Accounting Dimensions (Venster ID-283)

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!

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!

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!

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!

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!

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!

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!

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