PURCHORDER – Purchase Order Master

System
Purchase Order (PO)
Prefix
PCR
Primary key
COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE
Fields
181
Updated by
238 programs
Referenced by
124 programs

PURCHORDER is the Purchase Order Master table in Lawson Purchase Order (prefix PCR). It is indexed by COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE (PCRSET1); alternate indexes: PCRSET10, PCRSET11, PCRSET12, PCRSET2, PCRSET3, PCRSET4, PCRSET5, PCRSET6 and 3 more. It is related 1:1 to APCOMPANY, BUYER, FOBCODE, ICCOMPANY, ICLOCATION, MACOMPANY, MAREASONCD, MMUAVAL and 7 more and 1:M to APAPIHIST, APDISTPAY, APINVOICE, APVENDIV, MAAOCDTL, MAINVDTL, MAMAAHIST, MAMADHIST and 9 more. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 230 more and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM17.1 and 116 more. The table has 181 fields, 12 indexes and 33 documented relations.

About PURCHORDER

This file contains header information for each purchase order.

Fields (181)

Column = COBOL field name without the PCR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PCR-COMPANY PK
COMPANY		Numeric 4The company number represents a defined company and is entered on all actions. For conversion: Fatal Error - If equal to spaces, or zeros, or not numeric, or either Purchase Order company, Inventory Control company, or Accounts Payable company is not found, then the purchase order is not loaded.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-NUMBER PK
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order. For conversion: Fatal Error - If equal to spaces, or the purchase order company flag says it must be numeric and it is not, or the purchase order already exists, then the purchase order is not loaded. Also, if previously processed, then the record is skipped.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-RELEASE PK
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-REVISION
PO_REVISION		Numeric 3The purchase order revision number. Assigned sequentially by the system when the purchase order is revised. For conversion: Fatal Error - If not numeric, then the purchase order is not loaded.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-RETURN-NUMBER
RETURN_NUMBER		Numeric 10This is the number assigned to the return for purposes of referencing the return internally and with the customer or vendor.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-VENDOR
VENDOR		Alpha 9 (Right Justified)This field contains the vendor's identification code. For conversion: This is allowed to be changed for matching load program. Non-Fatal Error - Entry release edits are applied. If an edit fails, the 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.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The vendor's purchase from location. It is validated against the Accounts Payable vendor alternate location master. For conversion: This is allowed to be changed for matching load program. 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.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-BUYER-CODE
BUYER_CODE		Alpha 3The user-defined buyer identification code. For conversion: Nonfatal Error - Entry release edits are applied. If an edit fails, the purchase order is loaded at an unreleased status. Default - Purchase Order company buyer code.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-BLKT-STD-AGRMT
BLKT_STD_AGRMT		Alpha 30—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-DATE
PO_DATE		Numeric 8 (yyyymmdd)The date for this purchase order. For conversion: Fatal Error - If not numeric or invalid date, than the purchase order is not loaded. Default - System date.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-OBJ-ID
PO_OBJ_ID		Alpha 10 (Right Justified)The PO Object ID is used as a document number for the warehouse system. This field, along with the PO Line number, is used to relate POLINE records to WHDEMAND records. A unique PO Object ID is obtained when the PO number is assigned in PO creation. It is passed on the to the PO line when the PO line 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).AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the transaction currency code. Default is from Vendor (AP10.1) when present, otherwise from Vendor Class (AP00.3) when present, otherwise the company base currency. For conversion: Nonfatal Error - If not company base, and not Accounts Payable vendor balance, Purchase Order company does not allow 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.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-ENT-CNV-RATE
ENT_CNV_RATE		Signed 14.7Currency conversion rate at purchase order entry time. For conversion: Nonfatal Error - If company base, and not equal to zeros, then reset to zeros. If not company base and equal to zeros, then reset to general ledger. Fatal Error - If not company base and equal to zeroes and invalid currency code. Default - Currency base rate.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-REC-CNV-RATE
REC_CNV_RATE		Signed 14.7Currency conversion rate for the purchase order at receiving time.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-CURR-SET-FLAG
CURR_SET_FLAG		Alpha 1Flag defines when the currency rate has been set for the purchase order. For conversion: Nonfatal Errors - If not equal to spaces, E, I, or R, then reset to E. Default - E.
  • E Entry
  • R Receiving
  • I Invoicing
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-REVALUE-FLAG
REVALUE_FLAG		Alpha 1Currency is reevaluated when Accounts Payable prints a check in a currency other than that defined on the purchase order or invoice. For conversion: Nonfatal Error - If not equal to Yes or No, then reset to Yes (the default).
  • Y Yes
  • N No
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-DL-DATE
DFLT_DL_DATE		Numeric 8 (yyyymmdd)Default early delivery date.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-LOCATION
LOCATION		Alpha 5This field contains a valid stock location within the company inventory. For conversion: Fatal Error - If equal to spaces, or not found in Inventory Control, then the purchase order is not loaded.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-NAME
SH_NAME		Alpha 30 (Lower Case)This is the ship-to name. For conversion: Nonfatal Error - If not equal to spaces and address equal spaces. Default - Inventory Control location ship name.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-ADDR1
SH_ADDR1		Alpha 30 (Lower Case)This is the ship-to address line one.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-ADDR2
SH_ADDR2		Alpha 30 (Lower Case)This is the ship-to address line two.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-ADDR3
SH_ADDR3		Alpha 30 (Lower Case)This is the ship-to address line three.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-ADDR4
SH_ADDR4		Alpha 30 (Lower Case)This is the ship-to address line four.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-CITY-ADDR5
SH_CITY_ADDR5		Alpha 18 (Lower Case)This is the ship-to city or the ship-to address line five.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-STATE-PROV
SH_STATE_PROV		Alpha 2This is the ship-to state or the ship-to province.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-POST-CODE
SH_POST_CODE		Alpha 10 (Lower Case)This is the ship-to mail code.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-COUNTRY-CD
SH_COUNTRY_CD		Alpha 2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-COUNTRY
SH_COUNTRY		Alpha 30 (Lower Case)This is the ship-to country.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-COUNTY
SH_COUNTY		Alpha 25 (Lower Case)The county for the company address.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-PHONE-PREF
SH_PHONE_PREF		Alpha 6This is the ship-to telephone number prefix.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-PHONE
SH_PHONE		Alpha 15This is the ship-to telephone number.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-PHONE-EXT
SH_PHONE_EXT		Alpha 5The ship-to telephone extension number.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SH-CONTACT
SH_CONTACT		Alpha 30 (Lower Case)This is the ship-to contact.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-NBR-LINES
NBR_LINES		Numeric 6The total number of lines on this purchase order.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-CLOSED-LINES
CLOSED_LINES		Numeric 6The number of closed lines for this purchase order.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DROPSHIP-FL
DROPSHIP_FL		Alpha 1This flag indicates whether this is a dropship purchase order. A dropship purchase order is not received. For conversion: Nonfatal Error - If not equal to Y or N, then reset to N (the default).
  • N Receiving Required
  • Y Receiving Not Allowed
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PRT-REC-FLAG
PRT_REC_FLAG		Alpha 1The purchase order creates receiver documents when this print receiver flag is coded Y and it is part of the selection criteria for the receiving print program. For conversion: Nonfatal Error - If not equal to Yes or No, then reset to Yes (the default).
  • N No
  • Y Yes
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-FAX-PREFIX
FAX_PREFIX		Alpha 6Fax number prefix. For conversion: Default - Purchase order vendor location fax prefix.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-FAX-NUMBER
FAX_NUMBER		Alpha 15Fax number. For conversion: Default - Purchase order vendor location fax number.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-FAX-EXT
FAX_EXT		Alpha 5Fax number extension. For conversion: Default - Purchase order vendor location fax extension.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company. For conversion: Nonfatal Error - If not found in Accounts Payable.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-WEIGHT
WEIGHT		Signed 9.3This field contains the unit weight of the item based on the stock unit of measure.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-CUBIC-FEET
CUBIC_FEET		Signed 9.3This field contains the unit cubit feet of the item based on the stock unit of measure.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-FREIGHT-TERMS
FREIGHT_TERMS		Alpha 1The freight terms code for this purchase order. For conversion: Nonfatal Error - If not found then reset to purchase order company freight terms. Default - purchase order company freight terms.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-FOB-CODE
FOB_CODE		Alpha 3The user-defined ship term code for this purchase order. For conversion: Nonfatal Error - If not found. Default - Purchase order vendor location ship term, purchase order vendor ship term.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-SHIP-VIA
SHIP_VIA		Alpha 12 (Lower Case)The purchase order ship via narrative defaults from the vendor or is entered.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-TERM-CODE
TERM_CODE		Alpha 5A user-defined code representing a method of determining an invoice due and discount dates. For conversion: Default - Accounts Payable Vendor location term code, Accounts Payable Vendor term code. If present, overrides due days, discount days and discount rate.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid tax code in Tax. For conversion: Nonfatal Error - If not found, or tax is landed and company is standard cost, then reset to spaces. Default - Accounts Payable vendor location tax code, Accounts Payable vendor tax code.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-TOT-PRD-AMT
TOT_PRD_AMT		Signed 18.2This is the total product amount associated with the purchase order.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-TOT-TAXBL-AMT
TOT_TAXBL_AMT		Signed 18.2The total taxable amount for the purchase order.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-LETTER-OF-CR
LETTER_OF_CR		Alpha 20This field contains the letter of credit.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-TOT-ORDER-AMT
TOT_ORDER_AMT		Signed 18.2The total order amount for the purchase order. This includes the total product cost, all add-on costs (for all vendors, whether printed or not) and all taxes (whether invoiced or accrued).AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-USER-DATE-1
USER_DATE_1		Numeric 8 (yyyymmdd)This is the user date one. For conversion: Non-Fatal Error - If not numeric, or invalid, then reset to zeros.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-USER-DATE-2
USER_DATE_2		Numeric 8 (yyyymmdd)This is the user date two. For conversion: Nonfatal Error - If not numeric, or invalid, then reset to zeros.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-LAST-LINE-NBR
LAST_LINE_NBR		Numeric 6This is the last line number on the purchase order.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-TAXBL-FL
DFLT_TAXBL_FL		Alpha 1This taxable flag is used to default a Yes or No, for special and service items when adding them to a purchase order. The nonstock and inventory items have this flag defined in the Inventory Control system. For conversion: Nonfatal Error - If not equal to spaces, Yes, or No, then reset to No (the default).
  • Y Yes
  • N No
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-ACCT-UNIT
DFLT_ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-ACCOUNT
DFLT_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-SUB-ACCT
DFLT_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-DIST-CO
DFLT_DIST_CO		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-ACTIVITY
DFLT_ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-ACCT-CAT
DFLT_ACCT_CAT		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruAM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-BILL-CAT
DFLT_BILL_CAT		Alpha 32—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-REQ-LOC
DFLT_REQ_LOC		Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-REQUESTER
DFLT_REQUESTER		Alpha 10 (Lower Case)This is the person who requested this requisition.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-DEL-TO
DFLT_DEL_TO		Alpha 30 (Lower Case)This field can be used to specify where to deliver the items. This field prints on the delivery ticket when you run Delivery Ticket Print program.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-SRC-DOC
DFLT_SRC_DOC		Alpha 10—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-ASSET-TEM
DFLT_ASSET_TEM		Alpha 10A user-defined asset template identifies general asset creation parameters that you can use to quickly add assets with minimal keying. Using a template lets you default many data items associated with a new asset. You can use an asset template to process quick asset additions in AM20.1 (Quick Addition) and to create assets and asset books from Accounts Payable and Activity Management interface information. Asset templates are required if you define new assets as a result of transactions interfaced from the Lawson Purchase Order or Accounts Payable systems.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-ASSET-NBR
DFLT_ASSET_NBR		Numeric 10The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-RELEASED-FL
RELEASED_FL		Alpha 1Released Flag. Record is now available for further processing in the system. For conversion: Nonfatal Error - If not equal to Y or N, then reset to N (the default).
  • N No
  • Y Yes
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-ISSUED-FLAG
ISSUED_FLAG		Alpha 1This is the issue status of the purchase order. If the PO has been issued at least once, this flag will be set to a value of "Y". Once set to "Y", it never changes. For conversion: Fatal Error - If not equal to Y or N, then this purchase order is not loaded.
  • N No
  • Y Yes
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-REVISED-FL
REVISED_FL		Alpha 1This is the purchase order revised status flag.
  • N No
  • Y Yes
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-CANCELLED-FL
CANCELLED_FL		Alpha 1This is the purchase order canceled status flag.
  • N No
  • Y Yes
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-CLOSED-FL
CLOSED_FL		Alpha 1The closed flag.
  • N No
  • Y Yes
  • H Historical
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-LAST-ACTIVITY
LAST_ACTIVITY		Numeric 8 (yyyymmdd)This date reflects the last time any activity has been applied to this purchase order. Activity consists of receiving or invoicing of any line item on the purchase order. This includes any receiving adjustments or receiving rejections. For conversion: Default - System date.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-CLOSE-DATE
CLOSE_DATE		Numeric 8 (yyyymmdd)This is the date the purchase order was closed.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-USER-FLD-1
PO_USER_FLD_1		Alpha 1Purchase order header user field one.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-USER-FLD-3
PO_USER_FLD_3		Alpha 30Purchase order header user field two.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-USER-FLD-5
PO_USER_FLD_5		Alpha 30 (Lower Case)Purchase order header user field three.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-INVC-MTHD-CODE
INVC_MTHD_CODE		Alpha 3The method the vendor is to use to invoice the order (manual, EDI, or evaluated receipts settlement).
  • IBM Invoice By Mail
  • IEL Invoice Electonically
  • INR Invoice Not Required
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-ISSUE-METH
ISSUE_METH		Alpha 1Specifies the method that will be used to issue the purchase order to the vendor.
  • P Paper
  • F Fax
  • E EDI
  • I Internet Mail
  • D Do Not Print
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-REVISIONS-INCL
REVISIONS_INCL		Alpha 1Specifies what information will be included when a revised purchase order is re-issued. You can specify that only the revised information is included, along with messages that indicate what was revised (option O - Revisions Only). Alternately, you can specify that the entire purchase order is included, along with messages that indicate the revisions. Finally, you can 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). " " = Not Revised
  • O Revisions Only
  • C Revisions Complete
  • I Reissue
  • N Not Applicable
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-ISSUE-PENDING
ISSUE_PENDING		Alpha 1Indicates whether the purchase order will be processed if it meets the selection criteria specified in PO120 (Purchase Order Issue).
  • Y Yes
  • N No
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-USER-ID
USER_ID		Alpha 10 (Lower Case)Contains the user ID of the person who originally released the purchase order.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-AOC-TOTAL
PO_AOC_TOTAL		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-TAX-TOTAL
PO_TAX_TOTAL		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-PRINT-TOTAL
PO_PRINT_TOTAL		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POV-AOC-TOTAL
POV_AOC_TOTAL		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POV-ITAX-TOTAL
POV_ITAX_TOTAL		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POV-GRD-TOTAL
POV_GRD_TOTAL		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-OV-AOC-TOTAL
OV_AOC_TOTAL		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-OV-ITAX-TOTAL
OV_ITAX_TOTAL		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-OV-GRD-TOTAL
OV_GRD_TOTAL		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-ACCR-TAX-TOTAL
ACCR_TAX_TOTAL		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-OPEN-PO-AMT
OPEN_PO_AMT		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-UNLOADING-PORT
UNLOADING_PORT		Alpha 5The port where the goods are unloaded if required. Must be defined in Port Codes (IN04.1).AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DEST-REGION
DEST_REGION		Alpha 2The region of the country to which the goods were shipped, if required. Must be a valid region in IN02.1 (Region Maintenance)AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-NOTC
NOTC		Alpha 2The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-STAT-PROC
STAT_PROC		Alpha 6The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-RECORD-SOURCE
RECORD_SOURCE		Numeric 2—
  • 01 PO20
  • 02 PO23
  • 03 PO27
  • 04 PO29
  • 05 PO100
  • 06 PO101
  • 07 PO520
