|
|
POQUOTES FILE
PO Quotes
This optional file contains purchasing information for an item at a specific
inventory Location for a vendor and/or for a vendor and purchase from
location.
REFERENCED BY
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 PO214 PO216 PO22.2 PO22.3
PO31.1 PO72.2 RQ10.1 RQ10.3 RQ11.1 RQ20.1
RQ20.2 RQ20.4 RQ35.1 RQ500 SEA3.1 WH20.2
WH20.7 PO13.1
UPDATED BY
PO115 PO14.1 PO15.1 PO150
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POQ-COMPANY Numeric 4 PO14.1 PO150
Company The company number.
POQ-LOCATION Alpha 5 PO14.1 PO150
Location Code This field contains a valid stock
location within the company inventory.
POQ-ITEM Alpha 32 PO14.1 PO150
Item Number This field contains the item
identifier.
POQ-VENDOR Alpha 9 PO14.1 PO150
Vendor ID The vendor's identification code.
POQ-PURCH-FR-LOC Alpha 4 PO14.1 PO150
Purchase From The vendor's purchase from location.
Location Code
POQ-CURRENCY-CODE Alpha 5 PO14.1 PO150
Currency Code The base currency defined for the
company in the General Ledger system.
POQ-ORDER-MULT Numeric 4
Order Multiple Designate quantity for the order
multiple. Indicates that the reorder
quantity should be a multiple of this
quantity.
POQ-CUR-QT-COST Signed 13.5 PO14.1 PO15.1
Current Quote Cost Current, item single unit quote cost. PO150
POQ-CUR-QT-DATE Numeric 8 (yyyymmdd) PO14.1 PO15.1
Current Quote Current, item quote cost effective date. PO150
Effective Date
POQ-CUR-BRK-COST Signed 13.5 Occurs 5 Times PO14.1
Current Qty Break Current item quantity break, unit quote
Cost cost for this quantity.
POQ-CUR-BRK-QTY Signed 9.0 Occurs 5 Times PO14.1
Current Qty Break Current item quantity break, quantity
Quantity for this unit cost quote.
POQ-NEW-QT-COST Signed 13.5 PO14.1 PO15.1
New Quote Cost New, item single unit quote cost. PO150
POQ-NEW-QT-DATE Numeric 8 (yyyymmdd) PO14.1 PO15.1
New Quote Effective New, item quote cost effective date. PO150
Date
POQ-NEW-BRK-COST Signed 13.5 Occurs 5 Times PO14.1
New Qty Break Cost New item quantity break, unit quote
cost for this quantity.
POQ-NEW-BRK-QTY Signed 9.0 Occurs 5 Times PO14.1
New Qty Break New, item quote quantity break quantity
Quantity for this unit cost quote.
POQ-CAT-UPD-FL Alpha 1 PO115 PO14.1
Catalog Update Flag The catalog update flag indicates that PO15.1 PO150
this quote cost has been updated since
the last processing of PO15.1 (Catalog
Price Update).
N = No
Y = Yes
POQ-QTY-BRK-TEST Derived
Qty Brk Test
POQ-HAS-QTY-BRK-FL Derived
Has Qty Breaks Flag
POQUOTES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POQSET1 COMPANY BL92.1 CX05.1
LOCATION DR100 IC140
ITEM IC141 IC142
VENDOR IC522 IC523
PURCH-FR-LOC 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
...
POQSET2 COMPANY PO115
LOCATION
VENDOR
PURCH-FR-LOC
ITEM
POQSET3 COMPANY PO13.1 PO214
VENDOR
ITEM
PURCH-FR-LOC
LOCATION
POQSET5 COMPANY
ITEM
VENDOR
LOCATION
PURCH-FR-LOC
POQUOTES FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
POQ-COMPANY -> CPY-COMPANY (CPYSET1)
Apvendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
POQ-VENDOR -> VEN-VENDOR
Apvendorloc APVENLOC Required
VEN-VENDOR-GROUP -> VLO-VENDOR-GROUP
POQ-VENDOR -> VLO-VENDOR
POQ-PURCH-FR-LOC -> VLO-LOCATION-CODE
Iccompany ICCOMPANY Required
POQ-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
POQ-COMPANY -> ICL-COMPANY
POQ-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Required
POQ-COMPANY -> ITL-COMPANY
POQ-LOCATION -> ITL-LOCATION
POQ-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
POQ-ITEM -> ITE-ITEM
Pocompany POCOMPANY Required
POQ-COMPANY -> PCY-COMPANY
Poitemven POITEMVEN Required
POQ-COMPANY -> PIV-COMPANY
POQ-ITEM -> PIV-ITEM
POQ-VENDOR -> PIV-VENDOR
|