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 AM18.1 AP131 AP210 AP220 AP230
AR48.3 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 IC28.1 IC530 MA180 MA530 MA531
MA63.1 MA66.2 MA66.3 MA67.1 MA67.2 MA70.1
MA75.1 MA80.1 MAED.1 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 OE111 OE113
OE114 OE116 OE129 OE13.2 OE13.3 OE13.5
OE13.6 OE14.4 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE81.1 OE810 OE830 OE90.1 OE90.2 PO100
PO101 PO122 PO131 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 POI3.1 POIE.1
POII.1 POIJ.1 PR198 RQ10.1 RQ10.2 WH20.2
WH20.7
UPDATED BY
AP10.1 AP100 AP115 AP125 AP126 AP141
AP150 AP170 AP25.1 AP25.2 AP26.1 AP27.1
AP30.3 AP30.4 AP305 AP32.1 AP36.1 AP40.1
AP40.2 AP510 AP520 API1.1 API2.1 EE135
EE35.1 EE35.2 EE520 MA310 MA60.2 MA60.4
MA61.1 MA65.1 MAI1.1 AM115 AM117 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 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 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 AP141 AP150
record in the Vendor Group file. AP170 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 MA60.2
MA60.4 MA61.1
MA65.1 MAI1.1
HLI-HLD-CODE Alpha 4 AP10.1 AP141
Element: Hld Code Ap The hold code assigned to the vendor, AP150 AP170
invoice, or payment. Must be a valid AP26.1 AP27.1
record in the Hold Code file. AP30.3 AP32.1
AP36.1 AP40.1
AP40.2 AP510
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA60.2 MA60.4
MA61.1 MA65.1
MAI1.1
HLI-COMPANY Numeric 4 AP141 AP150
Element: Company The company number. Must be a valid AP170 AP26.1
record in the Accounts Payable Company AP27.1 AP30.3
file. AP32.1 AP36.1
AP40.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 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 AP141 AP150
record in the Vendor file. AP170 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 MA60.2
MA60.4 MA61.1
MA65.1 MAI1.1
HLI-INVOICE Alpha 22 AP115 AP141
Element: Invoice NumberThe invoice number. Used only if the AP150 AP170
item on hold is an invoice or payment. AP26.1 AP27.1
AP30.3 AP32.1
AP36.1 AP40.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
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 AP25.1
Used only if the item on hold is an AP25.2 AP26.1
invoice or payment. AP27.1 AP30.3
AP32.1 AP36.1
AP40.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA60.2
MA60.4 MA61.1
MA65.1 MAI1.1
HLI-CANCEL-SEQ Numeric 4 AP141 AP150
Element: Sequence NumbeThe sequence number assigned upon a AP170 AP26.1
cancellation of a distributed invoice. AP27.1 AP30.3
The first sequence assigned is 9999. AP32.1 AP36.1
AP40.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA60.2
MA60.4 MA61.1
MA65.1 MAI1.1
HLI-SEQ-NBR Numeric 4 AP141 AP150
Element: Sequence NumbeAn automatically assigned sequence AP170 AP26.1
number. AP27.1 AP30.3
AP32.1 AP36.1
AP40.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA60.2
MA60.4 MA61.1
MA65.1 MAI1.1
HLI-VOID-SEQ Numeric 4 AP141 AP150
Element: Sequence NumbeThe void sequence for the invoice AP170 AP26.1
payment, if applicable. Used by the AP27.1 AP30.3
system to keep payment records unique AP32.1 AP36.1
each time a payment is voided and the AP40.1 AP520
invoice is reinstated for payment. API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA60.2
MA60.4 MA61.1
MA65.1 MAI1.1
HLI-PROC-LEVEL Alpha 5 AP141 AP150
Element: Process Level The process level represents a AP26.1 AP30.3
reporting level below company. AP32.1 AP36.1
AP40.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA60.2
MA60.4 MA61.1
MA65.1 MAI1.1
HLI-REC-TYPE Alpha 1 AP10.1 AP141
Element: Record Type The file record type. Identifies the AP150 AP170
type of record on hold. Valid values AP26.1 AP27.1
are: AP30.3 AP32.1
AP36.1 AP40.1
I = Invoice. Used for upgrading invoice AP40.2 AP510
records. After invoices on hold are AP520 API1.1
upgraded, a post-upgrade program changes API2.1 EE135
this value to Payment. EE35.1 EE35.2
EE520 MA310
P = Payment. MA60.2 MA60.4
MA61.1 MA65.1
V = Vendor. 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
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
HLISET5 REC-TYPE This index can be used to delete a AC210 AM115
VENDOR-GROUP range of holds by record type and vendor AM117 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
AP210 AP220
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
|