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


UPDATED BY
AP10.1 AP100 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 AP25.3 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 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 AP05.4
AP240 AP250 AP00.1 AP252 AC210 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 AM500 AM51.1 AM551 AM97.1 AP03.3
AP110 AP131 AP133 AP180 AP181 AP210
AP220 AP230 AP28.1 AP28.2 AP300 AP35.1
AP55.2 AP56.2 AP90.1 AP91.1 API3.1 API4.1
MX123 MX500 MA540 MAED.1 PO10.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1 PR05.1 PR05.3 PR198 PR226 PR247
PR26.1 PR47.1 PR514 UK47.1

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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 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
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
HLISET5 REC-TYPE
VENDOR-GROUP
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
HLD-CODE
...
AC210 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 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.1 AP100
AP110 AP115
AP125 AP126
AP131 AP133
AP150 AP170


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: Wed Jun 08 20:47:31 2016

Home
Contact Us



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