|
|
CBSTMTDTL FILE
Cash Staement Detail
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 AR34.1 AR570 AR575 AR580 AR82.1
CB10.1 CB15.1 CB15.2 CB180 CB190 CB20.1
CB25.1 CB500 DT180 DT181 DT185 DT92.1
UPDATED BY
CB06.2 CB185 CB30.1 CB80.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CSD-CASH-CODE Alpha 4 CB06.2 CB185
Element: Cash Code A cash code represents a bank account. CB30.1 CB80.1
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 CB185
Reconciliation The bank-assigned reconciliation CB30.1 CB80.1
Statement statement number. Used only for cash
codes that require reconciliation
statements.
CSD-LINE-NBR Numeric 6 CB06.2 CB185
Element: Line Number This field contains the line number for CB30.1 CB80.1
the transaction.
CSD-TRANS-TYPE Alpha 1 CB06.2 CB185
Element: Transaction TyType of transaction to be entered by CB30.1 CB80.1
user. Values are C (customer receipt), V
(vendor payment), G (GL-type
transaction), and R (reconciliation
transaction).
CSD-COMPANY Numeric 4 CB06.2 CB185
Element: Company Identifies the AP company if the CB30.1 CB80.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
CSD-BANK-INST-CODE Alpha 3 CB06.2 CB185
Element: Transaction CoA pay code or transaction code CB30.1 CB80.1
represents a type of bank transaction:
cash payment, bill of exchange payment,
or bank service transaction.
CSD-CUSTOMER Alpha 9 (Right Justified) CB06.2
Element: Customer NumbeThis field contains the number that
represents a customer.
CSD-VENDOR Alpha 9 (Right Justified) CB06.2
Element: 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 CB185
Element: Payment Nbr A number that is automatically assigned CB30.1 CB80.1
to a bank statement cash receipt,
payment, or GL-type transaction.
CSD-ORIG-CURRENCY Alpha 5 CB06.2 CB185
Element: Currency Code The currency of the transaction. CB30.1 CB80.1
CSD-TRAN-AMT Signed 18.2 CB06.2 CB185
Element: Intl Amt The transaction amount in base CB30.1 CB80.1
currency.
CSD-ORIG-AMT Signed 18.2 CB06.2 CB185
Element: Intl Amt The transaction amount in transaction CB30.1 CB80.1
currency.
CSD-TRANS-DATE Numeric 8 (yyyymmdd) CB06.2 CB185
Element: Transaction DaThe date of the transaction. CB30.1 CB80.1
CSD-BATCH-NBR Numeric 6 CB06.2
Element: 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
Element: Process Level The process level represents a
reporting level below company.
CSD-PAY-GROUP Alpha 4 CB06.2
Element: 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.
CSD-TRANS-IDENT Numeric 10 CB06.2 CB185
Element: Trans Ident A unique system-generated CB30.1 CB80.1
identification value assigned to the
transaction to make this record unique.
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 KeyChange AP55.1 AP81.1
CASH-CODE AP90.5 AR115
LINE-NBR AR124 AR20.1
AR21.1 AR21.2
AR21.3 AR21.4
AR24.1 AR30.1
AR34.1 AR570
AR575 AR580
AR82.1 CB06.2
CB10.1 CB15.1
CB15.2 CB180
CB185 CB190
...
|
