POCOMPANY – Company System Master

System: Purchase Order (PO)
Prefix: PCY
Primary key: COMPANY
Fields: 188
Updated by: 224 programs
Referenced by: 164 programs

POCOMPANY is the Company System Master table in Lawson Purchase Order (prefix PCY). It is indexed by COMPANY (PCYSET1); alternate indexes: PCYSET2. It is related 1:1 to ICCOMPANY, ITEMGROUP, POFRTTERM and PROCUREGRP and 1:M to ICLOCATION, POAOCMAST, PODEFAUDIT, PODOCREF and PURCHORDER. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 216 more and referenced by AM19.1, AM19.2, AP00.4, AP05.3, AP05.6, AP06.1, AP115, AP133 and 156 more. The table has 188 fields, 2 indexes and 9 documented relations.

About POCOMPANY

A file of valid Purchase Order companies and corresponding parameters.

Fields (188)

Column = COBOL field name without the PCY- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`PCY-COMPANY` PK COMPANY	Numeric 4	The company number.	PO01.1
#`PCY-NAME` NAME	Alpha 30 (Lower Case)	Displays the company description.	PO01.1
#`PCY-PROCURE-GROUP` SET2 PROCURE_GROUP	Alpha 4	This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#`PCY-BASE-CURR-CD` BASE_CURR_CD	Alpha 5	The general ledger-defined currency code for this purchase order company.	PO01.1
#`PCY-BASE-CUC-DESC` BASE_CUC_DESC	Alpha 30 (Lower Case)	This field displays the description.	PO01.1
#`PCY-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	PO01.1
#`PCY-FREIGHT-TERMS` FREIGHT_TERMS	Alpha 1	Default terms code used to describe the terms of the freight on a purchase order.	PO01.1
#`PCY-UOM-REQ-FL` UOM_REQ_FL	Alpha 1	If the Unit of Measure Required flag is set to Yes, entry of the unit of measure field is required for both the purchase order entry and the receiving entry. `N` No `Y` Yes	PO01.1
#`PCY-REVISIONS-INCL` REVISIONS_INCL	Alpha 1	Specifies what information will be included when a revised Purchase Order is re-issued. You may specify that only the revised information is included, along with messages that indicate what was revised (option O - Revisions Only). Alternately, you may specify that the entire PO is included, along with messages that indicate the revisions. Finally, you may specify that the entire PO is re-issued. No revision messages will appear. If the PO has not been printed, or the revised PO is not to be re-issued, this field will be blank (Not Applicable). " " = Not Applicable `O` Revisions Only `C` Revisions Complete `I` Reissue	PO01.1
#`PCY-PO-COM-OPT` PO_COM_OPT	Alpha 1 Occurs 10 Times ×10	Indicates which inventory control comment types (created for the item) automatically print on the purchase order when the item is on the purchase order. `X` Select.	PO01.1
#`PCY-POE-COM-OPT` POE_COM_OPT	Alpha 1 Occurs 10 Times ×10	Indicates which inventory control comment types (created for the item) are automatically included with the purchase order transmitted document when the item is on the purchase order. `X` Select.	PO01.1
#`PCY-REC-COM-OPT` REC_COM_OPT	Alpha 1 Occurs 10 Times ×10	Indicates which inventory control comment types (created for the item) automatically print on the receiving document when the item is on the receiving document. `X` Select.	PO01.1
#`PCY-UPO-COM-OPT` UPO_COM_OPT	Alpha 1 Occurs 10 Times ×10	Indicates which inventory control comment types (created for the item) automatically print on the unreleased purchase order report when the item prints on this report. `X` Select.	PO01.1
#`PCY-OPO-COM-OPT` OPO_COM_OPT	Alpha 1 Occurs 10 Times ×10	Indicate which inventory control comment types (created for the item) automatically print on the open purchase order report when the item prints on this report. `X` Select.	PO01.1
#`PCY-URC-COM-OPT` URC_COM_OPT	Alpha 1 Occurs 10 Times ×10	Indicates which inventory control comment types (created for the item) automatically print on the unreleased receivings report when the item prints on the report. `X` Select.	PO01.1
#`PCY-PRT-QTY-FLAG` PRT_QTY_FLAG	Alpha 1	This flag defines if the open order (unreceived) quantity for a purchase order line item prints on the receiver. `N` No `Y` Yes	PO01.1
#`PCY-DISP-QTY-FLAG` DISP_QTY_FLAG	Alpha 1	This flag defines if the open order (unreceived) quantity for a purchase order line item prints on the receiving forms. `N` No `Y` Yes	PO01.1
#`PCY-USE-ALL-FLAG` USE_ALL_FLAG	Alpha 1	This flag defines if the Receive All flag can be used in the online receiving process. `N` No `Y` Yes	PO01.1
#`PCY-OK-OSHIP-FLAG` OK_OSHIP_FLAG	Alpha 1	Defines if the company policy is to accept all shipments. If the flag is set to Yes, overshipment tolerances are ignored and buyer messages are not generated for excess overshipments. `N` Buyer Messages Created `Y` No Buyer Messages Created	PO01.1
#`PCY-OSHIP-TOL-PCT` OSHIP_TOL_PCT	Percent 5.3 (Percent)	Quantity overshipment tolerance percentage.	PO01.1
#`PCY-USHIP-TOL-PCT` USHIP_TOL_PCT	Percent 6.3 (Percent)	This is the quantity undership percentage for automatic back order cancellation. If a value of 10% is entered here, for instance, and a quantity of 91 is shipped against an ordered quantity of 100, that would be considered a 9% undershipment. Since this is less than the 10% limit, the backordered amount would be canceled. This process takes place at receiving time. If a backorder is not canceled manually, the system checks, in order, the purchase order line, the purchase order vendor purchase from record, the purchase order vendor record, and the company record. If an undershipment percentage of a zero percent flag set to Y is encountered at any level, that value is used. NOTE The percentage can be set at 100%, which would cancel all backorders.	PO01.1
#`PCY-RET-REAS-CD-FL` RET_REAS_CD_FL	Alpha 1	This field, if set to Y, indicates a reason code must be entered when performing returns processing. If set to N, a reason code can be entered, but it is not a requirement. `N` No `Y` Yes	PO01.1
#`PCY-RNI-POST-DATE` RNI_POST_DATE	Numeric 8 (yyyymmdd)	The received not invoiced general ledger posting date from the last closed period.	PO135
#`PCY-PRNI-POST-DAT` PRNI_POST_DAT	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	PO135
#`PCY-LAST-MSG-SEQ` LAST_MSG_SEQ	Numeric 6	This is the last assigned message sequence number for generated buyer messages.	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#`PCY-REOPEN-FL` REOPEN_FL	Alpha 1	This flag indicates whether or not the company allows a closed purchase order to be reopened. `N` No `Y` Yes	PO01.1
#`PCY-AOC-ACT-DAYS` AOC_ACT_DAYS	Numeric 3	Miscellaneous and item add-on cost no activity close days.	PO01.1
#`PCY-OE-PO-CODE` OE_PO_CODE	Alpha 4	This is the purchase order code.	PO01.1
#`PCY-IC-PO-CODE` IC_PO_CODE	Alpha 4	This is the purchase order code.	PO01.1
#`PCY-RQ-PO-CODE` RQ_PO_CODE	Alpha 4	This is the purchase order code.	PO01.1
#`PCY-PO-PO-CODE` PO_PO_CODE	Alpha 4	This is the purchase order code.	PO01.1
#`PCY-CX-PO-CODE` CX_PO_CODE	Alpha 4	This is the purchase order code.	PO01.1
#`PCY-VR-PO-CODE` VR_PO_CODE	Alpha 4	This is the purchase order code.	PO01.1
#`PCY-MAN-CODE-ALWD` MAN_CODE_ALWD	Alpha 1	— `A` All Documents `P` Purchase Orders Only `N` No	PO01.1
#`PCY-CODE-DFLT-METH` CODE_DFLT_METH	Numeric 1	— `1` IC Location `2` Requesting Location `3` Vendor Location/Vendor `4` Buyer Group `5` System `6` PO Code Not Defaulted	PO01.1
#`PCY-REQ-LOC-ON-PO` REQ_LOC_ON_PO	Alpha 1	This element specifies whether the requesting location, deliver to, and quantity should appear on PO lines for paper, fax, and email Purchase Orders. If Yes is specified, this information will appear on the PO line for lines that are created to satisfy requests from the Lawson Requisition or Case Carts applications. `N` No `Y` Yes	PO01.1
#`PCY-PRT-MATCH-DTL` PRT_MATCH_DTL	Alpha 1	— `Y` Yes `N` No	PO01.1
#`PCY-PROC-LEV-REQ` PROC_LEV_REQ	Alpha 1	— `Y` Yes `N` No	PO01.1
#`PCY-PL-DFLT-FRMLC` PL_DFLT_FRMLC	Alpha 1	— `Y` Yes `N` No	PO01.1
#`PCY-CONTRACT-ORD` CONTRACT_ORD	Numeric 1	0 6	PO01.4
#`PCY-CATALOG-ORD` CATALOG_ORD	Numeric 1	0 6	PO01.4
#`PCY-BLANKET-ORD` BLANKET_ORD	Numeric 1	0 6	PO01.4
#`PCY-LASTCOST-ORD` LASTCOST_ORD	Numeric 1	0 6	PO01.4
#`PCY-LASTPO-ORD` LASTPO_ORD	Numeric 1	0 6	PO01.4
#`PCY-SRC-OVR-RECVD` SRC_OVR_RECVD	Alpha 1	OE, Receive Excess Msg `N` No `Y` Yes	PO01.1
#`PCY-SUB-MESSAGE` SUB_MESSAGE	Alpha 1	Substitute Message `N` No `Y` Yes	PO01.1
#`PCY-PKG-TRK-LVL` PKG_TRK_LVL	Alpha 1	This field is the level of package tracking. Blank means that package tracking is not being used, 'H' means that tracking is at the header level, 'L' means line level. " " = Package Tracking Not Used `H` Header Level `L` Line Level	PO01.1
#`PCY-LBL-DFLT-1` LBL_DFLT_1	Alpha 1	This field indicates if a default value of 1 should be defaulted if the number of labels field is left blank on PO30. " " = Hdr Package Tracking Not Used `Y` Yes `N` No	PO01.1
#`PCY-PRT-VEND-CNTCT` PRT_VEND_CNTCT	Numeric 1	This field indicates if vendor contact information will print on the purchase order header. `0` No `1` Yes	PO01.1
#`PCY-POB-NAME` POB_NAME	Alpha 30 (Lower Case)	Displays the company description.	PO01.1
#`PCY-POB-ADDR1` POB_ADDR1	Alpha 30 (Lower Case)	This field contains the first line of address information.	PO01.1
#`PCY-POB-ADDR2` POB_ADDR2	Alpha 30 (Lower Case)	This field contains the first line of address information.	PO01.1
#`PCY-POB-ADDR3` POB_ADDR3	Alpha 30 (Lower Case)	This field contains the first line of address information.	PO01.1
#`PCY-POB-ADDR4` POB_ADDR4	Alpha 30 (Lower Case)	This field contains the first line of address information.	PO01.1
#`PCY-POB-CITY-ADDR5` POB_CITY_ADDR5	Alpha 18 (Lower Case)	This field contains the city of the address.	PO01.1
#`PCY-POB-STATE-PROV` POB_STATE_PROV	Alpha 2	The state or province.	PO01.1
#`PCY-POB-POSTAL-CD` POB_POSTAL_CD	Alpha 10 (Lower Case)	This field contains the postal code.	PO01.1
#`PCY-POB-COUNTRY-CD` POB_COUNTRY_CD	Alpha 2	The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	PO01.1
#`PCY-POB-COUNTY` POB_COUNTY	Alpha 25 (Lower Case)	The county for the company address.	PO01.1
#`PCY-POB-CONTACT` POB_CONTACT	Alpha 30 (Lower Case)	This is the name of the main contact.	PO01.1
#`PCY-IC-NO-CHRG-ORD` IC_NO_CHRG_ORD	Numeric 1	0 6	PO01.4
#`PCY-COST-OR-VEND` COST_OR_VEND	Numeric 1	— `0` Cost First Then Vendor `1` Vendor First Then Cost	PO01.4
#`PCY-RQ-AU-PAR-LOC` RQ_AU_PAR_LOC	Numeric 1	—	PO01.4
#`PCY-RQ-AU-COMAGMT` RQ_AU_COMAGMT	Numeric 1	—	PO01.4
#`PCY-RQ-AU-DIST-CD` RQ_AU_DIST_CD	Numeric 1	—	PO01.4
#`PCY-RQ-AU-TEMP-LN` RQ_AU_TEMP_LN	Numeric 1	—	PO01.4
#`PCY-RQ-AU-FR-LOC` RQ_AU_FR_LOC	Numeric 1	—	PO01.4
#`PCY-RQ-AU-HEADER` RQ_AU_HEADER	Numeric 1	—	PO01.4
#`PCY-RQ-AU-REQ-LOC` RQ_AU_REQ_LOC	Numeric 1	—	PO01.4
#`PCY-RQ-AU-AGMTPART` RQ_AU_AGMTPART	Numeric 1	—	PO01.4
#`PCY-PO-AU-COMAGMT` PO_AU_COMAGMT	Numeric 1	—	PO01.4
#`PCY-PO-AU-HEADER` PO_AU_HEADER	Numeric 1	—	PO01.4
#`PCY-PO-AU-TEMP-LN` PO_AU_TEMP_LN	Numeric 1	—	PO01.4
#`PCY-PO-AU-REQ-LOC` PO_AU_REQ_LOC	Numeric 1	—	PO01.4
#`PCY-PO-AU-SHIP-TO` PO_AU_SHIP_TO	Numeric 1	—	PO01.4
#`PCY-PO-AU-AGMTPART` PO_AU_AGMTPART	Numeric 1	—	PO01.4
#`PCY-RQ-ACC-PAR-LOC` RQ_ACC_PAR_LOC	Numeric 1	—	PO01.4
#`PCY-RQ-ACC-COMAGMT` RQ_ACC_COMAGMT	Numeric 1	—	PO01.4
#`PCY-RQ-ACC-DIST-CD` RQ_ACC_DIST_CD	Numeric 1	—	PO01.4
#`PCY-RQ-ACC-TEMP-LN` RQ_ACC_TEMP_LN	Numeric 1	—	PO01.4
#`PCY-RQ-ACC-HEADER` RQ_ACC_HEADER	Numeric 1	—	PO01.4
#`PCY-RQ-ACC-REQ-LOC` RQ_ACC_REQ_LOC	Numeric 1	—	PO01.4
#`PCY-RQ-ACC-FR-LOC` RQ_ACC_FR_LOC	Numeric 1	—	PO01.4
#`PCY-RQ-ACC-ITEMAST` RQ_ACC_ITEMAST	Numeric 1	—	PO01.4
#`PCY-RQ-ACC-AGMT-LN` RQ_ACC_AGMT_LN	Numeric 1	—	PO01.4
#`PCY-PO-ACC-COMAGMT` PO_ACC_COMAGMT	Numeric 1	—	PO01.4
#`PCY-PO-ACC-HEADER` PO_ACC_HEADER	Numeric 1	—	PO01.4
#`PCY-PO-ACC-TEMP-LN` PO_ACC_TEMP_LN	Numeric 1	—	PO01.4
#`PCY-PO-ACC-REQ-LOC` PO_ACC_REQ_LOC	Numeric 1	—	PO01.4
#`PCY-PO-ACC-SHIP-TO` PO_ACC_SHIP_TO	Numeric 1	—	PO01.4
#`PCY-PO-ACC-ITEMAST` PO_ACC_ITEMAST	Numeric 1	—	PO01.4
#`PCY-PO-ACC-AGMT-LN` PO_ACC_AGMT_LN	Numeric 1	—	PO01.4
#`PCY-RQ-ACV-COMAGMT` RQ_ACV_COMAGMT	Numeric 1	—	PO01.4
#`PCY-RQ-ACV-TEMP-LN` RQ_ACV_TEMP_LN	Numeric 1	—	PO01.4
#`PCY-RQ-ACV-HEADER` RQ_ACV_HEADER	Numeric 1	—	PO01.4
#`PCY-RQ-ACV-REQ-LOC` RQ_ACV_REQ_LOC	Numeric 1	—	PO01.4
#`PCY-RQ-ACV-AGMT-LN` RQ_ACV_AGMT_LN	Numeric 1	—	PO01.4
#`PCY-PO-ACV-COMAGMT` PO_ACV_COMAGMT	Numeric 1	—	PO01.4
#`PCY-PO-ACV-TEMP-LN` PO_ACV_TEMP_LN	Numeric 1	—	PO01.4
#`PCY-PO-ACV-HEADER` PO_ACV_HEADER	Numeric 1	—	PO01.4
#`PCY-PO-ACV-AGMT-LN` PO_ACV_AGMT_LN	Numeric 1	—	PO01.4
#`PCY-RQ-ACT-COMAGMT` RQ_ACT_COMAGMT	Numeric 1	—	PO01.4
#`PCY-RQ-ACT-TEMP-LN` RQ_ACT_TEMP_LN	Numeric 1	—	PO01.4
#`PCY-RQ-ACT-HEADER` RQ_ACT_HEADER	Numeric 1	—	PO01.4
#`PCY-RQ-ACT-REQ-LOC` RQ_ACT_REQ_LOC	Numeric 1	—	PO01.4
#`PCY-RQ-ACT-AGMT-LN` RQ_ACT_AGMT_LN	Numeric 1	—	PO01.4
#`PCY-RQ-ACT-GLACCAT` RQ_ACT_GLACCAT	Numeric 1	—	PO01.4
#`PCY-PO-ACT-COMAGMT` PO_ACT_COMAGMT	Numeric 1	—	PO01.4
#`PCY-PO-ACT-TEMP-LN` PO_ACT_TEMP_LN	Numeric 1	—	PO01.4
#`PCY-PO-ACT-HEADER` PO_ACT_HEADER	Numeric 1	—	PO01.4
#`PCY-PO-ACT-AGMT-LN` PO_ACT_AGMT_LN	Numeric 1	—	PO01.4
#`PCY-PO-ACT-GLACCAT` PO_ACT_GLACCAT	Numeric 1	—	PO01.4
#`PCY-RQ-VEN-AGRMT` RQ_VEN_AGRMT	Numeric 1	—	PO01.4
#`PCY-RQ-VEN-ITEMSRC` RQ_VEN_ITEMSRC	Numeric 1	—	PO01.4
#`PCY-RQ-VEN-HEADER` RQ_VEN_HEADER	Numeric 1	—	PO01.4
#`PCY-IC-VEN-ITEMSRC` IC_VEN_ITEMSRC	Numeric 1	—	PO01.4
#`PCY-IC-VEN-AGRMT` IC_VEN_AGRMT	Numeric 1	—	PO01.4
#`PCY-RQ-PF-AGRMT` RQ_PF_AGRMT	Numeric 1	—	PO01.4
#`PCY-RQ-PF-ITEMSRC` RQ_PF_ITEMSRC	Numeric 1	—	PO01.4
#`PCY-RQ-PF-HEADER` RQ_PF_HEADER	Numeric 1	—	PO01.4
#`PCY-IC-PF-ITEMSRC` IC_PF_ITEMSRC	Numeric 1	—	PO01.4
#`PCY-IC-PF-AGRMT` IC_PF_AGRMT	Numeric 1	—	PO01.4
#`PCY-LAST-SEQ-NBR` LAST_SEQ_NBR	Numeric 4	An automatically assigned sequence number.	PO01.4
#`PCY-RQPO-RQ-LOC` RQPO_RQ_LOC	Numeric 1	—	PO01.4
#`PCY-RQPO-IC-LOC` RQPO_IC_LOC	Numeric 1	—	PO01.4
#`PCY-RQPO-VENDOR` RQPO_VENDOR	Numeric 1	—	PO01.4
#`PCY-RQPO-VENDLOC` RQPO_VENDLOC	Numeric 1	—	PO01.4
#`PCY-OEPO-VENDOR` OEPO_VENDOR	Numeric 1	—	PO01.4
#`PCY-OEPO-VENDLOC` OEPO_VENDLOC	Numeric 1	—	PO01.4
#`PCY-OEPO-IC-LOC` OEPO_IC_LOC	Numeric 1	—	PO01.4
#`PCY-SS-USED` SS_USED	Numeric 1	— `0` Strategic Sourcing Not Used `1` Strategic Sourcing Used	PO01.1
#`PCY-PO-RUN-STS` PO_RUN_STS	Numeric 1	— `0` None `1` PO135 Running	PO135
#`PCY-VR-CXL-UPD-SOH` VR_CXL_UPD_SOH	Numeric 1	— `0` No `1` Yes	PO01.1
#`PCY-RQ-PCARD-RQH` RQ_PCARD_RQH	Numeric 1	—	—
#`PCY-RQ-PCARD-RQL` RQ_PCARD_RQL	Numeric 1	—	—
#`PCY-RQ-PCARD-REQ` RQ_PCARD_REQ	Numeric 1	—	—
#`PCY-RQ-PCARD-VEN` RQ_PCARD_VEN	Numeric 1	—	—
#`PCY-RQ-PCARD-BUY` RQ_PCARD_BUY	Numeric 1	—	—
#`PCY-PO-PCARD-BUY` PO_PCARD_BUY	Numeric 1	—	—
#`PCY-PO-PCARD-VEN` PO_PCARD_VEN	Numeric 1	—	—
#`PCY-SS-PO-CODE` SS_PO_CODE	Alpha 4	This is the purchase order code.	PO01.1
#`PCY-PO-AUDIT-FL` PO_AUDIT_FL	Numeric 1	— `0` Audit After Issue Final `1` Audit Before Issue Final	PO01.1
#`PCY-DEL-PO-COMMIT` DEL_PO_COMMIT	Numeric 1	— `0` No `1` Yes	PO01.1
#`PCY-REC-BUDGET-FL` REC_BUDGET_FL	Alpha 1	— `Y` Yes `N` No	PO01.1
#`PCY-DEF-PRINT-FORM` DEF_PRINT_FORM	Numeric 1	— `1` Preprinted Form `2` Plain Paper `3` XML	PO01.1
#`PCY-DEF-ORIENT` DEF_ORIENT	Alpha 1	— `P` Portrait `L` Landscape	PO01.1
#`PCY-REOPEN-PLI-FL` REOPEN_PLI_FL	Alpha 1	— `Y` Yes `N` No	PO01.1
#`PCY-RQ-AU-AGMT-LN` RQ_AU_AGMT_LN	Numeric 1	—	PO01.4
#`PCY-PO-AU-AGMT-LN` PO_AU_AGMT_LN	Numeric 1	—	PO01.4
#`PCY-POB-PHONE-PREF` POB_PHONE_PREF	Alpha 6	—	PO01.1
#`PCY-POB-PHONE` POB_PHONE	Alpha 15	—	PO01.1
#`PCY-POB-PHONE-EXT` POB_PHONE_EXT	Alpha 5	—	PO01.1
#`PCY-POB-EMAIL-ADDR` POB_EMAIL_ADDR	Alpha 60 (Lower Case)	—	PO01.1
#`PCY-PO100-RUN-STS` PO100_RUN_STS	Numeric 1	— `0` None `1` PO100 Running	—
#`PCY-TRK-NBR-DFLT-1` TRK_NBR_DFLT_1	Alpha 1	— `Y` Yes `N` No	—
#`PCY-COST-OR-VENITM` COST_OR_VENITM	Numeric 1	This is a flag to indicate whether to default the PO unit cost before the vendor item or whether to default the vendor item before the PO unit cost. If the PO unit cost is first then it can bring back a vendor item and use it. If the vendor item is first then it will be input into the PO unit cost default routine. `0` Cost before vendor item `1` Vendor item before cost	PO01.4
#`PCY-APPROVAL-TYPE` APPROVAL_TYPE	Alpha 1	The type of PO approval record. `0` Header approval-PO approval cd `1` Header approval-Process Flow `2` No Approvals required	PO01.1
#`PCY-DSP-PAT-ID` DSP_PAT_ID	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-PAT-ID` EDI_PAT_ID	Alpha 1	—	PO01.1, PO01.5
#`PCY-MSK-PAT-ID` MSK_PAT_ID	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-VISIT-NBR` DSP_VISIT_NBR	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-VISIT-NBR` EDI_VISIT_NBR	Alpha 1	—	PO01.1, PO01.5
#`PCY-MSK-VISIT-NBR` MSK_VISIT_NBR	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-CASE-NBR` DSP_CASE_NBR	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-CASE-NBR` EDI_CASE_NBR	Alpha 1	—	PO01.1, PO01.5
#`PCY-MSK-CASE-NBR` MSK_CASE_NBR	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-PROC` DSP_PROC	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-PROC` EDI_PROC	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-PROC-DT` DSP_PROC_DT	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-PROC-DT` EDI_PROC_DT	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-PHYS-NAME` DSP_PHYS_NAME	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-PHYS-NAME` EDI_PHYS_NAME	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-NRS-COORD` DSP_NRS_COORD	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-NRS-COORD` EDI_NRS_COORD	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-SALES-REP` DSP_SALES_REP	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-SALES-REP` EDI_SALES_REP	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-ORD-NBR` DSP_ORD_NBR	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-ORD-NBR` EDI_ORD_NBR	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-REQUESTOR` DSP_REQUESTOR	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-REQUESTOR` EDI_REQUESTOR	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-LOT` DSP_LOT	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-LOT` EDI_LOT	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-SER-NBR` DSP_SER_NBR	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-SER-NBR` EDI_SER_NBR	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-USERDEF1` DSP_USERDEF1	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-USERDEF1` EDI_USERDEF1	Alpha 1	—	PO01.1, PO01.5
#`PCY-DSP-USERDEF2` DSP_USERDEF2	Alpha 1	—	PO01.1, PO01.5
#`PCY-EDI-USERDEF2` EDI_USERDEF2	Alpha 1	—	PO01.1, PO01.5

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PCYSET1`	`COMPANY`	Primary		AM19.1, AM19.2, AP00.4, AP05.3, AP05.6, AP06.1, AP115, AP125 +22 more (list truncated in source)
`PCYSET2`	`PROCURE-GROUP` `COMPANY`	KeyChange		AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (4) — lookups and parents

Relation Table Rules Condition Field map

Iccompany

ICCOMPANY

Required

PCY-COMPANY → ICC-COMPANY

Itemgroup

ITEMGROUP

Required

ICC-ITEM-GROUP → ITG-ITEM-GROUP

Pofrtterm

POFRTTERM

Required

`PCY-PROCURE-GROUP`	→	`POF-PROCURE-GROUP`
`PCY-FREIGHT-TERMS`	→	`POF-FREIGHT-TERMS`

Procuregrp

PROCUREGRP

Required

PCY-PROCURE-GROUP → PCG-PROCURE-GROUP

One to many (5) — child tables

Relation Table Rules Condition Field map

Iclocation

ICLOCATION

`PCY-COMPANY`	→	`ICL-COMPANY`
—	→	`ICL-LOCATION`

Poaocmast

POAOCMAST

Delete Restricted

`PCY-COMPANY`	→	`PAM-COMPANY`
—	→	`PAM-AOC-CODE`

Podefaudit

PODEFAUDIT

Delete Cascades

`PCY-COMPANY`	→	`PDT-COMPANY`
—	→	`PDT-AUDIT-TYPE`
—	→	`PDT-UPDATE-DATE`
—	→	`PDT-UPDATE-TIME`
—	→	`PDT-FLD-NBR`
—	→	`PDT-SEQ-NBR`
—	→	`PDT-AUDIT-ACTION`

Podocref

PODOCREF

`Spaces`	→	`POD-PROCURE-GROUP`
`PCY-COMPANY`	→	`POD-COMPANY`
—	→	`POD-TYPE`
—	→	`POD-PO-CODE`

Purchorder

PURCHORDER

Delete Restricted

`PCY-COMPANY`	→	`PCR-COMPANY`
—	→	`PCR-PO-CODE`
—	→	`PCR-PO-NUMBER`
—	→	`PCR-PO-RELEASE`

Programs

Updated by (224)

AP125 Batch Release
AP126 Mass Invoice Release
AP131 Chargeback
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP25.1 Batch Control
AP25.2 Batch Review
AP26.1 Invoice Release
AP27.1 Single Invoice Release
AP30.4 Invoice Cancel
AP510 Vendor Conversion
API1.1 Add Invoice
API2.1 Add Invoice
CX100 Pick List Print
CX20.1 Case Build
CX20.2 Case Detail
CX20.4 Substitute Items
CX20.5 Insert line
CX220 Case, Preference Listing
CX30.1 Case Completion Feedback
CX300 Preference List Purge
CX506 HL7 Schedules Import Interface
CXCP.1 Copy preference to case
DR100 Distribution Requirements Report
IC12.1 Item Location
IC140 Vendor Reorder Advice
IC141 Location Replenishment Report
IC142 Replenishment by Requisition PO's
IC145 Stock Status Report
IC243 Killed Item Report
IC330 Item Mass Change
IC64.1 Global Location Nbr Assignment GL/IC Company
IC64.2 Global Location Nbr Assignment IC Location
IC64.3 Global Location Number Assignment RQ Location
IC64.4 Global Location Number Assignment Manuf Code
IC64.5 Global Location Number Assignment Manuf Div
IC64.6 Global Location Number Assignment Vendor
IC64.7 Global Location Number Assignment Vendor Location
IC64.8 Global Location Number Assignment IC Bin
IC64.9 Global Location Number Assignment Buyer
IC66.1 Replenishment PO Worksheet
IC83.1 Par Location Counts
MA180 Open Receipt Archive
MA278 Cost Variance Analysis
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.2 Purchase Order Lookup
MA43.7 GL Distribution
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA53.1 Receipt Interface
MA530 ERS Invoice Creation
MA531 Receipt Interface
MA60.2 Invoice Level Match
MA60.3 Detail Level Match
MA60.5 Receipt Match Reference Adjustment
MA61.1 Match Invoice Approval
MA66.2 Invoice Message - Details
MA67.2 Invoice Match from frontend
MA67.3 Detail Match from frontend
MA68.2 Invoice Level Match - Prepaid
MA68.3 Detail Level Match - Prepaid
MA68.5 Receipt Match Reference Adjustment
MA70.1 Invoice Unmatch
MA75.1 PO Invoice Cancel
MA80.1 Receipt Archive
MAI1.1 Invoke for MAMATCH Object
PD10.1 P-Card Card Request
PD10.2 P-Card Cardholder
PD130 P-Card Invoice and Release
PD20.1 P-Card Charge Approval
PD20.2 P-Card Charge Approval Level
PD20.3 P-Card Charge Approval SEA
PD570 P-Card Charge Import
PO01.1 PO Company Setup
PO01.4 Default Rules
PO01.5 Procedure Info Output
PO04.1 Buyer
PO04.2 Buyer Purchasing Class
PO10.1 PO Vendor
PO10.2 Vendor Purchase From Location
PO100 Purchase Order Interface from Lawson Applications
PO101 Create Standing PO Release
PO115 Procurement Template Mass Changes
PO120 Mass PO Issue
PO122 Transmitted PO Acknowledgement
PO131 Receiving Log
PO132 Print Vendor Return Material Authorization
PO135 Received, Not Invoiced Report
PO136 Matched, Not Received Report
PO15.1 Procurement Templates
PO15.2 Procurement Template Participants
PO15.4 Procurement Template Line Detail
PO150 Bid Load to Contract or Catalog
PO17.1 Purchase Order Approval Review
PO190 Close Purchase Order Header
PO20.1 Purchase Order Entry
PO20.6 Substitute Vendor Items
PO20.9 Multiple Lines
PO204 Buyer Master Listing
PO21.1 Select and Copy
PO21.2 Add-On Cost Spread
PO21.3 Account Distribution
PO21.4 Miscellaneous Add-On Cost
PO21.5 Item Add-On Cost
PO22.1 Authorization, Release
PO22.3 Mass Cancel or Delete Purchase Orders
PO22.4 Mass Cancel or Delete Purchase Order Lines
PO220 PO Status Report
PO222 Remaining PO Balance Report
PO224 PO Revision Report
PO225 Vendor Agreement Listing
PO229 Vendor Agreement Format Print
PO23.1 Purchase Order Worksheet
PO230 Unreleased Receivings Listing
PO234 PO Interface Listing Report
PO24.1 Purchase Order Direct Approval
PO25.1 Vendor Agreements
PO25.5 Vendor Agreement Item Add-On Cost
PO25.6 Vendor Agreement Line
PO25.7 Service Agreement Line
PO251 PO Buyer Message Listing
PO26.3 Vendor Agreement Commitments Spread
PO26.7 Mass Release of Vendor Agreements
PO26.9 Vendor Agreement Release
PO27.2 Select Blanket Lines
PO27.3 Create PO From Procurement Template
PO27.4 Select and Copy Template
PO275 Delivery Date Analysis
PO276 Deliver Quantity Analysis
PO277 Deliver Quality Analysis
PO28.2 Vendor Agreement Line Detail List
PO280 Purchases By Class
PO29.1 Copy Purchase Order
PO30.1 PO Receiving
PO30.2 Substitute Item
PO30.3 Additional Tracking Numbers
PO30.4 PO Receiving Line Detail List
PO300 PO and Receipt Purge
PO31.1 Vendor Return
PO31.2 Vendor Return Item Selection
PO32.2 Item Detail
PO32.4 Cancel Detail
PO33.1 Receiving Adjustment
PO34.1 Inspection Accept or Reject
PO35.1 Receiving Approval and Release
PO36.1 Identify Lawson Items by Vendor Agreement Line
PO36.2 Vendor Agreement Import Manual Input
PO38.1 Invoice AOC
PO39.1 Additional Receiving Entry
PO39.2 Additional Adjustment/Rejection Entry
PO44.1 PO Line Source
PO50.1 Buyer Message Entry
PO52.1 Buyer Message - Receiving
PO520 Purchase Order Interface from Non Lawson
PO536 Vendor Price Agreement Load
PO54.5 PO Line Detail List
POCP.1 POC Comments Copy
POI3.1 Invoke for POPI70PD
POID.1 PO Delivery Ticket Select
POII.1 Invoke for POPCRUPD
POIJ.1 Invoke for POPLIUPD
RQ01.1 Requesting Locations
RQ10.1 Requisition
RQ10.2 Account Distribution
RQ10.3 Select and Copy
RQ10.4 Requisition Line Entry Detail
RQ10.5 Substitutes
RQ11.1 Kit Accessories
RQ12.1 Approval Review
RQ13.1 Direct Approval
RQ13.2 Direct Line Approval
RQ35.1 Requisition Returns
RQ44.1 Requisition Inquiry
RQ500 Requisition Interface
RQ810 Request Location Load
RQIB.1 RQRQHUPD Invoke Object
RQIF.1 RQRLNUPD Invoke Object
RQII.1 Invoke for Reqheader Inquiry
RQIJ.1 Requisition Copy
WH130 Pick List Print
WH132 Batch Feedback
WH190 Shipment Release
WH20.2 Nonstock and Special Allocation
WH20.7 Substitute Location
WH222 Shipments In Process
WH30.1 Picking Feedback by Document
WH30.2 Picking Feedback by Shipment
WH30.3 Picking by Batch
WH30.4 Bin Sequence Picking Feedback
WH31.1 Packing Feedback by Document
WH31.2 Packing Feedback by Shipment
WH31.3 Packing by Batch
WH31.4 Bin Sequence Packing Feedback
WH32.1 Shipping Feedback by Document
WH32.2 Shipping Feedback by Shipment
WH32.3 Shipping by Batch
WH32.4 Bin Sequence Shipping Feedback
WH32.5 Shipping Line Feedback
WH33.1 Bins
WH33.2 Lots
WH33.3 Serials
WH33.4 UOMs
WH33.5 Additional Shipment Information
WH33.6 Catch Weight
WH33.8 Preassembled Kits
WH33.9 Line Options
WH34.1 Component Bins
WH34.2 Component Lots
WH34.3 Component Serials
WH34.4 Component UOMs
WH40.1 Bill of Lading
WH40.2 Bill of Lading Feedback
WH520 Batch Feedback Interface
WH830 Shipment Load Program

Referenced by (164)

AM19.1 PO Line Asset Detail
AM19.2 Create Detail
AP00.4 Company
AP05.3 Distribution Code
AP05.6 Authority Code
AP06.1 Authorized Buyer
AP115 Vendor Merge
AP133 Mass Retainage Payment Adjust
AP205 Accounts Payable Codes Listing
AP220 Invoice Edit Report
AP233 Retainage Invoice Listing
AP305 Accounts Payable Company Purge
AP520 Invoice Interface
AP97.2 Retainage Invoice Inquiry By Purchase Order
AP97.3 Retainage Totals
AR10.1 Customer
CX05.1 Preference Template
CX05.2 Preference Template Diagnostics
CX55.1 Case Procedure Inquiry
CX805 Template Card Conversion
IC01.1 Company
IC02.1 Location
IC10.2 Item Master and Location
IC11.1 Item Master
IC130 General Ledger Interface
IC15.2 Bins
IC175 Update Variances
IC183 Par Level Load
IC20.1 Receipts
IC20.2 Detail Receipts
IC21.1 Issues
IC21.2 Detail Issues
IC22.1 Transfers
IC22.2 Detail Transfer
IC223 Availability Report
IC23.1 Intransit Receiving
IC24.1 Adjustments
IC24.2 Detail Adjustments
IC25.1 Document Release
IC320 Mass Item Location Copy
IC331 Par Cart Mass Changes
IC500 Transaction Interface
IC503 IC Valid UOM CSV Create
IC524 CSV Item Master
IC58.1 Global Location Numbers
IC598 Bin Label Export
IC62.1 Finished Goods
IC81.1 Cart, Par Location
IC81.2 Cart, Par Location Item Detail
IC811 Item Master Load
IC812 Item Location Load
IC82.1 Par Location Item Mass Change
IC840 Cart Par Location Conversion
ICIA.1 Keyword Search INVOKED Object
MA08.1 Add On Charge/Allowance
MA126 Auto Matching
MA208 Add on Charge/Allowance Listing
MA236 Invoiced, Not Received Report
MA237 Match Update Report
MA26.1 PO Invoice Match
MA264 Invoice Message Listing
MA279 Invoice AOC Detail Report
MA540 Invoice Interface
MA63.1 Invoice Line Match
MA64.9 PO Cost Message Accept Upload
MA65.1 Invoice Line Adjustment
MA69.1 AOC Level Detail Match
MA90.1 Match Analysis
MA95.1 Vendor History
MA95.2 Vendor History Analysis
MAED.1 Vendor
MM280 Departmental Procurement Expense Report
MM80.1 Departmental Procurement Expense Inquiry Selection
MM80.2 Departmental Procurement Expense Inquiry Detail
PD01.2 P-Card Program Companies
PD21.1 P-Card Charge Detail
PD262 PCard Setup Audit Report
PD62.2 Pcard Program Company Audit Inquiry
PO00.1 Procurement Group
PO08.1 Po Approval Code Maintenance
PO130 Receiving Document
PO133 Receiving Adjustment Log
PO134 Receiving Delivery and Putaway
PO139 Standard Cost Calculation
PO16.1 Bid
PO16.2 Bid Response
PO165 Procure Template Audit Report
PO18.1 Workflow Approval Maintenance
PO181 Load PO AUDITRULES
PO191 Audit Report of Deleted PO Numbers
PO194 PO Company Setup Audit Report
PO195 PO Vendor Agreement Audit Report
PO199 Subsystem Close
PO216 Bid Analysis
PO223 Buyer Expediting Report
PO227 Contract Agreement Compliance Report
PO228 Consolidated Demand Report
PO231 Return Status Report
PO233 PO Received Quantity Exceptions
PO240 Sub Contractor Monitoring Rpt
PO253 Item Receipt Volume Report
PO254 PO Inquiry Report
PO258 Receipt Inquiry Report from PO58
PO268 Default Rule Audit Log
PO274 Returns Analysis
PO278 RNI Aging Report
PO285 PO Activity By Source Report
PO295 Cash Requirements Forecast
PO522 PO Output Purge
PO529 PO Receiving File Create
PO53.1 Purchase Order Interface
PO53.2 Purchase Order Line Interface
PO53.3 Purchase Order Distribution Interface
PO53.4 Miscellaneous AOC
PO53.5 PO Conversion Comments
PO53.8 Item AOC
PO53.9 PO Line Asset Defaults
PO550 Bid Creation
PO58.1 Receipt Inquiry
PO58.2 Receipt Inquiry
PO61.2 PO Company Audit Inquiry
PO63.1 PO Inquiry By Item
PO64.1 PO Line Item History
PO65.1 Vendor Agreement Header Audit Inquiry
PO65.4 Procurement Template Participants Audit
PO66.1 PO Revision History
PO66.2 Purchase Order Audit Inquiry
PO67.1 PO Inquiry By AOC
PO68.1 PO Default Rules History
PO68.2 PO Default Rules Audit Inquiry
PO700 PO Hdr and Line Pivot UPGRADE
PO94.1 Vendor Performance
PO983 PO Line Item UNSPSC
POA1.1 Define Procurement Data Mart
POA10 List Duplicate Values for Data Mart
POA2.4 Define Organization Dimension
POA3.1 Data Load for Vendor Analysis
POAO.1 Olap Dimension Retrieval Format
POAX.1 Common Edits for Vend Analysis
POI4.1 PODOCREF Invoked Oject
POI7.1 POI7 Print Object
POIE.1 Delivery Ticket Report
POIF.1 MMDIST Activity Commit
POIG.1 MMDIST Budget Check
POIH.1 Invokeable Unit Cost Default
POIM.1 GL Budget Ck for PO and RQ
POIT.1 Invoke PO Total Method
RQ04.1 Requesters
RQ111 Print Requisitions
RQ140 Requisition Status Report
RQ260 Requisitioned Items Report
RQ300 Requisition Purge
RQ40.1 Requisitions by Location
RQ41.1 Requisition Status
RQ42.1 Requisitions by Item
RQCP.1 Copy Attachment Comments
RQD0.1 Invoke for RQ Orphan Check
RQIA.1 RQREQPD Invoke Object
RQIC.1 Get Item List Invoke Object
RQID.1 RQRQHUPD Invoke Object
RQIG.1 Get Shopping List Invoke Object
WH02.1 Outside Warehouse Participants
WH25.1 Cancellation By Item
WH25.2 Cancellation By Document

POCOMPANY – Company System Master

About POCOMPANY

Fields (188) Copy as SQL

Indexes (2)

Relations

One to one (4) — lookups and parents

One to many (5) — child tables

Programs

Updated by (224)

Referenced by (164)

Fields (188)