|
|
CBSTMTREC FILE
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 Numeric 12 CB81.1
Element: Recon Stmt NbrThe bank-assigned reconciliation
statement number. Used only for cash
codes that require reconciliation
statements.
CSR-STMT-SUFFIX Alpha 5 CB81.1
Element: Suffix Code
CSR-LINE-NBR Numeric 6 CB81.1
Element: Line Nbr This field contains the line number.
CSR-BANK-ENTITY Alpha 15 CB81.1
Element: Bank Entity Represents a bank institution location.
CSR-BANK-ACCT-NBR Alpha 35 CB81.1
Element: Bank Acct Nbr The bank-assigned account number
identification to be used for the cash
code.
CSR-RECORD-TYPE Alpha 1 CB81.1
Element: Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
CSR-CASH-CODE Alpha 4 CB185 CB81.1
Element: Cash Code A cash code represents a bank account. CB82.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.
CSR-BANK-INST-CODE Alpha 3 CB185 CB81.1
Element: Bank Inst CodeA transaction code represents a type of CB82.1
cash payment, bill of exchange payment,
or bank service transaction.
CSR-TRANS-NBR Alpha 10 (Right Justified) CB81.1
Element: Trans Nbr A unique, user-defined value used to
identify the transaction.
CSR-RECON-DATE Numeric 8 (yyyymmdd) CB81.1
Element: Recon Date Represents the date the transaction
cleared the bank or was voided.
CSR-RECON-AMT Signed 18.2 CB81.1
Element: Intl Amt
CSR-FUNCTION Alpha 1 CB81.1
Element: Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
V = Void
R = Reconcile
" " = Reconcile
CSR-DESCRIPTION Alpha 60 (Lower Case) CB81.1
Element: Description 60
CSR-USER-FIELD1 Alpha 30 CB81.1
Element: User Field1 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.
CSR-USER-FIELD2 Alpha 30 CB81.1
Element: User Field2 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.
CSR-USER-FIELD3 Alpha 30 CB81.1
Element: User Field1 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.
CSR-USER-FIELD4 Alpha 30 CB81.1
Element: User Field2 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.
CSR-RECON-BAL Signed 18.2 CB185 CB30.1
Element: Intl Amt CB81.1 CB82.1
CSR-LINE-STATUS Alpha 1 CB185 CB30.1
Element: Record Type This field identifies the type of CB80.1 CB81.1
record defined. CB82.1
Valid values are:
S = Summary
D = Detail
" " = Open
C = Closed
CSR-MAINT-DATE Numeric 8 (yyyymmdd) CB81.1
Element: Maint Date The date last changed.
CSR-MAINT-TIME Numeric 6 (hhmmss) CB81.1
Element: Maint Time The time last changed.
CSR-OPERATOR Alpha 10 CB81.1
Element: Operator This field is used to store the login
id of the person who entered the record.
CBSTMTREC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSRSET1 STMT-NBR CB185 CB30.1
STMT-SUFFIX CB300 CB80.1
LINE-NBR CB81.1 CB82.1
CSRSET2 STMT-NBR KeyChange CB185 CB281
STMT-SUFFIX
LINE-NBR
LINE-STATUS
CSRSET3 LINE-STATUS KeyChange CB185 CB281
STMT-NBR
STMT-SUFFIX
LINE-NBR
CBSTMTREC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbtrans CBTRANS
CSR-CASH-CODE -> CBT-CASH-CODE
CSR-BANK-INST-CODE -> CBT-BANK-INST-CODE
CSR-STMT-NBR -> CBT-CSR-STMT-NBR
CSR-STMT-SUFFIX -> CBT-CSR-STMT-SUFF
CSR-LINE-NBR -> CBT-CSR-LINE-NBR
CBT-TRANS-NBR
CBT-TRANS-IDENT
|
