Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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    BL02.1    CXCP.1    IC01.1    IC12.1
IC330     MA126     MA208     MA236     MA264     MA278
MA279     MA53.1    MA53.2    MA540     MA63.1    MA69.1
MA90.1    MA95.1    MA95.2    PD01.2    PD21.1    PO04.1
PO04.2    PO04.3    PO10.1    PO10.2    PO115     PO120
PO130     PO132     PO133     PO134     PO136     PO139
PO15.1    PO15.2    PO150     PO181     PO190     PO191
PO199     PO204     PO220     PO223     PO224     PO225
PO228     PO229     PO230     PO231     PO233     PO234
PO240     PO251     PO253     PO254     PO258     PO26.1
PO268     PO274     PO275     PO276     PO277     PO278
PO280     PO285     PO295     PO522     PO529     PO53.1
PO53.2    PO53.3    PO53.4    PO53.5    PO53.8    PO53.9
PO54.1    PO54.2    PO54.3    PO54.4    PO58.1    PO58.2
PO63.1    PO64.1    PO66.1    PO67.1    PO68.1    PO700
PO94.1    POA1.1    POA10     POA2.4    POA3.1    POAO.1
POAX.1    POCP.1    POI7.1    POIE.1    POIF.1    POIG.1
POIH.1    POIM.1    MM280     MM80.1    MM80.2    RQ01.1
RQ11.1    RQ111     RQ12.1    RQ13.1    RQ13.2    RQ140
RQ300     RQ35.1    RQ40.1    RQ41.1    RQ42.1    RQ44.1
RQ44.2    RQ500     RQ810     RQCP.1    RQD0.1    RQIA.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
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     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    MA180
MA41.1    MA41.2    MA41.4    MA41.7    MA43.1    MA43.2
MA43.3    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA66.2    MA66.3    MA67.2    MA67.3
MA68.2    MA68.3    MA68.5    MA70.1    MA75.1    MA80.1
MAI1.1    PD10.1    PD10.2    PD130     PD20.1    PD20.2
PD20.3    PO01.1    PO01.4    PO100     PO101     PO122
PO131     PO135     PO20.1    PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO23.1    PO24.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
PO32.4    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    POID.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   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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.7
                                                                 MA530   MA531
                                                                 MA540   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 PD130   PD20.1
                                                                 ...

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   This field displays the description.

PCY-BASE-ND            Numeric 1                                 PO01.1
Element: Base Nd       The number of decimal positions defined
                       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          This field displays the system date
                       when this was created.

PCY-LAST-MSG-SEQ       Numeric 6                                 AP125   AP126
Element: Seq Number    This is the last assigned message         AP131   AP20.1
                       sequence number for generated buyer       AP20.2  AP20.3
                       messages.                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.7
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.2  MA67.3
                                                                 MA68.2  MA68.3
                                                                 MA68.5  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PD10.1
                                                                 PD10.2  PD130
                                                                 PD20.1  PD20.2
                                                                 ...

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       This is the purchase order code.

PCY-IC-PO-CODE         Alpha 4                                   PO01.1
Element: Po Code       This is the purchase order code.

PCY-RQ-PO-CODE         Alpha 4                                   PO01.1
Element: Po Code       This is the purchase order code.

PCY-PO-PO-CODE         Alpha 4                                   PO01.1
Element: Po Code       This is the purchase order code.

PCY-CX-PO-CODE         Alpha 4                                   PO01.1
Element: Po Code       This is the purchase order code.

PCY-VR-PO-CODE         Alpha 4                                   PO01.1
Element: Po Code       This is the purchase order 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 Yes 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
Element: Proc Lev Req  Y = Yes
                       N = No

PCY-PL-DFLT-FRMLC      Alpha 1                                   PO01.1
Element: Pl Dflt Frmlc Y = Yes
                       N = No

PCY-CONTRACT-ORD       Numeric 1                                 PO01.4
Element: Contract Ord  0
                       6

