|
|
POLOCCON FILE
Purchasing Location Override
This file ties requesting locations to contracts, and can be used to define
which contracts a requesting location participates in. For example, when an
item is requested for a particular requesting location, contracts in this file
are interrogated to see if the item is on any contract for the location.
REFERENCED BY
PO217 BL92.1 CX05.1 DR100 IC140 IC141
IC142 IC522 IC523 IC524 IC525 IC526
IC83.1 PC120 PC20.1 PC540 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113
OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3
OE15.4 OE15.5 OE15.7 OE510 OE810 OE920
PO100 PO20.1 PO21.1 PO216 PO22.2 PO22.3
PO31.1 RQ10.1 RQ10.3 RQ11.1 RQ20.1 RQ20.2
RQ20.4 RQ35.1 RQ500 SEA3.1 WH20.2 WH20.7
UPDATED BY
PO117 PO17.1 MA300 PO25.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLO-COMPANY Numeric 4 PO117 PO17.1
Company The company number.
PLO-REQ-LOCATION Alpha 5 PO117 PO17.1
To Location The location requisitioning items. This
location can be an inventory or nonstock
location.
PLO-ORDER-NAME Alpha 10 PO117 PO17.1
Standard Order Name The user-defined standard order name.
PLO-EFFECTIVE-DATE Numeric 8 (yyyymmdd) PO117 PO17.1
Effective Date The date a vendor's prices will be in
effect.
PLO-TERMINATE-DATE Numeric 8 (yyyymmdd) PO117 PO17.1
Terminate Date This field indicates the date the use
of a contract type of standard order for
this location expires.
PLO-PRIORITY Numeric 1 PO117 PO17.1
Priority Number Indicates order of precedence for
contracts to determine costing defaults
for items.
1
2
3
4
5
6
7
8
9
POLOCCON FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLOSET1 COMPANY PO117 PO17.1
REQ-LOCATION
ORDER-NAME
PLOSET2 COMPANY MA300 PO117
ORDER-NAME PO217 PO25.1
REQ-LOCATION
PLOSET3 COMPANY KeyChange BL92.1 CX05.1
REQ-LOCATION DR100 IC140
PRIORITY IC141 IC142
ORDER-NAME IC522 IC523
IC524 IC525
IC526 IC83.1
PC120 PC20.1
PC540 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
...
PLOSET4 COMPANY KeyChange PO25.1
ORDER-NAME
EFFECTIVE-DATE
REQ-LOCATION
PLOSET5 COMPANY KeyChange PO25.1
ORDER-NAME
TERMINATE-DATE*
REQ-LOCATION
POLOCCON FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
PLO-COMPANY -> ICC-COMPANY
Rqloc RQLOC Required
PLO-COMPANY -> RQL-COMPANY
PLO-REQ-LOCATION -> RQL-REQ-LOCATION
Stpurchord STPURCHORD Required
PLO-COMPANY -> SPO-COMPANY
PLO-ORDER-NAME -> SPO-ORDER-NAME
|