POHDRPVT 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 PO190 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 POIT.1 RQ10.1
RQ10.2 RQ10.3 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PHP-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 PO190
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
...
PHP-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 PO190
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
...
PHP-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 PO190
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
...
PHP-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 PO190
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
...
PHP-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 PO190
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
...
PHP-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 PO190
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
...
PHP-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 PO190
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
...
PHP-PO-DATE Numeric 8 (yyyymmdd) AP125 AP126
Purchase Order Date 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 PO190
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
...
PHP-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
7 = Closed MA60.3 MA60.5
9 = Cancelled MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO136 PO190
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
...
PHP-TOT-ORDER-AMT Signed 15.2 AP125 AP126
Total Order Amount 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 PO190
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
...
PHP-NBR-LINES Numeric 6 AP125 AP126
Number of Lines This is the number of detail lines. 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 PO190
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
...
POHDRPVT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PHPSET1 COMPANY AP125 AP126
PO-CODE AP131 AP25.1
PO-NUMBER AP25.2 AP26.1
PO-RELEASE 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 PO190
PO20.1 PO21.2
...
PHPSET2 COMPANY KeyChange AP125 AP126
STATUS AP131 AP25.1
VENDOR AP25.2 AP26.1
PURCH-FR-LOC AP27.1 IC28.1
PO-DATE* MA180 MA43.9
PO-CODE MA530 MA531
PO-NUMBER MA60.2 MA60.3
PO-RELEASE 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
...
PHPSET3 COMPANY KeyChange AP125 AP126
STATUS AP131 AP25.1
BUYER-CODE AP25.2 AP26.1
PO-DATE* AP27.1 IC28.1
PO-CODE MA180 MA43.9
PO-NUMBER MA530 MA531
PO-RELEASE 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
...
PHPSET4 COMPANY KeyChange AP125 AP126
STATUS AP131 AP25.1
PO-CODE AP25.2 AP26.1
PO-DATE* AP27.1 IC28.1
PO-NUMBER MA180 MA43.9
PO-RELEASE MA530 MA531
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
...
PHPSET5 COMPANY KeyChange AP125 AP126
STATUS AP131 AP25.1
PO-DATE* AP25.2 AP26.1
PO-CODE AP27.1 IC28.1
PO-NUMBER MA180 MA43.9
PO-RELEASE MA530 MA531
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
...
|
