Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TXRPTDIST


                             TXRPTDIST FILE

This file stores distribution line information. Distribution records may be
regular distribution lines(goods/servics) or tax distribtuions.

REFERENCED BY

TX226

UPDATED BY

TX101     TX301

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TDT-COMPANY            Numeric 4                                 TX101
Element: Company       The company number. The company must
                       alerady be defined in the General Ledger
                       system.

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

TDT-DOCUMENT           Alpha 27                                  TX101
Element: Document Nbr  The number assigned to the transaction
                       (invoice, credit memo, etc.) for which
                       the intrastat data was entered.

TDT-SUFFIX             Numeric 3                                 TX101
Element: Suffix        This is the suffix for the invoice.

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

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

TDT-SEQ-NBR            Numeric 4                                 TX101
Element: Seq Nbr       An 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       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-ACCT-UNIT          Alpha 15                                  TX101
Element: Acct Unit     The 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: Sub Acct      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

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

TDT-DIST-SEQ-NBR       Numeric 6                                 TX101
Element: Dist Seq Nbr  A unique sequence number.

                         TXRPTDIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

                         TXRPTDIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Txrpttrans     TXRPTTRANS

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