Lawson Insight Technical Documentation |
|
POCOMPANY
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
API2.1 AR10.1 CXCP.1 DR100 IC01.1 IC12.1
IC140 IC141 IC142 IC21.1 IC21.2 IC282
IC330 IC500 IC531 IC598 IC81.2 IC83.1
PC20.1 MA126 MA208 MA236 MA264 MA278
MA53.1 MA53.2 MA540 MA63.1 MA68.1 MA95.1
MA95.2 PHI3.1 PO04.3 PO04.1 PO10.1 PO115
PO120 PO130 PO132 PO133 PO134 PO136
PO139 PO15.1 PO15.2 PO150 PO181 PO190
PO199 PO204 PO220 PO223 PO224 PO225
PO228 PO229 PO230 PO231 PO233 PO251
PO254 PO258 PO26.1 PO274 PO275 PO276
PO277 PO280 PO285 PO295 PO522 PO529
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 POIE.1 POIF.1 POIG.1
POIH.1 POIM.1 MM280 MM80.1 MM80.2 RQ01.1
RQ11.1 RQ12.1 RQ13.1 RQ140 RQ240 RQ300
RQ35.1 RQ40.1 RQ41.1 RQ42.1 RQ44.1 RQ44.2
RQ500 RQ780 RQ810 RQCP.1 RQD0.1 RQIB.1
RQIC.1 RQID.1 RQIF.1 RQIG.1 RQII.1 RQIJ.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
WO132 WO140 AP220 AP520 MA08.1 PO00.1
PO16.1 PO16.2 PO216 PO227 PO550 POI4.1
POIT.1
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 IC28.1 MA180
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
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 PO01.1 PO100 PO101 PO122
PO131 PO135 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POI3.1 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3
RQIE.1 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 AP20.1
group of companies that share a common AP20.2 AP20.3
procurement effort. They buy items and AP20.4 AP20.5
services together. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
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 PO01.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
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
PCY-BASE-ND Numeric 1 PO01.1
Account Currency
Code
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
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
PCY-LAST-MSG-SEQ Numeric 6 AP125 AP126
Record Sequence This is the last assigned message AP131 AP20.1
Number sequence number for generated buyer AP20.2 AP20.3
messages. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
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
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
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 and item add-on cost no
Closed Days activity 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
5
PCY-CATALOG-ORD Numeric 1 PO01.1
Element: Catalog Ord 0
5
PCY-BLANKET-ORD Numeric 1 PO01.1
Element: Blanket Ord 0
5
PCY-LASTCOST-ORD Numeric 1 PO01.1
Element: Lastcost Ord 0
5
PCY-LASTPO-ORD Numeric 1 PO01.1
Element: Lastpo Ord 0
5
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
POCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCYSET1 COMPANY AP00.4 AP05.3
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 AP30.4
AP510 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 AP30.4
AP520 API1.1
API2.1 IC28.1
MA08.1 MA180
MA208 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
...
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
|