—
PCR-SUBCONTRACT-PO
SUBCONTRACT_PO		Numeric 1This field indicates if the purchase order is a subcontractor PO. Only valid with Grant Management setup.
  • 0 No
  • 1 Yes
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-APPROVED
PO_APPROVED		Numeric 1—
  • 0 No
  • 1 Yes
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PFLOW-APRV-LVL
PFLOW_APRV_LVL		Alpha 20—PO18.1, PO24.1
PCR-SHIP-TO-ARRIVE
SHIP_TO_ARRIVE		Numeric 8 (yyyymmdd)This date will be used in best terms calculation. This date is provided at the PO level as the date the shipment should arrive.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-XREF-VENDOR
XREF_VENDOR		Alpha 9 (Right Justified)This is a vendor that is supported on a system outside Lawson. When records are interfaces we will maintain this vendor on the file but we will use the Lawson vendor while in the Lawson application.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-WRHS-NUMBER
WRHS_NUMBER		Alpha 5The number associated with the warehouse number the goods will be shipped to.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-MTCH-PRPY-FL
MTCH_PRPY_FL		Alpha 1This field will be populated from the INVOICE file if the invoice is INVOICE-TYPE R for Match Prepayment. When the receipt is entered or interfaced the same field on the receipt record will be populated in oreder to note that it will be matched to a match prepayment invoice. " " = No option
  • R Invoice Type Match Prepay
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-IMAGE-NUMBER
IMAGE_NUMBER		Alpha 100—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-NAME
POB_NAME		Alpha 30 (Lower Case)Displays the company description.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-ADDR1
POB_ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-ADDR2
POB_ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-ADDR3
POB_ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-ADDR4
POB_ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-CITY-ADDR5
POB_CITY_ADDR5		Alpha 18 (Lower Case)This field contains the city of the address.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-STATE-PROV
POB_STATE_PROV		Alpha 2The state or province.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-POSTAL-CD
POB_POSTAL_CD		Alpha 10 (Lower Case)This field contains the postal code.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-CONTRY-CD
POB_CONTRY_CD		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-COUNTY
POB_COUNTY		Alpha 25 (Lower Case)The county for the company address.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-CONTACT
POB_CONTACT		Alpha 30 (Lower Case)This is the name of the main contact.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-EMAIL-ADDRESS
EMAIL_ADDRESS		Alpha 60 (Lower Case)e-mail address.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PCARD-NBR
PCARD_NBR		Alpha 16—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-P-CARD-FLAG
P_CARD_FLAG		Numeric 1—
  • 0 Not a P-card PO
  • 1 P-Card PO
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-LOC-NAME-DRV
LOC_NAME_DRV		Derived——
PCR-PURCH-FR-NAME
PURCH_FR_NAME		Derived——
PCR-BUYER-NAME-DRV
BUYER_NAME_DRV		Derived——
PCR-DISP-PO-REL-CD
DISP_PO_REL_CD		Derived——
PCR-DISP-PO-REL
DISP_PO_REL		Derived——
PCR-DISP-DOC-NBR
DISP_DOC_NBR		Derived——
PCR-RET-TRK-PCT-CP
RET_TRK_PCT_CP		Numeric 1—
  • 0 No Retainage
  • 1 Purchase Order Level
  • 2 Line Level
  • 3 Vendor Agreement
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-RET-PCT-1
RET_PCT_1		Percent 5.2 (Percent)—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-RET-PCT-2
RET_PCT_2		Percent 5.2 (Percent)—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-RET-UP-TO-PCT
RET_UP_TO_PCT		Percent 5.2 (Percent)—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-RET-PCT-COMP
RET_PCT_COMP		Percent 5.2 (Percent)—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-RET-OVRD-PCT
RET_OVRD_PCT		Percent 5.2 (Percent)—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-RET-DUE-DATE
RET_DUE_DATE		Numeric 8 (yyyymmdd)—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-EXT-AMT
PO_EXT_AMT		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-MATCH-AMT
PO_MATCH_AMT		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-PHONE-PREF
POB_PHONE_PREF		Alpha 6—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-PHONE
POB_PHONE		Alpha 15—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-PHONE-EXT
POB_PHONE_EXT		Alpha 5—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-POB-EMAIL-ADDR
POB_EMAIL_ADDR		Alpha 60 (Lower Case)—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-PO-USER-FLD-7
PO_USER_FLD_7		Alpha 10 (Lower Case)——
PCR-DFLT-EAM-WO
DFLT_EAM_WO		Numeric 8—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-REASON-CODE
REASON_CODE		Alpha 4This field contains the reason code, which can be used when approving a purchase order.—
PCR-ATTAIN-LEVEL
ATTAIN_LEVEL		Numeric 1This is the highest approval level required for the purchase order. The purchase order must be approved at this level for further processing.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-APRV-LEVEL
APRV_LEVEL		Numeric 1This is the approval level that this purchase order has attained so far via PO17.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-LAST-APRV-DT
LAST_APRV_DT		Numeric 8 (yyyymmdd)This is the last approval date for the purchase order. Purchase orders are approved on PO17.1 (PO Approval Review).AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-REJECTED-FL
REJECTED_FL		Alpha 1This flag indicates that this purchase order has been rejected.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-OPER-CO
DFLT_OPER_CO		Numeric 4Identifies default operating company if attaching a source record of the type "PO" to the purchase order lines.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-APPROVE-CD
APPROVE_CD		Alpha 5This is a code to identify the approval process (levels) that a purchase order has to pass before it can be processed further.AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-APPROVAL-TYPE
APPROVAL_TYPE		Alpha 1The type of approval record.
  • 0 Header approval-PO approval cd
  • 1 Header approval-Process Flow
  • 2 No approval required
AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-CREATED-BY
CREATED_BY		Alpha 10—POII.1
PCR-LAST-UPDT-DATE
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PCR-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PCR-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PCR-FREIGHT-TOT
FREIGHT_TOT		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-INSURANCE-TOT
INSURANCE_TOT		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-CSTMS-TOT
CSTMS_TOT		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-OTHER-AOC-TOT
OTHER_AOC_TOT		Signed 18.2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-PAT-ID
DFLT_PAT_ID		Alpha 20—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-VISIT-NBR
DFLT_VISIT_NBR		Alpha 20—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-CASE-NBR
DFLT_CASE_NBR		Alpha 20—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-PROC
DFLT_PROC		Alpha 20—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-PROC-DATE
DFLT_PROC_DATE		Numeric 8 (yyyymmdd)—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-PHYS-NAME
DFLT_PHYS_NAME		Alpha 30—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-NRS-COORD
DFLT_NRS_COORD		Alpha 30—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-SALES-REP
DFLT_SALES_REP		Alpha 30—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-ORD-NBR
DFLT_ORD_NBR		Alpha 20—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-REQUESTOR
DFLT_REQUESTOR		Alpha 30—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-USERDEF1
DFLT_USERDEF1		Alpha 30—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-USERDEF2
DFLT_USERDEF2		Alpha 30—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-CN-CODE
DFLT_CN_CODE		Alpha 2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-GLBL-DOC-TYPE
GLBL_DOC_TYPE		Alpha 10—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-LAST-NAME
DFLT_LAST_NAME		Alpha 60—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-FIRST-NM
DFLT_FIRST_NM		Alpha 60—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-MIDDLE-NM
DFLT_MIDDLE_NM		Alpha 60—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-BIRTHDATE
DFLT_BIRTHDATE		Numeric 8 (yyyymmdd)—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-GENDER
DFLT_GENDER		Alpha 1—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-SSN
DFLT_SSN		Alpha 20—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)
PCR-DFLT-PROC-MOD
DFLT_PROC_MOD		Alpha 2—AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +52 more (list truncated in source)

