Distribution Code
Overview
The Distribution Code subject area is used to define and manage accounting distribution rules in a system. A distribution code specifies how financial transactions are allocated to general ledger accounts, ensuring consistent and accurate posting across business processes.
Each distribution code contains information such as debit and credit accounts, accounting segments, percentages, and distribution types. These codes are applied to transactions like payments, adjustments, refunds, or billing, determining how amounts are split and recorded in the ledger.
Conforming Layers
The only conforming layer of this subject area is DISTR_CODE_OBJ.
DISTR_CODE_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| SRC_DST_ID | Unique identifier for the distribution code, which defines how financial transactions are allocated across different general ledger (GL) accounts or cost centers. | VARCHAR | 10 |
| GL_CONST_ALG_CD | General Ledger (GL) allocation algorithm used to determine how transactions should be distributed across various accounts. This allows for automated and rule-based financial allocations. | VARCHAR | 12 |
| CIS_DIVISION | Division within the Customer Information System (CIS) that is accountable for this transaction. | VARCHAR | 5 |
| DFLT_SA_TYPE_CD | Service Agreement (SA) Type associated with the distribution code. This defines the type of customer account (e.g., utility, subscription, or loan agreement) for which this distribution rule applies. | VARCHAR | 8 |
| DST_DESCR | Description of the distribution code. | VARCHAR | 60 |
| GL_ACCT | General Ledger (GL) account to which transactions using this distribution code will be posted. | VARCHAR | 254 |
| CDC_LOAD_DTTM | Timestamp when the record was loaded into the data warehouse. | TIMESTAMP | |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP | |
| COMPOSITE_KEY | Unique identifier in the SRC_DST_ID format. This is the primary key. |
VARCHAR | 10 | CDC_FLAG | Flag specifying the type of data change captured in the record during the Change Data Capture (CDC) process. | VARCHAR | 1 |
| CDF1_CD CDF2_CD CDF3_CD CDF4_CD CDF5_CD CDF6_CD CDF7_CD CDF8_CD CDF9_CD CDF10_CD CDF11_CD CDF12_CD CDF13_CD CDF14_CD CDF15_CD |
Placeholders for future implementation of ORMB characteristics. | VARCHAR | 254 |
| CDF1_VAL CDF2_VAL CDF3_VAL CDF4_VAL CDF5_VAL CDF6_VAL CDF7_VAL CDF8_VAL CDF9_VAL CDF10_VAL CDF11_VAL CDF12_VAL CDF13_VAL CDF14_VAL CDF15_VAL |
Placeholders for values of future implementation of ORMB characteristics. | VARCHAR | 254 |