APHLDINV FILE
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 AC03.4
AC115 AC440 AC50.1 AC500 AC52.1 AC520
AM18.1 AP190 AP193 AP210 AP225 AP226
AP230 AR08.1 AR10.1 AR115 AR124 AR190
AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2
AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7
AR43.1 AR501 AR550 AR560 AR570 AR575
AR580 AR82.1 BL02.1 BL122 BL140 BL141
BL202 BL240 BL340 BL41.1 BL802 BL902
BL92.1 CB10.1 CB180 CB191 CB20.1 CB30.1
CB500 DT180 DT181 DR100 IC10.1 IC10.2
IC12.1 IC140 IC141 IC142 IC145 IC16.4
IC226 IC263 IC45.1 IC530 IC62.1 IC63.1
IC81.2 IC812 IC82.1 IC83.1 IC840 IN20.1
MA140 MA190 MA278 MA300 MA520 MA95.1
MA95.2 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE112 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE510 OE810 OE920 PBIP.1 PO10.1
PO10.2 PO100 PO115 PO120 PO121 PO123
PO13.1 PO130 PO131 PO132 PO135 PO14.1
PO15.1 PO150 PO180 PO210 PO213 PO214
PO216 PO220 PO221 PO223 PO224 PO225
PO23.1 PO23.2 PO230 PO231 PO233 PO236
PO24.1 PO25.1 PO25.2 PO25.3 PO25.4 PO26.1
PO272 PO274 PO275 PO276 PO277 PO28.3
PO28.4 PO28.5 PO28.7 PO28.8 PO280 PO29.1
PO295 PO33.1 PO50.1 PO529 PO560 PO60.1
PO61.1 PO62.1 PO63.1 PO64.1 PO66.1 PO67.1
PO68.1 PO69.1 PO72.2 PO81.1 PO813 PO820
PO821 PO94.1 PR05.1 PR05.3 PR150 PR195
PR199 PR226 PR26.1 PR514 PR82.1 PR85.1
RQ11.1 RQ20.1 RQ20.2 RQ20.3 RQ20.4 RQ35.1
RQ500 TX04.1 TX40.1 WH130 WH132 WH140
WH190 WH20.2 WH20.7 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 WO235 WO252 WO30.1
WO35.1 WO40.1
UPDATED BY
AP10.1 AP100 AP150 AP170 AP20.1 AP20.2
AP20.5 AP20.6 AP20.7 AP20.8 AP23.1 AP26.1
AP30.3 AP30.4 AP305 AP32.1 AP36.1 AP40.1
AP40.2 AP510 AP520 AP951 AP952 AP983
EE135 EE35.1 EE35.2 EE520 MA40.1 MA40.2
MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1
MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540
PO122 PO20.1 PO21.3 PO22.2 PO22.3 PO30.1
PO31.1 PO34.1 PO35.1 PO52.1 PO530 RQ10.1
RQ10.2 AP125 AP126 AP180 AP181 AP25.1
AP25.2 AP28.1 AP28.2 AP300 AP35.1 AP55.2
AP56.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HLI-VENDOR-GROUP Alpha 4 AP10.1 AP100
Vendor Group The vendor group. Must be a valid AP150 AP170
record in the Vendor Group file. AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP23.1
AP26.1 AP30.3
AP32.1 AP36.1
AP40.1 AP40.2
AP510 AP520
AP951 AP952
EE135 EE35.1
EE35.2 EE520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
HLI-HLD-CODE Alpha 4 AP10.1 AP150
Hold Code The hold code assigned to the vendor, AP170 AP20.1
invoice, or payment. Must be a valid AP20.2 AP20.5
record in the Hold Code file. AP20.6 AP20.7
AP23.1 AP26.1
AP30.3 AP32.1
AP36.1 AP40.1
AP40.2 AP510
AP520 AP951
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
HLI-COMPANY Numeric 4 AP150 AP170
Company The company number. Must be a valid AP20.1 AP20.2
record in the Accounts Payable Company AP20.5 AP20.6
file. AP20.7 AP23.1
AP26.1 AP30.3
AP32.1 AP36.1
AP40.1 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
HLI-VENDOR Alpha 9 AP10.1 AP150
Vendor ID The vendor number. Must be a valid AP170 AP20.1
record in the Vendor file. AP20.2 AP20.5
AP20.6 AP20.7
AP23.1 AP26.1
AP30.3 AP32.1
AP36.1 AP40.1
AP40.2 AP510
AP520 AP951
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
HLI-INVOICE Alpha 22 AP150 AP170
Invoice Number The invoice number. Used only if the AP20.1 AP20.2
item on hold is an invoice or payment. AP20.5 AP20.6
AP20.7 AP23.1
AP26.1 AP30.3
AP32.1 AP36.1
AP40.1 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
HLI-SUFFIX Numeric 3 AP150 AP170
Invoice Suffix The invoice suffix number. Represents AP20.1 AP20.2
the occurrence value of the invoice. AP20.5 AP20.6
Used only if the item on hold is an AP20.7 AP23.1
invoice or payment. AP26.1 AP30.3
AP32.1 AP36.1
AP40.1 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
HLI-CANCEL-SEQ Numeric 4 AP150 AP170
Cancel Sequence The sequence number assigned upon a AP20.1 AP20.2
cancellation of a distributed invoice. AP20.5 AP20.6
The first sequence assigned is 9999. AP20.7 AP23.1
AP26.1 AP30.3
AP32.1 AP36.1
AP40.1 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
HLI-SEQ-NBR Numeric 4 AP150 AP170
Sequence Number An automatically assigned sequence AP20.1 AP20.2
number. AP20.5 AP20.6
AP20.7 AP23.1
AP26.1 AP30.3
AP32.1 AP36.1
AP40.1 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
HLI-VOID-SEQ Numeric 4 AP150 AP170
Void Sequence The void sequence for the invoice AP20.1 AP20.2
payment, if applicable. Used by the AP20.5 AP20.6
system to keep payment records unique AP20.7 AP23.1
each time a payment is voided and the AP26.1 AP30.3
invoice is reinstated for payment. AP32.1 AP36.1
AP40.1 AP520
AP952 EE135
EE35.1 EE35.2
EE520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
HLI-REC-TYPE Alpha 1 AP10.1 AP150
Record Type The file record type. Identifies the AP170 AP20.1
type of record on hold. Valid values AP20.2 AP20.5
are: AP20.6 AP20.7
AP23.1 AP26.1
I = Invoice. Used for upgrading invoice AP30.3 AP32.1
records. After invoices on hold are AP36.1 AP40.1
upgraded, a post-upgrade program changes AP40.2 AP510
this value to Payment. AP520 AP951
AP952 EE135
P = Payment. EE35.1 EE35.2
EE520 MA40.1
V = Vendor. MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APHLDINV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HLISET1 VENDOR-GROUP This index is used to inquire by a AP05.4 AP305
HLD-CODE specific vendor group hold code.
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
HLISET2 VENDOR-GROUP This index is used by upgrade programs AP952
HLD-CODE only.
COMPANY
VENDOR KeyChange, Subset
INVOICE Where (REC-TYPE = "I" )
SUFFIX
CANCEL-SEQ
HLISET3 VENDOR-GROUP This index is used by AP170 (Payment AP170 AP240
HLD-CODE Closing) to remove temporary holds from AP250 AP290
VENDOR vendors. AP40.2 AP951
KeyChange, Subset
Where (REC-TYPE = "V" )
HLISET4 VENDOR-GROUP This index is used by AP170 (Payment AP00.1 AP170
HLD-CODE Closing) to remove temporary holds from AP240 AP40.1
COMPANY payment records. AP952 EE135
VENDOR EE35.1 EE35.2
INVOICE Subset EE520 MA40.1
SUFFIX Where (REC-TYPE = "P" ) MA40.2 MA41.1
CANCEL-SEQ MA41.2 MA41.3
SEQ-NBR MA41.4 MA41.5
VOID-SEQ MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO122 PO20.1
PO21.3 PO22.2
PO22.3 PO30.1
...
HLISET5 REC-TYPE This index can be used to delete a AC03.4 AC115
VENDOR-GROUP range of holds by record type and vendor AC440 AC50.1
COMPANY group. AC500 AC52.1
VENDOR AC520 AM18.1
INVOICE AP10.1 AP100
SUFFIX AP125 AP126
CANCEL-SEQ AP150 AP170
SEQ-NBR AP180 AP181
VOID-SEQ AP190 AP193
HLD-CODE AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP20.8
AP210 AP225
AP226 AP23.1
AP230 AP240
...
APHLDINV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|