PCY-CATALOG-ORD        Numeric 1                                 PO01.4
Element: Catalog Ord   0
                       6

PCY-BLANKET-ORD        Numeric 1                                 PO01.4
Element: Blanket Ord   0
                       6

PCY-LASTCOST-ORD       Numeric 1                                 PO01.4
Element: Lastcost Ord  0
                       6

PCY-LASTPO-ORD         Numeric 1                                 PO01.4
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          Displays the company description.

PCY-POB-ADDR1          Alpha 30  (Lower Case)
Element: Addr1         This field contains the first line of
                       address information.

PCY-POB-ADDR2          Alpha 30  (Lower Case)
Element: Addr1         This field contains the first line of
                       address information.

PCY-POB-ADDR3          Alpha 30  (Lower Case)
Element: Addr1         This field contains the first line of
                       address information.

PCY-POB-ADDR4          Alpha 30  (Lower Case)
Element: Addr1         This field contains the first line of
                       address information.

PCY-POB-CITY-ADDR5     Alpha 18  (Lower Case)
Element: City          This field contains the city of the
                       address.

PCY-POB-STATE-PROV     Alpha 2
Element: State Prov    The state or province.

PCY-POB-POSTAL-CD      Alpha 10  (Lower Case)
Element: Postal Code   This field contains the postal code.

PCY-POB-COUNTRY-CD     Alpha 2
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

PCY-POB-COUNTY         Alpha 25  (Lower Case)
Element: County        The county for the company address.

PCY-POB-CONTACT        Alpha 30  (Lower Case)
Element: Addr Contact  This is the name of the main contact.

PCY-IC-NO-CHRG-ORD     Numeric 1                                 PO01.4
Element: Ic No Chrg Ord0
                       6

PCY-COST-OR-VEND       Numeric 1                                 PO01.4
Element: Cost Or Vend  0 = Cost First Then Vendor
                       1 = Vendor First Then Cost

PCY-RQ-AU-PAR-LOC      Numeric 1                                 PO01.4
Element: Au Par Loc

PCY-RQ-AU-COMAGMT      Numeric 1                                 PO01.4
Element: Au Com Agrmt

PCY-RQ-AU-DIST-CD      Numeric 1                                 PO01.4
Element: Au Dist Code

PCY-RQ-AU-TEMP-LN      Numeric 1                                 PO01.4
Element: Au Templ Line

PCY-RQ-AU-FR-LOC       Numeric 1                                 PO01.4
Element: Rq Au Fr Loc

PCY-RQ-AU-HEADER       Numeric 1                                 PO01.4
Element: Au Header

PCY-RQ-AU-REQ-LOC      Numeric 1                                 PO01.4
Element: Au Req Loc

PCY-RQ-AU-AGMTPART     Numeric 1                                 PO01.4
Element: Au Agrmt Part

PCY-PO-AU-COMAGMT      Numeric 1                                 PO01.4
Element: Au Com Agrmt

PCY-PO-AU-HEADER       Numeric 1                                 PO01.4
Element: Au Header

PCY-PO-AU-TEMP-LN      Numeric 1                                 PO01.4
Element: Au Templ Line

PCY-PO-AU-REQ-LOC      Numeric 1                                 PO01.4
Element: Au Req Loc

PCY-PO-AU-SHIP-TO      Numeric 1                                 PO01.4
Element: Po Au Ship To

PCY-PO-AU-AGMTPART     Numeric 1                                 PO01.4
Element: Au Agrmt Part

PCY-RQ-ACC-PAR-LOC     Numeric 1                                 PO01.4
Element: Acc Par Loc

PCY-RQ-ACC-COMAGMT     Numeric 1                                 PO01.4
Element: Acc Com Agrmt

PCY-RQ-ACC-DIST-CD     Numeric 1                                 PO01.4
Element: Acc Dist Code

PCY-RQ-ACC-TEMP-LN     Numeric 1                                 PO01.4
Element: Acc Templ Line

