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
AP23.1    AP520     MA41.2    MA43.2    PO150     PO25.1
PO25.6    PO25.7    PO36.2    PO536     AM115     AM15.1
AM15.2    AM15.3    AM15.4    AM20.1    AM20.3    AM21.1
AM21.3    AM500     AM51.1    AM551     AM97.1    AP110
AP510     API3.1    API4.1    IC840     PR05.1    PR05.3
PR226     PR247     PR26.1    PR47.1    PR514     UK47.1

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: 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.

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 15.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       This index is used by the Distribution   AP00.4  AP00.5
          DIST-CODE     Code entry screen to maintain            AP05.3  AP10.5
                        distribution code header records within  AP20.1  AP20.2
                        an Accounts Payable company.             AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP205   AP23.1
                                                                 AP305   AP520
                                                                 MA41.2  MA43.2
                                                                 PO150   PO25.1
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536

HDRSET2   VENDOR-GROUP  This index is used by the Vendor online  AM115   AM15.1
          DIST-CODE     screen to verify distribution code       AM15.2  AM15.3
          COMPANY       header records within an Accounts        AM15.4  AM20.1
                        Payable vendor group.                    AM20.3  AM21.1
                        KeyChange                                AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP00.3
                                                                 AP10.1  AP110
                                                                 AP510   API3.1
                                                                 API4.1  IC840
                                                                 PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514   UK47.1

HDRSET3   DIST-CODE     This index is used by the Accounts       AP205
          COMPANY       Payable Codes Listing program to print
                        distribution code header records.
                        KeyChange

                         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