BUYERPO

Each row of this table represents a Purchase Order Number. It is that the Buyer organization of the Account has defined or used for Trading with the Seller organization. The number is only unique within the Account.

Column Descriptions:

NameTypeDescription
BUYERPO_IDBIGINT NOT NULLGenerated unique key for this row.
SETCCURRCHAR (3)Currency of the Amount field. Alphabetic currency codes as per ISO 4217.
ACCOUNT_IDBIGINTThe ID of the business account to which the Buyer Purchase Order Number belongs. Foreign key to the ACCOUNT table.
PONUMBERVARCHAR (128) NOT NULLThe Buyer Purchase Order Number.
BUYERPOTYP_IDINTEGER NOT NULLType of the Buyer Purchase Order Number. The types are defined in the BUYERPOTYP table.
STATEINTEGER DEFAULT 0State of the Purchase Order Number: 0=Undefined, 1=Active, available for Order, 2=Closed, cannot be used for Order.
AMOUNTDECIMAL (20,5)Amount for Limited Purchase Order.
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.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>BUYERPO_IDPrimary Key
I0000488ACCOUNT_IDNon-Unique Index
I0000489BUYERPOTYP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_135BUYERPOTYP_IDBUYERPOTYPBUYERPOTYP_IDCascade
F_136SETCCURRSETCURRSETCCURRCascade
F_137ACCOUNT_IDACCOUNTACCOUNT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_424BUYERPO_IDLPOPURAMTBUYERPO_IDCascade
F_538BUYERPO_IDORDPAYMTHDBUYERPO_IDCascade
F_9004BUYERPO_IDORDERSBUYERPO_IDCascade