|
|
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 AR32.1
AR34.1 AR570 AR575 AR580 AR82.1 CB10.1
CB145 CB15.1 CB15.2 CB150 CB180 CB186
CB187 CB190 CB20.1 CB25.1 CB43.1 CB44.1
CB46.1 CB500 CB543 CB544 DT180 DT181
DT185 DT92.1
UPDATED BY
CB06.1 CB06.2 CB185 CB191 CB30.1 CB80.1
CB82.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
Element: Recon Stmt NbrThe bank-assigned reconciliation
statement number. Used only for cash
codes that require reconciliation
statements.
CSM-RECON-STMT-DT Numeric 8 (yyyymmdd) CB06.1
Element: Recon Stmt Dt The date the reconciliation statement
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
Element: Recon Jrnl Bk The reconciliation journal book assigned
to the reconciliation statement.
CSM-STMT-STATUS Numeric 1 CB06.1 CB191
Element: Stmt Status The 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 This field contains the process level,
which is the reporting hierarchy 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: Curr Rate The currency rate.
CSM-CURR-MUDV Alpha 1 CB06.1
Element: Curr Mudv
CSM-ORIG-ND Numeric 1 CB06.1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
CSM-STMT-BAL-ENT Signed 18.2 CB06.2 CB185
Element: Intl Amt CB30.1 CB80.1
CB82.1
CSM-STMT-ENT-DR Signed 18.2 CB06.2 CB185
Element: Intl Amt CB30.1 CB80.1
CB82.1
CSM-STMT-ENT-CR Signed 18.2 CB06.2 CB185
Element: Intl Amt CB30.1 CB80.1
CB82.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: Bank Inst CodeA 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 Nbr 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: Nbr Lines This is the number of detail lines. CB30.1 CB80.1
CB82.1
CBSTATEMNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSMSET1 CASH-CODE AP170 AP180
RECON-STMT-NBR AP181 AP190
AP255 AP265
AP55.1 AP81.1
AP90.5 AR115
AR124 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR30.1 AR32.1
AR34.1 AR570
AR575 AR580
AR82.1 CB06.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
...
CSMSET2 CASH-CODE KeyChange, Subset
RECON-STMT-NBRWhere STMT-STATUS = 1
STMT-STATUS
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
|
