POCOMPANY FILE
Company System Master
A file of valid Purchase Order companies and corresponding parameters.
REFERENCED BY
AP00.4 AP05.6 AP06.1 AP205 AP510 AP91.5
AP91.6 API1.1 API2.1 BL02.1 CXCP.1 DR100
IC01.1 IC12.1 IC140 IC141 IC142 IC330
IC531 IC83.1 MA126 MA208 MA278 MA53.1
MA53.2 MA63.1 MA68.1 MA95.1 MA95.2 PHI3.1
PO04.3 PO04.1 PO10.1 PO120 PO130 PO132
PO133 PO134 PO136 PO15.1 PO15.2 PO181
PO190 PO199 PO204 PO220 PO223 PO224
PO225 PO228 PO230 PO231 PO233 PO24.1
PO251 PO26.1 PO274 PO275 PO276 PO277
PO280 PO295 PO522 PO529 PO60.1 PO61.1
PO62.1 PO63.1 PO64.1 PO66.1 PO67.1 PO68.1
PO85.1 PO94.1 POA2.4 POA3.1 POAO.1 POAX.1
POCP.1 POI7.1 POIF.1 POIH.1 RQ01.1 RQ11.1
RQ12.1 RQ13.1 RQ140 RQ300 RQ40.1 RQ41.1
RQ42.1 RQ44.1 RQ44.2 RQ780 RQ810 RQCP.1
WH02.1 WH130 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 PO00.1 PO16.1 PO16.2 PO216
PO227 PO550
UPDATED BY
PO01.1 PO135 POIJ.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCY-COMPANY Numeric 4 PO01.1
Company The company number.
PCY-NAME Alpha 30 (Lower Case) PO01.1
Name Displays the company description.
PCY-PROCURE-GROUP Alpha 4 PO01.1 POIJ.1
Procure Group This field contains the identifier for a RQ44.1
group of companies that share a common
procurement effort. They buy items and
services together.
PCY-BASE-CURR-CD Alpha 5 PO01.1
Base Currency Code The general ledger-defined currency
code for this purchase order company.
PCY-BASE-CUC-DESC Alpha 30 (Lower Case) PO01.1
Base Cuc Desc The company base currency code
description.
PCY-BASE-ND Numeric 1 PO01.1
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
PCY-FREIGHT-TERMS Alpha 1 PO01.1
Default Freight Default terms code used to describe the
Terms terms of the freight on a purchase
order.
PCY-UOM-REQ-FL Alpha 1 PO01.1
Require UOM 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 Alpha 1 PO01.1
Revisions Incl 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 Alpha 1 Occurs 10 Times PO01.1
Purchase Order Indicates which inventory control
Comment Type 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 Alpha 1 Occurs 10 Times PO01.1
Transmitted POs Indicates which inventory control
Comment Type 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 Alpha 1 Occurs 10 Times PO01.1
Receiving Document Indicates which inventory control
Comt Type 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 Alpha 1 Occurs 10 Times PO01.1
Unreleased POs Indicates which inventory control
Comment Type 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 Alpha 1 Occurs 10 Times PO01.1
Open POs Comment Indicate which inventory control
Type 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 Alpha 1 Occurs 10 Times PO01.1
Unreleased Indicates which inventory control
Receivings Cmt Type 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 Alpha 1 PO01.1
Print Quantity on This flag defines if the open order
Document (unreceived) quantity for a purchase
order line item prints on the receiver.
N = No
Y = Yes
PCY-DISP-QTY-FLAG Alpha 1 PO01.1
Display Quantity on This flag defines if the open order
Screen (unreceived) quantity for a purchase
order line item prints on the receiving
forms.
N = No
Y = Yes
PCY-USE-ALL-FLAG Alpha 1 PO01.1
Receive All This flag defines if the Receive All
flag can be used in the online receiving
process.
N = No
Y = Yes
PCY-OK-OSHIP-FLAG Alpha 1 PO01.1
Accept All Defines if the company policy is to
Shipments Flag 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 Percent 5.3 (Percent) PO01.1
Overshipment Quantity overshipment tolerance
Percentage percentage.
PCY-USHIP-TOL-PCT Percent 6.3 (Percent) PO01.1
Undershipment Cncl This is the quantity undership
Percentage 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 Alpha 1 PO01.1
Reason Code Required 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 Numeric 8 (yyyymmdd) PO135
RNI Posting Date The received not invoiced general
ledger posting date from the last closed
period.
PCY-PRNI-POST-DAT Numeric 8 (yyyymmdd) PO135
Prni Post Dat The received not invoiced General
Ledger posting date from the closing
period prior to the last closed period.
PCY-LAST-MSG-SEQ Numeric 6 POIJ.1
Last Message This is the last assigned message
Sequence Number sequence number for generated buyer
messages.
PCY-REOPEN-FL Alpha 1 PO01.1
Reopen History PO This flag indicates whether or not the
company allows a closed purchase order
to be reopened.
N = No
Y = Yes
PCY-AOC-ACT-DAYS Numeric 3 PO01.1
Miscellaneous AOC Miscellaneous add-on cost no activity
Closed Days close days.
PCY-OE-PO-CODE Alpha 4 PO01.1
Oe Po Code
PCY-IC-PO-CODE Alpha 4 PO01.1
Ic Po Code
PCY-RQ-PO-CODE Alpha 4 PO01.1
Rq Po Code
PCY-PO-PO-CODE Alpha 4 PO01.1
Po Po Code
PCY-CX-PO-CODE Alpha 4 PO01.1
Cx Po Code
PCY-VR-PO-CODE Alpha 4 PO01.1
Vr Po Code
PCY-MAN-CODE-ALWD Alpha 1 PO01.1
Man Code Alwd A = All Documents
P = Purchase Orders Only
N = No
PCY-CODE-DFLT-METH Numeric 1 PO01.1
Code Dflt Meth 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 Alpha 1 PO01.1
Req Loc On Po This element specifies whether the
requesting location, deliver to, and
quantity should appear on PO lines for
paper, fax, and email Purchase Orders.
If "Y" 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 Alpha 1 PO01.1
Prt Match Dtl Y = Yes
N = No
PCY-PROC-LEV-REQ Alpha 1 PO01.1
Process Levels Y = Yes
Required N = No
PCY-PL-DFLT-FRMLC Alpha 1 PO01.1
Pl Dflt Frmlc Y = Yes
N = No
PCY-OVER-NC-FL Alpha 1
Over Nc Fl
PCY-CONTRACT-ORD Numeric 1 PO01.1
Contract Ord 0
5
PCY-PO-CON-OVER-FL Alpha 1
Po Con Over Fl Y = Yes
N = No
PCY-RQ-CON-OVER-FL Alpha 1
Rq Con Over Fl Y = Yes
N = No
PCY-CATALOG-ORD Numeric 1 PO01.1
Catalog Ord 0
5
PCY-PO-CAT-OVER-FL Alpha 1
Po Cat Over Fl Y = Yes
N = No
PCY-RQ-CAT-OVER-FL Alpha 1
Rq Cat Over Fl Y = Yes
N = No
PCY-BLANKET-ORD Numeric 1 PO01.1
Blanket Ord 0
5
PCY-RQ-BLK-OVER-FL Alpha 1
Rq Blk Over Fl Y = Yes
N = No
PCY-PO-BLK-OVER-FL Alpha 1
Po Blk Over Fl Y = Yes
N = No
PCY-LASTCOST-ORD Numeric 1 PO01.1
Lastcost Ord 0
5
PCY-PO-LC-OVER-FL Alpha 1
Po Lc Over Fl Y = Yes
N = No
PCY-RQ-LC-OVER-FL Alpha 1
Rq Lc Over Fl Y = Yes
N = No
PCY-LASTPO-ORD Numeric 1 PO01.1
Lastpo Ord 0
5
PCY-PO-LP-OVER-FL Alpha 1
Po Lp Over Fl Y = Yes
N = No
PCY-RQ-LP-OVER-FL Alpha 1
Rq Lp Over Fl Y = Yes
N = No
PCY-SRC-OVR-RECVD Alpha 1 PO01.1
Src Ovr Recvd OE, Receive Excess Msg
N = No
Y = Yes
PCY-SUB-MESSAGE Alpha 1 PO01.1
Sub Message Substitute Message
N = No
Y = Yes
POCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCYSET1 COMPANY AP00.4 AP05.6
AP06.1 AP205
AP510 AP91.5
AP91.6 API1.1
API2.1 BL02.1
CXCP.1 DR100
IC01.1 IC12.1
IC140 IC141
IC142 IC330
IC531 IC83.1
MA126 MA208
MA278 MA53.1
MA53.2 MA63.1
MA68.1 MA95.1
MA95.2 PHI3.1
...
PCYSET2 PROCURE-GROUP KeyChange PO00.1 PO04.1
COMPANY PO10.1 PO15.1
PO15.2 PO16.1
PO16.2 PO181
PO216 PO227
PO228 PO550
POA2.4 POA3.1
POAO.1
POCOMPANY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
POCOMPANY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iclocation ICLOCATION
PCY-COMPANY -> ICL-COMPANY
ICL-LOCATION
Poaocmast POAOCMAST Delete Restricted
PCY-COMPANY -> PAM-COMPANY
PAM-AOC-CODE
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
|
