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	CB10.1	CB145	CB15.1
CB15.2	CB150	CB180	CB186	CB187	CB190
CB20.1	CB20.6	CB25.1	CB43.1	CB44.1	CB46.1
CB500	CB543	CB544

UPDATED BY

CB06.1	CB06.2	CB185	CB191	CB30.1	CB80.1
CB82.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CSM-CASH-CODE Element: Cash Code	Alpha 4 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.	CB06.1
CSM-RECON-STMT-NBR Element: Recon Stmt Nbr	Numeric 12 The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.	CB06.1
CSM-RECON-STMT-DT Element: Recon Stmt Dt	Numeric 8 (yyyymmdd) The date the reconciliation statement was prepared.	CB06.1
CSM-BEGIN-BAL Element: Intl Amt	Signed 18.2 The beginning balance for reconciliation statement. Represents the balance before the first transaction listed on the statement.	CB06.1
CSM-END-BAL Element: Intl Amt	Signed 18.2 The ending balance for the reconciliation statement. Represents the balance after the last transaction listed on the statement.	CB06.1
CSM-RECON-JRNL-BK Element: Recon Jrnl Bk	Alpha 12 The reconciliation journal book assigned to the reconciliation statement.	CB06.1
CSM-STMT-STATUS Element: Stmt Status	Numeric 1 The status of the reconciliation statement. Valid values are: 1 = Open. 9 = Closed.	CB06.1 CB191
CSM-COMPANY Element: Company	Numeric 4 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.	CB06.1
CSM-PROC-LEVEL Element: Process Level	Alpha 5 This field contains the process level, which is the reporting hierarchy below company.	CB06.2
CSM-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).	CB06.1
CSM-ORIG-RATE Element: Curr Rate	Signed 14.7 The currency rate.	CB06.1
CSM-CURR-MUDV Element: Curr Mudv	Alpha 1	CB06.1
CSM-ORIG-ND Element: Acct Nd	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.	CB06.1
CSM-STMT-BAL-ENT Element: Intl Amt	Signed 18.2	CB06.2 CB185 CB30.1 CB80.1 CB82.1
CSM-STMT-ENT-DR Element: Intl Amt	Signed 18.2	CB06.2 CB185 CB30.1 CB80.1 CB82.1
CSM-STMT-ENT-CR Element: Intl Amt	Signed 18.2	CB06.2 CB185 CB30.1 CB80.1 CB82.1
CSM-DEP-INST-CODE Element: Dep Inst Code	Alpha 3	CB06.1
CSM-CHK-INST-CODE Element: Chk Inst Code	Alpha 3	CB06.1
CSM-BANK-INST-CODE Element: Bank Inst Code	Alpha 3 A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.	CB06.1
CSM-RECN-INST-CODE Element: Recn Inst Code	Alpha 3	CB06.1
CSM-BATCH-NBR Element: Batch Nbr	Numeric 6 This identifies the batch the entered invoices, debit memos, and credit memos are a part of.	CB06.2
CSM-NBR-LINES Element: Nbr Lines	Numeric 6 This is the number of detail lines.	CB06.2 CB185 CB30.1 CB80.1 CB82.1

CBSTATEMNT FILE INDEX

CBSTATEMNT FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.