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    AP205     AP520     DR100     IC141
IC142     IC83.1    PO101     PO21.3    PO27.2    PO32.1
PO520     RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ35.1
RQ500     RQID.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 18.2                               AP05.3
Element: Intl 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
Element: Activity      The activity assigned to the
                       distribution. Used to group expense
                       distribution amounts to track costs for
                       projects, jobs, construction, and so on,
                       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
Element: Category      The account categories assigned to the
                       distribution.  Used with the Activity
                       field.

DTC-BILL-CATEGORY      Alpha 32
Element: Bill Category

DTC-UNT-AMOUNT         Signed 18.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
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                                  AP05.3
Element: Location Name A user-defined location name which
                       represents where an asset is physically
                       located. Locations are used to report
                       asset information.

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

DTC-AU-GROUP           Alpha 10                                  AP05.3
Element: Au Group      Accounting unit groups group and
                       identify the accounting units to use
                       when you create journal entries for
                       adding, adjusting, transferring, or
                       disposing of assets. Changes to
                       accounting unit groups are dynamic,
                       affecting all assets using the
                       accounting unit group. Accounting unit
                       group names are user-definable, and
                       accounting unit groups are set up by
                       company.

DTC-BAR-CODE           Alpha 30                                  AP05.3
Element: Bar Code

DTC-ITEM-LOC-DTL       Alpha 14                                  AP05.3
Element: Item Loc Dtl

                         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  AP205
          SEQ-NBR                                                AP305   AP520
                                                                 DR100   IC141
                                                                 IC142   IC83.1
                                                                 PO101   PO21.3
                                                                 PO27.2  PO32.1
                                                                 PO520   RQ10.1
                                                                 RQ10.2  RQ10.3
                                                                 RQ11.1  RQ35.1
                                                                 RQ500   RQID.1
                                                                 RQIF.1  RQIJ.1

                         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