Accounting Dimensions (jendela ID-283)
jendela: Accounting Dimensions
deskripsi: Maintain Non-Account Dimension Trees
membantu: 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
deskripsi: Maintain Organizationt Accounting Dimension Tree
membantu 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!
Berkas:Accounting Dimensions - Organization Dimension - jendela (iDempiere 1.0.0).png
nama | nama | deskripsi | membantu | spesifikasi |
---|---|---|---|---|
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 | Penjelasan | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
Active | Active | 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 | Summary Level | 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
deskripsi: Maintain Sales Region Accounting Dimension Tree
membantu 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!
Berkas:Accounting Dimensions - Sales Region Dimension - jendela (iDempiere 1.0.0).png
nama | nama | deskripsi | membantu | spesifikasi |
---|---|---|---|---|
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 | Default | 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 | Penjelasan | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
Active | Active | 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 | Summary Level | 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: Dimensi Aktivitas
deskripsi: Maintain Acitivity Accounting Dimension Tree
membantu 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!
Berkas:Accounting Dimensions - Dimensi Aktivitas - jendela (iDempiere 1.0.0).png
nama | nama | deskripsi | membantu | spesifikasi |
---|---|---|---|---|
Activity | Activity | Aktifitas Bisnis | 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 | Penjelasan | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
Active | Active | 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 | Summary Level | 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
deskripsi: Maintain Project Accounting Dimension Tree
membantu 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!
Berkas:Accounting Dimensions - Project Dimension - jendela (iDempiere 1.0.0).png
nama | nama | deskripsi | membantu | spesifikasi |
---|---|---|---|---|
Project | Proyek | Financial Project | A Project allows you to track and control internal or external activities. | C_Project_ID numeric(10) NOT NULL ID |
Currency | Mata Uang | 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 | Partner Bisnis | 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 | Buat 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 for Payment of this transaction | Payment Terms identify the method and timing of payment for this transaction. | 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 | Versi Daftar Harga | 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 | Invoiced Quantity | 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 | Jumlah Yang Telah Di-Invoice | The amount invoiced | The amount invoiced | InvoicedAmt numeric NOT NULL Amount |
Partner Location | Lokasi Partner | 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 | Penjelasan | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) Text |
Active | Active | 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 | Summary Level | 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
deskripsi: Maintain Business Partner Accounting Dimension Tree
membantu 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!
Berkas:Accounting Dimensions - Business Partner Dimension - jendela (iDempiere 1.0.0).png
nama | nama | deskripsi | membantu | spesifikasi |
---|---|---|---|---|
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 | Penjelasan | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
Active | Active | 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 | Summary Level | 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 | Kelompok Partner Bisnis | Business Partner Group | 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 | Saldo Mula-Mula | 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 amout is used for Credit Management.
Invoices and Payment Allocations determine the Open Balance (i.e. not Orders or Payments). |
TotalOpenBalance numeric Amount |
TAB: Dimensi Produk
deskripsi: Maintain Product Accounting Dimension Tree
membantu 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!
Berkas:Accounting Dimensions - Dimensi Produk - jendela (iDempiere 1.0.0).png
nama | nama | deskripsi | membantu | spesifikasi |
---|---|---|---|---|
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 | Penjelasan | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
Active | Active | 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 | Summary Level | 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 | Kategori Produk | 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
deskripsi: Maintain Marketing Campaign Accounting Dimension Tree
membantu 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!
Berkas:Accounting Dimensions - Campaign Dimension - jendela (iDempiere 1.0.0).png
nama | nama | deskripsi | membantu | spesifikasi |
---|---|---|---|---|
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 of a range. | 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 | 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 | Penjelasan | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
Active | Active | 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 | Summary Level | 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 |