Komponen inventaris, dimensi dan barang — Pro
Komponen kuantitas per gudang/varian, satuan inventaris, master dan nama produk; bukan stok tersedia.
TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA.
Untuk gudang, pembelian dan manajer: pilih partisi, perusahaan, lokasi dan gudang; periksa setiap baris inventaris beserta varian standar dan satuan inventaris. Lihat kuantitas yang dibukukan finansial, penerimaan/pengeluaran fisik belum dibukukan, registrasi dan picked secara terpisah. Barang membuka master serta konteks perencanaan saat ini; Nama produk membuka nama/deskripsi menurut bahasa sumber. 43 posisi berguna dalam Detil. Bukan laporan stok tersedia atau nilai persediaan.
Mengapa Cifru? Sesuaikan konfigurasi dengan cara kerja Anda. Pilih kolom, filter, dan rincian yang diperlukan, lalu tampilkan informasi di ponsel yang mungkin belum tersedia di aplikasi seluler bawaan perangkat lunak bisnis Anda. Pilihannya bergantung pada data yang dapat diakses dari sumber yang Anda berwenang gunakan dan paket Cifru Anda.
EDISI: AX 2012 R3 on-premises SQL Server, untuk instalasi lama yang sudah ada; bukan Dynamics 365, Business Central atau SQL cloud. Dukungan diperpanjang berakhir 11 Januari 2023. Akun SELECT dibatasi dan verifikasi administrator instalasi wajib; jangan membuka server ke internet.
Pro nyata: satu sumber, satu Home, tiga daftar, dua sub-tombol lazy. Filtrasi partisi/perusahaan wajib; lokasi/gudang opsional, diterapkan sebelum batas 1.000 baris. Tidak ada periode sejarah atau timestamp kesegaran AX yang ditebak. Data live dibaca terbatas; tidak ada refresh berkala. Batas bukan jaminan kueri murah atau hasil lengkap; periksa indeks, waktu, batas dan izin lokal.
KUANTITAS ASLI: PostedQty dibukukan finansial; Received diterima fisik belum dibukukan; Deducted dikeluarkan fisik belum dibukukan; Registered diregistrasi penerimaan; Picked telah diambil. Semuanya komponen sumber, bukan saldo fisik/disponibel hasil rumus. Nilai negatif, nol, NULL dan baris saldo ditutup tetap dipertahankan. Closed dan ClosedQty adalah flag sumber berbeda, termasuk kode asing/NULL. Tidak ada SUM antardimensi/satuan, konversi, nilai stok, harga atau mata uang yang ditebak.
WHS: Microsoft menjelaskan bahwa InventSum AvailPhysical/AvailOrdered/Ordered/ReservPhysical/ReservOrdered dapat memberikan hasil salah pada proses Warehouse Management R3. Paket ini TIDAK memproyeksikan disponibilitas, reservasi ataupun PhysicalInvent; tidak meniru provider/prosedur vendor. Dimensi WHS lanjutan seperti status inventaris/license plate tidak diperluas. Setiap baris sumber tetap terpisah, termasuk yang memiliki dimensi standar tampak sama. Bukan rekomendasi mengambil/pengiriman barang berdasarkan angka tersedia; gunakan fungsi native AX untuk keputusan ketersediaan.
KONTEKS: dimensi, gudang, master atau satuan hilang/ambigu tidak menghapus atau menggandakan baris saldo. Ketersediaan referensi ditampilkan; nilai ambigu tidak dipilih secara acak. UnitId berasal hanya dari InventTableModule ModuleType=0 (Invent), bukan unit beli/jual. Alias adalah teks pencarian, bukan nama produk terjemahan. Nama produk menampilkan semua teks dan LanguageId sumber; tidak menebak bahasa instalasi dari bahasa Cifru. Teks bahasa ganda ditandai dan tetap ditampilkan.
MASTER SAAT INI: pemasok utama adalah untuk pesanan terencana, bukan pemasok setiap transaksi. BOMUnitId adalah satuan konsumsi BOM. Berat per unit inventaris memakai satuan sumber yang harus dikonfirmasi administrator, tidak otomatis kg. Volume mengikuti referensi m³. Berat/volume ditampilkan sebagai teks sumber untuk mempertahankan pecahan kecil tanpa pembulatan tampilan numerik dua desimal; bukan angka agregasi/widget. Kuantitas numerik mengikuti format tampilan Cifru, tanpa mengubah nilai sumber. Tidak ada dimensi fisik barang ditebak dari faktor pengukuran BOM. Master/teks dapat berubah antara pembacaan live; bukan snapshot historis atau transaksi konsisten lintas layar.
AKSES: partisi, DATAAREAID tersimpan, RecId dan ItemId tepat diteruskan ke kedua anak. Int64 sebagai teks utuh, pencocokan biner mempertahankan kapital/spasi akhir. Perusahaan virtual memerlukan pemetaan administrator. Filter bukan ACL; SQL langsung tidak mewarisi AOS/XDS. Gunakan izin server minimum. Tidak ada kredensial, server, data perusahaan nyata, ID teknis pada kartu, audit atau data pribadi disisipkan. AOT adalah referensi, bukan DDL instalasi bersertifikat: periksa R3, konfigurasi modul, schema pemilik, kolom, relasi, keunikan kunci, indeks dan izin sebelum uji baca terbatas saat impor. Tes SQLite adaptasi dan DEMO bukan SQL Server/ERP nyata.
Referensi komponen: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg970236(v=ax.60)
Dimensi: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg934874(v=ax.60)
Satuan per modul: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg971003(v=ax.60)
Nama menurut bahasa: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg962386(v=ax.60)
Batas WHS: https://www.microsoft.com/en-us/dynamics-365/blog/no-audience/2014/05/05/upgrading-code-that-relies-on-available-and-reserved-inventory-quantities-in-ax-2012-r3/
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Komponen inventaris
- Details: Barang
- Details: Nama produk
- Sub-button: Informasi barang
- Sub-button: Nama produk menurut bahasa
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 CONCAT(LEN(CONCAT(s.Partition,N'#')),N':',s.Partition,N':',LEN(CONCAT(s.dataAreaId,N'#')),N':',s.dataAreaId,N':',LEN(CONCAT(s.RecId,N'#')),N':',s.RecId,N':') AS StockKey, CAST(s.Partition AS nvarchar(30)) AS PartitionId, CAST(s.RecId AS nvarchar(30)) AS StockRecId, s.ItemId AS ItemId, i.NameAlias AS NameAlias, pt.PartitionKey AS PartitionKey, s.dataAreaId AS dataAreaId, d.InventSiteId AS InventSiteId, d.InventLocationId AS InventLocationId, w.Name AS WarehouseName, d.wMSLocationId AS wMSLocationId, d.inventBatchId AS inventBatchId, d.inventSerialId AS inventSerialId, d.configId AS configId, d.InventColorId AS InventColorId, d.InventSizeId AS InventSizeId, d.InventStyleId AS InventStyleId, m.UnitId AS UnitId, CASE WHEN (SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0)=1 AND (m.UnitId IS NULL OR LEN(m.UnitId)=0) THEN N'Referensi ada, satuan kosong' ELSE CASE (SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0),N' referensi; nilai tidak dipilih') END END AS UnitState, CASE (SELECT COUNT_BIG(*) FROM InventDim q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.inventDimId AS varbinary(max))=CAST(s.InventDimId AS varbinary(max))) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM InventDim q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.inventDimId AS varbinary(max))=CAST(s.InventDimId AS varbinary(max))),N' referensi; nilai tidak dipilih') END AS DimensionState, CASE (SELECT COUNT_BIG(*) FROM InventLocation q WHERE q.Partition=d.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(d.dataAreaId AS varbinary(max)) AND CAST(q.InventLocationId AS varbinary(max))=CAST(d.InventLocationId AS varbinary(max))) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM InventLocation q WHERE q.Partition=d.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(d.dataAreaId AS varbinary(max)) AND CAST(q.InventLocationId AS varbinary(max))=CAST(d.InventLocationId AS varbinary(max))),N' referensi; nilai tidak dipilih') END AS WarehouseState, CASE (SELECT COUNT_BIG(*) FROM InventTable q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max))) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM InventTable q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max))),N' referensi; nilai tidak dipilih') END AS MasterState, s.PostedQty AS PostedQty, s.Received AS Received, s.Deducted AS Deducted, s.Registered AS Registered, s.Picked AS Picked, CASE WHEN s.Closed IS NULL THEN N'Tidak diketahui (NULL)' WHEN s.Closed=0 THEN N'Tidak' WHEN s.Closed=1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',s.Closed) END AS ClosedState, CASE WHEN s.ClosedQty IS NULL THEN N'Tidak diketahui (NULL)' WHEN s.ClosedQty=0 THEN N'Tidak' WHEN s.ClosedQty=1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',s.ClosedQty) END AS ClosedQtyState FROM InventSum s INNER JOIN Partitions pt ON pt.RecId=s.Partition LEFT JOIN InventDim d ON d.Partition=s.Partition AND CAST(d.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(d.inventDimId AS varbinary(max))=CAST(s.InventDimId AS varbinary(max)) AND (SELECT COUNT_BIG(*) FROM InventDim q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.inventDimId AS varbinary(max))=CAST(s.InventDimId AS varbinary(max)))=1 LEFT JOIN InventTable i ON i.Partition=s.Partition AND CAST(i.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(i.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND (SELECT COUNT_BIG(*) FROM InventTable q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)))=1 LEFT JOIN InventTableModule m ON m.Partition=s.Partition AND CAST(m.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(m.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND m.ModuleType=0 AND (SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0)=1 LEFT JOIN InventLocation w ON w.Partition=d.Partition AND CAST(w.dataAreaId AS varbinary(max))=CAST(d.dataAreaId AS varbinary(max)) AND CAST(w.InventLocationId AS varbinary(max))=CAST(d.InventLocationId AS varbinary(max)) AND (SELECT COUNT_BIG(*) FROM InventLocation q WHERE q.Partition=d.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(d.dataAreaId AS varbinary(max)) AND CAST(q.InventLocationId AS varbinary(max))=CAST(d.InventLocationId AS varbinary(max)))=1 WHERE s.Partition IS NOT NULL AND s.RecId>0 AND s.dataAreaId IS NOT NULL AND DATALENGTH(s.dataAreaId)>0 AND s.ItemId IS NOT NULL AND DATALENGTH(s.ItemId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'InventSum',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventSum',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U') AND OBJECT_ID(N'InventTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventTable',N'U') AND OBJECT_ID(N'InventTableModule',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventTableModule',N'U') AND OBJECT_ID(N'InventLocation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventLocation',N'U') AND OBJECT_ID(N'EcoResProduct',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EcoResProduct',N'U') AND OBJECT_ID(N'EcoResProductTranslation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EcoResProductTranslation',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(s.Partition,N'#')),N':',s.Partition,N':',LEN(CONCAT(s.dataAreaId,N'#')),N':',s.dataAreaId,N':',LEN(CONCAT(s.RecId,N'#')),N':',s.RecId,N':'),CONCAT(LEN(CONCAT(i.Partition,N'#')),N':',i.Partition,N':',LEN(CONCAT(i.dataAreaId,N'#')),N':',i.dataAreaId,N':',LEN(CONCAT(i.RecId,N'#')),N':',i.RecId,N':')) AS ProductKey, CONCAT(LEN(CONCAT(s.Partition,N'#')),N':',s.Partition,N':',LEN(CONCAT(s.dataAreaId,N'#')),N':',s.dataAreaId,N':',LEN(CONCAT(s.RecId,N'#')),N':',s.RecId,N':') AS ParentStockKey, i.ItemId AS ItemId, i.NameAlias AS NameAlias, e.DisplayProductNumber AS DisplayProductNumber, e.SearchName AS SearchName, i.PrimaryVendorId AS PrimaryVendorId, i.ItemBuyerGroupId AS ItemBuyerGroupId, i.PackagingGroupId AS PackagingGroupId, i.BOMUnitId AS BOMUnitId, i.NetWeight AS NetWeight, i.TaraWeight AS TaraWeight, i.UnitVolume AS UnitVolume, m.UnitId AS UnitId, CASE WHEN (SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0)=1 AND (m.UnitId IS NULL OR LEN(m.UnitId)=0) THEN N'Referensi ada, satuan kosong' ELSE CASE (SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0),N' referensi; nilai tidak dipilih') END END AS UnitState FROM InventSum s INNER JOIN Partitions pt ON pt.RecId=s.Partition INNER JOIN InventTable i ON i.Partition=s.Partition AND CAST(i.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(i.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND (SELECT COUNT_BIG(*) FROM InventTable q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)))=1 LEFT JOIN InventTableModule m ON m.Partition=s.Partition AND CAST(m.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(m.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND m.ModuleType=0 AND (SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0)=1 LEFT JOIN EcoResProduct e ON e.Partition=i.Partition AND e.RecId=i.Product AND (SELECT COUNT_BIG(*) FROM EcoResProduct q WHERE q.Partition=i.Partition AND q.RecId=i.Product)=1 WHERE s.Partition IS NOT NULL AND s.RecId>0 AND s.dataAreaId IS NOT NULL AND DATALENGTH(s.dataAreaId)>0 AND s.ItemId IS NOT NULL AND DATALENGTH(s.ItemId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND s.Partition=CAST(:partition AS bigint) AND CAST(s.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND s.RecId=CAST(:stockRecId AS bigint) AND CAST(s.ItemId AS varbinary(max))=CAST(:itemId AS varbinary(max)) AND i.RecId>0 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'InventSum',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventSum',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U') AND OBJECT_ID(N'InventTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventTable',N'U') AND OBJECT_ID(N'InventTableModule',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventTableModule',N'U') AND OBJECT_ID(N'InventLocation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventLocation',N'U') AND OBJECT_ID(N'EcoResProduct',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EcoResProduct',N'U') AND OBJECT_ID(N'EcoResProductTranslation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EcoResProductTranslation',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(s.Partition,N'#')),N':',s.Partition,N':',LEN(CONCAT(s.dataAreaId,N'#')),N':',s.dataAreaId,N':',LEN(CONCAT(s.RecId,N'#')),N':',s.RecId,N':'),CONCAT(LEN(CONCAT(t.Partition,N'#')),N':',t.Partition,N':',LEN(CONCAT(t.RecId,N'#')),N':',t.RecId,N':')) AS TranslationKey, CONCAT(LEN(CONCAT(s.Partition,N'#')),N':',s.Partition,N':',LEN(CONCAT(s.dataAreaId,N'#')),N':',s.dataAreaId,N':',LEN(CONCAT(s.RecId,N'#')),N':',s.RecId,N':') AS ParentStockKey, t.LanguageId AS LanguageId, t.Name AS Name, t.Description AS Description, CASE WHEN t.LanguageId IS NULL OR DATALENGTH(t.LanguageId)=0 THEN N'Bahasa kosong; periksa sumber' WHEN (SELECT COUNT_BIG(*) FROM EcoResProductTranslation q WHERE q.Partition=t.Partition AND q.Product=t.Product AND CAST(q.LanguageId AS varbinary(max))=CAST(t.LanguageId AS varbinary(max)))=1 THEN N'Satu teks bahasa' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM EcoResProductTranslation q WHERE q.Partition=t.Partition AND q.Product=t.Product AND CAST(q.LanguageId AS varbinary(max))=CAST(t.LanguageId AS varbinary(max))),N' teks bahasa; semuanya ditampilkan') END AS LanguageState FROM InventSum s INNER JOIN Partitions pt ON pt.RecId=s.Partition INNER JOIN InventTable i ON i.Partition=s.Partition AND CAST(i.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(i.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND (SELECT COUNT_BIG(*) FROM InventTable q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)))=1 INNER JOIN EcoResProductTranslation t ON t.Partition=i.Partition AND t.Product=i.Product AND i.Product>0 AND t.RecId>0 WHERE s.Partition IS NOT NULL AND s.RecId>0 AND s.dataAreaId IS NOT NULL AND DATALENGTH(s.dataAreaId)>0 AND s.ItemId IS NOT NULL AND DATALENGTH(s.ItemId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND s.Partition=CAST(:partition AS bigint) AND CAST(s.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND s.RecId=CAST(:stockRecId AS bigint) AND CAST(s.ItemId AS varbinary(max))=CAST(:itemId AS varbinary(max)) AND i.RecId>0 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'InventSum',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventSum',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U') AND OBJECT_ID(N'InventTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventTable',N'U') AND OBJECT_ID(N'InventTableModule',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventTableModule',N'U') AND OBJECT_ID(N'InventLocation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventLocation',N'U') AND OBJECT_ID(N'EcoResProduct',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EcoResProduct',N'U') AND OBJECT_ID(N'EcoResProductTranslation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EcoResProductTranslation',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Dynamics AX 2012 R3 — SQL Server lokal berizin",
"id": "76CB53EF-EC5B-51D6-8B81-D1CECD193688",
"kind": "sqlServer",
"requiredObjects": [
"InventSum",
"InventDim",
"InventTable",
"InventTableModule",
"InventLocation",
"EcoResProduct",
"EcoResProductTranslation",
"Partitions"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "586EDA90-53C6-5EEA-B177-AA8D973EE76A",
"key": "ItemId",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"id": "BA7D085D-5E2D-5508-90E6-A396CFDC7CD6",
"mappings": [
{
"commonFieldKey": "",
"key": "StockKey",
"label": "Internal StockKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StockKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartitionId",
"label": "Internal PartitionId",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PartitionId",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StockRecId",
"label": "Internal StockRecId",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StockRecId",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemId",
"label": "Kode barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ItemId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NameAlias",
"label": "Alias pencarian barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NameAlias",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartitionKey",
"label": "Partisi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PartitionKey",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dataAreaId",
"label": "Perusahaan tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "dataAreaId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventSiteId",
"label": "Kode lokasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventSiteId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventLocationId",
"label": "Kode gudang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventLocationId",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "WarehouseName",
"label": "Nama gudang saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WarehouseName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "wMSLocationId",
"label": "Tempat dalam gudang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "wMSLocationId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "inventBatchId",
"label": "Batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "inventBatchId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "inventSerialId",
"label": "Nomor seri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "inventSerialId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "configId",
"label": "Konfigurasi barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "configId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventColorId",
"label": "Warna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventColorId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventSizeId",
"label": "Ukuran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventSizeId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventStyleId",
"label": "Gaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventStyleId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UnitId",
"label": "Satuan inventaris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UnitId",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UnitState",
"label": "Ketersediaan satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UnitState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DimensionState",
"label": "Ketersediaan dimensi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DimensionState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseState",
"label": "Ketersediaan gudang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WarehouseState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MasterState",
"label": "Ketersediaan master barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MasterState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostedQty",
"label": "Jumlah dibukukan finansial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PostedQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Received",
"label": "Diterima fisik, belum dibukukan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Received",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Deducted",
"label": "Dikeluarkan fisik, belum dibukukan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Deducted",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Registered",
"label": "Jumlah diregistrasi penerimaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Registered",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Picked",
"label": "Jumlah diambil (picked)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Picked",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ClosedState",
"label": "Saldo sumber ditutup",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ClosedState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ClosedQtyState",
"label": "Jumlah terbuka nol",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ClosedQtyState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Komponen inventaris",
"primaryKey": "StockKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemId",
"NameAlias",
"PartitionKey",
"dataAreaId",
"InventSiteId",
"InventLocationId",
"WarehouseName",
"wMSLocationId",
"inventBatchId",
"inventSerialId",
"configId",
"InventColorId",
"InventSizeId",
"InventStyleId",
"UnitId",
"UnitState",
"DimensionState",
"WarehouseState",
"MasterState",
"PostedQty",
"Received",
"Deducted",
"Registered",
"Picked",
"ClosedState",
"ClosedQtyState"
],
"sourceID": "76CB53EF-EC5B-51D6-8B81-D1CECD193688",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(s.Partition,N'#')),N':',s.Partition,N':',LEN(CONCAT(s.dataAreaId,N'#')),N':',s.dataAreaId,N':',LEN(CONCAT(s.RecId,N'#')),N':',s.RecId,N':') AS StockKey, CAST(s.Partition AS nvarchar(30)) AS PartitionId, CAST(s.RecId AS nvarchar(30)) AS StockRecId, s.ItemId AS ItemId, i.NameAlias AS NameAlias, pt.PartitionKey AS PartitionKey, s.dataAreaId AS dataAreaId, d.InventSiteId AS InventSiteId, d.InventLocationId AS InventLocationId, w.Name AS WarehouseName, d.wMSLocationId AS wMSLocationId, d.inventBatchId AS inventBatchId, d.inventSerialId AS inventSerialId, d.configId AS configId, d.InventColorId AS InventColorId, d.InventSizeId AS InventSizeId, d.InventStyleId AS InventStyleId, m.UnitId AS UnitId, CASE WHEN (SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0)=1 AND (m.UnitId IS NULL OR LEN(m.UnitId)=0) THEN N'Referensi ada, satuan kosong' ELSE CASE (SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0),N' referensi; nilai tidak dipilih') END END AS UnitState, CASE (SELECT COUNT_BIG(*) FROM InventDim q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.inventDimId AS varbinary(max))=CAST(s.InventDimId AS varbinary(max))) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM InventDim q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.inventDimId AS varbinary(max))=CAST(s.InventDimId AS varbinary(max))),N' referensi; nilai tidak dipilih') END AS DimensionState, CASE (SELECT COUNT_BIG(*) FROM InventLocation q WHERE q.Partition=d.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(d.dataAreaId AS varbinary(max)) AND CAST(q.InventLocationId AS varbinary(max))=CAST(d.InventLocationId AS varbinary(max))) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM InventLocation q WHERE q.Partition=d.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(d.dataAreaId AS varbinary(max)) AND CAST(q.InventLocationId AS varbinary(max))=CAST(d.InventLocationId AS varbinary(max))),N' referensi; nilai tidak dipilih') END AS WarehouseState, CASE (SELECT COUNT_BIG(*) FROM InventTable q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max))) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM InventTable q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max))),N' referensi; nilai tidak dipilih') END AS MasterState, s.PostedQty AS PostedQty, s.Received AS Received, s.Deducted AS Deducted, s.Registered AS Registered, s.Picked AS Picked, CASE WHEN s.Closed IS NULL THEN N'Tidak diketahui (NULL)' WHEN s.Closed=0 THEN N'Tidak' WHEN s.Closed=1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',s.Closed) END AS ClosedState, CASE WHEN s.ClosedQty IS NULL THEN N'Tidak diketahui (NULL)' WHEN s.ClosedQty=0 THEN N'Tidak' WHEN s.ClosedQty=1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',s.ClosedQty) END AS ClosedQtyState FROM InventSum s INNER JOIN Partitions pt ON pt.RecId=s.Partition LEFT JOIN InventDim d ON d.Partition=s.Partition AND CAST(d.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(d.inventDimId AS varbinary(max))=CAST(s.InventDimId AS varbinary(max)) AND (SELECT COUNT_BIG(*) FROM InventDim q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.inventDimId AS varbinary(max))=CAST(s.InventDimId AS varbinary(max)))=1 LEFT JOIN InventTable i ON i.Partition=s.Partition AND CAST(i.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(i.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND (SELECT COUNT_BIG(*) FROM InventTable q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)))=1 LEFT JOIN InventTableModule m ON m.Partition=s.Partition AND CAST(m.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(m.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND m.ModuleType=0 AND (SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0)=1 LEFT JOIN InventLocation w ON w.Partition=d.Partition AND CAST(w.dataAreaId AS varbinary(max))=CAST(d.dataAreaId AS varbinary(max)) AND CAST(w.InventLocationId AS varbinary(max))=CAST(d.InventLocationId AS varbinary(max)) AND (SELECT COUNT_BIG(*) FROM InventLocation q WHERE q.Partition=d.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(d.dataAreaId AS varbinary(max)) AND CAST(q.InventLocationId AS varbinary(max))=CAST(d.InventLocationId AS varbinary(max)))=1 WHERE s.Partition IS NOT NULL AND s.RecId>0 AND s.dataAreaId IS NOT NULL AND DATALENGTH(s.dataAreaId)>0 AND s.ItemId IS NOT NULL AND DATALENGTH(s.ItemId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'InventSum',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventSum',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U') AND OBJECT_ID(N'InventTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventTable',N'U') AND OBJECT_ID(N'InventTableModule',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventTableModule',N'U') AND OBJECT_ID(N'InventLocation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventLocation',N'U') AND OBJECT_ID(N'EcoResProduct',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EcoResProduct',N'U') AND OBJECT_ID(N'EcoResProductTranslation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EcoResProductTranslation',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "586EDA90-53C6-5EEA-B177-AA8D973EE76A",
"key": "ItemId",
"type": "text"
},
{
"direction": "ascending",
"id": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
"key": "ProductKey",
"type": "text"
}
],
"id": "C7F68590-FF5E-5AA2-BAF4-8A962B41B2F7",
"mappings": [
{
"commonFieldKey": "",
"key": "ProductKey",
"label": "Internal ProductKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentStockKey",
"label": "Internal ParentStockKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentStockKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemId",
"label": "Kode barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ItemId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NameAlias",
"label": "Alias pencarian barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NameAlias",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DisplayProductNumber",
"label": "Nomor produk bersama",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DisplayProductNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SearchName",
"label": "Teks pencarian produk",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SearchName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PrimaryVendorId",
"label": "Pemasok utama pesanan terencana",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PrimaryVendorId",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ItemBuyerGroupId",
"label": "Kode kelompok pembeli",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ItemBuyerGroupId",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PackagingGroupId",
"label": "Kode kelompok kemasan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PackagingGroupId",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BOMUnitId",
"label": "Satuan konsumsi BOM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BOMUnitId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NetWeight",
"label": "Berat bersih / unit (satuan sumber)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NetWeight",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TaraWeight",
"label": "Berat tara / unit (satuan sumber)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TaraWeight",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UnitVolume",
"label": "Volume per unit inventaris (m³)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UnitVolume",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UnitId",
"label": "Satuan inventaris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UnitId",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UnitState",
"label": "Ketersediaan satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UnitState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Informasi barang",
"primaryKey": "ProductKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "33CF35FA-AB00-5F50-8A62-12ED03354A8F",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "71D5AF4D-9E32-5472-8DCF-08FA849CCF7F",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "StockRecId",
"id": "F7EDE2E2-FA77-52E8-811B-8BB31CA43309",
"name": "stockRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ItemId",
"id": "12B64BEA-321E-54A8-BAA5-B64910A3097A",
"name": "itemId",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemId",
"NameAlias",
"DisplayProductNumber",
"SearchName",
"PrimaryVendorId",
"ItemBuyerGroupId",
"PackagingGroupId",
"BOMUnitId",
"NetWeight",
"TaraWeight",
"UnitVolume",
"UnitId",
"UnitState"
],
"sourceID": "76CB53EF-EC5B-51D6-8B81-D1CECD193688",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(s.Partition,N'#')),N':',s.Partition,N':',LEN(CONCAT(s.dataAreaId,N'#')),N':',s.dataAreaId,N':',LEN(CONCAT(s.RecId,N'#')),N':',s.RecId,N':'),CONCAT(LEN(CONCAT(i.Partition,N'#')),N':',i.Partition,N':',LEN(CONCAT(i.dataAreaId,N'#')),N':',i.dataAreaId,N':',LEN(CONCAT(i.RecId,N'#')),N':',i.RecId,N':')) AS ProductKey, CONCAT(LEN(CONCAT(s.Partition,N'#')),N':',s.Partition,N':',LEN(CONCAT(s.dataAreaId,N'#')),N':',s.dataAreaId,N':',LEN(CONCAT(s.RecId,N'#')),N':',s.RecId,N':') AS ParentStockKey, i.ItemId AS ItemId, i.NameAlias AS NameAlias, e.DisplayProductNumber AS DisplayProductNumber, e.SearchName AS SearchName, i.PrimaryVendorId AS PrimaryVendorId, i.ItemBuyerGroupId AS ItemBuyerGroupId, i.PackagingGroupId AS PackagingGroupId, i.BOMUnitId AS BOMUnitId, i.NetWeight AS NetWeight, i.TaraWeight AS TaraWeight, i.UnitVolume AS UnitVolume, m.UnitId AS UnitId, CASE WHEN (SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0)=1 AND (m.UnitId IS NULL OR LEN(m.UnitId)=0) THEN N'Referensi ada, satuan kosong' ELSE CASE (SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0),N' referensi; nilai tidak dipilih') END END AS UnitState FROM InventSum s INNER JOIN Partitions pt ON pt.RecId=s.Partition INNER JOIN InventTable i ON i.Partition=s.Partition AND CAST(i.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(i.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND (SELECT COUNT_BIG(*) FROM InventTable q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)))=1 LEFT JOIN InventTableModule m ON m.Partition=s.Partition AND CAST(m.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(m.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND m.ModuleType=0 AND (SELECT COUNT_BIG(*) FROM InventTableModule q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND q.ModuleType=0)=1 LEFT JOIN EcoResProduct e ON e.Partition=i.Partition AND e.RecId=i.Product AND (SELECT COUNT_BIG(*) FROM EcoResProduct q WHERE q.Partition=i.Partition AND q.RecId=i.Product)=1 WHERE s.Partition IS NOT NULL AND s.RecId>0 AND s.dataAreaId IS NOT NULL AND DATALENGTH(s.dataAreaId)>0 AND s.ItemId IS NOT NULL AND DATALENGTH(s.ItemId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND s.Partition=CAST(:partition AS bigint) AND CAST(s.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND s.RecId=CAST(:stockRecId AS bigint) AND CAST(s.ItemId AS varbinary(max))=CAST(:itemId AS varbinary(max)) AND i.RecId>0 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'InventSum',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventSum',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U') AND OBJECT_ID(N'InventTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventTable',N'U') AND OBJECT_ID(N'InventTableModule',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventTableModule',N'U') AND OBJECT_ID(N'InventLocation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventLocation',N'U') AND OBJECT_ID(N'EcoResProduct',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EcoResProduct',N'U') AND OBJECT_ID(N'EcoResProductTranslation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EcoResProductTranslation',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "F5704292-0D46-53B6-A7FA-C8450E931C6B",
"key": "Name",
"type": "text"
},
{
"direction": "ascending",
"id": "79B9201B-1178-5FC1-8789-8B1187A78963",
"key": "TranslationKey",
"type": "text"
}
],
"id": "47F43569-FD2F-5886-B253-7C3F521AD060",
"mappings": [
{
"commonFieldKey": "",
"key": "TranslationKey",
"label": "Internal TranslationKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TranslationKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentStockKey",
"label": "Internal ParentStockKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentStockKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LanguageId",
"label": "Bahasa teks sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LanguageId",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Name",
"label": "Nama produk",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Name",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Deskripsi tambahan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LanguageState",
"label": "Keunikan teks bahasa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LanguageState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1000,
"name": "Nama produk menurut bahasa",
"primaryKey": "TranslationKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "33CF35FA-AB00-5F50-8A62-12ED03354A8F",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "71D5AF4D-9E32-5472-8DCF-08FA849CCF7F",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "StockRecId",
"id": "F7EDE2E2-FA77-52E8-811B-8BB31CA43309",
"name": "stockRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ItemId",
"id": "12B64BEA-321E-54A8-BAA5-B64910A3097A",
"name": "itemId",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"LanguageId",
"Name",
"Description",
"LanguageState"
],
"sourceID": "76CB53EF-EC5B-51D6-8B81-D1CECD193688",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(s.Partition,N'#')),N':',s.Partition,N':',LEN(CONCAT(s.dataAreaId,N'#')),N':',s.dataAreaId,N':',LEN(CONCAT(s.RecId,N'#')),N':',s.RecId,N':'),CONCAT(LEN(CONCAT(t.Partition,N'#')),N':',t.Partition,N':',LEN(CONCAT(t.RecId,N'#')),N':',t.RecId,N':')) AS TranslationKey, CONCAT(LEN(CONCAT(s.Partition,N'#')),N':',s.Partition,N':',LEN(CONCAT(s.dataAreaId,N'#')),N':',s.dataAreaId,N':',LEN(CONCAT(s.RecId,N'#')),N':',s.RecId,N':') AS ParentStockKey, t.LanguageId AS LanguageId, t.Name AS Name, t.Description AS Description, CASE WHEN t.LanguageId IS NULL OR DATALENGTH(t.LanguageId)=0 THEN N'Bahasa kosong; periksa sumber' WHEN (SELECT COUNT_BIG(*) FROM EcoResProductTranslation q WHERE q.Partition=t.Partition AND q.Product=t.Product AND CAST(q.LanguageId AS varbinary(max))=CAST(t.LanguageId AS varbinary(max)))=1 THEN N'Satu teks bahasa' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM EcoResProductTranslation q WHERE q.Partition=t.Partition AND q.Product=t.Product AND CAST(q.LanguageId AS varbinary(max))=CAST(t.LanguageId AS varbinary(max))),N' teks bahasa; semuanya ditampilkan') END AS LanguageState FROM InventSum s INNER JOIN Partitions pt ON pt.RecId=s.Partition INNER JOIN InventTable i ON i.Partition=s.Partition AND CAST(i.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(i.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)) AND (SELECT COUNT_BIG(*) FROM InventTable q WHERE q.Partition=s.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(s.dataAreaId AS varbinary(max)) AND CAST(q.ItemId AS varbinary(max))=CAST(s.ItemId AS varbinary(max)))=1 INNER JOIN EcoResProductTranslation t ON t.Partition=i.Partition AND t.Product=i.Product AND i.Product>0 AND t.RecId>0 WHERE s.Partition IS NOT NULL AND s.RecId>0 AND s.dataAreaId IS NOT NULL AND DATALENGTH(s.dataAreaId)>0 AND s.ItemId IS NOT NULL AND DATALENGTH(s.ItemId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND s.Partition=CAST(:partition AS bigint) AND CAST(s.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND s.RecId=CAST(:stockRecId AS bigint) AND CAST(s.ItemId AS varbinary(max))=CAST(:itemId AS varbinary(max)) AND i.RecId>0 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'InventSum',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventSum',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U') AND OBJECT_ID(N'InventTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventTable',N'U') AND OBJECT_ID(N'InventTableModule',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventTableModule',N'U') AND OBJECT_ID(N'InventLocation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventLocation',N'U') AND OBJECT_ID(N'EcoResProduct',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EcoResProduct',N'U') AND OBJECT_ID(N'EcoResProductTranslation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.EcoResProductTranslation',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "CFB65552-4EE9-5A2A-90BE-8C2A5F348325",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "A222A274-7EDD-5C78-BC92-420FC1086FD0",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "C7F68590-FF5E-5AA2-BAF4-8A962B41B2F7",
"title": "Barang",
"urlKey": ""
},
{
"id": "1A572025-CAEF-5AB5-8CA6-C7DB87F4A6E0",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "C4B4A66D-2A87-5996-A117-06072F913027",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "47F43569-FD2F-5886-B253-7C3F521AD060",
"title": "Nama produk",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InventLocationId",
"label": "Kode gudang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseName",
"label": "Nama gudang saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UnitId",
"label": "Satuan inventaris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PostedQty",
"label": "Jumlah dibukukan finansial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Received",
"label": "Diterima fisik, belum dibukukan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Deducted",
"label": "Dikeluarkan fisik, belum dibukukan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UnitState",
"label": "Ketersediaan satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "BA7D085D-5E2D-5508-90E6-A396CFDC7CD6",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Barang dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "ItemId",
"label": "Kode barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Barang dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "NameAlias",
"label": "Alias pencarian barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Barang dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "PartitionKey",
"label": "Partisi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Barang dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "dataAreaId",
"label": "Perusahaan tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Barang dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "UnitId",
"label": "Satuan inventaris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Barang dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "UnitState",
"label": "Ketersediaan satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Barang dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "MasterState",
"label": "Ketersediaan master barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Gudang dan varian standar",
"detailRole": "information",
"isVisible": true,
"key": "InventSiteId",
"label": "Kode lokasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Gudang dan varian standar",
"detailRole": "information",
"isVisible": true,
"key": "InventLocationId",
"label": "Kode gudang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Gudang dan varian standar",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseName",
"label": "Nama gudang saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Gudang dan varian standar",
"detailRole": "information",
"isVisible": true,
"key": "wMSLocationId",
"label": "Tempat dalam gudang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Gudang dan varian standar",
"detailRole": "information",
"isVisible": true,
"key": "inventBatchId",
"label": "Batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Gudang dan varian standar",
"detailRole": "information",
"isVisible": true,
"key": "inventSerialId",
"label": "Nomor seri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Gudang dan varian standar",
"detailRole": "information",
"isVisible": true,
"key": "configId",
"label": "Konfigurasi barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Gudang dan varian standar",
"detailRole": "information",
"isVisible": true,
"key": "InventColorId",
"label": "Warna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Gudang dan varian standar",
"detailRole": "information",
"isVisible": true,
"key": "InventSizeId",
"label": "Ukuran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Gudang dan varian standar",
"detailRole": "information",
"isVisible": true,
"key": "InventStyleId",
"label": "Gaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Gudang dan varian standar",
"detailRole": "information",
"isVisible": true,
"key": "DimensionState",
"label": "Ketersediaan dimensi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Gudang dan varian standar",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseState",
"label": "Ketersediaan gudang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Komponen kuantitas sumber",
"detailRole": "information",
"isVisible": true,
"key": "PostedQty",
"label": "Jumlah dibukukan finansial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Komponen kuantitas sumber",
"detailRole": "information",
"isVisible": true,
"key": "Received",
"label": "Diterima fisik, belum dibukukan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Komponen kuantitas sumber",
"detailRole": "information",
"isVisible": true,
"key": "Deducted",
"label": "Dikeluarkan fisik, belum dibukukan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Komponen kuantitas sumber",
"detailRole": "information",
"isVisible": true,
"key": "Registered",
"label": "Jumlah diregistrasi penerimaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Komponen kuantitas sumber",
"detailRole": "information",
"isVisible": true,
"key": "Picked",
"label": "Jumlah diambil (picked)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Flag saldo sumber",
"detailRole": "information",
"isVisible": true,
"key": "ClosedState",
"label": "Saldo sumber ditutup",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Flag saldo sumber",
"detailRole": "information",
"isVisible": true,
"key": "ClosedQtyState",
"label": "Jumlah terbuka nol",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "72012F84-68E3-59C4-BFE8-F647BBE6C752",
"openFilters": [
{
"id": "2ABFB427-27FD-5002-8E5A-D1782FECAED0",
"includeAllOption": false,
"key": "PartitionKey",
"title": "Partisi",
"type": "text"
},
{
"id": "66C2D089-E1AE-5E36-A893-61BBE5E755AC",
"includeAllOption": false,
"key": "dataAreaId",
"title": "Perusahaan tersimpan",
"type": "text"
},
{
"id": "73569850-1948-5B05-9672-EDCD3B600BBB",
"includeAllOption": true,
"key": "InventSiteId",
"title": "Lokasi",
"type": "text"
},
{
"id": "DAFC3BED-C444-566E-9C61-F60CA7455A3C",
"includeAllOption": true,
"key": "InventLocationId",
"title": "Gudang",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "586EDA90-53C6-5EEA-B177-AA8D973EE76A",
"key": "ItemId",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "NameAlias",
"systemImage": "shippingbox",
"title": "Komponen inventaris",
"titleKey": "ItemId"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UnitId",
"label": "Satuan inventaris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PrimaryVendorId",
"label": "Pemasok utama (rencana)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ItemBuyerGroupId",
"label": "Kode kelompok pembeli",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PackagingGroupId",
"label": "Kode kelompok kemasan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "C7F68590-FF5E-5AA2-BAF4-8A962B41B2F7",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identitas dan perencanaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "ItemId",
"label": "Kode barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas dan perencanaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "NameAlias",
"label": "Alias pencarian barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas dan perencanaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "DisplayProductNumber",
"label": "Nomor produk bersama",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas dan perencanaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "SearchName",
"label": "Teks pencarian produk",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas dan perencanaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PrimaryVendorId",
"label": "Pemasok utama pesanan terencana",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas dan perencanaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "ItemBuyerGroupId",
"label": "Kode kelompok pembeli",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas dan perencanaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PackagingGroupId",
"label": "Kode kelompok kemasan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas dan perencanaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "BOMUnitId",
"label": "Satuan konsumsi BOM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Satuan dan ukuran sumber",
"detailRole": "information",
"isVisible": true,
"key": "UnitId",
"label": "Satuan inventaris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Satuan dan ukuran sumber",
"detailRole": "information",
"isVisible": true,
"key": "UnitState",
"label": "Ketersediaan satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Satuan dan ukuran sumber",
"detailRole": "information",
"isVisible": true,
"key": "NetWeight",
"label": "Berat bersih / unit (satuan sumber)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Satuan dan ukuran sumber",
"detailRole": "information",
"isVisible": true,
"key": "TaraWeight",
"label": "Berat tara / unit (satuan sumber)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Satuan dan ukuran sumber",
"detailRole": "information",
"isVisible": true,
"key": "UnitVolume",
"label": "Volume per unit inventaris (m³)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "7271B3C2-E710-5DD6-B2F0-1ABEF5AE32C5",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "586EDA90-53C6-5EEA-B177-AA8D973EE76A",
"key": "ItemId",
"type": "text"
},
{
"direction": "ascending",
"id": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
"key": "ProductKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "NameAlias",
"systemImage": "cube",
"title": "Informasi barang",
"titleKey": "ItemId"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LanguageId",
"label": "Bahasa teks sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LanguageState",
"label": "Keunikan teks bahasa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "47F43569-FD2F-5886-B253-7C3F521AD060",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Teks produk saat ini",
"detailRole": "information",
"isVisible": true,
"key": "LanguageId",
"label": "Bahasa teks sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Teks produk saat ini",
"detailRole": "information",
"isVisible": true,
"key": "Name",
"label": "Nama produk",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Teks produk saat ini",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Deskripsi tambahan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Teks produk saat ini",
"detailRole": "information",
"isVisible": true,
"key": "LanguageState",
"label": "Keunikan teks bahasa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "0F076F7D-3A5E-538F-A215-F9C3EB71C95D",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "F5704292-0D46-53B6-A7FA-C8450E931C6B",
"key": "Name",
"type": "text"
},
{
"direction": "ascending",
"id": "79B9201B-1178-5FC1-8789-8B1187A78963",
"key": "TranslationKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "LanguageId",
"systemImage": "text.bubble",
"title": "Nama produk menurut bahasa",
"titleKey": "Name"
}
],
"relations": [
{
"childDatasetID": "C7F68590-FF5E-5AA2-BAF4-8A962B41B2F7",
"childKey": "ParentStockKey",
"id": "A222A274-7EDD-5C78-BC92-420FC1086FD0",
"name": "Barang",
"parentDatasetID": "BA7D085D-5E2D-5508-90E6-A396CFDC7CD6",
"parentKey": "StockKey"
},
{
"childDatasetID": "47F43569-FD2F-5886-B253-7C3F521AD060",
"childKey": "ParentStockKey",
"id": "C4B4A66D-2A87-5996-A117-06072F913027",
"name": "Nama produk",
"parentDatasetID": "BA7D085D-5E2D-5508-90E6-A396CFDC7CD6",
"parentKey": "StockKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Microsoft Dynamics AX",
"configurationLanguages": [
"id"
],
"countries": [
"ID"
],
"createdAt": "2026-10-09T00:00:00Z",
"description": "TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA.\n\nUntuk gudang, pembelian dan manajer: pilih partisi, perusahaan, lokasi dan gudang; periksa setiap baris inventaris beserta varian standar dan satuan inventaris. Lihat kuantitas yang dibukukan finansial, penerimaan/pengeluaran fisik belum dibukukan, registrasi dan picked secara terpisah. Barang membuka master serta konteks perencanaan saat ini; Nama produk membuka nama/deskripsi menurut bahasa sumber. 43 posisi berguna dalam Detil. Bukan laporan stok tersedia atau nilai persediaan.\n\nMengapa Cifru? Sesuaikan konfigurasi dengan cara kerja Anda. Pilih kolom, filter, dan rincian yang diperlukan, lalu tampilkan informasi di ponsel yang mungkin belum tersedia di aplikasi seluler bawaan perangkat lunak bisnis Anda. Pilihannya bergantung pada data yang dapat diakses dari sumber yang Anda berwenang gunakan dan paket Cifru Anda.\n\nEDISI: AX 2012 R3 on-premises SQL Server, untuk instalasi lama yang sudah ada; bukan Dynamics 365, Business Central atau SQL cloud. Dukungan diperpanjang berakhir 11 Januari 2023. Akun SELECT dibatasi dan verifikasi administrator instalasi wajib; jangan membuka server ke internet.\n\nPro nyata: satu sumber, satu Home, tiga daftar, dua sub-tombol lazy. Filtrasi partisi/perusahaan wajib; lokasi/gudang opsional, diterapkan sebelum batas 1.000 baris. Tidak ada periode sejarah atau timestamp kesegaran AX yang ditebak. Data live dibaca terbatas; tidak ada refresh berkala. Batas bukan jaminan kueri murah atau hasil lengkap; periksa indeks, waktu, batas dan izin lokal.\n\nKUANTITAS ASLI: PostedQty dibukukan finansial; Received diterima fisik belum dibukukan; Deducted dikeluarkan fisik belum dibukukan; Registered diregistrasi penerimaan; Picked telah diambil. Semuanya komponen sumber, bukan saldo fisik/disponibel hasil rumus. Nilai negatif, nol, NULL dan baris saldo ditutup tetap dipertahankan. Closed dan ClosedQty adalah flag sumber berbeda, termasuk kode asing/NULL. Tidak ada SUM antardimensi/satuan, konversi, nilai stok, harga atau mata uang yang ditebak.\n\nWHS: Microsoft menjelaskan bahwa InventSum AvailPhysical/AvailOrdered/Ordered/ReservPhysical/ReservOrdered dapat memberikan hasil salah pada proses Warehouse Management R3. Paket ini TIDAK memproyeksikan disponibilitas, reservasi ataupun PhysicalInvent; tidak meniru provider/prosedur vendor. Dimensi WHS lanjutan seperti status inventaris/license plate tidak diperluas. Setiap baris sumber tetap terpisah, termasuk yang memiliki dimensi standar tampak sama. Bukan rekomendasi mengambil/pengiriman barang berdasarkan angka tersedia; gunakan fungsi native AX untuk keputusan ketersediaan.\n\nKONTEKS: dimensi, gudang, master atau satuan hilang/ambigu tidak menghapus atau menggandakan baris saldo. Ketersediaan referensi ditampilkan; nilai ambigu tidak dipilih secara acak. UnitId berasal hanya dari InventTableModule ModuleType=0 (Invent), bukan unit beli/jual. Alias adalah teks pencarian, bukan nama produk terjemahan. Nama produk menampilkan semua teks dan LanguageId sumber; tidak menebak bahasa instalasi dari bahasa Cifru. Teks bahasa ganda ditandai dan tetap ditampilkan.\n\nMASTER SAAT INI: pemasok utama adalah untuk pesanan terencana, bukan pemasok setiap transaksi. BOMUnitId adalah satuan konsumsi BOM. Berat per unit inventaris memakai satuan sumber yang harus dikonfirmasi administrator, tidak otomatis kg. Volume mengikuti referensi m³. Berat/volume ditampilkan sebagai teks sumber untuk mempertahankan pecahan kecil tanpa pembulatan tampilan numerik dua desimal; bukan angka agregasi/widget. Kuantitas numerik mengikuti format tampilan Cifru, tanpa mengubah nilai sumber. Tidak ada dimensi fisik barang ditebak dari faktor pengukuran BOM. Master/teks dapat berubah antara pembacaan live; bukan snapshot historis atau transaksi konsisten lintas layar.\n\nAKSES: partisi, DATAAREAID tersimpan, RecId dan ItemId tepat diteruskan ke kedua anak. Int64 sebagai teks utuh, pencocokan biner mempertahankan kapital/spasi akhir. Perusahaan virtual memerlukan pemetaan administrator. Filter bukan ACL; SQL langsung tidak mewarisi AOS/XDS. Gunakan izin server minimum. Tidak ada kredensial, server, data perusahaan nyata, ID teknis pada kartu, audit atau data pribadi disisipkan. AOT adalah referensi, bukan DDL instalasi bersertifikat: periksa R3, konfigurasi modul, schema pemilik, kolom, relasi, keunikan kunci, indeks dan izin sebelum uji baca terbatas saat impor. Tes SQLite adaptasi dan DEMO bukan SQL Server/ERP nyata.\n\nReferensi komponen: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg970236(v=ax.60)\nDimensi: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg934874(v=ax.60)\nSatuan per modul: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg971003(v=ax.60)\nNama menurut bahasa: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg962386(v=ax.60)\nBatas WHS: https://www.microsoft.com/en-us/dynamics-365/blog/no-audience/2014/05/05/upgrading-code-that-relies-on-available-and-reserved-inventory-quantities-in-ax-2012-r3/",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "9563F527-C0B8-579C-B391-88345B655690",
"rootButtonCount": 1,
"summary": "Komponen kuantitas per gudang/varian, satuan inventaris, master dan nama produk; bukan stok tersedia.",
"tags": [
"Dynamics AX 2012 R3",
"SQL Server",
"Inventaris",
"Gudang",
"Barang",
"Pro"
],
"title": "Komponen inventaris, dimensi dan barang — Pro"
}
}