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