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
AP290 AM18.1


UPDATED BY
AC160 AC210 AC297 AM115 AM117 AM15.1
AM15.2 AM15.3 AM15.4 AM19.1 AM19.2 AM19.4
AM20.1 AM20.3 AM21.1 AM21.3 AM22.1 AM500
AM51.1 AM551 AM97.1 AP00.1 AP03.3 AP05.4
AP10.1 AP100 AP110 AP115 AP125 AP126
AP131 AP133 AP141 AP150 AP170 AP180
AP181 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP20.8 AP21.1 AP210 AP220
AP23.1 AP230 AP240 AP25.1 AP25.2 AP25.3
AP250 AP252 AP26.1 AP27.1 AP271 AP28.1
AP28.2 AP30.1 AP30.2 AP30.3 AP30.4 AP300
AP305 AP32.1 AP35.1 AP36.1 AP40.1 AP40.2
AP510 AP520 AP55.2 AP56.2 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 EE135 EE35.1 EE35.2 EE520
DR100 IC140 IC142 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 IC840 EX542 EX545 MX123
MX500 MA180 MA279 MA310 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
MA530 MA531 MA540 MA60.2 MA60.3 MA60.4
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.4 MA68.5 MA69.1
MA70.1 MA75.1 MA80.1 MAED.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD235
PO10.1 PO100 PO101 PO120 PO122 PO131
PO136 PO150 PO190 PO20.1 PO20.6 PO20.9
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.2 PO22.3 PO22.4 PO22.5 PO220 PO223
PO23.1 PO233 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO253 PO254 PO27.2 PO278 PO28.2
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 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 PR198
PR226 PR247 PR26.1 PR47.1 PR514 UK47.1
RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2
RQ260 RQ35.1 RQ500 RQIF.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 ZW130

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
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 MA310
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 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
MA310 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.
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 MA310
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 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 MA310
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
MA310 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 MA310
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 MA310
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 MA310
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 MA310
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 MA310
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 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
MA310 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 11:07:28 2016

Home
Contact Us



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