Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DTIDRAFTS


                             DTIDRAFTS FILE

UPDATED BY

DT52.1    DT520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DTI-COMPANY            Numeric 4                                 DT52.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

DTI-CUSTOMER           Alpha 9  (Right Justified)                DT52.1
Element: Customer      This field contains the number that
                       represents a customer.

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

DTI-SUFFIX             Numeric 3                                 DT52.1
Element: Suffix        This is the 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        This field displays the status of the
                       transaction.

DTI-DRAFT-AMOUNT       Signed 18.2                               DT52.1
Element: Intl Amt

DTI-CURRENCY-CODE      Alpha 5                                   DT52.1  DT520
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

DTI-DRAFT-DATE         Numeric 8  (yyyymmdd)                     DT52.1  DT520
Element: Draft Date    The field contains the bill of exchange
                       creation date.

DTI-MATURITY-DATE      Numeric 8  (yyyymmdd)                     DT52.1
Element: Maturity Date The remittance due date.  Indicates when
                       the remittance is due to be paid in
                       full.

DTI-PROCESS-LEVEL      Alpha 5                                   DT52.1
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

DTI-BANK-INST-CODE     Alpha 3                                   DT52.1
Element: Bank Inst CodeA transaction code represents a type of
                       cash payment, bill of exchange payment,
                       or bank service transaction.

DTI-JRNL-BOOK-NBR      Alpha 12                                  DT52.1
Element: Jrnl Book Nbr The journal book assigned to the
                       transaction.

DTI-BANK-ENTITY        Alpha 15                                  DT52.1  DT520
Element: Bank Entity   Represents a bank institution location.


DTI-BANK-ACCT-NBR      Alpha 35                                  DT52.1  DT520
Element: Bank Acct Nbr The bank-assigned account number
                       identification to be used for the cash
                       code.


DTI-ORIG-RATE          Signed 14.7                               DT52.1  DT520
Element: Orig Rate

DTI-PAYER-REF          Alpha 10                                  DT52.1
Element: Payer Ref

DTI-XREF-NBR           Alpha 22                                  DT52.1
Element: Xref Nbr

                         DTIDRAFTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DTISET1   COMPANY                                                DT52.1  DT520
          CUSTOMER
          AR-DRAFT-NBR
          SUFFIX