Item_vendor_pricing

Columns

Name Type Length Precision Scale References In Description
cost_0 NUMBER 30 15 Cost of item vendor pricing
cost_is_percentage VARCHAR2 1 Cost is percentage of item vendor pricing
currency_id NUMBER 39 0 currency_id
Currencies
Currency ID of the item vendor pricing
item_id NUMBER 39 0 item_id
Items
Item ID of the item vendor pricing
subsidiary_id NUMBER 39 0 subsidiary_id
Subsidiaries
Subsidiary ID of the item vendor pricing
vendor_id NUMBER 39 0 vendor_id
Vendors
Vendor ID of the item vendor pricing

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
item_vendor_pricing_currencies_fk currency_id Currencies currency_id 1
item_vendor_pricing_items_fk item_id Items item_id 1
item_vendor_pricing_subsidiaries_fk subsidiary_id Subsidiaries subsidiary_id 1
item_vendor_pricing_vendors_fk vendor_id Vendors vendor_id 1