Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TXRPTDIST


                             TXRPTDIST FILE

REFERENCED BY

TX226

UPDATED BY

TX101     TX301

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TDT-COMPANY            Numeric 4                                 TX101
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.

TDT-SYSTEM-CD          Alpha 2                                   TX101
Element: System Code   This field indicates on what system the
                       transaction originated.

TDT-DOCUMENT           Alpha 27                                  TX101
Element: Document NumbeThis field identifies the document from
                       which this transaction record was
                       created.

TDT-SUFFIX             Numeric 3                                 TX101
Element: Invoice SuffixThis is the suffix for the invoice.

TDT-TRANS-TYPE         Alpha 1                                   TX101
Element: Transaction TyIdentifies the type of AR transaction:
                       I=Invoice
                       C=Credit memo
                       D=Debit memo
                       For non-AR documents, this field will be
                       a space.

TDT-SEQ-NBR            Numeric 4                                 TX101
Element: Sequence NumbeAn automatically assigned sequence
                       number.

TDT-TAX-CODE           Alpha 10                                  TX101
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


TDT-DIST-COMPANY       Numeric 4                                 TX101
Element: Company       The company number used for posting the
                       transaction. A valid intercompany
                       relationship must be defined in the
                       Lawson General Ledger system.

TDT-ACCT-UNIT          Alpha 15                                  TX101
Element: Accounting UniThe accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


TDT-ACCOUNT            Numeric 6                                 TX101
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

TDT-SUB-ACCT           Numeric 4                                 TX101
Element: Subaccount    This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

TDT-BASE-AMT           Signed 18.2                               TX101
Element: Intl Amt      This is the amount of the transaction in
                       the company base amount.

TDT-BASE-TAXABLE       Signed 18.2                               TX101
Element: Intl Amt

TDT-LINE-NBR           Numeric 6                                 TX101
Element: Line Number   This field contains the line number.

                         TXRPTDIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TDTSET1   COMPANY                                                TX226   TX301
          SYSTEM-CD
          DOCUMENT
          SUFFIX
          TRANS-TYPE
          SEQ-NBR

                         TXRPTDIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Txrpttrans     TXRPTTRANS   Required

                            TDT-COMPANY       -> TAS-COMPANY
                            TDT-SYSTEM-CD     -> TAS-SYSTEM-CD
                            TDT-DOCUMENT      -> TAS-DOCUMENT
                            TDT-SUFFIX        -> TAS-SUFFIX
                            TDT-TRANS-TYPE    -> TAS-TRANS-TYPE