總帳分類帳 (窗口 ID-132)
出自iDempiere zh
窗口: 總帳分類帳
描述: Enter and change Manual Journal Entries
幫助: The GL Journal Window allows you to enter and modify manual journal entries
TAB: 批
描述: 通用分類帳分類帳批次
幫助 The GL Journal Batch Tab defines the control parameters for a Journal Batch. A Batch can consist of multiple Journals.
File:總帳分類帳 - 批 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Journal Batch | 分類帳批次 | 通用分類帳分類帳批次 | The General Ledger Journal Batch identifies a group of journals to be processed as a group. | GL_JournalBatch_ID numeric(10) NOT NULL ID |
| 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 |
| Process Now | 現在處理 | null | null | Processing character(1) NOT NULL Button |
| Processed | 已處理 | The document has been processed | The Processed checkbox indicates that a document has been processed. | Processed character(1) NOT NULL Yes-No |
| 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 |
| Document No | 文檔號 | Document sequence number of the document | The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".
If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. 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). |
DocumentNo character varying(30) NOT NULL String |
| Description | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) NOT NULL String |
| PostingType | 過帳類型 | The type of amount that this journal updated | The Posting Type indicates the type of amount (Actual, Encumbrance, Budget) this journal updated. | PostingType character(1) NOT NULL List |
| Document Type | 文件類型 | 文件類型或規則 | The Document Type determines document sequence and processing rules | C_DocType_ID numeric(10) NOT NULL Table Direct |
| GL Category | 總帳分類 | 總帳分類 | The General Ledger Category is an optional, user defined method of grouping journal lines. | GL_Category_ID numeric(10) Table Direct |
| Document Date | 文件日期 | 文件的日期 | The Document Date indicates the date the document was generated. It may or may not be the same as the accounting date. | DateDoc timestamp without time zone Date |
| Account Date | 記賬日期 | 記賬日期 | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document | DateAcct timestamp without time zone Date |
| Period | 分期 | 日曆的分期 | The Period indicates an exclusive range of dates for a calendar. | C_Period_ID numeric(10) Table |
| Currency | 貨幣 | 幣種為該筆記錄 | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID numeric(10) Table Direct |
| Control Amount | 控制金額 | If not zero, the Debit amount of the document must be equal this amount | If the control amount is zero, no check is performed.
Otherwise the total Debit amount must be equal to the control amount, before the document is processed. |
ControlAmt numeric Amount |
| Approved | 已批准 | 指示該文檔是否需要批准 | The Approved checkbox indicates if this document requires approval before it can be processed. | IsApproved character(1) Yes-No |
| Total Debit | 總借方 | Total debit in document currency | The Total Debit indicates the total debit amount for a journal or journal batch in the source currency | TotalDr numeric NOT NULL Amount |
| Total Credit | 總貸方 | Total Credit in document currency | The Total Credit indicates the total credit amount for a journal or journal batch in the source currency | TotalCr numeric NOT NULL Amount |
| Document Status | 文檔狀態 | The current status of the document | The Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action field | DocStatus character(2) NOT NULL List |
| Process Batch | 處理批 | null | null | DocAction character(2) NOT NULL Button |
| Copy Details | 複製明細 | Copy Journal Lines from other Journal Batch | null | CopyFrom character(1) Button |
TAB: 分類帳
描述: 通用分類帳分類帳
幫助 The GL Journal Tab defines the control parameters for a single GL Journal.
File:總帳分類帳 - 分類帳 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Journal | 分類帳 | 通用分類帳分類帳 | The General Ledger Journal identifies a group of journal lines which represent a logical business transaction | GL_Journal_ID numeric(10) NOT NULL ID |
| Printed | 已打印 | Indicates if this document is printed | The Printed checkbox indicates if this document will be printed. | IsPrinted character(1) NOT NULL Yes-No |
| Processed | 已處理 | The document has been processed | The Processed checkbox indicates that a document has been processed. | Processed character(1) Yes-No |
| Process Now | Process Now | null | null | Processing character(1) Button |
| 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 |
| Accounting Schema | 會計模式 | 帳戶的規則 | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID numeric(10) NOT NULL Table Direct |
| Journal Batch | 分類帳批次 | 通用分類帳分類帳批次 | The General Ledger Journal Batch identifies a group of journals to be processed as a group. | GL_JournalBatch_ID numeric(10) Table Direct |
| Document No | 文檔號 | Document sequence number of the document | The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".
If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. 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). |
DocumentNo character varying(30) NOT NULL String |
| Description | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) NOT NULL 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 |
| PostingType | 過帳類型 | The type of amount that this journal updated | The Posting Type indicates the type of amount (Actual, Encumbrance, Budget) this journal updated. | PostingType character(1) NOT NULL List |
| Budget | 預算 | 通用分類帳預算 | The General Ledger Budget identifies a user defined budget. These can be used in reporting as a comparison against your actual amounts. | GL_Budget_ID numeric(10) Table Direct |
| Document Type | 文件類型 | 文件類型或規則 | The Document Type determines document sequence and processing rules | C_DocType_ID numeric(10) NOT NULL Table Direct |
| GL Category | 總帳分類 | 總帳分類 | The General Ledger Category is an optional, user defined method of grouping journal lines. | GL_Category_ID numeric(10) NOT NULL Table Direct |
| Document Date | 文件日期 | 文件的日期 | The Document Date indicates the date the document was generated. It may or may not be the same as the accounting date. | DateDoc timestamp without time zone NOT NULL Date |
| Account Date | 記賬日期 | 記賬日期 | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document | DateAcct timestamp without time zone NOT NULL Date |
| Period | 分期 | 日曆的分期 | The Period indicates an exclusive range of dates for a calendar. | C_Period_ID numeric(10) NOT NULL Table |
| Currency | 貨幣 | 幣種為該筆記錄 | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID numeric(10) Table Direct |
| Currency Type | Currency Type | Currency Conversion Rate Type | The Currency Conversion Rate Type lets you define different type of rates, e.g. Spot, Corporate and/or Sell/Buy rates. | C_ConversionType_ID numeric(10) NOT NULL Table Direct |
| Rate | 匯率 | 幣種匯率 | The Currency Conversion Rate indicates the rate to use when converting the source currency to the accounting currency | CurrencyRate numeric NOT NULL Number |
| Control Amount | 控制金額 | If not zero, the Debit amount of the document must be equal this amount | If the control amount is zero, no check is performed.
Otherwise the total Debit amount must be equal to the control amount, before the document is processed. |
ControlAmt numeric Amount |
| Approved | 已批准 | 指示該文檔是否需要批准 | The Approved checkbox indicates if this document requires approval before it can be processed. | IsApproved character(1) NOT NULL Yes-No |
| Total Debit | 總借方 | Total debit in document currency | The Total Debit indicates the total debit amount for a journal or journal batch in the source currency | TotalDr numeric NOT NULL Amount |
| Total Credit | 總貸方 | Total Credit in document currency | The Total Credit indicates the total credit amount for a journal or journal batch in the source currency | TotalCr numeric NOT NULL Amount |
| Document Status | 文檔狀態 | The current status of the document | The Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action field | DocStatus character(2) NOT NULL List |
| Process Journal | 分類帳處理 | null | null | DocAction character(2) NOT NULL Button |
| Posted | 已過帳 | 過帳狀態 | The Posted field indicates the status of the Generation of General Ledger Accounting Lines | Posted character(1) NOT NULL Button |
TAB: 明細
描述: 通用分類帳分類帳明細
幫助 The GL Journal Line Tab defines the individual debit and credit transactions that comprise a journal.
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 |
| Journal | 分類帳 | 通用分類帳分類帳 | The General Ledger Journal identifies a group of journal lines which represent a logical business transaction | GL_Journal_ID numeric(10) NOT NULL Table Direct |
| Line No | 明細號 | Unique line for this document | Indicates the unique line for a document. It will also control the display order of the lines within a document. | Line numeric(10) NOT NULL Integer |
| 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 |
| Generated | 生成的 | 這行被生成的 | The Generated checkbox identifies a journal line that was generated from a source document. Lines could also be entered manually or imported. | IsGenerated character(1) NOT NULL Yes-No |
| Currency | 貨幣 | 幣種為該筆記錄 | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID numeric(10) NOT NULL Table Direct |
| Account Date | 記賬日期 | 記賬日期 | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document | DateAcct timestamp without time zone NOT NULL Date |
| Currency Type | Currency Type | Currency Conversion Rate Type | The Currency Conversion Rate Type lets you define different type of rates, e.g. Spot, Corporate and/or Sell/Buy rates. | C_ConversionType_ID numeric(10) NOT NULL Table Direct |
| Account | 帳戶 | 已使用帳戶 | 帳戶用 | Account_ID numeric(10) Table |
| 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 |
| Trx Organization | 交易機構 | Performing or initiating organization | The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. | AD_OrgTrx_ID numeric(10) Table |
| Activity | 活動 | 業務活動 | Activities indicate tasks that are performed and used to utilize Activity based Costing | C_Activity_ID numeric(10) Table |
| 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 |
| Sales Region | 銷售區域 | 銷售報導區域 | The Sales Region indicates a specific area of sales coverage. | C_SalesRegion_ID numeric(10) Table |
| Project | 項目 | 財務項目 | Project ID is a user defined identifier for a Project | C_Project_ID numeric(10) Table |
| Sub Account | 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. | C_SubAcct_ID numeric(10) Table Direct |
| Product | 產品 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) Search |
| Location From | 來源位置 | Location that inventory was moved from | The Location From indicates the location that a product was moved from. | C_LocFrom_ID numeric(10) Search |
| Location To | 目標位置 | Location that inventory was moved to | The Location To indicates the location that a product was moved to. | C_LocTo_ID numeric(10) Search |
| User Element 1 | User Element 1 | User defined accounting Element | A user defined accounting element refers to a Adempiere table. This allows to use any table content as an accounting dimension (e.g. Project Task). Note that User Elements are optional and are populated from the context of the document (i.e. not requested) | UserElement1_ID numeric(10) ID |
| User Element 2 | User Element 2 | User defined accounting Element | A user defined accounting element refers to a Adempiere table. This allows to use any table content as an accounting dimension (e.g. Project Task). Note that User Elements are optional and are populated from the context of the document (i.e. not requested) | UserElement2_ID numeric(10) ID |
| User List 1 | User1 | 用戶定義元素 #1 | The user defined element displays the optional elements that have been defined for this account combination. | User1_ID numeric(10) Table |
| User List 2 | User2 | 用戶定義元素 #2 | The user defined element displays the optional elements that have been defined for this account combination. | User2_ID numeric(10) Table |
| Alias List | Alias List | Valid Account Alias List | The Combination identifies a valid combination of element which represent a GL account. | Alias_ValidCombination_ID numeric(10) Table |
| Rate | 匯率 | 幣種匯率 | The Currency Conversion Rate indicates the rate to use when converting the source currency to the accounting currency | CurrencyRate numeric NOT NULL Number |
| Combination | 組合 | 有效的帳戶組合 | The Combination identifies a valid combination of element which represent a GL account. | C_ValidCombination_ID numeric(10) Account |
| Asset Related? | Asset Related? | null | null | A_CreateAsset character(1) Yes-No |
| Asset | 資產 | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | A_Asset_ID numeric(10) Search |
| Asset Group | 資產分類 | 群體的資產 | The group of assets determines default accounts. If an asset group is selected in the product category, assets are created when delivering the asset. | A_Asset_Group_ID numeric(10) Table Direct |
| Source Debit | 借方來源 | 借方來源金額 | The Source Debit Amount indicates the credit amount for this line in the source currency. | AmtSourceDr numeric NOT NULL Amount |
| Source Credit | 貸方來源 | 貸方來源金額 | The Source Credit Amount indicates the credit amount for this line in the source currency. | AmtSourceCr numeric NOT NULL Amount |
| Accounted Debit | 帳戶借方 | 帳戶借方金額 | The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency | AmtAcctDr numeric NOT NULL Amount |
| Accounted Credit | 帳戶貸方 | 帳戶貸方金額 | The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency | AmtAcctCr numeric NOT NULL Amount |
| UOM | 度量單位 | 度量單位 | The UOM defines a unique non monetary Unit of Measure | C_UOM_ID numeric(10) Table Direct |
| Quantity | 數量 | 數量 | The Quantity indicates the number of a specific product or item for this document. | Qty numeric Amount |
.png){kind=link}
.png){kind=link}
.png){kind=link}