|
|
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 AP205
AP520 PO150 PO25.1 PO25.6 PO25.7 PO36.2
PO536 AM115 AM117 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 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 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 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 AP205 AP305
an Accounts Payable company. AP520 PO150
PO25.1 PO25.6
PO25.7 PO36.2
PO536
HDRSET2 VENDOR-GROUP This index is used by the Vendor online AM115 AM117
DIST-CODE screen to verify distribution code AM15.1 AM15.2
COMPANY header records within an Accounts AM15.3 AM15.4
Payable vendor group. AM20.1 AM20.3
KeyChange AM21.1 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 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
|
