BUYERPOTYP

The Buyer Purchase Order Type table. This table defines the different types of Buyer Purchase Order for the Site.

Column Descriptions:

NameTypeDescription
BUYERPOTYP_IDINTEGER NOT NULLTypes of Buyer Purchase Order (PO):
  1. Blanket PO
  2. Limited PO
  3. Single-use Individual PO
  4. Multiple-use Individual PO (PO Number can be used by more than one order).
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>BUYERPOTYP_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_135BUYERPOTYP_IDBUYERPOBUYERPOTYP_IDCascade