CBSTATEMNT

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSMSET1 CASH-CODE
RECON-STMT-NBR
...
AP170 AP180
AP181 AP190
AP255 AP265
AP55.1 AP81.1
AP90.5 CB06.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB43.1 CB44.1
CB46.1 CB500
CSMSET2 CASH-CODE
RECON-STMT-NBR
STMT-STATUS
KeyChange, Subset
WhereSTMT-STATUS =1


CBSTATEMNT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:11:46 2016

Home
Contact Us



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