 |
Lawson Insight Technical Documentation |
|
POLINEPVT FILE
REFERENCED BY
PO254 PO54.1 PO54.2 PO54.3 PO54.4
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 API1.1 IC28.1 MA180 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.3
MA67.1 MA67.2 MA70.1 MAI1.1 PO100 PO101
PO122 PO131 PO136 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO25.2 PO25.6
PO25.7 PO25.8 PO27.3 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 PO700 POI3.1 POI7.1
POIE.1 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLP-COMPANY Numeric 4 AP125 AP126
Company The company number represents an AP131 AP25.1
established company and is entered on AP25.2 AP26.1
all function codes. AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
PO Number This field contains the number AP131 AP25.1
representing the purchase order. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-PO-RELEASE Numeric 4 AP125 AP126
PO Release Number Used to identify a purchase order AP131 AP25.1
release (created from a Blanket or AP25.2 AP26.1
Standing order). AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-PO-CODE Alpha 4 AP125 AP126
Po Code This is the purchase order code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-LINE-NBR Numeric 6 AP125 AP126
Line Number This field contains the line number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-VENDOR Alpha 9 (Right Justified) AP125 AP126
Vendor ID The vendor's identification code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-PURCH-FR-LOC Alpha 4 AP125 AP126
Purchase From The vendor's purchase from location. AP131 AP25.1
Location Code AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-BUYER-CODE Alpha 3 AP125 AP126
Buyer Code The user defined buyer identifier. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-EARLY-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Early Delivery Date This field contains the early delivery AP131 AP25.1
(Rqst DT) date. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stocking AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-PURCH-MAJCL Alpha 4 AP125 AP126
Major Purchasing The user defined Major Purchasing Class AP131 AP25.1
Class identifier. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-PURCH-MINCL Alpha 4 AP125 AP126
Minor Purchasing The user defined Minor purchasing Class AP131 AP25.1
Class identifier. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-STATUS Numeric 1 AP125 AP126
Status This field displays the status of the AP131 AP25.1
transaction. It is a conversion of flags AP25.2 AP26.1
(released, closed ...) AP27.1 API1.1
1 = Unreleased IC28.1 MA180
2 = Released MA43.9 MA530
3 = Issued MA531 MA60.2
5 = Open Receivings MA60.3 MA60.5
7 = Closed MA61.1 MA66.3
9 = Cancelled MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
PLP-EXTENDED-AMT Signed 15.2 AP125 AP126
Extended Amt AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.2 PO25.6
PO25.7 PO25.8
PO254 PO27.3
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
PO54.1 PO54.2
...
POLINEPVT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLPSET1 COMPANY AP125 AP126
PO-NUMBER AP131 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 API1.1
LINE-NBR IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.2 PO21.3
...
PLPSET2 COMPANY KeyChange AP125 AP126
ITEM AP131 AP25.1
LOCATION AP25.2 AP26.1
BUYER-CODE AP27.1 IC28.1
VENDOR MA180 MA43.9
PURCH-MAJCL MA530 MA531
PURCH-MINCL MA60.2 MA60.3
PO-NUMBER MA60.5 MA61.1
PO-RELEASE MA66.3 MA67.1
PO-CODE MA67.2 MA70.1
LINE-NBR MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
PLPSET3 COMPANY KeyChange AP125 AP126
ITEM AP131 AP25.1
EARLY-DL-DATE* AP25.2 AP26.1
LOCATION AP27.1 IC28.1
BUYER-CODE MA180 MA43.9
VENDOR MA530 MA531
PURCH-MAJCL MA60.2 MA60.3
PURCH-MINCL MA60.5 MA61.1
PO-NUMBER MA66.3 MA67.1
PO-RELEASE MA67.2 MA70.1
PO-CODE MAI1.1 PO100
LINE-NBR PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
PLPSET4 COMPANY KeyChange AP125 AP126
PURCH-MAJCL AP131 AP25.1
PURCH-MINCL AP25.2 AP26.1
LOCATION AP27.1 IC28.1
BUYER-CODE MA180 MA43.9
VENDOR MA530 MA531
PO-NUMBER MA60.2 MA60.3
PO-RELEASE MA60.5 MA61.1
PO-CODE MA66.3 MA67.1
LINE-NBR MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
PLPSET5 COMPANY KeyChange AP125 AP126
EARLY-DL-DATE* AP131 AP25.1
VENDOR AP25.2 AP26.1
PO-NUMBER AP27.1 IC28.1
PO-RELEASE MA180 MA43.9
PO-CODE MA530 MA531
LINE-NBR MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
PLPSET6 COMPANY KeyChange AP125 AP126
STATUS AP131 AP25.1
ITEM AP25.2 AP26.1
EARLY-DL-DATE* AP27.1 IC28.1
LOCATION MA180 MA43.9
BUYER-CODE MA530 MA531
VENDOR MA60.2 MA60.3
PURCH-MAJCL MA60.5 MA61.1
PURCH-MINCL MA66.3 MA67.1
PO-NUMBER MA67.2 MA70.1
PO-RELEASE MAI1.1 PO100
PO-CODE PO101 PO122
LINE-NBR PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
|