This table is used to keep track of Purchase Amounts by Purchase Order number and by Orders. Entries are created only for Orders against Limited Purchase Order (PO) numbers.

Column Descriptions:

ORDERS_IDBIGINT NOT NULLOrder ID. Foreign key to the ORDERS table.
SETCCURRCHAR (3)Currency of the Amount field. Alphabetic currency codes as per ISO 4217.
BUYERPO_IDBIGINT NOT NULLID of the Buyer Purchase Order Number of the Limited PO.
AMOUNTDECIMAL (20,5) NOT NULLExpected purchase amounts for this Order against this Limited PO. The amount is in the same currency as the Purchase Limit Amount specified in the Limited PO.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0000607BUYERPO_IDNon-Unique Index
I0000608ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType