Posisi terbuka pelanggan, transaksi dan master — Pro
Posisi pelanggan saat ini, jatuh tempo dan mata uang terkait; transaksi dan master melalui dua sub-tombol.
TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA.
Untuk penagihan, akuntansi dan manajer: pilih partisi/perusahaan dan, bila perlu, akun pelanggan. Lihat posisi terbuka SAAT INI, tanggal jatuh tempo, jumlah bertanda dan mata uang transaksi terkait; tanggal lama, negatif, nol dan NULL tidak dihapus dengan filter periode otomatis. Transaksi membuka dokumen, jumlah asli, bagian diselesaikan dan referensi pembayaran; Pelanggan membuka master saat ini. 53 posisi berguna dalam Detil.
Mengapa Cifru? Sesuaikan konfigurasi dengan cara kerja Anda. Pilih kolom, filter, dan rincian yang diperlukan, lalu tampilkan informasi di ponsel yang mungkin belum tersedia di aplikasi seluler bawaan perangkat lunak bisnis Anda. Pilihannya bergantung pada data yang dapat diakses dari sumber yang Anda berwenang gunakan dan paket Cifru Anda.
EDISI: AX 2012 R3 on-premises SQL Server, hanya instalasi lama yang sudah ada. Dukungan berakhir 11 Januari 2023; bukan Dynamics 365/Business Central/SQL cloud atau anjuran membuka server ke internet. Pro nyata: satu sumber, satu Home, tiga daftar, dua sub-tombol lazy. Tidak ada refresh berkala.
POSISI SUMBER: CustTransOpen saat pembacaan, bukan seluruh faktur, saldo historis/as-of, rekonstruksi aging atau semua transaksi pelanggan. AmountCur asli tetap bertanda, tanpa ABS/pembalikan sign dan tanpa dihitung dari faktur dikurangi pembayaran. Baris pembayaran, kredit, uang muka atau jumlah nol/negatif/NULL tidak dibuang menurut jenis/nomor/semantik yang ditebak. Sign, tanggal kosong/sentinel, penyelesaian dan kelengkapan wajib dicocokkan dengan AX terpasang. Tidak ada status lunas/terlambat yang disimpulkan. Tidak ada cutoff tanggal saat membuka; filter tanggal lokal hanya baris yang sudah dibaca, bukan saldo historis atau pembacaan seluruh sumber.
MATA UANG/JUMLAH: CurrencyCode hanya dari satu transaksi cocok, bukan mata uang default master. Referensi hilang/ambigu atau mata uang kosong terlihat; jumlah posisi tetap ada tanpa mata uang ditebak. AmountCur transaksi dan SettleAmountCur adalah dua nilai sumber sendiri, bukan formula remaining atau bukti sebuah pembayaran terjadi. PossibleCashDisc adalah diskon potensial, bukan diskon dipakai. AmountMST/reporting/penyesuaian kurs dihilangkan tanpa bukti mata uang sendiri. Tidak ada SUM campuran mata uang, konversi, paid-today atau netting. Jumlah ditampilkan sebagai teks desimal lokal untuk menghindari pembulatan visual dua desimal; bukan widget agregasi atau filter/sort angka implisit. Tidak mengubah tipe atau angka dalam sumber.
TAUTAN: EDT Int64 CustTransRefRecId dan relasi bernama RefRecId menunjuk CustTrans; referensi publik tidak memuat daftar FK SQL lengkap atau badan lookup X++. Administrator WAJIB menguji populasi, pemetaan, keunikan, kunci/indeks, modul dan hak instalasi. Kueri memakai partisi, DATAAREAID tersimpan, RefRecId dan akun tepat. Tidak ada fallback nomor faktur/Voucher/nama. Beberapa open rows dengan RefRecId yang sama tetap berbeda, bukan didedup atau dijumlah. Missing/ambiguous transaksi/master tidak menghapus atau menggandakan posisi; nilai ambigu tidak dipilih acak.
TANGGAL/KONTEKS: jatuh tempo dan tanggal CustTransOpen bukan tanggal CustTrans/dokumen. Closed adalah tanggal penyelesaian total sumber, bukan enum Ya/Tidak atau sertifikat lunas. Referensi pembayaran/kode metode bukan transaksi bank. Nama/syarat/currency/penangguhan master adalah konteks SAAT INI, bukan salinan historis atau mata uang posisi. Tidak ada bank, alamat/kontak privat, identitas pemerintah, audit-user atau credit limit bermata uang ditebak. Nama bisnis dapat merupakan data pribadi; hanya akses berwenang. Jenis sumber dipetakan dari 47 kode enum resmi; kode regional asli, asing dan NULL tidak disembunyikan.
AKSES/KINERJA: partisi/perusahaan wajib, akun opsional, sebelum batas 1.000 baris. Tidak menjamin kelengkapan, kueri murah atau snapshot atomik lintas layar; parent dapat berubah. Identitas Int64 sebagai teks penuh dan binary matching mempertahankan kapital/spasi akhir. Baris tanpa identitas scope valid atau partisi ambigu tidak dapat dibuka; bukan bukti tidak ada piutang. Filter bukan ACL; SQL langsung tidak mewarisi AOS/XDS. Gunakan akun SELECT berizin minimum, validasi perusahaan virtual, schema pemilik, kolom, FK, kunci, indeks, waktu dan uji baca terbatas saat impor. Paket/capture tidak memuat 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/gg916367(v=ax.60)
Transaksi: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg915776(v=ax.60)
Referensi Int64: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg863365(v=ax.60)
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Posisi terbuka pelanggan
- Details: Transaksi
- Details: Pelanggan
- Sub-button: Transaksi terkait
- Sub-button: Pelanggan 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 CustomerName, 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 CustTrans 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 CustTrans 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 CustTrans 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 CustTrans 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 CustTrans 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 CustTable 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 CustTable 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 CustomerState, 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, o.LastInterestDate AS LastInterestDate FROM CustTransOpen 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 CustTrans 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 CustTrans 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 CustTable m ON m.Partition=o.Partition AND CAST(m.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(m.AccountNum AS varbinary(max))=CAST(o.AccountNum AS varbinary(max)) AND m.RecId>0 AND (SELECT COUNT_BIG(*) FROM CustTable 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'CustTransOpen',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTransOpen',N'U') AND OBJECT_ID(N'CustTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTrans',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':'),CONCAT(LEN(CONCAT(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'Kode asli: Vend' 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 CustTransOpen 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 CustTrans 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 CustTrans 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'CustTransOpen',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTransOpen',N'U') AND OBJECT_ID(N'CustTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTrans',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':'),CONCAT(LEN(CONCAT(m.Partition,N'#')),N':',m.Partition,N':',LEN(CONCAT(m.dataAreaId,N'#')),N':',m.dataAreaId,N':',LEN(CONCAT(m.RecId,N'#')),N':',m.RecId,N':')) AS CustomerKey, CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS ParentOpenKey, COALESCE(NULLIF(p.Name,N''),m.AccountNum) AS CustomerName, m.AccountNum AS AccountNum, p.KnownAs AS KnownAs, p.NameAlias AS NameAlias, p.PartyNumber AS PartyNumber, m.CustGroup AS CustGroup, m.Currency AS Currency, m.InvoiceAccount AS InvoiceAccount, m.PaymTermId AS PaymTermId, m.PaymMode AS PaymMode, m.OurAccountNum AS OurAccountNum, m.DlvMode AS DlvMode, m.DlvTerm AS DlvTerm, CASE WHEN m.Blocked IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE m.Blocked WHEN 0 THEN N'Tidak ditangguhkan' WHEN 1 THEN N'Faktur' WHEN 2 THEN N'Semua' WHEN 3 THEN N'Pembayaran' WHEN 4 THEN N'Permintaan' WHEN 5 THEN N'Never (kode sumber)' ELSE CONCAT(N'Kode sumber ',m.Blocked) END END AS BlockStatus, m.CreditRating AS CreditRating, 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 CustTransOpen 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 CustTable m ON m.Partition=o.Partition AND CAST(m.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(m.AccountNum AS varbinary(max))=CAST(o.AccountNum AS varbinary(max)) AND m.RecId>0 AND (SELECT COUNT_BIG(*) FROM CustTable 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'CustTransOpen',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTransOpen',N'U') AND OBJECT_ID(N'CustTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTrans',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Dynamics AX 2012 R3 — SQL Server lokal berizin",
"id": "CA36A917-6864-57EA-B478-E1C2CA2E1239",
"kind": "sqlServer",
"requiredObjects": [
"CustTransOpen",
"CustTrans",
"Partitions",
"CustTable",
"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": "CF898E5E-5E77-5EFF-854E-9F2ABB89E4C1",
"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 pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CustomerName",
"label": "Nama pelanggan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerName",
"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": "CustomerState",
"label": "Ketersediaan master pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerState",
"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 tunai posisi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CashDiscDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PossibleCashDisc",
"label": "Diskon tunai potensial sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PossibleCashDisc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LastInterestDate",
"label": "Tanggal perhitungan bunga terakhir",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LastInterestDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Posisi terbuka pelanggan",
"primaryKey": "OpenKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"AccountNum",
"CustomerName",
"PartitionKey",
"dataAreaId",
"OpenTransDate",
"DueDate",
"OpenAmountCur",
"CurrencyCode",
"Invoice",
"Voucher",
"OriginalTransDate",
"TransactionState",
"CurrencyState",
"CustomerState",
"PartyState",
"CashDiscDate",
"PossibleCashDisc",
"LastInterestDate"
],
"sourceID": "CA36A917-6864-57EA-B478-E1C2CA2E1239",
"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 CustomerName, 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 CustTrans 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 CustTrans 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 CustTrans 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 CustTrans 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 CustTrans 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 CustTable 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 CustTable 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 CustomerState, 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, o.LastInterestDate AS LastInterestDate FROM CustTransOpen 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 CustTrans 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 CustTrans 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 CustTable m ON m.Partition=o.Partition AND CAST(m.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(m.AccountNum AS varbinary(max))=CAST(o.AccountNum AS varbinary(max)) AND m.RecId>0 AND (SELECT COUNT_BIG(*) FROM CustTable 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'CustTransOpen',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTransOpen',N'U') AND OBJECT_ID(N'CustTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTrans',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "8D5638F7-E0EF-55B1-8436-6FFBF61C7634",
"key": "TransKey",
"type": "text"
}
],
"id": "74796CB4-1D5E-5BAD-A2A9-896BFDE6304C",
"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 pelanggan 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 voucher pengurang terakhir",
"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",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymMode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymSpec",
"label": "Kode spesifikasi 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",
"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 terkait",
"primaryKey": "TransKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "3C57F6C3-7119-5C41-93BC-2A68E703467B",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "F3AE2AF8-5D40-5A7D-A149-CD22DE094C93",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OpenRecId",
"id": "C14807B2-155D-57A7-8F8A-82AFEDA9A829",
"name": "openRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "AccountNum",
"id": "8CDE003C-8BE5-5815-96AA-E5CC24E08C64",
"name": "account",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "RefToken",
"id": "38B5563B-69A2-5935-B9B7-F816B4337AB7",
"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": "CA36A917-6864-57EA-B478-E1C2CA2E1239",
"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'Kode asli: Vend' 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 CustTransOpen 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 CustTrans 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 CustTrans 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'CustTransOpen',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTransOpen',N'U') AND OBJECT_ID(N'CustTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTrans',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
"key": "CustomerKey",
"type": "text"
}
],
"id": "38204BF9-29D4-5840-8267-9C3D7DDDF6D2",
"mappings": [
{
"commonFieldKey": "",
"key": "CustomerKey",
"label": "Internal CustomerKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerKey",
"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": "CustomerName",
"label": "Nama pelanggan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountNum",
"label": "Akun pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "KnownAs",
"label": "Nama dikenal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "KnownAs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NameAlias",
"label": "Alias pencarian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NameAlias",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartyNumber",
"label": "Nomor pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PartyNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustGroup",
"label": "Grup pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Currency",
"label": "Mata uang faktur bawaan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Currency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceAccount",
"label": "Akun penerima faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymTermId",
"label": "Kode syarat pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymTermId",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PaymMode",
"label": "Kode metode pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymMode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OurAccountNum",
"label": "Akun kita pada pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OurAccountNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DlvMode",
"label": "Kode cara pengiriman bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DlvMode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DlvTerm",
"label": "Kode syarat pengiriman bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DlvTerm",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BlockStatus",
"label": "Status penangguhan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BlockStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CreditRating",
"label": "Peringkat kredit tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CreditRating",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartyState",
"label": "Ketersediaan nama pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PartyState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Pelanggan posisi saat ini",
"primaryKey": "CustomerKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "3C57F6C3-7119-5C41-93BC-2A68E703467B",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "F3AE2AF8-5D40-5A7D-A149-CD22DE094C93",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OpenRecId",
"id": "C14807B2-155D-57A7-8F8A-82AFEDA9A829",
"name": "openRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "AccountNum",
"id": "8CDE003C-8BE5-5815-96AA-E5CC24E08C64",
"name": "account",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "RefToken",
"id": "38B5563B-69A2-5935-B9B7-F816B4337AB7",
"name": "refToken",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"CustomerName",
"AccountNum",
"KnownAs",
"NameAlias",
"PartyNumber",
"CustGroup",
"Currency",
"InvoiceAccount",
"PaymTermId",
"PaymMode",
"OurAccountNum",
"DlvMode",
"DlvTerm",
"BlockStatus",
"CreditRating",
"PartyState"
],
"sourceID": "CA36A917-6864-57EA-B478-E1C2CA2E1239",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':'),CONCAT(LEN(CONCAT(m.Partition,N'#')),N':',m.Partition,N':',LEN(CONCAT(m.dataAreaId,N'#')),N':',m.dataAreaId,N':',LEN(CONCAT(m.RecId,N'#')),N':',m.RecId,N':')) AS CustomerKey, CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS ParentOpenKey, COALESCE(NULLIF(p.Name,N''),m.AccountNum) AS CustomerName, m.AccountNum AS AccountNum, p.KnownAs AS KnownAs, p.NameAlias AS NameAlias, p.PartyNumber AS PartyNumber, m.CustGroup AS CustGroup, m.Currency AS Currency, m.InvoiceAccount AS InvoiceAccount, m.PaymTermId AS PaymTermId, m.PaymMode AS PaymMode, m.OurAccountNum AS OurAccountNum, m.DlvMode AS DlvMode, m.DlvTerm AS DlvTerm, CASE WHEN m.Blocked IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE m.Blocked WHEN 0 THEN N'Tidak ditangguhkan' WHEN 1 THEN N'Faktur' WHEN 2 THEN N'Semua' WHEN 3 THEN N'Pembayaran' WHEN 4 THEN N'Permintaan' WHEN 5 THEN N'Never (kode sumber)' ELSE CONCAT(N'Kode sumber ',m.Blocked) END END AS BlockStatus, m.CreditRating AS CreditRating, 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 CustTransOpen 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 CustTable m ON m.Partition=o.Partition AND CAST(m.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(m.AccountNum AS varbinary(max))=CAST(o.AccountNum AS varbinary(max)) AND m.RecId>0 AND (SELECT COUNT_BIG(*) FROM CustTable 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'CustTransOpen',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTransOpen',N'U') AND OBJECT_ID(N'CustTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTrans',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "8B70AEF5-8F89-5B16-A6C9-AA8C166EDC88",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "012A7B56-2104-5144-81FC-FBF705CA7B6E",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "74796CB4-1D5E-5BAD-A2A9-896BFDE6304C",
"title": "Transaksi",
"urlKey": ""
},
{
"id": "3EEED90E-F633-5A46-91E3-116D5B2E8E66",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "FC89DC0D-FC1E-5680-9BCB-4C3C68BC0EFE",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "38204BF9-29D4-5840-8267-9C3D7DDDF6D2",
"title": "Pelanggan",
"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 pelanggan",
"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": "CF898E5E-5E77-5EFF-854E-9F2ABB89E4C1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Pelanggan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "AccountNum",
"label": "Akun pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pelanggan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "CustomerName",
"label": "Nama pelanggan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pelanggan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "PartitionKey",
"label": "Partisi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pelanggan 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 dan bunga sumber",
"detailRole": "information",
"isVisible": true,
"key": "CashDiscDate",
"label": "Tanggal diskon tunai posisi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon dan bunga sumber",
"detailRole": "information",
"isVisible": true,
"key": "PossibleCashDisc",
"label": "Diskon tunai potensial sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon dan bunga sumber",
"detailRole": "information",
"isVisible": true,
"key": "LastInterestDate",
"label": "Tanggal perhitungan bunga terakhir",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Ketersediaan master",
"detailRole": "information",
"isVisible": true,
"key": "CustomerState",
"label": "Ketersediaan master pelanggan",
"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": "EC763C4E-A3EB-5262-B30D-DF46674495DC",
"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": "93D050E2-447E-5ABA-BF7E-EC9A9C2C66BB",
"includeAllOption": true,
"key": "AccountNum",
"title": "Akun pelanggan",
"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": "CustomerName",
"systemImage": "banknote",
"title": "Posisi terbuka pelanggan",
"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": "74796CB4-1D5E-5BAD-A2A9-896BFDE6304C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identitas transaksi",
"detailRole": "information",
"isVisible": true,
"key": "AccountNum",
"label": "Akun pelanggan 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 voucher pengurang terakhir",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kode pembayaran sumber",
"detailRole": "information",
"isVisible": true,
"key": "PaymMode",
"label": "Kode metode pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kode pembayaran sumber",
"detailRole": "information",
"isVisible": true,
"key": "PaymSpec",
"label": "Kode spesifikasi 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",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "6F1F7112-9143-54DC-87F9-CBBA2E7F3337",
"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 terkait",
"titleKey": "TransTitle"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CustGroup",
"label": "Grup pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang faktur bawaan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PaymTermId",
"label": "Kode syarat pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BlockStatus",
"label": "Status penangguhan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "38204BF9-29D4-5840-8267-9C3D7DDDF6D2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "CustomerName",
"label": "Nama pelanggan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "AccountNum",
"label": "Akun pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "KnownAs",
"label": "Nama dikenal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "NameAlias",
"label": "Alias pencarian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PartyNumber",
"label": "Nomor pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "CustGroup",
"label": "Grup pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang faktur bawaan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun penerima faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PaymTermId",
"label": "Kode syarat pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PaymMode",
"label": "Kode metode pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "OurAccountNum",
"label": "Akun kita pada pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan status saat ini",
"detailRole": "information",
"isVisible": true,
"key": "DlvMode",
"label": "Kode cara pengiriman bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan status saat ini",
"detailRole": "information",
"isVisible": true,
"key": "DlvTerm",
"label": "Kode syarat pengiriman bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan status saat ini",
"detailRole": "information",
"isVisible": true,
"key": "BlockStatus",
"label": "Status penangguhan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan status saat ini",
"detailRole": "information",
"isVisible": true,
"key": "CreditRating",
"label": "Peringkat kredit tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Ketersediaan nama",
"detailRole": "information",
"isVisible": true,
"key": "PartyState",
"label": "Ketersediaan nama pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "210E51E6-9CDC-51AB-A610-289A02639972",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
"key": "CustomerKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountNum",
"systemImage": "person.2",
"title": "Pelanggan posisi saat ini",
"titleKey": "CustomerName"
}
],
"relations": [
{
"childDatasetID": "74796CB4-1D5E-5BAD-A2A9-896BFDE6304C",
"childKey": "ParentOpenKey",
"id": "012A7B56-2104-5144-81FC-FBF705CA7B6E",
"name": "Transaksi",
"parentDatasetID": "CF898E5E-5E77-5EFF-854E-9F2ABB89E4C1",
"parentKey": "OpenKey"
},
{
"childDatasetID": "38204BF9-29D4-5840-8267-9C3D7DDDF6D2",
"childKey": "ParentOpenKey",
"id": "FC89DC0D-FC1E-5680-9BCB-4C3C68BC0EFE",
"name": "Pelanggan",
"parentDatasetID": "CF898E5E-5E77-5EFF-854E-9F2ABB89E4C1",
"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 penagihan, akuntansi dan manajer: pilih partisi/perusahaan dan, bila perlu, akun pelanggan. Lihat posisi terbuka SAAT INI, tanggal jatuh tempo, jumlah bertanda dan mata uang transaksi terkait; tanggal lama, negatif, nol dan NULL tidak dihapus dengan filter periode otomatis. Transaksi membuka dokumen, jumlah asli, bagian diselesaikan dan referensi pembayaran; Pelanggan membuka master saat ini. 53 posisi berguna dalam Detil.\n\nMengapa Cifru? Sesuaikan konfigurasi dengan cara kerja Anda. Pilih kolom, filter, dan rincian yang diperlukan, lalu tampilkan informasi di ponsel yang mungkin belum tersedia di aplikasi seluler bawaan perangkat lunak bisnis Anda. Pilihannya bergantung pada data yang dapat diakses dari sumber yang Anda berwenang gunakan dan paket Cifru Anda.\n\nEDISI: AX 2012 R3 on-premises SQL Server, hanya instalasi lama yang sudah ada. Dukungan berakhir 11 Januari 2023; bukan Dynamics 365/Business Central/SQL cloud atau anjuran membuka server ke internet. Pro nyata: satu sumber, satu Home, tiga daftar, dua sub-tombol lazy. Tidak ada refresh berkala.\n\nPOSISI SUMBER: CustTransOpen saat pembacaan, bukan seluruh faktur, saldo historis/as-of, rekonstruksi aging atau semua transaksi pelanggan. AmountCur asli tetap bertanda, tanpa ABS/pembalikan sign dan tanpa dihitung dari faktur dikurangi pembayaran. Baris pembayaran, kredit, uang muka atau jumlah nol/negatif/NULL tidak dibuang menurut jenis/nomor/semantik yang ditebak. Sign, tanggal kosong/sentinel, penyelesaian dan kelengkapan wajib dicocokkan dengan AX terpasang. Tidak ada status lunas/terlambat yang disimpulkan. Tidak ada cutoff tanggal saat membuka; filter tanggal lokal hanya baris yang sudah dibaca, bukan saldo historis atau pembacaan seluruh sumber.\n\nMATA UANG/JUMLAH: CurrencyCode hanya dari satu transaksi cocok, bukan mata uang default master. Referensi hilang/ambigu atau mata uang kosong terlihat; jumlah posisi tetap ada tanpa mata uang ditebak. AmountCur transaksi dan SettleAmountCur adalah dua nilai sumber sendiri, bukan formula remaining atau bukti sebuah pembayaran terjadi. PossibleCashDisc adalah diskon potensial, bukan diskon dipakai. AmountMST/reporting/penyesuaian kurs dihilangkan tanpa bukti mata uang sendiri. Tidak ada SUM campuran mata uang, konversi, paid-today atau netting. Jumlah ditampilkan sebagai teks desimal lokal untuk menghindari pembulatan visual dua desimal; bukan widget agregasi atau filter/sort angka implisit. Tidak mengubah tipe atau angka dalam sumber.\n\nTAUTAN: EDT Int64 CustTransRefRecId dan relasi bernama RefRecId menunjuk CustTrans; referensi publik tidak memuat daftar FK SQL lengkap atau badan lookup X++. Administrator WAJIB menguji populasi, pemetaan, keunikan, kunci/indeks, modul dan hak instalasi. Kueri memakai partisi, DATAAREAID tersimpan, RefRecId dan akun tepat. Tidak ada fallback nomor faktur/Voucher/nama. Beberapa open rows dengan RefRecId yang sama tetap berbeda, bukan didedup atau dijumlah. Missing/ambiguous transaksi/master tidak menghapus atau menggandakan posisi; nilai ambigu tidak dipilih acak.\n\nTANGGAL/KONTEKS: jatuh tempo dan tanggal CustTransOpen bukan tanggal CustTrans/dokumen. Closed adalah tanggal penyelesaian total sumber, bukan enum Ya/Tidak atau sertifikat lunas. Referensi pembayaran/kode metode bukan transaksi bank. Nama/syarat/currency/penangguhan master adalah konteks SAAT INI, bukan salinan historis atau mata uang posisi. Tidak ada bank, alamat/kontak privat, identitas pemerintah, audit-user atau credit limit bermata uang ditebak. Nama bisnis dapat merupakan data pribadi; hanya akses berwenang. Jenis sumber dipetakan dari 47 kode enum resmi; kode regional asli, asing dan NULL tidak disembunyikan.\n\nAKSES/KINERJA: partisi/perusahaan wajib, akun opsional, sebelum batas 1.000 baris. Tidak menjamin kelengkapan, kueri murah atau snapshot atomik lintas layar; parent dapat berubah. Identitas Int64 sebagai teks penuh dan binary matching mempertahankan kapital/spasi akhir. Baris tanpa identitas scope valid atau partisi ambigu tidak dapat dibuka; bukan bukti tidak ada piutang. Filter bukan ACL; SQL langsung tidak mewarisi AOS/XDS. Gunakan akun SELECT berizin minimum, validasi perusahaan virtual, schema pemilik, kolom, FK, kunci, indeks, waktu dan uji baca terbatas saat impor. Paket/capture tidak memuat 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/gg916367(v=ax.60)\nTransaksi: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg915776(v=ax.60)\nReferensi Int64: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg863365(v=ax.60)",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "FFAD2D2B-5044-5E30-8443-72BB93A16C1E",
"rootButtonCount": 1,
"summary": "Posisi pelanggan saat ini, jatuh tempo dan mata uang terkait; transaksi dan master melalui dua sub-tombol.",
"tags": [
"Dynamics AX 2012 R3",
"SQL Server",
"Akuntansi",
"Pelanggan",
"Jatuh tempo",
"Pro"
],
"title": "Posisi terbuka pelanggan, transaksi dan master — Pro"
}
}