Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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    AP110     AP510
API3.1    API4.1    IC840

UPDATED BY

AP05.3    AP305

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

HDR-DIST-CODE        Alpha 9                                     AP05.3
Distribution 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
Description          The distribution code description.

HDR-ACCT-EDIT-FLAG   Alpha 1                                     AP05.3
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.

HDR-ACCT-UNIT-FLAG   Alpha 1                                     AP05.3
Accounting Unit Flag Used 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
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
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
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
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
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

HDRSET2   VENDOR-GROUP  This index is used by the Vendor online  AP00.3  AP10.1
          DIST-CODE     screen to verify distribution code       AP110   AP510
          COMPANY       header records within an Accounts        API3.1  API4.1
                        Payable vendor group.                    IC840
                        KeyChange

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