会計実績残高(Accounting Fact Balances)|iDempiere 13 画面リファレンス
会計実績残高(Accounting Fact Balances)
Section titled “会計実績残高(Accounting Fact Balances)”iDempiere 13 標準ウィンドウ(AD_Window_ID: 255)
メニュー: 会計管理 ▸ 会計実績残高
Query Accounting Daily Balances
Query daily account balances
| # | タブ | テーブル | 階層 | 説明 |
|---|---|---|---|---|
| 10 | 会計実績残高 | Fact_Acct_Balance | 0 | View daily accounting balances |
会計実績残高 タブのフィールド
Section titled “会計実績残高 タブのフィールド”| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 会計スキーマ | C_AcctSchema_ID | Table Direct | ✔ | Rules for accounting |
| 転記日付 | DateAcct | Date | ✔ | Accounting Date |
| 転記タイプ | PostingType | List | ✔ | The type of posted amount for the transaction |
| 勘定科目 | Account_ID | Search | ✔ | Account used |
| サブアカウント | C_SubAcct_ID | Table Direct | Sub account for Element Value | |
| 取引先 | C_BPartner_ID | Search | Identifies a Business Partner | |
| 品目 | M_Product_ID | Search | Product, Service, Item | |
| プロジェクト | C_Project_ID | Table Direct | Financial Project | |
| 販売地域 | C_SalesRegion_ID | Table Direct | Sales coverage region | |
| 営業活動 | C_Campaign_ID | Table Direct | キャンペーン、営業活動 | |
| 取引組織 | AD_OrgTrx_ID | Table | Performing or initiating organization | |
| 送り元 | C_LocFrom_ID | Table | Location that inventory was moved from | |
| 送り先 | C_LocTo_ID | Table | Location that inventory was moved to | |
| アクティビティ | C_Activity_ID | Table Direct | Business Activity | |
| ユーザー1 | User1_ID | Search | User defined list element #1 | |
| ユーザー2 | User2_ID | Search | User defined list element #2 | |
| ユーザーエレメント1 | UserElement1_ID | ID | User defined accounting Element | |
| ユーザーエレメント2 | UserElement2_ID | ID | User defined accounting Element | |
| 予算 | GL_Budget_ID | Table Direct | General Ledger Budget | |
| 借方計上金額 | AmtAcctDr | Amount | ✔ | Accounted Debit Amount |
| 貸方計上金額 | AmtAcctCr | Amount | ✔ | Accounted Credit Amount |
| 数量 | Qty | Quantity | ✔ | Quantity |