|
|
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 AR34.1
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
Element: 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 18.2 CB06.1
Element: Intl Amt The beginning balance for reconciliation
statement. Represents the balance before
the first transaction listed on the
statement.
CSM-END-BAL Signed 18.2 CB06.1
Element: Intl Amt 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
Element: Statement StatThe status of the reconciliation
statement. Valid values are:
1 = Open.
9 = Closed.
CSM-COMPANY Numeric 4 CB06.1
Element: Company 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.
CSM-PROC-LEVEL Alpha 5 CB06.2
Element: Process Level The process level represents a
reporting level below company.
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 14.7 CB06.1
Element: Currency Rate
CSM-CURR-MUDV Alpha 1 CB06.1
Currency
Multiply/Divide
CSM-ORIG-ND Numeric 1 CB06.1
Account Currency Currency decimal indicator.
Code
CSM-STMT-BAL-ENT Signed 18.2 CB06.2 CB185
Element: Intl Amt CB30.1 CB80.1
CSM-STMT-ENT-DR Signed 18.2 CB06.2 CB185
Element: Intl Amt CB30.1 CB80.1
CSM-STMT-ENT-CR Signed 18.2 CB06.2 CB185
Element: Intl Amt CB30.1 CB80.1
CSM-DEP-INST-CODE Alpha 3 CB06.1
Element: Dep Inst 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: Number of LineThis is the number of detail lines. 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 AR34.1
AR570 AR575
AR580 AR82.1
CB06.1 CB06.2
CB10.1 CB15.1
CB15.2 CB180
CB185 CB190
...
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
|
