Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APDISTCODE


                            APDISTCODE FILE

                        Distribution Code Detail

The Distribution Code Detail file contains distribution code detail records.
A distribution code detail record represents default information for one line
of expense distribution.

Each distribution code detail record is related to one record in the
Distribution Code Header file. More than one detail record can be associated
with the same header record.

Distribution codes are used to automatically create expense distributions or
expense distribution "shells" for invoices or to split invoice distributions
into multiple distribution lines.

REFERENCED BY

AP00.4    AP00.5    AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.7    AP205     AP23.1    AP520     DR100
IC141     IC142     IC83.1    MA41.2    MA43.2    MA43.7
MA43.8    MA43.9    PO101     PO21.3    PO27.2    PO32.1
PO520     RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ35.1
RQ500     RQID.1    RQIE.1    RQIF.1    RQIJ.1

UPDATED BY

AP05.3    AP305

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DTC-COMPANY            Numeric 4                                 AP05.3
Element: Company       The company number. Must be a valid
                       company in the Accounts Payable Company
                       file.

DTC-DIST-CODE          Alpha 9                                   AP05.3
Element: Distribution CA user-defined code used to
                       automatically create expense
                       distributions or expense distribution
                       "shells" for invoices or to split an
                       invoice distribution into multiple
                       distributions. Must be a valid record in
                       the Distribution Code Header file.

DTC-SEQ-NBR            Numeric 4                                 AP05.3
Element: Sequence NumbeA system-assigned sequence number used
                       to identify the distribution code detail
                       record.

DTC-DIST-COMPANY       Numeric 4                                 AP05.3
Element: Posting CompanThe company the expense distribution
                       should be posted to. Must be a valid
                       record in the General Ledger Company
                       file and a valid relationship must exist
                       in the Intercompany Relationship file.
                       If left blank, the company defaults.

DTC-DIS-ACCT-UNIT      Alpha 15                                  AP05.3
Distribution           The general ledger distribution
Accounting Unit        accounting unit used for posting the
                       expense distribution. Must be a valid
                       accounting unit in the Lawson General
                       Ledger system.

DTC-DIS-ACCOUNT        Numeric 6                                 AP05.3
Distribution           The general ledger distribution account
Account Number         number used for posting the expense
                       distribution. Must be a valid account
                       number in the Lawson General Ledger
                       system.

DTC-DIS-SUB-ACCT       Numeric 4                                 AP05.3
Distribution           The general ledger distribution
Subaccount Number      subaccount number used for posting the
                       expense distribution. Must be a valid
                       subaccount in the Lawson General Ledger
                       system.

DTC-TRAN-DIST-AMT      Signed 15.2                               AP05.3
Element: Adj Amt       The transaction amount for the
                       distribution. If entered, the Allocation
                       Percentage and Unit Amount fields must
                       be blank.

DTC-DIST-RATE          Signed 6.3                                AP05.3
Allocation             The percent of the invoice amount that
Percentage             should be allocated to the distribution.
                       If entered, the Distribution Amount and
                       Unit Amount fields must be blank.

DTC-ASSET-DESC         Alpha 30  (Lower Case)                    AP05.3
Element: Asset DescriptA description of the asset assigned to
                       the distribution, if assigned.

DTC-TAG-NBR            Alpha 12                                  AP05.3
Element: Tag           The tag number associated with the
                       distribution. Represents a short name
                       for a part of an asset.

DTC-ITEM-NBR           Alpha 32                                  AP05.3
Element: Item          The item number assigned to the
                       distribution. Represents one element of
                       an asset that is made up of multiple
                       elements, but is depreciated as a common
                       asset unit. If assigned, an Asset
                       Template must also be assigned to the
                       distribution.

DTC-ITEM-DESC          Alpha 30                                  AP05.3
Element: Item DescriptiThe item description.

DTC-ITEM-QUANTITY      Numeric 8                                 AP05.3
Element: Item Quantity The number of units that make up the
                       asset item. Each unit of an item is
                       exactly the same as every other unit of
                       the item.

DTC-ASSET-TEMPLATE     Alpha 10                                  AP05.3
Element: Asset TemplateThe asset template assigned to the
                       distribution. Represents asset
                       information used to create a record in
                       the Lawson Asset Management system. If
                       assigned, the Asset number field must be
                       blank.

DTC-MODEL-NUMBER       Alpha 30                                  AP05.3
Element: Model         The model number assigned to the
                       distribution. Used in conjunction with
                       the Asset Template field. If assigned,
                       an asset template must also be assigned
                       to the distribution.

