|
|
CBSTATEMNT FILE
Reconciliation Statement
The Reconciliation Statement file contains reconciliation statement header
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 CB733 CB953
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CSM-CASH-CODE Alpha 4 CB06.1 CB953
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 CB953
Reconciliation The bank-assigned reconciliation
Statement Nbr statement number. Used only for cash
codes that require reconciliation
statements.
CSM-RECON-STMT-DT Numeric 8 (yyyymmdd) CB06.1 CB953
Reconciliation The date the reconciliation statement
Statement Date was prepared.
CSM-BEGIN-BAL Signed 15.2 CB06.1 CB953
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 CB953
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 CB953
Reconciliation The reconciliation journal book
Journal Book assigned to the reconciliation
statement.
CSM-STMT-STATUS Numeric 1 CB06.1 CB191
Statement Status The status of the reconciliation CB953
statement. Valid values are:
1 = Open.
9 = Closed.
CSM-COMPANY Numeric 4 CB06.1 CB953
Company The company number represents an
established company and is entered on
all function codes.
CSM-PROC-LEVEL Alpha 5 CB06.2 CB953
Process Level The process level represents a
reporting level below company.
CSM-CURRENCY-CODE Alpha 5 CB06.1 CB953
Currency Code This field contains the company base
currency code established in GL10.1
(Company).
CSM-ORIG-RATE Signed 12.6 CB06.1 CB953
Original Exchange Original exchange rate. If the cash
Rate code currency is different from the
company base currency, you can specify
an exchange rate. If you do not, the
rate defined for the currency in the
Currency system defaults.
CSM-CURR-MUDV Alpha 1 CB06.1 CB953
Currency The currency multiply/divide indicator.
Multiply/Divide Indicates whether the currency exchange
rate is to be multiplied (M) or divided
(D) by the original transaction amount
to calculate the base currency amount.
CSM-ORIG-ND Numeric 1 CB06.1 CB953
Currency Decimal Currency decimal indicator.
Indicator
CSM-STMT-BAL-ENT Signed 15.2 CB06.2 CB953
Statement Balance The statement balance entered.
Entered
CSM-STMT-ENT-DR Signed 15.2 CB06.2 CB953
Statement Debits The statement debits entered.
Entered
CSM-STMT-ENT-CR Signed 15.2 CB06.2 CB953
Statement Credits The statement credits entered.
Entered
CSM-DEP-INST-CODE Alpha 3 CB06.1 CB953
Deposit The default transaction (pay) code for
Pay/Transaction Code cash deposits.
CSM-CHK-INST-CODE Alpha 3 CB06.1 CB953
Cash Paymt The default transaction (pay) code for
Pay/Transact Code cash payments.
CSM-BANK-INST-CODE Alpha 3 CB06.1 CB953
GL Trans The default transaction (pay) code for
Pay/Transaction Code GL-type transactions.
CSM-RECN-INST-CODE Alpha 3 CB06.1 CB953
Reconcile The default transaction (pay) code for
Pay/Transaction Code reconciliation transactions.
CSM-BATCH-NBR Numeric 6 CB06.2 CB953
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 CB953
Number of Detail This is the number of detail lines.
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
|