|
|
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
AP10.5 AP10.1 AP20.1 AP20.2 AP20.5 AP20.7
AP205 AP23.1 AP520 MA40.1 MA40.2 MA41.1
MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2
MA43.3 MA43.4 MA52.1 AP00.3 AP110 AP510
UPDATED BY
AP05.3 AP305 AP950 AP980
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HDR-COMPANY Numeric 4 AP05.3 AP950
Company The company number. Must be a valid
record in the Accounts Payable Company
file.
HDR-DIST-CODE Alpha 9 AP05.3 AP950
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 AP950
Description The distribution code description.
HDR-ACCT-EDIT-FLAG Alpha 1 AP05.3 AP950
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 AP950
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 AP950
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 AP980
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 AP980
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 AP980
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 AP950
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 AP05.3 AP10.5
DIST-CODE Code entry screen to maintain AP20.1 AP20.2
distribution code header records within AP20.5 AP20.7
an Accounts Payable company. AP205 AP23.1
AP305 AP520
AP950 AP980
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
HDRSET2 VENDOR-GROUP This index is used by the Vendor online AP00.3 AP10.1
DIST-CODE screen to verify distribution code AP110 AP510
header records within an Accounts
Payable vendor group.
KeyChange, Duplicates
HDRSET3 DIST-CODE This index is used by the Accounts AP205
Payable Codes Listing program to print
distribution code header records.
KeyChange, Duplicates
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
|