Indexes (12)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PCRSET1COMPANY, PO-CODE, PO-NUMBER, PO-RELEASEPrimaryAM17.1, AM19.1, AM19.2, AM219, AP115, AP125, AP126, AP131 +22 more (list truncated in source)
PCRSET10COMPANY, VENDOR, PURCH-FR-LOC, PO-NUMBER, PO-RELEASE, PO-CODEKeyChange, SubsetWhere SUBCONTRACT-PO = 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PCRSET11COMPANY, VENDOR, PO-CODE, PO-NUMBER, PO-RELEASEKeyChange, SubsetWhere RELEASED-FL = "Y" And CLOSED-FL != "Y"AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +22 more (list truncated in source)
PCRSET12COMPANY, PO-NUMBER, PO-DATE, LAST-UPDT-DATE, PO-CODE, PO-RELEASEKeyChange—
PCRSET2COMPANY, VENDOR, PURCH-FR-LOC, PO-DATE*, PO-CODE, PO-NUMBER*, PO-RELEASE*KeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM17.1 +22 more (list truncated in source)
PCRSET3COMPANY, BUYER-CODE, PO-DATE*, PO-CODE, PO-NUMBER*, PO-RELEASE*KeyChangeAM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +22 more (list truncated in source)
PCRSET4COMPANY, ISSUE-METH, BUYER-CODE, LOCATION, VENDOR, PURCH-FR-LOC, PO-CODE, PO-NUMBER, PO-RELEASEKeyChange, SubsetWhere ISSUE-PENDING = "Y" And RELEASED-FL = "Y" And RETURN-NUMBER = ZeroesAM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +22 more (list truncated in source)
PCRSET5COMPANY, BUYER-CODE, PO-CODE, PO-NUMBER, PO-RELEASEKeyChange, SubsetWhere RELEASED-FL != "Y"AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +22 more (list truncated in source)
PCRSET6COMPANY, VENDOR, PURCH-FR-LOC, PO-CODE, PO-NUMBER, PO-RELEASEKeyChange, SubsetWhere RELEASED-FL = "Y" And CLOSED-FL != "Y"AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +22 more (list truncated in source)
PCRSET7COMPANY, PO-DATE*, PO-NUMBER*, PO-CODE, PO-RELEASE*KeyChangeAM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +22 more (list truncated in source)
PCRSET8COMPANY, PO-CODE, PO-DATE*, PO-NUMBER*, PO-RELEASE*KeyChangeAM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +22 more (list truncated in source)
PCRSET9COMPANY, VENDOR, PURCH-FR-LOC, PO-DATE*, PO-CODE, PO-NUMBER*, PO-RELEASE*KeyChange, SubsetWhere RELEASED-FL = "Y" And DROPSHIP-FL != "Y" And NBR-LINES > CLOSED-LINESPO529

