Accounting Dimensions (Venster ID-283)

Uit iDempiere nl
Ga naar:navigatie, zoeken



Venster: Accounting Dimensions

Beschrijving: Maintain Non-Account Dimension Trees

Help: Maintain Trees of non account segment trees. Account segment trees (as well as user defined dimensions) are mainatained in the Account Element window. Please note that you will not be able to create new entities in this window if you have not default set for all manfatory values!



TAB: Organization Dimension

Beschrijving: Maintain Organizationt Accounting Dimension Tree


Help Please note that you will not be able to create new entities in this window if you have not default set for all mandatory values!


Bestand:Accounting Dimensions - Organization Dimension - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Search Key Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value
character varying(40) NOT NULL
String
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Summary Level Samenvatting Niveau This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. IsSummary
character(1) NOT NULL
Yes-No




TAB: Sales Region Dimension

Beschrijving: Maintain Sales Region Accounting Dimension Tree


Help Please note that you will not be able to create new entities in this window if you have not default set for all mandatory values!


Bestand:Accounting Dimensions - Sales Region Dimension - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Sales Region Sales Region Sales coverage region The Sales Region indicates a specific area of sales coverage. C_SalesRegion_ID
numeric(10) NOT NULL
ID
Sales Representative Sales Representative Sales Representative or Company Agent The Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user. SalesRep_ID
numeric(10)
Table
Default Standaard Default value The Default Checkbox indicates if this record will be used as a default value. IsDefault
character(1) NOT NULL
Yes-No
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Search Key Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value
character varying(40) NOT NULL
String
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Summary Level Samenvatting Niveau This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. IsSummary
character(1) NOT NULL
Yes-No




TAB: Acitivity Dimension

Beschrijving: Maintain Acitivity Accounting Dimension Tree


Help Please note that you will not be able to create new entities in this window if you have not default set for all mandatory values!


Bestand:Accounting Dimensions - Acitivity Dimension - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Activity Activity Business Activity Activities indicate tasks that are performed and used to utilize Activity based Costing C_Activity_ID
numeric(10) NOT NULL
ID
Comment/Help Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help
character varying(2000)
Text
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Search Key Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value
character varying(40) NOT NULL
String
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Summary Level Samenvatting Niveau This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. IsSummary
character(1) NOT NULL
Yes-No




TAB: Project Dimension

Beschrijving: Maintain Project Accounting Dimension Tree


Help Please note that you will not be able to create new entities in this window if you have not default set for all mandatory values!


Bestand:Accounting Dimensions - Project Dimension - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Project Project Financial Project A Project allows you to track and control internal or external activities. C_Project_ID
numeric(10) NOT NULL
ID
Currency Munteenheid The Currency for this record Indicates the Currency to be used when processing or reporting on this record C_Currency_ID
numeric(10) NOT NULL
Table Direct
Business Partner Relatie Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson C_BPartner_ID
numeric(10)
Search
Committed Amount Committed Amount The (legal) commitment amount The commitment amount is independent from the planned amount. You would use the planned amount for your realistic estimation, which might be higher or lower than the commitment amount. CommittedAmt
numeric NOT NULL
Amount
Generate Order Generate Order Generate Order from Project The Generate Order process will generate a new Order document based on the project phase. A price list and warehouse/service point must be defined on the project. GenerateTo
character(1)
Button
Finish Date Finish Date Finish or (planned) completion date The finish date is used to indicate when the project is expected to be completed or has been completed. DateFinish
timestamp without time zone
Date
Contract Date Contract Date The (planned) effective date of this document. The contract date is used to determine when the document becomes effective. This is usually the contract date. The contract date is used in reports and report parameters. DateContract
timestamp without time zone
Date
Commitment Commitment Is this document a (legal) commitment? Commitment indicates if the document is legally binding. IsCommitment
character(1) NOT NULL
Yes-No
Processed Processed The document has been processed The Processed checkbox indicates that a document has been processed. Processed
character(1) NOT NULL
Yes-No
Payment Term Payment Term The terms of Payment (timing, discount) Payment Terms identify the method and timing of payment. C_PaymentTerm_ID
numeric(10)
Table Direct
Campaign Campaign Marketing Campaign The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. C_Campaign_ID
numeric(10)
Table Direct
Order Reference Order Reference Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner The business partner order reference is the order reference for this specific transaction; Often Purchase Order numbers are given to print on Invoices for easier reference. A standard number can be defined in the Business Partner (Customer) window. POReference
character varying(20)
String
Planned Margin Planned Margin Project's planned margin amount The Planned Margin Amount indicates the anticipated margin amount for this project or project line. PlannedMarginAmt
numeric NOT NULL
Amount
Planned Quantity Planned Quantity Planned quantity for this project The Planned Quantity indicates the anticipated quantity for this project or project line PlannedQty
numeric NOT NULL
Quantity
Planned Amount Planned Amount Planned amount for this project The Planned Amount indicates the anticipated amount for this project or project line. PlannedAmt
numeric NOT NULL
Amount
Price List Version Price List Version Identifies a unique instance of a Price List Each Price List can have multiple versions. The most common use is to indicate the dates that a Price List is valid for. M_PriceList_Version_ID
numeric(10)
Table Direct
Sales Representative Sales Representative Sales Representative or Company Agent The Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user. SalesRep_ID
numeric(10)
Table
Note Note Optional additional user defined information The Note field allows for optional entry of user defined information regarding this record Note
character varying(2000)
Text
Close Project Close Project null null Processing
character(1)
Button
Project Category Project Category Project Category The Project Category determines the behavior of the project:

