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 Company The AR company number to which the records are interfaced.. DTI-CUSTOMER Alpha 9 (Right Justified) DT52.1 Customer The customer associated with the bill of exchange. DTI-DRAFT-NBR Alpha 10 (Right Justified) DT52.1 DT520 Bill of Exchange The number assigned to the bill of Number exchange. DTI-SUFFIX Numeric 3 DT52.1 Suffix The suffix for the invoice. DTI-ACTION-CODE Alpha 10 Action Code This field contains the personnel action code. DTI-STATUS Numeric 1 DT52.1 Status The bill of exchange status. Can be 0 - Created 5 - Created/Unreleased 8 - Canceled DTI-DRAFT-AMOUNT Signed 15.2 DT52.1 Bill of Exchange The bill of exchange amount. Amount DTI-CURRENCY-CODE Alpha 5 DT52.1 DT520 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 Maturity Date The bill of exchange maturity date. DTI-PROCESS-LEVEL Alpha 5 DT52.1 Process Level The process level assigned to the transaction. DTI-BANK-INST-CODE Alpha 3 DT52.1 Bank Payment Code The payment code (transcation code) assigned to the transaction; must have a type of BOE. DTI-JRNL-BOOK-NBR Alpha 12 DT52.1 Journal Book Number The journal book assigned to the transaction. DTI-BANK-ENTITY Alpha 15 DT52.1 DT520 Bank Entity The customer's bank. DTI-BANK-ACCT-NBR Alpha 17 DT52.1 DT520 Bank Account Number The bank-assigned account number identification to be used for the cash code. DTI-ORIG-RATE Signed 12.6 DT52.1 DT520 Currency Rate The currency exchange rate. DTI-PAYER-REF Alpha 10 DT52.1 Payer Reference User-entered bank reference information.. DTI-XREF-NBR Alpha 10 DT52.1 Cross-Reference 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. DRAFT-NBR SUFFIX |