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
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
Reconciliation The bank-assigned reconciliation
Statement 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 Number This field contains the number that
represents a customer.
CSD-VENDOR Alpha 9 (Right Justified) CB06.2
Vendor ID 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 Nbr A number that is automatically assigned
to a bank statement cash receipt,
payment, or GL-type transaction.
CSD-ORIG-CURRENCY Alpha 5 CB06.2
Original 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
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
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
...
|
