|
|
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
|
