會計分錄查詢 (窗口 ID-162)
出自iDempiere zh
窗口: 會計分錄查詢
描述: 查詢會計分錄
幫助: Query the detail accounting transactions
TAB: 會計
描述: null
幫助 null
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 |
| 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 |
| Table | 表 | 欄位所在表 | The Table indicates the table in which a field or fields reside. | AD_Table_ID numeric(10) NOT NULL Table Direct |
| Record ID | 記錄ID | 記錄的內部ID | The Record ID is the internal unique identifier of a record | Record_ID numeric(10) NOT NULL Button |
| Description | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) String |
| Period | 分期 | 日曆的分期 | The Period indicates an exclusive range of dates for a calendar. | C_Period_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 NOT NULL Date |
| 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 |
| Transaction Date | 交易日期 | 交易日期 | The Transaction Date indicates the date of the transaction. | DateTrx timestamp without time zone NOT NULL Date |
| Account | 帳戶 | 已使用帳戶 | 帳戶用 | Account_ID numeric(10) NOT NULL 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 |
| 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 | 產品 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) Search |
| Project | 項目 | 財務項目 | Project ID is a user defined identifier for a Project | C_Project_ID numeric(10) Table Direct |
| Sales Region | 銷售區域 | 銷售報導區域 | The Sales Region indicates a specific area of sales coverage. | C_SalesRegion_ID numeric(10) Table Direct |
| 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 |
| 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 |
| Activity | 活動 | 業務活動 | Activities indicate tasks that are performed and used to utilize Activity based Costing | C_Activity_ID numeric(10) Table Direct |
| 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 |
| 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 |
| GL Category | 總帳分類 | 總帳分類 | The General Ledger Category is an optional, user defined method of grouping journal lines. | GL_Category_ID numeric(10) Table Direct |
| 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 |
| Tax | 稅 | 稅標識符 | The Tax indicates the type of tax for this document line. | C_Tax_ID numeric(10) Table Direct |
| Locator | 貨位 | 倉庫貨位 | The Locator ID indicates where in a Warehouse a product is located. | M_Locator_ID numeric(10) Table Direct |
| Currency | 貨幣 | 幣種為該筆記錄 | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID numeric(10) NOT NULL 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 Quantity |
