CBSTMTDTL

Cash Staement Detail
UPDATED BY
AP170 AP180 AP181 AP190 AP255 AP265
AP55.1 AP81.1 AP90.5 CB06.1 CB06.2 CB10.1
CB145 CB15.1 CB15.2 CB150 CB180 CB185
CB186 CB187 CB190 CB191 CB20.1 CB20.6
CB25.1 CB30.1 CB46.1 CB500 CB543 CB544
CB80.1 CB82.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CSD-CASH-CODE
Element: Cash Code
Alpha 4
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.
CB06.2 CB185
CB30.1 CB80.1
CB82.1
CSD-RECON-STMT-NBR
Element: Recon Stmt Nbr
Numeric 12
The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.
CB06.2 CB185
CB30.1 CB80.1
CB82.1
CSD-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
CB06.2 CB185
CB30.1 CB80.1
CB82.1
CSD-TRANS-TYPE
Element: Trans Type
Alpha 1
Determines if amounts or units are processed in each transaction.
CB06.2 CB185
CB30.1 CB80.1
CB82.1
CSD-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
CB06.2 CB185
CB30.1 CB80.1
CB82.1
CSD-BANK-INST-CODE
Element: Bank Inst Code
Alpha 3
A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.
CB06.2 CB185
CB30.1 CB80.1
CB82.1
CSD-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
CB06.2
CSD-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
CB06.2
CSD-REMIT-TO-CODE
Element: Remit To Code
Alpha 4
A user-defined code that represents a vendor's remittance address.
CB06.2
CSD-PAYMENT-NBR
Element: Payment Nbr
Alpha 10 (Right Justified)
CB06.2 CB185
CB30.1 CB80.1
CB82.1
CSD-ORIG-CURRENCY
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
CB06.2 CB185
CB30.1 CB80.1
CB82.1
CSD-TRAN-AMT
Element: Intl Amt
Signed 18.2
CB06.2 CB185
CB30.1 CB80.1
CB82.1
CSD-ORIG-AMT
Element: Intl Amt
Signed 18.2
CB06.2 CB185
CB30.1 CB80.1
CB82.1
CSD-TRANS-DATE
Element: Trans Date
Numeric 8 (yyyymmdd)
The date of the transaction.
CB06.2 CB185
CB30.1 CB80.1
CB82.1
CSD-BATCH-NBR
Element: Batch Nbr
Numeric 6
This identifies the batch the entered invoices, debit memos, and credit memos are a part of.
CB06.2
CSD-PROC-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
CB06.2
CSD-PAY-GROUP
Element: Pay Group
Alpha 4
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.
CB06.2
CSD-TRANS-IDENT
Element: Trans Ident
Numeric 10
A unique system-generated identification value assigned to the transaction to make this record unique.
CB06.2 CB185
CB30.1 CB80.1
CB82.1


CBSTMTDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSDSET1 CASH-CODE
RECON-STMT-NBR
LINE-NBR
CB06.1 CB06.2
CB191
CSDSET2 BANK-INST-CODE
RECON-STMT-NBR
PAYMENT-NBR
TRANS-TYPE
CASH-CODE
LINE-NBR
KeyChange
...
AP170 AP180
AP181 AP190
AP255 AP265
AP55.1 AP81.1
AP90.5 CB06.2
CB10.1 CB145
CB15.1 CB15.2
CB150 CB180
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1


File created: Thu Jun 09 11:11:46 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.