Warehouse stock, current product and SKU-wide bins — Pro
Choose a warehouse; inspect source quantities and replenishment settings, then product and SKU-wide bins on demand.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.
For warehouse, purchasing, production and management teams: choose a warehouse and inspect the recorded on-hand, on-order, booked, in-transit and work-in-process quantities alongside specifications, serial context, current stock unit and replenishment settings. Open Details for receipt/repair dates and recorded costs. Two sub-buttons load the current product dossier and that SKU's warehouse-bin positions only when requested.
Why Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.
Pro: one source, three bounded live lists with same-row Details and two lazy sub-buttons. No widgets, computed totals or periodic refresh. Warehouse selection is mandatory at opening before the final 2,000-row root cap; product/bin reads have 500-row caps. Existing workspace resources count. Search and local filters cover loaded rows only, not a complete inventory. Native numeric values are exact source strings; local quantity sorting/filtering is textual. A row cap is not a performance guarantee.
STOCK MEANING: stored source quantities and thresholds are kept separate. No available-to-sell formula, aggregate by item/warehouse, unit conversion, inferred stock valuation, MRP or automatic purchase suggestion. WIP/in-process and allocated descriptions use item/warehouse scope, wider than a serial/specification row; booked/on-order descriptions use item/specification/warehouse. Values may repeat across serial rows: NEVER sum or subtract them. Current unit is optional item-master context, not proof of installed quantity basis. Lead-time unit is unverified, not assumed days. Zero, negative, unknown and NULL values remain distinct; NULL is not zero. No vendor recalc procedure or formula is executed.
BINS: explicitly SKU/warehouse/specification-wide, NOT a selected serial's allocation. Icibin has no serial field. Parent UID and unchanged item/warehouse/spec1/spec2/serial context are revalidated before child reads. All matching bin positions are read lazily, not merged or allocated to a serial. A missing/empty/ambiguous bin identity blocks the whole bin branch; an empty result does not prove zero stock. Designation is a native relationship flag, not a picked master: 0=not user-set, 1=user-set; unknown remains unknown. Native min(nseq) is the documented master-bin rule, but no first-bin, tie resolution or installed uniqueness is inferred.
CURRENT CONTEXT: unique current Icitem/Icwhse enrich the row; absent or duplicate masters preserve stock with a context warning, without arbitrary names or fanout. Current product child requires a unique master; missing context may yield no child without removing root stock. Same SKU in different serial rows retains different hidden parent-owned child keys. Opaque full cuid is the warehouse/bin row identity, NOT item+warehouse. UTF16 encoded context preserves NULL vs blank, Unicode and spaces through app parent-value trimming. Incomplete/duplicate stock identities are excluded, not silently selected; exclusions do not establish a complete inventory.
COSTS AND PRICES: recorded source text with no currency symbol. Selected tables establish neither ISO currency nor installed cost/price unit basis. Actual gallery must label these limits. No FX/tax/discount, valuation or valid-quote calculation. Current product price and standard cost are master values, not current warehouse receipt cost or historical transaction snapshots. Confirm basis with the administrator before financial use.
COMPATIBILITY: own complete historical IC12 reference, 15 February 2021, table-specific fields/keys and quantity-dimension meanings. Not current SQL14 or AccountMate Enterprise certification. AMTBL Required/widths are form metadata, not installed DDL/nullability. SQL Server 2012+ for CONCAT; binary token conversion uses SQL Server UTF16 representation. Owner is UNKNOWN: administrator must confirm exactly one readable Iciwhs, Icitem, Icwhse and Icibin resolved identically by login/default schema on Android/iOS. Android metadata can prefer dbo; iOS SQL uses login/default resolution. Ambiguous owners must be replaced with confirmed qualified objects in Studio, then bounded read tests repeated. Import is not claimed to automatically reject duplicate owners. Check installed edition/types, full keys, collation, units/currency, results, indexes/query plan and response times. Native key candidate checks can use equality lookups but bounded output is not a cheap query guarantee. Narrow an authorised reporting source if needed.
SECURITY: company-authorised SELECT-only reporting connection; direct SQL does not inherit ERP ACL. Filters are not permissions. No credentials/server address/business rows in the package. Documentary and adapted synthetic checks do not certify a real ERP/SQL Server/iOS installation, source permissions, performance or subscription purchase. Unofficial, not endorsed by AccountMate.
Documentation: https://www.accountmateportal.com/xasset/techdoc/amsql12_ic_drg.pdf
Gallery: Eight original native Cifru DEMO images show complete stock, current-product and SKU-wide-bin cards, both actually opened sub-buttons and representative Details. All business values are invented; no AccountMate installation was connected. The configuration retains55 useful Detail positions (26stock,18product,11bin); all55 were checked against full private overlapping native continuations. The selected gallery shows52 positions: only current warehouse name, warehouse context and product context remain in private Details1, not these eight images. Financial basis and wider WIP/bin scope warnings are visible. No field was removed, screenshot retouched or row substituted to fit eight. Sixteen original PNG/XML pairs, frozen invented input and silent RAW are retained for future videos; whole RAW/Home/adverse NULL-placeholder lists/redundant continuations are private and not video-approved. Root-card action labels scroll horizontally; both full action labels are visible in Details4. Pro resource requirements were checked; filming uses a Pro test entitlement, not a purchase test. This proves native synthetic UI/action traversal, not source SQL, installed ERP/iOS/DDL/owner/collation, NULL/decimal/date conversion, units/currency, ACL, completeness or performance.
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Warehouse stock
- Details: Current product
- Details: Warehouse bins — SKU-wide
- Sub-button: Current product
- Sub-button: SKU-wide warehouse bins
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END AS StockKey, CASE WHEN w.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.citemno AS nvarchar(max))), 2)) END AS ItemToken, CASE WHEN w.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cwarehouse AS nvarchar(max))), 2)) END AS WarehouseToken, CASE WHEN w.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode1 AS nvarchar(max))), 2)) END AS Spec1Token, CASE WHEN w.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode2 AS nvarchar(max))), 2)) END AS Spec2Token, CASE WHEN w.csernum IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.csernum AS nvarchar(max))), 2)) END AS SerialToken, COALESCE(NULLIF(m.cdescript,N''),w.citemno) AS RowTitle, CAST(w.citemno AS nvarchar(max)) AS citemno, CAST(w.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(w.cspeccode1 AS nvarchar(max)) AS cspeccode1, CAST(w.cspeccode2 AS nvarchar(max)) AS cspeccode2, CAST(w.csernum AS nvarchar(max)) AS csernum, CAST(w.nonhand AS nvarchar(max)) AS nonhand, CAST(w.nonorder AS nvarchar(max)) AS nonorder, CAST(w.nbook AS nvarchar(max)) AS nbook, CAST(w.ninprocess AS nvarchar(max)) AS ninprocess, CAST(w.nallocate AS nvarchar(max)) AS nallocate, CAST(w.nintransit AS nvarchar(max)) AS nintransit, CAST(w.ninterim AS nvarchar(max)) AS ninterim, CAST(w.nrmaonhand AS nvarchar(max)) AS nrmaonhand, CAST(w.nsafestock AS nvarchar(max)) AS nsafestock, CAST(w.nreordpt AS nvarchar(max)) AS nreordpt, CAST(w.nreordqty AS nvarchar(max)) AS nreordqty, CAST(w.nmfgltime AS nvarchar(max)) AS nmfgltime, CONVERT(varchar(33), w.dlastrecv, 126) AS dlastrecv, CONVERT(varchar(33), w.dlastrepd, 126) AS dlastrepd, CAST(w.ncost AS nvarchar(max)) AS ncost, CAST(w.nlrecvcost AS nvarchar(max)) AS nlrecvcost, CAST(m.cmeasure AS nvarchar(max)) AS StockUnit, CAST(m.cclass AS nvarchar(max)) AS ItemClass, CAST(h.cdescript AS nvarchar(max)) AS WarehouseName, CASE WHEN m.citemno IS NULL THEN N'Missing or ambiguous — verify source' ELSE N'Unique current item' END AS ProductContext, CASE WHEN h.cwarehouse IS NULL THEN N'Missing or ambiguous — verify source' ELSE N'Unique current warehouse' END AS WarehouseContext FROM Iciwhs w LEFT JOIN Icitem m ON m.citemno=w.citemno AND 1=(SELECT COUNT(*) FROM Icitem mq WHERE mq.citemno=m.citemno) LEFT JOIN Icwhse h ON h.cwarehouse=w.cwarehouse AND 1=(SELECT COUNT(*) FROM Icwhse hq WHERE hq.cwarehouse=h.cwarehouse) WHERE w.cuid IS NOT NULL AND DATALENGTH(CAST(w.cuid AS nvarchar(max)))>0 AND w.citemno IS NOT NULL AND DATALENGTH(CAST(w.citemno AS nvarchar(max)))>0 AND w.cwarehouse IS NOT NULL AND DATALENGTH(CAST(w.cwarehouse AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Iciwhs wq WHERE wq.cuid=w.cuid AND CASE WHEN wq.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(wq.cuid AS nvarchar(max))), 2)) END=CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END)
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END,N':',CASE WHEN m.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(m.citemno AS nvarchar(max))), 2)) END) AS ProductKey, CAST(m.citemno AS nvarchar(max)) AS citemno, CAST(m.cdescript AS nvarchar(max)) AS cdescript, CAST(m.cfdescript AS nvarchar(max)) AS cfdescript, CAST(m.cbarcode1 AS nvarchar(max)) AS cbarcode1, CAST(m.cbarcode2 AS nvarchar(max)) AS cbarcode2, CAST(m.cclass AS nvarchar(max)) AS cclass, CAST(m.cprodline AS nvarchar(max)) AS cprodline, CAST(m.cstatus AS nvarchar(max)) AS cstatus, CAST(m.cmeasure AS nvarchar(max)) AS cmeasure, CAST(m.csmeasure AS nvarchar(max)) AS csmeasure, CAST(m.cpmeasure AS nvarchar(max)) AS cpmeasure, CAST(m.nqtydec AS nvarchar(max)) AS nqtydec, CAST(m.cvendno AS nvarchar(max)) AS cvendno, CAST(m.cbuyer AS nvarchar(max)) AS cbuyer, CAST(m.lkititem AS nvarchar(max)) AS lkititem, CAST(m.llot AS nvarchar(max)) AS llot, CAST(m.nprice AS nvarchar(max)) AS nprice, CAST(m.nstdcost AS nvarchar(max)) AS nstdcost FROM Iciwhs w INNER JOIN Icitem m ON m.citemno=w.citemno AND 1=(SELECT COUNT(*) FROM Icitem mq WHERE mq.citemno=m.citemno) WHERE w.cuid=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:uid, 2, 2147483647), 2)) AND w.cuid IS NOT NULL AND DATALENGTH(CAST(w.cuid AS nvarchar(max)))>0 AND w.citemno IS NOT NULL AND DATALENGTH(CAST(w.citemno AS nvarchar(max)))>0 AND w.cwarehouse IS NOT NULL AND DATALENGTH(CAST(w.cwarehouse AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Iciwhs wq WHERE wq.cuid=w.cuid AND CASE WHEN wq.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(wq.cuid AS nvarchar(max))), 2)) END=CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END) AND CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END=:uid AND CASE WHEN w.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.citemno AS nvarchar(max))), 2)) END=:item AND CASE WHEN w.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cwarehouse AS nvarchar(max))), 2)) END=:warehouse AND CASE WHEN w.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode1 AS nvarchar(max))), 2)) END=:spec1 AND CASE WHEN w.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode2 AS nvarchar(max))), 2)) END=:spec2 AND CASE WHEN w.csernum IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.csernum AS nvarchar(max))), 2)) END=:serial
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END,N':',CASE WHEN b.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(b.cuid AS nvarchar(max))), 2)) END) AS BinKey, CAST(b.citemno AS nvarchar(max)) AS citemno, CAST(b.cspeccode1 AS nvarchar(max)) AS cspeccode1, CAST(b.cspeccode2 AS nvarchar(max)) AS cspeccode2, CAST(b.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(b.cbin AS nvarchar(max)) AS cbin, CAST(b.ldesignate AS nvarchar(max)) AS ldesignate, CAST(b.nseq AS nvarchar(max)) AS nseq, CAST(b.nonhand AS nvarchar(max)) AS nonhand, CAST(b.nrefillpt AS nvarchar(max)) AS nrefillpt, CAST(b.nrefillqty AS nvarchar(max)) AS nrefillqty, N'SKU/warehouse/specification-wide; not serial allocation' AS BinScope FROM Iciwhs w INNER JOIN Icibin b ON b.citemno=w.citemno AND b.cwarehouse=w.cwarehouse AND CASE WHEN b.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(b.citemno AS nvarchar(max))), 2)) END=CASE WHEN w.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.citemno AS nvarchar(max))), 2)) END AND CASE WHEN b.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(b.cwarehouse AS nvarchar(max))), 2)) END=CASE WHEN w.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cwarehouse AS nvarchar(max))), 2)) END AND CASE WHEN b.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(b.cspeccode1 AS nvarchar(max))), 2)) END=CASE WHEN w.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode1 AS nvarchar(max))), 2)) END AND CASE WHEN b.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(b.cspeccode2 AS nvarchar(max))), 2)) END=CASE WHEN w.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode2 AS nvarchar(max))), 2)) END WHERE w.cuid=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:uid, 2, 2147483647), 2)) AND w.cuid IS NOT NULL AND DATALENGTH(CAST(w.cuid AS nvarchar(max)))>0 AND w.citemno IS NOT NULL AND DATALENGTH(CAST(w.citemno AS nvarchar(max)))>0 AND w.cwarehouse IS NOT NULL AND DATALENGTH(CAST(w.cwarehouse AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Iciwhs wq WHERE wq.cuid=w.cuid AND CASE WHEN wq.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(wq.cuid AS nvarchar(max))), 2)) END=CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END) AND CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END=:uid AND CASE WHEN w.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.citemno AS nvarchar(max))), 2)) END=:item AND CASE WHEN w.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cwarehouse AS nvarchar(max))), 2)) END=:warehouse AND CASE WHEN w.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode1 AS nvarchar(max))), 2)) END=:spec1 AND CASE WHEN w.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode2 AS nvarchar(max))), 2)) END=:spec2 AND CASE WHEN w.csernum IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.csernum AS nvarchar(max))), 2)) END=:serial AND NOT EXISTS (SELECT 1 FROM Icibin bx WHERE bx.citemno=w.citemno AND bx.cwarehouse=w.cwarehouse AND CASE WHEN bx.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(bx.citemno AS nvarchar(max))), 2)) END=CASE WHEN w.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.citemno AS nvarchar(max))), 2)) END AND CASE WHEN bx.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(bx.cwarehouse AS nvarchar(max))), 2)) END=CASE WHEN w.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cwarehouse AS nvarchar(max))), 2)) END AND CASE WHEN bx.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(bx.cspeccode1 AS nvarchar(max))), 2)) END=CASE WHEN w.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode1 AS nvarchar(max))), 2)) END AND CASE WHEN bx.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(bx.cspeccode2 AS nvarchar(max))), 2)) END=CASE WHEN w.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode2 AS nvarchar(max))), 2)) END AND (bx.cuid IS NULL OR DATALENGTH(CAST(bx.cuid AS nvarchar(max)))=0 OR NOT (1=(SELECT COUNT(*) FROM Icibin bxq WHERE bxq.cuid=bx.cuid AND CASE WHEN bxq.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(bxq.cuid AS nvarchar(max))), 2)) END=CASE WHEN bx.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(bx.cuid AS nvarchar(max))), 2)) END))))
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "AccountMate SQL/Express — authorised company database",
"id": "AD23CAE4-3239-548A-8EE5-675F4DCB05C6",
"kind": "sqlServer",
"requiredObjects": [
"Iciwhs",
"Icitem",
"Icwhse",
"Icibin"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "AccountMate SQL/Express",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "B542C1D5-7035-5511-B5B4-C9C36E386D64",
"key": "citemno",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"id": "0C9C2206-6DAE-5F2C-A684-F38A0B54F3A9",
"mappings": [
{
"commonFieldKey": "",
"key": "StockKey",
"label": "Hidden full stock identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StockKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemToken",
"label": "Hidden item context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ItemToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseToken",
"label": "Hidden warehouse context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WarehouseToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Spec1Token",
"label": "Hidden specification1 context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Spec1Token",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Spec2Token",
"label": "Hidden specification2 context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Spec2Token",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SerialToken",
"label": "Hidden serial context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SerialToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RowTitle",
"label": "Card title",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RowTitle",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "citemno",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "citemno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cwarehouse",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cwarehouse",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cspeccode1",
"label": "Specification code1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cspeccode1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cspeccode2",
"label": "Specification code2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cspeccode2",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "csernum",
"label": "Serial number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csernum",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nonhand",
"label": "On-hand quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nonhand",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nonorder",
"label": "On-order quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nonorder",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nbook",
"label": "Booked quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nbook",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ninprocess",
"label": "In-process quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ninprocess",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nallocate",
"label": "Allocated quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nallocate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nintransit",
"label": "In-transit quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nintransit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ninterim",
"label": "Interim quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ninterim",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nrmaonhand",
"label": "RMA on-hand quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nrmaonhand",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nsafestock",
"label": "Safety stock (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nsafestock",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nreordpt",
"label": "Reorder point (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nreordpt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nreordqty",
"label": "Reorder quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nreordqty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nmfgltime",
"label": "Manufacturing lead time (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nmfgltime",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dlastrecv",
"label": "Recorded last receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "dlastrecv",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dlastrepd",
"label": "Recorded last repair date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "dlastrepd",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ncost",
"label": "Cost by native method (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ncost",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nlrecvcost",
"label": "Last receipt cost (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nlrecvcost",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StockUnit",
"label": "Current stock unit — verify basis",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StockUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ItemClass",
"label": "Current item class",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ItemClass",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "WarehouseName",
"label": "Current warehouse name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WarehouseName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductContext",
"label": "Current product context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProductContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseContext",
"label": "Current warehouse context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WarehouseContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Warehouse stock",
"primaryKey": "StockKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"citemno",
"cwarehouse",
"cspeccode1",
"cspeccode2",
"csernum",
"nonhand",
"nonorder",
"nbook",
"ninprocess",
"nallocate",
"nintransit",
"ninterim",
"nrmaonhand",
"nsafestock",
"nreordpt",
"nreordqty",
"nmfgltime",
"dlastrecv",
"dlastrepd",
"ncost",
"nlrecvcost",
"StockUnit",
"ItemClass",
"WarehouseName",
"ProductContext",
"WarehouseContext"
],
"sourceID": "AD23CAE4-3239-548A-8EE5-675F4DCB05C6",
"sqlQuery": "SELECT CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END AS StockKey, CASE WHEN w.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.citemno AS nvarchar(max))), 2)) END AS ItemToken, CASE WHEN w.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cwarehouse AS nvarchar(max))), 2)) END AS WarehouseToken, CASE WHEN w.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode1 AS nvarchar(max))), 2)) END AS Spec1Token, CASE WHEN w.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode2 AS nvarchar(max))), 2)) END AS Spec2Token, CASE WHEN w.csernum IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.csernum AS nvarchar(max))), 2)) END AS SerialToken, COALESCE(NULLIF(m.cdescript,N''),w.citemno) AS RowTitle, CAST(w.citemno AS nvarchar(max)) AS citemno, CAST(w.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(w.cspeccode1 AS nvarchar(max)) AS cspeccode1, CAST(w.cspeccode2 AS nvarchar(max)) AS cspeccode2, CAST(w.csernum AS nvarchar(max)) AS csernum, CAST(w.nonhand AS nvarchar(max)) AS nonhand, CAST(w.nonorder AS nvarchar(max)) AS nonorder, CAST(w.nbook AS nvarchar(max)) AS nbook, CAST(w.ninprocess AS nvarchar(max)) AS ninprocess, CAST(w.nallocate AS nvarchar(max)) AS nallocate, CAST(w.nintransit AS nvarchar(max)) AS nintransit, CAST(w.ninterim AS nvarchar(max)) AS ninterim, CAST(w.nrmaonhand AS nvarchar(max)) AS nrmaonhand, CAST(w.nsafestock AS nvarchar(max)) AS nsafestock, CAST(w.nreordpt AS nvarchar(max)) AS nreordpt, CAST(w.nreordqty AS nvarchar(max)) AS nreordqty, CAST(w.nmfgltime AS nvarchar(max)) AS nmfgltime, CONVERT(varchar(33), w.dlastrecv, 126) AS dlastrecv, CONVERT(varchar(33), w.dlastrepd, 126) AS dlastrepd, CAST(w.ncost AS nvarchar(max)) AS ncost, CAST(w.nlrecvcost AS nvarchar(max)) AS nlrecvcost, CAST(m.cmeasure AS nvarchar(max)) AS StockUnit, CAST(m.cclass AS nvarchar(max)) AS ItemClass, CAST(h.cdescript AS nvarchar(max)) AS WarehouseName, CASE WHEN m.citemno IS NULL THEN N'Missing or ambiguous — verify source' ELSE N'Unique current item' END AS ProductContext, CASE WHEN h.cwarehouse IS NULL THEN N'Missing or ambiguous — verify source' ELSE N'Unique current warehouse' END AS WarehouseContext FROM Iciwhs w LEFT JOIN Icitem m ON m.citemno=w.citemno AND 1=(SELECT COUNT(*) FROM Icitem mq WHERE mq.citemno=m.citemno) LEFT JOIN Icwhse h ON h.cwarehouse=w.cwarehouse AND 1=(SELECT COUNT(*) FROM Icwhse hq WHERE hq.cwarehouse=h.cwarehouse) WHERE w.cuid IS NOT NULL AND DATALENGTH(CAST(w.cuid AS nvarchar(max)))>0 AND w.citemno IS NOT NULL AND DATALENGTH(CAST(w.citemno AS nvarchar(max)))>0 AND w.cwarehouse IS NOT NULL AND DATALENGTH(CAST(w.cwarehouse AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Iciwhs wq WHERE wq.cuid=w.cuid AND CASE WHEN wq.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(wq.cuid AS nvarchar(max))), 2)) END=CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END)",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "AccountMate SQL/Express",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "B542C1D5-7035-5511-B5B4-C9C36E386D64",
"key": "citemno",
"type": "text"
},
{
"direction": "ascending",
"id": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
"key": "ProductKey",
"type": "text"
}
],
"id": "CD89255C-6711-54E9-BDAB-10CCDAAD0A3D",
"mappings": [
{
"commonFieldKey": "",
"key": "ProductKey",
"label": "Hidden parent-owned product identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentKey",
"label": "Hidden full parent identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "citemno",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "citemno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cdescript",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cdescript",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cfdescript",
"label": "Foreign description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cfdescript",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbarcode1",
"label": "Barcode 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbarcode1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbarcode2",
"label": "Barcode 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbarcode2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cclass",
"label": "Item class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cclass",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cprodline",
"label": "Product line code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cprodline",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cstatus",
"label": "Status code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cstatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cmeasure",
"label": "Stock unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cmeasure",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "csmeasure",
"label": "Sales unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "csmeasure",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cpmeasure",
"label": "Purchase unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cpmeasure",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nqtydec",
"label": "Quantity decimal places",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nqtydec",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cvendno",
"label": "Inventory vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cvendno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbuyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbuyer",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lkititem",
"label": "Kit item (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "lkititem",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "llot",
"label": "Lot controlled (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "llot",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nprice",
"label": "Unit price (source value)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nprice",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nstdcost",
"label": "Standard cost (source value)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nstdcost",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Current product",
"primaryKey": "ProductKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "StockKey",
"id": "1142E032-41C6-5B3B-8E77-7C7F803CE2A0",
"name": "uid",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ItemToken",
"id": "0E7EC32E-28DD-560A-9222-0F12B4749C05",
"name": "item",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "WarehouseToken",
"id": "C52D3D32-A984-5157-BB61-247FC69E0927",
"name": "warehouse",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "Spec1Token",
"id": "3718CC0C-B5DD-5322-AC9D-5D67BB253A08",
"name": "spec1",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "Spec2Token",
"id": "3D322305-F664-50F7-8ABC-1675F9492EC2",
"name": "spec2",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "SerialToken",
"id": "7F51437C-C23F-548E-8D5D-904BAFCBD74E",
"name": "serial",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"citemno",
"cdescript",
"cfdescript",
"cbarcode1",
"cbarcode2",
"cclass",
"cprodline",
"cstatus",
"cmeasure",
"csmeasure",
"cpmeasure",
"nqtydec",
"cvendno",
"cbuyer",
"lkititem",
"llot",
"nprice",
"nstdcost"
],
"sourceID": "AD23CAE4-3239-548A-8EE5-675F4DCB05C6",
"sqlQuery": "SELECT CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END,N':',CASE WHEN m.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(m.citemno AS nvarchar(max))), 2)) END) AS ProductKey, CAST(m.citemno AS nvarchar(max)) AS citemno, CAST(m.cdescript AS nvarchar(max)) AS cdescript, CAST(m.cfdescript AS nvarchar(max)) AS cfdescript, CAST(m.cbarcode1 AS nvarchar(max)) AS cbarcode1, CAST(m.cbarcode2 AS nvarchar(max)) AS cbarcode2, CAST(m.cclass AS nvarchar(max)) AS cclass, CAST(m.cprodline AS nvarchar(max)) AS cprodline, CAST(m.cstatus AS nvarchar(max)) AS cstatus, CAST(m.cmeasure AS nvarchar(max)) AS cmeasure, CAST(m.csmeasure AS nvarchar(max)) AS csmeasure, CAST(m.cpmeasure AS nvarchar(max)) AS cpmeasure, CAST(m.nqtydec AS nvarchar(max)) AS nqtydec, CAST(m.cvendno AS nvarchar(max)) AS cvendno, CAST(m.cbuyer AS nvarchar(max)) AS cbuyer, CAST(m.lkititem AS nvarchar(max)) AS lkititem, CAST(m.llot AS nvarchar(max)) AS llot, CAST(m.nprice AS nvarchar(max)) AS nprice, CAST(m.nstdcost AS nvarchar(max)) AS nstdcost FROM Iciwhs w INNER JOIN Icitem m ON m.citemno=w.citemno AND 1=(SELECT COUNT(*) FROM Icitem mq WHERE mq.citemno=m.citemno) WHERE w.cuid=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:uid, 2, 2147483647), 2)) AND w.cuid IS NOT NULL AND DATALENGTH(CAST(w.cuid AS nvarchar(max)))>0 AND w.citemno IS NOT NULL AND DATALENGTH(CAST(w.citemno AS nvarchar(max)))>0 AND w.cwarehouse IS NOT NULL AND DATALENGTH(CAST(w.cwarehouse AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Iciwhs wq WHERE wq.cuid=w.cuid AND CASE WHEN wq.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(wq.cuid AS nvarchar(max))), 2)) END=CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END) AND CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END=:uid AND CASE WHEN w.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.citemno AS nvarchar(max))), 2)) END=:item AND CASE WHEN w.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cwarehouse AS nvarchar(max))), 2)) END=:warehouse AND CASE WHEN w.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode1 AS nvarchar(max))), 2)) END=:spec1 AND CASE WHEN w.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode2 AS nvarchar(max))), 2)) END=:spec2 AND CASE WHEN w.csernum IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.csernum AS nvarchar(max))), 2)) END=:serial",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "AccountMate SQL/Express",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "C0C269F5-47F8-58C5-B0B4-F1F4CA958661",
"key": "nseq",
"type": "number"
},
{
"direction": "ascending",
"id": "CE8B032D-AC6F-5BF3-A54F-BC412C6E9216",
"key": "BinKey",
"type": "text"
}
],
"id": "C7E5E867-49D2-5206-809A-B0782A328951",
"mappings": [
{
"commonFieldKey": "",
"key": "BinKey",
"label": "Hidden parent-owned bin identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BinKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentKey",
"label": "Hidden full parent identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "citemno",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "citemno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cspeccode1",
"label": "Specification code1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cspeccode1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cspeccode2",
"label": "Specification code2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cspeccode2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cwarehouse",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cwarehouse",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cbin",
"label": "Bin code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "cbin",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ldesignate",
"label": "Designated bin (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ldesignate",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nseq",
"label": "Native bin sequence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nseq",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nonhand",
"label": "Bin on-hand quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nonhand",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nrefillpt",
"label": "Bin refill point (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nrefillpt",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nrefillqty",
"label": "Bin refill quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "nrefillqty",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BinScope",
"label": "Scope — not a serial allocation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BinScope",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "SKU-wide warehouse bins",
"primaryKey": "BinKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "StockKey",
"id": "1142E032-41C6-5B3B-8E77-7C7F803CE2A0",
"name": "uid",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ItemToken",
"id": "0E7EC32E-28DD-560A-9222-0F12B4749C05",
"name": "item",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "WarehouseToken",
"id": "C52D3D32-A984-5157-BB61-247FC69E0927",
"name": "warehouse",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "Spec1Token",
"id": "3718CC0C-B5DD-5322-AC9D-5D67BB253A08",
"name": "spec1",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "Spec2Token",
"id": "3D322305-F664-50F7-8ABC-1675F9492EC2",
"name": "spec2",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "SerialToken",
"id": "7F51437C-C23F-548E-8D5D-904BAFCBD74E",
"name": "serial",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"citemno",
"cspeccode1",
"cspeccode2",
"cwarehouse",
"cbin",
"ldesignate",
"nseq",
"nonhand",
"nrefillpt",
"nrefillqty",
"BinScope"
],
"sourceID": "AD23CAE4-3239-548A-8EE5-675F4DCB05C6",
"sqlQuery": "SELECT CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END AS ParentKey, CONCAT(CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END,N':',CASE WHEN b.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(b.cuid AS nvarchar(max))), 2)) END) AS BinKey, CAST(b.citemno AS nvarchar(max)) AS citemno, CAST(b.cspeccode1 AS nvarchar(max)) AS cspeccode1, CAST(b.cspeccode2 AS nvarchar(max)) AS cspeccode2, CAST(b.cwarehouse AS nvarchar(max)) AS cwarehouse, CAST(b.cbin AS nvarchar(max)) AS cbin, CAST(b.ldesignate AS nvarchar(max)) AS ldesignate, CAST(b.nseq AS nvarchar(max)) AS nseq, CAST(b.nonhand AS nvarchar(max)) AS nonhand, CAST(b.nrefillpt AS nvarchar(max)) AS nrefillpt, CAST(b.nrefillqty AS nvarchar(max)) AS nrefillqty, N'SKU/warehouse/specification-wide; not serial allocation' AS BinScope FROM Iciwhs w INNER JOIN Icibin b ON b.citemno=w.citemno AND b.cwarehouse=w.cwarehouse AND CASE WHEN b.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(b.citemno AS nvarchar(max))), 2)) END=CASE WHEN w.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.citemno AS nvarchar(max))), 2)) END AND CASE WHEN b.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(b.cwarehouse AS nvarchar(max))), 2)) END=CASE WHEN w.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cwarehouse AS nvarchar(max))), 2)) END AND CASE WHEN b.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(b.cspeccode1 AS nvarchar(max))), 2)) END=CASE WHEN w.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode1 AS nvarchar(max))), 2)) END AND CASE WHEN b.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(b.cspeccode2 AS nvarchar(max))), 2)) END=CASE WHEN w.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode2 AS nvarchar(max))), 2)) END WHERE w.cuid=CONVERT(nvarchar(max), CONVERT(varbinary(max), SUBSTRING(:uid, 2, 2147483647), 2)) AND w.cuid IS NOT NULL AND DATALENGTH(CAST(w.cuid AS nvarchar(max)))>0 AND w.citemno IS NOT NULL AND DATALENGTH(CAST(w.citemno AS nvarchar(max)))>0 AND w.cwarehouse IS NOT NULL AND DATALENGTH(CAST(w.cwarehouse AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM Iciwhs wq WHERE wq.cuid=w.cuid AND CASE WHEN wq.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(wq.cuid AS nvarchar(max))), 2)) END=CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END) AND CASE WHEN w.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cuid AS nvarchar(max))), 2)) END=:uid AND CASE WHEN w.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.citemno AS nvarchar(max))), 2)) END=:item AND CASE WHEN w.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cwarehouse AS nvarchar(max))), 2)) END=:warehouse AND CASE WHEN w.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode1 AS nvarchar(max))), 2)) END=:spec1 AND CASE WHEN w.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode2 AS nvarchar(max))), 2)) END=:spec2 AND CASE WHEN w.csernum IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.csernum AS nvarchar(max))), 2)) END=:serial AND NOT EXISTS (SELECT 1 FROM Icibin bx WHERE bx.citemno=w.citemno AND bx.cwarehouse=w.cwarehouse AND CASE WHEN bx.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(bx.citemno AS nvarchar(max))), 2)) END=CASE WHEN w.citemno IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.citemno AS nvarchar(max))), 2)) END AND CASE WHEN bx.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(bx.cwarehouse AS nvarchar(max))), 2)) END=CASE WHEN w.cwarehouse IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cwarehouse AS nvarchar(max))), 2)) END AND CASE WHEN bx.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(bx.cspeccode1 AS nvarchar(max))), 2)) END=CASE WHEN w.cspeccode1 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode1 AS nvarchar(max))), 2)) END AND CASE WHEN bx.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(bx.cspeccode2 AS nvarchar(max))), 2)) END=CASE WHEN w.cspeccode2 IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(w.cspeccode2 AS nvarchar(max))), 2)) END AND (bx.cuid IS NULL OR DATALENGTH(CAST(bx.cuid AS nvarchar(max)))=0 OR NOT (1=(SELECT COUNT(*) FROM Icibin bxq WHERE bxq.cuid=bx.cuid AND CASE WHEN bxq.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(bxq.cuid AS nvarchar(max))), 2)) END=CASE WHEN bx.cuid IS NULL THEN N'N' ELSE CONCAT(N'V',CONVERT(varchar(max), CONVERT(varbinary(max), CAST(bx.cuid AS nvarchar(max))), 2)) END))))",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "8C56715F-E457-52DB-8055-171F540FDDFE",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "EF01573E-8F7F-50FE-9F44-D20265918DC8",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "CD89255C-6711-54E9-BDAB-10CCDAAD0A3D",
"title": "Current product",
"urlKey": ""
},
{
"id": "758C38AF-C251-5CC0-876A-C8B7309ECFB4",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "B8CDB326-EB14-52DD-979D-AA9789559E2A",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "C7E5E867-49D2-5206-809A-B0782A328951",
"title": "Warehouse bins — SKU-wide",
"urlKey": ""
}
],
"badgeKey": "cwarehouse",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cspeccode1",
"label": "Specification code1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cspeccode2",
"label": "Specification code2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "csernum",
"label": "Serial number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nonhand",
"label": "On-hand quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nonorder",
"label": "On-order quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nbook",
"label": "Booked quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StockUnit",
"label": "Current stock unit — verify basis",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ItemClass",
"label": "Current item class",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "0C9C2206-6DAE-5F2C-A684-F38A0B54F3A9",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Product and warehouse — current context",
"detailRole": "information",
"isVisible": true,
"key": "citemno",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current context",
"detailRole": "information",
"isVisible": true,
"key": "cwarehouse",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current context",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseName",
"label": "Current warehouse name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current context",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseContext",
"label": "Current warehouse context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current context",
"detailRole": "information",
"isVisible": true,
"key": "ItemClass",
"label": "Current item class",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current context",
"detailRole": "information",
"isVisible": true,
"key": "ProductContext",
"label": "Current product context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Specifications and serial — no consolidation",
"detailRole": "information",
"isVisible": true,
"key": "cspeccode1",
"label": "Specification code1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Specifications and serial — no consolidation",
"detailRole": "information",
"isVisible": true,
"key": "cspeccode2",
"label": "Specification code2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Specifications and serial — no consolidation",
"detailRole": "information",
"isVisible": true,
"key": "csernum",
"label": "Serial number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored quantities — NOT available to sell",
"detailRole": "information",
"isVisible": true,
"key": "StockUnit",
"label": "Current stock unit — verify basis",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored quantities — NOT available to sell",
"detailRole": "information",
"isVisible": true,
"key": "nonhand",
"label": "On-hand quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored quantities — NOT available to sell",
"detailRole": "information",
"isVisible": true,
"key": "nonorder",
"label": "On-order quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored quantities — NOT available to sell",
"detailRole": "information",
"isVisible": true,
"key": "nbook",
"label": "Booked quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored quantities — NOT available to sell",
"detailRole": "information",
"isVisible": true,
"key": "nintransit",
"label": "In-transit quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored quantities — NOT available to sell",
"detailRole": "information",
"isVisible": true,
"key": "ninterim",
"label": "Interim quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored quantities — NOT available to sell",
"detailRole": "information",
"isVisible": true,
"key": "nrmaonhand",
"label": "RMA on-hand quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "WIP quantities — wider item/warehouse scope",
"detailRole": "information",
"isVisible": true,
"key": "ninprocess",
"label": "In-process quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "WIP quantities — wider item/warehouse scope",
"detailRole": "information",
"isVisible": true,
"key": "nallocate",
"label": "Allocated quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Replenishment settings — not a purchase proposal",
"detailRole": "information",
"isVisible": true,
"key": "nsafestock",
"label": "Safety stock (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Replenishment settings — not a purchase proposal",
"detailRole": "information",
"isVisible": true,
"key": "nreordpt",
"label": "Reorder point (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Replenishment settings — not a purchase proposal",
"detailRole": "information",
"isVisible": true,
"key": "nreordqty",
"label": "Reorder quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Replenishment settings — not a purchase proposal",
"detailRole": "information",
"isVisible": true,
"key": "nmfgltime",
"label": "Manufacturing lead time (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded receipt and repair dates",
"detailRole": "information",
"isVisible": true,
"key": "dlastrecv",
"label": "Recorded last receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded receipt and repair dates",
"detailRole": "information",
"isVisible": true,
"key": "dlastrepd",
"label": "Recorded last repair date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded costs — currency and unit basis unverified",
"detailRole": "information",
"isVisible": true,
"key": "ncost",
"label": "Cost by native method (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded costs — currency and unit basis unverified",
"detailRole": "information",
"isVisible": true,
"key": "nlrecvcost",
"label": "Last receipt cost (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "5202A74D-FDC5-5DDF-AD67-7126118A2DC5",
"openFilters": [
{
"id": "E6550558-2E6C-5924-B1F3-65A53AAF9E97",
"includeAllOption": false,
"key": "cwarehouse",
"title": "Choose authorised warehouse",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "B542C1D5-7035-5511-B5B4-C9C36E386D64",
"key": "citemno",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "citemno",
"systemImage": "doc.text",
"title": "Warehouse stock",
"titleKey": "RowTitle"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cclass",
"label": "Item class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cmeasure",
"label": "Stock unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "lkititem",
"label": "Kit item (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "llot",
"label": "Lot controlled (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "CD89255C-6711-54E9-BDAB-10CCDAAD0A3D",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current product identity",
"detailRole": "information",
"isVisible": true,
"key": "cdescript",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current product identity",
"detailRole": "information",
"isVisible": true,
"key": "citemno",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current product identity",
"detailRole": "information",
"isVisible": true,
"key": "cfdescript",
"label": "Foreign description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current product identity",
"detailRole": "information",
"isVisible": true,
"key": "cbarcode1",
"label": "Barcode 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current product identity",
"detailRole": "information",
"isVisible": true,
"key": "cbarcode2",
"label": "Barcode 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Classification and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "cclass",
"label": "Item class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Classification and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "cprodline",
"label": "Product line code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Classification and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "cstatus",
"label": "Status code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Classification and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "cvendno",
"label": "Inventory vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Classification and purchasing codes",
"detailRole": "information",
"isVisible": true,
"key": "cbuyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current units — no conversion",
"detailRole": "information",
"isVisible": true,
"key": "cmeasure",
"label": "Stock unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current units — no conversion",
"detailRole": "information",
"isVisible": true,
"key": "csmeasure",
"label": "Sales unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current units — no conversion",
"detailRole": "information",
"isVisible": true,
"key": "cpmeasure",
"label": "Purchase unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current units — no conversion",
"detailRole": "information",
"isVisible": true,
"key": "nqtydec",
"label": "Quantity decimal places",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Control flags — recorded values",
"detailRole": "information",
"isVisible": true,
"key": "lkititem",
"label": "Kit item (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Control flags — recorded values",
"detailRole": "information",
"isVisible": true,
"key": "llot",
"label": "Lot controlled (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded price/cost — currency not supplied",
"detailRole": "information",
"isVisible": true,
"key": "nprice",
"label": "Unit price (source value)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded price/cost — currency not supplied",
"detailRole": "information",
"isVisible": true,
"key": "nstdcost",
"label": "Standard cost (source value)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "537F0F65-D1A4-5E62-AA01-68891542DA09",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "B542C1D5-7035-5511-B5B4-C9C36E386D64",
"key": "citemno",
"type": "text"
},
{
"direction": "ascending",
"id": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
"key": "ProductKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "citemno",
"systemImage": "doc.text",
"title": "Current product",
"titleKey": "cdescript"
},
{
"actions": [],
"badgeKey": "cwarehouse",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ldesignate",
"label": "Designated bin (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nonhand",
"label": "Bin on-hand quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nrefillpt",
"label": "Bin refill point (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nrefillqty",
"label": "Bin refill quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "C7E5E867-49D2-5206-809A-B0782A328951",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "SKU-wide bins — NOT a serial allocation",
"detailRole": "information",
"isVisible": true,
"key": "BinScope",
"label": "Scope — not a serial allocation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "SKU-wide bins — NOT a serial allocation",
"detailRole": "information",
"isVisible": true,
"key": "citemno",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "SKU-wide bins — NOT a serial allocation",
"detailRole": "information",
"isVisible": true,
"key": "cwarehouse",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "SKU-wide bins — NOT a serial allocation",
"detailRole": "information",
"isVisible": true,
"key": "cspeccode1",
"label": "Specification code1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "SKU-wide bins — NOT a serial allocation",
"detailRole": "information",
"isVisible": true,
"key": "cspeccode2",
"label": "Specification code2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "SKU-wide bins — NOT a serial allocation",
"detailRole": "information",
"isVisible": true,
"key": "cbin",
"label": "Bin code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bin quantity and refill settings",
"detailRole": "information",
"isVisible": true,
"key": "nonhand",
"label": "Bin on-hand quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bin quantity and refill settings",
"detailRole": "information",
"isVisible": true,
"key": "nrefillpt",
"label": "Bin refill point (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded bin quantity and refill settings",
"detailRole": "information",
"isVisible": true,
"key": "nrefillqty",
"label": "Bin refill quantity (source)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native bin relationship and sequence",
"detailRole": "information",
"isVisible": true,
"key": "ldesignate",
"label": "Designated bin (native flag)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native bin relationship and sequence",
"detailRole": "information",
"isVisible": true,
"key": "nseq",
"label": "Native bin sequence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "1BFB714C-FEFB-5E9F-8B13-7EDF57873094",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "C0C269F5-47F8-58C5-B0B4-F1F4CA958661",
"key": "nseq",
"type": "number"
},
{
"direction": "ascending",
"id": "CE8B032D-AC6F-5BF3-A54F-BC412C6E9216",
"key": "BinKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "citemno",
"systemImage": "doc.text",
"title": "SKU-wide warehouse bins",
"titleKey": "cbin"
}
],
"relations": [
{
"childDatasetID": "CD89255C-6711-54E9-BDAB-10CCDAAD0A3D",
"childKey": "ParentKey",
"id": "EF01573E-8F7F-50FE-9F44-D20265918DC8",
"name": "Current product",
"parentDatasetID": "0C9C2206-6DAE-5F2C-A684-F38A0B54F3A9",
"parentKey": "StockKey"
},
{
"childDatasetID": "C7E5E867-49D2-5206-809A-B0782A328951",
"childKey": "ParentKey",
"id": "B8CDB326-EB14-52DD-979D-AA9789559E2A",
"name": "Warehouse bins — SKU-wide",
"parentDatasetID": "0C9C2206-6DAE-5F2C-A684-F38A0B54F3A9",
"parentKey": "StockKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "AccountMate for SQL/Express",
"changelog": "Initial Pro warehouse stock with current product and SKU-wide bins; native fictional complete cards and representative Details. Not a real ERP connection test.",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-11T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.\n\nFor warehouse, purchasing, production and management teams: choose a warehouse and inspect the recorded on-hand, on-order, booked, in-transit and work-in-process quantities alongside specifications, serial context, current stock unit and replenishment settings. Open Details for receipt/repair dates and recorded costs. Two sub-buttons load the current product dossier and that SKU's warehouse-bin positions only when requested.\n\nWhy Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.\n\nPro: one source, three bounded live lists with same-row Details and two lazy sub-buttons. No widgets, computed totals or periodic refresh. Warehouse selection is mandatory at opening before the final 2,000-row root cap; product/bin reads have 500-row caps. Existing workspace resources count. Search and local filters cover loaded rows only, not a complete inventory. Native numeric values are exact source strings; local quantity sorting/filtering is textual. A row cap is not a performance guarantee.\n\nSTOCK MEANING: stored source quantities and thresholds are kept separate. No available-to-sell formula, aggregate by item/warehouse, unit conversion, inferred stock valuation, MRP or automatic purchase suggestion. WIP/in-process and allocated descriptions use item/warehouse scope, wider than a serial/specification row; booked/on-order descriptions use item/specification/warehouse. Values may repeat across serial rows: NEVER sum or subtract them. Current unit is optional item-master context, not proof of installed quantity basis. Lead-time unit is unverified, not assumed days. Zero, negative, unknown and NULL values remain distinct; NULL is not zero. No vendor recalc procedure or formula is executed.\n\nBINS: explicitly SKU/warehouse/specification-wide, NOT a selected serial's allocation. Icibin has no serial field. Parent UID and unchanged item/warehouse/spec1/spec2/serial context are revalidated before child reads. All matching bin positions are read lazily, not merged or allocated to a serial. A missing/empty/ambiguous bin identity blocks the whole bin branch; an empty result does not prove zero stock. Designation is a native relationship flag, not a picked master: 0=not user-set, 1=user-set; unknown remains unknown. Native min(nseq) is the documented master-bin rule, but no first-bin, tie resolution or installed uniqueness is inferred.\n\nCURRENT CONTEXT: unique current Icitem/Icwhse enrich the row; absent or duplicate masters preserve stock with a context warning, without arbitrary names or fanout. Current product child requires a unique master; missing context may yield no child without removing root stock. Same SKU in different serial rows retains different hidden parent-owned child keys. Opaque full cuid is the warehouse/bin row identity, NOT item+warehouse. UTF16 encoded context preserves NULL vs blank, Unicode and spaces through app parent-value trimming. Incomplete/duplicate stock identities are excluded, not silently selected; exclusions do not establish a complete inventory.\n\nCOSTS AND PRICES: recorded source text with no currency symbol. Selected tables establish neither ISO currency nor installed cost/price unit basis. Actual gallery must label these limits. No FX/tax/discount, valuation or valid-quote calculation. Current product price and standard cost are master values, not current warehouse receipt cost or historical transaction snapshots. Confirm basis with the administrator before financial use.\n\nCOMPATIBILITY: own complete historical IC12 reference, 15 February 2021, table-specific fields/keys and quantity-dimension meanings. Not current SQL14 or AccountMate Enterprise certification. AMTBL Required/widths are form metadata, not installed DDL/nullability. SQL Server 2012+ for CONCAT; binary token conversion uses SQL Server UTF16 representation. Owner is UNKNOWN: administrator must confirm exactly one readable Iciwhs, Icitem, Icwhse and Icibin resolved identically by login/default schema on Android/iOS. Android metadata can prefer dbo; iOS SQL uses login/default resolution. Ambiguous owners must be replaced with confirmed qualified objects in Studio, then bounded read tests repeated. Import is not claimed to automatically reject duplicate owners. Check installed edition/types, full keys, collation, units/currency, results, indexes/query plan and response times. Native key candidate checks can use equality lookups but bounded output is not a cheap query guarantee. Narrow an authorised reporting source if needed.\n\nSECURITY: company-authorised SELECT-only reporting connection; direct SQL does not inherit ERP ACL. Filters are not permissions. No credentials/server address/business rows in the package. Documentary and adapted synthetic checks do not certify a real ERP/SQL Server/iOS installation, source permissions, performance or subscription purchase. Unofficial, not endorsed by AccountMate.\n\nDocumentation: https://www.accountmateportal.com/xasset/techdoc/amsql12_ic_drg.pdf\n\nGallery: Eight original native Cifru DEMO images show complete stock, current-product and SKU-wide-bin cards, both actually opened sub-buttons and representative Details. All business values are invented; no AccountMate installation was connected. The configuration retains55 useful Detail positions (26stock,18product,11bin); all55 were checked against full private overlapping native continuations. The selected gallery shows52 positions: only current warehouse name, warehouse context and product context remain in private Details1, not these eight images. Financial basis and wider WIP/bin scope warnings are visible. No field was removed, screenshot retouched or row substituted to fit eight. Sixteen original PNG/XML pairs, frozen invented input and silent RAW are retained for future videos; whole RAW/Home/adverse NULL-placeholder lists/redundant continuations are private and not video-approved. Root-card action labels scroll horizontally; both full action labels are visible in Details4. Pro resource requirements were checked; filming uses a Pro test entitlement, not a purchase test. This proves native synthetic UI/action traversal, not source SQL, installed ERP/iOS/DDL/owner/collation, NULL/decimal/date conversion, units/currency, ACL, completeness or performance.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "A6E42535-E7CB-5495-9E2E-48D4A33741F0",
"rootButtonCount": 1,
"summary": "Choose a warehouse; inspect source quantities and replenishment settings, then product and SKU-wide bins on demand.",
"tags": [
"AccountMate",
"SQL Server",
"Inventory",
"Warehouse",
"Stock",
"Purchasing",
"Production",
"Pro"
],
"title": "Warehouse stock, current product and SKU-wide bins — Pro"
}
}