Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
Company              The company number represents an
                     established company and is entered on
                     all function codes.


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

DTX-SUFFIX           Numeric 3                                   AR44.3  DT150
Invoice Suffix       This is the suffix for the invoice.

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

DTX-CANCEL-SEQ       Numeric 4                                   AR44.3  DT150
Cancel Sequence      The 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 5                                   AR44.3  DT150
App Seq

DTX-CR-COMPANY       Numeric 4                                   AR44.3  DT150
Cr Company

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

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

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

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

DTX-CR-CUSTOMER      Alpha 9  (Right Justified)                  AR44.3  DT150
Cr Customer

DTX-CR-APP-SEQ       Numeric 5                                   AR44.3  DT150
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