GL配分（GL Distribution）｜iDempiere 13 画面リファレンス
GL配分（GL Distribution）
Section titled “GL配分（GL Distribution）”iDempiere 13 標準ウィンドウ（AD_Window_ID: 323）
メニュー: 会計管理 ▸ 会計設定 ▸ GL配分
General Ledger Distribution
If the account combination criteria of the Distribution is met, the posting to the account combination is replaced by the account combinations of the distribution lines. The distribution is a one-step operation based on the percentage of the lines.
| # | タブ | テーブル | 階層 | 説明 |
|---|---|---|---|---|
| 10 | GL配分 | GL_Distribution | 0 | General Ledger Distribution |
| 20 | 詳細 | GL_DistributionLine | 1 | General Ledger Distribution Target Line |
GL配分 タブのフィールド
Section titled “GL配分 タブのフィールド”If the account combination criteria of the Distribution is met, the posting to the account combination is replaced by the account combinations of the distribution lines.
The distribution is prorated based on the percentage of the lines. If the total percent is less then 100 and one line is 0 (null), it gets the remainder. If there is no line with 0, any rounding is adjusted in the line with the biggest amount.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | Optional short description of the record | |
| コメント | Help | Text | Comment or Hint | |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| シーケンスNo | SeqNo | Integer | ✔ | Method of ordering records; lowest number comes first |
| 会計スキーマ | C_AcctSchema_ID | Table Direct | ✔ | Rules for accounting |
| Create Reversal | IsCreateReversal | Yes-No | ✔ | Indicates that reversal movement will be created, if disabled the original movement will be deleted. |
| 転記タイプ | PostingType | List | The type of posted amount for the transaction | |
| 伝票タイプ | C_DocType_ID | Table Direct | Document type or rules | |
| 有効開始日 | ValidFrom | Date | Valid from including this date (first day) | |
| 有効終了日 | ValidTo | Date | Valid to including this date (last day) | |
| 任意組織 | AnyOrg | Yes-No | ✔ | Match any value of the Organization segment |
| 組織 | Org_ID | Table | Organizational entity within tenant | |
| 任意勘定科目 | AnyAcct | Yes-No | ✔ | Match any value of the Account segment |
| 勘定科目 | Account_ID | Search | Account used | |
| 任意アクティビティ | AnyActivity | Yes-No | ✔ | Match any value of the Activity segment |
| アクティビティ | C_Activity_ID | Table Direct | Business Activity | |
| 任意製品 | AnyProduct | Yes-No | ✔ | Match any value of the Product segment |
| 品目 | M_Product_ID | Search | Product, Service, Item | |
| 任意取引先 | AnyBPartner | Yes-No | ✔ | Match any value of the Business Partner segment |
| 取引先 | C_BPartner_ID | Search | Identifies a Business Partner | |
| 任意プロジェクト | AnyProject | Yes-No | ✔ | Match any value of the Project segment |
| プロジェクト | C_Project_ID | Search | Financial Project | |
| 任意キャンペーン | AnyCampaign | Yes-No | ✔ | Match any value of the Campaign segment |
| 営業活動 | C_Campaign_ID | Table Direct | キャンペーン、営業活動 | |
| 任意ロケーション元 | AnyLocFrom | Yes-No | ✔ | Match any value of the Location From segment |
| 送り元 | C_LocFrom_ID | Table | Location that inventory was moved from | |
| 任意ロケーション先 | AnyLocTo | Yes-No | ✔ | Match any value of the Location To segment |
| 送り先 | C_LocTo_ID | Table | Location that inventory was moved to | |
| 任意販売地域 | AnySalesRegion | Yes-No | ✔ | Match any value of the Sales Region segment |
| 販売地域 | C_SalesRegion_ID | Table Direct | Sales coverage region | |
| 任意取引組織 | AnyOrgTrx | Yes-No | ✔ | Match any value of the Transaction Organization segment |
| 取引組織 | AD_OrgTrx_ID | Table | Performing or initiating organization | |
| 任意ユーザー1 | AnyUser1 | Yes-No | ✔ | Match any value of the User 1 segment |
| ユーザー1 | User1_ID | Search | User defined list element #1 | |
| 任意ユーザー2 | AnyUser2 | Yes-No | ✔ | Match any value of the User 2 segment |
| ユーザー2 | User2_ID | Search | User defined list element #2 | |
| Any Department | AnyDepartment | Yes-No | ✔ | Match any value of the Department segment |
| Department | C_Department_ID | Table Direct | ||
| Any Warehouse | AnyWarehouse | Yes-No | ✔ | Match any value of the Warehouse segment |
| Warehouse | M_Warehouse_ID | Table Direct | Storage Warehouse and Service Point | |
| Any Asset | AnyAsset | Yes-No | ✔ | Match any value of the Asset segment |
| Asset | A_Asset_ID | Search | Asset used internally or by customers | |
| Any Charge | AnyCharge | Yes-No | ✔ | Match any value of the Charge segment |
| Charge | C_Charge_ID | Table Direct | Additional document charges | |
| Any Employee | AnyEmployee | Yes-No | ✔ | Match any value of the Employee segment |
| Employee | C_Employee_ID | Search | Identifies a Business Partner | |
| Any Attribute Set Instance | AnyAttributeSetInstance | Yes-No | ✔ | Match any value of the Employee segment |
| Attribute Set Instance | M_AttributeSetInstance_ID | Table Direct | Product Attribute Set Instance | |
| Any Cost Center | AnyCostCenter | Yes-No | ✔ | Match any value of the Cost Center segment |
| Cost Center | C_CostCenter_ID | Table Direct | ||
| 総パーセント | PercentTotal | Number | ✔ | Sum of the Percent details |
| 有効 | IsValid | Yes-No | ✔ | Element is valid |
| 検査 | Processing | Button | Verify GL Distribution |
詳細 タブのフィールド
Section titled “詳細 タブのフィールド”If the account combination criteria of the Distribution is met, the posting to the account combination is replaced by the account combinations of the distribution lines. The distribution is prorated based on the perecent value of the lines. A Percent value of 0 (null) indicates the remainder to 100. There can only be one line with 0 percent.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| GL配分 | GL_Distribution_ID | Table Direct | ✔ | General Ledger Distribution |
| 明細番号 | Line | Integer | ✔ | Unique line for this document |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 説明 | Description | String | Optional short description of the record | |
| パーセント | Percent | Number | ✔ | Percentage |
| 組織上書き | OverwriteOrg | Yes-No | ✔ | Overwrite the account segment Organization with the value specified |
| 組織 | Org_ID | Table | Organizational entity within tenant | |
| 科目上書き | OverwriteAcct | Yes-No | ✔ | Overwrite the account segment Account with the value specified |
| 勘定科目 | Account_ID | Search | Account used | |
| アクティビティ上書き | OverwriteActivity | Yes-No | ✔ | Overwrite the account segment Activity with the value specified |
| アクティビティ | C_Activity_ID | Table Direct | Business Activity | |
| 品目上書き | OverwriteProduct | Yes-No | ✔ | Overwrite the account segment Product with the value specified |
| 品目 | M_Product_ID | Search | Product, Service, Item | |
| 取引先上書き | OverwriteBPartner | Yes-No | ✔ | Overwrite the account segment Business Partner with the value specified |
| 取引先 | C_BPartner_ID | Search | Identifies a Business Partner | |
| プロジェクト上書き | OverwriteProject | Yes-No | ✔ | Overwrite the account segment Project with the value specified |
| プロジェクト | C_Project_ID | Table Direct | Financial Project | |
| キャンペーン上書き | OverwriteCampaign | Yes-No | ✔ | Overwrite the account segment Campaign with the value specified |
| 営業活動 | C_Campaign_ID | Table Direct | キャンペーン、営業活動 | |
| ロケーション元上書き | OverwriteLocFrom | Yes-No | ✔ | Overwrite the account segment Location From with the value specified |
| 送り元 | C_LocFrom_ID | Table | Location that inventory was moved from | |
| ロケーション先上書き | OverwriteLocTo | Yes-No | ✔ | Overwrite the account segment Location From with the value specified |
| 送り先 | C_LocTo_ID | Table | Location that inventory was moved to | |
| 販売地域上書き | OverwriteSalesRegion | Yes-No | ✔ | Overwrite the account segment Sales Region with the value specified |
| 販売地域 | C_SalesRegion_ID | Table Direct | Sales coverage region | |
| 取引組織上書き | OverwriteOrgTrx | Yes-No | ✔ | Overwrite the account segment Transaction Organization with the value specified |
| 取引組織 | AD_OrgTrx_ID | Table | Performing or initiating organization | |
| ユーザー1上書き | OverwriteUser1 | Yes-No | ✔ | Overwrite the account segment User 1 with the value specified |
| ユーザー1 | User1_ID | Search | User defined list element #1 | |
| ユーザー2上書き | OverwriteUser2 | Yes-No | ✔ | Overwrite the account segment User 2 with the value specified |
| ユーザー2 | User2_ID | Search | User defined list element #2 | |
| Overwrite Cost Center | OverwriteCostCenter | Yes-No | ✔ | Overwrite the account segment Cost Center with the value specified |
| Cost Center | C_CostCenter_ID | Table Direct | ||
| Overwrite Department | OverwriteDepartment | Yes-No | ✔ | Overwrite the account segment Department with the value specified |
| Department | C_Department_ID | Table Direct | ||
| Overwrite Asset | OverwriteAsset | Yes-No | ✔ | Overwrite the account segment Asset with the value specified |
| Asset | A_Asset_ID | Search | Asset used internally or by customers | |
| Overwrite Attribute Set Instance | OverwriteAttributeSetInstance | Yes-No | ✔ | Overwrite the account segment Attribute Set Instance with the value specified |
| Attribute Set Instance | M_AttributeSetInstance_ID | Table Direct | Product Attribute Set Instance | |
| Overwrite Charge | OverwriteCharge | Yes-No | ✔ | Overwrite the account segment Charge with the value specified |
| Charge | C_Charge_ID | Table Direct | Additional document charges | |
| Overwrite Employee | OverwriteEmployee | Yes-No | ✔ | Overwrite the account segment Employee with the value specified |
| Employee | C_Employee_ID | Search | Identifies a Business Partner | |
| Overwrite Warehouse | OverwriteWarehouse | Yes-No | ✔ | Overwrite the account segment Warehouse with the value specified |
| Warehouse | M_Warehouse_ID | Table Direct | Storage Warehouse and Service Point |