The Buyer Purchase Order Type table. This table
defines the different types of Buyer Purchase Order for the
Site.
Column Descriptions:
| Name | Type | Description |
| BUYERPOTYP_ID | INTEGER NOT NULL | Types of Buyer Purchase Order (PO):
- Blanket PO
- Limited PO
- Single-use Individual PO
- Multiple-use Individual PO (PO Number can be used by more than
one order).
|
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | BUYERPOTYP_ID | Primary Key |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_135 | BUYERPOTYP_ID | BUYERPO | BUYERPOTYP_ID | Cascade |