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