CBTRANS – Bank Transaction

System: Cash Ledger (CB)
Prefix: CBT
Primary key: BANK-INST-CODE, TRANS-IDENT
Fields: 73
Updated by: 36 programs
Referenced by: 95 programs

CBTRANS is the Bank Transaction table in Lawson Cash Ledger (prefix CBT). It is indexed by BANK-INST-CODE, TRANS-IDENT (CBTSET1); alternate indexes: CBTSET10, CBTSET11, CBTSET2, CBTSET3, CBTSET4, CBTSET5, CBTSET6, CBTSET7 and 2 more. It is related 1:1 to APDRAFTS, ARPYMNTHDR, CBADJUST, CBBALANCE, CBBANKENT, CBBANKINST, CBCASHCODE, CBCPYCASH and 6 more and 1:M to APAPPHIST, APPAYMENT, CBCHECK, CBDISTRIB, CBFTTRANS, CBPAYMENT, CBRECPTDTL, CBTRANSAUD and 1 more. It is updated by AP170, AP180, AP181, AP190, AP195, AP255, AP265, AP81.1 and 28 more and referenced by AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 and 87 more. The table has 73 fields, 11 indexes and 24 documented relations.

About CBTRANS

The Bank Transaction file contains Cash Ledger bank transaction records.

Fields (73)

