CBTRANS

Bank Transaction

The Bank Transaction file contains Cash Ledger bank transaction records.

REFERENCED BY
AP10.1 AP10.2 AP100 AP109 AP110 AP111
AP115 AP125 AP126 AP14.1 AP14.2 AP14.5
AP150 AP151 AP16.1 AP16.2 AP160 AP161
AP193 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP28.1 AP28.2 AP30.1 AP30.2
AP30.4 AP300 AP305 AP510 AP520 AP590
API1.1 API2.1 CB00.1 CB175 EE135 EE20.1
EE20.2 EE35.1 EE35.2 EE520 IC64.6 MA41.1
MA41.2 MA41.4 MA41.7 MA42.1 MA42.2 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA44.1 MA44.2
MA60.2 MA60.3 MA60.4 MA61.1 MA64.6 MA64.9
MA65.1 MA66.1 MA66.2 MA66.3 MA67.3 MA68.2
MA68.4 MA70.1 MA75.1 MAED.1 MAI1.1 CB281
CB221 CB286 CB220 CB260 CB43.1 CB44.1
CB45.1 CB50.1 CB90.4 CBOD.1 CBOD.2


UPDATED BY
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
CB300 CB46.1 CB500 CB543 CB544 CB80.1
CB82.1 TX101 CB222 CB170 AP195 CB195

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBT-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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-BANK-INST-CODE
Element: Transaction Code
Alpha 3
The bank transaction code. Represents a type of cash payment, bill of exchange payment, or bank service. 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-TRANS-NBR
Element: Transaction Number
Alpha 10 (Right Justified)
A unique number used to identify the bank 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
CBT-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
CBT-BANK-INST-TYPE
Transaction Code
Type
Alpha 1
Indicates the type of bank transaction (based on the transaction code assigned to the transaction). Valid values are: C = Cash Payment Transaction. D = Bill of Exchange Payment Transaction. B = Bank Service 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
CBT-SOURCE-CODE
Element: Source Code
Alpha 2
Identifies where the transaction was created. Must be 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-COMPANY
Element: Company
Numeric 4
The company number that initiated the bank transaction. Must be a valid record in the General Ledger Company file and a valid relationship record must exist in the Company-Cash Code Relationship 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
If the Source Code field = AP, this field contains the accounts payable vendor number associated with the bank transaction. Must be a valid record in the Accounts Payable Vendor 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the accounts receivable customer number associated with the bank transaction. This field is only populate if the transacion is a Return to Maker (RTM) record created in AR82. Must be a valid record in the AR Company Customer 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-EMPLOYEE
Element: Employee
Numeric 9
The employee number associated with the bank transaction. THIS FIELD IS NOT CURRENTLY USED.
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
CBT-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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-PROC-LEVEL
Element: Process Level
Alpha 5
The process level associated with the bank transaction. If the Source Code field = AP, must be a valid record in the Accounts Payable Process Level file. If the Source Code field = AR, must be a valid record in the Accounts Receivable Process Level file. If the Source Code field = CB, this field may be blank or must be a valid record in the Cash Deposit Process Level 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-ISSUE-DATE
Element: Issue Date
Numeric 8 (yyyymmdd)
The date 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
CBT-RECON-DATE
Element: Recon Date
Numeric 8 (yyyymmdd)
Represents the date the transaction cleared the bank or was voided.
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
CBT-ISSUE-BNK-AMT
Acct Currency
Issued Amt
Signed 18.2
The amount of the transaction 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-ISSUE-BASE-AMT
Base Currency
Issued Amt
Signed 18.2
The amount of the transaction in the base currency of the company responsible for generating 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
CBT-RECON-BNK-AMT
Acct Currency
Reconciled Amt
Signed 18.2
The amount of the transaction recognized by the bank 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-RECON-BASE-AMT
Base Currency
Reconciled Amt
Signed 18.2
The amount of the transaction recognized by the bank in the currency of the company responsible for generating 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
CBT-TRAN-ND
Element: Acct Nd
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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal places defined for the currency of the company responsible for generating 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
CBT-BNK-TRANS-SIGN
Banking Transaction
Type
Alpha 2
Indicates the type of bank transaction. Valid values are: CR = Bank Credit. DR = Bank Debit.
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
CBT-ORIG-CNV-RATE
Element: Curr Rate
Signed 14.7
The exchange used to convert transaction amounts from the bank account currency to the company base currency. This is the rate in effect at the time the transaction was created or entered.
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
CBT-RECON-CNV-RATE
Reconciled Exchange
Rate
Signed 14.7
The exchange used to convert transaction amounts from the bank account currency to the company base currency. This is the rate in effect at the time the transaction was reconciled.
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
CBT-ISSUE-TRAN-AMT
Element: Intl Amt
Signed 18.2
The amount of the transaction in the currency 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
CBT-BNK-CNV-RATE
Element: Curr Rate
Signed 14.7
The exchange rate used to convert the transaction currency to 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-BANK-ND
Element: Acct Nd
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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-CURRENCY-CODE
Element: Transaction Currency
Alpha 5
The currency of the transaction. Must be a valid record in the Currency Codes 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The description 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
CBT-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
The reference value assigned to the transaction. 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-PERIOD-DATE
Element: Period Date
Numeric 8 (yyyymmdd)
The ending date of the bank statement period the transaction was reconciled in.
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
CBT-LAST-DIST-SEQ
Element: Seq Nbr
Numeric 4
The last system-assigned sequence number assigned to distributions for a cash ledger 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
CBT-REC-STATUS
Element: Rec Status
Numeric 1
The status of the transaction in the Lawson Cash Ledger system. Valid values are: 0 = Unreleased. 1 = Open. 2 = Reconciled. 3 = Voided. 4 = Stop Payment.
5 = Stale Dated
6 = Escheated
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
CB220 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1
CBT-REINSTATE-FL
Element: All Flag
Alpha 1
If Source Code = AP, indicates whether invoices associated with a voided cash payment have been reinstated by AP190 (Invoice Reinstatement). If Source Code = CB, indicates whether the voided transaction has been updated by CB180 (Cash Ledger Void Update). Valid values are: N = No. Y = Yes.
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
CBT-PRINT-STATUS
Element: All Flag
Alpha 1
Indicates whether the transaction has been updated as reported on by the bank transaction reconciliation. Valid values are: N = No. Y = Yes.
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
CBT-DIST-APPLIED
Element: Intl Amt
Signed 18.2
The total distribution amount applied to the transaction in the currency of the bank account. If the Source Code field = CB, the transaction cannot be released until the total distribution amount equals the transaction amount.
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
CBT-BASE-APPLIED
Element: Intl Amt
Signed 18.2
The total distribution amount applied to the transaction in the currency of the company responsible for generating the transaction. This field is used to balance the transactions distribution base amounts when the transaction amount is in balance.
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
CBT-DIST-DATE
Element: Dist Date
Numeric 8 (yyyymmdd)
The date used for posting 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-SERIAL-NUM
Element: Serial Num
Numeric 8
A system-generated number used to group tape payment transactions.
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
CBT-SUMMARY-OPTION
Element: Summary Option
Alpha 1
Indicates whether the transaction is a summarized tape payment record. Valid values are: Y = Yes. Blank = Not a summarized tape payment record.
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
CBT-REC-TYPE
Element: Rec Type
Alpha 1
Identifies the type of bank transaction record. Valid values are: R = Cash Receipt Entry. T = Fund Transfer Header. D = Fund Transfer Detail. Blank = None of the above.
C = CB Payment
E = CB EFT Extract
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
CBT-PAY-GROUP
Element: Pay Group
Alpha 4
The pay group associated with the transaction. Used only if the Source Code field = AP. Must be a valid record in the Pay Group 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-JRNL-BOOK-NBR
Element: Jrnl Book Nbr
Alpha 12
The journal book assigned to 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
CBT-RECON-STMT-NBR
Element: Recon Stmt Nbr
Numeric 12
The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.
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
CBT-STMT-STATUS
Element: Stmt Status
Numeric 1
The status of the reconciliation statement associated with the transaction. Used only for transactions for a cash code that requires reconciliation statements. Valid values are: 1 = Open. 9 = Closed. Blank = Reconciliation statements not required.
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
CBT-BANK-SIGN
Element: GL Transaction Type
Derived
Indicates whether the transaction represents a bank debit or a bank credit.
CBT-RPT-ISSUE-AMT
Element: Report Issued Amount
Derived
The issued amount of the transaction stated as positive or negative.
CBT-RPT-RECON-AMT
Report Reconciled
Amount
Derived
The reconciled amount of the transaction stated as positive or negative.
CBT-DRILL-DOWN-STS
Element: Drill Down Status
Derived
The status of the transaction. Used for drill down display purposes.
CBT-RECON-VARIANCE
Reconciliation
Variance
Derived
The amount posted to the general ledger reconciliation variance account for the transaction.
CBT-SHORT-PAYEE
Element: Short Payee
Derived
A short vendor name for payments generated by Accounts Payable.
CBT-JBK-SEQ-NBR
Element: Jbk Seq Nbr
Numeric 10
The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-SOURCE
Element: Source
Alpha 1
The source of the transaction. Input or output. Input transactions are Accounts Payable. Output transactions are Accounts Receivable.
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
CBT-TAX-FLAG
Element: All Flag
Alpha 1

