Pesanan penjualan, rincian dan pelanggan — Pro
Pesanan normal per periode/partisi/perusahaan; jadwal, nilai dan kuantitas baris serta pelanggan saat ini.
TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA.
Untuk penjualan, layanan pelanggan, gudang dan manajer: pilih periode dibuat UTC, partisi dan perusahaan tersimpan. Lihat pesanan normal, referensi, pembayaran serta jadwal diminta/dikonfirmasi. Buka Rincian untuk kuantitas, satuan, harga per unit harga, diskon, nilai dan status tiap baris. Pelanggan membuka dossier pelanggan SAAT INI, bukan salinan historis pesanan. 72 nilai berguna dalam Detil.
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 KHUSUS: AX 2012 R3 on-premises pada SQL Server, hanya instalasi lama yang sudah ada dengan akses SELECT yang disetujui administrator. Dukungan diperpanjang berakhir 11 Januari 2023 (Microsoft Lifecycle, zona Pacific). Bukan anjuran memasang ERP lama atau membuka server ke internet. Bukan AX 2009, Dynamics 365 Finance/SCM atau Business Central; akses SQL cloud tidak diasumsikan.
Pro nyata: satu sumber, satu Home, tiga daftar dan dua sub-tombol lazy. Hanya SalesType=3 (Sales) pada pesanan; bukan penawaran, langganan, jurnal atau retur. Status baris dan jenis baris tetap ditampilkan terpisah, termasuk kode tak dikenal/NULL. Status Difakturkan bukan bukti sudah dibayar.
Periode memilih tanggal UTC createdDateTime sumber, bukan tanggal faktur atau janji kirim. Waktu lengkap tetap terlihat. Filter asli periode/partisi/perusahaan diterapkan sebelum batas 1.000 baris. Rincian membuka semua baris dari pesanan tepat, bukan hanya baris pada periode. Tidak ada refresh berkala; gunakan rentang sempit dan verifikasi indeks, batas, waktu dan kelengkapan pada instalasi. Batas baris tidak menjamin kueri murah. Jumlah baris menghitung baris sumber, termasuk duplikat: bukan bukti unik atau ekspor seluruh ERP. Kunci duplikat harus diperbaiki oleh administrator, bukan didedup sembarang.
LINGKUP: partisi Int64 diteruskan sebagai teks tanpa pembulatan, dataAreaId tersimpan dan pesanan dipertahankan pada kedua anak. Pencocokan biner membedakan huruf besar/kecil serta spasi akhir. Perusahaan virtual mungkin menggunakan DATAAREAID seperti VIR: administrator harus memverifikasi pemetaan. Filter bukan ACL dan SQL langsung tidak mewarisi AOS/XDS/izin pengguna AX. Gunakan akun SELECT yang dibatasi di server.
NILAI ASLI: SalesPrice dan diskon nominal per PriceUnit, bukan otomatis harga per satu barang. LineAmount adalah nilai baris sumber dengan diskon, bukan total fiskal/PPN pesanan. Tidak ada penjumlahan lintas mata uang, kalkulasi pajak, margin, utang atau pembayaran. Mata uang baris tetap sendiri, tidak ditimpa mata uang pesanan. Kuantitas jual dan inventaris berbeda; satuan inventaris tidak ditebak dari SalesUnit. RemainPhysical/Financial, negatif dan NULL dipertahankan sesuai sumber, tanpa rumus konversi atau pembagian harga dengan nol. Kode pajak dan pengiriman adalah kode, bukan kamus atau perhitungan pajak.
Pelanggan adalah master pemesan saat ini, bukan otomatis penerima faktur atau historis. Master hilang tidak menghapus pesanan/baris; sub-tombol dapat tidak memiliki data. Tidak ada kontak privat, alamat, rekening bank, kartu pembayaran, identitas pribadi pemerintah atau mata uang kredit yang ditebak. Nama bisnis tetap dapat merupakan data pribadi; akses hanya bila berwenang.
Dokumentasi tabel/kolom dan enum Microsoft AOT mendasari pembuatan ini, bukan sertifikat DDL SQL instalasi Anda. Daftar field indeks/FK yang sparse tidak diisi dengan asumsi. Verifikasi versi R3, modul, pemilik tabel, kolom, kunci, relasi, indeks dan izin aktual sebelum uji baca terbatas saat impor. Paket dan DEMO sepenuhnya fiktif, tanpa kredensial/server/data perusahaan nyata. Tes SQLite adaptasi bukan SQL Server atau ERP nyata.
Referensi pesanan: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg873240(v=ax.60)
Referensi baris: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg870909(v=ax.60)
Siklus dukungan: https://learn.microsoft.com/en-us/lifecycle/products/dynamics-ax-2012-r3
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Pesanan penjualan
- Details: Rincian
- Details: Pelanggan
- Sub-button: Rincian pesanan
- Sub-button: Pelanggan pesanan saat ini
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(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS OrderKey, CAST(o.Partition AS nvarchar(30)) AS PartitionId, CAST(o.RecId AS nvarchar(30)) AS OrderRecId, CAST(o.createdDateTime AS date) AS CreatedDate, o.SalesId AS SalesId, o.SalesName AS SalesName, pt.PartitionKey AS PartitionKey, o.dataAreaId AS dataAreaId, o.CustAccount AS CustAccount, o.InvoiceAccount AS InvoiceAccount, o.CurrencyCode AS CurrencyCode, CASE WHEN o.SalesStatus IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.SalesStatus WHEN 0 THEN N'Tidak ditentukan' WHEN 1 THEN N'Terbuka' WHEN 2 THEN N'Dikirim' WHEN 3 THEN N'Difakturkan' WHEN 4 THEN N'Dibatalkan' ELSE CONCAT(N'Kode sumber ',o.SalesStatus) END END AS OrderStatus, CASE WHEN o.SalesType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.SalesType WHEN 0 THEN N'Jurnal' WHEN 1 THEN N'DEL_Quotation (kode lama)' WHEN 2 THEN N'Langganan' WHEN 3 THEN N'Pesanan penjualan' WHEN 4 THEN N'Retur' WHEN 5 THEN N'DEL_Blanket (kode lama)' WHEN 6 THEN N'Permintaan barang' ELSE CONCAT(N'Kode sumber ',o.SalesType) END END AS OrderType, o.CustomerRef AS CustomerRef, o.PurchOrderFormNum AS PurchOrderFormNum, o.createdDateTime AS OrderCreatedUTC, (SELECT COUNT_BIG(*) FROM SalesLine l WHERE l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(l.SalesId AS varbinary(max))=CAST(o.SalesId AS varbinary(max))) AS LineCount, o.Payment AS Payment, o.PaymMode AS PaymMode, o.DlvMode AS DlvMode, o.DlvTerm AS DlvTerm, o.ReceiptDateRequested AS ReceiptDateRequested, o.ReceiptDateConfirmed AS ReceiptDateConfirmed, o.ShippingDateRequested AS ShippingDateRequested, o.ShippingDateConfirmed AS ShippingDateConfirmed, o.DeliveryDate AS DeliveryDate, o.InventLocationId AS InventLocationId, o.InventSiteId AS InventSiteId, o.QuotationId AS QuotationId, o.ProjId AS ProjId FROM SalesTable o INNER JOIN Partitions pt ON pt.RecId=o.Partition WHERE o.SalesType=3 AND o.Partition IS NOT NULL AND o.RecId IS NOT NULL AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.SalesId IS NOT NULL AND DATALENGTH(o.SalesId)>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'SalesTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SalesTable',N'U') AND OBJECT_ID(N'SalesLine',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SalesLine',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':'),CONCAT(LEN(CONCAT(l.Partition,N'#')),N':',l.Partition,N':',LEN(CONCAT(l.dataAreaId,N'#')),N':',l.dataAreaId,N':',LEN(CONCAT(l.RecId,N'#')),N':',l.RecId,N':')) AS LineKey, CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS ParentOrderKey, l.ItemId AS ItemId, l.Name AS Name, l.LineNum AS LineNum, l.CurrencyCode AS CurrencyCode, CASE WHEN l.SalesStatus IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE l.SalesStatus WHEN 0 THEN N'Tidak ditentukan' WHEN 1 THEN N'Terbuka' WHEN 2 THEN N'Dikirim' WHEN 3 THEN N'Difakturkan' WHEN 4 THEN N'Dibatalkan' ELSE CONCAT(N'Kode sumber ',l.SalesStatus) END END AS LineStatus, CASE WHEN l.SalesType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE l.SalesType WHEN 0 THEN N'Jurnal' WHEN 1 THEN N'DEL_Quotation (kode lama)' WHEN 2 THEN N'Langganan' WHEN 3 THEN N'Pesanan penjualan' WHEN 4 THEN N'Retur' WHEN 5 THEN N'DEL_Blanket (kode lama)' WHEN 6 THEN N'Permintaan barang' ELSE CONCAT(N'Kode sumber ',l.SalesType) END END AS LineType, l.SalesQty AS SalesQty, l.SalesUnit AS SalesUnit, l.QtyOrdered AS QtyOrdered, l.SalesPrice AS SalesPrice, l.PriceUnit AS PriceUnit, l.LineAmount AS LineAmount, l.LineDisc AS LineDisc, l.LinePercent AS LinePercent, l.MultiLnDisc AS MultiLnDisc, l.MultiLnPercent AS MultiLnPercent, l.SalesMarkup AS SalesMarkup, l.RemainSalesPhysical AS RemainSalesPhysical, l.RemainSalesFinancial AS RemainSalesFinancial, l.RemainInventPhysical AS RemainInventPhysical, l.RemainInventFinancial AS RemainInventFinancial, l.ReceiptDateRequested AS ReceiptDateRequested, l.ReceiptDateConfirmed AS ReceiptDateConfirmed, l.ShippingDateRequested AS ShippingDateRequested, l.ShippingDateConfirmed AS ShippingDateConfirmed, l.PackingUnit AS PackingUnit, l.PackingUnitQty AS PackingUnitQty, l.OverDeliveryPct AS OverDeliveryPct, l.UnderDeliveryPct AS UnderDeliveryPct, l.TaxGroup AS TaxGroup, l.TaxItemGroup AS TaxItemGroup FROM SalesTable o INNER JOIN Partitions pt ON pt.RecId=o.Partition INNER JOIN SalesLine l ON l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(l.SalesId AS varbinary(max))=CAST(o.SalesId AS varbinary(max)) WHERE o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:orderRecId AS bigint) AND CAST(o.SalesId AS varbinary(max))=CAST(:orderId AS varbinary(max)) AND o.SalesType=3 AND o.Partition IS NOT NULL AND o.RecId IS NOT NULL AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.SalesId IS NOT NULL AND DATALENGTH(o.SalesId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND l.RecId IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'SalesTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SalesTable',N'U') AND OBJECT_ID(N'SalesLine',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SalesLine',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':'),CONCAT(LEN(CONCAT(m.Partition,N'#')),N':',m.Partition,N':',LEN(CONCAT(m.dataAreaId,N'#')),N':',m.dataAreaId,N':',LEN(CONCAT(m.RecId,N'#')),N':',m.RecId,N':')) AS CustomerKey, CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS ParentOrderKey, COALESCE(NULLIF(p.Name,N''),m.AccountNum) AS CustomerName, m.AccountNum AS AccountNum, p.KnownAs AS KnownAs, p.NameAlias AS NameAlias, p.PartyNumber AS PartyNumber, m.CustGroup AS CustGroup, m.Currency AS Currency, m.InvoiceAccount AS InvoiceAccount, m.PaymTermId AS PaymTermId, m.PaymMode AS PaymMode, m.OurAccountNum AS OurAccountNum, m.DlvMode AS DlvMode, m.DlvTerm AS DlvTerm, CASE WHEN m.Blocked IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE m.Blocked WHEN 0 THEN N'Tidak ditangguhkan' WHEN 1 THEN N'Faktur' WHEN 2 THEN N'Semua' WHEN 3 THEN N'Pembayaran' WHEN 4 THEN N'Permintaan' WHEN 5 THEN N'Never (kode sumber)' ELSE CONCAT(N'Kode sumber ',m.Blocked) END END AS BlockStatus, m.CreditRating AS CreditRating FROM SalesTable o INNER JOIN Partitions pt ON pt.RecId=o.Partition INNER JOIN CustTable m ON m.Partition=o.Partition AND CAST(m.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(m.AccountNum AS varbinary(max))=CAST(o.CustAccount AS varbinary(max)) LEFT JOIN DirPartyTable p ON p.Partition=m.Partition AND p.RecId=m.Party WHERE o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:orderRecId AS bigint) AND CAST(o.SalesId AS varbinary(max))=CAST(:orderId AS varbinary(max)) AND o.SalesType=3 AND o.Partition IS NOT NULL AND o.RecId IS NOT NULL AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.SalesId IS NOT NULL AND DATALENGTH(o.SalesId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND m.RecId IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'SalesTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SalesTable',N'U') AND OBJECT_ID(N'SalesLine',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SalesLine',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',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": "3E0E2AFB-949F-5CD2-B8E3-C4436EA59286",
"kind": "sqlServer",
"requiredObjects": [
"SalesTable",
"SalesLine",
"Partitions",
"CustTable",
"DirPartyTable"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "3FBFD871-A7A6-57F6-B519-A20132000EBF",
"key": "CreatedDate",
"type": "date"
},
{
"direction": "ascending",
"id": "B9A6FEF7-2967-516A-80F2-85B48E692658",
"key": "SalesId",
"type": "text"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"id": "B8252C9C-F13E-59EE-9552-FCD08E541ABA",
"mappings": [
{
"commonFieldKey": "",
"key": "OrderKey",
"label": "Internal OrderKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderKey",
"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": "OrderRecId",
"label": "Internal OrderRecId",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderRecId",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CreatedDate",
"label": "Internal CreatedDate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CreatedDate",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalesId",
"label": "Nomor pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SalesId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalesName",
"label": "Nama pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SalesName",
"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": "CustAccount",
"label": "Akun pemesan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceAccount",
"label": "Akun penerima faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Mata uang pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderStatus",
"label": "Status pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderType",
"label": "Jenis pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerRef",
"label": "Referensi pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerRef",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchOrderFormNum",
"label": "Nomor permintaan pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchOrderFormNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderCreatedUTC",
"label": "Pesanan dibuat (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderCreatedUTC",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineCount",
"label": "Jumlah baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Payment",
"label": "Kode syarat pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Payment",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymMode",
"label": "Kode metode pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymMode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DlvMode",
"label": "Kode cara pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DlvMode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DlvTerm",
"label": "Kode syarat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DlvTerm",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ReceiptDateRequested",
"label": "Penerimaan diminta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ReceiptDateRequested",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ReceiptDateConfirmed",
"label": "Penerimaan dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ReceiptDateConfirmed",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShippingDateRequested",
"label": "Pengiriman diminta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShippingDateRequested",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ShippingDateConfirmed",
"label": "Pengiriman dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShippingDateConfirmed",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DeliveryDate",
"label": "Tanggal pengiriman sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DeliveryDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventLocationId",
"label": "Kode gudang pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventLocationId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventSiteId",
"label": "Kode lokasi pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventSiteId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QuotationId",
"label": "Referensi penawaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QuotationId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProjId",
"label": "Referensi proyek",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProjId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Pesanan penjualan",
"primaryKey": "OrderKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"SalesId",
"SalesName",
"PartitionKey",
"dataAreaId",
"CustAccount",
"InvoiceAccount",
"CurrencyCode",
"OrderStatus",
"OrderType",
"CustomerRef",
"PurchOrderFormNum",
"OrderCreatedUTC",
"LineCount",
"Payment",
"PaymMode",
"DlvMode",
"DlvTerm",
"ReceiptDateRequested",
"ReceiptDateConfirmed",
"ShippingDateRequested",
"ShippingDateConfirmed",
"DeliveryDate",
"InventLocationId",
"InventSiteId",
"QuotationId",
"ProjId"
],
"sourceID": "3E0E2AFB-949F-5CD2-B8E3-C4436EA59286",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS OrderKey, CAST(o.Partition AS nvarchar(30)) AS PartitionId, CAST(o.RecId AS nvarchar(30)) AS OrderRecId, CAST(o.createdDateTime AS date) AS CreatedDate, o.SalesId AS SalesId, o.SalesName AS SalesName, pt.PartitionKey AS PartitionKey, o.dataAreaId AS dataAreaId, o.CustAccount AS CustAccount, o.InvoiceAccount AS InvoiceAccount, o.CurrencyCode AS CurrencyCode, CASE WHEN o.SalesStatus IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.SalesStatus WHEN 0 THEN N'Tidak ditentukan' WHEN 1 THEN N'Terbuka' WHEN 2 THEN N'Dikirim' WHEN 3 THEN N'Difakturkan' WHEN 4 THEN N'Dibatalkan' ELSE CONCAT(N'Kode sumber ',o.SalesStatus) END END AS OrderStatus, CASE WHEN o.SalesType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.SalesType WHEN 0 THEN N'Jurnal' WHEN 1 THEN N'DEL_Quotation (kode lama)' WHEN 2 THEN N'Langganan' WHEN 3 THEN N'Pesanan penjualan' WHEN 4 THEN N'Retur' WHEN 5 THEN N'DEL_Blanket (kode lama)' WHEN 6 THEN N'Permintaan barang' ELSE CONCAT(N'Kode sumber ',o.SalesType) END END AS OrderType, o.CustomerRef AS CustomerRef, o.PurchOrderFormNum AS PurchOrderFormNum, o.createdDateTime AS OrderCreatedUTC, (SELECT COUNT_BIG(*) FROM SalesLine l WHERE l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(l.SalesId AS varbinary(max))=CAST(o.SalesId AS varbinary(max))) AS LineCount, o.Payment AS Payment, o.PaymMode AS PaymMode, o.DlvMode AS DlvMode, o.DlvTerm AS DlvTerm, o.ReceiptDateRequested AS ReceiptDateRequested, o.ReceiptDateConfirmed AS ReceiptDateConfirmed, o.ShippingDateRequested AS ShippingDateRequested, o.ShippingDateConfirmed AS ShippingDateConfirmed, o.DeliveryDate AS DeliveryDate, o.InventLocationId AS InventLocationId, o.InventSiteId AS InventSiteId, o.QuotationId AS QuotationId, o.ProjId AS ProjId FROM SalesTable o INNER JOIN Partitions pt ON pt.RecId=o.Partition WHERE o.SalesType=3 AND o.Partition IS NOT NULL AND o.RecId IS NOT NULL AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.SalesId IS NOT NULL AND DATALENGTH(o.SalesId)>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'SalesTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SalesTable',N'U') AND OBJECT_ID(N'SalesLine',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SalesLine',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "AA367C24-B913-596B-AFB8-936AF6AA00E1",
"key": "LineNum",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "FCA4CEE2-DDE2-57FA-8368-A243CDDFE62D",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Internal LineKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentOrderKey",
"label": "Internal ParentOrderKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentOrderKey",
"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": "Name",
"label": "Deskripsi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Name",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineNum",
"label": "Nomor urut baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineNum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Mata uang baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineStatus",
"label": "Status baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineType",
"label": "Jenis baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalesQty",
"label": "Jumlah pesanan (satuan jual)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SalesQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SalesUnit",
"label": "Satuan jual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SalesUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QtyOrdered",
"label": "Jumlah pesanan (satuan inventaris)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QtyOrdered",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalesPrice",
"label": "Harga per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SalesPrice",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PriceUnit",
"label": "Jumlah satuan per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PriceUnit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineAmount",
"label": "Nilai baris sumber setelah diskon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineDisc",
"label": "Diskon baris per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineDisc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LinePercent",
"label": "Diskon baris (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LinePercent",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MultiLnDisc",
"label": "Diskon multibaris per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MultiLnDisc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MultiLnPercent",
"label": "Diskon multibaris (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MultiLnPercent",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalesMarkup",
"label": "Biaya harga tetap sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SalesMarkup",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RemainSalesPhysical",
"label": "Belum dikirim (satuan jual)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RemainSalesPhysical",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RemainSalesFinancial",
"label": "Dikirim, belum diperbarui faktur (satuan jual)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RemainSalesFinancial",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RemainInventPhysical",
"label": "Belum dikirim (satuan inventaris)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RemainInventPhysical",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RemainInventFinancial",
"label": "Dikirim, belum diperbarui faktur (satuan inventaris)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RemainInventFinancial",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ReceiptDateRequested",
"label": "Penerimaan diminta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ReceiptDateRequested",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ReceiptDateConfirmed",
"label": "Penerimaan dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ReceiptDateConfirmed",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShippingDateRequested",
"label": "Pengiriman diminta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShippingDateRequested",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShippingDateConfirmed",
"label": "Pengiriman dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ShippingDateConfirmed",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PackingUnit",
"label": "Satuan kemasan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PackingUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PackingUnitQty",
"label": "Jumlah kemasan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PackingUnitQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OverDeliveryPct",
"label": "Toleransi lebih kirim (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OverDeliveryPct",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UnderDeliveryPct",
"label": "Toleransi kurang kirim (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UnderDeliveryPct",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TaxGroup",
"label": "Kode grup pajak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TaxGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TaxItemGroup",
"label": "Kode pajak barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TaxItemGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Rincian pesanan",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "B3ECD41E-D0F2-536A-B001-4F8F247435C2",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "186A7488-6CCF-5FA0-BA45-462A5B01AF73",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderRecId",
"id": "E4316D90-4F3A-503E-A4EC-62F6059DA45F",
"name": "orderRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "SalesId",
"id": "143E0740-3EBD-5E29-BAC2-493278D437C9",
"name": "orderId",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemId",
"Name",
"LineNum",
"CurrencyCode",
"LineStatus",
"LineType",
"SalesQty",
"SalesUnit",
"QtyOrdered",
"SalesPrice",
"PriceUnit",
"LineAmount",
"LineDisc",
"LinePercent",
"MultiLnDisc",
"MultiLnPercent",
"SalesMarkup",
"RemainSalesPhysical",
"RemainSalesFinancial",
"RemainInventPhysical",
"RemainInventFinancial",
"ReceiptDateRequested",
"ReceiptDateConfirmed",
"ShippingDateRequested",
"ShippingDateConfirmed",
"PackingUnit",
"PackingUnitQty",
"OverDeliveryPct",
"UnderDeliveryPct",
"TaxGroup",
"TaxItemGroup"
],
"sourceID": "3E0E2AFB-949F-5CD2-B8E3-C4436EA59286",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':'),CONCAT(LEN(CONCAT(l.Partition,N'#')),N':',l.Partition,N':',LEN(CONCAT(l.dataAreaId,N'#')),N':',l.dataAreaId,N':',LEN(CONCAT(l.RecId,N'#')),N':',l.RecId,N':')) AS LineKey, CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS ParentOrderKey, l.ItemId AS ItemId, l.Name AS Name, l.LineNum AS LineNum, l.CurrencyCode AS CurrencyCode, CASE WHEN l.SalesStatus IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE l.SalesStatus WHEN 0 THEN N'Tidak ditentukan' WHEN 1 THEN N'Terbuka' WHEN 2 THEN N'Dikirim' WHEN 3 THEN N'Difakturkan' WHEN 4 THEN N'Dibatalkan' ELSE CONCAT(N'Kode sumber ',l.SalesStatus) END END AS LineStatus, CASE WHEN l.SalesType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE l.SalesType WHEN 0 THEN N'Jurnal' WHEN 1 THEN N'DEL_Quotation (kode lama)' WHEN 2 THEN N'Langganan' WHEN 3 THEN N'Pesanan penjualan' WHEN 4 THEN N'Retur' WHEN 5 THEN N'DEL_Blanket (kode lama)' WHEN 6 THEN N'Permintaan barang' ELSE CONCAT(N'Kode sumber ',l.SalesType) END END AS LineType, l.SalesQty AS SalesQty, l.SalesUnit AS SalesUnit, l.QtyOrdered AS QtyOrdered, l.SalesPrice AS SalesPrice, l.PriceUnit AS PriceUnit, l.LineAmount AS LineAmount, l.LineDisc AS LineDisc, l.LinePercent AS LinePercent, l.MultiLnDisc AS MultiLnDisc, l.MultiLnPercent AS MultiLnPercent, l.SalesMarkup AS SalesMarkup, l.RemainSalesPhysical AS RemainSalesPhysical, l.RemainSalesFinancial AS RemainSalesFinancial, l.RemainInventPhysical AS RemainInventPhysical, l.RemainInventFinancial AS RemainInventFinancial, l.ReceiptDateRequested AS ReceiptDateRequested, l.ReceiptDateConfirmed AS ReceiptDateConfirmed, l.ShippingDateRequested AS ShippingDateRequested, l.ShippingDateConfirmed AS ShippingDateConfirmed, l.PackingUnit AS PackingUnit, l.PackingUnitQty AS PackingUnitQty, l.OverDeliveryPct AS OverDeliveryPct, l.UnderDeliveryPct AS UnderDeliveryPct, l.TaxGroup AS TaxGroup, l.TaxItemGroup AS TaxItemGroup FROM SalesTable o INNER JOIN Partitions pt ON pt.RecId=o.Partition INNER JOIN SalesLine l ON l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(l.SalesId AS varbinary(max))=CAST(o.SalesId AS varbinary(max)) WHERE o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:orderRecId AS bigint) AND CAST(o.SalesId AS varbinary(max))=CAST(:orderId AS varbinary(max)) AND o.SalesType=3 AND o.Partition IS NOT NULL AND o.RecId IS NOT NULL AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.SalesId IS NOT NULL AND DATALENGTH(o.SalesId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND l.RecId IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'SalesTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SalesTable',N'U') AND OBJECT_ID(N'SalesLine',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SalesLine',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "81F2AA9E-89D6-59B0-8AF0-BE212938DABE",
"key": "CustomerName",
"type": "text"
},
{
"direction": "ascending",
"id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
"key": "CustomerKey",
"type": "text"
}
],
"id": "B3AA7060-6EBF-5266-B893-CFAFB4F96246",
"mappings": [
{
"commonFieldKey": "",
"key": "CustomerKey",
"label": "Internal CustomerKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentOrderKey",
"label": "Internal ParentOrderKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentOrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerName",
"label": "Nama pelanggan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountNum",
"label": "Akun pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "KnownAs",
"label": "Nama dikenal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "KnownAs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NameAlias",
"label": "Alias pencarian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NameAlias",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartyNumber",
"label": "Nomor pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PartyNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustGroup",
"label": "Grup pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Currency",
"label": "Mata uang faktur bawaan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Currency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceAccount",
"label": "Akun penerima faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymTermId",
"label": "Kode syarat pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymTermId",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PaymMode",
"label": "Kode metode pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymMode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OurAccountNum",
"label": "Akun kita pada pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OurAccountNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DlvMode",
"label": "Kode cara pengiriman bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DlvMode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DlvTerm",
"label": "Kode syarat pengiriman bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DlvTerm",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BlockStatus",
"label": "Status penangguhan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BlockStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CreditRating",
"label": "Peringkat kredit tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CreditRating",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Pelanggan pesanan saat ini",
"primaryKey": "CustomerKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "B3ECD41E-D0F2-536A-B001-4F8F247435C2",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "186A7488-6CCF-5FA0-BA45-462A5B01AF73",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderRecId",
"id": "E4316D90-4F3A-503E-A4EC-62F6059DA45F",
"name": "orderRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "SalesId",
"id": "143E0740-3EBD-5E29-BAC2-493278D437C9",
"name": "orderId",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"CustomerName",
"AccountNum",
"KnownAs",
"NameAlias",
"PartyNumber",
"CustGroup",
"Currency",
"InvoiceAccount",
"PaymTermId",
"PaymMode",
"OurAccountNum",
"DlvMode",
"DlvTerm",
"BlockStatus",
"CreditRating"
],
"sourceID": "3E0E2AFB-949F-5CD2-B8E3-C4436EA59286",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':'),CONCAT(LEN(CONCAT(m.Partition,N'#')),N':',m.Partition,N':',LEN(CONCAT(m.dataAreaId,N'#')),N':',m.dataAreaId,N':',LEN(CONCAT(m.RecId,N'#')),N':',m.RecId,N':')) AS CustomerKey, CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS ParentOrderKey, COALESCE(NULLIF(p.Name,N''),m.AccountNum) AS CustomerName, m.AccountNum AS AccountNum, p.KnownAs AS KnownAs, p.NameAlias AS NameAlias, p.PartyNumber AS PartyNumber, m.CustGroup AS CustGroup, m.Currency AS Currency, m.InvoiceAccount AS InvoiceAccount, m.PaymTermId AS PaymTermId, m.PaymMode AS PaymMode, m.OurAccountNum AS OurAccountNum, m.DlvMode AS DlvMode, m.DlvTerm AS DlvTerm, CASE WHEN m.Blocked IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE m.Blocked WHEN 0 THEN N'Tidak ditangguhkan' WHEN 1 THEN N'Faktur' WHEN 2 THEN N'Semua' WHEN 3 THEN N'Pembayaran' WHEN 4 THEN N'Permintaan' WHEN 5 THEN N'Never (kode sumber)' ELSE CONCAT(N'Kode sumber ',m.Blocked) END END AS BlockStatus, m.CreditRating AS CreditRating FROM SalesTable o INNER JOIN Partitions pt ON pt.RecId=o.Partition INNER JOIN CustTable m ON m.Partition=o.Partition AND CAST(m.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(m.AccountNum AS varbinary(max))=CAST(o.CustAccount AS varbinary(max)) LEFT JOIN DirPartyTable p ON p.Partition=m.Partition AND p.RecId=m.Party WHERE o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:orderRecId AS bigint) AND CAST(o.SalesId AS varbinary(max))=CAST(:orderId AS varbinary(max)) AND o.SalesType=3 AND o.Partition IS NOT NULL AND o.RecId IS NOT NULL AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.SalesId IS NOT NULL AND DATALENGTH(o.SalesId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND m.RecId IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'SalesTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SalesTable',N'U') AND OBJECT_ID(N'SalesLine',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SalesLine',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "921AF198-5F1C-556D-9807-381A63E87C27",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "2CFB2338-3741-5589-9582-CF73946311DC",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "FCA4CEE2-DDE2-57FA-8368-A243CDDFE62D",
"title": "Rincian",
"urlKey": ""
},
{
"id": "FAE5C665-76F8-5ADC-8A23-53B20BC317EC",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "6908B544-1E6C-5440-A7FA-80856001FBA6",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "B3AA7060-6EBF-5266-B893-CFAFB4F96246",
"title": "Pelanggan",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CustAccount",
"label": "Akun pemesan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderStatus",
"label": "Status pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderCreatedUTC",
"label": "Pesanan dibuat (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ShippingDateRequested",
"label": "Pengiriman diminta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Jumlah baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B8252C9C-F13E-59EE-9552-FCD08E541ABA",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Pesanan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "SalesId",
"label": "Nomor pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pesanan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "SalesName",
"label": "Nama pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pesanan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "PartitionKey",
"label": "Partisi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pesanan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "dataAreaId",
"label": "Perusahaan tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pesanan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "CustAccount",
"label": "Akun pemesan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pesanan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun penerima faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pesanan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "CustomerRef",
"label": "Referensi pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pesanan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "PurchOrderFormNum",
"label": "Nomor permintaan pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pesanan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "OrderCreatedUTC",
"label": "Pesanan dibuat (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pesanan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Jumlah baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pesanan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "OrderStatus",
"label": "Status pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pesanan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "OrderType",
"label": "Jenis pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "Payment",
"label": "Kode syarat pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "PaymMode",
"label": "Kode metode pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan jadwal",
"detailRole": "information",
"isVisible": true,
"key": "DlvMode",
"label": "Kode cara pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan jadwal",
"detailRole": "information",
"isVisible": true,
"key": "DlvTerm",
"label": "Kode syarat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan jadwal",
"detailRole": "information",
"isVisible": true,
"key": "ShippingDateRequested",
"label": "Pengiriman diminta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan jadwal",
"detailRole": "information",
"isVisible": true,
"key": "ShippingDateConfirmed",
"label": "Pengiriman dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan jadwal",
"detailRole": "information",
"isVisible": true,
"key": "ReceiptDateRequested",
"label": "Penerimaan diminta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan jadwal",
"detailRole": "information",
"isVisible": true,
"key": "ReceiptDateConfirmed",
"label": "Penerimaan dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan jadwal",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryDate",
"label": "Tanggal pengiriman sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan jadwal",
"detailRole": "information",
"isVisible": true,
"key": "InventLocationId",
"label": "Kode gudang pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan jadwal",
"detailRole": "information",
"isVisible": true,
"key": "InventSiteId",
"label": "Kode lokasi pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi tambahan",
"detailRole": "information",
"isVisible": true,
"key": "QuotationId",
"label": "Referensi penawaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi tambahan",
"detailRole": "information",
"isVisible": true,
"key": "ProjId",
"label": "Referensi proyek",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "ACD8B069-067F-5DE2-9A0A-1B400A77C790",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "C51EA8A2-7E69-5A52-8520-F58E41F09EA0",
"includeAllOption": false,
"key": "CreatedDate",
"title": "Periode dibuat (UTC)",
"type": "date"
},
{
"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"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "3FBFD871-A7A6-57F6-B519-A20132000EBF",
"key": "CreatedDate",
"type": "date"
},
{
"direction": "ascending",
"id": "B9A6FEF7-2967-516A-80F2-85B48E692658",
"key": "SalesId",
"type": "text"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "SalesName",
"systemImage": "cart",
"title": "Pesanan penjualan",
"titleKey": "SalesId"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SalesQty",
"label": "Jumlah pesanan (satuan jual)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SalesUnit",
"label": "Satuan jual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SalesPrice",
"label": "Harga per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PriceUnit",
"label": "Jumlah satuan per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineAmount",
"label": "Nilai baris sumber setelah diskon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineStatus",
"label": "Status baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "FCA4CEE2-DDE2-57FA-8368-A243CDDFE62D",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Barang dan status",
"detailRole": "information",
"isVisible": true,
"key": "ItemId",
"label": "Kode barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Barang dan status",
"detailRole": "information",
"isVisible": true,
"key": "Name",
"label": "Deskripsi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Barang dan status",
"detailRole": "information",
"isVisible": true,
"key": "LineNum",
"label": "Nomor urut baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Barang dan status",
"detailRole": "information",
"isVisible": true,
"key": "LineStatus",
"label": "Status baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Barang dan status",
"detailRole": "information",
"isVisible": true,
"key": "LineType",
"label": "Jenis baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan satuan",
"detailRole": "information",
"isVisible": true,
"key": "SalesQty",
"label": "Jumlah pesanan (satuan jual)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas dan satuan",
"detailRole": "information",
"isVisible": true,
"key": "SalesUnit",
"label": "Satuan jual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan satuan",
"detailRole": "information",
"isVisible": true,
"key": "QtyOrdered",
"label": "Jumlah pesanan (satuan inventaris)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas dan satuan",
"detailRole": "information",
"isVisible": true,
"key": "RemainSalesPhysical",
"label": "Belum dikirim (satuan jual)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas dan satuan",
"detailRole": "information",
"isVisible": true,
"key": "RemainSalesFinancial",
"label": "Dikirim, belum diperbarui faktur (satuan jual)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas dan satuan",
"detailRole": "information",
"isVisible": true,
"key": "RemainInventPhysical",
"label": "Belum dikirim (satuan inventaris)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas dan satuan",
"detailRole": "information",
"isVisible": true,
"key": "RemainInventFinancial",
"label": "Dikirim, belum diperbarui faktur (satuan inventaris)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas dan satuan",
"detailRole": "information",
"isVisible": true,
"key": "PackingUnit",
"label": "Satuan kemasan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan satuan",
"detailRole": "information",
"isVisible": true,
"key": "PackingUnitQty",
"label": "Jumlah kemasan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "SalesPrice",
"label": "Harga per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "PriceUnit",
"label": "Jumlah satuan per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "LineAmount",
"label": "Nilai baris sumber setelah diskon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "LineDisc",
"label": "Diskon baris per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "LinePercent",
"label": "Diskon baris (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "MultiLnDisc",
"label": "Diskon multibaris per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "MultiLnPercent",
"label": "Diskon multibaris (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "SalesMarkup",
"label": "Biaya harga tetap sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Jadwal dan toleransi",
"detailRole": "information",
"isVisible": true,
"key": "ShippingDateRequested",
"label": "Pengiriman diminta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jadwal dan toleransi",
"detailRole": "information",
"isVisible": true,
"key": "ShippingDateConfirmed",
"label": "Pengiriman dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jadwal dan toleransi",
"detailRole": "information",
"isVisible": true,
"key": "ReceiptDateRequested",
"label": "Penerimaan diminta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jadwal dan toleransi",
"detailRole": "information",
"isVisible": true,
"key": "ReceiptDateConfirmed",
"label": "Penerimaan dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jadwal dan toleransi",
"detailRole": "information",
"isVisible": true,
"key": "OverDeliveryPct",
"label": "Toleransi lebih kirim (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Jadwal dan toleransi",
"detailRole": "information",
"isVisible": true,
"key": "UnderDeliveryPct",
"label": "Toleransi kurang kirim (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "TaxGroup",
"label": "Kode grup pajak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "TaxItemGroup",
"label": "Kode pajak barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "18DE3984-39D6-58C0-A1CC-A3ECF25872CA",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "AA367C24-B913-596B-AFB8-936AF6AA00E1",
"key": "LineNum",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemId",
"systemImage": "list.bullet",
"title": "Rincian pesanan",
"titleKey": "Name"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CustGroup",
"label": "Grup pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang faktur bawaan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PaymTermId",
"label": "Kode syarat pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BlockStatus",
"label": "Status penangguhan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "B3AA7060-6EBF-5266-B893-CFAFB4F96246",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "CustomerName",
"label": "Nama pelanggan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "AccountNum",
"label": "Akun pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "KnownAs",
"label": "Nama dikenal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "NameAlias",
"label": "Alias pencarian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PartyNumber",
"label": "Nomor pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "CustGroup",
"label": "Grup pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang faktur bawaan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun penerima faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PaymTermId",
"label": "Kode syarat pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PaymMode",
"label": "Kode metode pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "OurAccountNum",
"label": "Akun kita pada pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan status saat ini",
"detailRole": "information",
"isVisible": true,
"key": "DlvMode",
"label": "Kode cara pengiriman bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan status saat ini",
"detailRole": "information",
"isVisible": true,
"key": "DlvTerm",
"label": "Kode syarat pengiriman bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan status saat ini",
"detailRole": "information",
"isVisible": true,
"key": "BlockStatus",
"label": "Status penangguhan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan status saat ini",
"detailRole": "information",
"isVisible": true,
"key": "CreditRating",
"label": "Peringkat kredit tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "3F8934A7-3210-5C96-B1B3-A87EB7231264",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "81F2AA9E-89D6-59B0-8AF0-BE212938DABE",
"key": "CustomerName",
"type": "text"
},
{
"direction": "ascending",
"id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
"key": "CustomerKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountNum",
"systemImage": "person.2",
"title": "Pelanggan pesanan saat ini",
"titleKey": "CustomerName"
}
],
"relations": [
{
"childDatasetID": "FCA4CEE2-DDE2-57FA-8368-A243CDDFE62D",
"childKey": "ParentOrderKey",
"id": "2CFB2338-3741-5589-9582-CF73946311DC",
"name": "Rincian",
"parentDatasetID": "B8252C9C-F13E-59EE-9552-FCD08E541ABA",
"parentKey": "OrderKey"
},
{
"childDatasetID": "B3AA7060-6EBF-5266-B893-CFAFB4F96246",
"childKey": "ParentOrderKey",
"id": "6908B544-1E6C-5440-A7FA-80856001FBA6",
"name": "Pelanggan",
"parentDatasetID": "B8252C9C-F13E-59EE-9552-FCD08E541ABA",
"parentKey": "OrderKey"
}
],
"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 penjualan, layanan pelanggan, gudang dan manajer: pilih periode dibuat UTC, partisi dan perusahaan tersimpan. Lihat pesanan normal, referensi, pembayaran serta jadwal diminta/dikonfirmasi. Buka Rincian untuk kuantitas, satuan, harga per unit harga, diskon, nilai dan status tiap baris. Pelanggan membuka dossier pelanggan SAAT INI, bukan salinan historis pesanan. 72 nilai berguna dalam Detil.\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 KHUSUS: AX 2012 R3 on-premises pada SQL Server, hanya instalasi lama yang sudah ada dengan akses SELECT yang disetujui administrator. Dukungan diperpanjang berakhir 11 Januari 2023 (Microsoft Lifecycle, zona Pacific). Bukan anjuran memasang ERP lama atau membuka server ke internet. Bukan AX 2009, Dynamics 365 Finance/SCM atau Business Central; akses SQL cloud tidak diasumsikan.\n\nPro nyata: satu sumber, satu Home, tiga daftar dan dua sub-tombol lazy. Hanya SalesType=3 (Sales) pada pesanan; bukan penawaran, langganan, jurnal atau retur. Status baris dan jenis baris tetap ditampilkan terpisah, termasuk kode tak dikenal/NULL. Status Difakturkan bukan bukti sudah dibayar.\n\nPeriode memilih tanggal UTC createdDateTime sumber, bukan tanggal faktur atau janji kirim. Waktu lengkap tetap terlihat. Filter asli periode/partisi/perusahaan diterapkan sebelum batas 1.000 baris. Rincian membuka semua baris dari pesanan tepat, bukan hanya baris pada periode. Tidak ada refresh berkala; gunakan rentang sempit dan verifikasi indeks, batas, waktu dan kelengkapan pada instalasi. Batas baris tidak menjamin kueri murah. Jumlah baris menghitung baris sumber, termasuk duplikat: bukan bukti unik atau ekspor seluruh ERP. Kunci duplikat harus diperbaiki oleh administrator, bukan didedup sembarang.\n\nLINGKUP: partisi Int64 diteruskan sebagai teks tanpa pembulatan, dataAreaId tersimpan dan pesanan dipertahankan pada kedua anak. Pencocokan biner membedakan huruf besar/kecil serta spasi akhir. Perusahaan virtual mungkin menggunakan DATAAREAID seperti VIR: administrator harus memverifikasi pemetaan. Filter bukan ACL dan SQL langsung tidak mewarisi AOS/XDS/izin pengguna AX. Gunakan akun SELECT yang dibatasi di server.\n\nNILAI ASLI: SalesPrice dan diskon nominal per PriceUnit, bukan otomatis harga per satu barang. LineAmount adalah nilai baris sumber dengan diskon, bukan total fiskal/PPN pesanan. Tidak ada penjumlahan lintas mata uang, kalkulasi pajak, margin, utang atau pembayaran. Mata uang baris tetap sendiri, tidak ditimpa mata uang pesanan. Kuantitas jual dan inventaris berbeda; satuan inventaris tidak ditebak dari SalesUnit. RemainPhysical/Financial, negatif dan NULL dipertahankan sesuai sumber, tanpa rumus konversi atau pembagian harga dengan nol. Kode pajak dan pengiriman adalah kode, bukan kamus atau perhitungan pajak.\n\nPelanggan adalah master pemesan saat ini, bukan otomatis penerima faktur atau historis. Master hilang tidak menghapus pesanan/baris; sub-tombol dapat tidak memiliki data. Tidak ada kontak privat, alamat, rekening bank, kartu pembayaran, identitas pribadi pemerintah atau mata uang kredit yang ditebak. Nama bisnis tetap dapat merupakan data pribadi; akses hanya bila berwenang.\n\nDokumentasi tabel/kolom dan enum Microsoft AOT mendasari pembuatan ini, bukan sertifikat DDL SQL instalasi Anda. Daftar field indeks/FK yang sparse tidak diisi dengan asumsi. Verifikasi versi R3, modul, pemilik tabel, kolom, kunci, relasi, indeks dan izin aktual sebelum uji baca terbatas saat impor. Paket dan DEMO sepenuhnya fiktif, tanpa kredensial/server/data perusahaan nyata. Tes SQLite adaptasi bukan SQL Server atau ERP nyata.\n\nReferensi pesanan: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg873240(v=ax.60)\nReferensi baris: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg870909(v=ax.60)\nSiklus dukungan: https://learn.microsoft.com/en-us/lifecycle/products/dynamics-ax-2012-r3",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "162FF963-C186-5B01-BD34-733F78BE534F",
"rootButtonCount": 1,
"summary": "Pesanan normal per periode/partisi/perusahaan; jadwal, nilai dan kuantitas baris serta pelanggan saat ini.",
"tags": [
"Dynamics AX 2012 R3",
"SQL Server",
"Pesanan penjualan",
"Rincian",
"Pelanggan",
"Pro"
],
"title": "Pesanan penjualan, rincian dan pelanggan — Pro"
}
}