Pipeline
commodityprice object[]
Array [
dtmchangedstring<date-time>
dtmeffectivestring<date-time>
fuserdefinedboolean
notestring
pipelineIdinteger<int32>
productidstring
supplieridstring
unitpricenumber<double>
userstring
]
consumption object[]
Array [
conDatestring
consactualflagboolean
consamountnumber<double>
consdatasourceidstring
consdatechangedstring<date-time>
consdisplaynoteboolean
considinteger<int32>
consiflatornumber<double>
consnotestring
consnummonthsinteger<int32>
consstartmonthinteger<int32>
consstartyearinteger<int32>
old_consumptionnumber<double>
pipelineIdinteger<int32>
productidstring
]
datasource object[]
Array [
datasourceidstring
datasourcenamestring
datasourcetypeidstring
pipelineIdinteger<int32>
]
fundingsource object[]
Array [
fundingnotestring
fundingsourceidstring
fundingsourcenamestring
pipelineIdinteger<int32>
]
inventory object[]
Array [
ctrindexinteger<int32>
fimportedboolean
invamountnumber<double>
invdatasourceidstring
invdatechangedstring<date-time>
invdisplaynoteboolean
inventoryDatestring
invnotestring
invtransferflagboolean
old_inventorynumber<double>
periodstring<date-time>
pipelineIdinteger<int32>
productidstring
]
method object[]
Array [
categoryidinteger<int32>
cypfactornumber<double>
frollupboolean
methodidstring
methodnamestring
methodnotestring
parentidinteger<int32>
pipelineIdinteger<int32>
]
monthlystockarchive object[]
Array [
eoybalancenumber<double>
pipelineIdinteger<int32>
productidstring
stockmonthinteger<int32>
stockyearinteger<int32>
]
paste_errors object[]
Array [
f1string
f2string
f3number<double>
pipelineIdinteger<int32>
]
product object[]
Array [
buconversioninteger<int32>
dbllowestunitqtynumber<double>
defaultcasesizeinteger<int32>
famcchangedboolean
favailabilitystatusboolean
fpermittedincountryboolean
fuserdefinedboolean
lngamcmonthsinteger<int32>
lngamcstartinteger<int32>
lngbatchinteger<int32>
memavailabilitynotesstring
methodidstring
oldmethodidstring
oldproductidstring
oldproductnamestring
pipelineIdinteger<int32>
prodcmaxinteger<int32>
prodcmininteger<int32>
proddesstockinteger<int32>
productactivedatestring<date-time>
productactiveflagboolean
productidstring
productmaxmonthsinteger<int32>
productminmonthsinteger<int32>
productnamestring
productnotestring
strimportsourcestring
strtypestring
supplieridstring
txtinnovatordrugnamestring
txtlowestunitmeasurestring
txtmigrationstatusinteger<int32>
txtmigrationstatusdatestring<date-time>
txtpreferencenotesstring
txtsubstitutionliststring
]
productfreightcost object[]
Array [
dtmchangedstring<date-time>
freightcostnumber<double>
pipelineIdinteger<int32>
productidstring
supplieridstring
]
productsuppliercasesize object[]
Array [
dtmchangedstring<date-time>
dtmeffectivestring<date-time>
intcasesizeinteger<int32>
notestring
pipelineIdinteger<int32>
productidstring
supplieridstring
userstring
]
programinfo object[]
Array [
archivedatestring<date-time>
archiveincludeboolean
archiveyearinteger<int32>
countrycodestring
countrynamestring
datadirectorystring
defaultleadtimeordernumber<double>
defaultleadtimeplannumber<double>
defaultleadtimeshipnumber<double>
defaultshipcostnumber<double>
emailstring
faxstring
isactiveboolean
iscurrentboolean
isdefaultboolean
languagestring
notestring
pipelineIdinteger<int32>
programcodestring
programcontactstring
programnamestring
startsizestring
telephonestring
]
shipment object[]
Array [
old_shipmentnumber<double>
pipelineIdinteger<int32>
productidstring
shipamountnumber<double>
shipcaselotinteger<int32>
shipdatasourceidstring
shipdatechangedstring<date-time>
shipdisplaynoteboolean
shipfreightcostnumber<double>
shipfundingsourceidstring
shipmentidstring
shipnotestring
shipordereddatestring<date-time>
shipplanneddatestring<date-time>
shippostring
shipreceiveddatestring<date-time>
shipshippeddatestring<date-time>
shipstatuscodestring
shipvaluenumber<double>
supplieridstring
]
source object[]
Array [
defaultsupplierboolean
freightnumber<double>
pipelineIdinteger<int32>
supplieridstring
supplierleadtimeordernumber<double>
supplierleadtimeplannumber<double>
supplierleadtimeshipnumber<double>
suppliernamestring
suppliernotestring
]
tblbe_version object[]
Array [
dtmupdatedstring<date-time>
pipelineIdinteger<int32>
sbe_versionstring
]
tblimportproducts object[]
Array [
dtmexportstring<date-time>
fprocessedboolean
lngcypnumber<double>
lngidinteger<int32>
pipelineIdinteger<int32>
strdosestring
strmappingstring
strnamestring
strproductidstring
strsourcestring
]
tblimportrecords object[]
Array [
dbldataintervalnumber<double>
dtmperiodstring<date-time>
lngadjustmentinteger<int32>
lngconsumptioninteger<int32>
lngparentidinteger<int32>
pipelineIdinteger<int32>
strproductidstring
]
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"
}
]
}