" " = Not interfaced
I = Interfaced
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
TX101
CBT-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
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
CBT-MAINT-TIME
Element: Maint Time
Numeric 6 (hhmmss)
The time last changed.
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
CBT-USER-FIELD1
Element: User Field1
Alpha 30
This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.
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
CBT-USER-FIELD2
Element: User Field2
Alpha 30
This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.
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
CBT-USER-FIELD3
Element: User Field1
Alpha 30
This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.
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
CBT-USER-FIELD4
Element: User Field2
Alpha 30
This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.
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
CBT-STALE-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
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
CBT-STL-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
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
CBT-STL-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
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
CBT-STL-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
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
CBT-CSR-STMT-NBR
Element: Recon Stmt Nbr
Numeric 12
The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.
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
CBT-CSR-STMT-SUFF
Element: Suffix Code
Alpha 5
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
CBT-CSR-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line 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
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBT-CSR-RECON-DESC
Element: Description 60
Alpha 60 (Lower Case)
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
CBT-CSR-TRANS-NBR
Element: Trans Nbr
Alpha 10 (Right Justified)
A unique, user-defined value used to identify 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
CBT-CREATED-BY
Element: Operator
Alpha 10
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
CBT-LAST-UPDT-DATE
Element: Date
Numeric 8 (yyyymmdd)
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
TX101
CBT-LAST-UPDT-TIME
Element: Time
Numeric 8
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
TX101
CBT-LAST-UPDATE-BY
Element: Operator
Alpha 10
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
TX101
CBT-RECON-SYSTEM
Element: Flag Num
Numeric 1
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


CBTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBTSET1 BANK-INST-CODE
TRANS-IDENT
...
AP10.1 AP10.2
AP100 AP109
AP110 AP111
AP115 AP125
AP126 AP14.1
AP14.2 AP14.5
AP150 AP151
AP16.1 AP16.2
AP160 AP161
AP170 AP180
AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
CBTSET10 CASH-CODE
CSR-STMT-NBR
CSR-STMT-SUFF
CSR-LINE-NBR
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
KeyChange
CB281 CB82.1
CBTSET11 CREATED-BY
CASH-CODE
BANK-INST-CODE
SOURCE-CODE
TRANS-NBR
SUFFIX
COMPANY
TRANS-IDENT
CB221
CBTSET2 CASH-CODE
PERIOD-DATE
BANK-INST-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
KeyChange
CB190 CB222
CBTSET3 CASH-CODE
BANK-INST-CODE
SOURCE-CODE
TRANS-NBR
SUFFIX
COMPANY
TRANS-IDENT
KeyChange
CB170 CB221
CB300
CBTSET4 BANK-INST-CODE
SERIAL-NUM
TRANS-IDENT
KeyChange, Subset
WhereSERIAL-NUM !=Zeroes
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
CBTSET5 REC-STATUS
COMPANY
CASH-CODE
BANK-INST-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
KeyChange
AP190 AP195
CB180 CB186
CB187 CB286
CBTSET6 CASH-CODE
BANK-INST-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
KeyChange
...
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
CB220 CB25.1
CB260 CB30.1
CB43.1 CB44.1
CB45.1 CB46.1
CBTSET7 CASH-CODE
ISSUE-DATE*
BANK-INST-CODE
SOURCE-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
KeyChange
CBTSET8 COMPANY
BANK-INST-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
KeyChange
CB195 TX101
CBTSET9 CASH-CODE
BANK-INST-CODE
CSR-STMT-NBR
CSR-STMT-SUFF
CSR-LINE-NBR
TRANS-NBR
TRANS-IDENT
KeyChange


CBTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
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"
AndCBT-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
Cbtransbod CBTRANSBOD Not Required, Delete Cascades
CBT-CASH-CODE->YCL-CASH-CODE
CBT-BANK-INST-CODE->YCL-BANK-INST-CODE
CBT-TRANS-NBR->YCL-TRANS-NBR
CBT-SUFFIX->YCL-SUFFIX
CBT-TRANS-IDENT->YCL-TRANS-IDENT
Cbtrfhdr CBTRFHDR Not Required
Valid When CBT-SOURCE-CODE ="CB"
AndCBT-REC-TYPE ="T"
CBT-CASH-CODE->CBH-CASH-CODE
CBT-TRANS-NBR->CBH-TRANSFER-NBR
Glsystem GLSYSTEM Required
CBT-COMPANY->GLS-COMPANY


CBTRANS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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
Cbtransaud CBTRANSAUD
CBT-BANK-INST-CODE->CAU-BANK-INST-CODE
CBT-TRANS-IDENT->CAU-TRANS-IDENT
  CAU-UNIQUE-I-D
Cbtrfdtl CBTRFDTL
CBT-CASH-CODE->CBL-DTL-CASH-CODE
CBT-TRANS-NBR->CBL-TRANSFER-NBR
  CBL-CASH-CODE


File created: Thu Jun 09 02:12:12 2016

Home
Contact Us



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