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 AP230 AR48.3 MAED.1 PR198
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 AP21.1 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.1 AP30.3
AP30.2 AP30.4 AP305 AP32.1 AP36.1 AP40.1
AP40.2 AP510 AP520 API1.1 API2.1 EE135
EE35.1 EE35.2 EE520 ET542 ET545 MA310
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA60.2 MA60.4
MA60.3 MA60.5 MA61.1 MA65.1 MA68.2 MA68.4
MA68.3 MA68.5 MAI1.1 AC160 AM115 AM117
AM15.1 AM15.2 AM15.3 AM15.4 AM19.1 AM19.2
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 AP03.3 AP110 AP131 AP180
AP181 AP210 AP220 AP28.1 AP28.2 AP300
AP35.1 AP55.2 AP56.2 AP90.1 AP91.1 API3.1
API4.1 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 MX123 MX500 MA180 MA279 MA530
MA531 MA63.1 MA66.2 MA66.3 MA67.2 MA67.3
MA70.1 MA75.1 MA80.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD235 PO10.1 PO100
PO101 PO120 PO122 PO131 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO220
PO223 PO23.1 PO233 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO253 PO254 PO27.2 PO278
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 PO54.1 PO54.2
PO54.3 PO54.4 POI3.1 POID.1 POII.1 POIJ.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 UK47.1 RQ10.1 RQ10.2 WH20.2 WH20.7
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
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 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 AP20.1 AP20.2
record in the Hold Code file. AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP23.1 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.3 AP32.1
AP36.1 AP40.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.6 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MAI1.1
HLI-VENDOR Alpha 9 (Right Justified) AP10.1 AP115
Element: Vendor 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
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MAI1.1
HLI-INVOICE Alpha 22 AP115 AP125
Element: Invoice The 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.3
AP32.1 AP36.1
AP40.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.6
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
MAI1.1
HLI-SUFFIX Numeric 3 AP125 AP126
Element: Suffix The 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.3 AP32.1
AP36.1 AP40.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.6 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MAI1.1
HLI-CANCEL-SEQ Numeric 4 AP125 AP126
Element: Seq Nbr An automatically assigned sequence AP141 AP150
number. AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.3 AP32.1
AP36.1 AP40.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.6 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MAI1.1
HLI-SEQ-NBR Numeric 4 AP125 AP126
Element: Seq Nbr An automatically assigned sequence AP141 AP150
number. AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.3 AP32.1
AP36.1 AP40.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.6 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MAI1.1
HLI-VOID-SEQ Numeric 4 AP125 AP126
Element: Seq Nbr The 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.3 AP32.1
AP36.1 AP40.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.6 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MAI1.1
HLI-PROC-LEVEL Alpha 5 AP125 AP126
Element: Process Level This field contains the process level, AP141 AP150
which is the reporting hierarchy below AP20.1 AP20.2
company. AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.3 AP32.1
AP36.1 AP40.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.6 MA60.2
MA60.4 MA61.1
MA65.1 MA68.2
MA68.4 MAI1.1
HLI-REC-TYPE Alpha 1 AP10.1 AP125
Element: Rec 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 AP21.1
upgraded, a post-upgrade program changes AP23.1 AP25.1
this value to Payment. AP25.2 AP26.1
AP27.1 AP30.3
P = Payment. AP32.1 AP36.1
AP40.1 AP40.2
V = Vendor. 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.6
MA60.2 MA60.4
MA61.1 MA65.1
MA68.2 MA68.4
MAI1.1
APHLDINV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HLISET1 VENDOR-GROUP AP05.4 AP305
HLD-CODE
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
HLISET3 VENDOR-GROUP KeyChange, Subset AP170 AP240
HLD-CODE Where (REC-TYPE = "V" ) AP250 AP290
VENDOR AP40.2
HLISET4 VENDOR-GROUP Subset AP00.1 AP141
HLD-CODE Where (REC-TYPE = "P" ) AP170 AP240
COMPANY AP252 AP40.1
VENDOR EE135 EE35.1
INVOICE EE35.2 EE520
SUFFIX ET542 ET545
CANCEL-SEQ MA43.1 MA43.2
SEQ-NBR MA43.3 MA43.4
VOID-SEQ MA43.6
HLISET5 REC-TYPE AC160 AC210
VENDOR-GROUP AM115 AM117
COMPANY AM15.1 AM15.2
VENDOR AM15.3 AM15.4
INVOICE AM18.1 AM19.1
SUFFIX AM19.2 AM19.4
CANCEL-SEQ AM20.1 AM20.3
SEQ-NBR AM21.1 AM21.3
VOID-SEQ AM500 AM51.1
HLD-CODE AM551 AM97.1
AP03.3 AP10.1
AP100 AP110
AP115 AP125
AP126 AP131
AP150 AP170
...
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
|