Company System Master
A file of valid Purchase Order companies and corresponding parameters.
REFERENCED BY
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
|---|---|---|---|---|
| PCY-COMPANY Element: Company | Numeric 4 The company number. |
|
||
| PCY-NAME Element: Name | Alpha 30 (Lower Case) Displays the company description. |
|
||
| PCY-PROCURE-GROUP Element: 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. |
|||
| PCY-BASE-CURR-CD Element: Currency Code | Alpha 5 The general ledger-defined currency code for this purchase order company. |
|
||
| PCY-BASE-CUC-DESC Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
| PCY-BASE-ND Element: Base Nd | Numeric 1 The number of decimal positions defined for the company base currency. |
|
||
| PCY-FREIGHT-TERMS Default Freight Terms | Alpha 1 Default terms code used to describe the terms of the freight on a purchase order. |
|
||
| PCY-UOM-REQ-FL Element: Require UOM | 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 |
|
||
| PCY-REVISIONS-INCL Element: 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). O = Revisions Only C = Revisions Complete I = Reissue " " = Not Applicable |
|
||
| PCY-PO-COM-OPT Purchase Order Comment Type | Alpha 1 Occurs 10 Times 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. |
|
||
| PCY-POE-COM-OPT Transmitted POs Comment Type | Alpha 1 Occurs 10 Times 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. |
|
||
| PCY-REC-COM-OPT Receiving Document Comt Type | Alpha 1 Occurs 10 Times 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. |
|
||
| PCY-UPO-COM-OPT Unreleased POs Comment Type | Alpha 1 Occurs 10 Times 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. |
|
||
| PCY-OPO-COM-OPT Open POs Comment Type | Alpha 1 Occurs 10 Times 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. |
|
||
| PCY-URC-COM-OPT Unreleased Receivings Cmt Type | Alpha 1 Occurs 10 Times 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. |
|
||
| PCY-PRT-QTY-FLAG Print Quantity on Document | 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 |
|
||
| PCY-DISP-QTY-FLAG Display Quantity on Screen | 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 |
|
||
| PCY-USE-ALL-FLAG Element: Receive All | Alpha 1 This flag defines if the Receive All flag can be used in the online receiving process. N = No Y = Yes |
|
||
| PCY-OK-OSHIP-FLAG Element: All 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 |
|
||
| PCY-OSHIP-TOL-PCT Overshipment Percentage | Percent 5.3 (Percent) Quantity overshipment tolerance percentage. |
|
||
| PCY-USHIP-TOL-PCT Undershipment Cncl Percentage | 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. |
|
||
| PCY-RET-REAS-CD-FL Element: Reason Code Required | 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 |
|
||
| PCY-RNI-POST-DATE Element: Date | Numeric 8 (yyyymmdd) The received not invoiced general ledger posting date from the last closed period. |
|
||
| PCY-PRNI-POST-DAT Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||
| PCY-LAST-MSG-SEQ Element: Seq Number | Numeric 6 This is the last assigned message sequence number for generated buyer messages. |
|||
| PCY-REOPEN-FL Element: Reopen History PO | Alpha 1 This flag indicates whether or not the company allows a closed purchase order to be reopened. N = No Y = Yes |
|
||
| PCY-AOC-ACT-DAYS Miscellaneous AOC Closed Days | Numeric 3 Miscellaneous and item add-on cost no activity close days. |
|
||
| PCY-OE-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||
| PCY-IC-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||
| PCY-RQ-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||
| PCY-PO-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||
| PCY-CX-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||
| PCY-VR-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||
| PCY-MAN-CODE-ALWD Element: All Flag | Alpha 1 A = All Documents P = Purchase Orders Only N = No |
|
||
| PCY-CODE-DFLT-METH Element: 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 |
|
||
| PCY-REQ-LOC-ON-PO Element: 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 |
|
||
| PCY-PRT-MATCH-DTL Element: Prt Match Dtl | Alpha 1 Y = Yes N = No |
|
||
| PCY-PROC-LEV-REQ Element: Proc Lev Req | Alpha 1 Y = Yes N = No |
|
||
| PCY-PL-DFLT-FRMLC Element: Pl Dflt Frmlc | Alpha 1 Y = Yes N = No |
|
||
| PCY-CONTRACT-ORD Element: Contract Ord | Numeric 1 0 6 |
|
||
| PCY-CATALOG-ORD Element: Catalog Ord | Numeric 1 0 6 |
|
||
| PCY-BLANKET-ORD Element: Blanket Ord | Numeric 1 0 6 |
|
||
| PCY-LASTCOST-ORD Element: Lastcost Ord | Numeric 1 0 6 |
|
||
| PCY-LASTPO-ORD Element: Lastpo Ord | Numeric 1 0 6 |
|
||
| PCY-SRC-OVR-RECVD Element: Src Ovr Recvd | Alpha 1 OE, Receive Excess Msg N = No Y = Yes |
|
||
| PCY-SUB-MESSAGE Element: Sub Message | Alpha 1 Substitute Message N = No Y = Yes |
|
||
| PCY-PKG-TRK-LVL Element: 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 |
|
||
| PCY-LBL-DFLT-1 Element: 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. Y = Yes N = No " " = Hdr Package Tracking Not Used |
|
||
| PCY-PRT-VEND-CNTCT Element: Prt Vend Cntct | Numeric 1 This field indicates if vendor contact information will print on the purchase order header. 0 = No 1 = Yes |
|
||
| PCY-POB-NAME Element: Name | Alpha 30 (Lower Case) Displays the company description. |
|
||
| PCY-POB-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
| PCY-POB-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
| PCY-POB-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
| PCY-POB-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
| PCY-POB-CITY-ADDR5 Element: City | Alpha 18 (Lower Case) This field contains the city of the address. |
|
||
| PCY-POB-STATE-PROV Element: State Prov | Alpha 2 The state or province. |
|
||
| PCY-POB-POSTAL-CD Element: Postal Code | Alpha 10 (Lower Case) This field contains the postal code. |
|
||
| PCY-POB-COUNTRY-CD Element: Country Code | Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). |
|
||
| PCY-POB-COUNTY Element: County | Alpha 25 (Lower Case) The county for the company address. |
|
||
| PCY-POB-CONTACT Element: Addr Contact | Alpha 30 (Lower Case) This is the name of the main contact. |
|
||
| PCY-IC-NO-CHRG-ORD Element: Ic No Chrg Ord | Numeric 1 0 6 |
|
||
| PCY-COST-OR-VEND Element: Cost Or Vend | Numeric 1 0 = Cost First Then Vendor 1 = Vendor First Then Cost |
|
||
| PCY-RQ-AU-PAR-LOC Element: Au Par Loc | Numeric 1 |
|
||
| PCY-RQ-AU-COMAGMT Element: Au Com Agrmt | Numeric 1 |
|
||
| PCY-RQ-AU-DIST-CD Element: Au Dist Code | Numeric 1 |
|
||
| PCY-RQ-AU-TEMP-LN Element: Au Templ Line | Numeric 1 |
|
||
| PCY-RQ-AU-FR-LOC Element: Rq Au Fr Loc | Numeric 1 |
|
||
| PCY-RQ-AU-HEADER Element: Au Header | Numeric 1 |
|
||
| PCY-RQ-AU-REQ-LOC Element: Au Req Loc | Numeric 1 |
|
||
| PCY-RQ-AU-AGMTPART Element: Au Agrmt Part | Numeric 1 |
|
||
| PCY-PO-AU-COMAGMT Element: Au Com Agrmt | Numeric 1 |
|
||
| PCY-PO-AU-HEADER Element: Au Header | Numeric 1 |
|
||
| PCY-PO-AU-TEMP-LN Element: Au Templ Line | Numeric 1 |
|
||
| PCY-PO-AU-REQ-LOC Element: Au Req Loc | Numeric 1 |
|
||
| PCY-PO-AU-SHIP-TO Element: Po Au Ship To | Numeric 1 |
|
||
| PCY-PO-AU-AGMTPART Element: Au Agrmt Part | Numeric 1 |
|
||
| PCY-RQ-ACC-PAR-LOC Element: Acc Par Loc | Numeric 1 |
|
||
| PCY-RQ-ACC-COMAGMT Element: Acc Com Agrmt | Numeric 1 |
|
||
| PCY-RQ-ACC-DIST-CD Element: Acc Dist Code | Numeric 1 |
|
||
| PCY-RQ-ACC-TEMP-LN Element: Acc Templ Line | Numeric 1 |
|
||
| PCY-RQ-ACC-HEADER Element: Acc Header | Numeric 1 |
|
||
| PCY-RQ-ACC-REQ-LOC Element: Acc Req Loc | Numeric 1 |
|
||
| PCY-RQ-ACC-FR-LOC Element: Rq Acc Fr Loc | Numeric 1 |
|
||
| PCY-RQ-ACC-ITEMAST Element: Acc Itemmast | Numeric 1 |
|
||
| PCY-RQ-ACC-AGMT-LN Element: Acc Agrmt Line | Numeric 1 |
|
||
| PCY-PO-ACC-COMAGMT Element: Acc Com Agrmt | Numeric 1 |
|
||
| PCY-PO-ACC-HEADER Element: Acc Header | Numeric 1 |
|
||
| PCY-PO-ACC-TEMP-LN Element: Acc Templ Line | Numeric 1 |
|
||
| PCY-PO-ACC-REQ-LOC Element: Acc Req Loc | Numeric 1 |
|
||
| PCY-PO-ACC-SHIP-TO Element: Po Acc Ship To | Numeric 1 |
|
||
| PCY-PO-ACC-ITEMAST Element: Acc Itemmast | Numeric 1 |
|
||
| PCY-PO-ACC-AGMT-LN Element: Acc Agrmt Line | Numeric 1 |
|
||
| PCY-RQ-ACV-COMAGMT Element: Acv Com Agrmt | Numeric 1 |
|
||
| PCY-RQ-ACV-TEMP-LN Element: Acv Templ Line | Numeric 1 |
|
||
| PCY-RQ-ACV-HEADER Element: Acv Header | Numeric 1 |
|
||
| PCY-RQ-ACV-REQ-LOC Element: Acv Req Loc | Numeric 1 |
|
||
| PCY-RQ-ACV-AGMT-LN Element: Acv Agrmt Line | Numeric 1 |
|
||
| PCY-PO-ACV-COMAGMT Element: Acv Com Agrmt | Numeric 1 |
|
||
| PCY-PO-ACV-TEMP-LN Element: Acv Templ Line | Numeric 1 |
|
||
| PCY-PO-ACV-HEADER Element: Acv Header | Numeric 1 |
|
||
| PCY-PO-ACV-AGMT-LN Element: Acv Agrmt Line | Numeric 1 |
|
||
| PCY-RQ-ACT-COMAGMT Element: Act Com Agrmt | Numeric 1 |
|
||
| PCY-RQ-ACT-TEMP-LN Element: Act Templ Line | Numeric 1 |
|
||
| PCY-RQ-ACT-HEADER Element: Act Header | Numeric 1 |
|
||
| PCY-RQ-ACT-REQ-LOC Element: Act Req Loc | Numeric 1 |
|
||
| PCY-RQ-ACT-AGMT-LN Element: Act Agrmt Line | Numeric 1 |
|
||
| PCY-RQ-ACT-GLACCAT Element: Act Glaccat | Numeric 1 |
|
||
| PCY-PO-ACT-COMAGMT Element: Act Com Agrmt | Numeric 1 |
|
||
| PCY-PO-ACT-TEMP-LN Element: Act Templ Line | Numeric 1 |
|
||
| PCY-PO-ACT-HEADER Element: Act Header | Numeric 1 |
|
||
| PCY-PO-ACT-AGMT-LN Element: Act Agrmt Line | Numeric 1 |
|
||
| PCY-PO-ACT-GLACCAT Element: Act Glaccat | Numeric 1 |
|
||
| PCY-RQ-VEN-AGRMT Element: Ven Agrmt | Numeric 1 |
|
||
| PCY-RQ-VEN-ITEMSRC Element: Ven Itemsrc | Numeric 1 |
|
||
| PCY-RQ-VEN-HEADER Element: Ven Header | Numeric 1 |
|
||
| PCY-IC-VEN-ITEMSRC Element: Ven Itemsrc | Numeric 1 |
|
||
| PCY-IC-VEN-AGRMT Element: Ven Agrmt | Numeric 1 |
|
||
| PCY-RQ-PF-AGRMT Element: Pf Agrmt | Numeric 1 |
|
||
| PCY-RQ-PF-ITEMSRC Element: Pf Itemsrc | Numeric 1 |
|
||
| PCY-RQ-PF-HEADER Element: Pf Header | Numeric 1 |
|
||
| PCY-IC-PF-ITEMSRC Element: Pf Itemsrc | Numeric 1 |
|
||
| PCY-IC-PF-AGRMT Element: Pf Agrmt | Numeric 1 |
|
||
| PCY-LAST-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||
| PCY-RQPO-RQ-LOC Element: Rqpo Rq Loc | Numeric 1 |
|
||
| PCY-RQPO-IC-LOC Element: Rqpo Ic Loc | Numeric 1 |
|
||
| PCY-RQPO-VENDOR Element: Rqpo Vendor | Numeric 1 |
|
||
| PCY-RQPO-VENDLOC Element: Rqpo Vendloc | Numeric 1 |
|
||
| PCY-OEPO-VENDOR Element: Oepo Vendor | Numeric 1 |
|
||
| PCY-OEPO-VENDLOC Element: Oepo Vendloc | Numeric 1 |
|
||
| PCY-OEPO-IC-LOC Element: Oepo Ic Loc | Numeric 1 |
|
||
| PCY-SS-USED Element: Ss Used | Numeric 1 0 = Strategic Sourcing Not Used 1 = Strategic Sourcing Used |
|
||
| PCY-PO-RUN-STS Element: Po Run Sts | Numeric 1 0 = None 1 = PO135 Running |
|
||
| PCY-VR-CXL-UPD-SOH Element: Vr Cxl Upd Soh | Numeric 1 0 = No 1 = Yes |
|
||
| PCY-RQ-PCARD-RQH Element: Rq Pcard Rqh | Numeric 1 |
|
||
| PCY-RQ-PCARD-RQL Element: Rq Pcard Rql | Numeric 1 |
|
||
| PCY-RQ-PCARD-REQ Element: Rq Pcard Req | Numeric 1 |
|
||
| PCY-RQ-PCARD-VEN Element: Rq Pcard Ven | Numeric 1 |
|
||
| PCY-RQ-PCARD-BUY Element: Rq Pcard Buy | Numeric 1 |
|
||
| PCY-PO-PCARD-BUY Element: Po Pcard Buy | Numeric 1 |
|
||
| PCY-PO-PCARD-VEN Element: Po Pcard Ven | Numeric 1 |
|
||
| PCY-SS-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||
| PCY-PO-AUDIT-FL Element: Po Audit Fl | Numeric 1 0 = Audit After Issue Final 1 = Audit Before Issue Final |
|
||
| PCY-DEL-PO-COMMIT Element: Flag Num | Numeric 1 0 = No 1 = Yes |
|
||
| PCY-REC-BUDGET-FL Element: All Flag | Alpha 1 Y = Yes N = No |
|
||
| PCY-DEF-PRINT-FORM Element: Flag Num | Numeric 1 1 = Preprinted Form 2 = Plain Paper 3 = XML |
|
||
| PCY-DEF-ORIENT Element: All Flag | Alpha 1 P = Portrait L = Landscape |
|
||
| PCY-REOPEN-PLI-FL Element: All Flag | Alpha 1 Y = Yes N = No |
|
||
| PCY-RQ-AU-AGMT-LN Element: Au Agmt Ln | Numeric 1 |
|
||
| PCY-PO-AU-AGMT-LN Element: Au Agmt Ln | Numeric 1 |
|
||
| PCY-POB-PHONE-PREF Element: Phone Prefix | Alpha 6 |
|
||
| PCY-POB-PHONE Element: Phone | Alpha 15 |
|
||
| PCY-POB-PHONE-EXT Element: Phone Ext | Alpha 5 |
|
||
| PCY-POB-EMAIL-ADDR Element: Email Address | Alpha 60 (Lower Case) |
|
||
| PCY-PO100-RUN-STS Element: Po Run Sts | Numeric 1 0 = None 1 = PO100 Running |
|
||
| PCY-TRK-NBR-DFLT-1 Element: All Flag | Alpha 1 Y = Yes N = No |
|
||
| PCY-COST-OR-VENITM Element: Cost Or Vend | 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 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||
|---|---|---|---|---|---|---|---|---|---|
| PCYSET1 |
COMPANY |
|
|||||||
| PCYSET2 |
PROCURE-GROUP COMPANY |
|
|||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
|---|---|---|---|---|---|---|---|---|
| Iccompany | ICCOMPANY |
Required
| ||||||
| Itemgroup | ITEMGROUP |
Required
| ||||||
| Pofrtterm | POFRTTERM |
Required
| ||||||
| Procuregrp | PROCUREGRP |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Iclocation | ICLOCATION |
| |||||||||||||||||||||
| Poaocmast | POAOCMAST |
Delete Restricted
| |||||||||||||||||||||
| Podefaudit | PODEFAUDIT |
Delete Cascades
| |||||||||||||||||||||
| Podocref | PODOCREF |
| |||||||||||||||||||||
| Purchorder | PURCHORDER |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.