Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             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