CBDISTRIB

Transaction Distribution

The Transaction Distribution file contains all distribution records associated with a Cash Ledger transaction.

REFERENCED BY
TX101


UPDATED BY
AP170 AP180 AP181 AP190 AP255 AP265
AP81.1 AP90.5 CB06.2 CB10.1 CB145 CB15.1
CB15.2 CB150 CB175 CB180 CB185 CB186
CB187 CB190 CB191 CB20.1 CB20.6 CB25.1
CB30.1 CB300 CB45.1 CB46.1 CB500 CB543
CB544 CB55.1 CB554 CB80.1 CB82.1 CB195
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-TRANS-IDENT
Element: Transaction ID
Numeric 10
A unique system-generated identification value assigned to the transaction to make this record unique.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-SUFFIX
Element: Transaction Suffix
Numeric 3
The transaction suffix number. Represents the occurrence value of the transaction.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBD-SOURCE-CODE
Element: Source Code
Alpha 2
Identifies where the bank transaction was created. Must be a valid source code.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-SEQ-NBR
Element: Seq Nbr
Numeric 4
Contains a system-assigned sequence number.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-DIST-TYPE
Element: Dist Type
Alpha 1
The distribution type. Valid values are: E = Entry. R = Reconciliation.
V = Cash Ledger Void Update
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-REC-STATUS
Element: Rec Status
Numeric 1
The status of the transaction distribution. Valid values are: 0 = Unreleased. 1 = Released. 9 = Posted.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB175 CB180
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
CBD-POST-DATE
Element: Post Date
Numeric 8 (yyyymmdd)
The date for using to post the transaction to the general ledger.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-BANK-DIST-AMT
Acct Currency
Distribution Amt
Signed 18.2
The distribution amount in the currency of the bank account.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-ORIG-BASE-AMT
Base Currency
Distribution Amt
Signed 18.2
The distribution amount in the base currency of the originating company.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-DIST-BASE-AMT
To Company
Distribution Amount
Signed 18.2
The distribution amount in the base currency of the distribution company.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-TO-BNK-DST-AMT
To Acct Curr
Distribution Amt
Signed 18.2
The distribution amount in the currency of the to bank account.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
The reference value assigned to the transaction distribution. Used for informational purposes.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The description of the transaction distribution.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
CB10.1 CB145
CB150 CB180
CB20.1 CB20.6
CB30.1 CB45.1
CB46.1 CB500
CB543 CB55.1
CB554
CBD-TRAN-TAXABLE
Element: Intl Amt
Signed 18.2
The taxable amount of the bank transaction distribution in the currency of the bank account.
CB10.1 CB145
CB150 CB180
CB20.1 CB20.6
CB30.1 CB45.1
CB46.1 CB500
CB543 CB55.1
CB554
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.
CB145 CB180
CB20.1 CB20.6
CB30.1 CB45.1
CB46.1 CB500
CB554
CBD-TO-BASE-ND
Element: Acct Nd
Numeric 1
The number of decimal places defined for the base currency of the distribution company.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-TRAN-ND
Transaction Number
of Decimals
Numeric 1
The number of decimal places defined for the bank account currency.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
CBD-BASE-ND
Base Currency Nbr
of Decimals
Numeric 1
The number of decimal places defined for the currency of the originating company.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB175 CB180
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
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.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB175 CB180
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
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.
CB10.1 CB145
CB15.1 CB15.2
CB150 CB191
CB20.1 CB20.6
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CBD-ANALYSIS-FLD
Element: Analysis Fld
Alpha 32
Currently not in use.
CB145 CB20.1
CB20.6 CB30.1
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.
CB145
CBD-TAX-AMOUNT
Element: Intl Amt
Signed 18.2
CBD-BASE-TAX-AMT
Element: Intl Amt
Signed 18.2


CBDISTRIB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBDSET1 CASH-CODE
BANK-INST-CODE
TRANS-IDENT
DIST-TYPE
SEQ-NBR
...
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB175 CB180
CB185 CB186
CB187 CB190
CB191 CB195
CB20.1 CB20.6
CB221 CB245
CB246 CB25.1
CB255 CB30.1
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
KeyChange
CB55.1
CBDSET3 ACT-OBJ-ID
CASH-CODE
BANK-INST-CODE
TRANS-IDENT
DIST-TYPE
SEQ-NBR
KeyChange, Subset
WhereACT-OBJ-ID !=Zeroes
CBDSET4 COMPANY
REC-STATUS
CASH-CODE
BANK-INST-CODE
TRANS-IDENT
DIST-TYPE
SEQ-NBR
KeyChange
CB150 CB175
CB180 CB191
CB195 CB20.1
CB30.1 CB45.1
CB46.1


CBDISTRIB FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbbankent CBBANKENT Required
CBC-BANK-ENTITY->CBE-BANK-ENTITY
Cbcashcode CBCASHCODE Required
CBD-CASH-CODE->CBC-CASH-CODE
Cbsegblock CBSEGBLOCK Required
CBD-CASH-CODE->CBK-CASH-CODE
CBD-BANK-INST-CODE->CBK-BANK-INST-CODE
CBD-TRANS-IDENT->CBK-TRANS-IDENT
CBD-DIST-TYPE->CBK-DIST-TYPE
CBD-SEQ-NBR->CBK-SEQ-NBR
Cbstatemnt CBSTATEMNT Not Required
Valid When CBD-RECON-STMT-NBR !=Zeroes
CBD-CASH-CODE->CSM-CASH-CODE
CBD-RECON-STMT-NBR->CSM-RECON-STMT-NBR
Cbtrans CBTRANS Required
CBD-BANK-INST-CODE->CBT-BANK-INST-CODE
CBD-TRANS-IDENT->CBT-TRANS-IDENT
Glmaster GLMASTER Required
CBD-DIST-COMPANY->GLM-COMPANY
CBD-DIS-ACCT-UNIT->GLM-ACCT-UNIT
CBD-DIS-ACCOUNT->GLM-ACCOUNT
CBD-DIS-SUB-ACCT->GLM-SUB-ACCOUNT
Glnames GLNAMES Required
CBD-DIST-COMPANY->GLN-COMPANY
CBD-DIS-ACCT-UNIT->GLN-ACCT-UNIT
Glsystem GLSYSTEM Required
CBD-DIST-COMPANY->GLS-COMPANY
Glsystem Orig GLSYSTEM Required
CBD-COMPANY->GLS-COMPANY


CBDISTRIB FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbstmtdtl CBSTMTDTL
CBD-BANK-INST-CODE->CSD-BANK-INST-CODE
CBD-RECON-STMT-NBR->CSD-RECON-STMT-NBR
CBD-TRANS-NBR->CSD-PAYMENT-NBR
"G"->CSD-TRANS-TYPE
CBD-CASH-CODE->CSD-CASH-CODE
  CSD-LINE-NBR


File created: Wed Jun 08 20:48:22 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.