{
"dataset": {
"tblname": "RSLDATA",
"libname": "AIDDATA",
"attr": [
{ "name" : "LISTNAME",
"type" : "CHAR",
"datatype" : "A",
"length" : 15,
"decimals" : 0,
"decpos" : 0,
"width" : 15,
"varchar" : "0",
"allownull" : "0",
"alias" : "RSLNAME",
"colhdg" : ["RSLNAME"]
},
{ "name" : "IMVND",
"type" : "CHAR",
"datatype" : "A",
"length" : 3,
"decimals" : 0,
"decpos" : 0,
"width" : 6,
"varchar" : "0",
"allownull" : "0",
"alias" : "Vendor",
"colhdg" : ["Vendor"]
},
{ "name" : "IMITEM",
"type" : "CHAR",
"datatype" : "A",
"length" : 15,
"decimals" : 0,
"decpos" : 0,
"width" : 15,
"varchar" : "0",
"allownull" : "0",
"alias" : "Item",
"colhdg" : ["Item"]
},
{ "name" : "VendorItem",
"type" : "VARCHAR",
"datatype" : "A",
"length" : 20,
"decimals" : 0,
"decpos" : 0,
"width" : 20,
"varchar" : "0",
"allownull" : "0",
"alias" : "VendorItem",
"colhdg" : ["VendorItem"]
},
{ "name" : "IMDES",
"type" : "CHAR",
"datatype" : "A",
"length" : 20,
"decimals" : 0,
"decpos" : 0,
"width" : 20,
"varchar" : "0",
"allownull" : "0",
"alias" : "ItemDesc",
"colhdg" : ["ItemDesc"]
},
{ "name" : "Price",
"type" : "DECIMAL",
"datatype" : "P",
"length" : 7,
"decimals" : 2,
"decpos" : 2,
"width" : 9,
"varchar" : "0",
"allownull" : "1",
"alias" : "Price",
"colhdg" : ["Price"]
},
{ "name" : "IBQOH",
"type" : "DECIMAL",
"datatype" : "P",
"length" : 7,
"decimals" : 0,
"decpos" : 0,
"width" : 9,
"varchar" : "0",
"allownull" : "1",
"alias" : "QOH",
"colhdg" : ["QOH"]
},
{ "name" : "IBQOO",
"type" : "DECIMAL",
"datatype" : "P",
"length" : 7,
"decimals" : 0,
"decpos" : 0,
"width" : 9,
"varchar" : "0",
"allownull" : "1",
"alias" : "QOO",
"colhdg" : ["QOO"]
},
{ "name" : "LastDateOrdered",
"type" : "VARCHAR",
"datatype" : "A",
"length" : 10,
"decimals" : 0,
"decpos" : 0,
"width" : 15,
"varchar" : "0",
"allownull" : "1",
"alias" : "LastDateOrdered",
"colhdg" : ["LastDateOrdered"]
},
{ "name" : "ProductImage",
"type" : "VARCHAR",
"datatype" : "A",
"length" : 640,
"decimals" : 0,
"decpos" : 0,
"width" : 640,
"varchar" : "0",
"allownull" : "1",
"alias" : "ProductImage",
"colhdg" : ["ProductImage"]
}
]
, "row": [
{
"RSLNAME" : "GAS CANS",
"Vendor" : "CCA",
"Item" : "R02367",
"VendorItem" : "CCA R02367",
"ItemDesc" : "20L GAS CAN",
"Price" : 38.71,
"QOH" : 5,
"QOO" : 0,
"LastDateOrdered" : "11/17/2023",
"ProductImage" : " 20L GAS CAN
AIN: CCA R02367 $38.71 \" >"
}
,{
"RSLNAME" : "GAS CANS",
"Vendor" : "SSR",
"Item" : "123750",
"VendorItem" : "SSR 123750",
"ItemDesc" : "2GL RED PLAS GAS CAN",
"Price" : 22.41,
"QOH" : 55,
"QOO" : 12,
"LastDateOrdered" : "03/18/2024",
"ProductImage" : " 2GL RED PLAS GAS CAN
AIN: SSR 123750 $22.41 \" >"
}
,{
"RSLNAME" : "GAS CANS",
"Vendor" : "SSR",
"Item" : "123758",
"VendorItem" : "SSR 123758",
"ItemDesc" : "1GL RED PLAS GAS CAN",
"Price" : 14.32,
"QOH" : 32,
"QOO" : 24,
"LastDateOrdered" : "03/18/2024",
"ProductImage" : " 1GL RED PLAS GAS CAN
AIN: SSR 123758 $14.32 \" >"
}
,{
"RSLNAME" : "GAS CANS",
"Vendor" : "SSR",
"Item" : "133108",
"VendorItem" : "SSR 133108",
"ItemDesc" : "5 GAL RED GAS CAN",
"Price" : 108.82,
"QOH" : 1,
"QOO" : 0,
"LastDateOrdered" : "None",
"ProductImage" : " 5 GAL RED GAS CAN
AIN: SSR 133108 $108.82 \" >"
}
,{
"RSLNAME" : "GAS CANS",
"Vendor" : "SSR",
"Item" : "178827",
"VendorItem" : "SSR 178827",
"ItemDesc" : "6GAL GAS TANK",
"Price" : 93.25,
"QOH" : 2,
"QOO" : 0,
"LastDateOrdered" : "10/02/2023",
"ProductImage" : " 6GAL GAS TANK
AIN: SSR 178827 $93.25 \" >"
}
,{
"RSLNAME" : "GAS CANS",
"Vendor" : "SSR",
"Item" : "248474",
"VendorItem" : "SSR 248474",
"ItemDesc" : "5GL RED POLY GAS CAN",
"Price" : 42.53,
"QOH" : 8,
"QOO" : 0,
"LastDateOrdered" : "03/04/2024",
"ProductImage" : " 5GL RED POLY GAS CAN
AIN: SSR 248474 $42.53 \" >"
}
,{
"RSLNAME" : "GAS CANS",
"Vendor" : "SSR",
"Item" : "248477",
"VendorItem" : "SSR 248477",
"ItemDesc" : "6GAL RED GAS CAN",
"Price" : 53.17,
"QOH" : 5,
"QOO" : 0,
"LastDateOrdered" : "01/08/2024",
"ProductImage" : " 6GAL RED GAS CAN
AIN: SSR 248477 $53.17 \" >"
}
,{
"RSLNAME" : "GAS CANS",
"Vendor" : "SSR",
"Item" : "248478",
"VendorItem" : "SSR 248478",
"ItemDesc" : "5GAL KEROSENE CAN",
"Price" : 42.53,
"QOH" : 6,
"QOO" : 0,
"LastDateOrdered" : "05/01/2023",
"ProductImage" : " 5GAL KEROSENE CAN
AIN: SSR 248478 $42.53 \" >"
}
,{
"RSLNAME" : "GAS CANS",
"Vendor" : "SSR",
"Item" : "248479",
"VendorItem" : "SSR 248479",
"ItemDesc" : "5GAL YEL DIESEL CAN",
"Price" : 44.01,
"QOH" : 6,
"QOO" : 4,
"LastDateOrdered" : "03/11/2024",
"ProductImage" : " 5GAL YEL DIESEL CAN
AIN: SSR 248479 $44.01 \" >"
}
,{
"RSLNAME" : "GAS CANS",
"Vendor" : "SSR",
"Item" : "531317",
"VendorItem" : "SSR 531317",
"ItemDesc" : "6GAL WTR CONTAINER",
"Price" : 32.59,
"QOH" : 3,
"QOO" : 0,
"LastDateOrdered" : "05/01/2023",
"ProductImage" : " 6GAL WTR CONTAINER
AIN: SSR 531317 $32.59 \" >"
}
]
, "rowcount": 10
}
}