Lawson Insight Technical Documentation |
|
CBDISTRIB
CBDISTRIB FILE
Transaction Distribution
The Transaction Distribution file contains all distribution records
associated with a Cash Ledger transaction.
REFERENCED BY
CB195 CB221 CB245 CB246 CB255 CB99.1
TX101
UPDATED BY
AP170 AP180 AP181 AP190 AP255 AP265
AP81.1 AP90.5 AR115 AR124 AR20.1 AR21.1
AR21.2 AR21.3 AR24.1 AR30.1 AR32.1 AR34.1
AR570 AR575 AR580 AR82.1 CB06.2 CB10.1
CB145 CB15.1 CB15.2 CB150 CB175 CB180
CB185 CB186 CB187 CB190 CB191 CB20.1
CB25.1 CB30.1 CB300 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 CB80.1 CB82.1
DT180 DT181 DT185 DT92.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBD-CASH-CODE Alpha 4 AP170 AP180
Element: Cash Code The cash code. Represents a bank AP181 AP190
account. Must be a valid record in the AP255 AP265
Cash Code file. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-BANK-INST-CODE Alpha 3 AP170 AP180
Element: Transaction CoThe transaction code. Represents a type AP181 AP190
of cash payment, bill of exchange AP255 AP265
payment, or bank service transaction. AP81.1 AP90.5
Must be a valid record in the Bank AR115 AR124
Transaction Code file. AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-TRANS-IDENT Numeric 10 AP170 AP180
Element: Transaction IDA unique system-generated AP181 AP190
identification value assigned to the AP255 AP265
transaction to make this record unique. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-TRANS-NBR Alpha 10 (Right Justified) AP170 AP180
Element: Transaction NuThe unique number used to identify the AP181 AP190
transaction. Must be a valid record in AP255 AP265
the Bank Transaction file. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-SUFFIX Numeric 3 AP170 AP180
Element: Transaction SuThe transaction suffix number. AP181 AP190
Represents the occurrence value of the AP255 AP265
transaction. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-SOURCE-CODE Alpha 2 AP170 AP180
Element: Source Code Identifies where the bank transaction AP181 AP190
was created. Must be a valid source AP255 AP265
code. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-COMPANY Numeric 4 AP170 AP180
Element: Company The company number that initiated or AP181 AP190
created the transaction. Must be a valid AP255 AP265
record in the General Ledger Company AP81.1 AP90.5
file. AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-SEQ-NBR Numeric 4 AP170 AP180
Element: Seq Nbr Contains a system-assigned sequence AP181 AP190
number. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-DIST-COMPANY Numeric 4 AP170 AP180
Element: Company The company number the bank transaction AP181 AP190
is to be posted to. Must be a valid AP255 AP265
record in the General Ledger Company AP81.1 AP90.5
file. AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-DIST-TYPE Alpha 1 AP170 AP180
Element: Dist Type The distribution type. Valid values are: AP181 AP190
AP255 AP265
E = Entry. AP81.1 AP90.5
R = Reconciliation. AR115 AR124
V = Cash Ledger Void Update AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-RECORD-TYPE Alpha 1 AP170 AP180
Element: Record Type Identifies the type of distribution AP181 AP190
record. Valid values are: AP255 AP265
AP81.1 AP90.5
C = Cash Account Distribution. AR115 AR124
E = EFT Payment distribution. AR20.1 AR21.1
P = CB Payment distribution. AR21.2 AR21.3
O = Offset CB payment distribution AR24.1 AR30.1
Blank = Not a cash account distribution. AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-REC-STATUS Numeric 1 AP170 AP180
Element: Rec Status The status of the transaction AP181 AP190
distribution. Valid values are: AP255 AP265
AP81.1 AP90.5
0 = Unreleased. AR115 AR124
1 = Released. AR20.1 AR21.1
9 = Posted. AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB175 CB180
CB185 CB186
CB187 CB190
CB191 CB20.1
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBD-POST-DATE Numeric 8 (yyyymmdd) AP170 AP180
Element: Post Date The date for using to post the AP181 AP190
transaction to the general ledger. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-DIS-ACCT-UNIT Alpha 15 AP170 AP180
Element: Acct Unit The general ledger distribution AP181 AP190
accounting unit. Must be a valid record AP255 AP265
in the General Ledger Names file. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-DIS-ACCOUNT Numeric 6 AP170 AP180
Element: Account The general ledger distribution account AP181 AP190
number. Must be a valid record in the AP255 AP265
General Ledger Account Master file. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-DIS-SUB-ACCT Numeric 4 AP170 AP180
Element: Sub Acct The general ledger distribution AP181 AP190
subaccount number. Must be a valid AP255 AP265
record in the General Ledger Account AP81.1 AP90.5
Master file. AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-ACT-CNV-RATE Signed 14.7 AP170 AP180
Element: Exchange Rate The currency exchange rate used to AP181 AP190
convert the bank account currency AP255 AP265
distribution amount to the company base AP81.1 AP90.5
currency. AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-BANK-DIST-AMT Signed 18.2 AP170 AP180
Acct Currency The distribution amount in the currency AP181 AP190
Distribution Amt of the bank account. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-ORIG-BASE-AMT Signed 18.2 AP170 AP180
Base Currency The distribution amount in the base AP181 AP190
Distribution Amt currency of the originating company. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-DIST-BASE-AMT Signed 18.2 AP170 AP180
To Company The distribution amount in the base AP181 AP190
Distribution Amount currency of the distribution company. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-TO-BNK-DST-AMT Signed 18.2 AP170 AP180
To Acct Curr The distribution amount in the currency AP181 AP190
Distribution Amt of the to bank account. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-REFERENCE Alpha 10 (Lower Case) AP170 AP180
Element: Reference The reference value assigned to the AP181 AP190
transaction distribution. Used for AP255 AP265
informational purposes. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-DESCRIPTION Alpha 30 (Lower Case) AP170 AP180
Element: Description The description of the transaction AP181 AP190
distribution. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-ACTIVITY Alpha 15 AP170 AP180
Element: Activity The activity assigned to the bank AP181 AP190
transaction distribution. Must be a AP255 AP265
valid record in the Activity Header AP81.1 AP90.5
file. AR115 AR124
AR20.1 AR21.1
Activities are the tasks that make up AR21.2 AR21.3
an activity group. Activities identify AR24.1 AR30.1
work being done, such as work orders, AR32.1 AR34.1
phases, products, and so on. A variety AR570 AR575
of costs, revenues, or both make up an AR580 AR82.1
activity. CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-TAX-CODE Alpha 10 CB10.1 CB145
Element: Tax Code The tax code to be applied to the bank CB150 CB180
transaction distribution. Must be a CB20.1 CB30.1
valid record in the Tax Code file. CB45.1 CB46.1
CB500 CB543
CB55.1 CB554
CBD-TRAN-TAXABLE Signed 18.2 CB10.1 CB145
Element: Intl Amt The taxable amount of the bank CB150 CB180
transaction distribution in the currency CB20.1 CB30.1
of the bank account. CB45.1 CB46.1
CB500 CB543
CB55.1 CB554
CBD-TAX-TYPE Alpha 1 CB145 CB150
Element: Tax Type If a Tax Code is present, this field CB180 CB20.1
indicates the type of tax. Valid values CB30.1 CB45.1
are: CB46.1 CB500
CB554
I = Invoiced. The tax amount is
included in the transaction amount.
CBD-TO-BASE-ND Numeric 1 AP170 AP180
Element: Acct Nd The number of decimal places defined AP181 AP190
for the base currency of the AP255 AP265
distribution company. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-TO-TRAN-ND Numeric 1 AP170 AP180
To Transaction Nbr The number of decimal places defined AP181 AP190
of Decimals for the currency of the to bank account. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-TRAN-ND Numeric 1 AP170 AP180
Transaction Number The number of decimal places defined for AP181 AP190
of Decimals the bank account currency. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-BASE-ND Numeric 1 AP170 AP180
Base Currency Nbr The number of decimal places defined for AP181 AP190
of Decimals the currency of the originating AP255 AP265
company. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB45.1
CB46.1 CB500
CB543 CB544
CB55.1 CB554
CB80.1 CB82.1
DT180 DT181
DT185 DT92.1
CBD-GLT-OBJ-ID Numeric 12 AP170 AP180
Element: Obj Id This is the object identifier. It is AP181 AP190
used to relate commitments or posted AP255 AP265
transactions back to the originating AP81.1 AP90.5
subsystems. Each subsystem record that AR115 AR124
is updated as a commitment or posted AR20.1 AR21.1
transaction is assigned an object AR21.2 AR21.3
identifier. The object identifier is AR24.1 AR30.1
maintained in the subsystem files and in AR32.1 AR34.1
the Activity Commitments Detail and AR570 AR575
Activity Transaction files. The object AR580 AR82.1
identifier is a unique key used to drill CB06.2 CB10.1
back from Activity Management to the CB145 CB15.1
subsystems. CB15.2 CB150
CB175 CB180
CB185 CB186
CB187 CB190
CB191 CB20.1
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBD-ACT-OBJ-ID Numeric 12 AP170 AP180
Element: Obj Id This is the object identifier. It is AP181 AP190
used to relate commitments or posted AP255 AP265
transactions back to the originating AP81.1 AP90.5
subsystems. Each subsystem record that AR115 AR124
is updated as a commitment or posted AR20.1 AR21.1
transaction is assigned an object AR21.2 AR21.3
identifier. The object identifier is AR24.1 AR30.1
maintained in the subsystem files and in AR32.1 AR34.1
the Activity Commitments Detail and AR570 AR575
Activity Transaction files. The object AR580 AR82.1
identifier is a unique key used to drill CB06.2 CB10.1
back from Activity Management to the CB145 CB15.1
subsystems. CB15.2 CB150
CB175 CB180
CB185 CB186
CB187 CB190
CB191 CB20.1
CB25.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBD-ACCT-CATEGORY Alpha 5 CB10.1 CB145
Element: Acct Category The account category assigned to the CB15.1 CB15.2
bank transaction distribution. Must be a CB150 CB191
valid record in the Activity Account CB20.1 CB30.1
Category file. CB45.1 CB46.1
CB500 CB543
Account categories are the Activity CB544 CB55.1
Management accounts by which activity CB554
transactions are grouped for budgeting
and reporting.
CBD-ANALYSIS-FLD Alpha 32 CB145 CB20.1
Element: Analysis Fld Currently not in use. CB30.1
CBD-RECON-STMT-NBR Numeric 12 CB145
Element: Recon Stmt NbrThe bank-assigned reconciliation
statement number. Used only for cash
codes that require reconciliation
statements.
CBD-TAX-AMOUNT Signed 18.2 CB150 CB45.1
Element: Intl Amt
CBD-BASE-TAX-AMT Signed 18.2 CB150 CB45.1
Element: Intl Amt
CBDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBDSET1 CASH-CODE AP170 AP180
BANK-INST-CODE AP181 AP190
TRANS-IDENT AP255 AP265
DIST-TYPE AP81.1 AP90.5
SEQ-NBR AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB175 CB180
...
CBDSET2 DIST-COMPANY KeyChange CB55.1
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 KeyChange, Subset
CASH-CODE Where ACT-OBJ-ID != Zeroes
BANK-INST-CODE
TRANS-IDENT
DIST-TYPE
SEQ-NBR
CBDSET4 COMPANY KeyChange CB150 CB175
REC-STATUS CB191 CB195
CASH-CODE CB20.1 CB30.1
BANK-INST-CODE CB45.1 CB46.1
TRANS-IDENT
DIST-TYPE
SEQ-NBR
CBDISTRIB FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
Glsystem GLSYSTEM Required
CBD-DIST-COMPANY -> GLS-COMPANY
Glsystem Orig GLSYSTEM Required
CBD-COMPANY -> GLS-COMPANY
CBDISTRIB FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|