|
|
CBSTATEMNT FILE
Reconciliation Statement
The Reconciliation Statement file contains reconciliation statement records
for cash codes that require statements to be reconciled.
REFERENCED BY
AP170 AP180 AP181 AP190 AP255 AP265
AP55.1 AP81.1 AP90.5 AR115 AR124 AR20.1
AR21.1 AR21.2 AR21.3 AR24.1 AR30.1 AR30.2
AR30.4 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.1 CB06.2 CB185 CB191 CB30.1 CB80.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CSM-CASH-CODE Alpha 4 CB06.1
Accounts Receivable The cash code. Represents the bank
Code account that requires reconciliation
statements. Must be a valid record in
the Cash Code file and must have Yes
selected in the Reconciliation Statement
Required field.
CSM-RECON-STMT-NBR Numeric 12 CB06.1
Reconciliation The bank-assigned reconciliation
Statement statement number. Used only for cash
codes that require reconciliation
statements.
CSM-RECON-STMT-DT Numeric 8 (yyyymmdd) CB06.1
Element: Date The date the reconciliation statement
was prepared.
CSM-BEGIN-BAL Signed 15.2 CB06.1
Element: Current BalancThe beginning balance for reconciliation
statement. Represents the balance before
the first transaction listed on the
statement.
CSM-END-BAL Signed 15.2 CB06.1
Element: Current BalancThe ending balance for the
reconciliation statement. Represents the
balance after the last transaction
listed on the statement.
CSM-RECON-JRNL-BK Alpha 12 CB06.1
Reconciliation The reconciliation journal book assigned
Journal Book to the reconciliation statement.
CSM-STMT-STATUS Numeric 1 CB06.1 CB191
Element: Statement StatThe status of the reconciliation
statement. Valid values are:
1 = Open.
9 = Closed.
CSM-COMPANY Numeric 4 CB06.1
Element: Company The company number represents an
established company and is entered on
all function codes.
CSM-PROC-LEVEL Alpha 5 CB06.2
Element: Process Level
CSM-CURRENCY-CODE Alpha 5 CB06.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
CSM-ORIG-RATE Signed 12.6 CB06.1
Element: Account Rate
CSM-CURR-MUDV Alpha 1 CB06.1
Currency
Multiply/Divide
CSM-ORIG-ND Numeric 1 CB06.1
Account Currency
Code
CSM-STMT-BAL-ENT Signed 15.2 CB06.2 CB185
Element: Stmt Bal Ent CB30.1 CB80.1
CSM-STMT-ENT-DR Signed 15.2 CB06.2 CB185
Element: Stmt Ent Dr CB30.1 CB80.1
CSM-STMT-ENT-CR Signed 15.2 CB06.2 CB185
Element: Stmt Ent Cr CB30.1 CB80.1
CSM-DEP-INST-CODE Alpha 3 CB06.1
Element: Transaction Code
CSM-CHK-INST-CODE Alpha 3 CB06.1
Element: Chk Inst Code
CSM-BANK-INST-CODE Alpha 3 CB06.1
Element: Transaction CoA transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
CSM-RECN-INST-CODE Alpha 3 CB06.1
Element: Recn Inst Code
CSM-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.
CSM-NBR-LINES Numeric 6 CB06.2 CB185
Element: Line Number CB30.1 CB80.1
CBSTATEMNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSMSET1 CASH-CODE This index is used to access and AP170 AP180
RECON-STMT-NBRvalidate a bank statement record for a AP181 AP190
given cash code. AP255 AP265
AP55.1 AP81.1
AP90.5 AR115
AR124 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR30.1 AR30.2
AR30.4 AR570
AR575 AR580
AR82.1 CB06.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
...
CSMSET2 CASH-CODE This index is used to access only open
RECON-STMT-NBRbank statement records.
STMT-STATUS KeyChange, Subset
Where STMT-STATUS = 1
CBSTATEMNT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbstmtdtl CBSTMTDTL Delete Restricted
CSM-CASH-CODE -> CSD-CASH-CODE (CSDSET1)
CSM-RECON-STMT-NBR -> CSD-RECON-STMT-NBR
CSD-LINE-NBR
|