PCY-RQ-ACC-HEADER      Numeric 1                                 PO01.4
Element: Acc Header

PCY-RQ-ACC-REQ-LOC     Numeric 1                                 PO01.4
Element: Acc Req Loc

PCY-RQ-ACC-FR-LOC      Numeric 1                                 PO01.4
Element: Rq Acc Fr Loc

PCY-RQ-ACC-ITEMAST     Numeric 1                                 PO01.4
Element: Acc Itemmast

PCY-RQ-ACC-AGMT-LN     Numeric 1                                 PO01.4
Element: Acc Agrmt Line

PCY-PO-ACC-COMAGMT     Numeric 1                                 PO01.4
Element: Acc Com Agrmt

PCY-PO-ACC-HEADER      Numeric 1                                 PO01.4
Element: Acc Header

PCY-PO-ACC-TEMP-LN     Numeric 1                                 PO01.4
Element: Acc Templ Line

PCY-PO-ACC-REQ-LOC     Numeric 1                                 PO01.4
Element: Acc Req Loc

PCY-PO-ACC-SHIP-TO     Numeric 1                                 PO01.4
Element: Po Acc Ship To

PCY-PO-ACC-ITEMAST     Numeric 1                                 PO01.4
Element: Acc Itemmast

PCY-PO-ACC-AGMT-LN     Numeric 1                                 PO01.4
Element: Acc Agrmt Line

PCY-RQ-ACV-COMAGMT     Numeric 1                                 PO01.4
Element: Acv Com Agrmt

PCY-RQ-ACV-TEMP-LN     Numeric 1                                 PO01.4
Element: Acv Templ Line

PCY-RQ-ACV-HEADER      Numeric 1                                 PO01.4
Element: Acv Header

PCY-RQ-ACV-REQ-LOC     Numeric 1                                 PO01.4
Element: Acv Req Loc

PCY-RQ-ACV-AGMT-LN     Numeric 1                                 PO01.4
Element: Acv Agrmt Line

PCY-PO-ACV-COMAGMT     Numeric 1                                 PO01.4
Element: Acv Com Agrmt

PCY-PO-ACV-TEMP-LN     Numeric 1                                 PO01.4
Element: Acv Templ Line

PCY-PO-ACV-HEADER      Numeric 1                                 PO01.4
Element: Acv Header

PCY-PO-ACV-AGMT-LN     Numeric 1                                 PO01.4
Element: Acv Agrmt Line

PCY-RQ-ACT-COMAGMT     Numeric 1                                 PO01.4
Element: Act Com Agrmt

PCY-RQ-ACT-TEMP-LN     Numeric 1                                 PO01.4
Element: Act Templ Line

PCY-RQ-ACT-HEADER      Numeric 1                                 PO01.4
Element: Act Header

PCY-RQ-ACT-REQ-LOC     Numeric 1                                 PO01.4
Element: Act Req Loc

PCY-RQ-ACT-AGMT-LN     Numeric 1                                 PO01.4
Element: Act Agrmt Line

PCY-RQ-ACT-GLACCAT     Numeric 1                                 PO01.4
Element: Act Glaccat

PCY-PO-ACT-COMAGMT     Numeric 1                                 PO01.4
Element: Act Com Agrmt

PCY-PO-ACT-TEMP-LN     Numeric 1                                 PO01.4
Element: Act Templ Line

PCY-PO-ACT-HEADER      Numeric 1                                 PO01.4
Element: Act Header

PCY-PO-ACT-AGMT-LN     Numeric 1                                 PO01.4
Element: Act Agrmt Line

PCY-PO-ACT-GLACCAT     Numeric 1                                 PO01.4
Element: Act Glaccat

PCY-RQ-VEN-AGRMT       Numeric 1                                 PO01.4
Element: Ven Agrmt

PCY-RQ-VEN-ITEMSRC     Numeric 1                                 PO01.4
Element: Ven Itemsrc

