POAOCDTL FILE
Add On Cost Detail
Purchase Order Add On Cost Detail file. This file contains all Add On Costs
in relation to a Purchase Order. This relation can be at Purchase Order level
and/or at Purchase Order Item level.
REFERENCED BY
MA00.1 MA140 MA52.1 PO120 PO121 PO122
PO123 PO220 PO225 PO26.1 PO32.1 PO50.1
PO60.1 PO61.1 PO63.1 PO64.1 MA08.1 PO135
PO67.1
UPDATED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP26.1 BL92.1 IN20.1 MA190 MA300 MA40.1
MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.4
MA530 MA540 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE510 OE810 OE920 PO100 PO20.1
PO21.2 PO21.5 PO21.6 PO22.1 PO22.2 PO22.3
PO25.1 PO25.2 PO25.4 PO28.5 PO28.8 PO30.1
PO31.1 PO33.1 PO34.1 PO35.1 PO530 RQ20.1
RQ20.3 RQ20.4 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAO-COMPANY Numeric 4 BL92.1 MA41.6
Company The company number. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO25.4 PO28.8
PO31.1 WH20.2
WH20.7
PAO-ORDER-NAME Alpha 10 BL92.1 MA41.6
Standard Order Name The user-defined standard order name. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO22.2 PO22.3
PO25.1 PO25.4
PO28.8 WH20.2
WH20.7
PAO-PO-NUMBER Alpha 7 (Right Justified) BL92.1 MA41.6
PO Number This field contains the number OE10.1 OE10.2
representing the purchase order. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO22.2 PO22.3
PO25.4 PO28.8
PO31.1 WH20.2
WH20.7
PAO-PO-RELEASE Numeric 6 BL92.1 MA41.6
PO Release Number Used to identify a purchase order OE10.1 OE10.2
release (created from a Blanket or OE10.3 OE10.4
Standing order). OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO22.2 PO22.3
PO25.4 PO28.8
PO31.1 WH20.2
WH20.7
PAO-LINE-NBR Numeric 6 BL92.1 MA41.6
Line Number This field contains the line number. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO20.1
PO21.2 PO21.5
PO21.6 PO22.2
PO22.3 PO25.4
PO28.8 WH20.2
WH20.7
PAO-AOC-CODE Alpha 2 AP125 AP126
Add On Cost Code This field contains the identifier for AP225 AP226
the add-on cost associated with this AP25.1 AP25.2
line item. AP26.1 BL92.1
MA41.6 MA530
MA540 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 PO100
PO21.2 PO21.5
PO21.6 PO25.4
PO28.8 PO31.1
WH20.2 WH20.7
PAO-VENDOR Alpha 9 BL92.1 IN20.1
Vendor ID The vendor's identification code. MA41.6 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 PO100
PO20.1 PO21.2
PO21.5 PO21.6
PO25.4 PO28.8
PO31.1 WH20.2
WH20.7
PAO-PURCH-FR-LOC Alpha 4 BL92.1 IN20.1
Purchase From The vendor's purchase from location. MA41.6 OE10.1
Location Code OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 PO100
PO20.1 PO21.2
PO21.5 PO21.6
PO25.4 PO28.8
PO31.1 WH20.2
WH20.7
PAO-LOCATION Alpha 5 BL92.1 MA41.6
Location Code This field contains a valid stock OE10.1 OE10.2
location within the company inventory. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO25.4 PO28.8
PO31.1 WH20.2
WH20.7
PAO-ORIG-LINE-NBR Numeric 6 BL92.1 MA41.6
Original Line Number This is the line number originally OE10.1 OE10.2
assigned to this line item upon OE10.3 OE10.4
creation. OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO25.4 PO28.8
WH20.2 WH20.7
PAO-AOC-RATE Percent 7.3 (Percent) BL92.1 MA41.6
Add On Cost Rate Add-on cost percentage rate. If add-on OE10.1 OE10.2
cost is spread by rate, this value OE10.3 OE10.4
multiplied by the line unit cost is the OE10.5 OE10.6
unit add-on cost for the purchase order OE10.7 OE10.8
line. OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO25.4 PO28.8
WH20.2 WH20.7
PAO-ENTRY Alpha 1 BL92.1 MA41.6
Entry Amount entry method. OE10.1 OE10.2
U = Unit Cost Entry OE10.3 OE10.4
R = Rate Percentage Entry OE10.5 OE10.6
T = Total Amount Entry OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO25.4 PO28.8
PO31.1 WH20.2
WH20.7
PAO-QUANTITY Signed 13.4 BL92.1 IN20.1
Quantity The order quantity. MA40.1 MA41.4
MA41.6 MA43.4
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO20.1
PO21.2 PO21.5
PO21.6 PO22.2
PO22.3 PO25.2
PO25.4 PO28.5
PO28.8 WH20.2
WH20.7
PAO-VPRI-QUANTITY Signed 13.4 BL92.1 IN20.1
Vendor Price The entered line quantity system MA40.1 MA41.4
Quantity converted to vendor pricing terms. MA41.6 MA43.4
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO20.1
PO21.2 PO21.5
PO21.6 PO22.2
PO22.3 PO25.2
PO25.4 PO28.5
PO28.8 WH20.2
WH20.7
PAO-ENT-UNIT-CST Signed 13.5 BL92.1 IN20.1
Entered Unit Cost The entered unit cost. MA40.1 MA41.1
MA41.2 MA41.6
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO20.1
PO21.2 PO21.5
PO21.6 PO22.2
PO22.3 PO25.2
PO25.4 PO28.5
PO28.8 RQ20.4
WH20.2 WH20.7
PAO-TOTAL-AOC Signed 15.2 BL92.1 IN20.1
Total Add On Cost The total add-on cost amount can be an MA41.6 OE10.1
entered amount if entered at this level, OE10.2 OE10.3
or a calculated amount if a unit add-on OE10.4 OE10.5
cost or add-on cost percent is entered. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 PO100
PO20.1 PO21.2
PO21.5 PO21.6
PO22.2 PO22.3
PO25.2 PO25.4
PO28.5 PO28.8
PO31.1 RQ20.4
WH20.2 WH20.7
PAO-REC-QTY Signed 13.4 MA40.1 MA41.4
Receiving Quantity The quantity received against the MA41.6 MA43.4
purchase order line the add-on cost is PO100 PO21.2
associated with. PO21.6 PO22.2
PO22.3 PO30.1
PO33.1 PO34.1
PO35.1 PO530
PAO-APPROVE-QTY Signed 13.4 AP125 AP126
Approved Quantity The approved quantity for this line AP225 AP226
item. AP25.1 AP25.2
AP26.1 MA530
MA540 PO100
PO21.2 PO22.2
PO22.3 PO31.1
PAO-UNREL-APP-QTY Signed 13.4 AP125 AP126
Unreleased Approval Approval quantity upon entry of an AP225 AP226
Quantity Invoice line item. This quantity is AP25.1 AP25.2
established before the Invoice has AP26.1 MA40.1
been released. MA41.1 MA41.2
MA41.4 MA41.6
MA43.4 MA530
MA540 PO21.2
PO22.2 PO22.3
PO31.1
PAO-MISC-APPV-AMT Signed 15.2 AP25.1 AP25.2
Miscellaneous This is the miscellaneous add-on cost PO22.2 PO22.3
Approved Amount amount that has been approved for this
add-on cost.
PAO-MISC-UNREL-AP Signed 15.2 AP125 AP126
Misc Unreleased Defines the miscellaneous approval AP225 AP226
Approval amount which has been entered, but not AP26.1 MA40.1
released. MA41.5 MA41.6
MA530 MA540
PO22.2 PO22.3
PO31.1
PAO-RECQTY-TO-APP Signed 13.4 AP125 AP126
Receiver Quantity This is the receipt quantity that is to AP225 AP226
To Approve be approved. This is in the vendor AP26.1 BL92.1
pricing unit of measure. MA40.1 MA41.4
MA41.6 MA43.4
MA530 MA540
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO21.2 PO21.6
PO22.2 PO22.3
PO30.1 PO31.1
PO33.1 PO34.1
WH20.2 WH20.7
PAO-SPREAD-METHOD Alpha 1 BL92.1 MA41.6
Spread Method A method of spreading add-on cost OE10.1 OE10.2
amounts across the purchase order line OE10.3 OE10.4
level. Amounts are spread by quantity, OE10.5 OE10.6
volume, weight or amount. Defaults to no OE10.7 OE10.8
spread. OE11.1 OE11.4
N = No Spread OE11.8 OE11.9
Q = Quantity OE110 OE113
W = Weight OE114 OE129
V = Volume OE14.4 OE15.1
A = Amount OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO25.4 WH20.2
WH20.7
PAO-DIST-CODE Alpha 9 BL92.1 MA41.6
Distribution Code A user-defined code that may be used to OE10.1 OE10.2
set up common distribution attributes. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO21.2 PO21.6
WH20.2 WH20.7
PAO-TAX-CODE Alpha 10 AP125 AP126
Tax Code This field contains a code representing AP225 AP226
specific tax information. This must be AP25.1 AP25.2
valid Tax Code. AP26.1 BL92.1
MA41.6 MA530
MA540 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 PO100
PO21.2 PO21.5
PO21.6 PO25.4
PO28.8 PO31.1
WH20.2 WH20.7
PAO-TAXABLE-FLAG Alpha 1 BL92.1 MA41.6
Taxable or Defines if taxable. OE10.1 OE10.2
Non-Taxable Flag Y = Yes OE10.3 OE10.4
N = No OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO25.4 PO28.8
PO31.1 WH20.2
WH20.7
PAO-ORIGIN-CD Alpha 2 BL92.1 MA41.6
Origin Code This field identifies the system that OE10.1 OE10.2
created this record. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO31.1
WH20.2 WH20.7
PAO-PRINT-FLAG Alpha 1 BL92.1 MA41.6
Print on PO Indicates if the system prints the OE10.1 OE10.2
add-on cost on the purchase order. OE10.3 OE10.4
Y = Yes OE10.5 OE10.6
N = No OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO25.4 PO28.8
PO31.1 WH20.2
WH20.7
PAO-SUMMARY-FLAG Alpha 1 BL92.1 MA41.6
Summary Only Defines if the add-on cost is printed OE10.1 OE10.2
in summary or at a detail level on the OE10.3 OE10.4
purchase order. OE10.5 OE10.6
Y = Yes OE10.7 OE10.8
N = No OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO25.4 PO28.8
PO31.1 WH20.2
WH20.7
PAO-ZERO-COST-FLG Alpha 1 BL92.1 MA41.6
Zero Cost Flag Defines if this tax record is allowed OE10.1 OE10.2
to have a zero unit cost. OE10.3 OE10.4
N = No OE10.5 OE10.6
Y = Yes OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO21.2
PO21.5 PO21.6
PO25.4 PO28.8
PO31.1 WH20.2
WH20.7
PAO-RELEASED-FL Alpha 1 BL92.1 IN20.1
Released Released flag. Record is now available MA41.6 OE10.1
for further processing in the system. OE10.2 OE10.3
Y = Yes OE10.4 OE10.5
N = No OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 PO100
PO20.1 PO21.2
PO21.5 PO21.6
PO22.1 PO22.2
PO22.3 PO25.4
PO28.8 PO31.1
RQ20.1 RQ20.3
RQ20.4 WH20.2
WH20.7
PAO-CANCELLED-FL Alpha 1 BL92.1 IN20.1
Canceled Flag The canceled flag. MA41.6 OE10.1
N = No OE10.2 OE10.3
Y = Yes OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 PO100
PO20.1 PO21.2
PO21.5 PO21.6
PO22.2 PO22.3
PO25.4 PO28.8
PO31.1 WH20.2
WH20.7
PAO-CLOSED-FL Alpha 1 AP125 AP126
Closed Flag The closed flag. AP225 AP226
N = No AP25.1 AP25.2
Y = Yes AP26.1 BL92.1
MA190 MA41.6
MA530 MA540
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO20.1
PO21.2 PO21.5
PO21.6 PO22.2
PO22.3 PO25.4
PO28.8 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PAO-INV-SPRD-CRET Numeric 1 MA41.6
Inv Sprd Cret Defines if record was created during
purchase order invoice spread.
1 = Invoice Spread Difference
POAOCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAOSET1 COMPANY AP125 AP126
ORDER-NAME AP225 AP226
PO-NUMBER AP25.1 AP25.2
PO-RELEASE AP26.1 BL92.1
LINE-NBR IN20.1 MA00.1
AOC-CODE MA140 MA190
MA300 MA40.1
MA40.2 MA41.1
MA41.2 MA41.3
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
OE10.1 OE10.2
...
PAOSET2 COMPANY MA08.1 MA41.6
AOC-CODE MA530 MA540
PO-NUMBER PO21.2 PO21.5
PO-RELEASE PO31.1
ORDER-NAME
LINE-NBR
PAOSET3 COMPANY Subset PO21.1 PO22.2
ORDER-NAME Where LINE-NBR != Zeroes PO22.3
PO-NUMBER
PO-RELEASE
LINE-NBR
AOC-CODE
PAOSET4 COMPANY KeyChange, Subset MA41.4
ORDER-NAME Where CLOSED-FL = "N"
VENDOR And CANCELLED-FL = "N"
PO-NUMBER And RELEASED-FL = "Y"
PO-RELEASE
AOC-CODE
LINE-NBR
PAOSET5 COMPANY Subset MA41.4
ORDER-NAME Where CANCELLED-FL = "N"
AOC-CODE And CLOSED-FL = "N"
PO-NUMBER And RELEASED-FL = "Y"
PO-RELEASE
LINE-NBR
PAOSET6 COMPANY KeyChange, Subset PO135
PO-NUMBER Where ORDER-NAME = Spaces
PO-RELEASE
LINE-NBR
AOC-CODE
PAOSET7 COMPANY Subset PO67.1
AOC-CODE Where ORDER-NAME = Spaces
PO-NUMBER
PO-RELEASE
LINE-NBR
POAOCDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
PAO-COMPANY -> CPY-COMPANY
Iclocation ICLOCATION Not Required
PAO-COMPANY -> ICL-COMPANY
PAO-LOCATION -> ICL-LOCATION
Poaocmast POAOCMAST Required
PAO-COMPANY -> PAM-COMPANY
PAO-AOC-CODE -> PAM-AOC-CODE
Pocompany POCOMPANY Required
PAO-COMPANY -> PCY-COMPANY
Polinedtl POLINE Required
When PAO-LINE-NBR != Zeroes
And PAO-ORDER-NAME = Spaces
PAO-COMPANY -> PLI-COMPANY
PAO-PO-NUMBER -> PLI-PO-NUMBER
PAO-PO-RELEASE -> PLI-PO-RELEASE
PAO-LINE-NBR -> PLI-LINE-NBR
Purchorder PURCHORDER Required
When PAO-ORDER-NAME = Spaces
PAO-COMPANY -> PCR-COMPANY
PAO-PO-NUMBER -> PCR-PO-NUMBER
PAO-PO-RELEASE -> PCR-PO-RELEASE
Stpoline STPOLINE Required
When PAO-ORDER-NAME != Spaces
And PAO-LINE-NBR != Zeroes
PAO-COMPANY -> SPL-COMPANY
PAO-ORDER-NAME -> SPL-ORDER-NAME
PAO-LINE-NBR -> SPL-LINE-NBR
Stpurchorder STPURCHORD Required
When PAO-ORDER-NAME != Spaces
PAO-COMPANY -> SPO-COMPANY
PAO-ORDER-NAME -> SPO-ORDER-NAME
Vendloc APVENLOC Not Required
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
PAO-VENDOR -> VLO-VENDOR
PAO-PURCH-FR-LOC -> VLO-LOCATION-CODE
Vendor APVENMAST Not Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
PAO-VENDOR -> VEN-VENDOR
POAOCDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poapprove POAPPROVE Delete Restricted
PAO-COMPANY -> POA-COMPANY
PAO-PO-NUMBER -> POA-PO-NUMBER
PAO-PO-RELEASE -> POA-PO-RELEASE
PAO-LINE-NBR -> POA-LINE-NBR
PAO-VENDOR -> POA-VENDOR
PAO-AOC-CODE -> POA-AOC-CODE
POA-INVOICE
POA-SUFFIX
Poinvoice POINVOICE Delete Restricted
PAO-COMPANY -> POI-COMPANY
PAO-PO-NUMBER -> POI-PO-NUMBER
PAO-PO-RELEASE -> POI-PO-RELEASE
POI-VENDOR
POI-INVOICE
POI-SUFFIX
Poline Dlv Dte POLINE
PAO-COMPANY -> PLI-COMPANY
PAO-LOCATION -> PLI-LOCATION
PLI-EARLY-DL-DATE
PLI-PO-NUMBER
PLI-PO-RELEASE
PLI-LINE-NBR
|