POBID FILE Bid REFERENCED BY PO150 PO216 UPDATED BY PO16.1 PO16.2 PO550 PO560 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY PBD-COMPANY Numeric 4 PO16.1 PO16.2 Company The company number. PO550 PO560 PBD-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. PBD-DESCRIPTION Alpha 30 (Lower Case) PO16.1 PO16.2 Description This field contains the description. PO550 PO560 PBD-VENDOR Alpha 9 PO16.1 PO16.2 Vendor ID The vendor's identification code. PO550 PO560 PBD-PURCH-FR-LOC Alpha 4 PO16.1 PO16.2 Purchase From The vendor's purchase from location. PO550 PO560 Location Code PBD-CREATE-DATE Numeric 8 (yyyymmdd) PO16.1 PO16.2 Creation Date The creation date. PO550 PO560 PBD-EFFECTIVE-DATE Numeric 8 (yyyymmdd) PO16.1 PO16.2 Effective Date The date a vendor's prices will be in PO550 PO560 effect. POBID FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN PBDSET1 COMPANY PO150 PO16.1 BID PO16.2 PO216 VENDOR PO550 PO560 PURCH-FR-LOC PBDSET2 COMPANY Subset BID Where VENDOR = Spaces And PURCH-FR-LOC = Spaces PBDSET3 COMPANY Subset BID Where VENDOR != Spaces VENDOR PURCH-FR-LOC POBID FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Pocompany POCOMPANY Required PBD-COMPANY -> PCY-COMPANY (PCYSET1) POBID FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Pobiditem POBIDITEM Delete Restricted PBD-COMPANY -> PBT-COMPANY PBD-BID -> PBT-BID PBD-VENDOR -> PBT-VENDOR PBD-PURCH-FR-LOC -> PBT-PURCH-FR-LOC PBT-ITEM PBT-VEN-ITEM Vendor Respons POBID Valid When PBD-VENDOR != Spaces PBD-COMPANY -> PBD-COMPANY PBD-BID -> PBD-BID PBD-VENDOR PBD-PURCH-FR-LOC |