 |
Lawson Insight Technical Documentation |
|
POCOMPANY FILE
Company System Master
A file of valid Purchase Order companies and corresponding parameters.
REFERENCED BY
AP00.4 AP05.6 AP06.1 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP205 AP23.1 AP510
AP91.5 AP91.6 API1.1 API2.1 AR10.1 CXCP.1
DR100 IC01.1 IC12.1 IC140 IC141 IC142
IC330 IC531 IC598 IC83.1 MA126 MA208
MA278 MA41.1 MA41.2 MA41.4 MA53.1 MA53.2
MA540 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 PO150
PO181 PO190 PO199 PO204 PO220 PO223
PO224 PO225 PO228 PO230 PO231 PO233
PO24.1 PO25.2 PO25.4 PO25.6 PO25.7 PO25.8
PO25.1 PO251 PO254 PO26.1 PO27.1 PO27.2
PO27.3 PO27.4 PO274 PO275 PO276 PO277
PO280 PO295 PO522 PO529 PO54.1 PO54.2
PO54.3 PO54.4 PO64.1 PO66.1 PO67.1 PO68.1
PO700 PO85.1 PO94.1 POA1.1 POA10 POA2.4
POA3.1 POAO.1 POAX.1 POCP.1 POI7.1 POIF.1
POIG.1 POIH.1 POIM.1 RQ01.1 RQ11.1 RQ12.1
RQ13.1 RQ140 RQ300 RQ35.1 RQ40.1 RQ41.1
RQ42.1 RQ44.1 RQ44.2 RQ500 RQ780 RQ810
RQCP.1 RQIB.1 RQIF.1 SEA4.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 AP220 AP520 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 IC28.1 MA180 MA43.9 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.3 MA67.1
MA67.2 MA70.1 MAI1.1 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
Company The company number.
PCY-NAME Alpha 30 (Lower Case) PO01.1
Name Displays the company description.
PCY-PROCURE-GROUP Alpha 4 AP125 AP126
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 IC28.1
services together. MA180 MA43.9
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO01.1 PO100
PO101 PO122
PO131 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
RQ44.1 WH20.2
...
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 AP125 AP126
Last Message This is the last assigned message AP131 AP25.1
Sequence Number sequence number for generated buyer AP25.2 AP26.1
messages. AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 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
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-CONTRACT-ORD Numeric 1 PO01.1
Contract Ord 0
5
PCY-CATALOG-ORD Numeric 1 PO01.1
Catalog Ord 0
5
PCY-BLANKET-ORD Numeric 1 PO01.1
Blanket Ord 0
5
PCY-LASTCOST-ORD Numeric 1 PO01.1
Lastcost Ord 0
5
PCY-LASTPO-ORD Numeric 1 PO01.1
Lastpo Ord 0
5
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
PCY-PKG-TRK-LVL Alpha 1 PO01.1
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
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
POCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCYSET1 COMPANY AP00.4 AP05.6
AP06.1 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP205 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP510 AP91.5
AP91.6 API1.1
API2.1 AR10.1
CXCP.1 DR100
IC01.1 IC12.1
IC140 IC141
...
PCYSET2 PROCURE-GROUP KeyChange AP125 AP126
COMPANY AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
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
|