Pesanan pembelian, baris dan pemasok — Pro
Pesanan normal per periode/partisi/perusahaan; penerimaan, nilai, jadwal, dimensi barang dan pemasok saat ini.
TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA.
Untuk pembelian, penerimaan barang, administrasi pemasok dan manajer: pilih periode dibuat UTC, partisi dan perusahaan. Periksa pesanan normal, pemasok pemesanan/penagih, referensi, kondisi serta jadwal. Baris membuka jumlah beli/inventaris, sisa penerimaan/faktur, harga, diskon, peran jadwal, gudang, tempat, batch, seri dan varian. Pemasok membuka kondisi master SAAT INI. 91 posisi 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 SQL Server, hanya instalasi lama yang sudah ada. 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, Business Central atau akses SQL cloud.
Pro nyata: satu sumber, satu Home, tiga daftar dan dua sub-tombol lazy. Hanya PurchaseType=3 (Purch) pada antet, bukan retur, jurnal atau kode DEL lama. Status Diterima berarti penerimaan, bukan status penjualan. Difakturkan bukan bukti sudah dibayar. Jenis/status/peran jadwal baris sendiri tetap ditampilkan, termasuk NULL dan kode asing. LineNumber Int64 sebagai teks utuh, bukan SalesLine.LineNum.
Periode asli memilih createdDateTime UTC sumber; bukan tanggal faktur/jatuh tempo atau pengiriman. Waktu lengkap tetap terlihat. Periode/partisi/perusahaan diterapkan sebelum batas 1.000 baris. Baris membuka semua baris pesanan tepat, tanpa memfilter lagi jadwal anak menurut periode. Jumlah baris mencakup baris jadwal dan duplikat: bukan jumlah barang unik atau ekspor lengkap. Tidak ada refresh berkala. Batas baris bukan jaminan kueri murah; verifikasi kunci, indeks, waktu dan kelengkapan lokal. Duplikat tidak disembunyikan.
NILAI ASLI: PurchPrice dan diskon nominal baris per PriceUnit, bukan otomatis per satu barang. LineAmount setelah diskon, bukan total fiskal/PPN pesanan. Tidak ada SUM baris pesanan dan jadwal yang bisa menggandakan nilai; tidak ada total lintas mata uang, pajak, margin, utang atau pembayaran dihitung. Mata uang baris tetap sendiri. Kuantitas beli dan inventaris berbeda; satuan inventaris tidak ditebak dari PurchUnit. Sisa fisik belum diterima dan sisa finansial diterima belum diperbarui faktur ditampilkan terpisah. Negatif, nol, NULL dipertahankan; tidak ada pembagian dengan nol, konversi atau jumlah penerimaan historis yang ditebak.
KONDISI: LineDisc pada antet/master adalah KODE grup; pada baris adalah jumlah diskon per PriceUnit. DiscPercent antet adalah diskon total persentase sumber. Grup harga/diskon/biaya, CashDisc, kode pembayaran, pengiriman dan pajak bukan harga, tanggal jatuh tempo, pajak atau pembayaran final yang dihitung. DeliveryName adalah nama alamat pengiriman, bukan otomatis nama pemasok.
DIMENSI: InventDim opsional dipasangkan dengan partisi, perusahaan tersimpan dan InventDimId tepat. Lokasi/gudang/tempat/batch/seri/warna/ukuran/gaya adalah kode konteks saat ini, bukan nama produk terjemahan atau kuantitas stok. Dimensi hilang tidak menghapus baris; nilai tidak tersedia tetap kosong. Verifikasi fitur/modul serta kunci unik pada instalasi. Pemasok adalah OrderAccount saat ini, bukan otomatis InvoiceAccount, pemasok baris atau salinan historis. Master hilang tidak menghapus pesanan/baris.
AKSES: seluruh anak mempertahankan partisi, DATAAREAID tersimpan, RecId dan PurchId tepat. Int64 diteruskan sebagai teks tanpa pembulatan; pencocokan biner membedakan huruf besar/kecil dan spasi akhir. Perusahaan virtual seperti VIR perlu pemetaan administrator. Filter bukan ACL; SQL langsung tidak mewarisi AOS/XDS atau izin AX. Gunakan akun SELECT dibatasi pada server. Tidak ada kontak privat, alamat lengkap, bank, identitas pemerintah pribadi, audit atau CreditMax dengan mata uang yang ditebak. Nama bisnis tetap dapat merupakan data pribadi; hanya akses berwenang.
DOKUMENTASI: Microsoft AOT tabel/kolom dan enum asli, bukan sertifikat DDL SQL instalasi. Verifikasi versi R3, modul, schema pemilik, kolom, relasi, kunci, indeks dan izin aktual sebelum uji baca terbatas saat impor. Daftar FK/index sparse tidak diisi dengan asumsi. Paket/DEMO tanpa kredensial, server atau 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/gg928139(v=ax.60)
Referensi baris: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg955711(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 pembelian
- Details: Baris
- Details: Pemasok
- Sub-button: Baris pembelian
- Sub-button: Pemasok 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.PurchId AS PurchId, o.PurchName AS PurchName, pt.PartitionKey AS PartitionKey, o.dataAreaId AS dataAreaId, o.OrderAccount AS OrderAccount, o.InvoiceAccount AS InvoiceAccount, o.CurrencyCode AS CurrencyCode, CASE WHEN o.PurchStatus IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.PurchStatus WHEN 0 THEN N'Tidak ditentukan' WHEN 1 THEN N'Terbuka' WHEN 2 THEN N'Diterima' WHEN 3 THEN N'Difakturkan' WHEN 4 THEN N'Dibatalkan' ELSE CONCAT(N'Kode sumber ',o.PurchStatus) END END AS OrderStatus, CASE WHEN o.PurchaseType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.PurchaseType WHEN 0 THEN N'Jurnal' WHEN 1 THEN N'DEL_Quotation (kode lama)' WHEN 2 THEN N'DEL_Subscription (kode lama)' WHEN 3 THEN N'Pesanan pembelian' WHEN 4 THEN N'Retur' WHEN 5 THEN N'DEL_Blanket (kode lama)' ELSE CONCAT(N'Kode sumber ',o.PurchaseType) END END AS OrderType, o.VendorRef AS VendorRef, o.createdDateTime AS OrderCreatedUTC, (SELECT COUNT_BIG(*) FROM PurchLine l WHERE l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(l.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max))) AS LineCount, o.Payment AS Payment, o.PaymMode AS PaymMode, o.PaymSpec AS PaymSpec, o.CashDisc AS CashDisc, o.PriceGroupId AS PriceGroupId, o.LineDisc AS LineDisc, o.MultiLineDisc AS MultiLineDisc, o.EndDisc AS EndDisc, o.DiscPercent AS DiscPercent, o.DeliveryName AS DeliveryName, o.DeliveryDate AS DeliveryDate, o.ConfirmedDlv AS ConfirmedDlv, o.DlvMode AS DlvMode, o.DlvTerm AS DlvTerm, o.InventLocationId AS InventLocationId, o.InventSiteId AS InventSiteId, o.PurchPoolId AS PurchPoolId, o.ProjId AS ProjId FROM PurchTable o INNER JOIN Partitions pt ON pt.RecId=o.Partition WHERE o.PurchaseType=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.PurchId IS NOT NULL AND DATALENGTH(o.PurchId)>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'PurchTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PurchTable',N'U') AND OBJECT_ID(N'PurchLine',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PurchLine',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'VendTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',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.ExternalItemId AS ExternalItemId, CAST(l.LineNumber AS nvarchar(30)) AS LineNumber, l.CurrencyCode AS CurrencyCode, CASE WHEN l.PurchStatus IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE l.PurchStatus WHEN 0 THEN N'Tidak ditentukan' WHEN 1 THEN N'Terbuka' WHEN 2 THEN N'Diterima' WHEN 3 THEN N'Difakturkan' WHEN 4 THEN N'Dibatalkan' ELSE CONCAT(N'Kode sumber ',l.PurchStatus) END END AS LineStatus, CASE WHEN l.PurchaseType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE l.PurchaseType WHEN 0 THEN N'Jurnal' WHEN 1 THEN N'DEL_Quotation (kode lama)' WHEN 2 THEN N'DEL_Subscription (kode lama)' WHEN 3 THEN N'Pesanan pembelian' WHEN 4 THEN N'Retur' WHEN 5 THEN N'DEL_Blanket (kode lama)' ELSE CONCAT(N'Kode sumber ',l.PurchaseType) END END AS LineType, CASE WHEN l.LineDeliveryType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE l.LineDeliveryType WHEN 0 THEN N'Baris pesanan' WHEN 1 THEN N'Baris pesanan, beberapa pengiriman' WHEN 2 THEN N'Baris jadwal pengiriman' ELSE CONCAT(N'Kode sumber ',l.LineDeliveryType) END END AS DeliveryRole, l.PurchQty AS PurchQty, l.PurchUnit AS PurchUnit, l.QtyOrdered AS QtyOrdered, l.PurchPrice AS PurchPrice, 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.PurchMarkup AS PurchMarkup, l.RemainPurchPhysical AS RemainPurchPhysical, l.RemainPurchFinancial AS RemainPurchFinancial, l.RemainInventPhysical AS RemainInventPhysical, l.RemainInventFinancial AS RemainInventFinancial, l.DeliveryDate AS DeliveryDate, l.ConfirmedDlv AS ConfirmedDlv, l.DeliveryName AS DeliveryName, l.OverDeliveryPct AS OverDeliveryPct, l.UnderDeliveryPct AS UnderDeliveryPct, l.TaxGroup AS TaxGroup, l.TaxItemGroup AS TaxItemGroup, l.VendAccount AS VendAccount, d.InventSiteId AS InventSiteId, d.InventLocationId AS InventLocationId, 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 FROM PurchTable o INNER JOIN Partitions pt ON pt.RecId=o.Partition INNER JOIN PurchLine l ON l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(l.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max)) LEFT JOIN InventDim d ON d.Partition=l.Partition AND CAST(d.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND l.InventDimId IS NOT NULL AND DATALENGTH(l.InventDimId)>0 AND CAST(d.inventDimId AS varbinary(max))=CAST(l.InventDimId 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.PurchId AS varbinary(max))=CAST(:orderId AS varbinary(max)) AND o.PurchaseType=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.PurchId IS NOT NULL AND DATALENGTH(o.PurchId)>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'PurchTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PurchTable',N'U') AND OBJECT_ID(N'PurchLine',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PurchLine',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'VendTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',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 VendorKey, 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 VendorName, m.AccountNum AS AccountNum, p.KnownAs AS KnownAs, p.NameAlias AS NameAlias, p.PartyNumber AS PartyNumber, m.VendGroup AS VendGroup, m.Currency AS Currency, m.InvoiceAccount AS InvoiceAccount, m.YourAccountNum AS YourAccountNum, m.PaymTermId AS PaymTermId, m.PaymMode AS PaymMode, m.PaymSpec AS PaymSpec, m.CashDisc AS CashDisc, m.PriceGroup AS PriceGroup, m.LineDisc AS LineDisc, m.MultiLineDisc AS MultiLineDisc, m.EndDisc AS EndDisc, m.MarkupGroup AS MarkupGroup, 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 FROM PurchTable o INNER JOIN Partitions pt ON pt.RecId=o.Partition INNER JOIN VendTable 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.OrderAccount 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.PurchId AS varbinary(max))=CAST(:orderId AS varbinary(max)) AND o.PurchaseType=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.PurchId IS NOT NULL AND DATALENGTH(o.PurchId)>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'PurchTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PurchTable',N'U') AND OBJECT_ID(N'PurchLine',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PurchLine',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'VendTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',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": "00B997E1-0867-5D34-9ABF-82208D3CB431",
"kind": "sqlServer",
"requiredObjects": [
"PurchTable",
"PurchLine",
"Partitions",
"VendTable",
"DirPartyTable",
"InventDim"
],
"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": "8521AA55-6ADE-5C42-9151-6822BC179831",
"key": "PurchId",
"type": "text"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"id": "21997538-D1E8-5639-B1FB-411714957E53",
"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": "PurchId",
"label": "Nomor pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchName",
"label": "Deskripsi pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchName",
"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": "OrderAccount",
"label": "Akun pemasok pemesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceAccount",
"label": "Akun pemasok penagih",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Mata uang penagihan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderStatus",
"label": "Status pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderType",
"label": "Jenis pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorRef",
"label": "Referensi pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorRef",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderCreatedUTC",
"label": "Pesanan dibuat (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderCreatedUTC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"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": "PaymSpec",
"label": "Kode penanganan pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymSpec",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CashDisc",
"label": "Kode diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CashDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PriceGroupId",
"label": "Grup harga pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PriceGroupId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineDisc",
"label": "Grup diskon baris pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MultiLineDisc",
"label": "Grup diskon multibaris pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MultiLineDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EndDisc",
"label": "Grup diskon total pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EndDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscPercent",
"label": "Diskon total sumber (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscPercent",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DeliveryName",
"label": "Nama pada alamat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DeliveryName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DeliveryDate",
"label": "Tanggal pengiriman pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DeliveryDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ConfirmedDlv",
"label": "Pengiriman pesanan dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ConfirmedDlv",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"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": "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": "PurchPoolId",
"label": "Kelompok pesanan pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchPoolId",
"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 pembelian",
"primaryKey": "OrderKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"PurchId",
"PurchName",
"PartitionKey",
"dataAreaId",
"OrderAccount",
"InvoiceAccount",
"CurrencyCode",
"OrderStatus",
"OrderType",
"VendorRef",
"OrderCreatedUTC",
"LineCount",
"Payment",
"PaymMode",
"PaymSpec",
"CashDisc",
"PriceGroupId",
"LineDisc",
"MultiLineDisc",
"EndDisc",
"DiscPercent",
"DeliveryName",
"DeliveryDate",
"ConfirmedDlv",
"DlvMode",
"DlvTerm",
"InventLocationId",
"InventSiteId",
"PurchPoolId",
"ProjId"
],
"sourceID": "00B997E1-0867-5D34-9ABF-82208D3CB431",
"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.PurchId AS PurchId, o.PurchName AS PurchName, pt.PartitionKey AS PartitionKey, o.dataAreaId AS dataAreaId, o.OrderAccount AS OrderAccount, o.InvoiceAccount AS InvoiceAccount, o.CurrencyCode AS CurrencyCode, CASE WHEN o.PurchStatus IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.PurchStatus WHEN 0 THEN N'Tidak ditentukan' WHEN 1 THEN N'Terbuka' WHEN 2 THEN N'Diterima' WHEN 3 THEN N'Difakturkan' WHEN 4 THEN N'Dibatalkan' ELSE CONCAT(N'Kode sumber ',o.PurchStatus) END END AS OrderStatus, CASE WHEN o.PurchaseType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.PurchaseType WHEN 0 THEN N'Jurnal' WHEN 1 THEN N'DEL_Quotation (kode lama)' WHEN 2 THEN N'DEL_Subscription (kode lama)' WHEN 3 THEN N'Pesanan pembelian' WHEN 4 THEN N'Retur' WHEN 5 THEN N'DEL_Blanket (kode lama)' ELSE CONCAT(N'Kode sumber ',o.PurchaseType) END END AS OrderType, o.VendorRef AS VendorRef, o.createdDateTime AS OrderCreatedUTC, (SELECT COUNT_BIG(*) FROM PurchLine l WHERE l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(l.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max))) AS LineCount, o.Payment AS Payment, o.PaymMode AS PaymMode, o.PaymSpec AS PaymSpec, o.CashDisc AS CashDisc, o.PriceGroupId AS PriceGroupId, o.LineDisc AS LineDisc, o.MultiLineDisc AS MultiLineDisc, o.EndDisc AS EndDisc, o.DiscPercent AS DiscPercent, o.DeliveryName AS DeliveryName, o.DeliveryDate AS DeliveryDate, o.ConfirmedDlv AS ConfirmedDlv, o.DlvMode AS DlvMode, o.DlvTerm AS DlvTerm, o.InventLocationId AS InventLocationId, o.InventSiteId AS InventSiteId, o.PurchPoolId AS PurchPoolId, o.ProjId AS ProjId FROM PurchTable o INNER JOIN Partitions pt ON pt.RecId=o.Partition WHERE o.PurchaseType=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.PurchId IS NOT NULL AND DATALENGTH(o.PurchId)>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'PurchTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PurchTable',N'U') AND OBJECT_ID(N'PurchLine',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PurchLine',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'VendTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "F5704292-0D46-53B6-A7FA-C8450E931C6B",
"key": "Name",
"type": "text"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "749391A8-4871-59E2-828B-86271F1819A8",
"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": "ExternalItemId",
"label": "Kode barang pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ExternalItemId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineNumber",
"label": "Nomor baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Mata uang penagihan 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 pembelian baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DeliveryRole",
"label": "Peran baris dalam jadwal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DeliveryRole",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchQty",
"label": "Jumlah pesanan (satuan beli)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PurchQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PurchUnit",
"label": "Satuan beli",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchUnit",
"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": "PurchPrice",
"label": "Harga per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PurchPrice",
"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": "PurchMarkup",
"label": "Biaya harga tetap sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PurchMarkup",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RemainPurchPhysical",
"label": "Belum diterima (satuan beli)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RemainPurchPhysical",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RemainPurchFinancial",
"label": "Diterima, belum diperbarui faktur (satuan beli)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RemainPurchFinancial",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RemainInventPhysical",
"label": "Belum diterima (satuan inventaris)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RemainInventPhysical",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RemainInventFinancial",
"label": "Diterima, belum diperbarui faktur (satuan inventaris)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RemainInventFinancial",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DeliveryDate",
"label": "Tanggal pengiriman baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DeliveryDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ConfirmedDlv",
"label": "Pengiriman baris dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ConfirmedDlv",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DeliveryName",
"label": "Nama pada alamat pengiriman baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DeliveryName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OverDeliveryPct",
"label": "Toleransi lebih terima (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OverDeliveryPct",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UnderDeliveryPct",
"label": "Toleransi kurang terima (%)",
"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
},
{
"commonFieldKey": "",
"key": "VendAccount",
"label": "Akun pemasok baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventSiteId",
"label": "Kode lokasi dimensi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventSiteId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventLocationId",
"label": "Kode gudang dimensi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventLocationId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "wMSLocationId",
"label": "Kode tempat gudang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "wMSLocationId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "inventBatchId",
"label": "Kode 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": "Kode konfigurasi barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "configId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventColorId",
"label": "Kode warna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventColorId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventSizeId",
"label": "Kode ukuran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventSizeId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventStyleId",
"label": "Kode gaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventStyleId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Baris pembelian",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "2918EB34-026A-5974-911E-D5387F85736E",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "9CC1F542-A538-55B5-A5ED-9D39A735ECB3",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderRecId",
"id": "A856D04D-581A-520B-9185-70DD152202D2",
"name": "orderRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PurchId",
"id": "9B67EA53-3C69-5A82-9A12-C85A5C7885C3",
"name": "orderId",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemId",
"Name",
"ExternalItemId",
"LineNumber",
"CurrencyCode",
"LineStatus",
"LineType",
"DeliveryRole",
"PurchQty",
"PurchUnit",
"QtyOrdered",
"PurchPrice",
"PriceUnit",
"LineAmount",
"LineDisc",
"LinePercent",
"MultiLnDisc",
"MultiLnPercent",
"PurchMarkup",
"RemainPurchPhysical",
"RemainPurchFinancial",
"RemainInventPhysical",
"RemainInventFinancial",
"DeliveryDate",
"ConfirmedDlv",
"DeliveryName",
"OverDeliveryPct",
"UnderDeliveryPct",
"TaxGroup",
"TaxItemGroup",
"VendAccount",
"InventSiteId",
"InventLocationId",
"wMSLocationId",
"inventBatchId",
"inventSerialId",
"configId",
"InventColorId",
"InventSizeId",
"InventStyleId"
],
"sourceID": "00B997E1-0867-5D34-9ABF-82208D3CB431",
"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.ExternalItemId AS ExternalItemId, CAST(l.LineNumber AS nvarchar(30)) AS LineNumber, l.CurrencyCode AS CurrencyCode, CASE WHEN l.PurchStatus IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE l.PurchStatus WHEN 0 THEN N'Tidak ditentukan' WHEN 1 THEN N'Terbuka' WHEN 2 THEN N'Diterima' WHEN 3 THEN N'Difakturkan' WHEN 4 THEN N'Dibatalkan' ELSE CONCAT(N'Kode sumber ',l.PurchStatus) END END AS LineStatus, CASE WHEN l.PurchaseType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE l.PurchaseType WHEN 0 THEN N'Jurnal' WHEN 1 THEN N'DEL_Quotation (kode lama)' WHEN 2 THEN N'DEL_Subscription (kode lama)' WHEN 3 THEN N'Pesanan pembelian' WHEN 4 THEN N'Retur' WHEN 5 THEN N'DEL_Blanket (kode lama)' ELSE CONCAT(N'Kode sumber ',l.PurchaseType) END END AS LineType, CASE WHEN l.LineDeliveryType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE l.LineDeliveryType WHEN 0 THEN N'Baris pesanan' WHEN 1 THEN N'Baris pesanan, beberapa pengiriman' WHEN 2 THEN N'Baris jadwal pengiriman' ELSE CONCAT(N'Kode sumber ',l.LineDeliveryType) END END AS DeliveryRole, l.PurchQty AS PurchQty, l.PurchUnit AS PurchUnit, l.QtyOrdered AS QtyOrdered, l.PurchPrice AS PurchPrice, 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.PurchMarkup AS PurchMarkup, l.RemainPurchPhysical AS RemainPurchPhysical, l.RemainPurchFinancial AS RemainPurchFinancial, l.RemainInventPhysical AS RemainInventPhysical, l.RemainInventFinancial AS RemainInventFinancial, l.DeliveryDate AS DeliveryDate, l.ConfirmedDlv AS ConfirmedDlv, l.DeliveryName AS DeliveryName, l.OverDeliveryPct AS OverDeliveryPct, l.UnderDeliveryPct AS UnderDeliveryPct, l.TaxGroup AS TaxGroup, l.TaxItemGroup AS TaxItemGroup, l.VendAccount AS VendAccount, d.InventSiteId AS InventSiteId, d.InventLocationId AS InventLocationId, 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 FROM PurchTable o INNER JOIN Partitions pt ON pt.RecId=o.Partition INNER JOIN PurchLine l ON l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(l.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max)) LEFT JOIN InventDim d ON d.Partition=l.Partition AND CAST(d.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND l.InventDimId IS NOT NULL AND DATALENGTH(l.InventDimId)>0 AND CAST(d.inventDimId AS varbinary(max))=CAST(l.InventDimId 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.PurchId AS varbinary(max))=CAST(:orderId AS varbinary(max)) AND o.PurchaseType=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.PurchId IS NOT NULL AND DATALENGTH(o.PurchId)>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'PurchTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PurchTable',N'U') AND OBJECT_ID(N'PurchLine',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PurchLine',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'VendTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "B3C5665E-F32F-5A05-BB03-A0E5B7192640",
"key": "VendorName",
"type": "text"
},
{
"direction": "ascending",
"id": "BC515F3F-CAEC-53F1-9967-06042027411E",
"key": "VendorKey",
"type": "text"
}
],
"id": "2B8047BE-A4D2-5C0B-8675-9E6918F04E01",
"mappings": [
{
"commonFieldKey": "",
"key": "VendorKey",
"label": "Internal VendorKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorKey",
"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": "VendorName",
"label": "Nama pemasok saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountNum",
"label": "Akun pemasok",
"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": "VendGroup",
"label": "Grup pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Currency",
"label": "Mata uang faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Currency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceAccount",
"label": "Akun penagih bawaan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "YourAccountNum",
"label": "Akun kita pada pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "YourAccountNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymTermId",
"label": "Kode syarat pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymTermId",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PaymMode",
"label": "Kode metode pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymMode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymSpec",
"label": "Kode penanganan pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymSpec",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CashDisc",
"label": "Kode diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CashDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PriceGroup",
"label": "Grup harga pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PriceGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineDisc",
"label": "Grup diskon baris bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MultiLineDisc",
"label": "Grup diskon multibaris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MultiLineDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EndDisc",
"label": "Grup diskon total",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EndDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MarkupGroup",
"label": "Grup biaya tambahan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MarkupGroup",
"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": "BlockStatus",
"label": "Penangguhan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BlockStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1000,
"name": "Pemasok pesanan saat ini",
"primaryKey": "VendorKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "2918EB34-026A-5974-911E-D5387F85736E",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "9CC1F542-A538-55B5-A5ED-9D39A735ECB3",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderRecId",
"id": "A856D04D-581A-520B-9185-70DD152202D2",
"name": "orderRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PurchId",
"id": "9B67EA53-3C69-5A82-9A12-C85A5C7885C3",
"name": "orderId",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VendorName",
"AccountNum",
"KnownAs",
"NameAlias",
"PartyNumber",
"VendGroup",
"Currency",
"InvoiceAccount",
"YourAccountNum",
"PaymTermId",
"PaymMode",
"PaymSpec",
"CashDisc",
"PriceGroup",
"LineDisc",
"MultiLineDisc",
"EndDisc",
"MarkupGroup",
"DlvMode",
"DlvTerm",
"BlockStatus"
],
"sourceID": "00B997E1-0867-5D34-9ABF-82208D3CB431",
"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 VendorKey, 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 VendorName, m.AccountNum AS AccountNum, p.KnownAs AS KnownAs, p.NameAlias AS NameAlias, p.PartyNumber AS PartyNumber, m.VendGroup AS VendGroup, m.Currency AS Currency, m.InvoiceAccount AS InvoiceAccount, m.YourAccountNum AS YourAccountNum, m.PaymTermId AS PaymTermId, m.PaymMode AS PaymMode, m.PaymSpec AS PaymSpec, m.CashDisc AS CashDisc, m.PriceGroup AS PriceGroup, m.LineDisc AS LineDisc, m.MultiLineDisc AS MultiLineDisc, m.EndDisc AS EndDisc, m.MarkupGroup AS MarkupGroup, 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 FROM PurchTable o INNER JOIN Partitions pt ON pt.RecId=o.Partition INNER JOIN VendTable 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.OrderAccount 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.PurchId AS varbinary(max))=CAST(:orderId AS varbinary(max)) AND o.PurchaseType=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.PurchId IS NOT NULL AND DATALENGTH(o.PurchId)>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'PurchTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PurchTable',N'U') AND OBJECT_ID(N'PurchLine',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.PurchLine',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'VendTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "40114DC6-FC23-59E0-8F85-21D3EB5EEFB2",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "0D0592A1-61C0-507D-B46F-61B80B421CCD",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "749391A8-4871-59E2-828B-86271F1819A8",
"title": "Baris",
"urlKey": ""
},
{
"id": "0989AF67-22CF-5FC1-BFCD-792C75688FAF",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "156B3262-C845-5A99-B6E7-24B562557AE2",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "2B8047BE-A4D2-5C0B-8675-9E6918F04E01",
"title": "Pemasok",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderAccount",
"label": "Akun pemasok pemesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang penagihan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderStatus",
"label": "Status pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryDate",
"label": "Tanggal pengiriman pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ConfirmedDlv",
"label": "Pengiriman pesanan dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Jumlah baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "21997538-D1E8-5639-B1FB-411714957E53",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Pembelian dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "PurchId",
"label": "Nomor pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "PurchName",
"label": "Deskripsi pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "PartitionKey",
"label": "Partisi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "dataAreaId",
"label": "Perusahaan tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "OrderAccount",
"label": "Akun pemasok pemesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun pemasok penagih",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "VendorRef",
"label": "Referensi pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "OrderCreatedUTC",
"label": "Pesanan dibuat (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Jumlah baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pembelian dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "OrderStatus",
"label": "Status pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "OrderType",
"label": "Jenis pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan kondisi pesanan",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang penagihan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan kondisi pesanan",
"detailRole": "information",
"isVisible": true,
"key": "Payment",
"label": "Kode syarat pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan kondisi pesanan",
"detailRole": "information",
"isVisible": true,
"key": "PaymMode",
"label": "Kode metode pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan kondisi pesanan",
"detailRole": "information",
"isVisible": true,
"key": "PaymSpec",
"label": "Kode penanganan pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan kondisi pesanan",
"detailRole": "information",
"isVisible": true,
"key": "CashDisc",
"label": "Kode diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan kondisi pesanan",
"detailRole": "information",
"isVisible": true,
"key": "PriceGroupId",
"label": "Grup harga pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan kondisi pesanan",
"detailRole": "information",
"isVisible": true,
"key": "LineDisc",
"label": "Grup diskon baris pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan kondisi pesanan",
"detailRole": "information",
"isVisible": true,
"key": "MultiLineDisc",
"label": "Grup diskon multibaris pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan kondisi pesanan",
"detailRole": "information",
"isVisible": true,
"key": "EndDisc",
"label": "Grup diskon total pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan kondisi pesanan",
"detailRole": "information",
"isVisible": true,
"key": "DiscPercent",
"label": "Diskon total sumber (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pengiriman dan referensi",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryName",
"label": "Nama pada alamat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan referensi",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryDate",
"label": "Tanggal pengiriman pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan referensi",
"detailRole": "information",
"isVisible": true,
"key": "ConfirmedDlv",
"label": "Pengiriman pesanan dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan referensi",
"detailRole": "information",
"isVisible": true,
"key": "DlvMode",
"label": "Kode cara pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan referensi",
"detailRole": "information",
"isVisible": true,
"key": "DlvTerm",
"label": "Kode syarat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan referensi",
"detailRole": "information",
"isVisible": true,
"key": "InventLocationId",
"label": "Kode gudang pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan referensi",
"detailRole": "information",
"isVisible": true,
"key": "InventSiteId",
"label": "Kode lokasi pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan referensi",
"detailRole": "information",
"isVisible": true,
"key": "PurchPoolId",
"label": "Kelompok pesanan pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan referensi",
"detailRole": "information",
"isVisible": true,
"key": "ProjId",
"label": "Referensi proyek",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "D60BF77D-E508-5E16-BD04-6019043D5CDF",
"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": "8521AA55-6ADE-5C42-9151-6822BC179831",
"key": "PurchId",
"type": "text"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "PurchName",
"systemImage": "cart",
"title": "Pesanan pembelian",
"titleKey": "PurchId"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PurchQty",
"label": "Jumlah pesanan (satuan beli)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PurchUnit",
"label": "Satuan beli",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PurchPrice",
"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 penagihan baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineStatus",
"label": "Status baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "749391A8-4871-59E2-828B-86271F1819A8",
"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": "ExternalItemId",
"label": "Kode barang pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Barang dan status",
"detailRole": "information",
"isVisible": true,
"key": "LineNumber",
"label": "Nomor baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Barang dan status",
"detailRole": "information",
"isVisible": true,
"key": "VendAccount",
"label": "Akun pemasok baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"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 pembelian baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Barang dan status",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryRole",
"label": "Peran baris dalam jadwal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan penerimaan",
"detailRole": "information",
"isVisible": true,
"key": "PurchQty",
"label": "Jumlah pesanan (satuan beli)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas dan penerimaan",
"detailRole": "information",
"isVisible": true,
"key": "PurchUnit",
"label": "Satuan beli",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan penerimaan",
"detailRole": "information",
"isVisible": true,
"key": "QtyOrdered",
"label": "Jumlah pesanan (satuan inventaris)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas dan penerimaan",
"detailRole": "information",
"isVisible": true,
"key": "RemainPurchPhysical",
"label": "Belum diterima (satuan beli)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas dan penerimaan",
"detailRole": "information",
"isVisible": true,
"key": "RemainPurchFinancial",
"label": "Diterima, belum diperbarui faktur (satuan beli)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas dan penerimaan",
"detailRole": "information",
"isVisible": true,
"key": "RemainInventPhysical",
"label": "Belum diterima (satuan inventaris)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas dan penerimaan",
"detailRole": "information",
"isVisible": true,
"key": "RemainInventFinancial",
"label": "Diterima, belum diperbarui faktur (satuan inventaris)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang penagihan baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "PurchPrice",
"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": "PurchMarkup",
"label": "Biaya harga tetap sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Jadwal dan toleransi",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryDate",
"label": "Tanggal pengiriman baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jadwal dan toleransi",
"detailRole": "information",
"isVisible": true,
"key": "ConfirmedDlv",
"label": "Pengiriman baris dikonfirmasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jadwal dan toleransi",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryName",
"label": "Nama pada alamat pengiriman baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jadwal dan toleransi",
"detailRole": "information",
"isVisible": true,
"key": "OverDeliveryPct",
"label": "Toleransi lebih terima (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Jadwal dan toleransi",
"detailRole": "information",
"isVisible": true,
"key": "UnderDeliveryPct",
"label": "Toleransi kurang terima (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InventSiteId",
"label": "Kode lokasi dimensi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InventLocationId",
"label": "Kode gudang dimensi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "wMSLocationId",
"label": "Kode tempat gudang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "inventBatchId",
"label": "Kode batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "inventSerialId",
"label": "Nomor seri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "configId",
"label": "Kode konfigurasi barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InventColorId",
"label": "Kode warna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InventSizeId",
"label": "Kode ukuran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InventStyleId",
"label": "Kode gaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"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": "2F5030B7-635B-5345-88A1-1B8AAD698FE2",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "F5704292-0D46-53B6-A7FA-C8450E931C6B",
"key": "Name",
"type": "text"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemId",
"systemImage": "list.bullet",
"title": "Baris pembelian",
"titleKey": "Name"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VendGroup",
"label": "Grup pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PaymTermId",
"label": "Kode syarat pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BlockStatus",
"label": "Penangguhan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "2B8047BE-A4D2-5C0B-8675-9E6918F04E01",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identitas pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "VendorName",
"label": "Nama pemasok saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "AccountNum",
"label": "Akun pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "KnownAs",
"label": "Nama dikenal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "NameAlias",
"label": "Alias pencarian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PartyNumber",
"label": "Nomor pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "VendGroup",
"label": "Grup pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun penagih bawaan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "YourAccountNum",
"label": "Akun kita pada pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PaymTermId",
"label": "Kode syarat pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PaymMode",
"label": "Kode metode pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PaymSpec",
"label": "Kode penanganan pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "CashDisc",
"label": "Kode diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kondisi pembelian bawaan",
"detailRole": "information",
"isVisible": true,
"key": "PriceGroup",
"label": "Grup harga pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kondisi pembelian bawaan",
"detailRole": "information",
"isVisible": true,
"key": "LineDisc",
"label": "Grup diskon baris bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kondisi pembelian bawaan",
"detailRole": "information",
"isVisible": true,
"key": "MultiLineDisc",
"label": "Grup diskon multibaris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kondisi pembelian bawaan",
"detailRole": "information",
"isVisible": true,
"key": "EndDisc",
"label": "Grup diskon total",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kondisi pembelian bawaan",
"detailRole": "information",
"isVisible": true,
"key": "MarkupGroup",
"label": "Grup biaya tambahan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan penangguhan",
"detailRole": "information",
"isVisible": true,
"key": "DlvMode",
"label": "Kode cara pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan penangguhan",
"detailRole": "information",
"isVisible": true,
"key": "DlvTerm",
"label": "Kode syarat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan penangguhan",
"detailRole": "information",
"isVisible": true,
"key": "BlockStatus",
"label": "Penangguhan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "0FA94F03-B6E0-57C4-9831-7D9494BB737A",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "B3C5665E-F32F-5A05-BB03-A0E5B7192640",
"key": "VendorName",
"type": "text"
},
{
"direction": "ascending",
"id": "BC515F3F-CAEC-53F1-9967-06042027411E",
"key": "VendorKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountNum",
"systemImage": "shippingbox",
"title": "Pemasok pesanan saat ini",
"titleKey": "VendorName"
}
],
"relations": [
{
"childDatasetID": "749391A8-4871-59E2-828B-86271F1819A8",
"childKey": "ParentOrderKey",
"id": "0D0592A1-61C0-507D-B46F-61B80B421CCD",
"name": "Baris",
"parentDatasetID": "21997538-D1E8-5639-B1FB-411714957E53",
"parentKey": "OrderKey"
},
{
"childDatasetID": "2B8047BE-A4D2-5C0B-8675-9E6918F04E01",
"childKey": "ParentOrderKey",
"id": "156B3262-C845-5A99-B6E7-24B562557AE2",
"name": "Pemasok",
"parentDatasetID": "21997538-D1E8-5639-B1FB-411714957E53",
"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 pembelian, penerimaan barang, administrasi pemasok dan manajer: pilih periode dibuat UTC, partisi dan perusahaan. Periksa pesanan normal, pemasok pemesanan/penagih, referensi, kondisi serta jadwal. Baris membuka jumlah beli/inventaris, sisa penerimaan/faktur, harga, diskon, peran jadwal, gudang, tempat, batch, seri dan varian. Pemasok membuka kondisi master SAAT INI. 91 posisi 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 SQL Server, hanya instalasi lama yang sudah ada. 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, Business Central atau akses SQL cloud.\n\nPro nyata: satu sumber, satu Home, tiga daftar dan dua sub-tombol lazy. Hanya PurchaseType=3 (Purch) pada antet, bukan retur, jurnal atau kode DEL lama. Status Diterima berarti penerimaan, bukan status penjualan. Difakturkan bukan bukti sudah dibayar. Jenis/status/peran jadwal baris sendiri tetap ditampilkan, termasuk NULL dan kode asing. LineNumber Int64 sebagai teks utuh, bukan SalesLine.LineNum.\n\nPeriode asli memilih createdDateTime UTC sumber; bukan tanggal faktur/jatuh tempo atau pengiriman. Waktu lengkap tetap terlihat. Periode/partisi/perusahaan diterapkan sebelum batas 1.000 baris. Baris membuka semua baris pesanan tepat, tanpa memfilter lagi jadwal anak menurut periode. Jumlah baris mencakup baris jadwal dan duplikat: bukan jumlah barang unik atau ekspor lengkap. Tidak ada refresh berkala. Batas baris bukan jaminan kueri murah; verifikasi kunci, indeks, waktu dan kelengkapan lokal. Duplikat tidak disembunyikan.\n\nNILAI ASLI: PurchPrice dan diskon nominal baris per PriceUnit, bukan otomatis per satu barang. LineAmount setelah diskon, bukan total fiskal/PPN pesanan. Tidak ada SUM baris pesanan dan jadwal yang bisa menggandakan nilai; tidak ada total lintas mata uang, pajak, margin, utang atau pembayaran dihitung. Mata uang baris tetap sendiri. Kuantitas beli dan inventaris berbeda; satuan inventaris tidak ditebak dari PurchUnit. Sisa fisik belum diterima dan sisa finansial diterima belum diperbarui faktur ditampilkan terpisah. Negatif, nol, NULL dipertahankan; tidak ada pembagian dengan nol, konversi atau jumlah penerimaan historis yang ditebak.\n\nKONDISI: LineDisc pada antet/master adalah KODE grup; pada baris adalah jumlah diskon per PriceUnit. DiscPercent antet adalah diskon total persentase sumber. Grup harga/diskon/biaya, CashDisc, kode pembayaran, pengiriman dan pajak bukan harga, tanggal jatuh tempo, pajak atau pembayaran final yang dihitung. DeliveryName adalah nama alamat pengiriman, bukan otomatis nama pemasok.\n\nDIMENSI: InventDim opsional dipasangkan dengan partisi, perusahaan tersimpan dan InventDimId tepat. Lokasi/gudang/tempat/batch/seri/warna/ukuran/gaya adalah kode konteks saat ini, bukan nama produk terjemahan atau kuantitas stok. Dimensi hilang tidak menghapus baris; nilai tidak tersedia tetap kosong. Verifikasi fitur/modul serta kunci unik pada instalasi. Pemasok adalah OrderAccount saat ini, bukan otomatis InvoiceAccount, pemasok baris atau salinan historis. Master hilang tidak menghapus pesanan/baris.\n\nAKSES: seluruh anak mempertahankan partisi, DATAAREAID tersimpan, RecId dan PurchId tepat. Int64 diteruskan sebagai teks tanpa pembulatan; pencocokan biner membedakan huruf besar/kecil dan spasi akhir. Perusahaan virtual seperti VIR perlu pemetaan administrator. Filter bukan ACL; SQL langsung tidak mewarisi AOS/XDS atau izin AX. Gunakan akun SELECT dibatasi pada server. Tidak ada kontak privat, alamat lengkap, bank, identitas pemerintah pribadi, audit atau CreditMax dengan mata uang yang ditebak. Nama bisnis tetap dapat merupakan data pribadi; hanya akses berwenang.\n\nDOKUMENTASI: Microsoft AOT tabel/kolom dan enum asli, bukan sertifikat DDL SQL instalasi. Verifikasi versi R3, modul, schema pemilik, kolom, relasi, kunci, indeks dan izin aktual sebelum uji baca terbatas saat impor. Daftar FK/index sparse tidak diisi dengan asumsi. Paket/DEMO tanpa kredensial, server atau 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/gg928139(v=ax.60)\nReferensi baris: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg955711(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": "EE27D058-CCB1-557D-9155-B80E16EF206A",
"rootButtonCount": 1,
"summary": "Pesanan normal per periode/partisi/perusahaan; penerimaan, nilai, jadwal, dimensi barang dan pemasok saat ini.",
"tags": [
"Dynamics AX 2012 R3",
"SQL Server",
"Pesanan pembelian",
"Penerimaan barang",
"Pemasok",
"Pro"
],
"title": "Pesanan pembelian, baris dan pemasok — Pro"
}
}