導入總帳分類帳 (窗口 ID-278)
出自iDempiere zh
窗口: 導入總帳分類帳
描述: Import General Ledger Journals
幫助: null
TAB: 通用分類帳
描述: 導入指揮分類帳
幫助 null
File:導入總帳分類帳 - 通用分類帳 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Import GL Journal | 導入總帳分類帳 | Import General Ledger Journal | null | I_GLJournal_ID numeric(10) NOT NULL ID |
| Imported | 已導入 | Has this import been processed | The Imported check box indicates if this import has been processed. | I_IsImported character(1) NOT NULL Yes-No |
| Import Error Message | 導入錯誤信息 | Messages generated from import process | The Import Error Message displays any error messages generated during the import process. | I_ErrorMsg character varying(2000) String |
| Journal Batch | 分類帳批次 | 通用分類帳分類帳批次 | The General Ledger Journal Batch identifies a group of journals to be processed as a group. | GL_JournalBatch_ID numeric(10) Search |
| Client Key | 實體關鍵字 | 客戶的關鍵字 | null | ClientValue character varying(40) String |
| Client | 客戶 | 安裝此軟件的客戶 | 客戶是一個公司或者合法的實體。你不能在客戶之間共享數據。 | AD_Client_ID numeric(10) Table Direct |
| Document Org | Document Org | Document Organization (independent from account organization) | null | AD_OrgDoc_ID numeric(10) Table |
| Batch Document No | 批文件號 | 文檔批的數字 | null | BatchDocumentNo character varying(30) String |
| Create New Batch | Create New Batch | If selected a new batch is created | Note that the balance check does not check that individual batches are balanced. | IsCreateNewBatch character(1) Yes-No |
| Batch Description | 批描述 | 批的描述 | null | BatchDescription character varying(255) String |
| Journal | 分類帳 | 通用分類帳分類帳 | The General Ledger Journal identifies a group of journal lines which represent a logical business transaction | GL_Journal_ID numeric(10) Search |
| Journal Document No | Journal Document No | Document number of the Journal | null | JournalDocumentNo character varying(30) String |
| Create New Journal | Create New Journal | If selected a new journal within the batch is created | Note that the balance check does not check that individual journals are balanced. | IsCreateNewJournal character(1) Yes-No |
| Account Schema Name | 帳戶模式名 | 會計模式的名稱 | null | AcctSchemaName character varying(60) String |
| Accounting Schema | 會計模式 | 帳戶的規則 | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID numeric(10) Table Direct |
| 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) 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 Name | 文件類型名 | 文件類型名 | null | DocTypeName character varying(60) String |
| Document Type | 文件類型 | 文件類型或規則 | The Document Type determines document sequence and processing rules | C_DocType_ID numeric(10) Table Direct |
| Category Name | 分類名 | 分類名 | null | CategoryName character varying(60) String |
| GL Category | 總帳分類 | 總帳分類 | The General Ledger Category is an optional, user defined method of grouping journal lines. | GL_Category_ID numeric(10) 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 Date |
| Period | 分期 | 日曆的分期 | The Period indicates an exclusive range of dates for a calendar. | C_Period_ID numeric(10) Table Direct |
| Journal Line | 分類帳明細 | 通用分類帳分類帳明細 | The General Ledger Journal Line identifies a single transaction in a journal. | GL_JournalLine_ID numeric(10) Search |
| 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) Integer |
| Description | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) String |
| Source Debit | 借方來源 | 借方來源金額 | The Source Debit Amount indicates the credit amount for this line in the source currency. | AmtSourceDr numeric Amount |
| Source Credit | 貸方來源 | 貸方來源金額 | The Source Credit Amount indicates the credit amount for this line in the source currency. | AmtSourceCr numeric Amount |
| ISO Currency Code | ISO貨幣編碼 | 幣種的 ISO 4217 編碼 | For details - http: www.unece.org trade rec rec09en.htm | ISO_Code character(3) String |
| Currency | 貨幣 | 幣種為該筆記錄 | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID numeric(10) Table Direct |
| Currency Type Key | Currency Type Key | Key value for the Currency Conversion Rate Type | The date type key for the conversion of foreign currency transactions | ConversionTypeValue character varying(40) String |
| 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) Table Direct |
| Rate | 匯率 | 幣種匯率 | The Currency Conversion Rate indicates the rate to use when converting the source currency to the accounting currency | CurrencyRate numeric Number |
| Accounted Debit | 帳戶借方 | 帳戶借方金額 | The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency | AmtAcctDr numeric Amount |
| Accounted Credit | 帳戶貸方 | 帳戶貸方金額 | The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency | AmtAcctCr numeric 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 Quantity |
| Combination | 組合 | 有效的帳戶組合 | The Combination identifies a valid combination of element which represent a GL account. | C_ValidCombination_ID numeric(10) Search |
| Org Key | 機構 關鍵字 | 機構的關鍵字 | null | OrgValue character varying(40) String |
| 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) Table Direct |
| Account Key | 帳戶關鍵字 | 會計科目的關鍵字 | null | AccountValue character varying(40) String |
| Account | 帳戶 | 已使用帳戶 | 帳戶用 | Account_ID numeric(10) Table |
| Business Partner Key | 業務夥伴關鍵字 | 業務夥伴的關鍵字 | null | BPartnerValue character varying(40) String |
| 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 |
| Product Key | 產品關鍵字 | 產品的關鍵字 | null | ProductValue character varying(40) String |
| UPC/EAN | UPC/EAN條碼 | 條形碼 | Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI Plessey, and Pharmacode) | UPC character varying(30) String |
| SKU | SKU | 存貨保管單位 | The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema. | SKU character varying(30) String |
| Product | 產品 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) Search |
| Project Key | 項目關鍵字 | 項目的關鍵字 | null | ProjectValue character varying(40) String |
| Project | 項目 | 財務項目 | Project ID is a user defined identifier for a Project | C_Project_ID numeric(10) Search |
| 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 |
| Activity | 活動 | 業務活動 | Activities indicate tasks that are performed and used to utilize Activity based Costing | C_Activity_ID numeric(10) Table Direct |
| Sales Region | 銷售區域 | 銷售報導區域 | The Sales Region indicates a specific area of sales coverage. | C_SalesRegion_ID numeric(10) Table Direct |
| Trx Org Key | 交易機構關鍵字 | Key of the Transaction Organization | null | OrgTrxValue character varying(40) String |
| 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 |
| 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) Table |
| 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) Table |
| 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 |
| Import Journal | Import Journal | Import General Ledger Batch/Journal/Line | The Parameters are default values for null import record values, they do not overwrite any data. | Processing character(1) Button |
| Processed | 已處理 | The document has been processed | The Processed checkbox indicates that a document has been processed. | Processed character(1) Yes-No |
.png){kind=link}