APDISTHDR

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 DR100 IC141 IC142
IC83.1 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA42.1 MA43.2 MA43.1 MA43.3 MA43.4 MA43.6
MA43.7 MA44.1 MA44.2 PD22.1 PO150 PO21.3
PO21.1 PO21.2 PO21.4 PO21.5 PO25.1 PO25.6
PO25.7 PO25.5 PO26.2 PO26.4 PO26.5 PO26.3
PO26.7 PO26.9 PO28.2 PO36.2 PO36.1 PO520
PO536 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5
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 AM22.1 AM500 AM51.1 AM551 AM97.1
AP03.3 AP110 AP115 AP125 AP126 AP131
AP150 AP210 AP220 AP25.1 AP25.2 AP26.1
AP27.1 AP271 AP30.2 AP30.4 AP300 AP510
AP90.1 AP91.1 API1.1 API2.1 API3.1 API4.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 IC12.1 IC140
IC145 IC243 IC330 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC840 MX123 MX500 MA126 MA180
MA278 MA279 MA53.1 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA69.1 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD235
PD570 PO04.1 PO04.2 PO10.1 PO10.2 PO100
PO101 PO115 PO120 PO122 PO131 PO132
PO136 PO15.1 PO15.2 PO15.4 PO17.1 PO190
PO192 PO195 PO20.1 PO20.6 PO20.9 PO204
PO22.1 PO22.2 PO22.3 PO22.4 PO22.5 PO220
PO222 PO223 PO224 PO225 PO229 PO23.1
PO230 PO233 PO234 PO24.1 PO251 PO253
PO254 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO278 PO280 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 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 PO529 PO54.1
PO54.2 PO54.3 PO54.4 PO54.5 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 PR05.1 PR05.3 PR226
PR247 PR26.1 PR47.1 PR514 RQ01.1 RQ12.1
RQ13.1 RQ13.2 RQ260 RQ44.1 RQ810 RQIB.1
RQII.1 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830


UPDATED BY
AP05.3 AP305

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HDR-COMPANY
Element: Company
Numeric 4
The company number. Must be a valid record in the Accounts Payable Company file.
AP05.3
HDR-DIST-CODE
Element: Dist Code
Alpha 9
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.
AP05.3
HDR-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The distribution code description.
AP05.3
HDR-ACCT-EDIT-FLAG
Element: Edit Accounts
Alpha 1
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
AP05.3
HDR-ACCT-UNIT-FLAG
Element: Accounting Unit Flag
Alpha 1
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.
AP05.3
HDR-ACCOUNT-FLAG
Element: Account Flag
Alpha 1
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.
AP05.3
HDR-TOTAL-PERCENT
Element: Percent Total
Signed 6.3
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.
AP05.3
HDR-TOTAL-TRAN-AMT
Element: Amount Total
Signed 18.2
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.
AP05.3
HDR-TOTAL-UNIT
Element: Unit Total
Signed 15.2
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.
AP05.3
HDR-VENDOR-GROUP
Element: Vendor Group
Alpha 4
The vendor group associated with the distribution code company.
AP05.3


APDISTHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HDRSET1 COMPANY
DIST-CODE
...
AP00.4 AP00.5
AP05.3 AP10.5
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP205 AP21.1
AP23.1 AP305
AP520 DR100
IC141 IC142
IC83.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 PD22.1
PO150 PO21.3
HDRSET2 VENDOR-GROUP
DIST-CODE
COMPANY
KeyChange
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP03.3
AP10.1 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
HDRSET3 DIST-CODE
COMPANY
KeyChange
AP205


APDISTHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
HDR-COMPANY->CPY-COMPANY


APDISTHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apdistcode APDISTCODE Delete Cascades
HDR-COMPANY->DTC-COMPANY
HDR-DIST-CODE->DTC-DIST-CODE
  DTC-SEQ-NBR


File created: Thu Jun 09 02:07:02 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.