Database Table: LPOPURAMT

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 Name Column Type Column Description
AMOUNT DECIMAL (20,5)
NOT NULL
Expected 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.
BUYERPO_ID BIGINT
NOT NULL
ID of the Buyer Purchase Order Number of the Limited PO.
ORDERS_ID BIGINT
NOT NULL
Order ID. Foreign key to the ORDERS table.
SETCCURR CHARACTER (3)
NULL
Currency of the Amount field. Alphabetic currency code as per ISO 4217.
Indexes:
Index Name Indexed Column Names Index Type
Not Applicable
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_422 SETCCURR SETCURR SETCCURR Cascade
F_423 ORDERS_ID ORDERS ORDERS_ID Cascade
F_424 BUYERPO_ID BUYERPO BUYERPO_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable