Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DTCREDIT


                             DTCREDIT FILE

REFERENCED BY

AR37.8    DT170     DT180     DT181     DT92.1

UPDATED BY

AR44.3    DT150     DT45.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DTX-COMPANY            Numeric 4                                 AR44.3  DT150
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.

DTX-AR-DRAFT-NBR       Alpha 22                                  AR44.3  DT150
Element: Ar Draft Nbr

DTX-SUFFIX             Numeric 3                                 AR44.3  DT150
Element: Invoice SuffixThis is the suffix for the invoice.

DTX-CUSTOMER           Alpha 9  (Right Justified)                AR44.3  DT150
Element: Customer NumbeThis field contains the number that
                       represents a customer.

DTX-CANCEL-SEQ         Numeric 4                                 AR44.3  DT150
Element: Sequence NumbeThe sequence number assigned upon a       DT45.1
                       cancellation of a distributed invoice.
                       The first sequence assigned is 9999.

DTX-DRAFT-SOURCE       Alpha 1                                   AR44.3  DT150
Bill of Exchange       This defines origination of the bill of
Source                 exchange.

DTX-APP-SEQ            Numeric 7                                 AR44.3  DT150
Element: App Seq

DTX-CR-COMPANY         Numeric 4                                 AR44.3  DT150
Element: Company

DTX-CR-TYPE            Alpha 1                                   AR44.3  DT150
Element: Cr Type

DTX-CR-NBR             Alpha 22                                  AR44.3  DT150
Element: Credit Memo Number

DTX-CR-BATCH           Numeric 6                                 AR44.3  DT150
Element: Cr Batch

DTX-CR-PYMNT-SEQ       Numeric 6                                 AR44.3  DT150
Element: Cr Pymnt Seq

DTX-CR-CUSTOMER        Alpha 9  (Right Justified)                AR44.3  DT150
Element: Customer Number

DTX-CR-APP-SEQ         Numeric 7                                 AR44.3  DT150
Element: Cr App Seq

                         DTCREDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DTXSET1   COMPANY                                                AR37.8  DT170
          AR-DRAFT-NBR                                           DT180   DT181
          SUFFIX                                                 DT45.1  DT45.2
          CUSTOMER                                               DT92.1
          CANCEL-SEQ
          DRAFT-SOURCE
          APP-SEQ

DTXSET2   CR-COMPANY
          CR-TYPE
          CR-NBR
          CR-BATCH
          CR-PYMNT-SEQ
          CR-APP-SEQ

                         DTCREDIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arapplied      ARAPPLIED    Required

                            DTX-CR-COMPANY      -> ARA-COMPANY  (ARASET1)
                            DTX-CR-TYPE         -> ARA-TRANS-TYPE
                            DTX-CR-NBR          -> ARA-INVOICE
                            DTX-CR-PYMNT-SEQ    -> ARA-PAYMENT-SEQ
                            DTX-CR-BATCH        -> ARA-BATCH-NBR
                            DTX-CR-APP-SEQ      -> ARA-APP-SEQ

Ardrafts       ARDRAFTS     Required

                            DTX-COMPANY         -> ARD-COMPANY
                            DTX-AR-DRAFT-NBR    -> ARD-AR-DRAFT-NBR
                            DTX-SUFFIX          -> ARD-SUFFIX
                            DTX-CUSTOMER        -> ARD-CUSTOMER
                            DTX-CANCEL-SEQ      -> ARD-CANCEL-SEQ
                            DTX-DRAFT-SOURCE    -> ARD-DRAFT-SOURCE

Aroitems       AROITEMS     Required

                            DTX-CR-COMPANY      -> ARO-COMPANY
                            DTX-CR-TYPE         -> ARO-TRANS-TYPE
                            DTX-CR-NBR          -> ARO-INVOICE
                            DTX-CR-PYMNT-SEQ    -> ARO-PAYMENT-SEQ