POBID

Bid
UPDATED BY
PO00.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PBD-PROCURE-GROUP
Element: Procure Group		Alpha 4
This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.
PBD-BID
Element: Bid		Alpha 10
A user assigned name for a group of items that have been sent to vendors for price quotes, or catalog pricing that has been received from a vendor.
PBD-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
PBD-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
PBD-PURCH-FR-LOC
Element: Purch Fr Loc		Alpha 4
The vendor's purchase from location.
PBD-CREATE-DATE
Element: Create Date		Numeric 8 (yyyymmdd)
The creation date.
PBD-EFFECTIVE-DATE
Element: Effective Date		Numeric 8 (yyyymmdd)
The date a vendor's prices will be in effect.


POBID FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PBDSET1 PROCURE-GROUP
BID
VENDOR
PURCH-FR-LOC
PO00.1
PBDSET2 PROCURE-GROUP
BID
Subset
WhereVENDOR =Spaces
AndPURCH-FR-LOC =Spaces


POBID FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Wed Jun 08 20:50:44 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.