Dossier pelanggan, alamat dan kontak — Pro
Pelanggan per partisi/perusahaan, penagihan bawaan, pengiriman, alamat historis dan kontak nonprivat.
TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA.
Untuk tim penjualan, administrasi dan manajer berizin: pilih partisi serta perusahaan tersimpan, cari pelanggan, lihat penagihan bawaan dan pengiriman, lalu buka Alamat atau Kontak sesuai kebutuhan. 19 nilai dossier, 14 nilai alamat dan delapan nilai kontak ditata dalam Detil; ID teknis disembunyikan.
Mengapa Cifru? Sesuaikan konfigurasi dengan cara kerja Anda. Pilih kolom, filter, dan rincian yang diperlukan, lalu tampilkan informasi di ponsel yang mungkin belum tersedia di aplikasi seluler bawaan perangkat lunak bisnis Anda. Pilihannya bergantung pada data yang dapat diakses dari sumber yang Anda berwenang gunakan dan paket Cifru Anda.
EDISI KHUSUS: AX 2012 R3 on-premises pada SQL Server. Dukungan diperpanjang berakhir 11 Januari 2023 (tanggal Microsoft Lifecycle, zona Pacific). Hanya untuk instalasi lama yang sudah ada dan akses SQL yang secara eksplisit disetujui administrator; bukan anjuran memasang ERP lama atau membuka server ke internet. Bukan Dynamics 365 Finance/SCM, Business Central atau AX 2009. SQL langsung untuk layanan cloud tidak diasumsikan.
Pro: satu sumber, tiga daftar, satu tombol Home dan dua sub-tombol lazy. Pilihan partisi dan DATAAREAID tersimpan wajib saat membuka daftar; filter diterapkan sebelum batas 1.000 baris. Setiap relasi mempertahankan partisi, perusahaan, akun pelanggan dan pihak terkait. ID Int64 diteruskan sebagai teks tanpa pembulatan; kunci gabungan tetap internal. Tidak ada pembaruan berulang. Batasi lingkup bila batas baca tercapai; ini bukan ekspor seluruh database.
PENTING: perusahaan virtual dapat menyimpan data dalam DATAAREAID bersama seperti VIR. Pilihan ini adalah nilai tersimpan, bukan otomatis nama badan hukum aktif di AX. Administrator harus memverifikasi pemetaan perusahaan virtual dan izin sumber. Filter bukan ACL. Pembacaan SQL tidak mewarisi AOS, XDS, aturan keamanan pengguna AX atau seluruh kebijakan privasi lokasi. Gunakan akun khusus SELECT dengan lingkup yang disetujui dan kontrol keamanan di server.
Hanya lokasi dan komunikasi dengan IsPrivate=0 disertakan. Alamat/komunikasi dengan PrivateForParty bukan nol, nilai privasi kosong/tidak dikenal, atau relasi pihak tidak cocok dikecualikan. Telepon/e-mail utama juga memerlukan relasi lokasi nonprivat yang cocok. Nama dan kontak bisnis tetap bisa merupakan data pribadi: hanya akses bila berwenang. Tidak disertakan rekening bank, kartu pembayaran, identitas pemerintah pribadi, data kelahiran atau audit. KreditMax tidak diambil karena mata uangnya bukan otomatis Currency faktur.
Alamat mencakup riwayat dan masa berlaku ValidFrom/ValidTo UTC; tidak semua baris masih berlaku sekarang dan bukan salinan alamat historis faktur. Kode negara/provinsi adalah kode sumber, bukan ISO yang diasumsikan. Syarat/metode pembayaran dan pengiriman adalah kode bawaan, bukan label kamus yang ditebak. Status penangguhan mengikuti enum Microsoft; Never tetap nama kode sumber, bukan keputusan kredit. Nilai enum tak dikenal/kosong tidak diubah menjadi Ya/Tidak.
Dokumentasi AOT Microsoft AX 2012 R3 dan white paper address book mendasari tabel, kolom dan relasi. Ini bukan sertifikat DDL atau indeks SQL instalasi Anda. Referensi F&O yang menjelaskan perusahaan virtual dan contoh SQL pelanggan hanya bukti pembanding, bukan pengganti skema AX. Verifikasi versi R3, konfigurasi modul, pemilik tabel, kolom, kunci dan relasi aktual serta indeks/izin/lingkup sebelum uji SELECT terbatas saat impor. Paket dan tangkapan DEMO sintetis tidak mengandung kredensial, server atau baris perusahaan nyata; pengujian SQLite tidak menjamin SQL Server atau ERP nyata.
Referensi pelanggan: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg915339(v=ax.60)
Referensi alamat: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg895161(v=ax.60)
Referensi kontak: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg876321(v=ax.60)
Siklus dukungan: https://learn.microsoft.com/en-us/lifecycle/products/dynamics-ax-2012-r3
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Dossier pelanggan
- Details: Alamat
- Details: Kontak
- Sub-button: Alamat pelanggan
- Sub-button: Kontak pelanggan
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(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, CAST(m.Partition AS nvarchar(30)) AS PartitionId, CAST(m.RecId AS nvarchar(30)) AS CustomerRecId, CAST(m.Party AS nvarchar(30)) AS PartyRecId, COALESCE(NULLIF(p.Name,N''),m.AccountNum) AS CustomerName, m.AccountNum AS AccountNum, pt.PartitionKey AS PartitionKey, m.dataAreaId AS dataAreaId, 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 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 CAST(m.Blocked AS nvarchar(30)) END AS BlockStatus, m.CreditRating AS CreditRating, phone.Locator AS PrimaryPhone, email.Locator AS PrimaryEmail FROM CustTable m INNER JOIN Partitions pt ON pt.RecId=m.Partition LEFT JOIN DirPartyTable p ON p.RecId=m.Party AND p.Partition=m.Partition LEFT JOIN LogisticsElectronicAddress phone ON phone.RecId=p.PrimaryContactPhone AND phone.Partition=m.Partition AND phone.IsPrivate=0 AND phone.PrivateForParty=0 AND phone.Type=1 AND EXISTS (SELECT 1 FROM DirPartyLocation pl WHERE pl.Partition=m.Partition AND pl.Party=m.Party AND pl.Location=phone.Location AND pl.IsPrivate=0) LEFT JOIN LogisticsElectronicAddress email ON email.RecId=p.PrimaryContactEmail AND email.Partition=m.Partition AND email.IsPrivate=0 AND email.PrivateForParty=0 AND email.Type=2 AND EXISTS (SELECT 1 FROM DirPartyLocation pl WHERE pl.Partition=m.Partition AND pl.Party=m.Party AND pl.Location=email.Location AND pl.IsPrivate=0) WHERE m.Partition IS NOT NULL AND m.RecId IS NOT NULL AND m.dataAreaId IS NOT NULL AND m.AccountNum IS NOT NULL AND m.dataAreaId<>N'' AND pt.PartitionKey IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') 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') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'DirPartyLocation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyLocation',N'U') AND OBJECT_ID(N'LogisticsPostalAddress',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LogisticsPostalAddress',N'U') AND OBJECT_ID(N'LogisticsElectronicAddress',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LogisticsElectronicAddress',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(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':'),CONCAT(LEN(CONCAT(pl.RecId,N'#')),N':',pl.RecId,N':'),CONCAT(LEN(CONCAT(a.Partition,N'#')),N':',a.Partition,N':',LEN(CONCAT(a.RecId,N'#')),N':',a.RecId,N':')) AS AddressKey, 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 ParentCustomerKey, a.Address AS Address, a.Street AS Street, a.StreetNumber AS StreetNumber, a.City AS City, a.DistrictName AS DistrictName, a.State AS State, a.CountryRegionId AS CountryRegionId, a.ZipCode AS ZipCode, a.BuildingCompliment AS BuildingCompliment, a.PostBox AS PostBox, a.ValidFrom AS ValidFrom, a.ValidTo AS ValidTo, CASE pl.IsPrimary WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CAST(pl.IsPrimary AS nvarchar(30)) END AS AddressPrimary, pl.AttentionToAddressLine AS AttentionToAddressLine FROM CustTable m INNER JOIN DirPartyTable p ON p.RecId=m.Party AND p.Partition=m.Partition INNER JOIN DirPartyLocation pl ON pl.Party=p.RecId AND pl.Partition=m.Partition INNER JOIN LogisticsPostalAddress a ON a.Location=pl.Location AND a.Partition=m.Partition WHERE m.Partition=CAST(:partition AS bigint) AND m.dataAreaId=:company AND m.RecId=CAST(:customer AS bigint) AND m.Party=CAST(:party AS bigint) AND pl.IsPrivate=0 AND a.IsPrivate=0 AND a.PrivateForParty=0 AND pl.RecId IS NOT NULL AND a.RecId IS NOT NULL AND a.ValidFrom IS NOT NULL AND a.ValidTo IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') 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') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'DirPartyLocation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyLocation',N'U') AND OBJECT_ID(N'LogisticsPostalAddress',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LogisticsPostalAddress',N'U') AND OBJECT_ID(N'LogisticsElectronicAddress',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LogisticsElectronicAddress',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(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':'),CONCAT(LEN(CONCAT(a.Partition,N'#')),N':',a.Partition,N':',LEN(CONCAT(a.RecId,N'#')),N':',a.RecId,N':')) AS ContactKey, 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 ParentCustomerKey, a.Locator AS Locator, a.Description AS Description, CASE a.Type WHEN 0 THEN N'Tidak ditentukan' WHEN 1 THEN N'Telepon' WHEN 2 THEN N'E-mail' WHEN 3 THEN N'Situs web' WHEN 4 THEN N'Teleks' WHEN 5 THEN N'Faks' ELSE CAST(a.Type AS nvarchar(30)) END AS ContactType, a.CountryRegionCode AS CountryRegionCode, a.LocatorExtension AS LocatorExtension, CASE a.IsPrimary WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CAST(a.IsPrimary AS nvarchar(30)) END AS ContactPrimary, CASE a.IsMobilePhone WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CAST(a.IsMobilePhone AS nvarchar(30)) END AS MobilePhone, CASE a.IsInstantMessage WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CAST(a.IsInstantMessage AS nvarchar(30)) END AS InstantMessage FROM CustTable m INNER JOIN DirPartyTable p ON p.RecId=m.Party AND p.Partition=m.Partition INNER JOIN LogisticsElectronicAddress a ON a.Partition=m.Partition WHERE m.Partition=CAST(:partition AS bigint) AND m.dataAreaId=:company AND m.RecId=CAST(:customer AS bigint) AND m.Party=CAST(:party AS bigint) AND a.RecId IS NOT NULL AND a.IsPrivate=0 AND a.PrivateForParty=0 AND EXISTS (SELECT 1 FROM DirPartyLocation pl WHERE pl.Partition=m.Partition AND pl.Party=m.Party AND pl.Location=a.Location AND pl.IsPrivate=0) AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') 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') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'DirPartyLocation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyLocation',N'U') AND OBJECT_ID(N'LogisticsPostalAddress',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LogisticsPostalAddress',N'U') AND OBJECT_ID(N'LogisticsElectronicAddress',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LogisticsElectronicAddress',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": "53F9C5DC-2EC5-534D-A2B7-6417AC895856",
"kind": "sqlServer",
"requiredObjects": [
"CustTable",
"DirPartyTable",
"Partitions",
"DirPartyLocation",
"LogisticsPostalAddress",
"LogisticsElectronicAddress"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "81F2AA9E-89D6-59B0-8AF0-BE212938DABE",
"key": "CustomerName",
"type": "text"
},
{
"direction": "ascending",
"id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
"key": "CustomerKey",
"type": "text"
}
],
"id": "D80FF367-5BEE-5C37-8052-143B1DAEE431",
"mappings": [
{
"commonFieldKey": "",
"key": "CustomerKey",
"label": "Internal CustomerKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerKey",
"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": "CustomerRecId",
"label": "Internal CustomerRecId",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerRecId",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartyRecId",
"label": "Internal PartyRecId",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PartyRecId",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerName",
"label": "Nama pelanggan",
"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": "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": "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",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Currency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceAccount",
"label": "Akun penerima faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "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": "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",
"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",
"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": "PrimaryPhone",
"label": "Telepon utama nonprivat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PrimaryPhone",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PrimaryEmail",
"label": "E-mail utama nonprivat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PrimaryEmail",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1000,
"name": "Dossier pelanggan",
"primaryKey": "CustomerKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"CustomerName",
"AccountNum",
"PartitionKey",
"dataAreaId",
"KnownAs",
"NameAlias",
"PartyNumber",
"CustGroup",
"Currency",
"InvoiceAccount",
"PaymTermId",
"PaymMode",
"OurAccountNum",
"DlvMode",
"DlvTerm",
"BlockStatus",
"CreditRating",
"PrimaryPhone",
"PrimaryEmail"
],
"sourceID": "53F9C5DC-2EC5-534D-A2B7-6417AC895856",
"sqlQuery": "SELECT 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, CAST(m.Partition AS nvarchar(30)) AS PartitionId, CAST(m.RecId AS nvarchar(30)) AS CustomerRecId, CAST(m.Party AS nvarchar(30)) AS PartyRecId, COALESCE(NULLIF(p.Name,N''),m.AccountNum) AS CustomerName, m.AccountNum AS AccountNum, pt.PartitionKey AS PartitionKey, m.dataAreaId AS dataAreaId, 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 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 CAST(m.Blocked AS nvarchar(30)) END AS BlockStatus, m.CreditRating AS CreditRating, phone.Locator AS PrimaryPhone, email.Locator AS PrimaryEmail FROM CustTable m INNER JOIN Partitions pt ON pt.RecId=m.Partition LEFT JOIN DirPartyTable p ON p.RecId=m.Party AND p.Partition=m.Partition LEFT JOIN LogisticsElectronicAddress phone ON phone.RecId=p.PrimaryContactPhone AND phone.Partition=m.Partition AND phone.IsPrivate=0 AND phone.PrivateForParty=0 AND phone.Type=1 AND EXISTS (SELECT 1 FROM DirPartyLocation pl WHERE pl.Partition=m.Partition AND pl.Party=m.Party AND pl.Location=phone.Location AND pl.IsPrivate=0) LEFT JOIN LogisticsElectronicAddress email ON email.RecId=p.PrimaryContactEmail AND email.Partition=m.Partition AND email.IsPrivate=0 AND email.PrivateForParty=0 AND email.Type=2 AND EXISTS (SELECT 1 FROM DirPartyLocation pl WHERE pl.Partition=m.Partition AND pl.Party=m.Party AND pl.Location=email.Location AND pl.IsPrivate=0) WHERE m.Partition IS NOT NULL AND m.RecId IS NOT NULL AND m.dataAreaId IS NOT NULL AND m.AccountNum IS NOT NULL AND m.dataAreaId<>N'' AND pt.PartitionKey IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') 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') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'DirPartyLocation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyLocation',N'U') AND OBJECT_ID(N'LogisticsPostalAddress',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LogisticsPostalAddress',N'U') AND OBJECT_ID(N'LogisticsElectronicAddress',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LogisticsElectronicAddress',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "99B8FB1E-64F1-5B3B-9B0F-A836A171AEB0",
"key": "Address",
"type": "text"
},
{
"direction": "ascending",
"id": "4FFDE6B4-2149-5A3F-9385-91284A8741BF",
"key": "AddressKey",
"type": "text"
}
],
"id": "610A3944-5EFB-56B0-83F9-BBE57CAA5EE8",
"mappings": [
{
"commonFieldKey": "",
"key": "AddressKey",
"label": "Internal AddressKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AddressKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentCustomerKey",
"label": "Internal ParentCustomerKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentCustomerKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Address",
"label": "Alamat terformat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Address",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Street",
"label": "Jalan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Street",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StreetNumber",
"label": "Nomor jalan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StreetNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "City",
"label": "Kota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "City",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DistrictName",
"label": "Distrik",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DistrictName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "State",
"label": "Kode provinsi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "State",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CountryRegionId",
"label": "Kode negara sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CountryRegionId",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ZipCode",
"label": "Kode pos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ZipCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BuildingCompliment",
"label": "Nama bangunan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BuildingCompliment",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostBox",
"label": "Kotak pos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostBox",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ValidFrom",
"label": "Berlaku sejak (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ValidFrom",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ValidTo",
"label": "Berlaku sampai (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ValidTo",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AddressPrimary",
"label": "Lokasi utama",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AddressPrimary",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AttentionToAddressLine",
"label": "Ditujukan kepada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AttentionToAddressLine",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Alamat pelanggan",
"primaryKey": "AddressKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "0DB3A257-8B64-528D-AA0C-9090052A8977",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "ABD287FA-6558-5025-8DD3-4EF53DD1582C",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CustomerRecId",
"id": "0B677E59-14EC-5DBF-AFF8-FEF515ADF842",
"name": "customer",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartyRecId",
"id": "809414B8-9EF0-5D79-AFDE-51F22E239DE8",
"name": "party",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Address",
"Street",
"StreetNumber",
"City",
"DistrictName",
"State",
"CountryRegionId",
"ZipCode",
"BuildingCompliment",
"PostBox",
"ValidFrom",
"ValidTo",
"AddressPrimary",
"AttentionToAddressLine"
],
"sourceID": "53F9C5DC-2EC5-534D-A2B7-6417AC895856",
"sqlQuery": "SELECT CONCAT(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':'),CONCAT(LEN(CONCAT(pl.RecId,N'#')),N':',pl.RecId,N':'),CONCAT(LEN(CONCAT(a.Partition,N'#')),N':',a.Partition,N':',LEN(CONCAT(a.RecId,N'#')),N':',a.RecId,N':')) AS AddressKey, 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 ParentCustomerKey, a.Address AS Address, a.Street AS Street, a.StreetNumber AS StreetNumber, a.City AS City, a.DistrictName AS DistrictName, a.State AS State, a.CountryRegionId AS CountryRegionId, a.ZipCode AS ZipCode, a.BuildingCompliment AS BuildingCompliment, a.PostBox AS PostBox, a.ValidFrom AS ValidFrom, a.ValidTo AS ValidTo, CASE pl.IsPrimary WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CAST(pl.IsPrimary AS nvarchar(30)) END AS AddressPrimary, pl.AttentionToAddressLine AS AttentionToAddressLine FROM CustTable m INNER JOIN DirPartyTable p ON p.RecId=m.Party AND p.Partition=m.Partition INNER JOIN DirPartyLocation pl ON pl.Party=p.RecId AND pl.Partition=m.Partition INNER JOIN LogisticsPostalAddress a ON a.Location=pl.Location AND a.Partition=m.Partition WHERE m.Partition=CAST(:partition AS bigint) AND m.dataAreaId=:company AND m.RecId=CAST(:customer AS bigint) AND m.Party=CAST(:party AS bigint) AND pl.IsPrivate=0 AND a.IsPrivate=0 AND a.PrivateForParty=0 AND pl.RecId IS NOT NULL AND a.RecId IS NOT NULL AND a.ValidFrom IS NOT NULL AND a.ValidTo IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') 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') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'DirPartyLocation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyLocation',N'U') AND OBJECT_ID(N'LogisticsPostalAddress',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LogisticsPostalAddress',N'U') AND OBJECT_ID(N'LogisticsElectronicAddress',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LogisticsElectronicAddress',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "7C27B5F9-48E6-5BDD-BF62-1B7912170F23",
"key": "Locator",
"type": "text"
},
{
"direction": "ascending",
"id": "992EF8B7-F10C-54B1-A8C7-5989E8B1BD96",
"key": "ContactKey",
"type": "text"
}
],
"id": "B4021148-ABA7-500F-900C-EB75E2DFABD8",
"mappings": [
{
"commonFieldKey": "",
"key": "ContactKey",
"label": "Internal ContactKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContactKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentCustomerKey",
"label": "Internal ParentCustomerKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentCustomerKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Locator",
"label": "Alamat komunikasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Locator",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Keterangan kontak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ContactType",
"label": "Jenis komunikasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContactType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CountryRegionCode",
"label": "Kode negara telepon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CountryRegionCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LocatorExtension",
"label": "Ekstensi telepon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LocatorExtension",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ContactPrimary",
"label": "Kontak utama",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ContactPrimary",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MobilePhone",
"label": "Telepon seluler",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MobilePhone",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InstantMessage",
"label": "Pesan instan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InstantMessage",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Kontak pelanggan",
"primaryKey": "ContactKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "0DB3A257-8B64-528D-AA0C-9090052A8977",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "ABD287FA-6558-5025-8DD3-4EF53DD1582C",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CustomerRecId",
"id": "0B677E59-14EC-5DBF-AFF8-FEF515ADF842",
"name": "customer",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartyRecId",
"id": "809414B8-9EF0-5D79-AFDE-51F22E239DE8",
"name": "party",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Locator",
"Description",
"ContactType",
"CountryRegionCode",
"LocatorExtension",
"ContactPrimary",
"MobilePhone",
"InstantMessage"
],
"sourceID": "53F9C5DC-2EC5-534D-A2B7-6417AC895856",
"sqlQuery": "SELECT CONCAT(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':'),CONCAT(LEN(CONCAT(a.Partition,N'#')),N':',a.Partition,N':',LEN(CONCAT(a.RecId,N'#')),N':',a.RecId,N':')) AS ContactKey, 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 ParentCustomerKey, a.Locator AS Locator, a.Description AS Description, CASE a.Type WHEN 0 THEN N'Tidak ditentukan' WHEN 1 THEN N'Telepon' WHEN 2 THEN N'E-mail' WHEN 3 THEN N'Situs web' WHEN 4 THEN N'Teleks' WHEN 5 THEN N'Faks' ELSE CAST(a.Type AS nvarchar(30)) END AS ContactType, a.CountryRegionCode AS CountryRegionCode, a.LocatorExtension AS LocatorExtension, CASE a.IsPrimary WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CAST(a.IsPrimary AS nvarchar(30)) END AS ContactPrimary, CASE a.IsMobilePhone WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CAST(a.IsMobilePhone AS nvarchar(30)) END AS MobilePhone, CASE a.IsInstantMessage WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CAST(a.IsInstantMessage AS nvarchar(30)) END AS InstantMessage FROM CustTable m INNER JOIN DirPartyTable p ON p.RecId=m.Party AND p.Partition=m.Partition INNER JOIN LogisticsElectronicAddress a ON a.Partition=m.Partition WHERE m.Partition=CAST(:partition AS bigint) AND m.dataAreaId=:company AND m.RecId=CAST(:customer AS bigint) AND m.Party=CAST(:party AS bigint) AND a.RecId IS NOT NULL AND a.IsPrivate=0 AND a.PrivateForParty=0 AND EXISTS (SELECT 1 FROM DirPartyLocation pl WHERE pl.Partition=m.Partition AND pl.Party=m.Party AND pl.Location=a.Location AND pl.IsPrivate=0) AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') 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') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'DirPartyLocation',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyLocation',N'U') AND OBJECT_ID(N'LogisticsPostalAddress',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LogisticsPostalAddress',N'U') AND OBJECT_ID(N'LogisticsElectronicAddress',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LogisticsElectronicAddress',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "12623003-2720-56ED-A37A-925323891693",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "0C22C688-B166-558B-B4E8-0E4007539772",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "610A3944-5EFB-56B0-83F9-BBE57CAA5EE8",
"title": "Alamat",
"urlKey": ""
},
{
"id": "D4A71580-4BBA-5ADE-BC2E-A4910A600811",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "7A5CE5F0-3BCE-56D6-9A35-FCA847CB600C",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "B4021148-ABA7-500F-900C-EB75E2DFABD8",
"title": "Kontak",
"urlKey": ""
}
],
"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",
"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",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PrimaryPhone",
"label": "Telepon utama nonprivat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PrimaryEmail",
"label": "E-mail utama nonprivat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "D80FF367-5BEE-5C37-8052-143B1DAEE431",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Pelanggan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "CustomerName",
"label": "Nama pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"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": "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": "Pelanggan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "KnownAs",
"label": "Nama dikenal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pelanggan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "NameAlias",
"label": "Alias pencarian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pelanggan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "PartyNumber",
"label": "Nomor pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pelanggan dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "CustGroup",
"label": "Grup pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun penerima faktur",
"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": "OurAccountNum",
"label": "Akun kita pada pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan penangguhan",
"detailRole": "information",
"isVisible": true,
"key": "DlvMode",
"label": "Kode cara pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan penangguhan",
"detailRole": "information",
"isVisible": true,
"key": "DlvTerm",
"label": "Kode syarat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan penangguhan",
"detailRole": "information",
"isVisible": true,
"key": "BlockStatus",
"label": "Status penangguhan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan penangguhan",
"detailRole": "information",
"isVisible": true,
"key": "CreditRating",
"label": "Peringkat kredit tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kontak utama nonprivat",
"detailRole": "information",
"isVisible": true,
"key": "PrimaryPhone",
"label": "Telepon utama nonprivat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kontak utama nonprivat",
"detailRole": "information",
"isVisible": true,
"key": "PrimaryEmail",
"label": "E-mail utama nonprivat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "0D71A556-B5FD-5A0D-A5CC-1C54DE1462CD",
"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"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "81F2AA9E-89D6-59B0-8AF0-BE212938DABE",
"key": "CustomerName",
"type": "text"
},
{
"direction": "ascending",
"id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
"key": "CustomerKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountNum",
"systemImage": "person.2",
"title": "Dossier pelanggan",
"titleKey": "CustomerName"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "City",
"label": "Kota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "State",
"label": "Kode provinsi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ZipCode",
"label": "Kode pos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CountryRegionId",
"label": "Kode negara sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AddressPrimary",
"label": "Lokasi utama",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ValidTo",
"label": "Berlaku sampai (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "610A3944-5EFB-56B0-83F9-BBE57CAA5EE8",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Alamat — termasuk riwayat",
"detailRole": "information",
"isVisible": true,
"key": "Address",
"label": "Alamat terformat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Alamat — termasuk riwayat",
"detailRole": "information",
"isVisible": true,
"key": "Street",
"label": "Jalan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Alamat — termasuk riwayat",
"detailRole": "information",
"isVisible": true,
"key": "StreetNumber",
"label": "Nomor jalan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Alamat — termasuk riwayat",
"detailRole": "information",
"isVisible": true,
"key": "BuildingCompliment",
"label": "Nama bangunan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Alamat — termasuk riwayat",
"detailRole": "information",
"isVisible": true,
"key": "City",
"label": "Kota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Alamat — termasuk riwayat",
"detailRole": "information",
"isVisible": true,
"key": "DistrictName",
"label": "Distrik",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Alamat — termasuk riwayat",
"detailRole": "information",
"isVisible": true,
"key": "State",
"label": "Kode provinsi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Alamat — termasuk riwayat",
"detailRole": "information",
"isVisible": true,
"key": "CountryRegionId",
"label": "Kode negara sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Alamat — termasuk riwayat",
"detailRole": "information",
"isVisible": true,
"key": "ZipCode",
"label": "Kode pos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Alamat — termasuk riwayat",
"detailRole": "information",
"isVisible": true,
"key": "PostBox",
"label": "Kotak pos",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Masa berlaku UTC",
"detailRole": "information",
"isVisible": true,
"key": "ValidFrom",
"label": "Berlaku sejak (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Masa berlaku UTC",
"detailRole": "information",
"isVisible": true,
"key": "ValidTo",
"label": "Berlaku sampai (UTC)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Konteks lokasi",
"detailRole": "information",
"isVisible": true,
"key": "AddressPrimary",
"label": "Lokasi utama",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Konteks lokasi",
"detailRole": "information",
"isVisible": true,
"key": "AttentionToAddressLine",
"label": "Ditujukan kepada",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "A7EC5C4E-74A5-5278-AFFB-6BBC91A6B406",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "99B8FB1E-64F1-5B3B-9B0F-A836A171AEB0",
"key": "Address",
"type": "text"
},
{
"direction": "ascending",
"id": "4FFDE6B4-2149-5A3F-9385-91284A8741BF",
"key": "AddressKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "City",
"systemImage": "map",
"title": "Alamat pelanggan",
"titleKey": "Address"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ContactType",
"label": "Jenis komunikasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Keterangan kontak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ContactPrimary",
"label": "Kontak utama",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LocatorExtension",
"label": "Ekstensi telepon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "B4021148-ABA7-500F-900C-EB75E2DFABD8",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Komunikasi nonprivat",
"detailRole": "information",
"isVisible": true,
"key": "Locator",
"label": "Alamat komunikasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Komunikasi nonprivat",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Keterangan kontak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Komunikasi nonprivat",
"detailRole": "information",
"isVisible": true,
"key": "ContactType",
"label": "Jenis komunikasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Komunikasi nonprivat",
"detailRole": "information",
"isVisible": true,
"key": "CountryRegionCode",
"label": "Kode negara telepon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Komunikasi nonprivat",
"detailRole": "information",
"isVisible": true,
"key": "LocatorExtension",
"label": "Ekstensi telepon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Atribut komunikasi",
"detailRole": "information",
"isVisible": true,
"key": "ContactPrimary",
"label": "Kontak utama",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Atribut komunikasi",
"detailRole": "information",
"isVisible": true,
"key": "MobilePhone",
"label": "Telepon seluler",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Atribut komunikasi",
"detailRole": "information",
"isVisible": true,
"key": "InstantMessage",
"label": "Pesan instan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "D8615F35-2706-56DD-9234-00A83F6223EA",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "7C27B5F9-48E6-5BDD-BF62-1B7912170F23",
"key": "Locator",
"type": "text"
},
{
"direction": "ascending",
"id": "992EF8B7-F10C-54B1-A8C7-5989E8B1BD96",
"key": "ContactKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Description",
"systemImage": "phone",
"title": "Kontak pelanggan",
"titleKey": "Locator"
}
],
"relations": [
{
"childDatasetID": "610A3944-5EFB-56B0-83F9-BBE57CAA5EE8",
"childKey": "ParentCustomerKey",
"id": "0C22C688-B166-558B-B4E8-0E4007539772",
"name": "Alamat",
"parentDatasetID": "D80FF367-5BEE-5C37-8052-143B1DAEE431",
"parentKey": "CustomerKey"
},
{
"childDatasetID": "B4021148-ABA7-500F-900C-EB75E2DFABD8",
"childKey": "ParentCustomerKey",
"id": "7A5CE5F0-3BCE-56D6-9A35-FCA847CB600C",
"name": "Kontak",
"parentDatasetID": "D80FF367-5BEE-5C37-8052-143B1DAEE431",
"parentKey": "CustomerKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Microsoft Dynamics AX",
"configurationLanguages": [
"id"
],
"countries": [
"ID"
],
"createdAt": "2026-10-08T00:00:00Z",
"description": "TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA.\n\nUntuk tim penjualan, administrasi dan manajer berizin: pilih partisi serta perusahaan tersimpan, cari pelanggan, lihat penagihan bawaan dan pengiriman, lalu buka Alamat atau Kontak sesuai kebutuhan. 19 nilai dossier, 14 nilai alamat dan delapan nilai kontak ditata dalam Detil; ID teknis disembunyikan.\n\nMengapa Cifru? Sesuaikan konfigurasi dengan cara kerja Anda. Pilih kolom, filter, dan rincian yang diperlukan, lalu tampilkan informasi di ponsel yang mungkin belum tersedia di aplikasi seluler bawaan perangkat lunak bisnis Anda. Pilihannya bergantung pada data yang dapat diakses dari sumber yang Anda berwenang gunakan dan paket Cifru Anda.\n\nEDISI KHUSUS: AX 2012 R3 on-premises pada SQL Server. Dukungan diperpanjang berakhir 11 Januari 2023 (tanggal Microsoft Lifecycle, zona Pacific). Hanya untuk instalasi lama yang sudah ada dan akses SQL yang secara eksplisit disetujui administrator; bukan anjuran memasang ERP lama atau membuka server ke internet. Bukan Dynamics 365 Finance/SCM, Business Central atau AX 2009. SQL langsung untuk layanan cloud tidak diasumsikan.\n\nPro: satu sumber, tiga daftar, satu tombol Home dan dua sub-tombol lazy. Pilihan partisi dan DATAAREAID tersimpan wajib saat membuka daftar; filter diterapkan sebelum batas 1.000 baris. Setiap relasi mempertahankan partisi, perusahaan, akun pelanggan dan pihak terkait. ID Int64 diteruskan sebagai teks tanpa pembulatan; kunci gabungan tetap internal. Tidak ada pembaruan berulang. Batasi lingkup bila batas baca tercapai; ini bukan ekspor seluruh database.\n\nPENTING: perusahaan virtual dapat menyimpan data dalam DATAAREAID bersama seperti VIR. Pilihan ini adalah nilai tersimpan, bukan otomatis nama badan hukum aktif di AX. Administrator harus memverifikasi pemetaan perusahaan virtual dan izin sumber. Filter bukan ACL. Pembacaan SQL tidak mewarisi AOS, XDS, aturan keamanan pengguna AX atau seluruh kebijakan privasi lokasi. Gunakan akun khusus SELECT dengan lingkup yang disetujui dan kontrol keamanan di server.\n\nHanya lokasi dan komunikasi dengan IsPrivate=0 disertakan. Alamat/komunikasi dengan PrivateForParty bukan nol, nilai privasi kosong/tidak dikenal, atau relasi pihak tidak cocok dikecualikan. Telepon/e-mail utama juga memerlukan relasi lokasi nonprivat yang cocok. Nama dan kontak bisnis tetap bisa merupakan data pribadi: hanya akses bila berwenang. Tidak disertakan rekening bank, kartu pembayaran, identitas pemerintah pribadi, data kelahiran atau audit. KreditMax tidak diambil karena mata uangnya bukan otomatis Currency faktur.\n\nAlamat mencakup riwayat dan masa berlaku ValidFrom/ValidTo UTC; tidak semua baris masih berlaku sekarang dan bukan salinan alamat historis faktur. Kode negara/provinsi adalah kode sumber, bukan ISO yang diasumsikan. Syarat/metode pembayaran dan pengiriman adalah kode bawaan, bukan label kamus yang ditebak. Status penangguhan mengikuti enum Microsoft; Never tetap nama kode sumber, bukan keputusan kredit. Nilai enum tak dikenal/kosong tidak diubah menjadi Ya/Tidak.\n\nDokumentasi AOT Microsoft AX 2012 R3 dan white paper address book mendasari tabel, kolom dan relasi. Ini bukan sertifikat DDL atau indeks SQL instalasi Anda. Referensi F&O yang menjelaskan perusahaan virtual dan contoh SQL pelanggan hanya bukti pembanding, bukan pengganti skema AX. Verifikasi versi R3, konfigurasi modul, pemilik tabel, kolom, kunci dan relasi aktual serta indeks/izin/lingkup sebelum uji SELECT terbatas saat impor. Paket dan tangkapan DEMO sintetis tidak mengandung kredensial, server atau baris perusahaan nyata; pengujian SQLite tidak menjamin SQL Server atau ERP nyata.\n\nReferensi pelanggan: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg915339(v=ax.60)\nReferensi alamat: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg895161(v=ax.60)\nReferensi kontak: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg876321(v=ax.60)\nSiklus dukungan: https://learn.microsoft.com/en-us/lifecycle/products/dynamics-ax-2012-r3",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "4436E625-CF79-5092-AE08-BC5D085317B4",
"rootButtonCount": 1,
"summary": "Pelanggan per partisi/perusahaan, penagihan bawaan, pengiriman, alamat historis dan kontak nonprivat.",
"tags": [
"Dynamics AX 2012 R3",
"SQL Server",
"Pelanggan",
"Alamat",
"Kontak",
"Pro"
],
"title": "Dossier pelanggan, alamat dan kontak — Pro"
}
}