|
|
CBSTMTDTL FILE
The Bank Statement Detail file maintains detail records for bank transactions
entered on the bank statement. It is updated by CB06.1 (Bank Statement) and
CB06.2 (Bank Statement Detail Entry).
REFERENCED BY
CB191 AP170 AP180 AP181 AP190 AP255
AP265 AP55.1 AP81.1 AP90.5 AR115 AR124
AR20.1 AR21.1 AR21.2 AR21.3 AR21.4 AR24.1
AR30.1 AR30.2 AR30.4 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.2 CB185 CB30.1 CB80.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CSD-CASH-CODE Alpha 4 CB06.2 CB185
Accounts Receivable CB30.1 CB80.1
Code
CSD-RECON-STMT-NBR Numeric 12 CB06.2 CB185
Reconciliation The bank-assigned reconciliation CB30.1 CB80.1
Statement statement number. Used only for cash
codes that require reconciliation
statements.
CSD-LINE-NBR Numeric 6 CB06.2 CB185
Element: Line Number This field contains the line number for CB30.1 CB80.1
the transaction.
CSD-TRANS-TYPE Alpha 1 CB06.2 CB185
Element: Transaction TyType of transaction to be entered by CB30.1 CB80.1
user. Values are C (customer receipt), V
(vendor payment), G (GL-type
transaction), and R (reconciliation
transaction).
CSD-COMPANY Numeric 4 CB06.2 CB185
Element: Company The company number represents an CB30.1 CB80.1
established company and is entered on
all function codes.
CSD-BANK-INST-CODE Alpha 3 CB06.2 CB185
Element: Transaction CoA pay code or transaction code CB30.1 CB80.1
represents a type of bank transaction:
cash payment, bill of exchange payment,
or bank service transaction.
CSD-CUSTOMER Alpha 9 (Right Justified) CB06.2
Element: Customer NumbeThis field contains the number that
represents a customer.
CSD-VENDOR Alpha 9 (Right Justified) CB06.2
Element: Vendor ID The vendor's identification code.
CSD-REMIT-TO-CODE Alpha 4 CB06.2
Purchase From
Location Code
CSD-PAYMENT-NBR Alpha 10 (Right Justified) CB06.2 CB185
Element: Payment Nbr A number that is automatically assigned CB30.1 CB80.1
to a bank statement cash receipt,
payment, or GL-type transaction.
CSD-ORIG-CURRENCY Alpha 5 CB06.2 CB185
To Company Base The currency of the transaction. CB30.1 CB80.1
Currency
CSD-TRAN-AMT Signed 15.2 CB06.2 CB185
Element: Adj Amt The transaction amount in base CB30.1 CB80.1
currency.
CSD-ORIG-AMT Signed 15.2 CB06.2 CB185
Element: Adj Amt The transaction amount in transaction CB30.1 CB80.1
currency.
CSD-TRANS-DATE Numeric 8 (yyyymmdd) CB06.2 CB185
Element: Date CB30.1 CB80.1
CSD-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.
CSD-PROC-LEVEL Alpha 5 CB06.2
Element: Process Level
CSD-PAY-GROUP Alpha 4 CB06.2
Element: Pay Group A pay group is used for processing
accounts payable payments. A pay group
lets you create a single payment for a
vendor to pay invoices received by all
company process levels assigned to the
pay group.
CBSTMTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSDSET1 CASH-CODE Used to access a specific detail line CB06.1 CB06.2
RECON-STMT-NBRfor a given statement number. CB191
LINE-NBR
CSDSET2 BANK-INST-CODEUsed to determine if any detail lines AP170 AP180
RECON-STMT-NBRexist for a given payment code and AP181 AP190
PAYMENT-NBR statement number. AP255 AP265
TRANS-TYPE KeyChange AP55.1 AP81.1
CASH-CODE AP90.5 AR115
AR124 AR20.1
AR21.1 AR21.2
AR21.3 AR21.4
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
...
|
