|
|
POCOMPANY FILE
Company System Master
A file of valid Purchase Order companies and corresponding parameters.
REFERENCED BY
AP00.4 AP05.3 AP05.6 AP06.1 AP205 AP510
AP91.5 AP91.6 API1.1 API2.1 AR10.1 BL02.1
CXCP.1 DR100 IC01.1 IC12.1 IC140 IC141
IC142 IC21.1 IC21.2 IC282 IC330 IC500
IC531 IC598 IC83.1 MA126 MA208 MA236
MA264 MA278 MA53.1 MA53.2 MA540 MA63.1
MA68.1 MA95.1 MA95.2 PO04.3 PO04.1 PO10.1
PO115 PO120 PO130 PO132 PO133 PO134
PO136 PO15.1 PO15.2 PO150 PO181 PO190
PO199 PO204 PO220 PO223 PO224 PO225
PO228 PO229 PO230 PO231 PO233 PO240
PO25.1 PO25.3 PO25.5 PO25.6 PO25.7 PO251
PO254 PO258 PO26.1 PO27.1 PO27.2 PO274
PO275 PO276 PO277 PO280 PO285 PO295
PO36.1 PO36.2 PO522 PO529 PO53.1 PO53.2
PO53.3 PO53.4 PO53.5 PO53.8 PO536 PO54.1
PO54.2 PO54.3 PO54.4 PO58.1 PO58.2 PO63.1
PO64.1 PO66.1 PO67.1 PO700 PO94.1 POA1.1
POA10 POA2.4 POA3.1 POAO.1 POAX.1 POCP.1
POI7.1 POID.1 POIF.1 POIG.1 POIH.1 POIM.1
RQ01.1 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ140
RQ240 RQ300 RQ35.1 RQ40.1 RQ41.1 RQ42.1
RQ44.1 RQ44.2 RQ500 RQ810 RQCP.1 RQIB.1
RQIC.1 RQID.1 RQIF.1 RQIG.1 RQII.1 RQIJ.1
WH02.1 WH130 WH132 WH190 WH222 WH25.1
WH25.2 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830 WO132
WO140 AP220 AP520 BL09.1 BL12.1 BL209
MA08.1 PO00.1 PO16.1 PO16.2 PO216 PO227
PO550 POI4.1 POIT.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 IC28.1 MA180 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE81.1 OE810 OE830
OE90.1 OE90.2 PO01.1 PO100 PO101 PO122
PO131 PO135 PO20.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 POI3.1 POIE.1 POII.1
POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCY-COMPANY Numeric 4 PO01.1
Element: Company The company number.
PCY-NAME Alpha 30 (Lower Case) PO01.1
Element: Name Displays the company description.
PCY-PROCURE-GROUP Alpha 4 AP125 AP126
Element: Procure Group This field contains the identifier for a AP131 AP25.1
group of companies that share a common AP25.2 AP26.1
procurement effort. They buy items and AP27.1 AP30.4
services together. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
PCY-BASE-CURR-CD Alpha 5 PO01.1
Element: Currency Code The general ledger-defined currency
code for this purchase order company.
PCY-BASE-CUC-DESC Alpha 30 (Lower Case) PO01.1
Element: Description 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
Element: 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
Element: Revisions InclSpecifies 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
Element: 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
Element: All Flag 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 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
Element: Reason Code ReThis 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
Element: Date The received not invoiced general
ledger posting date from the last closed
period.
PCY-PRNI-POST-DAT Numeric 8 (yyyymmdd) PO135
Element: Date The received not invoiced General
Ledger posting date from the closing
period prior to the last closed period.
PCY-LAST-MSG-SEQ Numeric 6 AP125 AP126
Record Sequence This is the last assigned message AP131 AP25.1
Number sequence number for generated buyer AP25.2 AP26.1
messages. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PCY-REOPEN-FL Alpha 1 PO01.1
Element: Reopen HistoryThis 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
Element: Po Code
PCY-IC-PO-CODE Alpha 4 PO01.1
Element: Po Code
PCY-RQ-PO-CODE Alpha 4 PO01.1
Element: Po Code
PCY-PO-PO-CODE Alpha 4 PO01.1
Element: Po Code
PCY-CX-PO-CODE Alpha 4 PO01.1
Element: Po Code
PCY-VR-PO-CODE Alpha 4 PO01.1
Element: Po Code
PCY-MAN-CODE-ALWD Alpha 1 PO01.1
Element: All Flag A = All Documents
P = Purchase Orders Only
N = No
PCY-CODE-DFLT-METH Numeric 1 PO01.1
Element: Code Dflt Meth1 = 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
Element: 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
Element: 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
Element: Pl Dflt Frmlc Y = Yes
N = No
PCY-CONTRACT-ORD Numeric 1 PO01.1
Element: Contract Ord 0
6
PCY-CATALOG-ORD Numeric 1 PO01.1
Element: Catalog Ord 0
6
PCY-BLANKET-ORD Numeric 1 PO01.1
Element: Blanket Ord 0
6
PCY-LASTCOST-ORD Numeric 1 PO01.1
Element: Lastcost Ord 0
6
PCY-LASTPO-ORD Numeric 1 PO01.1
Element: Lastpo Ord 0
6
PCY-SRC-OVR-RECVD Alpha 1 PO01.1
Element: Src Ovr Recvd OE, Receive Excess Msg
N = No
Y = Yes
PCY-SUB-MESSAGE Alpha 1 PO01.1
Element: Sub Message Substitute Message
N = No
Y = Yes
PCY-PKG-TRK-LVL Alpha 1 PO01.1
Element: Pkg Trk Lvl 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 Alpha 1 PO01.1
Element: Lbl Dflt 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 Numeric 1 PO01.1
Element: Prt Vend CntctThis field indicates if vendor contact
information will print on the purchase
order header.
0 = No
1 = Yes
PCY-POB-NAME Alpha 30 (Lower Case)
Element: Name
PCY-POB-ADDR1 Alpha 30 (Lower Case)
Element: Address 1
PCY-POB-ADDR2 Alpha 30 (Lower Case)
Element: Address 1
PCY-POB-ADDR3 Alpha 30 (Lower Case)
Element: Address 1
PCY-POB-ADDR4 Alpha 30 (Lower Case)
Element: Address 1
PCY-POB-CITY-ADDR5 Alpha 18 (Lower Case)
Element: City
PCY-POB-STATE-PROV Alpha 2
Element: State or Province
PCY-POB-POSTAL-CD Alpha 10 (Lower Case)
Element: Postal Code
PCY-POB-COUNTRY-CD Alpha 2
Element: Country Code
PCY-POB-COUNTY Alpha 25 (Lower Case)
Element: County
PCY-POB-CONTACT Alpha 30 (Lower Case)
Element: Contact
PCY-IC-NO-CHRG-ORD Numeric 1
Element: Ic No Chrg Ord0
6
POCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCYSET1 COMPANY AP00.4 AP05.3
AP05.6 AP06.1
AP125 AP126
AP131 AP205
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP510
AP91.5 AP91.6
API1.1 API2.1
AR10.1 BL02.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
PCYSET2 PROCURE-GROUP KeyChange AP125 AP126
COMPANY AP131 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
...
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
|