Relations

One to one (15) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredPCR-COMPANY → CPY-COMPANY
BuyerBUYERRequiredPCY-PROCURE-GROUP → BUY-PROCURE-GROUP, PCR-BUYER-CODE → BUY-BUYER-CODE
FobcodeFOBCODENot RequiredPCY-PROCURE-GROUP → FOB-PROCURE-GROUP, PCR-FOB-CODE → FOB-FOB-CODE
IccompanyICCOMPANYRequiredPCR-COMPANY → ICC-COMPANY
IclocationICLOCATIONRequiredPCR-COMPANY → ICL-COMPANY, PCR-LOCATION → ICL-LOCATION
MacompanyMACOMPANYRequiredPCR-COMPANY → MAY-COMPANY
MareasoncdMAREASONCDRequiredPCR-REASON-CODE → MAR-REASON-CODE
MmuavalMMUAVALNot RequiredPCR-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
PcrbodPCRBODNot Required, Delete CascadesPCR-COMPANY → PBB-COMPANY, PCR-PO-CODE → PBB-PO-CODE, PCR-PO-NUMBER → PBB-PO-NUMBER, PCR-PO-RELEASE → PBB-PO-RELEASE
PocompanyPOCOMPANYRequiredPCR-COMPANY → PCY-COMPANY
PofrttermPOFRTTERMNot RequiredPCY-PROCURE-GROUP → POF-PROCURE-GROUP, PCR-FREIGHT-TERMS → POF-FREIGHT-TERMS
PopcrufPOPCRUFNot RequiredPCR-COMPANY → UFP-COMPANY, PCR-PO-CODE → UFP-PO-CODE, PCR-PO-NUMBER → UFP-PO-NUMBER, PCR-PO-RELEASE → UFP-PO-RELEASE
TermsTERMSRequiredPCR-TERM-CODE → TMS-TERMS-CD
VendorAPVENMASTRequiredCPY-VENDOR-GROUP → VEN-VENDOR-GROUP, PCR-VENDOR → VEN-VENDOR
VendorlocAPVENLOCRequiredWhen PCR-PURCH-FR-LOC != SpacesCPY-VENDOR-GROUP → VLO-VENDOR-GROUP, PCR-VENDOR → VLO-VENDOR, PCR-PURCH-FR-LOC → VLO-LOCATION-CODE

