CBSTMTREC

REFERENCED BY
CB281


UPDATED BY
CB185 CB30.1 CB300 CB80.1 CB81.1 CB82.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CSR-STMT-NBR
Element: Recon Stmt Nbr
Numeric 12
The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.
CB81.1
CSR-STMT-SUFFIX
Element: Suffix Code
Alpha 5
CB81.1
CSR-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
CB81.1
CSR-BANK-ENTITY
Element: Bank Entity
Alpha 15
Represents a bank institution location.
CB81.1
CSR-BANK-ACCT-NBR
Element: Bank Acct Nbr
Alpha 35
The bank-assigned account number identification to be used for the cash code.
CB81.1
CSR-RECORD-TYPE
Element: Record Type
Alpha 1
This field identifies the type of record defined. Valid values are: S = Summary D = Detail
CB81.1
CSR-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.
CB185 CB81.1
CB82.1
CSR-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.
CB185 CB81.1
CB82.1
CSR-TRANS-NBR
Element: Trans Nbr
Alpha 10 (Right Justified)
A unique, user-defined value used to identify the transaction.
CB81.1
CSR-RECON-DATE
Element: Recon Date
Numeric 8 (yyyymmdd)
Represents the date the transaction cleared the bank or was voided.
CB81.1
CSR-RECON-AMT
Element: Intl Amt
Signed 18.2
CB81.1
CSR-FUNCTION
Element: Record Type
Alpha 1
This field identifies the type of record defined. Valid values are: S = Summary D = Detail
V = Void
R = Reconcile
" " = Reconcile
CB81.1
CSR-DESCRIPTION
Element: Description 60
Alpha 60 (Lower Case)
CB81.1
CSR-USER-FIELD1
Element: User Field1
Alpha 30
This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.
CB81.1
CSR-USER-FIELD2
Element: User Field2
Alpha 30
This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.
CB81.1
CSR-USER-FIELD3
Element: User Field1
Alpha 30
This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.
CB81.1
CSR-USER-FIELD4
Element: User Field2
Alpha 30
This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.
CB81.1
CSR-RECON-BAL
Element: Intl Amt
Signed 18.2
CB185 CB30.1
CB81.1 CB82.1
CSR-LINE-STATUS
Element: Record Type
Alpha 1
This field identifies the type of record defined. Valid values are: S = Summary D = Detail
" " = Open
C = Closed
CB185 CB30.1
CB80.1 CB81.1
CB82.1
CSR-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
CB81.1
CSR-MAINT-TIME
Element: Maint Time
Numeric 6 (hhmmss)
The time last changed.
CB81.1
CSR-OPERATOR
Element: Operator
Alpha 10
This field is used to store the login id of the person who entered the record.
CB81.1


CBSTMTREC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSRSET1 STMT-NBR
STMT-SUFFIX
LINE-NBR
CB185 CB30.1
CB300 CB80.1
CB81.1 CB82.1
CSRSET2 STMT-NBR
STMT-SUFFIX
LINE-NBR
LINE-STATUS
KeyChange
CB185 CB281
CSRSET3 LINE-STATUS
STMT-NBR
STMT-SUFFIX
LINE-NBR
KeyChange
CB185 CB281


CBSTMTREC FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbtrans CBTRANS
CSR-CASH-CODE->CBT-CASH-CODE
CSR-STMT-NBR->CBT-CSR-STMT-NBR
CSR-STMT-SUFFIX->CBT-CSR-STMT-SUFF
CSR-LINE-NBR->CBT-CSR-LINE-NBR
  CBT-BANK-INST-CODE
  CBT-TRANS-NBR
  CBT-TRANS-IDENT


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

Home
Contact Us



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