Lawson Insight Technical Documentation |
|
CBTRANS
CBTRANS FILE
Bank Transaction
The Bank Transaction file contains Cash Ledger bank transaction records.
REFERENCED BY
CB175 CB281 CB170 CB221 AP195 CB286
CB220 CB260 CB43.1 CB44.1 CB45.1 CB50.1
CB90.4 CB195
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 CB180 CB185
CB186 CB187 CB190 CB191 CB20.1 CB25.1
CB30.1 CB300 CB46.1 CB500 CB543 CB544
CB80.1 CB82.1 DT180 DT181 DT185 DT92.1
TX101
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBT-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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-BANK-INST-CODE Alpha 3 AP170 AP180
Element: Transaction CoThe bank transaction code. Represents a AP181 AP190
type of cash payment, bill of exchange AP255 AP265
payment, or bank service. Must be a AP81.1 AP90.5
valid record in the Bank Transaction AR115 AR124
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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-TRANS-NBR Alpha 10 (Right Justified) AP170 AP180
Element: Transaction NuA unique number used to identify the AP181 AP190
bank transaction. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-BANK-INST-TYPE Alpha 1 AP170 AP180
Transaction Code Indicates the type of bank transaction AP181 AP190
Type (based on the transaction code assigned AP255 AP265
to the transaction). Valid values are: AP81.1 AP90.5
AR115 AR124
C = Cash Payment Transaction. AR20.1 AR21.1
D = Bill of Exchange Payment AR21.2 AR21.3
Transaction. AR24.1 AR30.1
B = Bank Service Transaction. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-SOURCE-CODE Alpha 2 AP170 AP180
Element: Source Code Identifies where the transaction was AP181 AP190
created. Must be valid source code. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-COMPANY Numeric 4 AP170 AP180
Element: Company The company number that initiated the AP181 AP190
bank transaction. Must be a valid record AP255 AP265
in the General Ledger Company file and a AP81.1 AP90.5
valid relationship record must exist in AR115 AR124
the Company-Cash Code Relationship 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-VENDOR Alpha 9 (Right Justified) AP170 AP180
Element: Vendor If the Source Code field = AP, this AP181 AP190
field contains the accounts payable AP255 AP265
vendor number associated with the bank AP81.1 AP90.5
transaction. Must be a valid record in AR115 AR124
the Accounts Payable Vendor 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-CUSTOMER Alpha 9 (Right Justified) AP170 AP180
Element: Customer This field contains the accounts AP181 AP190
receivable customer number associated AP255 AP265
with the bank transaction. This field is AP81.1 AP90.5
only populate if the transacion is a AR115 AR124
Return to Maker (RTM) record created in AR20.1 AR21.1
AR82. Must be a valid record in the AR AR21.2 AR21.3
Company Customer file. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-EMPLOYEE Numeric 9 AP170 AP180
Element: Employee The employee number associated with the AP181 AP190
bank transaction. THIS FIELD IS NOT AP255 AP265
CURRENTLY USED. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-PROC-LEVEL Alpha 5 AP170 AP180
Element: Process Level The process level associated with the AP181 AP190
bank transaction. If the Source Code AP255 AP265
field = AP, must be a valid record in AP81.1 AP90.5
the Accounts Payable Process Level file. AR115 AR124
If the Source Code field = AR, must be a AR20.1 AR21.1
valid record in the Accounts Receivable AR21.2 AR21.3
Process Level file. If the Source Code AR24.1 AR30.1
field = CB, this field may be blank or AR32.1 AR34.1
must be a valid record in the Cash AR570 AR575
Deposit Process Level file. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-ISSUE-DATE Numeric 8 (yyyymmdd) AP170 AP180
Element: Issue Date The date of the transaction. 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
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-RECON-DATE Numeric 8 (yyyymmdd) AP170 AP180
Element: Recon Date Represents the date the transaction AP181 AP190
cleared the bank or was voided. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-ISSUE-BNK-AMT Signed 18.2 AP170 AP180
Acct Currency The amount of the transaction in the AP181 AP190
Issued Amt currency 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-ISSUE-BASE-AMT Signed 18.2 AP170 AP180
Base Currency The amount of the transaction in the AP181 AP190
Issued Amt base currency of the company responsible AP255 AP265
for generating the 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-RECON-BNK-AMT Signed 18.2 AP170 AP180
Acct Currency The amount of the transaction AP181 AP190
Reconciled Amt recognized by the bank in the currency AP255 AP265
of the bank account. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-RECON-BASE-AMT Signed 18.2 AP170 AP180
Base Currency The amount of the transaction AP181 AP190
Reconciled Amt recognized by the bank in the currency AP255 AP265
of the company responsible for AP81.1 AP90.5
generating the transaction. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-TRAN-ND Numeric 1 AP170 AP180
Element: Acct Nd The number of decimal places defined AP181 AP190
for 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-BASE-ND Numeric 1 AP170 AP180
Element: Base Nd The number of decimal places defined AP181 AP190
for the currency of the company AP255 AP265
responsible for generating the AP81.1 AP90.5
transaction. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-BNK-TRANS-SIGN Alpha 2 AP170 AP180
Banking Transaction Indicates the type of bank transaction. AP181 AP190
Type Valid values are: AP255 AP265
AP81.1 AP90.5
CR = Bank Credit. AR115 AR124
DR = Bank Debit. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-ORIG-CNV-RATE Signed 14.7 AP170 AP180
Element: Curr Rate The exchange used to convert AP181 AP190
transaction amounts from the bank AP255 AP265
account currency to the company base AP81.1 AP90.5
currency. This is the rate in effect at AR115 AR124
the time the transaction was created or AR20.1 AR21.1
entered. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-RECON-CNV-RATE Signed 14.7 AP170 AP180
Reconciled Exchange The exchange used to convert AP181 AP190
Rate transaction amounts from the bank AP255 AP265
account currency to the company base AP81.1 AP90.5
currency. This is the rate in effect at AR115 AR124
the time the transaction was reconciled. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-ISSUE-TRAN-AMT Signed 18.2 AP170 AP180
Element: Intl Amt The amount of the transaction in the AP181 AP190
currency of the transaction. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-BNK-CNV-RATE Signed 14.7 AP170 AP180
Element: Curr Rate The exchange rate used to convert the AP181 AP190
transaction currency to the bank account AP255 AP265
currency. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-BANK-ND Numeric 1 AP170 AP180
Element: Acct Nd The number of decimal places defined for AP181 AP190
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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-CURRENCY-CODE Alpha 5 AP170 AP180
Element: Transaction CuThe currency of the transaction. Must AP181 AP190
be a valid record in the Currency Codes AP255 AP265
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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-DESCRIPTION Alpha 30 (Lower Case) AP170 AP180
Element: Description The description of the transaction. 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
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-REFERENCE Alpha 10 (Lower Case) AP170 AP180
Element: Reference The reference value assigned to the AP181 AP190
transaction. Used for informational AP255 AP265
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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-PERIOD-DATE Numeric 8 (yyyymmdd) AP170 AP180
Element: Period Date The ending date of the bank statement AP181 AP190
period the transaction was reconciled AP255 AP265
in. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-LAST-DIST-SEQ Numeric 4 AP170 AP180
Element: Seq Nbr The last system-assigned sequence AP181 AP190
number assigned to distributions for a AP255 AP265
cash ledger 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-REC-STATUS Numeric 1 AP170 AP180
Element: Rec Status The status of the transaction in the AP181 AP190
Lawson Cash Ledger system. Valid values AP255 AP265
are: AP81.1 AP90.5
AR115 AR124
0 = Unreleased. AR20.1 AR21.1
1 = Open. AR21.2 AR21.3
2 = Reconciled. AR24.1 AR30.1
3 = Voided. AR32.1 AR34.1
4 = Stop Payment. AR570 AR575
5 = Stale Dated AR580 AR82.1
6 = Escheated CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-REINSTATE-FL Alpha 1 AP170 AP180
Element: All Flag If Source Code = AP, indicates whether AP181 AP190
invoices associated with a voided cash AP255 AP265
payment have been reinstated by AP190 AP81.1 AP90.5
(Invoice Reinstatement). If Source Code AR115 AR124
= CB, indicates whether the voided AR20.1 AR21.1
transaction has been updated by CB180 AR21.2 AR21.3
(Cash Ledger Void Update). Valid values AR24.1 AR30.1
are: AR32.1 AR34.1
AR570 AR575
N = No. AR580 AR82.1
Y = Yes. CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-PRINT-STATUS Alpha 1 AP170 AP180
Element: All Flag Indicates whether the transaction has AP181 AP190
been updated as reported on by the bank AP255 AP265
transaction reconciliation. Valid values AP81.1 AP90.5
are: AR115 AR124
AR20.1 AR21.1
N = No. AR21.2 AR21.3
Y = Yes. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-DIST-APPLIED Signed 18.2 AP170 AP180
Element: Intl Amt The total distribution amount applied AP181 AP190
to the transaction in the currency of AP255 AP265
the bank account. If the Source Code AP81.1 AP90.5
field = CB, the transaction cannot be AR115 AR124
released until the total distribution AR20.1 AR21.1
amount equals the transaction amount. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-BASE-APPLIED Signed 18.2 AP170 AP180
Element: Intl Amt The total distribution amount applied AP181 AP190
to the transaction in the currency of AP255 AP265
the company responsible for generating AP81.1 AP90.5
the transaction. This field is used to AR115 AR124
balance the transactions distribution AR20.1 AR21.1
base amounts when the transaction amount AR21.2 AR21.3
is in balance. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-DIST-DATE Numeric 8 (yyyymmdd) AP170 AP180
Element: Dist Date The date used for posting 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-SERIAL-NUM Numeric 8 AP170 AP180
Element: Serial Num A system-generated number used to group AP181 AP190
tape payment transactions. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-SUMMARY-OPTION Alpha 1 AP170 AP180
Element: Summary OptionIndicates whether the transaction is a AP181 AP190
summarized tape payment record. Valid AP255 AP265
values are: AP81.1 AP90.5
AR115 AR124
Y = Yes. AR20.1 AR21.1
Blank = Not a summarized tape payment AR21.2 AR21.3
record. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-REC-TYPE Alpha 1 AP170 AP180
Element: Rec Type Identifies the type of bank transaction AP181 AP190
record. Valid values are: AP255 AP265
AP81.1 AP90.5
R = Cash Receipt Entry. AR115 AR124
T = Fund Transfer Header. AR20.1 AR21.1
D = Fund Transfer Detail. AR21.2 AR21.3
Blank = None of the above. AR24.1 AR30.1
C = CB Payment AR32.1 AR34.1
E = CB EFT Extract 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-PAY-GROUP Alpha 4 AP170 AP180
Element: Pay Group The pay group associated with the AP181 AP190
transaction. Used only if the Source AP255 AP265
Code field = AP. Must be a valid record AP81.1 AP90.5
in the Pay Group 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-JRNL-BOOK-NBR Alpha 12 AP170 AP180
Element: Jrnl Book Nbr The journal book assigned to the AP181 AP190
transaction. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-RECON-STMT-NBR Numeric 12 AP170 AP180
Element: Recon Stmt NbrThe bank-assigned reconciliation AP181 AP190
statement number. Used only for cash AP255 AP265
codes that require reconciliation AP81.1 AP90.5
statements. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-STMT-STATUS Numeric 1 AP170 AP180
Element: Stmt Status The status of the reconciliation AP181 AP190
statement associated with the AP255 AP265
transaction. Used only for transactions AP81.1 AP90.5
for a cash code that requires AR115 AR124
reconciliation statements. Valid values AR20.1 AR21.1
are: AR21.2 AR21.3
AR24.1 AR30.1
1 = Open. AR32.1 AR34.1
9 = Closed. AR570 AR575
Blank = Reconciliation statements not AR580 AR82.1
required. CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-BANK-SIGN Derived
Element: GL TransactionIndicates whether the transaction
represents a bank debit or a bank
credit.
CBT-RPT-ISSUE-AMT Derived
Element: Report Issued The issued amount of the transaction
stated as positive or negative.
CBT-RPT-RECON-AMT Derived
Report Reconciled The reconciled amount of the
Amount transaction stated as positive or
negative.
CBT-DRILL-DOWN-STS Derived
Element: Drill Down StaThe status of the transaction. Used for
drill down display purposes.
CBT-RECON-VARIANCE Derived
Reconciliation The amount posted to the general ledger
Variance reconciliation variance account for the
transaction.
CBT-SHORT-PAYEE Derived
Element: Short Payee A short vendor name for payments
generated by Accounts Payable.
CBT-JBK-SEQ-NBR Numeric 10 AP170 AP180
Element: Jbk Seq Nbr The journal book sequence number AP181 AP190
assigned to a journal book transaction AP255 AP265
when it is added or interfaced to the AP81.1 AP90.5
Lawson system. Used only when Auto AR115 AR124
Journal Book Seq Nbr is set to Yes in AR20.1 AR21.1
GL10.1 (Company). 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-SOURCE Alpha 1 AP170 AP180
Element: Source The source of the transaction. Input or AP181 AP190
output. Input transactions are Accounts AP255 AP265
Payable. Output transactions are AP81.1 AP90.5
Accounts Receivable. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-TAX-FLAG Alpha 1 AP170 AP180
Element: All Flag " " = Not interfaced AP181 AP190
I = Interfaced 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1 TX101
CBT-MAINT-DATE Numeric 8 (yyyymmdd) AP170 AP180
Element: Maint Date The date last changed. 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
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-MAINT-TIME Numeric 6 (hhmmss) AP170 AP180
Element: Maint Time The time last changed. 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
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-USER-FIELD1 Alpha 30 AP170 AP180
Element: User Field1 This is the first user definable field. AP181 AP190
It can be used to capture any data that AP255 AP265
the user wants. The title of the field AP81.1 AP90.5
is setup in IC00. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-USER-FIELD2 Alpha 30 AP170 AP180
Element: User Field2 This is the second user definable AP181 AP190
field. This field can be used to enter AP255 AP265
any data that the user wants to capture AP81.1 AP90.5
for this item. The title of the field AR115 AR124
is setup in IC00. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-USER-FIELD3 Alpha 30 AP170 AP180
Element: User Field1 This is the first user definable field. AP181 AP190
It can be used to capture any data that AP255 AP265
the user wants. The title of the field AP81.1 AP90.5
is setup in IC00. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-USER-FIELD4 Alpha 30 AP170 AP180
Element: User Field2 This is the second user definable AP181 AP190
field. This field can be used to enter AP255 AP265
any data that the user wants to capture AP81.1 AP90.5
for this item. The title of the field AR115 AR124
is setup in IC00. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-STALE-DATE Numeric 8 (yyyymmdd) AP170 AP180
Element: Date This field displays the system date AP181 AP190
when this was created. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-STL-ACCT-UNIT Alpha 15 AP170 AP180
Element: Acct Unit The accounting unit is a shorthand AP181 AP190
notation representing the variable level AP255 AP265
number. When used in the General Ledger AP81.1 AP90.5
Account Master file, the accounting unit AR115 AR124
must be defined in the General Ledger AR20.1 AR21.1
Names file as a posting accounting unit. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-STL-ACCOUNT Numeric 6 AP170 AP180
Element: Account This field along with the accounting AP181 AP190
unit and subaccount make up the location AP255 AP265
(account) where amounts and other AP81.1 AP90.5
account information is stored. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-STL-SUB-ACCT Numeric 4 AP170 AP180
Element: Sub Acct This field contains the subaccount from AP181 AP190
your general ledger chart of accounts AP255 AP265
that was charged with the amount carried AP81.1 AP90.5
on this record. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-CSR-STMT-NBR Numeric 12 AP170 AP180
Element: Recon Stmt NbrThe bank-assigned reconciliation AP181 AP190
statement number. Used only for cash AP255 AP265
codes that require reconciliation AP81.1 AP90.5
statements. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-CSR-STMT-SUFF Alpha 5 AP170 AP180
Element: Suffix Code 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
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-CSR-LINE-NBR Numeric 6 AP170 AP180
Element: Line Nbr This field contains the line number. 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
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-CSR-RECON-DESC Alpha 60 (Lower Case) AP170 AP180
Element: Description 60 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
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBT-CSR-TRANS-NBR Alpha 10 (Right Justified) AP170 AP180
Element: Trans Nbr A unique, user-defined value used to AP181 AP190
identify the transaction. 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 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 DT180
DT181 DT185
DT92.1
CBTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBTSET1 BANK-INST-CODE AP170 AP180
TRANS-IDENT 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
...
CBTSET10 CASH-CODE KeyChange CB281 CB82.1
CSR-STMT-NBR
CSR-STMT-SUFF
CSR-LINE-NBR
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
CBTSET2 CASH-CODE KeyChange CB190
PERIOD-DATE
BANK-INST-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
CBTSET3 CASH-CODE KeyChange CB170 CB221
BANK-INST-CODE CB300
SOURCE-CODE
TRANS-NBR
SUFFIX
COMPANY
TRANS-IDENT
CBTSET4 BANK-INST-CODEKeyChange, Subset AP170 AP180
SERIAL-NUM Where SERIAL-NUM != Zeroes AP181 AP190
TRANS-IDENT 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
...
CBTSET5 REC-STATUS KeyChange AP190 AP195
COMPANY CB180 CB186
CASH-CODE CB187 CB286
BANK-INST-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
CBTSET6 CASH-CODE KeyChange AP170 AP180
BANK-INST-CODE AP181 AP190
TRANS-NBR AP255 AP265
SUFFIX AP81.1 AP90.5
TRANS-IDENT 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
...
CBTSET7 CASH-CODE KeyChange
ISSUE-DATE*
BANK-INST-CODE
SOURCE-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
CBTSET8 COMPANY KeyChange CB195 TX101
BANK-INST-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
CBTSET9 CASH-CODE KeyChange
BANK-INST-CODE
CSR-STMT-NBR
CSR-STMT-SUFF
CSR-LINE-NBR
TRANS-NBR
TRANS-IDENT
CBTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apdrafts APDRAFTS Required
When CBI-BANK-INST-TYPE = "D"
CBT-BANK-INST-CODE -> APT-BANK-INST-CODE
CBT-TRANS-IDENT -> APT-TRANS-IDENT
Aphset4 ARPYMNTHDR Not Required
CBT-BANK-INST-CODE -> APH-DEP-INST-CODE
CBT-TRANS-IDENT -> APH-TRANS-IDENT
Aphset5 ARPYMNTHDR Not Required
CBT-BANK-INST-CODE -> APH-ADJ-INST-CODE
CBT-TRANS-IDENT -> APH-ADJ-TRANS-IDNT
Arrtm ARRTM Not Required
CBT-BANK-INST-CODE -> RTM-RTM-INST-CODE
CBT-TRANS-IDENT -> RTM-TRANS-IDENT
Cbadjust CBADJUST Not Required
CBT-BANK-INST-CODE -> CBJ-BANK-INST-CODE
CBT-TRANS-IDENT -> CBJ-TRANS-IDENT
Cbbalance CBBALANCE Not Required
CBT-CASH-CODE -> CBB-CASH-CODE
CBT-PERIOD-DATE -> CBB-PER-END-DATE
Cbbankent CBBANKENT Required
CBC-BANK-ENTITY -> CBE-BANK-ENTITY
Cbbankinst CBBANKINST Required
CBT-BANK-INST-CODE -> CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
CBT-CASH-CODE -> CBC-CASH-CODE
Cbcpycash CBCPYCASH Required
CBT-COMPANY -> CBY-COMPANY
CBT-CASH-CODE -> CBY-CASH-CODE
Cbrecpthdr CBRECPTHDR Not Required, Delete Cascades
Valid When CBT-SOURCE-CODE = "CB"
And CBT-REC-TYPE = "R"
CBT-CASH-CODE -> CBP-CASH-CODE
CBT-BANK-INST-CODE -> CBP-BANK-INST-CODE
CBT-TRANS-NBR -> CBP-TRANS-NBR
Cbretpmt CBRETPMT Not Required
CBT-CASH-CODE -> CRP-CASH-CODE
CBT-BANK-INST-CODE -> CRP-BANK-INST-CODE
CBT-TRANS-IDENT -> CRP-TRANS-IDENT
Cbstmtrec CBSTMTREC Required
CBT-CSR-STMT-NBR -> CSR-STMT-NBR
CBT-CSR-STMT-SUFF -> CSR-STMT-SUFFIX
CBT-CSR-LINE-NBR -> CSR-LINE-NBR
Cbtrfhdr CBTRFHDR Not Required
Valid When CBT-SOURCE-CODE = "CB"
And CBT-REC-TYPE = "T"
CBT-CASH-CODE -> CBH-CASH-CODE
CBT-TRANS-NBR -> CBH-TRANSFER-NBR
Dtcashing DTCASHING Not Required
CBT-BANK-INST-CODE -> DTS-BANK-INST-CODE
CBT-TRANS-IDENT -> DTS-TRANS-IDENT
Dtremit DTREMIT Not Required
CBT-BANK-INST-CODE -> DRM-DEP-INST-CODE
CBT-TRANS-IDENT -> DRM-TRANS-IDENT
Glsystem GLSYSTEM Required
CBT-COMPANY -> GLS-COMPANY
CBTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apapphist APAPPHIST
CBT-PAY-GROUP -> AH3-PAY-GROUP
CBT-BANK-INST-CODE -> AH3-BANK-INST-CODE
CBT-TRANS-IDENT -> AH3-TRANS-IDENT
AH3-VENDOR
AH3-INVOICE
AH3-SUFFIX
AH3-CANCEL-SEQ
AH3-SEQ-NBR
AH3-VOID-SEQ
AH3-COMPANY
Appayment APPAYMENT
CBT-PAY-GROUP -> APP-PAY-GROUP
CBT-BANK-INST-CODE -> APP-BANK-INST-CODE
CBT-TRANS-IDENT -> APP-TRANS-IDENT
APP-VENDOR
APP-INVOICE
APP-SUFFIX
APP-CANCEL-SEQ
APP-SEQ-NBR
APP-VOID-SEQ
APP-COMPANY
Cbcheck Summ CBCHECK
CBT-CASH-CODE -> CHK-CASH-CODE
CBT-BANK-INST-CODE -> CHK-BANK-INST-CODE
CBT-SERIAL-NUM -> CHK-SERIAL-NUM
CHK-TRANS-NBR
CHK-TRANS-IDENT
Cbdistrib CBDISTRIB
CBT-CASH-CODE -> CBD-CASH-CODE
CBT-BANK-INST-CODE -> CBD-BANK-INST-CODE
CBT-TRANS-IDENT -> CBD-TRANS-IDENT
CBD-DIST-TYPE
CBD-SEQ-NBR
Cbfttrans CBFTTRANS
CBT-CASH-CODE -> CFT-CASH-CODE
CBT-BANK-INST-CODE -> CFT-BANK-INST-CODE
CBT-TRANS-NBR -> CFT-TRANS-NBR
CFT-REFERENCE-NO
CFT-TRANS-IDENT
Cbpayment CBPAYMENT
CBT-PAY-GROUP -> CBM-PAY-GROUP
CBT-BANK-INST-CODE -> CBM-BANK-INST-CODE
CBT-TRANS-IDENT -> CBM-TRANS-IDENT
CBM-CASH-CODE
Cbrecptdtl CBRECPTDTL
CBT-CASH-CODE -> CBA-CASH-CODE
CBT-BANK-INST-CODE -> CBA-BANK-INST-CODE
CBT-TRANS-NBR -> CBA-TRANS-NBR
CBA-SEQ-NBR
Cbtrfdtl CBTRFDTL
CBT-CASH-CODE -> CBL-DTL-CASH-CODE
CBT-TRANS-NBR -> CBL-TRANSFER-NBR
CBL-CASH-CODE
|