Column = COBOL field name without the CBT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`CBT-CASH-CODE` 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 +22 more
`CBT-BANK-INST-CODE` PK BANK_INST_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 +22 more
`CBT-TRANS-NBR` TRANS_NBR	Alpha 10 (Right Justified)	A unique number used to identify the bank transaction.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-SUFFIX` SUFFIX	Numeric 3	The transaction suffix number. Represents the occurrence value of the transaction.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-BANK-INST-TYPE` BANK_INST_TYPE	Alpha 1	Indicates the type of bank transaction (based on the transaction code assigned to the transaction). Valid values are: Transaction. `C` Cash Payment Transaction. `D` Bill of Exchange Payment `B` Bank Service Transaction.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-SOURCE-CODE` 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 +22 more
`CBT-COMPANY` 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 +22 more
`CBT-VENDOR` 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 +22 more
`CBT-CUSTOMER` 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 +22 more
`CBT-EMPLOYEE` 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 +22 more
`CBT-TRANS-IDENT` PK TRANS_IDENT	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 +22 more
`CBT-PROC-LEVEL` PROC_LEVEL	Alpha 5	The process level associated with the bank transaction. If the Source Code 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 must be a valid record in the Cash Deposit Process Level file. `field` AP, must be a valid record in `field` CB, this field may be blank or	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-ISSUE-DATE` ISSUE_DATE	Numeric 8 (yyyymmdd)	The date of the transaction.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-RECON-DATE` 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 +22 more
`CBT-ISSUE-BNK-AMT` ISSUE_BNK_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 +22 more
`CBT-ISSUE-BASE-AMT` ISSUE_BASE_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 +22 more
`CBT-RECON-BNK-AMT` RECON_BNK_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 +22 more
`CBT-RECON-BASE-AMT` RECON_BASE_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 +22 more
`CBT-TRAN-ND` TRAN_ND	Numeric 1	The number of decimal places defined for the bank account currency.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-BASE-ND` 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 +22 more
`CBT-BNK-TRANS-SIGN` BNK_TRANS_SIGN	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 +22 more
`CBT-ORIG-CNV-RATE` ORIG_CNV_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 +22 more
`CBT-RECON-CNV-RATE` RECON_CNV_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 +22 more
`CBT-ISSUE-TRAN-AMT` ISSUE_TRAN_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 +22 more
`CBT-BNK-CNV-RATE` BNK_CNV_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 +22 more
`CBT-BANK-ND` BANK_ND	Numeric 1	The number of decimal places defined for the bank account currency.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-CURRENCY-CODE` CURRENCY_CODE	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 +22 more
`CBT-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The description of the transaction.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-REFERENCE` 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 +22 more
`CBT-PERIOD-DATE` 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 +22 more
`CBT-LAST-DIST-SEQ` LAST_DIST_SEQ	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 +22 more
`CBT-REC-STATUS` 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 +23 more
`CBT-REINSTATE-FL` REINSTATE_FL	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 +22 more
`CBT-PRINT-STATUS` PRINT_STATUS	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 +22 more
`CBT-DIST-APPLIED` DIST_APPLIED	Signed 18.2	The total distribution amount applied to the transaction in the currency of the bank account. If the Source Code released until the total distribution amount equals the transaction amount. `field` CB, the transaction cannot be	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-BASE-APPLIED` BASE_APPLIED	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 +22 more
`CBT-DIST-DATE` 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 +22 more
`CBT-SERIAL-NUM` SERIAL_NUM	Numeric 8	A system-generated number used to group tape payment transactions.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-SUMMARY-OPTION` SUMMARY_OPTION	Alpha 1	Indicates whether the transaction is a summarized tape payment record. Valid values are: record. `Y` Yes. `Blank` Not a summarized tape payment	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-REC-TYPE` 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 +22 more
`CBT-PAY-GROUP` PAY_GROUP	Alpha 4	The pay group associated with the transaction. Used only if the Source in the Pay Group file. `Code field` AP. Must be a valid record	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	The journal book assigned to the transaction.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-RECON-STMT-NBR` 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 +22 more
`CBT-STMT-STATUS` 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: required. `1` Open. `9` Closed. `Blank` Reconciliation statements not	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-BANK-SIGN` BANK_SIGN	Derived	Indicates whether the transaction represents a bank debit or a bank credit.	—
`CBT-RPT-ISSUE-AMT` RPT_ISSUE_AMT	Derived	The issued amount of the transaction stated as positive or negative.	—
`CBT-RPT-RECON-AMT` RPT_RECON_AMT	Derived	The reconciled amount of the transaction stated as positive or negative.	—
`CBT-DRILL-DOWN-STS` DRILL_DOWN_STS	Derived	The status of the transaction. Used for drill down display purposes.	—
`CBT-RECON-VARIANCE` RECON_VARIANCE	Derived	The amount posted to the general ledger reconciliation variance account for the transaction.	—
`CBT-SHORT-PAYEE` SHORT_PAYEE	Derived	A short vendor name for payments generated by Accounts Payable.	—
`CBT-JBK-SEQ-NBR` 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 +22 more
`CBT-SOURCE` 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 +22 more
`CBT-TAX-FLAG` TAX_FLAG	Alpha 1	" " = Not interfaced `I` Interfaced	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +23 more
`CBT-MAINT-DATE` MAINT_DATE	Numeric 8 (yyyymmdd)	The date last changed.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-MAINT-TIME` MAINT_TIME	Numeric 6 (hhmmss)	The time last changed.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-USER-FIELD1` 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 +22 more
`CBT-USER-FIELD2` 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 +22 more
`CBT-USER-FIELD3` USER_FIELD3	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 +22 more
`CBT-USER-FIELD4` USER_FIELD4	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 +22 more
`CBT-STALE-DATE` STALE_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-STL-ACCT-UNIT` STL_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 +22 more
`CBT-STL-ACCOUNT` STL_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 +22 more
`CBT-STL-SUB-ACCT` STL_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 +22 more
`CBT-CSR-STMT-NBR` CSR_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 +22 more
`CBT-CSR-STMT-SUFF` CSR_STMT_SUFF	Alpha 5	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-CSR-LINE-NBR` CSR_LINE_NBR	Numeric 6	This field contains the line number.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-CSR-RECON-DESC` CSR_RECON_DESC	Alpha 60 (Lower Case)	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-CSR-TRANS-NBR` CSR_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 +22 more
`CBT-CREATED-BY` CREATED_BY	Alpha 10	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBT-LAST-UPDT-DATE` LAST_UPDT_DATE	Numeric 8 (yyyymmdd)	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +23 more
`CBT-LAST-UPDT-TIME` LAST_UPDT_TIME	Numeric 8	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +23 more
`CBT-LAST-UPDATE-BY` LAST_UPDATE_BY	Alpha 10	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +23 more
`CBT-RECON-SYSTEM` RECON_SYSTEM	Numeric 1	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more

Indexes (11)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`CBTSET1`	`BANK-INST-CODE`, `TRANS-IDENT`	Primary		AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source)
`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	Where SERIAL-NUM != Zeroes	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`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 +22 more (list truncated in source)
`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		—

Relations

One to one (15) — lookups and parents

Relation	Table	Rules	Condition	Field map
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" 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`
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" And CBT-REC-TYPE = "T"	`CBT-CASH-CODE` → `CBH-CASH-CODE`, `CBT-TRANS-NBR` → `CBH-TRANSFER-NBR`
Glsystem	GLSYSTEM	Required		`CBT-COMPANY` → `GLS-COMPANY`

One to many (9) — child tables

