Item Collection
Property |
Description |
Table |
OITM |
Primary key |
ItemCode/c |
$transaction |
issuewo,receiptwo,issue,receipt,receiptpo |
$branch |
no |
$mask |
no |
Name |
Type |
Description |
|
ItemCode |
Edm.String(50) |
|
|
ItemName |
Edm.String(100) |
|
|
IVersionId |
Edm.String(20) |
|
|
ForeignName |
Edm.String(100) |
|
|
MainSupplier |
Edm.String(15) |
|
|
Barcode |
Edm.String(254) |
|
|
CardCode |
Edm.String(20) |
|
|
ItemType |
Edm.String(1) |
|
|
InventoryItem |
Edm.Boolean |
|
|
ManageBatchNumbers |
Edm.Boolean |
|
|
ManageSerialNumbers |
Edm.Boolean |
|
|
BatchnumberGeneration |
Edm.String(1) |
|
|
Breakdown |
Edm.String(1) |
|
|
ProcurementMethod |
Edm.String(1) |
|
|
PlanningSystem |
Edm.String(1) |
|
|
IssueMethod |
Edm.String(1) |
|
|
ItemVersionAdministration |
Edm.Int32 |
|
|
ItemVersionCount |
Edm.Int32 |
|
|
CalculationPrice |
Edm.Decimal |
|
|
CalcLotSizeInventoryUOM |
Edm.Decimal |
|
|
CalcLotSizeProductionUoM |
Edm.Decimal |
|
|
ProductionLotSize |
Edm.Decimal |
|
|
ProductionLotSizeUnit |
Edm.Decimal |
|
|
MinimumOrderQuantity |
Edm.Decimal |
|
|
OrderMultiple |
Edm.Decimal |
|
|
ScrapPercent |
Edm.Int32 |
|
|
ScrapTable |
Edm.String(20) |
|
|
InventoryUOM |
Edm.String(20) |
|
|
ProductionUnit |
Edm.String(20) |
|
|
PurchaseUnit |
Edm.String(20) |
|
|
UnitGroupId |
Edm.Int32 |
|
|
OnHand |
Edm.Decimal |
|
|
DefaultWareHouse |
Edm.String(20) |
|
|
WareHouseRuleId |
Edm.String(50) |
|
|
CostAccountingMethod |
Edm.String(1) |
|
|
ManageStockByWarehouse |
Edm.String(1) |
|
|
DrawingNumber |
Edm.String(50) |
|
|
MatchCode |
Edm.String(20) |
|
|
DIN |
Edm.String(50) |
|
|
ItemGroupCode |
Edm.Int32 |
|
|
MaterialGroupId |
Edm.String(20) |
|
|
ShelfLife |
Edm.Int32 |
|
|
RawMaterialId |
Edm.String(20) |
|
|
SpecificWeight |
Edm.Decimal |
|
|
PurchaseUnitHeight1 |
Edm.Decimal |
|
|
PurchaseHeightUoM1 |
Edm.String(20) |
|
|
PurchaseUnitWidth1 |
Edm.Decimal |
|
|
PurchaseWidthUoM1 |
Edm.String(1) |
|
|
PurchaseUnitLength1 |
Edm.Decimal |
|
|
PurchaseLengthUoM1 |
Edm.String(1) |
|
|
Picture1 |
Edm.String(50) |
|
|
Picture2 |
Edm.String(50) |
|
|
Picture3 |
Edm.String(50) |
|
Join to Entiy Object |
Relation |
RawMaterial |
RawMaterialId |
ItemWareHouse |
ItemCode |
UoM |
UoMCode=InventoryUOM |
WareHouse |
WhsCode=DefaultWareHouse |
MaterialGroupId |
|
ItemGroup |
ItemGroupCode |
ItemVersion |
ItemCode |
ItemVersionDefault |
ItemCode,IVersionId |
UoMPurchase |
PurchaseUoMCode=PurchaseUnit |
UnitGroup |
UnitGroupId |
ItemDocuments |
ItemCode |
Function |
Parameter |
Description |
|
GetPrice |
ItemCode/c,Warehouse/c,CardCode/c,Quantity/i,Valuation/c) |
|
|
GetDocuments |
ItemCode/c) |
|
|
GetAsXML |
ItemCode/c) |
|
|
GetAsJson |
ItemCode/c,IVersionId/c,NullValues/b,udf/b |
|
My Example
Item("1111")
{
"value":
{
"ItemCode": "1111",
"ItemName": "Simple Version Admin Item 1",
"IVersionId": "",
"ForeignName": "TEST",
"MainSupplier": "V4894",
"Barcode": "111-222-333",
"CardCode": "V4894",
"ItemType": "I",
"InventoryItem": true,
"ManageBatchNumbers": false,
"ManageSerialNumbers": false,
"BatchnumberGeneration": "N",
"Breakdown": "K",
"ProcurementMethod": "B",
"PlanningSystem": 0,
"IssueMethod": "B",
"ItemVersionAdministration": 0,
"ItemVersionCount": 0,
"CalculationPrice": 55.355,
"CalcLotSizeInventoryUOM": 0,
"CalcLotSizeProductionUoM": 0,
"ProductionLotSize": 0,
"ProductionLotSizeUnit": "Pcs",
"MinimumOrderQuantity": 0,
"OrderMultiple": 0,
"ScrapPercent": null,
"ScrapTable": null,
"InventoryUOM": "Pcs",
"ProductionUnit": "Pcs",
"PurchaseUnit": "Pcs",
"UnitGroupId": -1,
"OnHand": 0,
"DefaultWareHouse": "01-locke",
"WareHouseRuleId": null,
"CostAccountingMethod": "A",
"ManageStockByWarehouse": "N",
"DrawingNumber": null,
"MatchCode": "test3",
"DIN": "ABC",
"ItemGroupCode": 100,
"MaterialGroupId": "HM",
"ShelfLife": 0,
"RawMaterialId": null,
"SpecificWeight": 0,
"PurchaseUnitHeight1": 0,
"PurchaseHeightUoM1": null,
"PurchaseUnitWidth1": 0,
"PurchaseWidthUoM1": null,
"PurchaseUnitLength1": 0,
"PurchaseLengthUoM1": null,
"Picture1": null,
"Picture2": null,
"Picture3": null,
"U_beas_BinGroup": null,
"U_symbol1": null,
"U_lagtemp": null,
"U_egnr": null,
"U_flammpkt": null,
"U_lagerinf": null,
"U_formula": null,
"U_alloy": null,
"U_fluxproz": null,
"U_brand": null,
"U_prodtyp": null,
"U_Mesh": null,
"U_fluxtype": null,
"U_coresize": null,
"U_weight": null,
"U_dim": null,
"U_diameter": null,
"U_qgrade": null,
"U_pack": null,
"U_divbez": null,
"U_beas_CalcLotsizeWoUnit": null,
"U_beas_prlotsizeU": 0,
"U_DW_AUTORECEIPT": null,
"U_DW_PACKAGEQTY": null
}
}