APHLDINV

Hold

The Hold file contains records of vendors, invoices, and payments that are on hold. When one of these items is placed on hold, a record is created in this file. When the hold is removed, the record is deleted.

REFERENCED BY
AP05.4 AP240 AP250 AP290 AP00.1 AP252
AC210 AC297 AM18.1 AP230 MAED.1 PR198


UPDATED BY
AP10.1 AP100 AP110 AP115 AP125 AP126
AP141 AP150 AP170 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.6 AP20.7 AP20.8 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.1
AP30.3 AP30.2 AP30.4 AP305 AP32.1 AP36.1
AP40.1 AP40.2 AP510 AP520 API1.1 API2.1
EE135 EE35.1 EE35.2 EE520 EX542 EX545
MA41.1 MA41.2 MA41.4 MA41.7 MA42.1 MA42.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MA44.1 MA44.2 MA60.2 MA60.4 MA60.3 MA60.5
MA61.1 MA65.1 MA68.2 MA68.4 MA68.3 MA68.5
MAI1.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 AP131 AP133 AP180 AP181
AP210 AP220 AP271 AP28.1 AP28.2 AP300
AP35.1 AP55.2 AP56.2 AP90.1 AP91.1 API3.1
API4.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC12.1 IC140 IC141 IC142 IC145 IC243
IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1
IC840 MX123 MX500 MA126 MA180 MA278
MA279 MA53.1 MA530 MA531 MA540 MA63.1
MA66.2 MA67.2 MA67.3 MA69.1 MA70.1 MA75.1
MA80.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
PO150 PO17.1 PO190 PO192 PO195 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.2 PO22.3 PO22.4
PO22.5 PO220 PO222 PO223 PO224 PO225
PO229 PO23.1 PO230 PO233 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO253
PO254 PO26.3 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO278 PO28.2
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 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO529
PO536 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 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ260 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1 RQII.1
RQIJ.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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HLI-VENDOR-GROUP
Element: Vendor Group		Alpha 4
The vendor group. Must be a valid record in the Vendor Group file.
AP10.1 AP100
AP110 AP125
AP126 AP141
AP150 AP170
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.3
AP32.1 AP36.1
AP40.1 AP40.2
AP510 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA42.1 MA42.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA44.1
MA44.2 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MAI1.1
HLI-HLD-CODE
Element: Hld Code Ap		Alpha 4
The hold code assigned to the vendor, invoice, or payment. Must be a valid record in the Hold Code file.
AP10.1 AP110
AP141 AP150
AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP26.1 AP27.1
AP30.3 AP32.1
AP36.1 AP40.1
AP40.2 AP510
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA44.1 MA44.2
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
MAI1.1
HLI-COMPANY
Element: Company		Numeric 4
The company number. Must be a valid record in the Accounts Payable Company file.
AP110 AP125
AP126 AP141
AP150 AP170
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.3
AP32.1 AP36.1
AP40.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA42.1 MA42.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA44.1
MA44.2 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MAI1.1
HLI-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor number. Must be a valid record in the Vendor file.
AP10.1 AP110
AP115 AP125
AP126 AP141
AP150 AP170
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.3
AP32.1 AP36.1
AP40.1 AP40.2
AP510 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA42.1 MA42.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA44.1
MA44.2 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MAI1.1
HLI-INVOICE
Element: Invoice		Alpha 22
The invoice number. Used only if the item on hold is an invoice or payment.
AP115 AP125
AP126 AP141
AP150 AP170
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.3
AP32.1 AP36.1
AP40.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA41.1 MA41.2
MA41.4 MA41.7
MA42.1 MA42.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA44.1
MA44.2 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MAI1.1
HLI-SUFFIX
Element: Suffix		Numeric 3
The invoice suffix number. Represents the occurrence value of the invoice. Used only if the item on hold is an invoice or payment.
AP125 AP126
AP141 AP150
AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.3 AP32.1
AP36.1 AP40.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA44.1 MA44.2
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
MAI1.1
HLI-CANCEL-SEQ
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
AP125 AP126
AP141 AP150
AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.3 AP32.1
AP36.1 AP40.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA44.1 MA44.2
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
MAI1.1
HLI-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
AP125 AP126
AP141 AP150
AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.3 AP32.1
AP36.1 AP40.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA44.1 MA44.2
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
MAI1.1
HLI-VOID-SEQ
Element: Seq Nbr		Numeric 4
The void sequence for the invoice payment, if applicable. Used by the system to keep payment records unique each time a payment is voided and the invoice is reinstated for payment.
AP125 AP126
AP141 AP150
AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.3 AP32.1
AP36.1 AP40.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA44.1 MA44.2
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
MAI1.1
HLI-PROC-LEVEL
Element: Process Level		Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
AP125 AP126
AP141 AP150
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.3 AP32.1
AP36.1 AP40.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA44.1 MA44.2
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
MAI1.1
HLI-REC-TYPE
Element: Rec Type		Alpha 1
The file record type. Identifies the type of record on hold. Valid values are: I = Invoice. Used for upgrading invoice records. After invoices on hold are upgraded, a post-upgrade program changes this value to Payment. P = Payment. V = Vendor.
AP10.1 AP110
AP125 AP126
AP141 AP150
AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.3 AP32.1
AP36.1 AP40.1
AP40.2 AP510
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.1
MA42.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA44.1 MA44.2
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
MAI1.1


APHLDINV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HLISET1 VENDOR-GROUP
HLD-CODE
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
AP05.4 AP305
HLISET3 VENDOR-GROUP
HLD-CODE
VENDOR
KeyChange, Subset
Where(REC-TYPE ="V")
AP170 AP240
AP250 AP290
AP40.2
HLISET4 VENDOR-GROUP
HLD-CODE
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
Subset
Where(REC-TYPE ="P")
AP00.1 AP141
AP170 AP240
AP252 AP40.1
EE135 EE35.1
EE35.2 EE520
EX542 EX545
MA42.1 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA44.1 MA44.2
HLISET5 REC-TYPE
VENDOR-GROUP
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
HLD-CODE
...
AC160 AC210
AC297 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM18.1
AM19.1 AM19.2
AM19.4 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.1
AP100 AP110
AP115 AP125
AP126 AP131


APHLDINV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apinvoice APINVOICE Required
When (HLI-REC-TYPE ="I" )
HLI-COMPANY->API-COMPANY
HLI-VENDOR->API-VENDOR
HLI-INVOICE->API-INVOICE
HLI-SUFFIX->API-SUFFIX
HLI-CANCEL-SEQ->API-CANCEL-SEQ
Appayment APPAYMENT Required
When (HLI-REC-TYPE ="P" )
HLI-COMPANY->APP-COMPANY
HLI-VENDOR->APP-VENDOR
HLI-INVOICE->APP-INVOICE
HLI-SUFFIX->APP-SUFFIX
HLI-CANCEL-SEQ->APP-CANCEL-SEQ
HLI-SEQ-NBR->APP-SEQ-NBR
HLI-VOID-SEQ->APP-VOID-SEQ
Apvenmast APVENMAST Required
When (HLI-REC-TYPE ="V" )
HLI-VENDOR-GROUP->VEN-VENDOR-GROUP
HLI-VENDOR->VEN-VENDOR

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

Home
Contact Us



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