Lawson Insight Technical Documentation |
|
APHLDINV
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 AP252
AC210 AC297 AM18.1 AP131 AP210 AP220
AP230 AR48.3 IC28.1 IC530 MA180 MA530
MA531 MA63.1 MA66.2 MA66.3 MA67.1 MA67.2
MA80.1 MAED.1 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POI3.1 POII.1
POIJ.1 PR198 RQ10.1 RQ10.2 RQ10.3 RQIE.1
WH20.2 WH20.7
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 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.1 AP30.3 AP30.4
AP305 AP31.3 AP32.1 AP36.1 AP40.1 AP40.2
AP43.1 AP510 AP520 API1.1 API2.1 EE135
EE35.1 EE35.2 EE520 MA310 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.5 MA43.7 MA43.8 MA60.2 MA60.4 MA61.1
MA65.1 MAI1.1 AM115 AM15.1 AM15.2 AM15.3
AM15.4 AM20.1 AM20.3 AM21.1 AM21.3 AM500
AM51.1 AM551 AM97.1 AP180 AP181 AP28.1
AP28.2 AP300 AP35.1 AP55.2 AP56.2 API3.1
API4.1 IC840 MA70.1 MA75.1 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HLI-VENDOR-GROUP Alpha 4 AP10.1 AP100
Element: Vendor Group The vendor group. Must be a valid AP125 AP126
record in the Vendor Group file. AP141 AP150
AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.3
AP31.3 AP32.1
AP36.1 AP40.1
AP40.2 AP43.1
AP510 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.2 MA60.4
MA61.1 MA65.1
MAI1.1
HLI-HLD-CODE Alpha 4 AP10.1 AP125
Accounts Receivable The hold code assigned to the vendor, AP126 AP141
Code invoice, or payment. Must be a valid AP150 AP170
record in the Hold Code file. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.3 AP31.3
AP32.1 AP36.1
AP40.1 AP40.2
AP43.1 AP510
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.4 MA61.1
MA65.1 MAI1.1
HLI-COMPANY Numeric 4 AP125 AP126
Element: Company The company number. Must be a valid AP141 AP150
record in the Accounts Payable Company AP170 AP20.1
file. AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.3
AP31.3 AP32.1
AP36.1 AP40.1
AP43.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.2 MA60.4
MA61.1 MA65.1
MAI1.1
HLI-VENDOR Alpha 9 (Right Justified) AP10.1 AP115
Element: Vendor ID The vendor number. Must be a valid AP125 AP126
record in the Vendor file. AP141 AP150
AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.3
AP31.3 AP32.1
AP36.1 AP40.1
AP40.2 AP43.1
AP510 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.2 MA60.4
MA61.1 MA65.1
MAI1.1
HLI-INVOICE Alpha 22 AP115 AP125
Element: Invoice NumberThe invoice number. Used only if the AP126 AP141
item on hold is an invoice or payment. AP150 AP170
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.3 AP31.3
AP32.1 AP36.1
AP40.1 AP43.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.4 MA61.1
MA65.1 MAI1.1
HLI-SUFFIX Numeric 3 AP125 AP126
Element: Invoice SuffixThe invoice suffix number. Represents AP141 AP150
the occurrence value of the invoice. AP170 AP20.1
Used only if the item on hold is an AP20.2 AP20.3
invoice or payment. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.3
AP31.3 AP32.1
AP36.1 AP40.1
AP43.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.2 MA60.4
MA61.1 MA65.1
MAI1.1
HLI-CANCEL-SEQ Numeric 4 AP125 AP126
Element: Sequence Number AP141 AP150
AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.3
AP31.3 AP32.1
AP36.1 AP40.1
AP43.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.2 MA60.4
MA61.1 MA65.1
MAI1.1
HLI-SEQ-NBR Numeric 4 AP125 AP126
Element: Sequence NumbeAn automatically assigned sequence AP141 AP150
number. AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.3
AP31.3 AP32.1
AP36.1 AP40.1
AP43.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.2 MA60.4
MA61.1 MA65.1
MAI1.1
HLI-VOID-SEQ Numeric 4 AP125 AP126
Element: Sequence NumbeThe void sequence for the invoice AP141 AP150
payment, if applicable. Used by the AP170 AP20.1
system to keep payment records unique AP20.2 AP20.3
each time a payment is voided and the AP20.4 AP20.5
invoice is reinstated for payment. AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.3
AP31.3 AP32.1
AP36.1 AP40.1
AP43.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.2 MA60.4
MA61.1 MA65.1
MAI1.1
HLI-PROC-LEVEL Alpha 5 AP125 AP126
Element: Process Level AP141 AP150
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.3
AP31.3 AP32.1
AP36.1 AP40.1
AP43.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.2 MA60.4
MA61.1 MA65.1
MAI1.1
HLI-REC-TYPE Alpha 1 AP10.1 AP125
Element: Record Type The file record type. Identifies the AP126 AP141
type of record on hold. Valid values AP150 AP170
are: AP20.1 AP20.2
AP20.3 AP20.4
I = Invoice. Used for upgrading invoice AP20.5 AP20.6
records. After invoices on hold are AP20.7 AP23.1
upgraded, a post-upgrade program changes AP25.1 AP25.2
this value to Payment. AP26.1 AP27.1
AP30.3 AP31.3
P = Payment. AP32.1 AP36.1
AP40.1 AP40.2
V = Vendor. AP43.1 AP510
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.4 MA61.1
MA65.1 MAI1.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
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
KeyChange, Subset
Where (REC-TYPE = "V" )
HLISET4 VENDOR-GROUP This index is used by AP170 (Payment AP00.1 AP141
HLD-CODE Closing) to remove temporary holds from AP170 AP240
COMPANY payment records. AP252 AP40.1
VENDOR Subset EE135 EE35.1
INVOICE Where (REC-TYPE = "P" ) EE35.2 EE520
SUFFIX MA41.1 MA41.2
CANCEL-SEQ MA41.4 MA43.1
SEQ-NBR MA43.2 MA43.3
VOID-SEQ MA43.4 MA43.5
MA43.7 MA43.8
HLISET5 REC-TYPE This index can be used to delete a AC210 AC297
VENDOR-GROUP range of holds by record type and vendor AM115 AM15.1
COMPANY group. AM15.2 AM15.3
VENDOR AM15.4 AM18.1
INVOICE AM20.1 AM20.3
SUFFIX AM21.1 AM21.3
CANCEL-SEQ AM500 AM51.1
SEQ-NBR AM551 AM97.1
VOID-SEQ AP10.1 AP100
HLD-CODE AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP20.1 AP20.2
AP20.3 AP20.4
...
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
|