One to many (18) — child tables

RelationTableRulesConditionField map
ApapihistAPAPIHISTPCR-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
ApdistpayAPDISTPAYPCR-COMPANY → DTY-COMPANY, PCR-PO-NUMBER → DTY-PO-NUMBER, PCR-PO-RELEASE → DTY-PO-RELEASE, PCR-PO-CODE → DTY-PO-CODE, → DTY-LINE-NBR, → DTY-MAD-SEQ-NBR, → DTY-VENDOR, → DTY-INVOICE, → DTY-SUFFIX, → DTY-PMT-SEQ-NBR, → DTY-DIST-SEQ-NBR
ApinvoiceAPINVOICEPCR-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
ApvendivAPVENDIVCPY-VENDOR-GROUP → VDC-VENDOR-GROUP, PCR-VENDOR → VDC-VENDOR, → VDC-LOCATION-CODE, → VDC-DIVERSE-CODE, → VDC-DCERT-DATE
MaaocdtlMAAOCDTLPCR-COMPANY → MAA-COMPANY, PCR-PO-NUMBER → MAA-PO-NUMBER, PCR-PO-RELEASE → MAA-PO-RELEASE, PCR-PO-CODE → MAA-PO-CODE, → MAA-LINE-NBR, → MAA-VENDOR, → MAA-INVOICE, → MAA-SUFFIX, → MAA-AOC-CODE, → MAA-SEQ-NBR
MainvdtlMAINVDTLPCR-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-SEQ-NBR
MamaahistMAMAAHISTPCR-COMPANY → MMH-COMPANY, PCR-PO-NUMBER → MMH-PO-NUMBER, PCR-PO-RELEASE → MMH-PO-RELEASE, PCR-PO-CODE → MMH-PO-CODE, → MMH-LINE-NBR, → MMH-VENDOR, → MMH-INVOICE, → MMH-SUFFIX, → MMH-AOC-CODE, → MMH-SEQ-NBR
MamadhistMAMADHISTPCR-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
MapoinvoiceMAPOINVDelete RestrictedPCR-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
MiscaocapprvlMAAOCDTLPCR-COMPANY → MAA-COMPANY, PCR-PO-NUMBER → MAA-PO-NUMBER, PCR-PO-RELEASE → MAA-PO-RELEASE, PCR-PO-CODE → MAA-PO-CODE, Zeroes → MAA-LINE-NBR, → MAA-VENDOR, → MAA-AOC-CODE, → MAA-INVOICE, → MAA-SUFFIX, → MAA-SEQ-NBR
MmdistMMDISTPCR-COMPANY → MMD-COMPANY, PCR-PO-NUMBER → MMD-DOC-NUMBER, PCR-PO-RELEASE → MMD-DOC-NBR-NUM, PCR-PO-CODE → MMD-PO-CODE, → MMD-LINE-NBR, → MMD-AOC-CODE, → MMD-LINE-SEQ
PoaochdrdtlPOAOCDTLPCR-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
PoaocsprdPOAOCSPRDDelete CascadesPCR-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
PoauditPOAUDITPCR-COMPANY → PAU-COMPANY, PCR-PO-NUMBER → PAU-PO-NUMBER, PCR-PO-RELEASE → PAU-PO-RELEASE, PCR-PO-CODE → PAU-PO-CODE, PCR-PO-REVISION → PAU-PO-REVISION, → PAU-UPDATE-DATE, → PAU-UPDATE-TIME, → PAU-PO-LINE-NBR, → PAU-AOC-CODE, → PAU-LINE-SEQ, → PAU-FLD-NBR, → PAU-AUDIT-TYPE, → PAU-AUDIT-ACTION
PolinePOLINEDelete CascadesPCR-COMPANY → PLI-COMPANY, PCR-PO-NUMBER → PLI-PO-NUMBER, PCR-PO-RELEASE → PLI-PO-RELEASE, PCR-PO-CODE → PLI-PO-CODE, → PLI-LINE-NBR
PoreceivePORECEIVEPCR-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
PoreclinePORECLINEPCR-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
PorevisionPOREVISIONPCR-COMPANY → PVS-COMPANY, PCR-PO-NUMBER → PVS-PO-NUMBER, PCR-PO-RELEASE → PVS-PO-RELEASE, PCR-PO-CODE → PVS-PO-CODE, → PVS-PO-REVISION

Programs

Updated by (238)

Referenced by (124)