Pipeline
commodityprice object[]
Array [
dtmchanged date-time
dtmeffective date-time
fuserdefined boolean
note string
pipelineId int32
productid string
supplierid string
unitprice double
user string
]
consumption object[]
Array [
conDate string
consactualflag boolean
consamount double
consdatasourceid string
consdatechanged date-time
consdisplaynote boolean
consid int32
consiflator double
consnote string
consnummonths int32
consstartmonth int32
consstartyear int32
old_consumption double
pipelineId int32
productid string
]
datasource object[]
Array [
datasourceid string
datasourcename string
datasourcetypeid string
pipelineId int32
]
fundingsource object[]
Array [
fundingnote string
fundingsourceid string
fundingsourcename string
pipelineId int32
]
inventory object[]
Array [
ctrindex int32
fimported boolean
invamount double
invdatasourceid string
invdatechanged date-time
invdisplaynote boolean
inventoryDate string
invnote string
invtransferflag boolean
old_inventory double
period date-time
pipelineId int32
productid string
]
method object[]
Array [
categoryid int32
cypfactor double
frollup boolean
methodid string
methodname string
methodnote string
parentid int32
pipelineId int32
]
monthlystockarchive object[]
Array [
eoybalance double
pipelineId int32
productid string
stockmonth int32
stockyear int32
]
paste_errors object[]
Array [
f1 string
f2 string
f3 double
pipelineId int32
]
product object[]
Array [
buconversion int32
dbllowestunitqty double
defaultcasesize int32
famcchanged boolean
favailabilitystatus boolean
fpermittedincountry boolean
fuserdefined boolean
lngamcmonths int32
lngamcstart int32
lngbatch int32
memavailabilitynotes string
methodid string
oldmethodid string
oldproductid string
oldproductname string
pipelineId int32
prodcmax int32
prodcmin int32
proddesstock int32
productactivedate date-time
productactiveflag boolean
productid string
productmaxmonths int32
productminmonths int32
productname string
productnote string
strimportsource string
strtype string
supplierid string
txtinnovatordrugname string
txtlowestunitmeasure string
txtmigrationstatus int32
txtmigrationstatusdate date-time
txtpreferencenotes string
txtsubstitutionlist string
]
productfreightcost object[]
Array [
dtmchanged date-time
freightcost double
pipelineId int32
productid string
supplierid string
]
productsuppliercasesize object[]
Array [
dtmchanged date-time
dtmeffective date-time
intcasesize int32
note string
pipelineId int32
productid string
supplierid string
user string
]
programinfo object[]
Array [
archivedate date-time
archiveinclude boolean
archiveyear int32
countrycode string
countryname string
datadirectory string
defaultleadtimeorder double
defaultleadtimeplan double
defaultleadtimeship double
defaultshipcost double
email string
fax string
isactive boolean
iscurrent boolean
isdefault boolean
language string
note string
pipelineId int32
programcode string
programcontact string
programname string
startsize string
telephone string
]
shipment object[]
Array [
old_shipment double
pipelineId int32
productid string
shipamount double
shipcaselot int32
shipdatasourceid string
shipdatechanged date-time
shipdisplaynote boolean
shipfreightcost double
shipfundingsourceid string
shipmentid string
shipnote string
shipordereddate date-time
shipplanneddate date-time
shippo string
shipreceiveddate date-time
shipshippeddate date-time
shipstatuscode string
shipvalue double
supplierid string
]
source object[]
Array [
defaultsupplier boolean
freight double
pipelineId int32
supplierid string
supplierleadtimeorder double
supplierleadtimeplan double
supplierleadtimeship double
suppliername string
suppliernote string
]
tblbe_version object[]
Array [
dtmupdated date-time
pipelineId int32
sbe_version string
]
tblimportproducts object[]
Array [
dtmexport date-time
fprocessed boolean
lngcyp double
lngid int32
pipelineId int32
strdose string
strmapping string
strname string
strproductid string
strsource string
]
tblimportrecords object[]
Array [
dbldatainterval double
dtmperiod date-time
lngadjustment int32
lngconsumption int32
lngparentid int32
pipelineId int32
strproductid string
]
Pipeline
{
"commodityprice": [
{
"dtmchanged": "2024-07-29T15:51:28.071Z",
"dtmeffective": "2024-07-29T15:51:28.071Z",
"fuserdefined": true,
"note": "string",
"pipelineId": 0,
"productid": "string",
"supplierid": "string",
"unitprice": 0,
"user": "string"
}
],
"consumption": [
{
"conDate": "string",
"consactualflag": true,
"consamount": 0,
"consdatasourceid": "string",
"consdatechanged": "2024-07-29T15:51:28.071Z",
"consdisplaynote": true,
"consid": 0,
"consiflator": 0,
"consnote": "string",
"consnummonths": 0,
"consstartmonth": 0,
"consstartyear": 0,
"old_consumption": 0,
"pipelineId": 0,
"productid": "string"
}
],
"datasource": [
{
"datasourceid": "string",
"datasourcename": "string",
"datasourcetypeid": "string",
"pipelineId": 0
}
],
"fundingsource": [
{
"fundingnote": "string",
"fundingsourceid": "string",
"fundingsourcename": "string",
"pipelineId": 0
}
],
"inventory": [
{
"ctrindex": 0,
"fimported": true,
"invamount": 0,
"invdatasourceid": "string",
"invdatechanged": "2024-07-29T15:51:28.071Z",
"invdisplaynote": true,
"inventoryDate": "string",
"invnote": "string",
"invtransferflag": true,
"old_inventory": 0,
"period": "2024-07-29T15:51:28.071Z",
"pipelineId": 0,
"productid": "string"
}
],
"method": [
{
"categoryid": 0,
"cypfactor": 0,
"frollup": true,
"methodid": "string",
"methodname": "string",
"methodnote": "string",
"parentid": 0,
"pipelineId": 0
}
],
"monthlystockarchive": [
{
"eoybalance": 0,
"pipelineId": 0,
"productid": "string",
"stockmonth": 0,
"stockyear": 0
}
],
"paste_errors": [
{
"f1": "string",
"f2": "string",
"f3": 0,
"pipelineId": 0
}
],
"product": [
{
"buconversion": 0,
"dbllowestunitqty": 0,
"defaultcasesize": 0,
"famcchanged": true,
"favailabilitystatus": true,
"fpermittedincountry": true,
"fuserdefined": true,
"lngamcmonths": 0,
"lngamcstart": 0,
"lngbatch": 0,
"memavailabilitynotes": "string",
"methodid": "string",
"oldmethodid": "string",
"oldproductid": "string",
"oldproductname": "string",
"pipelineId": 0,
"prodcmax": 0,
"prodcmin": 0,
"proddesstock": 0,
"productactivedate": "2024-07-29T15:51:28.071Z",
"productactiveflag": true,
"productid": "string",
"productmaxmonths": 0,
"productminmonths": 0,
"productname": "string",
"productnote": "string",
"strimportsource": "string",
"strtype": "string",
"supplierid": "string",
"txtinnovatordrugname": "string",
"txtlowestunitmeasure": "string",
"txtmigrationstatus": 0,
"txtmigrationstatusdate": "2024-07-29T15:51:28.071Z",
"txtpreferencenotes": "string",
"txtsubstitutionlist": "string"
}
],
"productfreightcost": [
{
"dtmchanged": "2024-07-29T15:51:28.071Z",
"freightcost": 0,
"pipelineId": 0,
"productid": "string",
"supplierid": "string"
}
],
"productsuppliercasesize": [
{
"dtmchanged": "2024-07-29T15:51:28.071Z",
"dtmeffective": "2024-07-29T15:51:28.071Z",
"intcasesize": 0,
"note": "string",
"pipelineId": 0,
"productid": "string",
"supplierid": "string",
"user": "string"
}
],
"programinfo": [
{
"archivedate": "2024-07-29T15:51:28.071Z",
"archiveinclude": true,
"archiveyear": 0,
"countrycode": "string",
"countryname": "string",
"datadirectory": "string",
"defaultleadtimeorder": 0,
"defaultleadtimeplan": 0,
"defaultleadtimeship": 0,
"defaultshipcost": 0,
"email": "string",
"fax": "string",
"isactive": true,
"iscurrent": true,
"isdefault": true,
"language": "string",
"note": "string",
"pipelineId": 0,
"programcode": "string",
"programcontact": "string",
"programname": "string",
"startsize": "string",
"telephone": "string"
}
],
"shipment": [
{
"old_shipment": 0,
"pipelineId": 0,
"productid": "string",
"shipamount": 0,
"shipcaselot": 0,
"shipdatasourceid": "string",
"shipdatechanged": "2024-07-29T15:51:28.071Z",
"shipdisplaynote": true,
"shipfreightcost": 0,
"shipfundingsourceid": "string",
"shipmentid": "string",
"shipnote": "string",
"shipordereddate": "2024-07-29T15:51:28.071Z",
"shipplanneddate": "2024-07-29T15:51:28.071Z",
"shippo": "string",
"shipreceiveddate": "2024-07-29T15:51:28.071Z",
"shipshippeddate": "2024-07-29T15:51:28.071Z",
"shipstatuscode": "string",
"shipvalue": 0,
"supplierid": "string"
}
],
"source": [
{
"defaultsupplier": true,
"freight": 0,
"pipelineId": 0,
"supplierid": "string",
"supplierleadtimeorder": 0,
"supplierleadtimeplan": 0,
"supplierleadtimeship": 0,
"suppliername": "string",
"suppliernote": "string"
}
],
"tblbe_version": [
{
"dtmupdated": "2024-07-29T15:51:28.071Z",
"pipelineId": 0,
"sbe_version": "string"
}
],
"tblimportproducts": [
{
"dtmexport": "2024-07-29T15:51:28.071Z",
"fprocessed": true,
"lngcyp": 0,
"lngid": 0,
"pipelineId": 0,
"strdose": "string",
"strmapping": "string",
"strname": "string",
"strproductid": "string",
"strsource": "string"
}
],
"tblimportrecords": [
{
"dbldatainterval": 0,
"dtmperiod": "2024-07-29T15:51:28.071Z",
"lngadjustment": 0,
"lngconsumption": 0,
"lngparentid": 0,
"pipelineId": 0,
"strproductid": "string"
}
]
}