 |
Lawson Insight Technical Documentation |
|
PURCHORDER FILE
Purchase Order Master
This file contains header information for each purchase order.
REFERENCED BY
POA3.1 AP30.2 AP32.2 AP520 API1.1 API2.1
IC130 MA63.1 MA65.1 PO01.1 PO133 PO135
PO16.1 PO16.2 PO216 PO220 PO223 PO224
PO227 PO230 PO233 PO26.1 PO274 PO275
PO276 PO277 PO280 PO295 PO550 PO60.1
PO61.1 PO62.1 PO63.1 PO64.1 PO66.1 PO67.1
PO68.1 POCP.1 POED.1 POI4.1 POI6.1 POIF.1
POIH.1 AP300 API3.1 API4.1 PO10.1 PO24.1
PO04.1 PO120 PO529
UPDATED BY
PO130 PO136 PO190 POI7.1 POIJ.1 POIT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCR-COMPANY Numeric 4 AP30.2 AP32.2
Company The company number represents a defined AP520 API1.1
company and is entered on all actions. API2.1 MA63.1
MA65.1 PO136
For conversion: PO190 PO220
Fatal Error - If equal to spaces, or PO64.1 POCP.1
zeros, or not numeric, or either POED.1 POI7.1
Purchase Order company, Inventory POIF.1 POIJ.1
Control company, or Accounts Payable POIT.1
company is not found, then the purchase
order is not loaded.
PCR-PO-NUMBER Alpha 14 (Right Justified) AP30.2 AP32.2
PO Number This field contains the number AP520 API1.1
representing the purchase order. API2.1 MA63.1
MA65.1 PO136
For conversion: PO190 PO220
Fatal Error - If equal to spaces, or PO64.1 POCP.1
the purchase order company flag says it POED.1 POI7.1
must be numeric and it is not, or the POIF.1 POIJ.1
purchase order already exists, then the POIT.1
purchase order is not loaded. Also, if
previously processed, then the record is
skipped.
PCR-PO-RELEASE Numeric 4 AP30.2 AP32.2
PO Release Number Used to identify a purchase order AP520 API1.1
release (created from a Blanket or API2.1 MA63.1
Standing order). MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-PO-CODE Alpha 4 AP30.2 AP32.2
Po Code This is the purchase order code. AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-PO-REVISION Numeric 3 AP30.2 AP32.2
PO Revision Number The purchase order revision number. AP520 API1.1
Assigned sequentially by the system when API2.1 MA63.1
the purchase order is revised. MA65.1 PO136
PO190 PO220
For conversion: PO64.1 POCP.1
Fatal Error - If not numeric, then the POED.1 POI7.1
purchase order is not loaded. POIF.1 POIJ.1
POIT.1
PCR-RETURN-NUMBER Numeric 10 AP30.2 AP32.2
Return Number This is the number assigned to the AP520 API1.1
return for purposes of referencing the API2.1 MA63.1
return internally and with the customer MA65.1 PO136
or vendor. PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-VENDOR Alpha 9 (Right Justified) AP30.2 AP32.2
Vendor ID This field contains the vendor's AP520 API1.1
identification code. API2.1 MA63.1
MA65.1 PO136
For conversion: PO190 PO220
This is allowed to be changed for PO64.1 POCP.1
matching load program. POED.1 POI7.1
Non-Fatal Error - Entry release edits POIF.1 POIJ.1
are applied. If an edit fails, the POIT.1
purchase order is loaded at an
unreleased status.
Fatal Error - If not found in Accounts
Payable, or does not pass vendor number
edit, then the purchase order is not
loaded. Cannot change if approval
activity exits.
PCR-PURCH-FR-LOC Alpha 4 AP30.2 AP32.2
Purchase From The vendor's purchase from location. AP520 API1.1
Location Code It is validated against the Accounts API2.1 MA63.1
Payable vendor alternate location MA65.1 PO136
master. PO190 PO220
PO64.1 POCP.1
For conversion: POED.1 POI7.1
This is allowed to be changed for POIF.1 POIJ.1
matching load program. POIT.1
Fatal Error - If not found in Accounts
Payable, or not a purchase from, the
purchase order is not loaded. Cannot be
changed if approval activity exists.
PCR-BUYER-CODE Alpha 3 AP30.2 AP32.2
Buyer Code The user-defined buyer identification AP520 API1.1
code. API2.1 MA63.1
MA65.1 PO136
For conversion: PO190 PO220
Nonfatal Error - Entry release edits PO64.1 POCP.1
are applied. If an edit fails, the POED.1 POI7.1
purchase order is loaded at an POIF.1 POIJ.1
unreleased status. POIT.1
Default - Purchase order company buyer
code.
PCR-BLKT-STD-AGRMT Alpha 30 AP30.2 AP32.2
Blkt Std Agrmt This field has a value attached to it AP520 API1.1
when a purchase order is a release from API2.1 MA63.1
a blanket or standing order. The field MA65.1 PO136
is equal to the agreement reference PO190 PO220
number for the blanket or standing PO64.1 POCP.1
order. POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-PO-DATE Numeric 8 (yyyymmdd) AP30.2 AP32.2
Purchase Order Date The date for this purchase order. AP520 API1.1
API2.1 MA63.1
For conversion: MA65.1 PO136
Fatal Error - If not numeric or invalid PO190 PO220
date, than the purchase order is not PO64.1 POCP.1
loaded. POED.1 POI7.1
Default - System date. POIF.1 POIJ.1
POIT.1
PCR-PO-OBJ-ID Alpha 10 (Right Justified) AP30.2 AP32.2
Po Obj Id The PO Object ID is used as a document AP520 API1.1
number for the warehouse system. This API2.1 MA63.1
field, along with the PO Line number, is MA65.1 PO136
used to relate POLINE records to PO190 PO220
WHDEMAND records. A unique PO Object ID PO64.1 POCP.1
is obtained when the PO number is POED.1 POI7.1
assigned in PO creation. It is passed POIF.1 POIJ.1
on the to the PO line when the PO line POIT.1
is created. The PO Object ID is
populated on the PO line only for the
duration of time that a WHDEMAND supply
type record exists for the PO line (from
PO line creation until full receipt or
cancel or the PO line).
PCR-CURRENCY-CODE Alpha 5 AP30.2 AP32.2
Currency Code This field contains the company's base AP520 API1.1
currency code defined in the General API2.1 MA63.1
Ledger company form. MA65.1 PO136
PO190 PO220
For conversion: PO64.1 POCP.1
Nonfatal Error - If not company base, POED.1 POI7.1
and not Accounts Payable vendor balance, POIF.1 POIJ.1
Purchase Order company does not allow POIT.1
multiple currencies and not company
base, or not found, then reset to
spaces.
Fatal Error - If no currency relation
found and either conversion rate or
currency flag is blank.
Default - Accounts Payable vendor
location invoice currency, Accounts
Payable vendor balance currency,
Accounts Payable vendor invoice
currency.
PCR-ENT-CNV-RATE Signed 12.6 AP30.2 AP32.2
Entered Conversion Currency conversion rate at purchase AP520 API1.1
Rate order entry time. API2.1 MA63.1
MA65.1 PO136
For conversion: PO190 PO220
Nonfatal Error - If company base, and PO64.1 POCP.1
not equal to zeros, then reset to zeros. POED.1 POI7.1
If not company base and equal to zeros, POIF.1 POIJ.1
then reset to general ledger. POIT.1
Fatal Error - If not company base and
equal to zeroes and invalid currency
code.
Default - Currency base rate.
PCR-REC-CNV-RATE Signed 12.6 AP30.2 AP32.2
Receiving Exchange Currency conversion rate for the AP520 API1.1
Rate purchase order at receiving time. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-CURR-SET-FLAG Alpha 1 AP30.2 AP32.2
Currency Set Flag Flag defines when the currency rate has AP520 API1.1
been set for the purchase order. API2.1 MA63.1
MA65.1 PO136
For conversion: PO190 PO220
Nonfatal Errors - If not equal to PO64.1 POCP.1
spaces, E, I, or R, then reset to E. POED.1 POI7.1
Default - E. POIF.1 POIJ.1
POIT.1
E = Entry
R = Receiving
I = Invoicing
PCR-REVALUE-FLAG Alpha 1 AP30.2 AP32.2
Revalue Currency is reevaluated when Accounts AP520 API1.1
Payable prints a check in a currency API2.1 MA63.1
other than that defined on the purchase MA65.1 PO136
order or invoice. PO190 PO220
PO64.1 POCP.1
For conversion: POED.1 POI7.1
Nonfatal Error - If not equal to Yes or POIF.1 POIJ.1
No, then reset to Yes (the default). POIT.1
Y = Yes
N = No
PCR-DFLT-DL-DATE Numeric 8 (yyyymmdd) AP30.2 AP32.2
Default Delivery Default early delivery date. AP520 API1.1
Date API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-LOCATION Alpha 5 AP30.2 AP32.2
Ship To This field contains a valid stock AP520 API1.1
location within the company inventory. API2.1 MA63.1
MA65.1 PO136
For conversion: PO190 PO220
Fatal Error - If equal to spaces, or PO64.1 POCP.1
not found in Inventory Control, then the POED.1 POI7.1
purchase order is not loaded. POIF.1 POIJ.1
POIT.1
PCR-SH-NAME Alpha 30 (Lower Case) AP30.2 AP32.2
Ship To Name This is the ship-to name. AP520 API1.1
API2.1 MA63.1
For conversion: MA65.1 PO136
Nonfatal Error - If not equal to spaces PO190 PO220
and address equal spaces. PO64.1 POCP.1
Default - Inventory Control location POED.1 POI7.1
ship name. POIF.1 POIJ.1
POIT.1
PCR-SH-ADDR1 Alpha 30 (Lower Case) AP30.2 AP32.2
Ship To Address This is the ship-to address line one. AP520 API1.1
Line 1 API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-SH-ADDR2 Alpha 30 (Lower Case) AP30.2 AP32.2
Ship To Address This is the ship-to address line two. AP520 API1.1
Line 2 API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-SH-ADDR3 Alpha 30 (Lower Case) AP30.2 AP32.2
Ship To Address This is the ship-to address line three. AP520 API1.1
Line 3 API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-SH-ADDR4 Alpha 30 (Lower Case) AP30.2 AP32.2
Ship To Address This is the ship-to address line four. AP520 API1.1
Line 4 API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-SH-CITY-ADDR5 Alpha 18 (Lower Case) AP30.2 AP32.2
Ship To City or This is the ship-to city or the ship-to AP520 API1.1
Address Line 5 address line five. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-SH-STATE-PROV Alpha 2 AP30.2 AP32.2
Ship To State or This is the ship-to state or the AP520 API1.1
Province ship-to province. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-SH-POST-CODE Alpha 10 (Lower Case) AP30.2 AP32.2
Ship To Postal Code This is the ship-to mail code. AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-SH-COUNTRY Alpha 30 (Lower Case) AP30.2 AP32.2
Ship To Country This is the ship-to country. AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-SH-COUNTY Alpha 25 (Lower Case) AP30.2 AP32.2
Sh County AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-SH-PHONE-PREF Alpha 6 AP30.2 AP32.2
Ship To Telephone This is the ship-to telephone number AP520 API1.1
Country Code prefix. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-SH-PHONE Alpha 15 AP30.2 AP32.2
Ship To Telephone This is the ship-to telephone number. AP520 API1.1
Number API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-SH-PHONE-EXT Alpha 5 AP30.2 AP32.2
Ship To Telephone The ship-to telephone extension number. AP520 API1.1
Extension API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-SH-CONTACT Alpha 30 (Lower Case) AP30.2 AP32.2
Ship To Contact This is the ship-to contact. AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-NBR-LINES Numeric 6 AP30.2 AP32.2
Number of Lines The total number of lines on this AP520 API1.1
purchase order. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-CLOSED-LINES Numeric 6 AP30.2 AP32.2
Closed Lines The number of closed lines for this AP520 API1.1
purchase order. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-DROPSHIP-FL Alpha 1 AP30.2 AP32.2
Dropship Flag This flag indicates whether this is a AP520 API1.1
dropship purchase order. A dropship API2.1 MA63.1
purchase order is not received. MA65.1 PO136
PO190 PO220
For conversion: PO64.1 POCP.1
Nonfatal Error - If not equal to Y or POED.1 POI7.1
N, then reset to N (the default). POIF.1 POIJ.1
N = Receiving Required POIT.1
Y = Receiving Not Allowed
PCR-PRT-REC-FLAG Alpha 1 AP30.2 AP32.2
Print Receiver Flag The purchase order creates receiver AP520 API1.1
documents when this print receiver flag API2.1 MA63.1
is coded Y and it is part of the MA65.1 PO130
selection criteria for the receiving PO136 PO190
print program. PO220 PO64.1
POCP.1 POED.1
For conversion: POI7.1 POIF.1
Nonfatal Error - If not equal to Yes or POIJ.1 POIT.1
No, then reset to Yes (the default).
N = No
Y = Yes
PCR-FAX-PREFIX Alpha 6 AP30.2 AP32.2
Fax Country Code Fax number prefix. AP520 API1.1
API2.1 MA63.1
For conversion: MA65.1 PO136
Default - Purchase order vendor PO190 PO220
location fax prefix. PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-FAX-NUMBER Alpha 15 AP30.2 AP32.2
Fax Number Fax number. AP520 API1.1
API2.1 MA63.1
For conversion: MA65.1 PO136
Default - Purchase order vendor PO190 PO220
location fax number. PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-FAX-EXT Alpha 5 AP30.2 AP32.2
Fax Extension Fax number extension. AP520 API1.1
API2.1 MA63.1
For conversion: MA65.1 PO136
Default - Purchase order vendor PO190 PO220
location fax extension. PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-PROCESS-LEVEL Alpha 5 AP30.2 AP32.2
Process Level This field contains the process level, AP520 API1.1
which is the reporting hierarchy below API2.1 MA63.1
company. MA65.1 PO136
PO190 PO220
For conversion: PO64.1 POCP.1
Nonfatal Error - If not found in POED.1 POI7.1
Accounts Payable. POIF.1 POIJ.1
POIT.1
PCR-WEIGHT Signed 9.3 AP30.2 AP32.2
Unit Weight This field contains the unit weight of AP520 API1.1
the item based on the stock unit of API2.1 MA63.1
measure. MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-CUBIC-FEET Signed 9.3 AP30.2 AP32.2
Cubic Feet This field contains the unit cubit feet AP520 API1.1
of the item based on the stock unit of API2.1 MA63.1
measure. MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-FREIGHT-TERMS Alpha 1 AP30.2 AP32.2
Freight Terms The freight terms code for this AP520 API1.1
purchase order. API2.1 MA63.1
MA65.1 PO136
For conversion: PO190 PO220
Nonfatal Error - If not found then PO64.1 POCP.1
reset to purchase order company freight POED.1 POI7.1
terms. POIF.1 POIJ.1
Default - purchase order company POIT.1
freight terms.
PCR-FOB-CODE Alpha 3 AP30.2 AP32.2
Shipping Term Code The user-defined ship term code for AP520 API1.1
this purchase order. API2.1 MA63.1
MA65.1 PO136
For conversion: PO190 PO220
Nonfatal Error - If not found. PO64.1 POCP.1
Default - Purchase order vendor POED.1 POI7.1
location ship term, purchase order POIF.1 POIJ.1
vendor ship term. POIT.1
PCR-SHIP-VIA Alpha 12 (Lower Case) AP30.2 AP32.2
Ship Via Description The purchase order ship via narrative AP520 API1.1
defaults from the vendor or is entered. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-TERM-CODE Alpha 5 AP30.2 AP32.2
Terms Code A user-defined code representing a AP520 API1.1
method of determining an invoices due API2.1 MA63.1
and discount dates. MA65.1 PO136
PO190 PO220
For conversion: PO64.1 POCP.1
Default - Accounts Payable Vendor POED.1 POI7.1
location term code, Accounts Payable POIF.1 POIJ.1
Vendor term code. If present, overrides POIT.1
due days, discount days and discount
rate.
PCR-TAX-CODE Alpha 10 AP30.2 AP32.2
Tax Code This field contains a code representing AP520 API1.1
specific tax information. This must be API2.1 MA63.1
valid tax code in the Tax system. MA65.1 PO136
PO190 PO220
For conversion: PO64.1 POCP.1
Nonfatal Error - If not found, or tax POED.1 POI7.1
is landed and company is standard cost, POIF.1 POIJ.1
then reset to spaces. POIT.1
Default - Accounts Payable vendor
location tax code, Accounts Payable
vendor tax code.
PCR-TOT-PRD-AMT Signed 15.2 AP30.2 AP32.2
Total Product Amount This is the total product amount AP520 API1.1
associated with the purchase order. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-TOT-TAXBL-AMT Signed 15.2 AP30.2 AP32.2
Total Taxable Amount The total taxable amount for the AP520 API1.1
purchase order. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-LETTER-OF-CR Alpha 20 AP30.2 AP32.2
Letter of Credit This field contains the letter of AP520 API1.1
credit. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-TOT-ORDER-AMT Signed 15.2 AP30.2 AP32.2
Total Order Amount The total order amount for the purchase AP520 API1.1
order. This includes the total product API2.1 MA63.1
cost, all add-on costs (for all vendors, MA65.1 PO136
whether printed or not) and all taxes PO190 PO220
(whether invoiced or accrued). PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-USER-DATE-1 Numeric 8 (yyyymmdd) AP30.2 AP32.2
User Date 1 This is the user date one. AP520 API1.1
API2.1 MA63.1
For conversion: MA65.1 PO136
Non-Fatal Error - If not numeric, or PO190 PO220
invalid, then reset to zeros. PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-USER-DATE-2 Numeric 8 (yyyymmdd) AP30.2 AP32.2
User Date 2 This is the user date two. AP520 API1.1
API2.1 MA63.1
For conversion: MA65.1 PO136
Nonfatal Error - If not numeric, or PO190 PO220
invalid, then reset to zeros. PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-LAST-LINE-NBR Numeric 6 AP30.2 AP32.2
Last Line Number This is the last line number on the AP520 API1.1
purchase order. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-DFLT-TAXBL-FL Alpha 1 AP30.2 AP32.2
Default Taxable Flag This taxable flag is used to default a AP520 API1.1
Yes or No, for special and service items API2.1 MA63.1
when adding them to a purchase order. MA65.1 PO136
PO190 PO220
The nonstock and inventory items have PO64.1 POCP.1
this flag defined in the Inventory POED.1 POI7.1
Control system. POIF.1 POIJ.1
POIT.1
For conversion:
Nonfatal Error - If not equal to
spaces, Yes, or No, then reset to No
(the default).
Y = Yes
N = No
PCR-DFLT-ACCT-UNIT Alpha 15 AP30.2 AP32.2
Dflt Acct Unit AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-DFLT-ACCOUNT Numeric 6 AP30.2 AP32.2
Dflt Account AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-DFLT-SUB-ACCT Numeric 4 AP30.2 AP32.2
Dflt Sub Acct AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-DFLT-DIST-CO Numeric 4 AP30.2 AP32.2
Dflt Dist Co AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-DFLT-ACTIVITY Alpha 15 AP30.2 AP32.2
Dflt Activity AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-DFLT-ACCT-CAT Alpha 5 AP30.2 AP32.2
Dflt Acct Cat AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-DFLT-REQ-LOC Alpha 5 AP30.2 AP32.2
Dflt Req Loc AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-DFLT-REQUESTER Alpha 10 (Lower Case) AP30.2 AP32.2
Dflt Requester AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-DFLT-DEL-TO Alpha 30 (Lower Case) AP30.2 AP32.2
Dflt Del To AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-DFLT-SRC-DOC Alpha 10 AP30.2 AP32.2
Dflt Src Doc AP520 API1.1
API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-RELEASED-FL Alpha 1 AP30.2 AP32.2
Released Released Flag. Record is now AP520 API1.1
available for further processing in API2.1 MA63.1
the system. MA65.1 PO136
PO190 PO220
For conversion: PO64.1 POCP.1
Nonfatal Error - If not equal to Y or POED.1 POI7.1
N, then reset to N (the default). POIF.1 POIJ.1
N = No POIT.1
Y = Yes
PCR-ISSUED-FLAG Alpha 1 AP30.2 AP32.2
Issued Flag This is the issue status of the purchase AP520 API1.1
order. If the PO has been issued at API2.1 MA63.1
least once, this flag will be set to a MA65.1 PO136
value of "Y". Once set to "Y", it never PO190 PO220
changes. PO64.1 POCP.1
For conversion: POED.1 POI7.1
Fatal Error - If not equal to Y or N, POIF.1 POIJ.1
then this purchase order is not loaded. POIT.1
N = No
Y = Yes
PCR-REVISED-FL Alpha 1 AP30.2 AP32.2
Revised Flag This is the purchase order revised AP520 API1.1
status flag. API2.1 MA63.1
N = No MA65.1 PO136
Y = Yes PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-CANCELLED-FL Alpha 1 AP30.2 AP32.2
Canceled Flag This is the purchase order canceled AP520 API1.1
status flag. API2.1 MA63.1
N = No MA65.1 PO136
Y = Yes PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-CLOSED-FL Alpha 1 AP30.2 AP32.2
Closed Flag The closed flag. AP520 API1.1
N = No API2.1 MA63.1
Y = Yes MA65.1 PO136
H = Historical PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-LAST-ACTIVITY Numeric 8 (yyyymmdd) AP30.2 AP32.2
Last Activity This date reflects the last time any AP520 API1.1
activity has been applied to this API2.1 MA63.1
purchase order. Activity consists of MA65.1 PO136
receiving or invoicing of any line item PO190 PO220
on the purchase order. This includes any PO64.1 POCP.1
receiving adjustments or receiving POED.1 POI7.1
rejections. POIF.1 POIJ.1
POIT.1
For conversion:
Default - System date.
PCR-CLOSE-DATE Numeric 8 (yyyymmdd) AP30.2 AP32.2
Close Date This is the date the purchase order was AP520 API1.1
closed. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-PO-USER-FLD-1 Alpha 1 AP30.2 AP32.2
Purchase Order User Purchase order header user field one. AP520 API1.1
Field 1 API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-PO-USER-FLD-3 Alpha 10 (Lower Case) AP30.2 AP32.2
Purchase Order User Purchase order header user field two. AP520 API1.1
Field 3 API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-PO-USER-FLD-5 Alpha 30 (Lower Case) AP30.2 AP32.2
Purchase Order User Purchase order header user field three. AP520 API1.1
Field 5 API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-INVC-MTHD-CODE Alpha 3 AP30.2 AP32.2
Invc Mthd Code The method the vendor is to use to AP520 API1.1
invoice the order (manual, EDI, or API2.1 MA63.1
evaluated receipts settlement). MA65.1 PO136
IBM = Invoice By Mail PO190 PO220
IEL = Invoice Electonically PO64.1 POCP.1
INR = Invoice Not Required POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-ISSUE-METH Alpha 1 AP30.2 AP32.2
Issue Meth Specifies the method that will be used AP520 API1.1
to issue the purchase order to the API2.1 MA63.1
vendor. MA65.1 PO136
P = Paper PO190 PO220
F = Fax PO64.1 POCP.1
E = EDI POED.1 POI7.1
I = Internet Mail POIF.1 POIJ.1
D = Do Not Print POIT.1
PCR-REVISIONS-INCL Alpha 1 AP30.2 AP32.2
Revisions Incl Specifies what information will be AP520 API1.1
included when a revised purchase order API2.1 MA63.1
is re-issued. MA65.1 PO136
PO190 PO220
You may specify that only the revised PO64.1 POCP.1
information is included, along with POED.1 POI7.1
messages that indicate what was revised POIF.1 POIJ.1
(option O - Revisions Only). POIT.1
Alternately, you may specify that the
entire purchase order is included,
along with messages that indicate the
revisions.
Finally, you may specify that the entire
purchase order is re-issued. No
revision messages will appear.
If the purchase order has not been
printed, or the revised purchase order
is not to be re-issued, this field will
be blank (Not Applicable).
O = Revisions Only
C = Revisions Complete
I = Reissue
N = Not Applicable
" " = Not Revised
PCR-ISSUE-PENDING Alpha 1 AP30.2 AP32.2
Issue Pending Indicates whether the purchase order AP520 API1.1
will be processed if it meets the API2.1 MA63.1
selection criteria specified in PO120 MA65.1 PO136
(Purchase Order Issue). PO190 PO220
Y = Yes PO64.1 POCP.1
N = No POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-USER-ID Alpha 10 (Lower Case) AP30.2 AP32.2
User ID Name Contains the user ID of the person who AP520 API1.1
originally released the purchase order. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-PO-AOC-TOTAL Signed 15.2 AP30.2 AP32.2
Po Aoc Total The total amount for add on costs that AP520 API1.1
are printed on the purchase order. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-PO-TAX-TOTAL Signed 15.2 AP30.2 AP32.2
Po Tax Total The total amount of invoiced taxes that AP520 API1.1
are printed on the purchase order. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-PO-PRINT-TOTAL Signed 15.2 AP30.2 AP32.2
Po Print Total The total amount printed on the purchase AP520 API1.1
order. This equals the total for API2.1 MA63.1
product, add on costs that are printed MA65.1 PO136
on the purchase order, and taxes that PO190 PO220
are printed on the purchase order. PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-POV-AOC-TOTAL Signed 15.2 AP30.2 AP32.2
Pov Aoc Total The total for all add on costs from the AP520 API1.1
purchase order vendor, whether they are API2.1 MA63.1
printed on the purchase order or not. MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-POV-ITAX-TOTAL Signed 15.2 AP30.2 AP32.2
Pov Itax Total The total tax that the purchase order AP520 API1.1
vendor will invoice. Includes invoiced API2.1 MA63.1
taxes for product as well as invoiced MA65.1 PO136
taxes for add on costs from the PO190 PO220
purchase order vendor, regardless of PO64.1 POCP.1
whether the add on cost is printed on POED.1 POI7.1
the purchase order. POIF.1 POIJ.1
POIT.1
PCR-POV-GRD-TOTAL Signed 15.2 AP30.2 AP32.2
Pov Grd Total The total amount the purchase order AP520 API1.1
vendor will invoice for this order. API2.1 MA63.1
Includes all product costs, add on costs MA65.1 PO136
charged by the purchase order vendor, PO190 PO220
and invoiced taxes for the above. PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-OV-AOC-TOTAL Signed 15.2 AP30.2 AP32.2
Ov Aoc Total The total amount for add on costs from AP520 API1.1
third party vendors. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-OV-ITAX-TOTAL Signed 15.2 AP30.2 AP32.2
Ov Itax Total The total tax that third party vendors AP520 API1.1
will invoice for the purchase order. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-OV-GRD-TOTAL Signed 15.2 AP30.2 AP32.2
Ov Grd Total The total amount that third party AP520 API1.1
vendors will invoice for the purchase API2.1 MA63.1
order. MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-ACCR-TAX-TOTAL Signed 15.2 AP30.2 AP32.2
Accr Tax Total The total accrued tax for the purchase AP520 API1.1
order. API2.1 MA63.1
MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-OPEN-PO-AMT Signed 15.2 AP30.2 AP32.2
Open PO Amount The portion of the total or extended AP520 API1.1
ordered amount that is still open -- API2.1 MA63.1
that is, it has not been cancelled or MA65.1 PO136
paid. This is always expressed in the PO190 PO220
company base currency, and includes only PO64.1 POCP.1
product costs (add on costs and taxes POED.1 POI7.1
are not included). POIF.1 POIJ.1
POIT.1
PCR-UNLOADING-PORT Alpha 5 AP30.2 AP32.2
Unloading Port The prot where the goods are unloaded if AP520 API1.1
required. Must be defined in IN04.1 API2.1 MA63.1
(Port Maintenance) MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-DEST-REGION Alpha 2 AP30.2 AP32.2
Dest Region The region of the country to which the AP520 API1.1
goods were shipped, if required. Must API2.1 MA63.1
be a valid region in IN02.1 (Region MA65.1 PO136
Maintenance) PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-NOTC Alpha 2 AP30.2 AP32.2
Notc The Nature of Transaction code. Must AP520 API1.1
be a valid code defined in IN07.1 (NOTC API2.1 MA63.1
Maintenance). MA65.1 PO136
PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-STAT-PROC Alpha 6 AP30.2 AP32.2
Stat Proc The statistical procedure code applied AP520 API1.1
to the data. The code must be defined API2.1 MA63.1
in IN06.1. (Statistical Procedure MA65.1 PO136
Maintenance). PO190 PO220
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCR-LOC-NAME-DRV Derived
Loc Name Drv
PCR-PURCH-FR-NAME Derived
Purch Fr Name
PCR-BUYER-NAME-DRV Derived
Buyer Name Drv
PCR-DISP-PO-REL-CD Derived
Disp Po Rel Cd
PCR-DISP-PO-REL Derived
Disp Po Rel
PCR-DISP-DOC-NBR Derived
Disp Doc Nbr
PURCHORDER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCRSET1 COMPANY AP30.2 AP32.2
PO-CODE AP520 API1.1
PO-NUMBER API2.1 IC130
PO-RELEASE MA63.1 MA65.1
PO01.1 PO130
PO133 PO135
PO136 PO16.1
PO16.2 PO190
PO216 PO220
PO223 PO224
PO227 PO230
PO233 PO26.1
PO274 PO275
PO276 PO277
PO280 PO295
...
PCRSET2 COMPANY KeyChange AP30.2 AP300
VENDOR AP32.2 AP520
PURCH-FR-LOC API1.1 API2.1
PO-DATE* API3.1 API4.1
PO-CODE MA63.1 MA65.1
PO-NUMBER* PO10.1 PO136
PO-RELEASE* PO190 PO224
PO24.1 PO60.1
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCRSET3 COMPANY KeyChange AP30.2 AP32.2
BUYER-CODE AP520 API1.1
PO-DATE* API2.1 MA63.1
PO-CODE MA65.1 PO04.1
PO-NUMBER* PO136 PO190
PO-RELEASE* PO220 PO224
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCRSET4 COMPANY KeyChange, Subset AP30.2 AP32.2
ISSUE-METH Where ISSUE-PENDING = "Y" AP520 API1.1
BUYER-CODE And RELEASED-FL = "Y" API2.1 MA63.1
LOCATION And RETURN-NUMBER = Zeroes MA65.1 PO120
VENDOR PO136 PO190
PURCH-FR-LOC PO64.1 POCP.1
PO-CODE POED.1 POI7.1
PO-NUMBER POIF.1 POIJ.1
PO-RELEASE POIT.1
PCRSET5 COMPANY KeyChange, Subset AP30.2 AP32.2
BUYER-CODE Where RELEASED-FL != "Y" AP520 API1.1
PO-CODE API2.1 MA63.1
PO-NUMBER MA65.1 PO136
PO-RELEASE PO190 PO64.1
POCP.1 POED.1
POI7.1 POIF.1
POIJ.1 POIT.1
PCRSET6 COMPANY KeyChange, Subset AP30.2 AP32.2
VENDOR Where RELEASED-FL = "Y" AP520 API1.1
PO-CODE And CLOSED-FL != "Y" API2.1 MA63.1
PO-NUMBER MA65.1 PO10.1
PO-RELEASE PO136 PO190
PO64.1 POCP.1
POED.1 POI7.1
POIF.1 POIJ.1
POIT.1
PCRSET7 COMPANY No programs are associated with this AP30.2 AP32.2
PO-DATE* index. It is used to do descending order AP520 API1.1
PO-NUMBER* selects. API2.1 MA63.1
PO-CODE KeyChange MA65.1 PO136
PO-RELEASE* PO190 PO64.1
POCP.1 POED.1
POI7.1 POIF.1
POIJ.1 POIT.1
PCRSET8 COMPANY This index is not referenced by any AP30.2 AP32.2
PO-CODE programs. It is used to do selects, so AP520 API1.1
PO-DATE* that they are in descending order by API2.1 MA63.1
PO-NUMBER* date. MA65.1 PO136
PO-RELEASE* KeyChange PO190 PO64.1
POCP.1 POED.1
POI7.1 POIF.1
POIJ.1 POIT.1
PCRSET9 COMPANY KeyChange, Subset PO529
VENDOR Where RELEASED-FL = "Y"
PURCH-FR-LOC And NBR-LINES > CLOSED-LINES
PO-DATE*
PO-CODE
PO-NUMBER*
PO-RELEASE*
PURCHORDER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
PCR-COMPANY -> CPY-COMPANY
Buyer BUYER Required
PCY-PROCURE-GROUP -> BUY-PROCURE-GROUP
PCR-BUYER-CODE -> BUY-BUYER-CODE
Fobcode FOBCODE Not Required
PCY-PROCURE-GROUP -> FOB-PROCURE-GROUP
PCR-FOB-CODE -> FOB-FOB-CODE
Iccompany ICCOMPANY Required
PCR-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
PCR-COMPANY -> ICL-COMPANY
PCR-LOCATION -> ICL-LOCATION
Macompany MACOMPANY Required
PCR-COMPANY -> MAY-COMPANY
Mmuaval MMUAVAL Required
PCR-COMPANY -> MUA-COMPANY
"PO" -> MUA-SYSTEM-CD
PCR-LOCATION -> MUA-LOCATION
"PT" -> MUA-DOC-TYPE
PCR-PO-NUMBER -> MUA-DOC-NUMBER
PCR-PO-RELEASE -> MUA-DOC-NBR-NUM
PCR-PO-CODE -> MUA-PO-CODE
Zeroes -> MUA-LINE-NBR
Zeroes -> MUA-API-OBJ-ID
Zeroes -> MUA-SEQ-NBR
Pocompany POCOMPANY Required
PCR-COMPANY -> PCY-COMPANY
Pofrtterm POFRTTERM Not Required
PCY-PROCURE-GROUP -> POF-PROCURE-GROUP
PCR-FREIGHT-TERMS -> POF-FREIGHT-TERMS
Popcruf POPCRUF Not Required
PCR-COMPANY -> UFP-COMPANY
PCR-PO-CODE -> UFP-PO-CODE
PCR-PO-NUMBER -> UFP-PO-NUMBER
PCR-PO-RELEASE -> UFP-PO-RELEASE
Terms TERMS Required
PCR-TERM-CODE -> TMS-TERMS-CD
Vendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
PCR-VENDOR -> VEN-VENDOR
Vendorloc APVENLOC Required
When PCR-PURCH-FR-LOC != Spaces
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
PCR-VENDOR -> VLO-VENDOR
PCR-PURCH-FR-LOC -> VLO-LOCATION-CODE
PURCHORDER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apapihist APAPIHIST
PCR-COMPANY -> AH1-COMPANY
PCR-VENDOR -> AH1-VENDOR
PCR-PO-NUMBER -> AH1-PO-NUMBER
PCR-PO-RELEASE -> AH1-PO-RELEASE
PCR-PO-CODE -> AH1-PO-CODE
AH1-LOCATION
AH1-INVOICE
AH1-SUFFIX
AH1-CANCEL-SEQ
Apinvoice APINVOICE
PCR-COMPANY -> API-COMPANY
PCR-VENDOR -> API-VENDOR
PCR-PO-NUMBER -> API-PO-NUMBER
PCR-PO-RELEASE -> API-PO-RELEASE
PCR-PO-CODE -> API-PO-CODE
API-LOCATION
API-INVOICE
API-SUFFIX
API-CANCEL-SEQ
Mainvdtl MAINVDTL
PCR-COMPANY -> MAD-COMPANY
PCR-PO-NUMBER -> MAD-PO-NUMBER
PCR-PO-RELEASE -> MAD-PO-RELEASE
PCR-PO-CODE -> MAD-PO-CODE
MAD-LINE-NBR
MAD-VENDOR
MAD-INVOICE
MAD-SUFFIX
MAD-AOC-CODE
MAD-SEQ-NBR
Mamadhist MAMADHIST
PCR-COMPANY -> MH1-COMPANY
PCR-PO-NUMBER -> MH1-PO-NUMBER
PCR-PO-RELEASE -> MH1-PO-RELEASE
PCR-PO-CODE -> MH1-PO-CODE
MH1-LINE-NBR
MH1-VENDOR
MH1-INVOICE
MH1-SUFFIX
MH1-AOC-CODE
MH1-SEQ-NBR
Mapoinvoice MAPOINV Delete Restricted
PCR-COMPANY -> AOI-COMPANY
PCR-PO-NUMBER -> AOI-PO-NUMBER
PCR-PO-RELEASE -> AOI-PO-RELEASE
PCR-PO-CODE -> AOI-PO-CODE
AOI-VENDOR
AOI-INVOICE
AOI-SUFFIX
Miscaocapprvl MAINVDTL
PCR-COMPANY -> MAD-COMPANY
PCR-PO-NUMBER -> MAD-PO-NUMBER
PCR-PO-RELEASE -> MAD-PO-RELEASE
PCR-PO-CODE -> MAD-PO-CODE
Zeroes -> MAD-LINE-NBR
MAD-VENDOR
MAD-AOC-CODE
MAD-INVOICE
MAD-SUFFIX
MAD-SEQ-NBR
Mmdist MMDIST
PCR-COMPANY -> MMD-COMPANY
"PO" -> MMD-SYSTEM-CD
Spaces -> MMD-LOCATION
"PT" -> MMD-DOC-TYPE
PCR-PO-NUMBER -> MMD-DOC-NUMBER
PCR-PO-RELEASE -> MMD-DOC-NBR-NUM
PCR-PO-CODE -> MMD-PO-CODE
MMD-LINE-NBR
MMD-COMPONENT-SEQ
MMD-AOC-CODE
MMD-LINE-SEQ
MMD-REQ-LOCATION
MMD-API-OBJ-ID
Poaochdrdtl POAOCDTL
PCR-COMPANY -> PAO-COMPANY
Spaces -> PAO-PROCURE-GROUP
Spaces -> PAO-VEN-AGRMT-REF
PCR-PO-NUMBER -> PAO-PO-NUMBER
PCR-PO-RELEASE -> PAO-PO-RELEASE
PCR-PO-CODE -> PAO-PO-CODE
Zeroes -> PAO-LINE-NBR
PAO-AOC-CODE
Poaocsprd POAOCSPRD Delete Cascades
PCR-COMPANY -> PSP-COMPANY
PCR-PO-NUMBER -> PSP-PO-NUMBER
PCR-PO-RELEASE -> PSP-PO-RELEASE
PCR-PO-CODE -> PSP-PO-CODE
PSP-AOC-CODE
PSP-INVOICE
Poaudit POAUDIT
PCR-COMPANY -> PAU-COMPANY
PCR-PO-NUMBER -> PAU-PO-NUMBER
PCR-PO-RELEASE -> PAU-PO-RELEASE
PCR-PO-CODE -> PAU-PO-CODE
PAU-PO-REVISION
PAU-UPDATE-DATE
PAU-UPDATE-TIME
PAU-PO-LINE-NBR
PAU-AOC-CODE
PAU-FLD-NBR
PAU-AUDIT-TYPE
PAU-AUDIT-ACTION
Poline POLINE Delete Cascades
PCR-COMPANY -> PLI-COMPANY
PCR-PO-NUMBER -> PLI-PO-NUMBER
PCR-PO-RELEASE -> PLI-PO-RELEASE
PCR-PO-CODE -> PLI-PO-CODE
PLI-LINE-NBR
Poreceive PORECEIVE
PCR-COMPANY -> POR-COMPANY
PCR-PO-CODE -> POR-PO-CODE
PCR-PO-NUMBER -> POR-PO-NUMBER
PCR-PO-RELEASE -> POR-PO-RELEASE
POR-PO-LOCATION
POR-REC-NUMBER
Porecline PORECLINE
PCR-COMPANY -> PRL-COMPANY
PCR-PO-CODE -> PRL-PO-CODE
PCR-PO-NUMBER -> PRL-PO-NUMBER
PCR-PO-RELEASE -> PRL-PO-RELEASE
PRL-LOCATION
PRL-MATCH-DTL-KEY
PRL-PO-LINE-NBR
PRL-REC-NUMBER
PRL-LINE-NBR
Porevision POREVISION
PCR-COMPANY -> PVS-COMPANY
PCR-PO-NUMBER -> PVS-PO-NUMBER
PCR-PO-RELEASE -> PVS-PO-RELEASE
PCR-PO-CODE -> PVS-PO-CODE
PVS-PO-REVISION
|