Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DTIDRAFTS


                             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 15.2                               DT52.1
Element: Adj 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
Element: Date          The bill of exchange creation date.

DTI-MATURITY-DATE      Numeric 8  (yyyymmdd)                     DT52.1
Element: 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 17                                  DT52.1  DT520
Element: Bank Account NThe bank-assigned account number
                       identification to be used for the cash
                       code.

DTI-ORIG-RATE          Signed 12.6                               DT52.1  DT520
Element: Account 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