General - no special accounting, e.g. for Presales or general tracking Service - no special accounting, e.g. for Service/Charge projects Work Order - creates Project/Job WIP transactions - ability to issue material Asset - create Project Asset transactions - ability to issue material

ProjectCategory
character(1)
List
Warehouse Warehouse Storage Warehouse and Service Point The Warehouse identifies a unique Warehouse where products are stored or Services are provided. M_Warehouse_ID
numeric(10)
Table Direct
Commitment is Ceiling Commitment is Ceiling The commitment amount/quantity is the chargeable ceiling The commitment amount and quantity is the maximum amount and quantity to be charged. Ignored, if the amount or quantity is zero. IsCommitCeiling
character(1) NOT NULL
Yes-No
Committed Quantity Committed Quantity The (legal) commitment Quantity The commitment amount is independent from the planned amount. You would use the planned amount for your realistic estimation, which might be higher or lower than the commitment amount. CommittedQty
numeric NOT NULL
Quantity
Project Balance Project Balance Total Project Balance The project balance is the sum of all invoices and payments ProjectBalanceAmt
numeric NOT NULL
Amount
Quantity Invoiced Quantity Invoiced The quantity invoiced null InvoicedQty
numeric NOT NULL
Quantity
Standard Phase Standard Phase Standard Phase of the Project Type Phase of the project with standard performance information with standard work C_Phase_ID
numeric(10)
Table Direct
Copy Details Copy Details Copy Lines/Phases/Tasks from other Project null CopyFrom
character(1)
Button
Invoiced Amount Invoiced Amount The amount invoiced The amount invoiced InvoicedAmt
numeric NOT NULL
Amount
Partner Location Relatie Locatie Identifies the (ship to) address for this Business Partner The Partner address indicates the location of a Business Partner C_BPartner_Location_ID
numeric(10)
Table Direct
User/Contact User/Contact User within the system - Internal or Business Partner Contact The User identifies a unique user in the system. This could be an internal user or a business partner contact AD_User_ID
numeric(10)
Table Direct
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Search Key Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value
character varying(40) NOT NULL
String
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
Text
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Summary Level Samenvatting Niveau This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. IsSummary
character(1) NOT NULL
Yes-No
Set Project Type Set Project Type Set Project Type and for Service Projects copy Phases and Tasks of Project Type into Project C_ProjectType_ID
numeric(10)
Button




TAB: Business Partner Dimension

Beschrijving: Maintain Business Partner Accounting Dimension Tree


Help Please note that you will not be able to create new entities in this window if you have not default set for all mandatory values!


Bestand:Accounting Dimensions - Business Partner Dimension - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Search Key Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value
character varying(40) NOT NULL
String
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Summary Level Samenvatting Niveau This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. IsSummary
character(1) NOT NULL
Yes-No
Business Partner Group Relatie Groep Relatie Groep The Business Partner Group provides a method of defining defaults to be used for individual Business Partners. C_BP_Group_ID
numeric(10) NOT NULL
Table Direct
Open Balance Open Balance Total Open Balance Amount in primary Accounting Currency The Total Open Balance Amount is the calculated open item amount for Customer and Vendor activity. If the Balance is below zero, we owe the Business Partner. The amount is used for Credit Management.

Invoices and Payment Allocations determine the Open Balance (i.e. not Orders or Payments).

TotalOpenBalance
numeric
Amount




TAB: Product Dimension

Beschrijving: Maintain Product Accounting Dimension Tree


Help Please note that you will not be able to create new entities in this window if you have not default set for all mandatory values!


Bestand:Accounting Dimensions - Product Dimension - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Search Key Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value
character varying(40) NOT NULL
String
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(255) NOT NULL
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Summary Level Samenvatting Niveau This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. IsSummary
character(1) NOT NULL
Yes-No
Product Category Product Category Category of a Product Identifies the category which this product belongs to. Product categories are used for pricing and selection. M_Product_Category_ID
numeric(10) NOT NULL
Table Direct




TAB: Campaign Dimension

Beschrijving: Maintain Marketing Campaign Accounting Dimension Tree


Help Please note that you will not be able to create new entities in this window if you have not default set for all mandatory values!


Bestand:Accounting Dimensions - Campaign Dimension - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Campaign Campaign Marketing Campaign The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. C_Campaign_ID
numeric(10) NOT NULL
ID
Start Date Start Date First effective day (inclusive) The Start Date indicates the first or starting date StartDate
timestamp without time zone
Date
End Date End Date Last effective date (inclusive) The End Date indicates the last date in this range. EndDate
timestamp without time zone
Date
Costs Kosten (Costs) Costs in accounting currency The Costs indicates the cost of a campaign in an Organizations accounting currency. Costs
numeric NOT NULL
Costs+Prices
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Search Key Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value
character varying(40) NOT NULL
String
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
String
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1) NOT NULL
Yes-No
Summary Level Samenvatting Niveau This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. IsSummary
character(1) NOT NULL
Yes-No
Channel Channel Sales Channel The Sales Channel identifies a channel (or method) of sales generation. C_Channel_ID
numeric(10)
Table Direct


Contributions / Posts

Cookies helpen ons onze services aan te bieden. Door onze services te gebruiken stemt u in met het gebruik van onze cookies.