|
|
DTCASHING FILE
AR Bank Cashing Charges
The AR Bank Cashing Charges file contains expenses associated with a bank
account (cash code).
UPDATED BY
DT180 DT181 DT80.4 DT90.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DTS-CASH-CODE Alpha 4 DT80.4 DT90.3
Element: Cash Code A cash code represents a specific bank
account at a bank location. Must be a
valid record in the Cash Ledger Cash Cod
file.
DTS-BANK-INST-CODE Alpha 3 DT80.4 DT90.3
Element: Payment Code The bank service transaction code used
to identify the type of expenses. Must
be a valid record in the Cash Ledger
Bank Transaction Code file.
DTS-TRAN-DATE Numeric 8 (yyyymmdd) DT80.4 DT90.3
Element: GL Posting DatThe general ledger posting date
assigned to the charges.
DTS-SEQ-NBR Numeric 4 DT80.4 DT90.3
Element: Seq Nbr This field contains the sequence
number, which is incremented if
duplicate records exist when a new
record is created.
DTS-COMPANY Numeric 4 DT80.4 DT90.3
Element: Company The company number represents an
established company. Must be a valid
record in the AR Company file.
DTS-TRAN-EXP-AMT Signed 18.2 DT80.4 DT90.3
Base Currency The amount of the bank expense in the
Expense Amount company base currency.
DTS-ORIG-EXP-AMT Signed 18.2 DT80.4 DT90.3
Transaction Curr The amount of the bank expense in the
Expense Amt currency of the bank account.
DTS-EXP-ACCT-UNIT Alpha 15 DT80.4 DT90.3
Element: Acct Unit The distribution accounting unit used
for posting the bank expense to the
general ledger.
DTS-EXP-ACCOUNT Numeric 6 DT80.4 DT90.3
Expense Account The distribution account number used
Number for posting the bank expense to the
general ledger.
DTS-EXP-SUB-ACCT Numeric 4 DT80.4 DT90.3
Expense Subaccount The distribution subaccount number used
Number for posting the bank expense to the
general ledger.
DTS-TRAN-ADMIN-AMT Signed 18.2 DT80.4 DT90.3
Base Curr Admin The administration expense amount in
Expense Amount the company base currency.
DTS-ORIG-ADMIN-AMT Signed 18.2 DT80.4 DT90.3
Administration The administration expense amount in
Expense Amount the currency of the bank account.
DTS-ADMN-ACCT-UNIT Alpha 15 DT80.4 DT90.3
Admin Expense The accounting unit used for posting
Accounting Unit the administration expense to the
general ledger.
DTS-ADMN-ACCOUNT Numeric 6 DT80.4 DT90.3
Admin Expense The account number used for posting the
Account Number administration expense to the general
ledger.
DTS-ADMN-SUB-ACCT Numeric 4 DT80.4 DT90.3
Admin Expense The subaccount number used for posting
Subaccount Nbr the administration expense to the
general ledger.
DTS-EXCHANGE-RATE Signed 14.7 DT80.4 DT90.3
Element: Acct Rate The exchange rate used to convert a
bank account currency amount to the
company base currency.
DTS-CURRENCY-CD Alpha 5 DT80.4 DT90.3
Bank Account The currency code assigned to the cash
Currency code. Represents the currency of the
bank account. Must be a valid record in
the Currency Code file.
DTS-GL-UPDATE-FL Alpha 1 DT180 DT181
General Ledger Indicates whether accounts receivable DT80.4 DT90.3
Update Flag distribution records have been created
by DT180 (Bank Presentation, Cashing
Update). Valid values are:
N = No
Y = Yes
DTS-TRANS-IDENT Numeric 10 DT180 DT181
Element: Transaction IDA unique, system-generated
identification value assigned to the
transaction to make this record unique.
DTS-JRNL-BOOK-NBR Alpha 12
Element: Journal Book NThis field contains the journal book
number.
DTCASHING FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DTSSET1 CASH-CODE DT180 DT181
BANK-INST-CODE DT80.4 DT90.3
TRAN-DATE
SEQ-NBR
DTSSET2 BANK-INST-CODEKeyChange, Subset
TRANS-IDENT Where BANK-INST-CODE != Spaces
And TRANS-IDENT != Zeroes
|