DTC-SERIAL-NUMBER      Alpha 30                                  AP05.3
Element: Serial        The serial number assigned to the
                       distribution. Represents the serial
                       number of an asset. Used in conjunction
                       with the Asset Template field. If
                       assigned, an asset template must also be
                       assigned to the distribution.

DTC-HOLD-AM            Alpha 1                                   AP05.3
Element: Hold Asset    This field indicates whether to hold
                       the asset in the Asset Interface file.
                       Being held keeps items from becoming
                       assets until they are released from
                       hold. Valid values are:

                       N = No. Default.
                       Y = Yes.

DTC-ASSET              Numeric 10                                AP05.3
Element: Asset         The asset number assigned to the
                       distribution. Represents an asset
                       belonging to the company. If assigned,
                       the Asset Template, Model, Serial, Tag,
                       and Item fields must be blank.

DTC-ACTIVITY           Alpha 15                                  AP05.3  AP20.1
Element: Activity      The activity assigned to the              AP20.2  AP20.3
                       distribution. Used to group expense       AP20.4  AP20.5
                       distribution amounts to track costs for   AP20.7  AP23.1
                       projects, jobs, construction, and so on,  MA41.2  MA43.2
                       without having to define additional
                       general ledger account numbers. Must be
                       a valid activity in the Lawson Activity
                       Management system.

DTC-DST-REFERENCE      Alpha 10                                  AP05.3
Element: Cross Ref     The reference value assigned to the
                       distribution. If left blank, the default
                       reference value defined for the company
                       defaults.

DTC-DESCRIPTION        Alpha 30  (Lower Case)                    AP05.3
Element: Description   The distribution description. If left
                       blank, the vendor number and name
                       defaults on the distribution during
                       invoice entry.

DTC-ACCT-CATEGORY      Alpha 5                                   AP05.3  AP20.1
Element: Category      The account categories assigned to the    AP20.2  AP20.3
                       distribution.  Used with the Activity     AP20.4  AP20.5
                       field.                                    AP20.7  AP23.1
                                                                 MA41.2  MA43.2

DTC-UNT-AMOUNT         Signed 15.2                               AP05.3
Element: Unit Amount   The total units for the distribution.
                       If entered, the Distribution Amount and
                       Allocation Percentage fields must be
                       blank.

DTC-COMBINE            Alpha 10                                  AP05.3
Element: Combine Asset This field indicates whether to combine
                       items as one asset.

DTC-ASSET-GROUP        Alpha 10                                  AP05.3
Element: Asset Group   The asset group assigned to the
                       distribution.

DTC-ACCT-UNIT          Alpha 15                                  AP05.3
Element: Accounting UniThe accounting unit assigned to the
                       distribution, if assigned. Must be a
                       valid record in the Lawson General
                       Ledger system.

DTC-LOCATION-NAME      Alpha 15
Element: Destination

DTC-DIVISION           Alpha 15
Element: Division      A user-defined division which is used
                       for reporting assets.

                         APDISTCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DTCSET1   COMPANY       This index is used to access             AP00.4  AP00.5
          DIST-CODE     distribution code records.               AP05.3  AP20.1
          SEQ-NBR                                                AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP205
                                                                 AP23.1  AP305
                                                                 AP520   DR100
                                                                 IC141   IC142
                                                                 IC83.1  MA41.2
                                                                 MA43.2  MA43.7
                                                                 MA43.8  MA43.9
                                                                 PO101   PO21.3
                                                                 PO27.2  PO32.1
                                                                 PO520   RQ10.1
                                                                 RQ10.2  RQ10.3
                                                                 ...

                         APDISTCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            DTC-COMPANY          -> CPY-COMPANY

Apdisthdr      APDISTHDR    Required

                            DTC-COMPANY          -> HDR-COMPANY
                            DTC-DIST-CODE        -> HDR-DIST-CODE

Glmaster       GLMASTER     Required
                            When DTC-DIS-ACCT-UNIT != Spaces
                            Or   DTC-DIS-ACCOUNT   != Zeroes

                            DTC-COMPANY          -> GLM-COMPANY
                            DTC-DIS-ACCT-UNIT    -> GLM-ACCT-UNIT
                            DTC-DIS-ACCOUNT      -> GLM-ACCOUNT
                            DTC-DIS-SUB-ACCT     -> GLM-SUB-ACCOUNT