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 |
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 |