Rptiteminventoryperstockresult |
Catalogus: ionBIZ
Ophalen: true
Tabelkolommen
De kolommen van de tabel Rptiteminventoryperstockresult worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
CommercialName |
string |
itgen_ibz_commercialname |
☐ |
|
CostType |
string |
itgen_ibz_costtype |
☐ |
|
CustomFields |
string |
itgen_ibz_customfields |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
InStock |
decimal |
itgen_ibz_instock |
☑ |
|
ItemId |
string |
itgen_ibz_itemid |
☐ |
|
LastUnitCostUpdate |
datetimeoffset |
itgen_ibz_lastunitcostupdate |
☐ |
|
MinimumStock |
decimal |
itgen_ibz_minimumstock |
☐ |
|
Name |
string |
itgen_ibz_name |
☐ |
|
ReliabilityOfLastUnitCost |
int32 |
itgen_ibz_reliabilityoflastunitcost |
☐ |
|
ReliabilityOfLastUnitCostType |
int32 |
itgen_ibz_reliabilityoflastunitcosttype |
☐ |
|
RotationIndex1Year |
decimal |
itgen_ibz_rotationindex1year |
☐ |
|
RotationIndex3Years |
decimal |
itgen_ibz_rotationindex3years |
☐ |
|
ShortName |
string |
itgen_ibz_shortname |
☐ |
|
Status |
string |
itgen_ibz_status |
☐ |
|
StockLocationName |
string |
itgen_ibz_stocklocationname |
☐ |
|
TotalCosts |
decimal |
itgen_ibz_totalcosts |
☐ |
|
TotalSales |
decimal |
itgen_ibz_totalsales |
☐ |
|
TotalWeightedCost |
decimal |
itgen_ibz_totalweightedcost |
☐ |
|
UnitCost |
decimal |
itgen_ibz_unitcost |
☐ |
|
UnitPrice |
decimal |
itgen_ibz_unitprice |
☐ |
|
WeightedUnitCost |
decimal |
itgen_ibz_weightedunitcost |
☐ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120
ionBIZ API Data Model