Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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