Skip to content

会計実績(Accounting Fact Details)|iDempiere 13 画面リファレンス

This content is not available in your language yet.

iDempiere 13 標準ウィンドウ(AD_Window_ID: 162)

メニュー: 会計管理 ▸ 会計実績

Query Accounting Facts

Query the detail accounting transactions

#タブテーブル階層説明
10会計実績Fact_Acct0View Accounting Fact Details
フィールドカラム必須説明
クライアントAD_Client_IDTable DirectTenant for this installation.
組織AD_Org_IDTable DirectOrganizational entity within tenant
会計スキーマC_AcctSchema_IDTable DirectRules for accounting
テーブルAD_Table_IDTable DirectDatabase Table information
レコードIDRecord_IDRecord IDDirect internal record ID
説明DescriptionStringOptional short description of the record
期間C_Period_IDTable DirectPeriod of the Calendar
転記日付DateAcctDateAccounting Date
転記タイプPostingTypeListThe type of posted amount for the transaction
取引日付DateTrxDateTransaction Date
勘定科目Account_IDSearchAccount used
サブアカウントC_SubAcct_IDTable DirectSub account for Element Value
取引先C_BPartner_IDSearchIdentifies a Business Partner
品目M_Product_IDSearchProduct, Service, Item
プロジェクトC_Project_IDTable DirectFinancial Project
販売地域C_SalesRegion_IDTable DirectSales coverage region
営業活動C_Campaign_IDTable Directキャンペーン、営業活動
取引組織AD_OrgTrx_IDTablePerforming or initiating organization
送り元C_LocFrom_IDTableLocation that inventory was moved from
送り先C_LocTo_IDTableLocation that inventory was moved to
アクティビティC_Activity_IDTable DirectBusiness Activity
ユーザー1User1_IDSearchUser defined list element #1
ユーザー2User2_IDSearchUser defined list element #2
ユーザーエレメント1UserElement1_IDIDUser defined accounting Element
ユーザーエレメント2UserElement2_IDIDUser defined accounting Element
GLカテゴリGL_Category_IDTable DirectGeneral Ledger Category
予算GL_Budget_IDTable DirectGeneral Ledger Budget
Attribute Set InstanceM_AttributeSetInstance_IDTable DirectProduct Attribute Set Instance
税率C_Tax_IDTable DirectTax identifier
保管場所M_Locator_IDTable DirectWarehouse Locator
通貨C_Currency_IDTable DirectThe Currency for this record
ソース借方AmtSourceDrAmountSource Debit Amount
ソース貸方AmtSourceCrAmountSource Credit Amount
借方計上金額AmtAcctDrAmountAccounted Debit Amount
貸方計上金額AmtAcctCrAmountAccounted Credit Amount
数量単位C_UOM_IDTable DirectUnit of Measure
数量QtyQuantityQuantity
Project PhaseC_ProjectPhase_IDTable DirectPhase of a Project
Project TaskC_ProjectTask_IDTable DirectActual Project Task in a Phase
Text Column 1CustomFieldText1TextUser defined accounting Element
Text Column 2CustomFieldText2TextUser defined accounting Element
Text Column 3CustomFieldText3TextUser defined accounting Element
Text Column 4CustomFieldText4TextUser defined accounting Element
ChargeC_Charge_IDTable DirectAdditional document charges
EmployeeC_Employee_IDSearchIdentifies a Business Partner
WarehouseM_Warehouse_IDTable DirectStorage Warehouse and Service Point
DepartmentC_Department_IDTable Direct
Cost CenterC_CostCenter_IDTable Direct