 |
Lawson Insight Technical Documentation |
|
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.3 MA67.1 MA67.2 MA70.1
MAED.1 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 PR05.1 PR05.3
PR198 PR226 PR247 PR26.1 PR47.1 PR514
RQ10.1 RQ10.2 WH20.2 WH20.7
UPDATED BY
AP10.1 AP100 AP115 AP141 AP150 AP170
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.6
AP20.7 AP20.8 AP23.1 AP26.1 AP27.1 AP30.3
AP30.4 AP305 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 MA43.1 MA43.2 MA43.3 MA43.4 MA43.5
MA43.7 MA43.8 MA60.2 MA60.4 MA61.1 MA65.1
MAI1.1 AP125 AP126 AP180 AP181 AP25.1
AP25.2 AP28.1 AP28.2 AP300 AP35.1 AP55.2
AP56.2 API3.1 API4.1 IC840
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HLI-VENDOR-GROUP Alpha 4 AP10.1 AP100
Vendor Group The vendor group. Must be a valid AP141 AP150
record in the Vendor Group file. AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP26.1
AP27.1 AP30.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 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 AP141
Hold Code The hold code assigned to the vendor, AP150 AP170
invoice, or payment. Must be a valid AP20.1 AP20.2
record in the Hold Code file. AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP23.1
AP26.1 AP27.1
AP30.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
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 AP141 AP150
Company The company number. Must be a valid AP170 AP20.1
record in the Accounts Payable Company AP20.2 AP20.3
file. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP26.1
AP27.1 AP30.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 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
Vendor ID The vendor number. Must be a valid AP141 AP150
record in the Vendor file. AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP26.1
AP27.1 AP30.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 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 AP141
Invoice Number The invoice number. Used only if the AP150 AP170
item on hold is an invoice or payment. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP23.1
AP26.1 AP27.1
AP30.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
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 AP141 AP150
Invoice Suffix The invoice suffix number. Represents AP170 AP20.1
the occurrence value of the invoice. AP20.2 AP20.3
Used only if the item on hold is an AP20.4 AP20.5
invoice or payment. AP20.6 AP20.7
AP23.1 AP26.1
AP27.1 AP30.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 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 AP141 AP150
Cancel Sequence The sequence number assigned upon a AP170 AP20.1
cancellation of a distributed invoice. AP20.2 AP20.3
The first sequence assigned is 9999. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP26.1
AP27.1 AP30.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 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 AP141 AP150
Sequence Number An automatically assigned sequence AP170 AP20.1
number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP26.1
AP27.1 AP30.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 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 AP141 AP150
Void Sequence The void sequence for the invoice AP170 AP20.1
payment, if applicable. Used by the AP20.2 AP20.3
system to keep payment records unique AP20.4 AP20.5
each time a payment is voided and the AP20.6 AP20.7
invoice is reinstated for payment. AP23.1 AP26.1
AP27.1 AP30.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 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 AP141 AP150
Process Level The process level represents a AP20.1 AP20.2
reporting level below company. AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP23.1
AP26.1 AP30.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 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 AP141
Record Type The file record type. Identifies the AP150 AP170
type of record on hold. Valid values AP20.1 AP20.2
are: AP20.3 AP20.4
AP20.5 AP20.6
I = Invoice. Used for upgrading invoice AP20.7 AP23.1
records. After invoices on hold are AP26.1 AP27.1
upgraded, a post-upgrade program changes AP30.3 AP32.1
this value to Payment. AP36.1 AP40.1
AP40.2 AP43.1
P = Payment. AP510 AP520
API1.1 API2.1
V = Vendor. EE135 EE35.1
EE35.2 EE520
MA310 MA41.1
MA41.2 MA41.4
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
HLISET2 VENDOR-GROUP This index is used by upgrade programs
HLD-CODE only.
COMPANY KeyChange, Subset
VENDOR Where (REC-TYPE = "I" )
INVOICE
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
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 AM18.1 AP10.1
COMPANY group. AP100 AP115
VENDOR AP125 AP126
INVOICE AP131 AP150
SUFFIX AP170 AP180
CANCEL-SEQ AP181 AP20.1
SEQ-NBR AP20.2 AP20.3
VOID-SEQ AP20.4 AP20.5
HLD-CODE AP20.6 AP20.7
AP20.8 AP210
AP220 AP23.1
AP230 AP240
AP25.1 AP25.2
AP25.3 AP250
...
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
|