|
|
POBID FILE
Bid
REFERENCED BY
PO00.1 PO150 PO216
UPDATED BY
PO16.1 PO16.2 PO550 PO560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PBD-PROCURE-GROUP Alpha 4 PO16.1 PO16.2
Element: Procure Group This field contains the identifier for a PO550 PO560
group of companies that share a common
procurement effort. They buy items and
services together.
PBD-BID Alpha 10 PO16.1 PO16.2
Element: Bid 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
Element: Description This field displays the description. PO550 PO560
PBD-VENDOR Alpha 9 (Right Justified) PO16.1 PO16.2
Element: Vendor The vendor's identification code. PO550 PO560
PBD-PURCH-FR-LOC Alpha 4 PO16.1 PO16.2
Element: Purch Fr Loc The vendor's purchase from location. PO550 PO560
PBD-CREATE-DATE Numeric 8 (yyyymmdd) PO16.1 PO16.2
Element: Create Date The creation date. PO550 PO560
PBD-EFFECTIVE-DATE Numeric 8 (yyyymmdd) PO16.1 PO16.2
Element: Effective DateThe date a vendor's prices will be in PO550 PO560
effect.
POBID FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PBDSET1 PROCURE-GROUP PO00.1 PO150
BID PO16.1 PO16.2
VENDOR PO216 PO550
PURCH-FR-LOC PO560
PBDSET2 PROCURE-GROUP Subset
BID Where VENDOR = Spaces
And PURCH-FR-LOC = Spaces
PBDSET3 PROCURE-GROUP Subset
BID Where VENDOR != Spaces
VENDOR
PURCH-FR-LOC
POBID FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apvenloc APVENLOC Required
PCG-VENDOR-GROUP -> VLO-VENDOR-GROUP (VLOSET1)
PBD-VENDOR -> VLO-VENDOR
PBD-PURCH-FR-LOC -> VLO-LOCATION-CODE
Apvenmast APVENMAST Required
PCG-VENDOR-GROUP -> VEN-VENDOR-GROUP
PBD-VENDOR -> VEN-VENDOR
Procuregrp PROCUREGRP Required
PBD-PROCURE-GROUP -> PCG-PROCURE-GROUP
POBID FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pobiditem POBIDITEM
PBD-PROCURE-GROUP -> PBT-PROCURE-GROUP
PBD-BID -> PBT-BID
PBD-VENDOR -> PBT-VENDOR
PBD-PURCH-FR-LOC -> PBT-PURCH-FR-LOC
PBT-ITEM
PBT-VEN-ITEM
|
