Lawson Insight Technical Documentation |
|
POLINEPVT
POLINEPVT FILE
This is used to create records for the purchase order inquiry form PO54
REFERENCED BY
PO223 PO254 PO54.1 PO54.2 PO54.3 PO54.4
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 IC28.1 MA180
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO122 PO131
PO136 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 PO700
POD0.1 POI3.1 POI7.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ10.3 RQIE.1 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLP-COMPANY Numeric 4 AP125 AP126
Element: Company The company number represents an AP131 AP20.1
established company and is entered on AP20.2 AP20.3
all function codes. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: PO Number This field contains the number AP131 AP20.1
representing the purchase order. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumUsed to identify a purchase order AP131 AP20.1
release (created from a Blanket or AP20.2 AP20.3
Standing order). AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-PO-CODE Alpha 4 AP125 AP126
Element: Po Code This is the purchase order code. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor ID The vendor's identification code. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-PURCH-FR-LOC Alpha 4 AP125 AP126
Purchase From The vendor's purchase from location. AP131 AP20.1
Location Code AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-BUYER-CODE Alpha 3 AP125 AP126
Element: Buyer AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-EARLY-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stocking AP131 AP20.1
location within the company inventory. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP131 AP20.1
identifier. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-PURCH-MAJCL Alpha 4 AP125 AP126
Element: Major Class AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-PURCH-MINCL Alpha 4 AP125 AP126
Element: Minor Class AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-STATUS Numeric 1 AP125 AP126
Element: Status This field displays the status of the AP131 AP20.1
transaction. It is a conversion of flags AP20.2 AP20.3
(released, closed ...) AP20.4 AP20.5
1 = Unreleased AP20.7 AP23.1
2 = Released AP25.1 AP25.2
3 = Issued AP26.1 AP27.1
5 = Open Receivings AP30.4 API1.1
7 = Closed IC28.1 MA180
9 = Cancelled MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
PLP-EXTENDED-AMT Signed 15.2 AP125 AP126
Element: Extended Amt AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO223 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO254 PO27.2
PO29.1 PO30.1
...
POLINEPVT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLPSET1 COMPANY AP125 AP126
PO-NUMBER AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
LINE-NBR AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
PLPSET2 COMPANY KeyChange AP125 AP126
ITEM AP131 AP20.1
LOCATION AP20.2 AP20.3
BUYER-CODE AP20.4 AP20.5
VENDOR AP20.7 AP23.1
PURCH-MAJCL AP25.1 AP25.2
PURCH-MINCL AP26.1 AP27.1
PO-NUMBER AP30.4 API1.1
PO-RELEASE IC28.1 MA180
PO-CODE MA41.2 MA41.7
LINE-NBR MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
PLPSET3 COMPANY KeyChange AP125 AP126
ITEM AP131 AP20.1
EARLY-DL-DATE* AP20.2 AP20.3
LOCATION AP20.4 AP20.5
BUYER-CODE AP20.7 AP23.1
VENDOR AP25.1 AP25.2
PURCH-MAJCL AP26.1 AP27.1
PURCH-MINCL AP30.4 API1.1
PO-NUMBER IC28.1 MA180
PO-RELEASE MA41.2 MA41.7
PO-CODE MA43.1 MA43.2
LINE-NBR MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
PLPSET4 COMPANY KeyChange AP125 AP126
PURCH-MAJCL AP131 AP20.1
PURCH-MINCL AP20.2 AP20.3
LOCATION AP20.4 AP20.5
BUYER-CODE AP20.7 AP23.1
VENDOR AP25.1 AP25.2
PO-NUMBER AP26.1 AP27.1
PO-RELEASE AP30.4 API1.1
PO-CODE IC28.1 MA180
LINE-NBR MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
PLPSET5 COMPANY KeyChange AP125 AP126
EARLY-DL-DATE* AP131 AP20.1
VENDOR AP20.2 AP20.3
PO-NUMBER AP20.4 AP20.5
PO-RELEASE AP20.7 AP23.1
PO-CODE AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
PLPSET6 COMPANY KeyChange AP125 AP126
STATUS AP131 AP20.1
ITEM AP20.2 AP20.3
EARLY-DL-DATE* AP20.4 AP20.5
LOCATION AP20.7 AP23.1
BUYER-CODE AP25.1 AP25.2
VENDOR AP26.1 AP27.1
PURCH-MAJCL AP30.4 API1.1
PURCH-MINCL IC28.1 MA180
PO-NUMBER MA41.2 MA41.7
PO-RELEASE MA43.1 MA43.2
PO-CODE MA43.3 MA43.9
LINE-NBR MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
|