Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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 Number      The customer associated with the bill of
                     exchange.

DTI-AR-DRAFT-NBR     Alpha 22                                    DT52.1  DT520
Ar Draft Nbr

DTI-SUFFIX           Numeric 3                                   DT52.1
Invoice 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
Transaction 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         The journal book assigned to the
                     transaction.

DTI-BANK-ENTITY      Alpha 15                                    DT52.1  DT520
Bank                 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
Orig Rate            The currency exchange rate.

DTI-PAYER-REF        Alpha 10                                    DT52.1
Payer Ref            User-entered bank reference
                     information..

DTI-XREF-NBR         Alpha 22                                    DT52.1
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