 |
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 AP00.1 AP252 AM18.1 AP210
AP220 AP230 AP250 AR48.3 IC530 IC840
MA63.1 MAED.1 POIJ.1 PR05.1 PR05.3 PR198
PR226 PR247 PR26.1 PR47.1 PR514
UPDATED BY
AP10.1 AP100 AP115 AP141 AP150 AP170
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 MA65.1 AP180
AP181 AP28.1 AP28.2 AP300 AP35.1 AP55.2
AP56.2 API3.1 API4.1
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 AP30.3
AP32.1 AP36.1
AP40.1 AP40.2
AP510 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA65.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 AP30.3 AP32.1
record in the Hold Code file. AP36.1 AP40.1
AP40.2 AP510
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA65.1
HLI-COMPANY Numeric 4 AP141 AP150
Company The company number. Must be a valid AP170 AP30.3
record in the Accounts Payable Company AP32.1 AP36.1
file. AP40.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA65.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 AP30.3
AP32.1 AP36.1
AP40.1 AP40.2
AP510 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA65.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. AP30.3 AP32.1
AP36.1 AP40.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA65.1
HLI-SUFFIX Numeric 3 AP141 AP150
Invoice Suffix The invoice suffix number. Represents AP170 AP30.3
the occurrence value of the invoice. AP32.1 AP36.1
Used only if the item on hold is an AP40.1 AP520
invoice or payment. API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA65.1
HLI-CANCEL-SEQ Numeric 4 AP141 AP150
Cancel Sequence The sequence number assigned upon a AP170 AP30.3
cancellation of a distributed invoice. AP32.1 AP36.1
The first sequence assigned is 9999. AP40.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA65.1
HLI-SEQ-NBR Numeric 4 AP141 AP150
Sequence Number An automatically assigned sequence AP170 AP30.3
number. AP32.1 AP36.1
AP40.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
MA310 MA65.1
HLI-VOID-SEQ Numeric 4 AP141 AP150
Void Sequence The void sequence for the invoice AP170 AP30.3
payment, if applicable. Used by the AP32.1 AP36.1
system to keep payment records unique AP40.1 AP520
each time a payment is voided and the API1.1 API2.1
invoice is reinstated for payment. EE135 EE35.1
EE35.2 EE520
MA310 MA65.1
HLI-PROC-LEVEL Alpha 5 AP141 AP150
Process Level The process level represents a AP30.3 AP32.1
reporting level below company. AP36.1 AP40.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520 MA310
MA65.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 AP30.3 AP32.1
are: AP36.1 AP40.1
AP40.2 AP510
I = Invoice. Used for upgrading invoice AP520 API1.1
records. After invoices on hold are API2.1 EE135
upgraded, a post-upgrade program changes EE35.1 EE35.2
this value to Payment. EE520 MA310
MA65.1
P = Payment.
V = Vendor.
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 AP40.2
VENDOR vendors.
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 AM18.1 AP10.1
VENDOR-GROUP range of holds by record type and vendor AP100 AP115
COMPANY group. AP150 AP170
VENDOR AP180 AP181
INVOICE AP210 AP220
SUFFIX AP230 AP240
CANCEL-SEQ AP250 AP28.1
SEQ-NBR AP28.2 AP30.3
VOID-SEQ AP30.4 AP300
HLD-CODE AP305 AP32.1
AP35.1 AP36.1
AP40.1 AP40.2
AP55.2 AP56.2
API3.1 API4.1
AR48.3 IC530
...
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
|