|
|
DTIDRAFTS FILE
The Bill of Exchange Interface file contains bill of exchange records from an
external source. The record format facilitates a non-bank format. The records
from this file are interfaced using DT520 (Draft Interface). Records in this
file can be maintained in DT52.1 (Draft Interface Maintenance) to comply with
edit requirements of DT520.
UPDATED BY
DT52.1 DT520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DTI-COMPANY Numeric 4 DT52.1
Element: Company The AR company number to which the
records are interfaced..
DTI-CUSTOMER Alpha 9 (Right Justified) DT52.1
Element: Customer NumbeThe customer associated with the bill of
exchange.
DTI-AR-DRAFT-NBR Alpha 22 DT52.1 DT520
Element: Ar Draft Nbr
DTI-SUFFIX Numeric 3 DT52.1
Element: Invoice SuffixThe suffix for the invoice.
DTI-ACTION-CODE Alpha 10
Element: Action Code This field contains the personnel
action code.
DTI-STATUS Numeric 1 DT52.1
Element: Status The bill of exchange status. Can be
0 - Created
5 - Created/Unreleased
8 - Canceled
DTI-DRAFT-AMOUNT Signed 18.2 DT52.1
Element: Intl Amt The bill of exchange amount.
DTI-CURRENCY-CODE Alpha 5 DT52.1 DT520
Element: Currency Code The company's base currency code
established in GL10.1 (Company).
DTI-DRAFT-DATE Numeric 8 (yyyymmdd) DT52.1 DT520
Bill of Exchange The bill of exchange creation date.
Date
DTI-MATURITY-DATE Numeric 8 (yyyymmdd) DT52.1
Element: Maturity Date The bill of exchange maturity date.
DTI-PROCESS-LEVEL Alpha 5 DT52.1
Element: Process Level The process level assigned to the
transaction.
DTI-BANK-INST-CODE Alpha 3 DT52.1
Element: Transaction CoThe payment code (transcation code)
assigned to the transaction; must have a
type of BOE.
DTI-JRNL-BOOK-NBR Alpha 12 DT52.1
Element: Journal Book The journal book assigned to the
transaction.
DTI-BANK-ENTITY Alpha 15 DT52.1 DT520
Element: Bank The customer's bank.
DTI-BANK-ACCT-NBR Alpha 35 DT52.1 DT520
Element: Bank Account NThe bank-assigned account number
identification to be used for the cash
code.
DTI-ORIG-RATE Signed 14.7 DT52.1 DT520
Element: Orig Rate The currency exchange rate.
DTI-PAYER-REF Alpha 10 DT52.1
Element: Payer Ref User-entered bank reference
information..
DTI-XREF-NBR Alpha 22 DT52.1
Element: Xref Nbr the open item transaction to which the
draft payment is to be applied, if
applicable.
DTIDRAFTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DTISET1 COMPANY Used to access bill of exchange DT52.1 DT520
CUSTOMER interface records by draft number.
AR-DRAFT-NBR
SUFFIX
|
