Posisi terbuka pemasok, transaksi dan master — Pro
Posisi pemasok saat ini, jatuh tempo dan mata uang terkait; transaksi, syarat dan jadwal melalui dua sub-tombol.
TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA.
Untuk akuntansi, pengadaan dan manajer: pilih partisi/perusahaan dan, bila perlu, akun pemasok. Lihat posisi terbuka SAAT INI, jatuh tempo, jumlah bertanda dan mata uang transaksi terkait. Buka Transaksi untuk dokumen, tanggal dan referensi pembayaran, atau Pemasok untuk syarat, jadwal, pengiriman dan penangguhan master saat ini. 60 posisi berguna dalam Detil; tidak hanya beberapa nama.
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, hanya instalasi lama yang sudah ada. Dukungan berakhir 11 Januari 2023; bukan Dynamics 365/Business Central/cloud atau anjuran membuka server ke internet. Pro nyata: satu sumber, satu Home, tiga daftar dan dua sub-tombol lazy. Tanpa refresh berkala.
POSISI SUMBER: VendTransOpen saat pembacaan, bukan seluruh faktur, saldo historis/as-of atau aging rekonstruksi. AmountCur tetap bertanda tanpa ABS/pembalikan sign atau rumus faktur dikurangi pembayaran. Tanggal lama, pembayaran/uang muka, kredit, nol, negatif dan NULL tidak dibuang berdasarkan jenis atau nomor yang ditebak. Tanpa cutoff periode otomatis; filter tanggal lokal hanya baris yang sudah dibaca. Sign, tanggal kosong/sentinel, penyelesaian dan kelengkapan harus dicocokkan dengan AX terpasang.
JUMLAH/MATA UANG: CurrencyCode hanya dari satu VendTrans cocok, bukan default VendTable. Referensi hilang/ambigu atau currency kosong terlihat, tanpa menebak mata uang atau menghilangkan posisi. AmountCur dan SettleAmountCur adalah nilai asli terpisah, bukan formula remaining atau bukti transfer bank. PossibleCashDisc adalah jumlah diskon sumber saat penagihan; bukan sekadar label diskon potensial pelanggan, atau sertifikat diskon yang diterapkan pada pembayaran. Mata uang/konteks diskon harus diverifikasi pada instalasi. AmountMST/reporting/kurs dihilangkan tanpa bukti mata uang sendiri. Tidak ada SUM campuran currency, konversi atau netting. Tampilan teks desimal mempertahankan presisi kecil; bukan widget agregasi atau filter/sort angka implisit. Tipe sumber tidak diubah.
TAUTAN: EDT Int64 VendTransRefRecId dan relasi bernama RefRecId menunjuk VendTrans; referensi publik tidak memuat daftar FK SQL lengkap atau badan X++ vendTrans(). Administrator wajib menguji populasi, pemetaan, keunikan, kunci/indeks, modul dan hak. Kueri mencocokkan partisi, DATAAREAID tersimpan, akun pemasok dan RefRecId tepat; tidak ada fallback faktur/Voucher/nama atau memakai pemasok pesanan sebagai pengganti akun posisi. Beberapa posisi dengan RefRecId sama tetap berbeda. Missing/ambiguous master atau transaksi tidak menghapus/menggandakan posisi; referensi parent berubah gagal aman.
TANGGAL/KONTEKS: tanggal/jatuh tempo posisi bukan tanggal transaksi/dokumen. CashDiscDate ditampilkan sebagai tanggal sumber untuk pembuatan transaksi. LastSettleDate memiliki keterangan publik hanya tanggal transaksi; tidak dinyatakan sebagai tanggal voucher pengurang terakhir milik pelanggan. Closed adalah tanggal penyelesaian total sumber, bukan enum Ya/Tidak atau kesimpulan lunas. LastInterestDate pelanggan tidak diproyeksikan pada pemasok. Kode/payment reference bukan mutasi bank.
MASTER SAAT INI: nama, syarat/jadwal/hari pembayaran, kelompok pengadaan, pengiriman dan peringkat tersimpan bukan snapshot faktur historis atau skor dihitung. YourAccountNum adalah akun kita pada pemasok, bukan OurAccountNum pelanggan. OneTimeVendor dan VendBlocked memakai rantai sendiri; kode NULL/asing tetap terlihat. BlockedReleaseDate tetap teks UTC sumber; tanggal tersebut tidak otomatis menyatakan pemasok aktif. Currency master bukan currency posisi. Tidak ada bank, alamat/kontak privat, identitas pemerintah, audit atau credit limit dengan mata uang ditebak. Nama bisnis dapat berupa data pribadi. Jenis transaksi memakai 47 kode resmi; regional/asing/NULL tidak disembunyikan.
AKSES/KINERJA: partisi/perusahaan wajib dan akun opsional sebelum maksimum 1.000 baris per baca. Tidak menjamin seluruh sumber, kueri murah atau snapshot atomik lintas layar. Int64 sebagai teks penuh dan binary matching mempertahankan kapital/spasi akhir. Scope kosong/partisi ambigu tidak dibuka; bukan bukti tidak ada utang. Filter bukan ACL; SQL langsung tidak mewarisi AOS/XDS. Gunakan akun SELECT berizin minimum; periksa perusahaan virtual, schema pemilik, kolom/FK/indeks dan uji terbatas saat impor. Tidak ada server/kredensial/data perusahaan nyata. AOT/SQLite/DEMO bukan DDL SQL terpasang atau uji ERP nyata.
Posisi: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg951979(v=ax.60)
Transaksi: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg930306(v=ax.60)
Referensi Int64: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg918908(v=ax.60)
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Posisi terbuka pemasok
- Details: Transaksi
- Details: Pemasok
- Sub-button: Transaksi pemasok terkait
- Sub-button: Pemasok posisi saat ini
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS OpenKey, CAST(o.Partition AS nvarchar(30)) AS PartitionId, CAST(o.RecId AS nvarchar(30)) AS OpenRecId, CASE WHEN o.RefRecId IS NULL THEN N'N:' ELSE CONCAT(N'V:',CAST(o.RefRecId AS nvarchar(30))) END AS RefToken, CONCAT(o.AccountNum,N' · ',COALESCE(NULLIF(t.Invoice,N''),NULLIF(t.Voucher,N''),N'posisi sumber')) AS Title, o.AccountNum AS AccountNum, p.Name AS VendorName, pt.PartitionKey AS PartitionKey, o.dataAreaId AS dataAreaId, o.TransDate AS OpenTransDate, o.DueDate AS DueDate, o.AmountCur AS OpenAmountCur, t.CurrencyCode AS CurrencyCode, t.Invoice AS Invoice, t.Voucher AS Voucher, t.TransDate AS OriginalTransDate, CASE (SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId),N' referensi; nilai tidak dipilih') END AS TransactionState, CASE WHEN (SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId)=1 AND (t.CurrencyCode IS NULL OR LEN(t.CurrencyCode)=0) THEN N'Referensi ada, mata uang kosong' ELSE CASE (SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId),N' referensi; nilai tidak dipilih') END END AS CurrencyState, 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.AccountNum 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.AccountNum AS varbinary(max)) AND q.RecId>0),N' referensi; nilai tidak dipilih') END AS VendorState, 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, o.CashDiscDate AS CashDiscDate, o.PossibleCashDisc AS PossibleCashDisc FROM VendTransOpen 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 VendTrans t ON t.Partition=o.Partition AND CAST(t.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(t.AccountNum AS varbinary(max))=CAST(o.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND t.RecId=o.RefRecId AND (SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId)=1 LEFT 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.AccountNum 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.AccountNum 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.Partition IS NOT NULL AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.AccountNum IS NOT NULL AND DATALENGTH(o.AccountNum)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendTransOpen',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTransOpen',N'U') AND OBJECT_ID(N'VendTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTrans',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')
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(t.Partition,N'#')),N':',t.Partition,N':',LEN(CONCAT(t.dataAreaId,N'#')),N':',t.dataAreaId,N':',LEN(CONCAT(t.RecId,N'#')),N':',t.RecId,N':')) AS TransKey, 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 ParentOpenKey, CONCAT(o.AccountNum,N' · ',COALESCE(NULLIF(t.Invoice,N''),NULLIF(t.Voucher,N''),N'posisi sumber')) AS TransTitle, t.AccountNum AS AccountNum, t.Invoice AS Invoice, t.Voucher AS Voucher, t.DocumentNum AS DocumentNum, t.DocumentDate AS DocumentDate, t.TransDate AS TransDate, t.DueDate AS DueDate, t.CurrencyCode AS CurrencyCode, t.AmountCur AS AmountCur, t.SettleAmountCur AS SettleAmountCur, t.Closed AS Closed, t.LastSettleDate AS LastSettleDate, t.Txt AS Txt, t.PaymMode AS PaymMode, t.PaymSpec AS PaymSpec, t.PaymReference AS PaymReference, t.PostingProfile AS PostingProfile, t.CashDiscCode AS CashDiscCode, CASE WHEN t.TransType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE t.TransType WHEN 1 THEN N'Transfer' WHEN 2 THEN N'Penjualan' WHEN 3 THEN N'Pembelian' WHEN 4 THEN N'Inventaris' WHEN 5 THEN N'Produksi' WHEN 6 THEN N'Proyek' WHEN 7 THEN N'Bunga' WHEN 8 THEN N'Pelanggan' WHEN 9 THEN N'Kode asli: ExchAdjustment' WHEN 10 THEN N'Kode asli: SummedUp' WHEN 11 THEN N'Kode asli: Payroll' WHEN 12 THEN N'Kode asli: FixedAssets' WHEN 13 THEN N'Kode asli: CollectionLetter' WHEN 14 THEN N'Pemasok' WHEN 15 THEN N'Pembayaran' WHEN 16 THEN N'Pajak' WHEN 17 THEN N'Bank' WHEN 18 THEN N'Kode asli: Conversion' WHEN 19 THEN N'Kode asli: BillOfExchange' WHEN 20 THEN N'Kode asli: PromissoryNote' WHEN 21 THEN N'Kode asli: Cost' WHEN 22 THEN N'Kode asli: Work' WHEN 23 THEN N'Kode asli: Fee' WHEN 24 THEN N'Penyelesaian' WHEN 25 THEN N'Kode asli: Allocation' WHEN 26 THEN N'Kode asli: Elimination' WHEN 27 THEN N'Diskon tunai' WHEN 28 THEN N'Kode asli: OverUnder' WHEN 29 THEN N'Kode asli: PennyDifference' WHEN 30 THEN N'Kode asli: CrossCompanySettlement' WHEN 31 THEN N'Kode asli: PurchReq' WHEN 32 THEN N'Kode asli: InflationAdjustment_MX' WHEN 33 THEN N'Kode asli: PurchAdvanceApplication' WHEN 34 THEN N'Kode asli: ConversionReporting' WHEN 35 THEN N'Penghapusan' WHEN 36 THEN N'Jurnal umum' WHEN 79 THEN N'Kode asli: FixedAssets_RU' WHEN 80 THEN N'Kode asli: RTax25_BadDebtDebitAmortisation' WHEN 81 THEN N'Kode asli: RDeferrals' WHEN 82 THEN N'Kode asli: RTax25_BadDebtCreditAmortisation' WHEN 83 THEN N'Kode asli: AdvanceAdjustment_RU' WHEN 84 THEN N'Kode asli: VATTaxAgent_RU' WHEN 85 THEN N'Kode asli: GainLossCurrencyDeal_RU' WHEN 100 THEN N'Kode asli: PdsRebateCreditNote' WHEN 101 THEN N'Kode asli: PdsRebatePassToAP' WHEN 251 THEN N'Kode asli: MCRUnderpayWriteOff' WHEN 0 THEN N'Tanpa jenis' ELSE CONCAT(N'Kode sumber ',t.TransType) END END AS TransTypeName FROM VendTransOpen 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 VendTrans t ON t.Partition=o.Partition AND CAST(t.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(t.AccountNum AS varbinary(max))=CAST(o.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND t.RecId=o.RefRecId AND (SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId)=1 WHERE o.Partition IS NOT NULL AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.AccountNum IS NOT NULL AND DATALENGTH(o.AccountNum)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:openRecId AS bigint) AND CAST(o.AccountNum AS varbinary(max))=CAST(:account AS varbinary(max)) AND CAST(CASE WHEN o.RefRecId IS NULL THEN N'N:' ELSE CONCAT(N'V:',CAST(o.RefRecId AS nvarchar(30))) END AS varbinary(max))=CAST(:refToken AS varbinary(max)) AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendTransOpen',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTransOpen',N'U') AND OBJECT_ID(N'VendTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTrans',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')
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 ParentOpenKey, 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 VendTransOpen 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.AccountNum 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.AccountNum 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.Partition IS NOT NULL AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.AccountNum IS NOT NULL AND DATALENGTH(o.AccountNum)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:openRecId AS bigint) AND CAST(o.AccountNum AS varbinary(max))=CAST(:account AS varbinary(max)) AND CAST(CASE WHEN o.RefRecId IS NULL THEN N'N:' ELSE CONCAT(N'V:',CAST(o.RefRecId AS nvarchar(30))) END AS varbinary(max))=CAST(:refToken AS varbinary(max)) AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendTransOpen',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTransOpen',N'U') AND OBJECT_ID(N'VendTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTrans',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')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Dynamics AX 2012 R3 — SQL Server lokal berizin",
"id": "3D496E04-364C-59CD-AE72-47C4E7EB0D77",
"kind": "sqlServer",
"requiredObjects": [
"VendTransOpen",
"VendTrans",
"Partitions",
"VendTable",
"DirPartyTable"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "8096CC7D-08A7-5A46-86CE-E08D5A211BA9",
"key": "DueDate",
"type": "date"
},
{
"direction": "ascending",
"id": "1C129BE8-126E-5066-8041-5347A0926F31",
"key": "AccountNum",
"type": "text"
},
{
"direction": "ascending",
"id": "09AE7138-08DE-51E1-988D-0315B5F41839",
"key": "OpenKey",
"type": "text"
}
],
"id": "3B111F70-09BB-5C86-B82F-9DCFF96D4326",
"mappings": [
{
"commonFieldKey": "",
"key": "OpenKey",
"label": "Internal OpenKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OpenKey",
"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": "OpenRecId",
"label": "Internal OpenRecId",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OpenRecId",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RefToken",
"label": "Internal RefToken",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RefToken",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Title",
"label": "Internal Title",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Title",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountNum",
"label": "Akun pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VendorName",
"label": "Nama pemasok saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorName",
"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": "OpenTransDate",
"label": "Tanggal posisi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OpenTransDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DueDate",
"label": "Jatuh tempo posisi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OpenAmountCur",
"label": "Jumlah posisi sumber (bertanda)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OpenAmountCur",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Mata uang transaksi terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Invoice",
"label": "Nomor faktur transaksi terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Invoice",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Voucher",
"label": "Voucher transaksi terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Voucher",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginalTransDate",
"label": "Tanggal transaksi terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OriginalTransDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionState",
"label": "Ketersediaan transaksi terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransactionState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CurrencyState",
"label": "Ketersediaan mata uang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VendorState",
"label": "Ketersediaan master pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorState",
"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
},
{
"commonFieldKey": "",
"key": "CashDiscDate",
"label": "Tanggal diskon sumber untuk pembuatan transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CashDiscDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PossibleCashDisc",
"label": "Jumlah diskon tunai saat penagihan (sumber)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PossibleCashDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Posisi terbuka pemasok",
"primaryKey": "OpenKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"AccountNum",
"VendorName",
"PartitionKey",
"dataAreaId",
"OpenTransDate",
"DueDate",
"OpenAmountCur",
"CurrencyCode",
"Invoice",
"Voucher",
"OriginalTransDate",
"TransactionState",
"CurrencyState",
"VendorState",
"PartyState",
"CashDiscDate",
"PossibleCashDisc"
],
"sourceID": "3D496E04-364C-59CD-AE72-47C4E7EB0D77",
"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 OpenKey, CAST(o.Partition AS nvarchar(30)) AS PartitionId, CAST(o.RecId AS nvarchar(30)) AS OpenRecId, CASE WHEN o.RefRecId IS NULL THEN N'N:' ELSE CONCAT(N'V:',CAST(o.RefRecId AS nvarchar(30))) END AS RefToken, CONCAT(o.AccountNum,N' · ',COALESCE(NULLIF(t.Invoice,N''),NULLIF(t.Voucher,N''),N'posisi sumber')) AS Title, o.AccountNum AS AccountNum, p.Name AS VendorName, pt.PartitionKey AS PartitionKey, o.dataAreaId AS dataAreaId, o.TransDate AS OpenTransDate, o.DueDate AS DueDate, o.AmountCur AS OpenAmountCur, t.CurrencyCode AS CurrencyCode, t.Invoice AS Invoice, t.Voucher AS Voucher, t.TransDate AS OriginalTransDate, CASE (SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId),N' referensi; nilai tidak dipilih') END AS TransactionState, CASE WHEN (SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId)=1 AND (t.CurrencyCode IS NULL OR LEN(t.CurrencyCode)=0) THEN N'Referensi ada, mata uang kosong' ELSE CASE (SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId) WHEN 0 THEN N'Tidak tersedia' WHEN 1 THEN N'Tersedia, satu referensi' ELSE CONCAT(N'Ambigu: ',(SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId),N' referensi; nilai tidak dipilih') END END AS CurrencyState, 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.AccountNum 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.AccountNum AS varbinary(max)) AND q.RecId>0),N' referensi; nilai tidak dipilih') END AS VendorState, 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, o.CashDiscDate AS CashDiscDate, o.PossibleCashDisc AS PossibleCashDisc FROM VendTransOpen 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 VendTrans t ON t.Partition=o.Partition AND CAST(t.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(t.AccountNum AS varbinary(max))=CAST(o.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND t.RecId=o.RefRecId AND (SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId)=1 LEFT 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.AccountNum 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.AccountNum 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.Partition IS NOT NULL AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.AccountNum IS NOT NULL AND DATALENGTH(o.AccountNum)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendTransOpen',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTransOpen',N'U') AND OBJECT_ID(N'VendTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTrans',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')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "8D5638F7-E0EF-55B1-8436-6FFBF61C7634",
"key": "TransKey",
"type": "text"
}
],
"id": "8C7FB110-8A66-5355-9E0B-E88102F230A7",
"mappings": [
{
"commonFieldKey": "",
"key": "TransKey",
"label": "Internal TransKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentOpenKey",
"label": "Internal ParentOpenKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentOpenKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransTitle",
"label": "Internal TransTitle",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransTitle",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountNum",
"label": "Akun pemasok transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Invoice",
"label": "Nomor faktur terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Invoice",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Voucher",
"label": "Nomor voucher",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Voucher",
"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": "TransDate",
"label": "Tanggal transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DueDate",
"label": "Jatuh tempo transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Mata uang transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AmountCur",
"label": "Jumlah transaksi asli (bertanda)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AmountCur",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SettleAmountCur",
"label": "Bagian diselesaikan sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SettleAmountCur",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Closed",
"label": "Tanggal penyelesaian total sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Closed",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LastSettleDate",
"label": "Tanggal sumber LastSettleDate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LastSettleDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Txt",
"label": "Uraian transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Txt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymMode",
"label": "Kode metode pembayaran pemasok",
"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": "PaymReference",
"label": "Referensi pembayaran tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymReference",
"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": "CashDiscCode",
"label": "Kode diskon tunai untuk persetujuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CashDiscCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransTypeName",
"label": "Jenis transaksi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TransTypeName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Transaksi pemasok terkait",
"primaryKey": "TransKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "E5DF15F8-86E6-5F77-AFF1-D7960B409894",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "FA8B2112-1320-5B0E-9CE7-748BAD8076A3",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OpenRecId",
"id": "8F053B4F-4170-56E2-8AF4-344F86878626",
"name": "openRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "AccountNum",
"id": "6301FADD-8A0B-546D-9C84-8292C96D815E",
"name": "account",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "RefToken",
"id": "B1D462D9-B2B1-5C68-829A-83A6DC3FBA5C",
"name": "refToken",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"AccountNum",
"Invoice",
"Voucher",
"DocumentNum",
"DocumentDate",
"TransDate",
"DueDate",
"CurrencyCode",
"AmountCur",
"SettleAmountCur",
"Closed",
"LastSettleDate",
"Txt",
"PaymMode",
"PaymSpec",
"PaymReference",
"PostingProfile",
"CashDiscCode",
"TransTypeName"
],
"sourceID": "3D496E04-364C-59CD-AE72-47C4E7EB0D77",
"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(t.Partition,N'#')),N':',t.Partition,N':',LEN(CONCAT(t.dataAreaId,N'#')),N':',t.dataAreaId,N':',LEN(CONCAT(t.RecId,N'#')),N':',t.RecId,N':')) AS TransKey, 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 ParentOpenKey, CONCAT(o.AccountNum,N' · ',COALESCE(NULLIF(t.Invoice,N''),NULLIF(t.Voucher,N''),N'posisi sumber')) AS TransTitle, t.AccountNum AS AccountNum, t.Invoice AS Invoice, t.Voucher AS Voucher, t.DocumentNum AS DocumentNum, t.DocumentDate AS DocumentDate, t.TransDate AS TransDate, t.DueDate AS DueDate, t.CurrencyCode AS CurrencyCode, t.AmountCur AS AmountCur, t.SettleAmountCur AS SettleAmountCur, t.Closed AS Closed, t.LastSettleDate AS LastSettleDate, t.Txt AS Txt, t.PaymMode AS PaymMode, t.PaymSpec AS PaymSpec, t.PaymReference AS PaymReference, t.PostingProfile AS PostingProfile, t.CashDiscCode AS CashDiscCode, CASE WHEN t.TransType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE t.TransType WHEN 1 THEN N'Transfer' WHEN 2 THEN N'Penjualan' WHEN 3 THEN N'Pembelian' WHEN 4 THEN N'Inventaris' WHEN 5 THEN N'Produksi' WHEN 6 THEN N'Proyek' WHEN 7 THEN N'Bunga' WHEN 8 THEN N'Pelanggan' WHEN 9 THEN N'Kode asli: ExchAdjustment' WHEN 10 THEN N'Kode asli: SummedUp' WHEN 11 THEN N'Kode asli: Payroll' WHEN 12 THEN N'Kode asli: FixedAssets' WHEN 13 THEN N'Kode asli: CollectionLetter' WHEN 14 THEN N'Pemasok' WHEN 15 THEN N'Pembayaran' WHEN 16 THEN N'Pajak' WHEN 17 THEN N'Bank' WHEN 18 THEN N'Kode asli: Conversion' WHEN 19 THEN N'Kode asli: BillOfExchange' WHEN 20 THEN N'Kode asli: PromissoryNote' WHEN 21 THEN N'Kode asli: Cost' WHEN 22 THEN N'Kode asli: Work' WHEN 23 THEN N'Kode asli: Fee' WHEN 24 THEN N'Penyelesaian' WHEN 25 THEN N'Kode asli: Allocation' WHEN 26 THEN N'Kode asli: Elimination' WHEN 27 THEN N'Diskon tunai' WHEN 28 THEN N'Kode asli: OverUnder' WHEN 29 THEN N'Kode asli: PennyDifference' WHEN 30 THEN N'Kode asli: CrossCompanySettlement' WHEN 31 THEN N'Kode asli: PurchReq' WHEN 32 THEN N'Kode asli: InflationAdjustment_MX' WHEN 33 THEN N'Kode asli: PurchAdvanceApplication' WHEN 34 THEN N'Kode asli: ConversionReporting' WHEN 35 THEN N'Penghapusan' WHEN 36 THEN N'Jurnal umum' WHEN 79 THEN N'Kode asli: FixedAssets_RU' WHEN 80 THEN N'Kode asli: RTax25_BadDebtDebitAmortisation' WHEN 81 THEN N'Kode asli: RDeferrals' WHEN 82 THEN N'Kode asli: RTax25_BadDebtCreditAmortisation' WHEN 83 THEN N'Kode asli: AdvanceAdjustment_RU' WHEN 84 THEN N'Kode asli: VATTaxAgent_RU' WHEN 85 THEN N'Kode asli: GainLossCurrencyDeal_RU' WHEN 100 THEN N'Kode asli: PdsRebateCreditNote' WHEN 101 THEN N'Kode asli: PdsRebatePassToAP' WHEN 251 THEN N'Kode asli: MCRUnderpayWriteOff' WHEN 0 THEN N'Tanpa jenis' ELSE CONCAT(N'Kode sumber ',t.TransType) END END AS TransTypeName FROM VendTransOpen 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 VendTrans t ON t.Partition=o.Partition AND CAST(t.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(t.AccountNum AS varbinary(max))=CAST(o.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND t.RecId=o.RefRecId AND (SELECT COUNT_BIG(*) FROM VendTrans 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.AccountNum AS varbinary(max)) AND o.RefRecId>0 AND q.RecId=o.RefRecId)=1 WHERE o.Partition IS NOT NULL AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.AccountNum IS NOT NULL AND DATALENGTH(o.AccountNum)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:openRecId AS bigint) AND CAST(o.AccountNum AS varbinary(max))=CAST(:account AS varbinary(max)) AND CAST(CASE WHEN o.RefRecId IS NULL THEN N'N:' ELSE CONCAT(N'V:',CAST(o.RefRecId AS nvarchar(30))) END AS varbinary(max))=CAST(:refToken AS varbinary(max)) AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendTransOpen',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTransOpen',N'U') AND OBJECT_ID(N'VendTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTrans',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')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "BC515F3F-CAEC-53F1-9967-06042027411E",
"key": "VendorKey",
"type": "text"
}
],
"id": "39DA5646-6333-52FB-94C0-77796C4BD455",
"mappings": [
{
"commonFieldKey": "",
"key": "VendorKey",
"label": "Internal VendorKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "VendorKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentOpenKey",
"label": "Internal ParentOpenKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentOpenKey",
"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 posisi saat ini",
"primaryKey": "VendorKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "E5DF15F8-86E6-5F77-AFF1-D7960B409894",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "FA8B2112-1320-5B0E-9CE7-748BAD8076A3",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OpenRecId",
"id": "8F053B4F-4170-56E2-8AF4-344F86878626",
"name": "openRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "AccountNum",
"id": "6301FADD-8A0B-546D-9C84-8292C96D815E",
"name": "account",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "RefToken",
"id": "B1D462D9-B2B1-5C68-829A-83A6DC3FBA5C",
"name": "refToken",
"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": "3D496E04-364C-59CD-AE72-47C4E7EB0D77",
"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 ParentOpenKey, 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 VendTransOpen 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.AccountNum 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.AccountNum 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.Partition IS NOT NULL AND o.RecId>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.AccountNum IS NOT NULL AND DATALENGTH(o.AccountNum)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:openRecId AS bigint) AND CAST(o.AccountNum AS varbinary(max))=CAST(:account AS varbinary(max)) AND CAST(CASE WHEN o.RefRecId IS NULL THEN N'N:' ELSE CONCAT(N'V:',CAST(o.RefRecId AS nvarchar(30))) END AS varbinary(max))=CAST(:refToken AS varbinary(max)) AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VendTransOpen',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTransOpen',N'U') AND OBJECT_ID(N'VendTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VendTrans',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')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "2504B7AF-937A-5FB8-B0DD-4E5330B364EA",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "0EFB5F0A-A8E6-5F3D-BCD1-DDD4AA5B8F96",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8C7FB110-8A66-5355-9E0B-E88102F230A7",
"title": "Transaksi",
"urlKey": ""
},
{
"id": "F58FB57A-E9F6-5CF2-9CFE-DEB62CAE87D6",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "4F5E300B-2759-53C1-845A-46C521E816CF",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "39DA5646-6333-52FB-94C0-77796C4BD455",
"title": "Pemasok",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Jatuh tempo posisi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OpenAmountCur",
"label": "Jumlah posisi (sumber)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountNum",
"label": "Akun pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransactionState",
"label": "Transaksi terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyState",
"label": "Mata uang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "3B111F70-09BB-5C86-B82F-9DCFF96D4326",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Pemasok dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "AccountNum",
"label": "Akun pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "VendorName",
"label": "Nama pemasok saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "PartitionKey",
"label": "Partisi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pemasok dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "dataAreaId",
"label": "Perusahaan tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posisi saat ini dan mata uang",
"detailRole": "information",
"isVisible": true,
"key": "OpenAmountCur",
"label": "Jumlah posisi sumber (bertanda)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posisi saat ini dan mata uang",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang transaksi terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posisi saat ini dan mata uang",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyState",
"label": "Ketersediaan mata uang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posisi saat ini dan mata uang",
"detailRole": "information",
"isVisible": true,
"key": "OpenTransDate",
"label": "Tanggal posisi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Posisi saat ini dan mata uang",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Jatuh tempo posisi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi transaksi",
"detailRole": "information",
"isVisible": true,
"key": "Invoice",
"label": "Nomor faktur transaksi terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi transaksi",
"detailRole": "information",
"isVisible": true,
"key": "Voucher",
"label": "Voucher transaksi terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi transaksi",
"detailRole": "information",
"isVisible": true,
"key": "OriginalTransDate",
"label": "Tanggal transaksi terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi transaksi",
"detailRole": "information",
"isVisible": true,
"key": "TransactionState",
"label": "Ketersediaan transaksi terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon sumber saat penagihan",
"detailRole": "information",
"isVisible": true,
"key": "CashDiscDate",
"label": "Tanggal diskon sumber untuk pembuatan transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon sumber saat penagihan",
"detailRole": "information",
"isVisible": true,
"key": "PossibleCashDisc",
"label": "Jumlah diskon tunai saat penagihan (sumber)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Ketersediaan master",
"detailRole": "information",
"isVisible": true,
"key": "VendorState",
"label": "Ketersediaan master pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Ketersediaan master",
"detailRole": "information",
"isVisible": true,
"key": "PartyState",
"label": "Ketersediaan nama pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "52CC3FA1-7C99-5971-8B16-D0B2E8989829",
"openFilters": [
{
"id": "2ABFB427-27FD-5002-8E5A-D1782FECAED0",
"includeAllOption": false,
"key": "PartitionKey",
"title": "Partisi",
"type": "text"
},
{
"id": "66C2D089-E1AE-5E36-A893-61BBE5E755AC",
"includeAllOption": false,
"key": "dataAreaId",
"title": "Perusahaan tersimpan",
"type": "text"
},
{
"id": "44CF3BC9-0137-5F52-8099-B96951C603AC",
"includeAllOption": true,
"key": "AccountNum",
"title": "Akun pemasok",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "8096CC7D-08A7-5A46-86CE-E08D5A211BA9",
"key": "DueDate",
"type": "date"
},
{
"direction": "ascending",
"id": "1C129BE8-126E-5066-8041-5347A0926F31",
"key": "AccountNum",
"type": "text"
},
{
"direction": "ascending",
"id": "09AE7138-08DE-51E1-988D-0315B5F41839",
"key": "OpenKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "VendorName",
"systemImage": "banknote",
"title": "Posisi terbuka pemasok",
"titleKey": "Title"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransDate",
"label": "Tanggal transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AmountCur",
"label": "Jumlah transaksi asli (bertanda)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SettleAmountCur",
"label": "Bagian diselesaikan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Closed",
"label": "Tanggal penyelesaian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "8C7FB110-8A66-5355-9E0B-E88102F230A7",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identitas transaksi",
"detailRole": "information",
"isVisible": true,
"key": "AccountNum",
"label": "Akun pemasok transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas transaksi",
"detailRole": "information",
"isVisible": true,
"key": "Invoice",
"label": "Nomor faktur terkait",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas transaksi",
"detailRole": "information",
"isVisible": true,
"key": "Voucher",
"label": "Nomor voucher",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas transaksi",
"detailRole": "information",
"isVisible": true,
"key": "DocumentNum",
"label": "Nomor dokumen asal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas transaksi",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDate",
"label": "Tanggal dokumen asal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas transaksi",
"detailRole": "information",
"isVisible": true,
"key": "TransTypeName",
"label": "Jenis transaksi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas transaksi",
"detailRole": "information",
"isVisible": true,
"key": "Txt",
"label": "Uraian transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Tanggal dan jumlah asli",
"detailRole": "information",
"isVisible": true,
"key": "TransDate",
"label": "Tanggal transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Tanggal dan jumlah asli",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Jatuh tempo transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Tanggal dan jumlah asli",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Tanggal dan jumlah asli",
"detailRole": "information",
"isVisible": true,
"key": "AmountCur",
"label": "Jumlah transaksi asli (bertanda)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Tanggal dan jumlah asli",
"detailRole": "information",
"isVisible": true,
"key": "SettleAmountCur",
"label": "Bagian diselesaikan sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Tanggal dan jumlah asli",
"detailRole": "information",
"isVisible": true,
"key": "Closed",
"label": "Tanggal penyelesaian total sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Tanggal dan jumlah asli",
"detailRole": "information",
"isVisible": true,
"key": "LastSettleDate",
"label": "Tanggal sumber LastSettleDate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kode pembayaran sumber",
"detailRole": "information",
"isVisible": true,
"key": "PaymMode",
"label": "Kode metode pembayaran pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kode pembayaran sumber",
"detailRole": "information",
"isVisible": true,
"key": "PaymSpec",
"label": "Kode penanganan pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kode pembayaran sumber",
"detailRole": "information",
"isVisible": true,
"key": "PaymReference",
"label": "Referensi pembayaran tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kode pembayaran sumber",
"detailRole": "information",
"isVisible": true,
"key": "PostingProfile",
"label": "Kode profil pembukuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kode pembayaran sumber",
"detailRole": "information",
"isVisible": true,
"key": "CashDiscCode",
"label": "Kode diskon tunai untuk persetujuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "2EB27C62-70CE-5503-95D5-3E58C9CD7528",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "8D5638F7-E0EF-55B1-8436-6FFBF61C7634",
"key": "TransKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Voucher",
"systemImage": "doc.text",
"title": "Transaksi pemasok terkait",
"titleKey": "TransTitle"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VendGroup",
"label": "Grup pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang faktur pemasok 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": "39DA5646-6333-52FB-94C0-77796C4BD455",
"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": "AD637DA8-F6E6-5556-A22F-908B074666BC",
"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 posisi saat ini",
"titleKey": "VendorName"
}
],
"relations": [
{
"childDatasetID": "8C7FB110-8A66-5355-9E0B-E88102F230A7",
"childKey": "ParentOpenKey",
"id": "0EFB5F0A-A8E6-5F3D-BCD1-DDD4AA5B8F96",
"name": "Transaksi",
"parentDatasetID": "3B111F70-09BB-5C86-B82F-9DCFF96D4326",
"parentKey": "OpenKey"
},
{
"childDatasetID": "39DA5646-6333-52FB-94C0-77796C4BD455",
"childKey": "ParentOpenKey",
"id": "4F5E300B-2759-53C1-845A-46C521E816CF",
"name": "Pemasok",
"parentDatasetID": "3B111F70-09BB-5C86-B82F-9DCFF96D4326",
"parentKey": "OpenKey"
}
],
"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 akuntansi, pengadaan dan manajer: pilih partisi/perusahaan dan, bila perlu, akun pemasok. Lihat posisi terbuka SAAT INI, jatuh tempo, jumlah bertanda dan mata uang transaksi terkait. Buka Transaksi untuk dokumen, tanggal dan referensi pembayaran, atau Pemasok untuk syarat, jadwal, pengiriman dan penangguhan master saat ini. 60 posisi berguna dalam Detil; tidak hanya beberapa nama.\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, hanya instalasi lama yang sudah ada. Dukungan berakhir 11 Januari 2023; bukan Dynamics 365/Business Central/cloud atau anjuran membuka server ke internet. Pro nyata: satu sumber, satu Home, tiga daftar dan dua sub-tombol lazy. Tanpa refresh berkala.\n\nPOSISI SUMBER: VendTransOpen saat pembacaan, bukan seluruh faktur, saldo historis/as-of atau aging rekonstruksi. AmountCur tetap bertanda tanpa ABS/pembalikan sign atau rumus faktur dikurangi pembayaran. Tanggal lama, pembayaran/uang muka, kredit, nol, negatif dan NULL tidak dibuang berdasarkan jenis atau nomor yang ditebak. Tanpa cutoff periode otomatis; filter tanggal lokal hanya baris yang sudah dibaca. Sign, tanggal kosong/sentinel, penyelesaian dan kelengkapan harus dicocokkan dengan AX terpasang.\n\nJUMLAH/MATA UANG: CurrencyCode hanya dari satu VendTrans cocok, bukan default VendTable. Referensi hilang/ambigu atau currency kosong terlihat, tanpa menebak mata uang atau menghilangkan posisi. AmountCur dan SettleAmountCur adalah nilai asli terpisah, bukan formula remaining atau bukti transfer bank. PossibleCashDisc adalah jumlah diskon sumber saat penagihan; bukan sekadar label diskon potensial pelanggan, atau sertifikat diskon yang diterapkan pada pembayaran. Mata uang/konteks diskon harus diverifikasi pada instalasi. AmountMST/reporting/kurs dihilangkan tanpa bukti mata uang sendiri. Tidak ada SUM campuran currency, konversi atau netting. Tampilan teks desimal mempertahankan presisi kecil; bukan widget agregasi atau filter/sort angka implisit. Tipe sumber tidak diubah.\n\nTAUTAN: EDT Int64 VendTransRefRecId dan relasi bernama RefRecId menunjuk VendTrans; referensi publik tidak memuat daftar FK SQL lengkap atau badan X++ vendTrans(). Administrator wajib menguji populasi, pemetaan, keunikan, kunci/indeks, modul dan hak. Kueri mencocokkan partisi, DATAAREAID tersimpan, akun pemasok dan RefRecId tepat; tidak ada fallback faktur/Voucher/nama atau memakai pemasok pesanan sebagai pengganti akun posisi. Beberapa posisi dengan RefRecId sama tetap berbeda. Missing/ambiguous master atau transaksi tidak menghapus/menggandakan posisi; referensi parent berubah gagal aman.\n\nTANGGAL/KONTEKS: tanggal/jatuh tempo posisi bukan tanggal transaksi/dokumen. CashDiscDate ditampilkan sebagai tanggal sumber untuk pembuatan transaksi. LastSettleDate memiliki keterangan publik hanya tanggal transaksi; tidak dinyatakan sebagai tanggal voucher pengurang terakhir milik pelanggan. Closed adalah tanggal penyelesaian total sumber, bukan enum Ya/Tidak atau kesimpulan lunas. LastInterestDate pelanggan tidak diproyeksikan pada pemasok. Kode/payment reference bukan mutasi bank.\n\nMASTER SAAT INI: nama, syarat/jadwal/hari pembayaran, kelompok pengadaan, pengiriman dan peringkat tersimpan bukan snapshot faktur historis atau skor dihitung. YourAccountNum adalah akun kita pada pemasok, bukan OurAccountNum pelanggan. OneTimeVendor dan VendBlocked memakai rantai sendiri; kode NULL/asing tetap terlihat. BlockedReleaseDate tetap teks UTC sumber; tanggal tersebut tidak otomatis menyatakan pemasok aktif. Currency master bukan currency posisi. Tidak ada bank, alamat/kontak privat, identitas pemerintah, audit atau credit limit dengan mata uang ditebak. Nama bisnis dapat berupa data pribadi. Jenis transaksi memakai 47 kode resmi; regional/asing/NULL tidak disembunyikan.\n\nAKSES/KINERJA: partisi/perusahaan wajib dan akun opsional sebelum maksimum 1.000 baris per baca. Tidak menjamin seluruh sumber, kueri murah atau snapshot atomik lintas layar. Int64 sebagai teks penuh dan binary matching mempertahankan kapital/spasi akhir. Scope kosong/partisi ambigu tidak dibuka; bukan bukti tidak ada utang. Filter bukan ACL; SQL langsung tidak mewarisi AOS/XDS. Gunakan akun SELECT berizin minimum; periksa perusahaan virtual, schema pemilik, kolom/FK/indeks dan uji terbatas saat impor. Tidak ada server/kredensial/data perusahaan nyata. AOT/SQLite/DEMO bukan DDL SQL terpasang atau uji ERP nyata.\n\nPosisi: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg951979(v=ax.60)\nTransaksi: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg930306(v=ax.60)\nReferensi Int64: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg918908(v=ax.60)",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "1DA9F009-B351-5150-8FFE-49FE5A42D527",
"rootButtonCount": 1,
"summary": "Posisi pemasok saat ini, jatuh tempo dan mata uang terkait; transaksi, syarat dan jadwal melalui dua sub-tombol.",
"tags": [
"Dynamics AX 2012 R3",
"SQL Server",
"Akuntansi",
"Pemasok",
"Jatuh tempo",
"Pro"
],
"title": "Posisi terbuka pemasok, transaksi dan master — Pro"
}
}