PCY-RQ-VEN-HEADER      Numeric 1                                 PO01.4
Element: Ven Header

PCY-IC-VEN-ITEMSRC     Numeric 1                                 PO01.4
Element: Ven Itemsrc

PCY-IC-VEN-AGRMT       Numeric 1                                 PO01.4
Element: Ven Agrmt

PCY-RQ-PF-AGRMT        Numeric 1                                 PO01.4
Element: Pf Agrmt

PCY-RQ-PF-ITEMSRC      Numeric 1                                 PO01.4
Element: Pf Itemsrc

PCY-RQ-PF-HEADER       Numeric 1                                 PO01.4
Element: Pf Header

PCY-IC-PF-ITEMSRC      Numeric 1                                 PO01.4
Element: Pf Itemsrc

PCY-IC-PF-AGRMT        Numeric 1                                 PO01.4
Element: Pf Agrmt

PCY-LAST-SEQ-NBR       Numeric 4                                 PO01.4
Element: Seq Nbr       An automatically assigned sequence
                       number.

PCY-RQPO-RQ-LOC        Numeric 1                                 PO01.4
Element: Rqpo Rq Loc

PCY-RQPO-IC-LOC        Numeric 1                                 PO01.4
Element: Rqpo Ic Loc

PCY-RQPO-VENDOR        Numeric 1                                 PO01.4
Element: Rqpo Vendor

PCY-RQPO-VENDLOC       Numeric 1                                 PO01.4
Element: Rqpo Vendloc

PCY-OEPO-VENDOR        Numeric 1                                 PO01.4
Element: Oepo Vendor

PCY-OEPO-VENDLOC       Numeric 1                                 PO01.4
Element: Oepo Vendloc

PCY-OEPO-IC-LOC        Numeric 1                                 PO01.4
Element: Oepo Ic Loc

PCY-SS-USED            Numeric 1                                 PO01.1
Element: Ss Used       0 = Strategic Sourcing Not Used
                       1 = Strategic Sourcing Used

PCY-PO-RUN-STS         Numeric 1                                 PO135
Element: Po Run Sts    0 = None
                       1 = PO135 Running

PCY-VR-CXL-UPD-SOH     Numeric 1                                 PO01.1
Element: Vr Cxl Upd Soh0 = No
                       1 = Yes

PCY-RQ-PCARD-RQH       Numeric 1
Element: Rq Pcard Rqh

PCY-RQ-PCARD-RQL       Numeric 1
Element: Rq Pcard Rql

PCY-RQ-PCARD-REQ       Numeric 1
Element: Rq Pcard Req

PCY-RQ-PCARD-VEN       Numeric 1
Element: Rq Pcard Ven

PCY-RQ-PCARD-BUY       Numeric 1
Element: Rq Pcard Buy

PCY-PO-PCARD-BUY       Numeric 1
Element: Po Pcard Buy

PCY-PO-PCARD-VEN       Numeric 1
Element: Po Pcard Ven

PCY-SS-PO-CODE         Alpha 4                                   PO01.1
Element: Po Code       This is the purchase order code.

PCY-PO-AUDIT-FL        Numeric 1                                 PO01.1
Element: Po Audit Fl   0 = Audit After Issue Final
                       1 = Audit Before Issue Final

                         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
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP510
                                                                 API1.1  API2.1
                                                                 AR10.1  BL02.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

PCYSET2   PROCURE-GROUP KeyChange                                AP125   AP126
          COMPANY                                                AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP220   AP23.1
                                                                 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
                                                                 ...

                         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

Podefaudit     PODEFAUDIT   Delete Cascades

                            PCY-COMPANY          -> PDT-COMPANY
                                                    PDT-AUDIT-TYPE
                                                    PDT-UPDATE-DATE
                                                    PDT-UPDATE-TIME
                                                    PDT-FLD-NBR
                                                    PDT-SEQ-NBR
                                                    PDT-AUDIT-ACTION

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