Faktur pemasok, baris dan dua peran pemasok — Pro
Periode, partisi dan perusahaan; total sumber, pajak, diskon, baris serta master pemasok penagih dan pemesan.
TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA.
Untuk pembelian, administrasi pemasok dan manajer: pilih periode faktur, partisi dan perusahaan. Lihat total sumber, pajak faktur, diskon dan jatuh tempo; buka baris dengan satuan, harga, pesanan asal dan dimensi. Penagih dan Pemesan membuka dua peran pemasok saat ini, tidak saling menggantikan. 123 posisi berguna dalam empat 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: AX 2012 R3 on-premises SQL Server untuk instalasi lama yang sudah ada; dukungan diperpanjang berakhir 11 Januari 2023. Bukan D365 Finance/SCM, AX2009 atau SQL cloud. Pro nyata: satu sumber, satu Home, empat daftar dan tiga sub-tombol lazy; tidak ada refresh berkala.
TAUTAN BARIS BELUM DIVALIDASI PADA R3 NYATA: lima field PurchID/InvoiceId/InvoiceDate/numberSequenceGroup/InternalInvoiceId berasal dari ekstrak metadata ASLI AX2012 R2, baris 228, dan output debug penulis AX. Referensi Microsoft R3 mendokumentasikan field dan relasi bernama tetapi daftar FK lengkap kosong. Ini bukan sertifikat mapping R3: administrator WAJIB memastikan pemetaan, populasi, indeks, keunikan dan kelengkapan setiap jalur posting termasuk konsolidasi sebelum digunakan. Tidak ada ParentRecId inventif atau fallback berdasarkan nomor faktur saja. PurchID adalah pesanan terlampir, OrigPurchId pesanan asal baris dan tidak dipaksa sama dengan faktur induk. Baris dengan pesanan asal berbeda tetap dapat tampil bila kelima field tautan cocok. Itu bukan bukti seluruh alur konsolidasi instalasi tercakup. Kunci NULL/kosong yang tidak cukup atau faktur induk ambigu memberi keadaan eksplisit dan jumlah baris kosong, bukan nol palsu atau pilihan baris pertama. Nol tautan unik bukan bukti faktur tidak pernah memiliki baris.
Identitas baris duplikat memblokir seluruh pembukaan baris dengan peringatan dan jumlah kosong, bukan menampilkan daftar parsial atau menghapus duplikat agar terlihat rapi.
LINGKUP: Proforma=No(0) dari EDT sendiri; uang muka, retur, nilai negatif, nol dan NULL tidak dihapus diam-diam. Tidak menebak bahwa angka negatif berarti nota kredit atau proforma berarti pembayaran. Baris anak membaca konteks faktur induk tepat, tanpa mengulang filter periode; master bisa hilang tanpa menghapus faktur. InvoiceAccount adalah pemasok penagih dan OrderAccount pemasok pemesan. Nama master SAAT INI bukan salinan historis nama faktur; mata uang/syarat master mungkin berbeda.
NILAI ASLI: InvoiceAmount total sumber dalam mata uang faktur, bukan saldo utang. SalesBalance total baris setelah diskon; EndDisc adalah JUMLAH, bukan persen. SumTax adalah pajak faktur induk asli; LineAmountTax pajak yang sudah termasuk pada baris, bukan pajak tambahan atau pajak yang dihitung ulang. CashDisc bersyarat bukan potongan yang terbukti dibayar. Tidak menambahkan komponen menjadi formula total, menjumlah lintas mata uang, membalik tanda atau menganggap voucher/kode pembayaran sebagai lunas. MST/reporting currency dan data bank/identitas pemerintah/kontak privat/audit dihilangkan.
SATUAN/PRESISI: Qty dalam PurchUnit, InventQty dalam satuan inventaris yang tidak ditebak. PurchPrice dan diskon nominal per PriceUnit; denominator nol/NULL tidak dibagi. LineAmount dan CurrencyCode baris dipertahankan walau beda dengan faktur induk, dengan peringatan. Sumber Real ditampilkan sebagai teks untuk mempertahankan nilai kecil; filter/sort jumlah adalah teks, bukan agregasi numerik. Tidak menghitung Qty x harga, margin, pajak atau total satuan campuran. Dimensi InventDim adalah kode konteks saat ini, bukan jaminan stok/dimensi historis; hilang atau ambigu tidak menghapus baris.
AKSES: pilih periode InvoiceDate, partisi dan DATAAREAID tersimpan sebelum batas 1.000 baris. Int64 dikirim sebagai teks utuh; pencocokan tepat membedakan case dan spasi akhir. Token tautan diturunkan dari lima field, bukan kolom asli AX, dan diuji ulang untuk faktur induk berubah. Duplikat RecId di scope ditolak, bukan deduplikasi kosmetik. Filter bukan ACL: SQL langsung tidak mewarisi AOS/XDS/izin aplikasi. Administrator harus membatasi akun SELECT, module/configuration keys, schema pemilik, perusahaan virtual, izin, indeks dan biaya baca. Batas 1.000 bukan jaminan cepat/lengkap.
VALIDASI: dokumentasi dan SQLite sintetik/adaptasi SELECT bukan tes SQL Server/ERP nyata. DEMO berisi data fiktif tanpa kredensial/server perusahaan. Uji baca terbatas saat impor dan verifikasi mapping R3 lokal wajib; paket bukan afiliasi atau garansi vendor.
Referensi R3 faktur induk: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg928207(v=ax.60)
Referensi R3 baris: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg949675(v=ax.60)
Ekstrak relasi R2 (bukan sertifikat R3): https://alexdmeyer.com/ax2012erd/Fky-AcctPay-ParentChilds-11.htm
Output debug penulis AX (bukan manual vendor): https://community.dynamics.com/forums/thread/details/?threadid=d5c36cd2-1a69-4f77-875f-684e42672021
Screenshots
What this package creates
1 Home3 Details4 lists1 sources to map
- Home: Faktur pemasok
- Details: Baris
- Details: Penagih
- Details: Pemesan
- Sub-button: Baris faktur pemasok
- Sub-button: Pemasok penagihan saat ini
- Sub-button: Pemasok pesanan saat ini
Sources are mapped locally and verified before applying.
Custom queriesPRO4 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 InvoiceKey, CAST(o.Partition AS nvarchar(30)) AS PartitionId, CAST(o.RecId AS nvarchar(30)) AS InvoiceRecId, CAST(o.InvoiceDate AS date) AS PeriodDate, CONCAT(CASE WHEN o.PurchId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.PurchId,N'#')),N':',o.PurchId,N':'),CASE WHEN o.InvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceId,N'#')),N':',o.InvoiceId,N':'),CASE WHEN o.InvoiceDate IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceDate,N'#')),N':',o.InvoiceDate,N':'),CASE WHEN o.numberSequenceGroup IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.numberSequenceGroup,N'#')),N':',o.numberSequenceGroup,N':'),CASE WHEN o.InternalInvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InternalInvoiceId,N'#')),N':',o.InternalInvoiceId,N':')) AS JoinToken, o.InvoiceId AS InvoiceId, o.InvoiceDate AS InvoiceDate, o.Description AS Description, pt.PartitionKey AS PartitionKey, o.dataAreaId AS dataAreaId, o.InvoiceAccount AS InvoiceAccount, bp.Name AS BillingVendorName, o.OrderAccount AS OrderAccount, op.Name AS OrderingVendorName, o.PurchId AS PurchId, o.CurrencyCode AS CurrencyCode, o.InvoiceAmount AS InvoiceAmount, o.SalesBalance AS SalesBalance, o.EndDisc AS EndDisc, o.SumLineDisc AS SumLineDisc, o.SumMarkup AS SumMarkup, o.SumTax AS SumTax, o.InvoiceRoundOff AS InvoiceRoundOff, o.DueDate AS DueDate, o.FixedDueDate AS FixedDueDate, o.Payment AS Payment, o.PaymentSched AS PaymentSched, o.CashDiscCode AS CashDiscCode, o.CashDisc AS CashDisc, o.CashDiscPercent AS CashDiscPercent, o.CashDiscDate AS CashDiscDate, o.LedgerVoucher AS LedgerVoucher, o.DocumentNum AS DocumentNum, o.DocumentDate AS DocumentDate, o.VendGroup AS VendGroup, o.PostingProfile AS PostingProfile, o.DlvMode AS DlvMode, o.DlvTerm AS DlvTerm, CASE WHEN o.Prepayment IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.Prepayment WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',o.Prepayment) END END AS PrepaymentName, CASE WHEN o.PurchId IS NOT NULL AND o.InvoiceId IS NOT NULL AND o.InvoiceDate IS NOT NULL AND o.numberSequenceGroup IS NOT NULL AND o.InternalInvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND DATALENGTH(o.InternalInvoiceId)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max)) AND CAST(q.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND q.InvoiceDate=o.InvoiceDate AND CAST(q.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(q.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND q.RecId>0)=1 AND (SELECT COUNT_BIG(*) FROM VendInvoiceTrans 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)) AND CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate AND CAST(l.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(l.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND l.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceTrans k WHERE k.Partition=l.Partition AND CAST(k.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND k.RecId=l.RecId)<>1)=0 THEN (SELECT COUNT_BIG(*) FROM VendInvoiceTrans 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)) AND CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate AND CAST(l.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(l.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND l.RecId>0) ELSE NULL END AS LineCount, CASE WHEN NOT (o.PurchId IS NOT NULL AND o.InvoiceId IS NOT NULL AND o.InvoiceDate IS NOT NULL AND o.numberSequenceGroup IS NOT NULL AND o.InternalInvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND DATALENGTH(o.InternalInvoiceId)>0) THEN N'Kunci tautan kosong — verifikasi lokal' WHEN o.PurchId IS NOT NULL AND o.InvoiceId IS NOT NULL AND o.InvoiceDate IS NOT NULL AND o.numberSequenceGroup IS NOT NULL AND o.InternalInvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND DATALENGTH(o.InternalInvoiceId)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max)) AND CAST(q.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND q.InvoiceDate=o.InvoiceDate AND CAST(q.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(q.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND q.RecId>0)=1 AND (SELECT COUNT_BIG(*) FROM VendInvoiceTrans 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)) AND CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate AND CAST(l.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(l.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND l.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceTrans k WHERE k.Partition=l.Partition AND CAST(k.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND k.RecId=l.RecId)<>1)>0 THEN N'Ambigu: identitas baris duplikat — verifikasi lokal' ELSE CASE (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max)) AND CAST(q.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND q.InvoiceDate=o.InvoiceDate AND CAST(q.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(q.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND q.RecId>0) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max)) AND CAST(q.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND q.InvoiceDate=o.InvoiceDate AND CAST(q.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(q.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND q.RecId>0),N' referensi; nilai tidak dipilih') END END AS LineLinkState, CASE (SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.InvoiceAccount AS varbinary(max)) AND q.RecId>0) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.InvoiceAccount AS varbinary(max)) AND q.RecId>0),N' referensi; nilai tidak dipilih') END AS BillingVendorState, CASE (SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.OrderAccount AS varbinary(max)) AND q.RecId>0) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.OrderAccount AS varbinary(max)) AND q.RecId>0),N' referensi; nilai tidak dipilih') END AS OrderingVendorState FROM VendInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition AND (SELECT COUNT_BIG(*) FROM Partitions q WHERE q.RecId=o.Partition)=1 LEFT JOIN VendTable bm ON bm.Partition=o.Partition AND CAST(bm.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(bm.AccountNum AS varbinary(max))=CAST(o.InvoiceAccount AS varbinary(max)) AND bm.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.InvoiceAccount AS varbinary(max)) AND q.RecId>0)=1 LEFT JOIN DirPartyTable bp ON bp.Partition=bm.Partition AND bp.RecId=bm.Party AND bm.Party>0 AND (SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=bm.Partition AND bm.Party>0 AND q.RecId=bm.Party)=1 LEFT JOIN VendTable om ON om.Partition=o.Partition AND CAST(om.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(om.AccountNum AS varbinary(max))=CAST(o.OrderAccount AS varbinary(max)) AND om.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.OrderAccount AS varbinary(max)) AND q.RecId>0)=1 LEFT JOIN DirPartyTable op ON op.Partition=om.Partition AND op.RecId=om.Party AND om.Party>0 AND (SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=om.Partition AND om.Party>0 AND q.RecId=om.Party)=1 WHERE o.Proforma=0 AND o.Partition>0 AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND q.RecId=o.RecId)=1 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceJour',N'U') AND OBJECT_ID(N'VendInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceTrans',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 ParentInvoiceKey, l.ItemId AS ItemId, l.Name AS Name, l.Description AS Description, l.ExternalItemId AS ExternalItemId, l.LineNum AS LineNum, l.InvoiceId AS InvoiceId, l.InvoiceDate AS InvoiceDate, l.PurchID AS PurchID, l.OrigPurchId AS OrigPurchId, l.CurrencyCode AS CurrencyCode, CASE WHEN CAST(l.CurrencyCode AS varbinary(max))=CAST(o.CurrencyCode AS varbinary(max)) THEN N'Sama dengan faktur induk' ELSE N'Berbeda atau kosong — verifikasi lokal' END AS CurrencyState, l.Qty AS Qty, l.PurchUnit AS PurchUnit, l.InventQty AS InventQty, l.PurchPrice AS PurchPrice, l.PriceUnit AS PriceUnit, l.LineAmount AS LineAmount, l.LineAmountTax AS LineAmountTax, l.LineDisc AS LineDisc, l.LinePercent AS LinePercent, l.MultiLnDisc AS MultiLnDisc, l.MultiLnPercent AS MultiLnPercent, l.DiscAmount AS DiscAmount, l.DiscPercent AS DiscPercent, l.PurchMarkup AS PurchMarkup, l.TaxGroup AS TaxGroup, l.TaxItemGroup AS TaxItemGroup, 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, CASE (SELECT COUNT_BIG(*) FROM InventDim q WHERE q.Partition=l.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND CAST(q.inventDimId AS varbinary(max))=CAST(l.InventDimId AS varbinary(max))) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM InventDim q WHERE q.Partition=l.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND CAST(q.inventDimId AS varbinary(max))=CAST(l.InventDimId AS varbinary(max))),N' referensi; nilai tidak dipilih') END AS DimensionState FROM VendInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition AND (SELECT COUNT_BIG(*) FROM Partitions q WHERE q.RecId=o.Partition)=1 INNER JOIN VendInvoiceTrans 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)) AND CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate AND CAST(l.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(l.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND l.RecId>0 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)) AND (SELECT COUNT_BIG(*) FROM InventDim q WHERE q.Partition=l.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND CAST(q.inventDimId AS varbinary(max))=CAST(l.InventDimId AS varbinary(max)))=1 WHERE o.Proforma=0 AND o.Partition>0 AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND q.RecId=o.RecId)=1 AND o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:invoiceRecId AS bigint) AND CAST(CONCAT(CASE WHEN o.PurchId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.PurchId,N'#')),N':',o.PurchId,N':'),CASE WHEN o.InvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceId,N'#')),N':',o.InvoiceId,N':'),CASE WHEN o.InvoiceDate IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceDate,N'#')),N':',o.InvoiceDate,N':'),CASE WHEN o.numberSequenceGroup IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.numberSequenceGroup,N'#')),N':',o.numberSequenceGroup,N':'),CASE WHEN o.InternalInvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InternalInvoiceId,N'#')),N':',o.InternalInvoiceId,N':')) AS varbinary(max))=CAST(:joinToken AS varbinary(max)) AND o.PurchId IS NOT NULL AND o.InvoiceId IS NOT NULL AND o.InvoiceDate IS NOT NULL AND o.numberSequenceGroup IS NOT NULL AND o.InternalInvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND DATALENGTH(o.InternalInvoiceId)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max)) AND CAST(q.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND q.InvoiceDate=o.InvoiceDate AND CAST(q.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(q.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND q.RecId>0)=1 AND (SELECT COUNT_BIG(*) FROM VendInvoiceTrans 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)) AND CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate AND CAST(l.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(l.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND l.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceTrans k WHERE k.Partition=l.Partition AND CAST(k.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND k.RecId=l.RecId)<>1)=0 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceJour',N'U') AND OBJECT_ID(N'VendInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceTrans',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 ParentInvoiceKey, 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.LineOfBusinessId AS LineOfBusinessId, CASE WHEN m.OneTimeVendor IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE m.OneTimeVendor WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',m.OneTimeVendor) END END AS OneTimeSupplier, 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.PaymSched AS PaymSched, m.PaymDayId AS PaymDayId, m.CashDisc AS CashDisc, m.PurchPoolId AS PurchPoolId, 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.BlockedReleaseDate AS BlockedReleaseDate, m.CreditRating AS CreditRating, CASE (SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=m.Partition AND m.Party>0 AND q.RecId=m.Party) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=m.Partition AND m.Party>0 AND q.RecId=m.Party),N' referensi; nilai tidak dipilih') END AS PartyState FROM VendInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition AND (SELECT COUNT_BIG(*) FROM Partitions q WHERE q.RecId=o.Partition)=1 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.InvoiceAccount AS varbinary(max)) AND m.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.InvoiceAccount AS varbinary(max)) AND q.RecId>0)=1 LEFT JOIN DirPartyTable p ON p.Partition=m.Partition AND p.RecId=m.Party AND m.Party>0 AND (SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=m.Partition AND m.Party>0 AND q.RecId=m.Party)=1 WHERE o.Proforma=0 AND o.Partition>0 AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND q.RecId=o.RecId)=1 AND o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:invoiceRecId AS bigint) AND CAST(CONCAT(CASE WHEN o.PurchId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.PurchId,N'#')),N':',o.PurchId,N':'),CASE WHEN o.InvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceId,N'#')),N':',o.InvoiceId,N':'),CASE WHEN o.InvoiceDate IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceDate,N'#')),N':',o.InvoiceDate,N':'),CASE WHEN o.numberSequenceGroup IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.numberSequenceGroup,N'#')),N':',o.numberSequenceGroup,N':'),CASE WHEN o.InternalInvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InternalInvoiceId,N'#')),N':',o.InternalInvoiceId,N':')) AS varbinary(max))=CAST(:joinToken AS varbinary(max)) AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceJour',N'U') AND OBJECT_ID(N'VendInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceTrans',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.3.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 ParentInvoiceKey, 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.LineOfBusinessId AS LineOfBusinessId, CASE WHEN m.OneTimeVendor IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE m.OneTimeVendor WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',m.OneTimeVendor) END END AS OneTimeSupplier, 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.PaymSched AS PaymSched, m.PaymDayId AS PaymDayId, m.CashDisc AS CashDisc, m.PurchPoolId AS PurchPoolId, 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.BlockedReleaseDate AS BlockedReleaseDate, m.CreditRating AS CreditRating, CASE (SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=m.Partition AND m.Party>0 AND q.RecId=m.Party) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=m.Partition AND m.Party>0 AND q.RecId=m.Party),N' referensi; nilai tidak dipilih') END AS PartyState FROM VendInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition AND (SELECT COUNT_BIG(*) FROM Partitions q WHERE q.RecId=o.Partition)=1 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)) AND m.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.OrderAccount AS varbinary(max)) AND q.RecId>0)=1 LEFT JOIN DirPartyTable p ON p.Partition=m.Partition AND p.RecId=m.Party AND m.Party>0 AND (SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=m.Partition AND m.Party>0 AND q.RecId=m.Party)=1 WHERE o.Proforma=0 AND o.Partition>0 AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND q.RecId=o.RecId)=1 AND o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:invoiceRecId AS bigint) AND CAST(CONCAT(CASE WHEN o.PurchId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.PurchId,N'#')),N':',o.PurchId,N':'),CASE WHEN o.InvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceId,N'#')),N':',o.InvoiceId,N':'),CASE WHEN o.InvoiceDate IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceDate,N'#')),N':',o.InvoiceDate,N':'),CASE WHEN o.numberSequenceGroup IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.numberSequenceGroup,N'#')),N':',o.numberSequenceGroup,N':'),CASE WHEN o.InternalInvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InternalInvoiceId,N'#')),N':',o.InternalInvoiceId,N':')) AS varbinary(max))=CAST(:joinToken AS varbinary(max)) AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceJour',N'U') AND OBJECT_ID(N'VendInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceTrans',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": "A7072502-DF15-5E58-B11F-C449031FCBF8",
"kind": "sqlServer",
"requiredObjects": [
"VendInvoiceJour",
"VendInvoiceTrans",
"Partitions",
"VendTable",
"DirPartyTable",
"InventDim"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "859554C5-01D8-52DC-99BB-01C93F2B75C9",
"key": "PeriodDate",
"type": "date"
},
{
"direction": "ascending",
"id": "002A79F1-506E-5C36-93B7-CB7C709835B6",
"key": "InvoiceId",
"type": "text"
},
{
"direction": "ascending",
"id": "1FBAFB24-87C8-5993-9B00-F74D2B1076CD",
"key": "InvoiceKey",
"type": "text"
}
],
"id": "B37EAA47-6E5A-5FE2-ACCC-7DB4AA7D9A72",
"mappings": [
{
"commonFieldKey": "",
"key": "InvoiceKey",
"label": "Internal InvoiceKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceKey",
"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": "InvoiceRecId",
"label": "Internal InvoiceRecId",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceRecId",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PeriodDate",
"label": "Internal PeriodDate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PeriodDate",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JoinToken",
"label": "Internal JoinToken",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "JoinToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceId",
"label": "Nomor faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceDate",
"label": "Tanggal faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Uraian faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"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": "InvoiceAccount",
"label": "Akun pemasok penagih",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BillingVendorName",
"label": "Nama pemasok penagih saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillingVendorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderAccount",
"label": "Akun pemasok pemesan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderingVendorName",
"label": "Nama pemasok pemesan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderingVendorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchId",
"label": "Pesanan yang dilampirkan pada faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Mata uang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceAmount",
"label": "Total faktur sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceAmount",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SalesBalance",
"label": "Total baris setelah diskon baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SalesBalance",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EndDisc",
"label": "Diskon total faktur (jumlah)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "EndDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SumLineDisc",
"label": "Jumlah diskon baris faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SumLineDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SumMarkup",
"label": "Biaya tambahan faktur sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SumMarkup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SumTax",
"label": "Jumlah pajak faktur sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SumTax",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceRoundOff",
"label": "Pembulatan faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceRoundOff",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DueDate",
"label": "Jatuh tempo faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FixedDueDate",
"label": "Jatuh tempo tetap sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FixedDueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Payment",
"label": "Kode syarat pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Payment",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymentSched",
"label": "Kode jadwal pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymentSched",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CashDiscCode",
"label": "Kode diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CashDiscCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CashDisc",
"label": "Jumlah diskon tunai bersyarat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CashDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CashDiscPercent",
"label": "Diskon tunai (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CashDiscPercent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CashDiscDate",
"label": "Batas pembayaran untuk diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CashDiscDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LedgerVoucher",
"label": "Voucher pembukuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LedgerVoucher",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocumentNum",
"label": "Nomor dokumen asal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DocumentNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocumentDate",
"label": "Tanggal dokumen asal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DocumentDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendGroup",
"label": "Grup pemasok pada faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingProfile",
"label": "Kode profil pembukuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostingProfile",
"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": "PrepaymentName",
"label": "Penanda uang muka sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PrepaymentName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineCount",
"label": "Jumlah baris bertaut tepat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineLinkState",
"label": "Ketersediaan tautan baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineLinkState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BillingVendorState",
"label": "Ketersediaan pemasok penagih",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BillingVendorState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderingVendorState",
"label": "Ketersediaan pemasok pemesan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderingVendorState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Faktur pemasok",
"primaryKey": "InvoiceKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"InvoiceId",
"InvoiceDate",
"Description",
"PartitionKey",
"dataAreaId",
"InvoiceAccount",
"BillingVendorName",
"OrderAccount",
"OrderingVendorName",
"PurchId",
"CurrencyCode",
"InvoiceAmount",
"SalesBalance",
"EndDisc",
"SumLineDisc",
"SumMarkup",
"SumTax",
"InvoiceRoundOff",
"DueDate",
"FixedDueDate",
"Payment",
"PaymentSched",
"CashDiscCode",
"CashDisc",
"CashDiscPercent",
"CashDiscDate",
"LedgerVoucher",
"DocumentNum",
"DocumentDate",
"VendGroup",
"PostingProfile",
"DlvMode",
"DlvTerm",
"PrepaymentName",
"LineCount",
"LineLinkState",
"BillingVendorState",
"OrderingVendorState"
],
"sourceID": "A7072502-DF15-5E58-B11F-C449031FCBF8",
"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 InvoiceKey, CAST(o.Partition AS nvarchar(30)) AS PartitionId, CAST(o.RecId AS nvarchar(30)) AS InvoiceRecId, CAST(o.InvoiceDate AS date) AS PeriodDate, CONCAT(CASE WHEN o.PurchId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.PurchId,N'#')),N':',o.PurchId,N':'),CASE WHEN o.InvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceId,N'#')),N':',o.InvoiceId,N':'),CASE WHEN o.InvoiceDate IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceDate,N'#')),N':',o.InvoiceDate,N':'),CASE WHEN o.numberSequenceGroup IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.numberSequenceGroup,N'#')),N':',o.numberSequenceGroup,N':'),CASE WHEN o.InternalInvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InternalInvoiceId,N'#')),N':',o.InternalInvoiceId,N':')) AS JoinToken, o.InvoiceId AS InvoiceId, o.InvoiceDate AS InvoiceDate, o.Description AS Description, pt.PartitionKey AS PartitionKey, o.dataAreaId AS dataAreaId, o.InvoiceAccount AS InvoiceAccount, bp.Name AS BillingVendorName, o.OrderAccount AS OrderAccount, op.Name AS OrderingVendorName, o.PurchId AS PurchId, o.CurrencyCode AS CurrencyCode, o.InvoiceAmount AS InvoiceAmount, o.SalesBalance AS SalesBalance, o.EndDisc AS EndDisc, o.SumLineDisc AS SumLineDisc, o.SumMarkup AS SumMarkup, o.SumTax AS SumTax, o.InvoiceRoundOff AS InvoiceRoundOff, o.DueDate AS DueDate, o.FixedDueDate AS FixedDueDate, o.Payment AS Payment, o.PaymentSched AS PaymentSched, o.CashDiscCode AS CashDiscCode, o.CashDisc AS CashDisc, o.CashDiscPercent AS CashDiscPercent, o.CashDiscDate AS CashDiscDate, o.LedgerVoucher AS LedgerVoucher, o.DocumentNum AS DocumentNum, o.DocumentDate AS DocumentDate, o.VendGroup AS VendGroup, o.PostingProfile AS PostingProfile, o.DlvMode AS DlvMode, o.DlvTerm AS DlvTerm, CASE WHEN o.Prepayment IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.Prepayment WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',o.Prepayment) END END AS PrepaymentName, CASE WHEN o.PurchId IS NOT NULL AND o.InvoiceId IS NOT NULL AND o.InvoiceDate IS NOT NULL AND o.numberSequenceGroup IS NOT NULL AND o.InternalInvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND DATALENGTH(o.InternalInvoiceId)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max)) AND CAST(q.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND q.InvoiceDate=o.InvoiceDate AND CAST(q.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(q.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND q.RecId>0)=1 AND (SELECT COUNT_BIG(*) FROM VendInvoiceTrans 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)) AND CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate AND CAST(l.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(l.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND l.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceTrans k WHERE k.Partition=l.Partition AND CAST(k.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND k.RecId=l.RecId)<>1)=0 THEN (SELECT COUNT_BIG(*) FROM VendInvoiceTrans 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)) AND CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate AND CAST(l.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(l.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND l.RecId>0) ELSE NULL END AS LineCount, CASE WHEN NOT (o.PurchId IS NOT NULL AND o.InvoiceId IS NOT NULL AND o.InvoiceDate IS NOT NULL AND o.numberSequenceGroup IS NOT NULL AND o.InternalInvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND DATALENGTH(o.InternalInvoiceId)>0) THEN N'Kunci tautan kosong — verifikasi lokal' WHEN o.PurchId IS NOT NULL AND o.InvoiceId IS NOT NULL AND o.InvoiceDate IS NOT NULL AND o.numberSequenceGroup IS NOT NULL AND o.InternalInvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND DATALENGTH(o.InternalInvoiceId)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max)) AND CAST(q.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND q.InvoiceDate=o.InvoiceDate AND CAST(q.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(q.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND q.RecId>0)=1 AND (SELECT COUNT_BIG(*) FROM VendInvoiceTrans 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)) AND CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate AND CAST(l.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(l.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND l.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceTrans k WHERE k.Partition=l.Partition AND CAST(k.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND k.RecId=l.RecId)<>1)>0 THEN N'Ambigu: identitas baris duplikat — verifikasi lokal' ELSE CASE (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max)) AND CAST(q.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND q.InvoiceDate=o.InvoiceDate AND CAST(q.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(q.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND q.RecId>0) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max)) AND CAST(q.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND q.InvoiceDate=o.InvoiceDate AND CAST(q.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(q.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND q.RecId>0),N' referensi; nilai tidak dipilih') END END AS LineLinkState, CASE (SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.InvoiceAccount AS varbinary(max)) AND q.RecId>0) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.InvoiceAccount AS varbinary(max)) AND q.RecId>0),N' referensi; nilai tidak dipilih') END AS BillingVendorState, CASE (SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.OrderAccount AS varbinary(max)) AND q.RecId>0) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.OrderAccount AS varbinary(max)) AND q.RecId>0),N' referensi; nilai tidak dipilih') END AS OrderingVendorState FROM VendInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition AND (SELECT COUNT_BIG(*) FROM Partitions q WHERE q.RecId=o.Partition)=1 LEFT JOIN VendTable bm ON bm.Partition=o.Partition AND CAST(bm.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(bm.AccountNum AS varbinary(max))=CAST(o.InvoiceAccount AS varbinary(max)) AND bm.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.InvoiceAccount AS varbinary(max)) AND q.RecId>0)=1 LEFT JOIN DirPartyTable bp ON bp.Partition=bm.Partition AND bp.RecId=bm.Party AND bm.Party>0 AND (SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=bm.Partition AND bm.Party>0 AND q.RecId=bm.Party)=1 LEFT JOIN VendTable om ON om.Partition=o.Partition AND CAST(om.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(om.AccountNum AS varbinary(max))=CAST(o.OrderAccount AS varbinary(max)) AND om.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.OrderAccount AS varbinary(max)) AND q.RecId>0)=1 LEFT JOIN DirPartyTable op ON op.Partition=om.Partition AND op.RecId=om.Party AND om.Party>0 AND (SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=om.Partition AND om.Party>0 AND q.RecId=om.Party)=1 WHERE o.Proforma=0 AND o.Partition>0 AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND q.RecId=o.RecId)=1 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceJour',N'U') AND OBJECT_ID(N'VendInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceTrans',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": "AA367C24-B913-596B-AFB8-936AF6AA00E1",
"key": "LineNum",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "5BA96CC9-CF4E-530E-89CC-A1D53FC44E4E",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Internal LineKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentInvoiceKey",
"label": "Internal ParentInvoiceKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentInvoiceKey",
"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 standar baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Name",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Uraian barang yang dipesan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"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": "LineNum",
"label": "Nomor urut baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineNum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceId",
"label": "Nomor faktur pada baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceDate",
"label": "Tanggal transaksi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchID",
"label": "Pesanan yang dilampirkan pada baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrigPurchId",
"label": "Pesanan asal tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrigPurchId",
"type": "text",
"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": "CurrencyState",
"label": "Kesesuaian mata uang dengan faktur induk",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Qty",
"label": "Jumlah dalam satuan beli",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Qty",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PurchUnit",
"label": "Satuan beli",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InventQty",
"label": "Jumlah dalam satuan inventaris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventQty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchPrice",
"label": "Harga per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchPrice",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PriceUnit",
"label": "Jumlah satuan per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PriceUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineAmount",
"label": "Nilai baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineAmount",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineAmountTax",
"label": "Pajak yang termasuk dalam nilai baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineAmountTax",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineDisc",
"label": "Diskon baris per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LinePercent",
"label": "Diskon baris (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LinePercent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MultiLnDisc",
"label": "Diskon multibaris per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MultiLnDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MultiLnPercent",
"label": "Diskon multibaris (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MultiLnPercent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscAmount",
"label": "Jumlah diskon transaksi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DiscAmount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscPercent",
"label": "Diskon transaksi (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DiscPercent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchMarkup",
"label": "Biaya harga tetap sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchMarkup",
"type": "text",
"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": "InventSiteId",
"label": "Kode lokasi dimensi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventSiteId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventLocationId",
"label": "Kode gudang dimensi",
"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
},
{
"commonFieldKey": "",
"key": "DimensionState",
"label": "Ketersediaan dimensi saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DimensionState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Baris faktur pemasok",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "A41929EA-0DD3-5779-98EF-A2E139C5C6EE",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "5980AB59-92B6-5794-AB0F-1E629A2F8600",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "InvoiceRecId",
"id": "A1552A91-99D9-58F8-984A-8015C044786D",
"name": "invoiceRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "JoinToken",
"id": "5D273FD2-F4B6-5536-B354-B32F0623BC7E",
"name": "joinToken",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemId",
"Name",
"Description",
"ExternalItemId",
"LineNum",
"InvoiceId",
"InvoiceDate",
"PurchID",
"OrigPurchId",
"CurrencyCode",
"CurrencyState",
"Qty",
"PurchUnit",
"InventQty",
"PurchPrice",
"PriceUnit",
"LineAmount",
"LineAmountTax",
"LineDisc",
"LinePercent",
"MultiLnDisc",
"MultiLnPercent",
"DiscAmount",
"DiscPercent",
"PurchMarkup",
"TaxGroup",
"TaxItemGroup",
"InventSiteId",
"InventLocationId",
"wMSLocationId",
"inventBatchId",
"inventSerialId",
"configId",
"InventColorId",
"InventSizeId",
"InventStyleId",
"DimensionState"
],
"sourceID": "A7072502-DF15-5E58-B11F-C449031FCBF8",
"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 ParentInvoiceKey, l.ItemId AS ItemId, l.Name AS Name, l.Description AS Description, l.ExternalItemId AS ExternalItemId, l.LineNum AS LineNum, l.InvoiceId AS InvoiceId, l.InvoiceDate AS InvoiceDate, l.PurchID AS PurchID, l.OrigPurchId AS OrigPurchId, l.CurrencyCode AS CurrencyCode, CASE WHEN CAST(l.CurrencyCode AS varbinary(max))=CAST(o.CurrencyCode AS varbinary(max)) THEN N'Sama dengan faktur induk' ELSE N'Berbeda atau kosong — verifikasi lokal' END AS CurrencyState, l.Qty AS Qty, l.PurchUnit AS PurchUnit, l.InventQty AS InventQty, l.PurchPrice AS PurchPrice, l.PriceUnit AS PriceUnit, l.LineAmount AS LineAmount, l.LineAmountTax AS LineAmountTax, l.LineDisc AS LineDisc, l.LinePercent AS LinePercent, l.MultiLnDisc AS MultiLnDisc, l.MultiLnPercent AS MultiLnPercent, l.DiscAmount AS DiscAmount, l.DiscPercent AS DiscPercent, l.PurchMarkup AS PurchMarkup, l.TaxGroup AS TaxGroup, l.TaxItemGroup AS TaxItemGroup, 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, CASE (SELECT COUNT_BIG(*) FROM InventDim q WHERE q.Partition=l.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND CAST(q.inventDimId AS varbinary(max))=CAST(l.InventDimId AS varbinary(max))) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM InventDim q WHERE q.Partition=l.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND CAST(q.inventDimId AS varbinary(max))=CAST(l.InventDimId AS varbinary(max))),N' referensi; nilai tidak dipilih') END AS DimensionState FROM VendInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition AND (SELECT COUNT_BIG(*) FROM Partitions q WHERE q.RecId=o.Partition)=1 INNER JOIN VendInvoiceTrans 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)) AND CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate AND CAST(l.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(l.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND l.RecId>0 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)) AND (SELECT COUNT_BIG(*) FROM InventDim q WHERE q.Partition=l.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND CAST(q.inventDimId AS varbinary(max))=CAST(l.InventDimId AS varbinary(max)))=1 WHERE o.Proforma=0 AND o.Partition>0 AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND q.RecId=o.RecId)=1 AND o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:invoiceRecId AS bigint) AND CAST(CONCAT(CASE WHEN o.PurchId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.PurchId,N'#')),N':',o.PurchId,N':'),CASE WHEN o.InvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceId,N'#')),N':',o.InvoiceId,N':'),CASE WHEN o.InvoiceDate IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceDate,N'#')),N':',o.InvoiceDate,N':'),CASE WHEN o.numberSequenceGroup IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.numberSequenceGroup,N'#')),N':',o.numberSequenceGroup,N':'),CASE WHEN o.InternalInvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InternalInvoiceId,N'#')),N':',o.InternalInvoiceId,N':')) AS varbinary(max))=CAST(:joinToken AS varbinary(max)) AND o.PurchId IS NOT NULL AND o.InvoiceId IS NOT NULL AND o.InvoiceDate IS NOT NULL AND o.numberSequenceGroup IS NOT NULL AND o.InternalInvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND DATALENGTH(o.InternalInvoiceId)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.PurchId AS varbinary(max))=CAST(o.PurchId AS varbinary(max)) AND CAST(q.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND q.InvoiceDate=o.InvoiceDate AND CAST(q.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(q.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND q.RecId>0)=1 AND (SELECT COUNT_BIG(*) FROM VendInvoiceTrans 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)) AND CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate AND CAST(l.numberSequenceGroup AS varbinary(max))=CAST(o.numberSequenceGroup AS varbinary(max)) AND CAST(l.InternalInvoiceId AS varbinary(max))=CAST(o.InternalInvoiceId AS varbinary(max)) AND l.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceTrans k WHERE k.Partition=l.Partition AND CAST(k.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND k.RecId=l.RecId)<>1)=0 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceJour',N'U') AND OBJECT_ID(N'VendInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceTrans',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": "BC515F3F-CAEC-53F1-9967-06042027411E",
"key": "VendorKey",
"type": "text"
}
],
"id": "54CA1434-9E09-55DB-BB7B-72FED433CDAF",
"mappings": [
{
"commonFieldKey": "",
"key": "VendorKey",
"label": "Internal VendorKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentInvoiceKey",
"label": "Internal ParentInvoiceKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentInvoiceKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorName",
"label": "Nama pemasok",
"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": "LineOfBusinessId",
"label": "Kode bidang usaha",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineOfBusinessId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OneTimeSupplier",
"label": "Pemasok satu kali",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OneTimeSupplier",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Currency",
"label": "Mata uang faktur pemasok bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Currency",
"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": "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": "PaymSched",
"label": "Kode jadwal pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymSched",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymDayId",
"label": "Kode hari pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymDayId",
"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": "PurchPoolId",
"label": "Kode kelompok pesanan pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchPoolId",
"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": "Status penangguhan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BlockStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BlockedReleaseDate",
"label": "Tanggal pelepasan penangguhan sumber (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BlockedReleaseDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CreditRating",
"label": "Peringkat kredit pemasok tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CreditRating",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartyState",
"label": "Ketersediaan nama pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PartyState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Pemasok penagihan saat ini",
"primaryKey": "VendorKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "A41929EA-0DD3-5779-98EF-A2E139C5C6EE",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "5980AB59-92B6-5794-AB0F-1E629A2F8600",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "InvoiceRecId",
"id": "A1552A91-99D9-58F8-984A-8015C044786D",
"name": "invoiceRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "JoinToken",
"id": "5D273FD2-F4B6-5536-B354-B32F0623BC7E",
"name": "joinToken",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VendorName",
"AccountNum",
"KnownAs",
"NameAlias",
"PartyNumber",
"VendGroup",
"LineOfBusinessId",
"OneTimeSupplier",
"Currency",
"InvoiceAccount",
"YourAccountNum",
"PaymTermId",
"PaymMode",
"PaymSpec",
"PaymSched",
"PaymDayId",
"CashDisc",
"PurchPoolId",
"DlvMode",
"DlvTerm",
"BlockStatus",
"BlockedReleaseDate",
"CreditRating",
"PartyState"
],
"sourceID": "A7072502-DF15-5E58-B11F-C449031FCBF8",
"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 ParentInvoiceKey, 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.LineOfBusinessId AS LineOfBusinessId, CASE WHEN m.OneTimeVendor IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE m.OneTimeVendor WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',m.OneTimeVendor) END END AS OneTimeSupplier, 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.PaymSched AS PaymSched, m.PaymDayId AS PaymDayId, m.CashDisc AS CashDisc, m.PurchPoolId AS PurchPoolId, 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.BlockedReleaseDate AS BlockedReleaseDate, m.CreditRating AS CreditRating, CASE (SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=m.Partition AND m.Party>0 AND q.RecId=m.Party) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=m.Partition AND m.Party>0 AND q.RecId=m.Party),N' referensi; nilai tidak dipilih') END AS PartyState FROM VendInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition AND (SELECT COUNT_BIG(*) FROM Partitions q WHERE q.RecId=o.Partition)=1 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.InvoiceAccount AS varbinary(max)) AND m.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.InvoiceAccount AS varbinary(max)) AND q.RecId>0)=1 LEFT JOIN DirPartyTable p ON p.Partition=m.Partition AND p.RecId=m.Party AND m.Party>0 AND (SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=m.Partition AND m.Party>0 AND q.RecId=m.Party)=1 WHERE o.Proforma=0 AND o.Partition>0 AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND q.RecId=o.RecId)=1 AND o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:invoiceRecId AS bigint) AND CAST(CONCAT(CASE WHEN o.PurchId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.PurchId,N'#')),N':',o.PurchId,N':'),CASE WHEN o.InvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceId,N'#')),N':',o.InvoiceId,N':'),CASE WHEN o.InvoiceDate IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceDate,N'#')),N':',o.InvoiceDate,N':'),CASE WHEN o.numberSequenceGroup IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.numberSequenceGroup,N'#')),N':',o.numberSequenceGroup,N':'),CASE WHEN o.InternalInvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InternalInvoiceId,N'#')),N':',o.InternalInvoiceId,N':')) AS varbinary(max))=CAST(:joinToken AS varbinary(max)) AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceJour',N'U') AND OBJECT_ID(N'VendInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceTrans',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": "BC515F3F-CAEC-53F1-9967-06042027411E",
"key": "VendorKey",
"type": "text"
}
],
"id": "869F54C9-8883-5754-93F7-4737C9591ADB",
"mappings": [
{
"commonFieldKey": "",
"key": "VendorKey",
"label": "Internal VendorKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentInvoiceKey",
"label": "Internal ParentInvoiceKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentInvoiceKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorName",
"label": "Nama pemasok",
"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": "LineOfBusinessId",
"label": "Kode bidang usaha",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineOfBusinessId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OneTimeSupplier",
"label": "Pemasok satu kali",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OneTimeSupplier",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Currency",
"label": "Mata uang faktur pemasok bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Currency",
"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": "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": "PaymSched",
"label": "Kode jadwal pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymSched",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymDayId",
"label": "Kode hari pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymDayId",
"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": "PurchPoolId",
"label": "Kode kelompok pesanan pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchPoolId",
"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": "Status penangguhan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BlockStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BlockedReleaseDate",
"label": "Tanggal pelepasan penangguhan sumber (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BlockedReleaseDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CreditRating",
"label": "Peringkat kredit pemasok tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CreditRating",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartyState",
"label": "Ketersediaan nama pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PartyState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Pemasok pesanan saat ini",
"primaryKey": "VendorKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "A41929EA-0DD3-5779-98EF-A2E139C5C6EE",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "5980AB59-92B6-5794-AB0F-1E629A2F8600",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "InvoiceRecId",
"id": "A1552A91-99D9-58F8-984A-8015C044786D",
"name": "invoiceRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "JoinToken",
"id": "5D273FD2-F4B6-5536-B354-B32F0623BC7E",
"name": "joinToken",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VendorName",
"AccountNum",
"KnownAs",
"NameAlias",
"PartyNumber",
"VendGroup",
"LineOfBusinessId",
"OneTimeSupplier",
"Currency",
"InvoiceAccount",
"YourAccountNum",
"PaymTermId",
"PaymMode",
"PaymSpec",
"PaymSched",
"PaymDayId",
"CashDisc",
"PurchPoolId",
"DlvMode",
"DlvTerm",
"BlockStatus",
"BlockedReleaseDate",
"CreditRating",
"PartyState"
],
"sourceID": "A7072502-DF15-5E58-B11F-C449031FCBF8",
"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 ParentInvoiceKey, 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.LineOfBusinessId AS LineOfBusinessId, CASE WHEN m.OneTimeVendor IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE m.OneTimeVendor WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',m.OneTimeVendor) END END AS OneTimeSupplier, 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.PaymSched AS PaymSched, m.PaymDayId AS PaymDayId, m.CashDisc AS CashDisc, m.PurchPoolId AS PurchPoolId, 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.BlockedReleaseDate AS BlockedReleaseDate, m.CreditRating AS CreditRating, CASE (SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=m.Partition AND m.Party>0 AND q.RecId=m.Party) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=m.Partition AND m.Party>0 AND q.RecId=m.Party),N' referensi; nilai tidak dipilih') END AS PartyState FROM VendInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition AND (SELECT COUNT_BIG(*) FROM Partitions q WHERE q.RecId=o.Partition)=1 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)) AND m.RecId>0 AND (SELECT COUNT_BIG(*) FROM VendTable q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(q.AccountNum AS varbinary(max))=CAST(o.OrderAccount AS varbinary(max)) AND q.RecId>0)=1 LEFT JOIN DirPartyTable p ON p.Partition=m.Partition AND p.RecId=m.Party AND m.Party>0 AND (SELECT COUNT_BIG(*) FROM DirPartyTable q WHERE q.Partition=m.Partition AND m.Party>0 AND q.RecId=m.Party)=1 WHERE o.Proforma=0 AND o.Partition>0 AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND (SELECT COUNT_BIG(*) FROM VendInvoiceJour q WHERE q.Partition=o.Partition AND CAST(q.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND q.RecId=o.RecId)=1 AND o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:invoiceRecId AS bigint) AND CAST(CONCAT(CASE WHEN o.PurchId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.PurchId,N'#')),N':',o.PurchId,N':'),CASE WHEN o.InvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceId,N'#')),N':',o.InvoiceId,N':'),CASE WHEN o.InvoiceDate IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InvoiceDate,N'#')),N':',o.InvoiceDate,N':'),CASE WHEN o.numberSequenceGroup IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.numberSequenceGroup,N'#')),N':',o.numberSequenceGroup,N':'),CASE WHEN o.InternalInvoiceId IS NULL THEN N'N:' ELSE N'V:' END,CONCAT(LEN(CONCAT(o.InternalInvoiceId,N'#')),N':',o.InternalInvoiceId,N':')) AS varbinary(max))=CAST(:joinToken AS varbinary(max)) AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceJour',N'U') AND OBJECT_ID(N'VendInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendInvoiceTrans',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": "CFA73DD3-DDAA-528E-B78A-6CF5971603A8",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "E0EA88F4-0701-54C9-BE9E-8120EEA36827",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "5BA96CC9-CF4E-530E-89CC-A1D53FC44E4E",
"title": "Baris",
"urlKey": ""
},
{
"id": "72A1BBB7-54C0-5C44-9171-DE165DF5A29F",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "DA701795-9656-58CB-8499-B339B82AC919",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "54CA1434-9E09-55DB-BB7B-72FED433CDAF",
"title": "Penagih",
"urlKey": ""
},
{
"id": "43D590A9-1853-51B5-B7A0-EA613F263125",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "E518AF64-0C97-5AED-BFA7-CDA7579EF4CF",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "869F54C9-8883-5754-93F7-4737C9591ADB",
"title": "Pemesan",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDate",
"label": "Tanggal faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun pemasok penagih",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAmount",
"label": "Total sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Jatuh tempo faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Baris bertaut",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "B37EAA47-6E5A-5FE2-ACCC-7DB4AA7D9A72",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceId",
"label": "Nomor faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDate",
"label": "Tanggal faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Uraian faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "PartitionKey",
"label": "Partisi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "dataAreaId",
"label": "Perusahaan tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "PrepaymentName",
"label": "Penanda uang muka sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun pemasok penagih",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "BillingVendorName",
"label": "Nama pemasok penagih saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "BillingVendorState",
"label": "Ketersediaan pemasok penagih",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "OrderAccount",
"label": "Akun pemasok pemesan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "OrderingVendorName",
"label": "Nama pemasok pemesan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "OrderingVendorState",
"label": "Ketersediaan pemasok pemesan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "PurchId",
"label": "Pesanan yang dilampirkan pada faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Nilai asli faktur",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Nilai asli faktur",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAmount",
"label": "Total faktur sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Nilai asli faktur",
"detailRole": "information",
"isVisible": true,
"key": "SalesBalance",
"label": "Total baris setelah diskon baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Nilai asli faktur",
"detailRole": "information",
"isVisible": true,
"key": "EndDisc",
"label": "Diskon total faktur (jumlah)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Nilai asli faktur",
"detailRole": "information",
"isVisible": true,
"key": "SumLineDisc",
"label": "Jumlah diskon baris faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Nilai asli faktur",
"detailRole": "information",
"isVisible": true,
"key": "SumMarkup",
"label": "Biaya tambahan faktur sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Nilai asli faktur",
"detailRole": "information",
"isVisible": true,
"key": "SumTax",
"label": "Jumlah pajak faktur sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Nilai asli faktur",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceRoundOff",
"label": "Pembulatan faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jatuh tempo dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Jatuh tempo faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jatuh tempo dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "FixedDueDate",
"label": "Jatuh tempo tetap sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jatuh tempo dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "Payment",
"label": "Kode syarat pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jatuh tempo dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "PaymentSched",
"label": "Kode jadwal pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon tunai bersyarat",
"detailRole": "information",
"isVisible": true,
"key": "CashDiscCode",
"label": "Kode diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon tunai bersyarat",
"detailRole": "information",
"isVisible": true,
"key": "CashDisc",
"label": "Jumlah diskon tunai bersyarat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon tunai bersyarat",
"detailRole": "information",
"isVisible": true,
"key": "CashDiscPercent",
"label": "Diskon tunai (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon tunai bersyarat",
"detailRole": "information",
"isVisible": true,
"key": "CashDiscDate",
"label": "Batas pembayaran untuk diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembukuan dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "LedgerVoucher",
"label": "Voucher pembukuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembukuan dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "DocumentNum",
"label": "Nomor dokumen asal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembukuan dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDate",
"label": "Tanggal dokumen asal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembukuan dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "VendGroup",
"label": "Grup pemasok pada faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembukuan dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "PostingProfile",
"label": "Kode profil pembukuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembukuan dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "DlvMode",
"label": "Kode cara pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembukuan dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "DlvTerm",
"label": "Kode syarat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Tautan baris",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Jumlah baris bertaut tepat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Tautan baris",
"detailRole": "information",
"isVisible": true,
"key": "LineLinkState",
"label": "Ketersediaan tautan baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "CA28D151-1DF1-56DC-B9E1-51AD257BEC32",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "65384408-41EC-555C-8D05-E3777B3945C3",
"includeAllOption": false,
"key": "PeriodDate",
"title": "Periode tanggal faktur",
"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": "859554C5-01D8-52DC-99BB-01C93F2B75C9",
"key": "PeriodDate",
"type": "date"
},
{
"direction": "ascending",
"id": "002A79F1-506E-5C36-93B7-CB7C709835B6",
"key": "InvoiceId",
"type": "text"
},
{
"direction": "ascending",
"id": "1FBAFB24-87C8-5993-9B00-F74D2B1076CD",
"key": "InvoiceKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "BillingVendorName",
"systemImage": "doc.text",
"title": "Faktur pemasok",
"titleKey": "InvoiceId"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Qty",
"label": "Jumlah dalam satuan beli",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PurchUnit",
"label": "Satuan beli",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PurchPrice",
"label": "Harga sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PriceUnit",
"label": "Unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineAmount",
"label": "Nilai baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "5BA96CC9-CF4E-530E-89CC-A1D53FC44E4E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Baris dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "ItemId",
"label": "Kode barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "Name",
"label": "Deskripsi standar baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Uraian barang yang dipesan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "ExternalItemId",
"label": "Kode barang pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "LineNum",
"label": "Nomor urut baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceId",
"label": "Nomor faktur pada baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDate",
"label": "Tanggal transaksi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "PurchID",
"label": "Pesanan yang dilampirkan pada baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "OrigPurchId",
"label": "Pesanan asal tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan harga",
"detailRole": "information",
"isVisible": true,
"key": "Qty",
"label": "Jumlah dalam satuan beli",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan harga",
"detailRole": "information",
"isVisible": true,
"key": "PurchUnit",
"label": "Satuan beli",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan harga",
"detailRole": "information",
"isVisible": true,
"key": "InventQty",
"label": "Jumlah dalam satuan inventaris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan harga",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan harga",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyState",
"label": "Kesesuaian mata uang dengan faktur induk",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan harga",
"detailRole": "information",
"isVisible": true,
"key": "PurchPrice",
"label": "Harga per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan harga",
"detailRole": "information",
"isVisible": true,
"key": "PriceUnit",
"label": "Jumlah satuan per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan harga",
"detailRole": "information",
"isVisible": true,
"key": "LineAmount",
"label": "Nilai baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan harga",
"detailRole": "information",
"isVisible": true,
"key": "LineAmountTax",
"label": "Pajak yang termasuk dalam nilai baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon dan kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "LineDisc",
"label": "Diskon baris per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon dan kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "LinePercent",
"label": "Diskon baris (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon dan kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "MultiLnDisc",
"label": "Diskon multibaris per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon dan kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "MultiLnPercent",
"label": "Diskon multibaris (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon dan kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "DiscAmount",
"label": "Jumlah diskon transaksi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon dan kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "DiscPercent",
"label": "Diskon transaksi (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon dan kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "PurchMarkup",
"label": "Biaya harga tetap sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon dan kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "TaxGroup",
"label": "Kode grup pajak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon dan kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "TaxItemGroup",
"label": "Kode pajak barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InventSiteId",
"label": "Kode lokasi dimensi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InventLocationId",
"label": "Kode gudang dimensi",
"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": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "DimensionState",
"label": "Ketersediaan dimensi saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "536086BE-8224-5D87-B553-46380C1DE8D7",
"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": "Baris faktur pemasok",
"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 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": "Status penangguhan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "54CA1434-9E09-55DB-BB7B-72FED433CDAF",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "VendorName",
"label": "Nama pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "AccountNum",
"label": "Akun pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "KnownAs",
"label": "Nama dikenal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "NameAlias",
"label": "Alias pencarian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PartyNumber",
"label": "Nomor pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "VendGroup",
"label": "Grup pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "LineOfBusinessId",
"label": "Kode bidang usaha",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "OneTimeSupplier",
"label": "Pemasok satu kali",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang faktur pemasok bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun pemasok penagih",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "YourAccountNum",
"label": "Akun kita pada pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "PaymTermId",
"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": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "PaymSpec",
"label": "Kode penanganan pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "PaymSched",
"label": "Kode jadwal pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "PaymDayId",
"label": "Kode hari pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "CashDisc",
"label": "Kode diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "PurchPoolId",
"label": "Kode kelompok pesanan pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "DlvMode",
"label": "Kode cara pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "DlvTerm",
"label": "Kode syarat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penangguhan dan nama sumber",
"detailRole": "information",
"isVisible": true,
"key": "BlockStatus",
"label": "Status penangguhan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penangguhan dan nama sumber",
"detailRole": "information",
"isVisible": true,
"key": "BlockedReleaseDate",
"label": "Tanggal pelepasan penangguhan sumber (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penangguhan dan nama sumber",
"detailRole": "information",
"isVisible": true,
"key": "CreditRating",
"label": "Peringkat kredit pemasok tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penangguhan dan nama sumber",
"detailRole": "information",
"isVisible": true,
"key": "PartyState",
"label": "Ketersediaan nama pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "9145ACCB-CD9D-5277-99F3-4516063DAC19",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "BC515F3F-CAEC-53F1-9967-06042027411E",
"key": "VendorKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountNum",
"systemImage": "shippingbox",
"title": "Pemasok penagihan saat ini",
"titleKey": "VendorName"
},
{
"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 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": "Status penangguhan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "869F54C9-8883-5754-93F7-4737C9591ADB",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "VendorName",
"label": "Nama pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "AccountNum",
"label": "Akun pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "KnownAs",
"label": "Nama dikenal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "NameAlias",
"label": "Alias pencarian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PartyNumber",
"label": "Nomor pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "VendGroup",
"label": "Grup pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "LineOfBusinessId",
"label": "Kode bidang usaha",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok saat ini",
"detailRole": "information",
"isVisible": true,
"key": "OneTimeSupplier",
"label": "Pemasok satu kali",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang faktur pemasok bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun pemasok penagih",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "YourAccountNum",
"label": "Akun kita pada pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "PaymTermId",
"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": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "PaymSpec",
"label": "Kode penanganan pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "PaymSched",
"label": "Kode jadwal pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "PaymDayId",
"label": "Kode hari pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "CashDisc",
"label": "Kode diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "PurchPoolId",
"label": "Kode kelompok pesanan pembelian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "DlvMode",
"label": "Kode cara pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pembelian dan pengiriman",
"detailRole": "information",
"isVisible": true,
"key": "DlvTerm",
"label": "Kode syarat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penangguhan dan nama sumber",
"detailRole": "information",
"isVisible": true,
"key": "BlockStatus",
"label": "Status penangguhan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penangguhan dan nama sumber",
"detailRole": "information",
"isVisible": true,
"key": "BlockedReleaseDate",
"label": "Tanggal pelepasan penangguhan sumber (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penangguhan dan nama sumber",
"detailRole": "information",
"isVisible": true,
"key": "CreditRating",
"label": "Peringkat kredit pemasok tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penangguhan dan nama sumber",
"detailRole": "information",
"isVisible": true,
"key": "PartyState",
"label": "Ketersediaan nama pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "91C201B5-8359-515F-AF94-9C96CC164E27",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"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": "5BA96CC9-CF4E-530E-89CC-A1D53FC44E4E",
"childKey": "ParentInvoiceKey",
"id": "E0EA88F4-0701-54C9-BE9E-8120EEA36827",
"name": "Baris",
"parentDatasetID": "B37EAA47-6E5A-5FE2-ACCC-7DB4AA7D9A72",
"parentKey": "InvoiceKey"
},
{
"childDatasetID": "54CA1434-9E09-55DB-BB7B-72FED433CDAF",
"childKey": "ParentInvoiceKey",
"id": "DA701795-9656-58CB-8499-B339B82AC919",
"name": "Penagih",
"parentDatasetID": "B37EAA47-6E5A-5FE2-ACCC-7DB4AA7D9A72",
"parentKey": "InvoiceKey"
},
{
"childDatasetID": "869F54C9-8883-5754-93F7-4737C9591ADB",
"childKey": "ParentInvoiceKey",
"id": "E518AF64-0C97-5AED-BFA7-CDA7579EF4CF",
"name": "Pemesan",
"parentDatasetID": "B37EAA47-6E5A-5FE2-ACCC-7DB4AA7D9A72",
"parentKey": "InvoiceKey"
}
],
"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, administrasi pemasok dan manajer: pilih periode faktur, partisi dan perusahaan. Lihat total sumber, pajak faktur, diskon dan jatuh tempo; buka baris dengan satuan, harga, pesanan asal dan dimensi. Penagih dan Pemesan membuka dua peran pemasok saat ini, tidak saling menggantikan. 123 posisi berguna dalam empat 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: AX 2012 R3 on-premises SQL Server untuk instalasi lama yang sudah ada; dukungan diperpanjang berakhir 11 Januari 2023. Bukan D365 Finance/SCM, AX2009 atau SQL cloud. Pro nyata: satu sumber, satu Home, empat daftar dan tiga sub-tombol lazy; tidak ada refresh berkala.\n\nTAUTAN BARIS BELUM DIVALIDASI PADA R3 NYATA: lima field PurchID/InvoiceId/InvoiceDate/numberSequenceGroup/InternalInvoiceId berasal dari ekstrak metadata ASLI AX2012 R2, baris 228, dan output debug penulis AX. Referensi Microsoft R3 mendokumentasikan field dan relasi bernama tetapi daftar FK lengkap kosong. Ini bukan sertifikat mapping R3: administrator WAJIB memastikan pemetaan, populasi, indeks, keunikan dan kelengkapan setiap jalur posting termasuk konsolidasi sebelum digunakan. Tidak ada ParentRecId inventif atau fallback berdasarkan nomor faktur saja. PurchID adalah pesanan terlampir, OrigPurchId pesanan asal baris dan tidak dipaksa sama dengan faktur induk. Baris dengan pesanan asal berbeda tetap dapat tampil bila kelima field tautan cocok. Itu bukan bukti seluruh alur konsolidasi instalasi tercakup. Kunci NULL/kosong yang tidak cukup atau faktur induk ambigu memberi keadaan eksplisit dan jumlah baris kosong, bukan nol palsu atau pilihan baris pertama. Nol tautan unik bukan bukti faktur tidak pernah memiliki baris.\n\nIdentitas baris duplikat memblokir seluruh pembukaan baris dengan peringatan dan jumlah kosong, bukan menampilkan daftar parsial atau menghapus duplikat agar terlihat rapi.\n\nLINGKUP: Proforma=No(0) dari EDT sendiri; uang muka, retur, nilai negatif, nol dan NULL tidak dihapus diam-diam. Tidak menebak bahwa angka negatif berarti nota kredit atau proforma berarti pembayaran. Baris anak membaca konteks faktur induk tepat, tanpa mengulang filter periode; master bisa hilang tanpa menghapus faktur. InvoiceAccount adalah pemasok penagih dan OrderAccount pemasok pemesan. Nama master SAAT INI bukan salinan historis nama faktur; mata uang/syarat master mungkin berbeda.\n\nNILAI ASLI: InvoiceAmount total sumber dalam mata uang faktur, bukan saldo utang. SalesBalance total baris setelah diskon; EndDisc adalah JUMLAH, bukan persen. SumTax adalah pajak faktur induk asli; LineAmountTax pajak yang sudah termasuk pada baris, bukan pajak tambahan atau pajak yang dihitung ulang. CashDisc bersyarat bukan potongan yang terbukti dibayar. Tidak menambahkan komponen menjadi formula total, menjumlah lintas mata uang, membalik tanda atau menganggap voucher/kode pembayaran sebagai lunas. MST/reporting currency dan data bank/identitas pemerintah/kontak privat/audit dihilangkan.\n\nSATUAN/PRESISI: Qty dalam PurchUnit, InventQty dalam satuan inventaris yang tidak ditebak. PurchPrice dan diskon nominal per PriceUnit; denominator nol/NULL tidak dibagi. LineAmount dan CurrencyCode baris dipertahankan walau beda dengan faktur induk, dengan peringatan. Sumber Real ditampilkan sebagai teks untuk mempertahankan nilai kecil; filter/sort jumlah adalah teks, bukan agregasi numerik. Tidak menghitung Qty x harga, margin, pajak atau total satuan campuran. Dimensi InventDim adalah kode konteks saat ini, bukan jaminan stok/dimensi historis; hilang atau ambigu tidak menghapus baris.\n\nAKSES: pilih periode InvoiceDate, partisi dan DATAAREAID tersimpan sebelum batas 1.000 baris. Int64 dikirim sebagai teks utuh; pencocokan tepat membedakan case dan spasi akhir. Token tautan diturunkan dari lima field, bukan kolom asli AX, dan diuji ulang untuk faktur induk berubah. Duplikat RecId di scope ditolak, bukan deduplikasi kosmetik. Filter bukan ACL: SQL langsung tidak mewarisi AOS/XDS/izin aplikasi. Administrator harus membatasi akun SELECT, module/configuration keys, schema pemilik, perusahaan virtual, izin, indeks dan biaya baca. Batas 1.000 bukan jaminan cepat/lengkap.\n\nVALIDASI: dokumentasi dan SQLite sintetik/adaptasi SELECT bukan tes SQL Server/ERP nyata. DEMO berisi data fiktif tanpa kredensial/server perusahaan. Uji baca terbatas saat impor dan verifikasi mapping R3 lokal wajib; paket bukan afiliasi atau garansi vendor.\n\nReferensi R3 faktur induk: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg928207(v=ax.60)\nReferensi R3 baris: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg949675(v=ax.60)\nEkstrak relasi R2 (bukan sertifikat R3): https://alexdmeyer.com/ax2012erd/Fky-AcctPay-ParentChilds-11.htm\nOutput debug penulis AX (bukan manual vendor): https://community.dynamics.com/forums/thread/details/?threadid=d5c36cd2-1a69-4f77-875f-684e42672021",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "6F7B8352-6BC4-5790-8DA6-CC4B598B8CFB",
"rootButtonCount": 1,
"summary": "Periode, partisi dan perusahaan; total sumber, pajak, diskon, baris serta master pemasok penagih dan pemesan.",
"tags": [
"Dynamics AX 2012 R3",
"SQL Server",
"Faktur pemasok",
"Pembelian",
"Baris faktur",
"Pro"
],
"title": "Faktur pemasok, baris dan dua peran pemasok — Pro"
}
}