會計科目 (窗口 ID-118)
窗口: 會計科目
描述: 維護會計科目
幫助: The Account Element Window is used to define and maintain the Accounting Element and User Defined Elements. One of the account segments is your natural account segment (Chart of Account). You may add a new account element for parallel reporting or for user defined accounting segments.
TAB: 科目類型
描述: 會計科目定義
幫助 The Element Tab defines the Name, Description and Format for an Element. Additionally, a Type of Account or User Defined is selected. Each Account Schema must have an Account Element type. The User Defined Elements are optional.
File:會計科目 - 科目類型 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Element | 會計科目 | 會計科目 | The Account Element uniquely identifies an Account Type. These are commonly known as a Chart of Accounts. | C_Element_ID numeric(10) NOT NULL ID |
| Client | 客戶 | 安裝此軟件的客戶 | 客戶是一個公司或者合法的實體。你不能在客戶之間共享數據。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 機構 | 客戶內的機構實體。 | 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 |
| 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 | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) String |
| Active | 有效 | 本記錄有效 | 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 |
| Value Format | 值格式 | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | 驗證元素:(空格)任何的個性
_ Space (fixed character) l any Letter a..Z NO space L any Letter a..Z NO space converted to upper case o any Letter a..Z or space O any Letter a..Z or space converted to upper case a any Letters &數字無空格 A any Letters & Digits NO space converted to upper case c any Letters &數字或空間 C any Letters & Digits or space converted to upper case 0 Digits 0..9 NO space 9 Digits 0..9 or space Example of format "(000)_000-0000" |
VFormat character varying(40) String |
| Type | 類型 | Element Type (account or user defined) | 元素類型標明此元素是財務元素還是自定義元素。 | ElementType character(1) NOT NULL List |
| Natural Account | 普通帳戶 | 主要的普通帳戶 | The natural account is often based on (industry specific) chart of accounts | IsNaturalAccount character(1) NOT NULL Yes-No |
| Balancing | 待平衡 | All transactions within an element value must balance (e.g. cost centers) | The Balancing checkbox indicates the this element must balance in each journal transaction. For example, if cost centers have been defined as an element which is balance then the debits and credits for each unique cost center must net to 0.00. This is commonly used to define parts of an organization which report as their own entity. Balancing is not an option for the Account element. | IsBalancing character(1) NOT NULL Yes-No |
| Tree | 樹 | 標識樹 | The Tree field identifies a unique Tree in the system. Trees define roll ups or summary levels of information. They are used in reports for defining report points and summarization levels. | AD_Tree_ID numeric(10) Table Direct |
TAB: 元素值
描述: 定義元素值
幫助 The Element Value Tab defines the individual valid values for the Element. The values must conform to the format defined. If the Element is an Account Type then the Account Classification (Asset, Liability etc) and posting controls are also defined
File:會計科目 - 元素值 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Account Element | 會計科目 | 會計科目 | Account Elements can be natural accounts or user defined values. | C_ElementValue_ID numeric(10) NOT NULL ID |
| Client | 客戶 | 安裝此軟件的客戶 | 客戶是一個公司或者合法的實體。你不能在客戶之間共享數據。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 機構 | 客戶內的機構實體。 | 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 |
| Element | 會計科目 | 會計科目 | The Account Element uniquely identifies an Account Type. These are commonly known as a Chart of Accounts. | C_Element_ID numeric(10) NOT NULL Table Direct |
| Search Key | 檢索關鍵字 | 記錄的檢索關鍵字在格式上是必須的 -並且必須唯一 | 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 | 名稱 | 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 | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) String |
| Active | 有效 | 本記錄有效 | 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 | 匯總級別 | 這是父類實體 | 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 |
| Account Type | 帳戶類型 | 指示帳戶的類型 | Valid account types are A - Asset, E - Expense, L - Liability, O- Owner's Equity, R -Revenue and M- Memo. The account type is used to determine what taxes, if any are applicable, validating payables and receivables for business partners. Note: Memo account amounts are ignored when checking for balancing | AccountType character(1) NOT NULL List |
| Post Actual | 過帳實際值 | 可過帳實際值 | The Post Actual indicates if actual values can be posted to this element value. | PostActual character(1) NOT NULL Yes-No |
| Account Sign | 財務符號 | Indicates the Natural Sign of the Account as a Debit or Credit | Indicates if the expected balance for this account should be a Debit or a Credit. | AccountSign character(1) NOT NULL List |
| Post Budget | 過帳預算 | 預算值可被過帳 | The Post Budget indicates if budget values can be posted to this element value. | PostBudget character(1) NOT NULL Yes-No |
| Document Controlled | 文檔受控 | Control account - If an account is controlled by a document, you cannot post manually to it | null | IsDocControlled character(1) Yes-No |
| Post Statistical | 過帳統計數量 | Post statistical quantities to this account? | null | PostStatistical character(1) NOT NULL Yes-No |
| Valid from | 開始有效 | Valid from including this date (first day) | The Valid From date indicates the first day of a date range | ValidFrom timestamp without time zone Date |
| Post Encumbrance | 過帳債權 | Post commitments to this account | null | PostEncumbrance character(1) NOT NULL Yes-No |
| Valid to | 結束有效 | Valid to including this date (last day) | The Valid To date indicates the last day of a date range | ValidTo timestamp without time zone Date |
| Bank Account | 銀行帳戶 | Indicates if this is the Bank Account | The Bank Account checkbox indicates if this is account is the bank account. | IsBankAccount character(1) Yes-No |
| Bank Account | 銀行帳戶 | 在銀行的帳戶 | The Bank Account identifies an account at this Bank. | C_BankAccount_ID numeric(10) Table Direct |
| Foreign Currency Account | Foreign Currency Account | Balances in foreign currency accounts are held in the nominated currency | Balances in foreign currency accounts are held in the nominated currency and translated to functional currency | IsForeignCurrency character(1) Yes-No |
| Currency | 貨幣 | 幣種為該筆記錄 | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID numeric(10) Table Direct |
TAB: 翻譯
描述: 定義翻譯
幫助 The Translation Tab defines the translation to an alternate language
File:會計科目 - 翻譯 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Client | 客戶 | 安裝此軟件的客戶 | 客戶是一個公司或者合法的實體。你不能在客戶之間共享數據。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 機構 | 客戶內的機構實體。 | 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 |
| Account Element | 會計科目 | 會計科目 | Account Elements can be natural accounts or user defined values. | C_ElementValue_ID numeric(10) NOT NULL Table Direct |
| Language | 語言 | 本客戶使用的語言 | The Language identifies the language to use for display | AD_Language character varying(6) NOT NULL Table |
| Active | 有效 | 本記錄有效 | 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 |
| 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 | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) String |
| Translated | 已翻譯 | 列被翻譯 | The Translated checkbox indicates if this column is translated. | IsTranslated character(1) NOT NULL Yes-No |
TAB: Sub Account
描述: Sub Account for Element Value
幫助 The Element Value (e.g. Account) may have optional sub accounts for further detail. The sub account is dependent on the value of the account, so a further specification. If the sub-accounts are more or less the same, consider using another accounting dimension.
File:會計科目 - Sub Account - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Client | 客戶 | 安裝此軟件的客戶 | 客戶是一個公司或者合法的實體。你不能在客戶之間共享數據。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 機構 | 客戶內的機構實體。 | 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 |
| Account Element | 會計科目 | 會計科目 | Account Elements can be natural accounts or user defined values. | C_ElementValue_ID numeric(10) NOT NULL Table Direct |
| Search Key | 檢索關鍵字 | 記錄的檢索關鍵字在格式上是必須的 -並且必須唯一 | 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 | 名稱 | 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 | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) String |
| Comment/Help | 注釋/幫助 | 注釋或提示 | The Help field contains a hint, comment or help about the use of this item. | Help character varying(2000) Text |
| Active | 有效 | 本記錄有效 | 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 |
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}