CBSTMTDTL FILE The Bank Statement Detail file maintains detail records for bank transactions entered on the bank statement. It is updated by CB06.1 (Bank Statement) and CB06.2 (Bank Statement Detail Entry). REFERENCED BY CB191 AP170 AP180 AP181 AP190 AP255 AP265 AP55.1 AP81.1 AP90.5 AR115 AR124 AR20.1 AR21.1 AR21.2 AR21.3 AR21.4 AR24.1 AR30.1 AR30.2 AR30.4 AR570 AR575 AR580 AR82.1 CB10.1 CB15.1 CB15.2 CB180 CB185 CB190 CB20.1 CB30.1 CB500 CB80.1 DT180 DT181 DT185 DT92.1 UPDATED BY CB06.2 CB981 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY CSD-CASH-CODE Alpha 4 CB06.2 Cash Code A cash code represents a bank account. More than one company can use the same cash code. The cash code must be linked to a bank in the Lawson Cash Ledger system. CSD-RECON-STMT-NBR Numeric 12 CB06.2 Reconcilaition The bank-assigned reconciliation Statement Nbr statement number. Used only for cash codes that require reconciliation statements. CSD-LINE-NBR Numeric 6 CB06.2 Line Number This field contains the line number for the transaction. CSD-TRANS-TYPE Alpha 1 CB06.2 Transaction Type Type of transaction to be entered by user. Values are C (customer receipt), V (vendor payment), G (GL-type transaction), and R (reconciliation transaction). CSD-COMPANY Numeric 4 CB06.2 Company The company number represents an established company and is entered on all function codes. CSD-BANK-INST-CODE Alpha 3 CB06.2 Transaction Code A pay code or transaction code represents a type of bank transaction: cash payment, bill of exchange payment, or bank service transaction. CSD-CUSTOMER Alpha 9 (Right Justified) CB06.2 Customer This field contains the number that represents a customer. CSD-VENDOR Alpha 9 CB06.2 Vendor The vendor's identification code. CSD-REMIT-TO-CODE Alpha 4 CB06.2 Remit-To Location A user-defined code that represents a Code vendor's remittance address. CSD-PAYMENT-NBR Alpha 10 (Right Justified) CB06.2 Payment Number A number that is automatically assigned to a bank statement cash receipt, payment, or GL-type transaction. CSD-ORIG-CURRENCY Alpha 5 CB06.2 Base Currency The currency of the transaction. CSD-TRAN-AMT Signed 15.2 CB06.2 Transaction Amount The transaction amount in base currency. CSD-ORIG-AMT Signed 15.2 CB06.2 Original Amount The transaction amount in transaction currency. CSD-TRANS-DATE Numeric 8 (yyyymmdd) CB06.2 Transaction Date The date of the transaction. CSD-BATCH-NBR Numeric 6 CB06.2 Batch Number This identifies the batch the entered invoices, debit memos, and credit memos are a part of. CSD-PROC-LEVEL Alpha 5 CB06.2 Process Level The process level represents a reporting level below company. CSD-PAY-GROUP Alpha 4 CB06.2 CB981 Pay Group A pay group is used for processing accounts payable payments. A pay group lets you create a single payment for a vendor to pay invoices received by all company process levels assigned to the pay group. CBSTMTDTL FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN CSDSET1 CASH-CODE Used to access a specific detail line CB06.1 CB06.2 RECON-STMT-NBRfor a given statement number. CB191 CB981 LINE-NBR CSDSET2 BANK-INST-CODEUsed to determine if any detail lines AP170 AP180 RECON-STMT-NBRexist for a given payment code and AP181 AP190 PAYMENT-NBR statement number. AP255 AP265 TRANS-TYPE AP55.1 AP81.1 AP90.5 AR115 AR124 AR20.1 AR21.1 AR21.2 AR21.3 AR21.4 AR24.1 AR30.1 AR30.2 AR30.4 AR570 AR575 AR580 AR82.1 CB06.2 CB10.1 CB15.1 CB15.2 CB180 CB185 ... |