Transaction Distribution
The Transaction Distribution file contains all distribution records associated with a Cash Ledger transaction.
REFERENCED BY
CB221 | CB245 | CB246 | CB255 | CB99.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CBD-CASH-CODE Element: Cash Code | Alpha 4 The cash code. Represents a bank account. Must be a valid record in the Cash Code file. |
|||||||||||||||||||||||||||||||
CBD-BANK-INST-CODE Element: Transaction Code | Alpha 3 The transaction code. Represents a type of cash payment, bill of exchange payment, or bank service transaction. Must be a valid record in the Bank Transaction Code file. |
|||||||||||||||||||||||||||||||
CBD-TRANS-IDENT Element: Transaction ID | Numeric 10 A unique system-generated identification value assigned to the transaction to make this record unique. |
|||||||||||||||||||||||||||||||
CBD-TRANS-NBR Element: Transaction Number | Alpha 10 (Right Justified) The unique number used to identify the transaction. Must be a valid record in the Bank Transaction file. |
|||||||||||||||||||||||||||||||
CBD-SUFFIX Element: Transaction Suffix | Numeric 3 The transaction suffix number. Represents the occurrence value of the transaction. |
|
||||||||||||||||||||||||||||||
CBD-SOURCE-CODE Element: Source Code | Alpha 2 Identifies where the bank transaction was created. Must be a valid source code. |
|||||||||||||||||||||||||||||||
CBD-COMPANY Element: Company | Numeric 4 The company number that initiated or created the transaction. Must be a valid record in the General Ledger Company file. |
|||||||||||||||||||||||||||||||
CBD-SEQ-NBR Element: Seq Nbr | Numeric 4 Contains a system-assigned sequence number. |
|||||||||||||||||||||||||||||||
CBD-DIST-COMPANY Element: Company | Numeric 4 The company number the bank transaction is to be posted to. Must be a valid record in the General Ledger Company file. |
|||||||||||||||||||||||||||||||
CBD-DIST-TYPE Element: Dist Type | Alpha 1 The distribution type. Valid values are: E = Entry. R = Reconciliation. V = Cash Ledger Void Update |
|||||||||||||||||||||||||||||||
CBD-RECORD-TYPE Element: Record Type | Alpha 1 Identifies the type of distribution record. Valid values are: C = Cash Account Distribution. E = EFT Payment distribution. P = CB Payment distribution. O = Offset CB payment distribution Blank = Not a cash account distribution. |
|||||||||||||||||||||||||||||||
CBD-REC-STATUS Element: Rec Status | Numeric 1 The status of the transaction distribution. Valid values are: 0 = Unreleased. 1 = Released. 9 = Posted. |
|||||||||||||||||||||||||||||||
CBD-POST-DATE Element: Post Date | Numeric 8 (yyyymmdd) The date for using to post the transaction to the general ledger. |
|||||||||||||||||||||||||||||||
CBD-DIS-ACCT-UNIT Element: Acct Unit | Alpha 15 The general ledger distribution accounting unit. Must be a valid record in the General Ledger Names file. |
|||||||||||||||||||||||||||||||
CBD-DIS-ACCOUNT Element: Account | Numeric 6 The general ledger distribution account number. Must be a valid record in the General Ledger Account Master file. |
|||||||||||||||||||||||||||||||
CBD-DIS-SUB-ACCT Element: Sub Acct | Numeric 4 The general ledger distribution subaccount number. Must be a valid record in the General Ledger Account Master file. |
|||||||||||||||||||||||||||||||
CBD-ACT-CNV-RATE Element: Exchange Rate | Signed 14.7 The currency exchange rate used to convert the bank account currency distribution amount to the company base currency. |
|||||||||||||||||||||||||||||||
CBD-BANK-DIST-AMT Acct Currency Distribution Amt | Signed 18.2 The distribution amount in the currency of the bank account. |
|||||||||||||||||||||||||||||||
CBD-ORIG-BASE-AMT Base Currency Distribution Amt | Signed 18.2 The distribution amount in the base currency of the originating company. |
|||||||||||||||||||||||||||||||
CBD-DIST-BASE-AMT To Company Distribution Amount | Signed 18.2 The distribution amount in the base currency of the distribution company. |
|||||||||||||||||||||||||||||||
CBD-TO-BNK-DST-AMT To Acct Curr Distribution Amt | Signed 18.2 The distribution amount in the currency of the to bank account. |
|||||||||||||||||||||||||||||||
CBD-REFERENCE Element: Reference | Alpha 10 (Lower Case) The reference value assigned to the transaction distribution. Used for informational purposes. |
|||||||||||||||||||||||||||||||
CBD-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The description of the transaction distribution. |
|||||||||||||||||||||||||||||||
CBD-ACTIVITY Element: Activity | Alpha 15 The activity assigned to the bank transaction distribution. Must be a valid record in the Activity Header file. Activities are the tasks that make up an activity group. Activities identify work being done, such as work orders, phases, products, and so on. A variety of costs, revenues, or both make up an activity. |
|||||||||||||||||||||||||||||||
CBD-TAX-CODE Element: Tax Code | Alpha 10 The tax code to be applied to the bank transaction distribution. Must be a valid record in the Tax Code file. |
|
||||||||||||||||||||||||||||||
CBD-TRAN-TAXABLE Element: Intl Amt | Signed 18.2 The taxable amount of the bank transaction distribution in the currency of the bank account. |
|
||||||||||||||||||||||||||||||
CBD-TAX-TYPE Element: Tax Type | Alpha 1 If a Tax Code is present, this field indicates the type of tax. Valid values are: I = Invoiced. The tax amount is included in the transaction amount. |
|
||||||||||||||||||||||||||||||
CBD-TO-BASE-ND Element: Acct Nd | Numeric 1 The number of decimal places defined for the base currency of the distribution company. |
|||||||||||||||||||||||||||||||
CBD-TO-TRAN-ND To Transaction Nbr of Decimals | Numeric 1 The number of decimal places defined for the currency of the to bank account. |
|||||||||||||||||||||||||||||||
CBD-TRAN-ND Transaction Number of Decimals | Numeric 1 The number of decimal places defined for the bank account currency. |
|||||||||||||||||||||||||||||||
CBD-BASE-ND Base Currency Nbr of Decimals | Numeric 1 The number of decimal places defined for the currency of the originating company. |
|||||||||||||||||||||||||||||||
CBD-GLT-OBJ-ID Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|||||||||||||||||||||||||||||||
CBD-ACT-OBJ-ID Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|||||||||||||||||||||||||||||||
CBD-ACCT-CATEGORY Element: Acct Category | Alpha 5 The account category assigned to the bank transaction distribution. Must be a valid record in the Activity Account Category file. Account categories are the Activity Management accounts by which activity transactions are grouped for budgeting and reporting. |
|
||||||||||||||||||||||||||||||
CBD-ANALYSIS-FLD Element: Analysis Fld | Alpha 32 Currently not in use. |
|
||||||||||||||||||||||||||||||
CBD-RECON-STMT-NBR Element: Recon Stmt Nbr | Numeric 12 The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements. |
|
||||||||||||||||||||||||||||||
CBD-TAX-AMOUNT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||||
CBD-BASE-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CBDSET1 |
CASH-CODE BANK-INST-CODE TRANS-IDENT DIST-TYPE SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||||||
CBDSET2 |
DIST-COMPANY DIS-ACCT-UNIT DIS-ACCOUNT DIS-SUB-ACCT GLT-OBJ-ID CASH-CODE TRANS-NBR BANK-INST-CODE DIST-TYPE SEQ-NBR TRANS-IDENT |
|
| ||||||||||||||||||||||||||||||||||||
CBDSET3 |
ACT-OBJ-ID CASH-CODE BANK-INST-CODE TRANS-IDENT DIST-TYPE SEQ-NBR |
|
|||||||||||||||||||||||||||||||||||||
CBDSET4 |
COMPANY REC-STATUS CASH-CODE BANK-INST-CODE TRANS-IDENT DIST-TYPE SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cbbankent | CBBANKENT |
Required
| |||||||||||||||
Cbcashcode | CBCASHCODE |
Required
| |||||||||||||||
Cbsegblock | CBSEGBLOCK |
Required
| |||||||||||||||
Cbstatemnt | CBSTATEMNT |
Not Required
| |||||||||||||||
Cbtrans | CBTRANS |
Required
| |||||||||||||||
Glmaster | GLMASTER |
Required
| |||||||||||||||
Glnames | GLNAMES |
Required
| |||||||||||||||
Glsystem | GLSYSTEM |
Required
| |||||||||||||||
Glsystem Orig | GLSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cbstmtdtl | CBSTMTDTL |
|
All trademarks and registered trademarks are the property of their
respective owners.