API GetSupplierProductPriceList: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method gives You overview of existing supplier product price list in system. ==== Exact name ==== <code>API_GetSupplierProductPriceL…“) |
(Žádný rozdíl)
|
Aktuální verze z 29. 7. 2021, 12:18
Description
Method gives You overview of existing supplier product price list in system.
Exact name
API_GetSupplierProductPriceList
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| ID | int | Internal system id | |
| SupplierID | int | SupplierID | API_GetCustomers.ID |
| SupplierProductCode | nvarchar(40) | Supplier product code | API_GetSupplierProductCrossList.SupplierProductCode |
| ManufacturerSupplier | nvarchar(50) | Manufacturer supplier | API_GetSupplierProductCrossList.ManufacturerSupplier |
| Prefix | nvarchar(3) | Prefix | API_GetSupplierProductCrossList.Prefix |
| ForeignPrice | decimal(19,6) | Foreign price | |
| CreatedDate | datetime | Created date | |
| UpdatedDate | datetime | Updated date |
Example
SELECT TOP 1000 * FROM [API_GetSupplierProductPriceList]
Notices
None.
