Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APDISTHDR


                             APDISTHDR FILE

                        Distribution Code Header

The Distribution Code Header file contains distribution code header records.
A distribution code header record has one or more related detail records in
the Distribution Code Detail file. A detail record represents default
information for one line of expense distribution.

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    AP00.3    AP10.5    AP10.1    AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP205
AP21.1    AP23.1    AP520     MA41.1    MA41.2    MA41.4
MA41.7    MA43.2    MA43.1    MA43.3    MA43.4    MA43.6
MA43.7    PD22.1    PO150     PO21.3    PO21.1    PO21.2
PO21.4    PO21.5    PO25.1    PO25.6    PO25.7    PO25.5
PO36.2    PO36.1    PO520     PO536     RQ10.1    RQ10.2
RQ10.3    RQ11.1    RQ35.1    RQ500     RQID.1    RQIF.1
RQIJ.1    AC160     AM115     AM117     AM15.1    AM15.2
AM15.3    AM15.4    AM19.1    AM19.2    AM20.1    AM20.3
AM21.1    AM21.3    AM500     AM51.1    AM551     AM97.1
AP03.3    AP110     AP115     AP125     AP126     AP131
AP210     AP220     AP25.1    AP25.2    AP26.1    AP27.1
AP30.2    AP30.4    AP510     AP90.1    AP91.1    API1.1
API2.1    API3.1    API4.1    BL120     BL122     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     BL92.1    MX123     MX500     MA180
MA279     MA530     MA531     MA60.2    MA60.3    MA60.5
MA61.1    MA63.1    MA65.1    MA66.2    MA66.3    MA67.2
MA67.3    MA68.2    MA68.3    MA68.5    MA70.1    MA75.1
MA80.1    MAI1.1    PD10.1    PD10.2    PD130     PD20.1
PD20.2    PD20.3    PD235     PO10.1    PO100     PO101
PO120     PO122     PO131     PO20.1    PO22.1    PO220
PO223     PO23.1    PO233     PO24.1    PO253     PO254
PO27.2    PO278     PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO32.4    PO33.1
PO34.1    PO35.1    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO54.1    PO54.2    PO54.3    PO54.4
POI3.1    POID.1    POII.1    POIJ.1    PR05.1    PR05.3
PR226     PR247     PR26.1    PR47.1    PR514     UK47.1
WH20.2    WH20.7

UPDATED BY

AP05.3    AP305

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

HDR-DIST-CODE          Alpha 9                                   AP05.3
Element: Dist Code     A user-defined code used to
                       automatically create expense
                       distributions or expense distribution
                       "shells" for invoices or to split an
                       invoice distribution into multiple
                       distributions.

HDR-DESCRIPTION        Alpha 30  (Lower Case)                    AP05.3
Element: Description   The distribution code description.

HDR-ACCT-EDIT-FLAG     Alpha 1                                   AP05.3
Element: Edit Accounts Indicates whether to edit general
                       ledger accounting units and account
                       numbers when the distribution code is
                       defined or during invoice entry. Valid
                       values are:

                       C = Code and Invoice Entry. The
                       Accounting Unit and Account Number
                       fields are required and are validated
                       when a distribution code is defined.

                       I = Invoice Entry Only. Accounting Unit
                       and Account Number fields are not
                       required when a distribution code is
                       defined, but will be validated if either
                       is entered. Any account information left
                       blank is entered and validated during
                       invoice entry.
                       S = Service Invoice

HDR-ACCT-UNIT-FLAG     Alpha 1                                   AP05.3
Element: Accounting UniUsed only if Invoice Entry is selected
                       in the Edit Accounts field. Indicates
                       whether the Accounting Unit field in the
                       Accounting Unit subform in AP20.1 (Basic
                       Invoice) or AP20.2 (Taxed Invoice) is
                       required during invoice entry. Valid
                       values are:

                       Y = Yes.
                       N = No.

HDR-ACCOUNT-FLAG       Alpha 1                                   AP05.3
Element: Account Flag  Used only if Invoice Entry is selected
                       in the Edit Accounts field. Indicates
                       whether the Account number fields in the
                       Account subform in AP20.1 (Basic
                       Invoice) or AP20.2 (Taxed Invoice) are
                       required during invoice entry. Valid
                       values are:

                       Y = Yes.
                       N = No.

HDR-TOTAL-PERCENT      Signed 6.3                                AP05.3
Element: Percent Total The total percent defined for the
                       distribution code. This is a sum of all
                       distribution code detail records
                       associated with the distribution code
                       header record.


HDR-TOTAL-TRAN-AMT     Signed 18.2                               AP05.3
Element: Amount Total  The total distribution amount defined
                       for the distribution code. This is the
                       sum of all distribution code detail
                       records associated with the distribution
                       code header record.


HDR-TOTAL-UNIT         Signed 15.2                               AP05.3
Element: Unit Total    The total units defined for the
                       distribution code. This is the sum of
                       all distribution code detail records
                       defined for the distribution code header
                       record.


HDR-VENDOR-GROUP       Alpha 4                                   AP05.3
Element: Vendor Group  The vendor group associated with the
                       distribution code company.

                         APDISTHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HDRSET1   COMPANY                                                AP00.4  AP00.5
          DIST-CODE                                              AP05.3  AP10.5
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP205   AP21.1
                                                                 AP23.1  AP305
                                                                 AP520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PD22.1  PO150
                                                                 PO21.3  PO25.1
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO520
                                                                 PO536   RQ10.1
                                                                 ...

HDRSET2   VENDOR-GROUP  KeyChange                                AC160   AM115
          DIST-CODE                                              AM117   AM15.1
          COMPANY                                                AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP00.3
                                                                 AP03.3  AP10.1
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 ...

HDRSET3   DIST-CODE     KeyChange                                AP205
          COMPANY

                         APDISTHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            HDR-COMPANY      -> CPY-COMPANY

                         APDISTHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apdistcode     APDISTCODE   Delete Cascades

                            HDR-COMPANY      -> DTC-COMPANY
                            HDR-DIST-CODE    -> DTC-DIST-CODE
                                                DTC-SEQ-NBR