|
|
CBSTMTDTL FILE
Cash Staement Detail
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 AR32.1 AR34.1 AR570 AR575 AR580
AR82.1 CB10.1 CB145 CB15.1 CB15.2 CB150
CB180 CB186 CB187 CB190 CB20.1 CB25.1
CB46.1 CB500 CB543 CB544 DT180 DT181
DT185 DT92.1
UPDATED BY
CB06.2 CB185 CB30.1 CB80.1 CB82.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 CB82.1
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
Element: Recon Stmt NbrThe bank-assigned reconciliation CB30.1 CB80.1
statement number. Used only for cash CB82.1
codes that require reconciliation
statements.
CSD-LINE-NBR Numeric 6 CB06.2 CB185
Element: Line Nbr This field contains the line number. CB30.1 CB80.1
CB82.1
CSD-TRANS-TYPE Alpha 1 CB06.2 CB185
Element: Trans Type Determines if amounts or units are CB30.1 CB80.1
processed in each transaction. CB82.1
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 CB82.1
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: Bank Inst CodeA transaction code represents a type of CB30.1 CB80.1
cash payment, bill of exchange payment, CB82.1
or bank service transaction.
CSD-CUSTOMER Alpha 9 (Right Justified) CB06.2
Element: Customer This field contains the number that
represents a customer.
CSD-VENDOR Alpha 9 (Right Justified) CB06.2
Element: Vendor The vendor's identification code.
CSD-REMIT-TO-CODE Alpha 4 CB06.2
Element: Remit To Code A user-defined code that represents a
vendor's remittance address.
CSD-PAYMENT-NBR Alpha 10 (Right Justified) CB06.2 CB185
Element: Payment Nbr CB30.1 CB80.1
CB82.1
CSD-ORIG-CURRENCY Alpha 5 CB06.2 CB185
Element: Currency Code This field contains the company base CB30.1 CB80.1
currency code established in Company CB82.1
(GL10.1 ).
CSD-TRAN-AMT Signed 18.2 CB06.2 CB185
Element: Intl Amt CB30.1 CB80.1
CB82.1
CSD-ORIG-AMT Signed 18.2 CB06.2 CB185
Element: Intl Amt CB30.1 CB80.1
CB82.1
CSD-TRANS-DATE Numeric 8 (yyyymmdd) CB06.2 CB185
Element: Trans Date The date of the transaction. CB30.1 CB80.1
CB82.1
CSD-BATCH-NBR Numeric 6 CB06.2
Element: Batch Nbr 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 This field contains the process level,
which is the reporting hierarchy 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 CB82.1
transaction to make this record unique.
CBSTMTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSDSET1 CASH-CODE CB06.1 CB06.2
RECON-STMT-NBR CB191
LINE-NBR
CSDSET2 BANK-INST-CODEKeyChange AP170 AP180
RECON-STMT-NBR AP181 AP190
PAYMENT-NBR AP255 AP265
TRANS-TYPE 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
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
...
|