Relation	Table	Field map
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`

Programs

Updated by (36)

AP170 Payment Closing
AP180 Bill of Exchange Cashing Update
AP181 Bill of Exchange Statement Update
AP190 Invoice Reinstatement
AP195 Period Closing
AP255 Bank Account Payment History
AP265 Cash Payment Register
AP81.1 Manual Forms Reservation
AP90.5 Cash Payment Inquiry
CB06.2 Bank Statement Detail Entry
CB10.1 Cash Receipt Deposit
CB145 EFT Extract Update
CB15.1 Bank Fund Transfer - Multiple Deposits
CB15.2 Bank Fund Transfer - Multiple Withdrawals
CB150 Mass Release
CB170 Positive Pay File Creation
CB180 Cash Ledger Void Update
CB185 Bank Tape Mass Reconciliation
CB186 Stale Dating Processing
CB187 Stale Dating Reopen Update
CB190 Bank Period Close
CB191 Bank Statement Close
CB195 Company Period Close
CB20.1 Bank Transaction Entry
CB20.6 Bank Transaction DIstribution
CB222 Cash Position Reconciliation
CB25.1 Manual Reconciliation Entry
CB30.1 Reconciliation Variance Adjustment
CB300 History Purge
CB46.1 Returned Payment Entry
CB500 Bank Transaction Interface
CB543 Receipts Load
CB544 Returned Payment Load
CB80.1 Bank Transaction Adjustment
CB82.1 Statement Reconciliation
TX101 Journal File Create

Referenced by (95)

AP10.1 Vendor
AP10.2 Vendor Location
AP100 Vendor Group Copy
AP109 Vendor Current Address Update
AP110 Mass Vendor Update
AP111 Vendor Deletion
AP115 Vendor Merge
AP125 Batch Release
AP126 Mass Invoice Release
AP14.1 Vendor Contact
AP14.2 Vendor Contact Address
AP14.5 1099 Tax Identification Information
AP150 Cash Requirements
AP151 Bill of Exchange Generation
AP16.1 Vendor Bank
AP16.2 Vendor Location Bank
AP160 Payment Tape Creation
AP161 Electronic Payment File Creation
AP193 Recurring Invoice Update
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.6 Prepayment
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP25.1 Batch Control
AP25.2 Batch Review
AP26.1 Invoice Release
AP27.1 Single Invoice Release
AP28.1 Bill of Exchange Acceptance by Vendor
AP28.2 Bill of Exchange Acceptance by Date
AP30.1 Invoice Maintenance
AP30.2 Distribution Adjustments
AP30.4 Invoice Cancel
AP300 Invoice and Vendor History Purge
AP305 Accounts Payable Company Purge
AP510 Vendor Conversion
AP520 Invoice Interface
AP590 AP Vendor CSV
API1.1 Add Invoice
API2.1 Add Invoice
CB00.1 Bank
CB175 Bank Transaction Posting
CB220 Bank History Report
CB221 Bank Transaction Listing
CB260 Cash Account Activity
CB281 Reconciliation Statement List
CB286 Stale Dating and Escheatment Report
CB43.1 Receipts Load Maintenance
CB44.1 Returned Payment Maintenance
CB45.1 EFT/CC Extract Entry
CB50.1 Bank Transaction Interface Maintenance
CB90.4 Bank Transactions
CBOD.1 CB BOD Maintenance
CBOD.2 CB BOD Inquiry
EE135 Mass Employee Release
EE20.1 Employee Advance
EE20.2 Employee Expense
EE35.1 Advance Release
EE35.2 Expense Release
EE520 Expense Interface
IC64.6 Global Location Number Assignment Vendor
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.1 Memo Line Detail - Purchase Order
MA42.2 Memo Line AOC Detail
MA43.1 Invoice Line Detail - Purchase Order
MA43.2 Purchase Order Lookup
MA43.3 Invoice Line Detail - Receipt
MA43.4 Invoice Line Detail - Service
MA43.6 Service Agreement Detail
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA60.2 Invoice Level Match
MA60.3 Detail Level Match
MA60.4 Invoice Match Reference Adjustment
MA61.1 Match Invoice Approval
MA64.6 Message Detail by Invoice
MA64.9 PO Cost Message Accept Upload
MA65.1 Invoice Line Adjustment
MA66.1 Review Invoice Message
MA66.2 Invoice Message - Details
MA66.3 Purchase Order Cost Review Message
MA67.3 Detail Match from frontend
MA68.2 Invoice Level Match - Prepaid
MA68.4 Invoice Match Reference Adjustment
MA70.1 Invoice Unmatch
MA75.1 PO Invoice Cancel
MAED.1 Vendor
MAI1.1 Invoke for MAMATCH Object