POBIDITEM FILE Bid Item REFERENCED BY PO216 UPDATED BY PO150 PO16.1 PO16.2 PO550 PO560 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY PBT-COMPANY Numeric 4 PO16.1 PO16.2 Company The company number. PO550 PO560 PBT-BID Alpha 10 PO16.1 PO16.2 Bid Name A user assigned name for a group of PO550 PO560 items that have been sent to vendors for price quotes, or catalog pricing that has been received from a vendor. PBT-ITEM Alpha 32 PO16.1 PO16.2 Item Number This field contains the item PO550 PO560 identifier. PBT-VENDOR Alpha 9 PO16.1 PO16.2 Vendor ID The vendor's identification code. PO550 PO560 PBT-PURCH-FR-LOC Alpha 4 PO16.1 PO16.2 Purchase From The vendor's purchase from location. PO550 PO560 Location Code PBT-VEN-ITEM Alpha 32 PO16.1 PO16.2 Vendor Item The vendor's item identifier. PO550 PO560 PBT-DESCRIPTION Alpha 30 (Lower Case) PO16.1 PO550 Description This field contains the description. PO560 PBT-MANUF-CODE Alpha 4 PO16.1 PO16.2 Manufacturer's Code This field contains a user defined code PO550 PO560 that indicates the manufacturer of an item. PBT-MANUF-DIVISION Alpha 4 PO16.1 PO16.2 Manufacturer's This is a user defined code that PO550 PO560 Division indicates which division of a manufacturer is tied to an item. PBT-MANUF-NBR Alpha 15 PO16.1 PO16.2 Manufacturer's Item This is the identifier that the PO550 PO560 Number manufacturer has assigned to an item. PBT-UNIT-PRICE Signed 13.5 PO16.1 PO16.2 Unit Price This field contains the unit price. PO550 PO560 PBT-BUY-UOM Alpha 4 PO16.1 PO16.2 Buying Unit of Buying unit of measure. PO550 PO560 Measure PBT-VPRI-UOM Alpha 4 PO16.1 PO16.2 Vendor Price Unit This is the vendor pricing unit of PO550 PO560 of Measure measure. PBT-USAGE Numeric 8 PO16.1 PO16.2 Purchase Quantity The total purchase quantity within the PO550 PO560 user defined time period. For manually entered bid items the time period will always be one year prior to entered date. PBT-EXPORT-FL Alpha 1 PO150 PO16.1 Load Flag Flag to control whether or not an item PO16.2 PO550 will be loaded to contracts or quotes. PO560 Y = Yes N = No POBIDITEM FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN PBTSET1 COMPANY PO150 PO16.1 BID PO216 PO550 VENDOR PURCH-FR-LOC ITEM VEN-ITEM PBTSET2 COMPANY Subset PO16.2 PO560 BID Where ITEM != Spaces VENDOR PURCH-FR-LOC MANUF-CODE MANUF-DIVISION MANUF-NBR ITEM PBTSET3 VENDOR This is just a test PURCH-FR-LOC BID VEN-ITEM ITEM COMPANY POBIDITEM FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Apcompany APCOMPANY Required PBT-COMPANY -> CPY-COMPANY (CPYSET1) Apvenloc APVENLOC Required When PBT-PURCH-FR-LOC != Spaces CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP PBT-VENDOR -> VLO-VENDOR PBT-PURCH-FR-LOC -> VLO-LOCATION-CODE Apvenmast APVENMAST Required CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP PBT-VENDOR -> VEN-VENDOR Iccompany ICCOMPANY Required PBT-COMPANY -> ICC-COMPANY Icmanufcode ICMANFCODE Required When PBT-MANUF-CODE != Spaces ICC-ITEM-GROUP -> IMC-ITEM-GROUP PBT-MANUF-CODE -> IMC-MANUF-CODE PBT-MANUF-DIVISION -> IMC-MANUF-DIVISION Itemmast ITEMMAST Required ICC-ITEM-GROUP -> ITE-ITEM-GROUP PBT-ITEM -> ITE-ITEM Pobid POBID Required PBT-COMPANY -> PBD-COMPANY PBT-BID -> PBD-BID Pobid1 POBID Not Required PBT-COMPANY -> PBD-COMPANY PBT-BID -> PBD-BID PBT-VENDOR -> PBD-VENDOR PBT-PURCH-FR-LOC -> PBD-PURCH-FR-LOC Pocompany POCOMPANY Required PBT-COMPANY -> PCY-COMPANY Venditem POITEMVEN Not Required PBT-COMPANY -> PIV-COMPANY PBT-ITEM -> PIV-ITEM PBT-VENDOR -> PIV-VENDOR |