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 CB185 CB190 CB20.1
CB30.1 CB500 CB80.1 DT180 DT181 DT185
DT92.1
UPDATED BY
CB06.1 CB06.2 CB191
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CSM-CASH-CODE Alpha 4 CB06.1
Cash Code The cash code. Represents the bank
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
Reconciliation The date the reconciliation statement
Statement Date was prepared.
CSM-BEGIN-BAL Signed 15.2 CB06.1
Beginning Balance The beginning balance for reconciliation
statement. Represents the balance before
the first transaction listed on the
statement.
CSM-END-BAL Signed 15.2 CB06.1
Ending Balance The 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
Statement Status The status of the reconciliation
statement. Valid values are:
1 = Open.
9 = Closed.
CSM-COMPANY Numeric 4 CB06.1
Company The company number represents an
established company and is entered on
all function codes.
CSM-PROC-LEVEL Alpha 5 CB06.2
Process Level The process level represents a
reporting level below company.
CSM-CURRENCY-CODE Alpha 5 CB06.1
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
CSM-ORIG-RATE Signed 12.6 CB06.1
Orig Rate
CSM-CURR-MUDV Alpha 1 CB06.1
Currency
Multiply/Divide
CSM-ORIG-ND Numeric 1 CB06.1
Orig Nd Currency decimal indicator.
CSM-STMT-BAL-ENT Signed 15.2 CB06.2
Stmt Bal Ent
CSM-STMT-ENT-DR Signed 15.2 CB06.2
Stmt Ent Dr
CSM-STMT-ENT-CR Signed 15.2 CB06.2
Stmt Ent Cr
CSM-DEP-INST-CODE Alpha 3 CB06.1
Dep Inst Code
CSM-CHK-INST-CODE Alpha 3 CB06.1
Chk Inst Code
CSM-BANK-INST-CODE Alpha 3 CB06.1
Transaction Code A transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
CSM-RECN-INST-CODE Alpha 3 CB06.1
Recn Inst Code
CSM-BATCH-NBR Numeric 6 CB06.2
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
Number of Lines This is the number of detail lines.
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 Duplicates, 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
|
