Pelanggan — Free
Kontak, saldo dan batas kredit pelanggan, mata uang, status, serta jumlah dokumen belum selesai.
BELUM DIVALIDASI PADA INSTALASI ERP NYATA. Struktur berdasarkan AOM resmi Sage 300 2023; diuji dengan data sintetis dan antarmuka Cifru. Saat impor, petakan sumber milik Anda dan jalankan uji baca/kompatibilitas. Periksa versi, kolom, hak akses dan hasil sebelum pemakaian bisnis. Gambar adalah DEMO sintetis, bukan data atau koneksi Sage nyata.
Untuk staf penjualan, penagihan, dan manajer: periksa kontak, saldo, batas kredit, dan syarat pembayaran pelanggan. Saldo dan batas kredit memakai mata uang pelanggan yang ditampilkan; bukan jumlah tunggakan lewat jatuh tempo. Jumlah dokumen belum selesai bukan hanya jumlah faktur. Tidak ada penjumlahan antar mata uang.
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.
Free: satu sumber, satu daftar, dan rincian baris yang sama. Tanpa SQL khusus, relasi antar daftar, widget, atau langganan berbayar untuk paket ini. Pilih kelompok/kategori saat membuka daftar; pencarian dan filter lokal hanya mencakup baris yang sudah dimuat. Status aktif/nonaktif dan ditahan tersedia dalam rincian; keduanya tidak disamakan. Maksimum 2.000 baris per pembacaan, tanpa penyegaran berkala. Persempit pilihan jika batas tercapai. Hak akses SQL harus dibatasi ke informasi yang boleh dilihat pengguna; filter tampilan bukan kontrol keamanan.
Memerlukan Sage 300 dengan basis data perusahaan Microsoft SQL Server dan akses baca yang sah. Bukan Sage 300 Construction and Real Estate. Konfigurasi tidak menyertakan server, kredensial, atau data bisnis. Konfigurasi komunitas tidak resmi. Nama tabel dan kolom berdasarkan AOM resmi 2023; belum diuji pada instalasi Sage nyata. Periksa edisi, skema dbo, kolom, keunikan kode, hak akses, dan kinerja sebelum digunakan. Bukan klaim kompatibilitas dengan versi 2026. Contoh DEMO tidak membuktikan kompatibilitas basis data. Dokumentasi: https://ca-kb.sage.com/portal/app/portlets/results/viewdocument.jsp?solutionid=232425080400014
Screenshots
What this package creates
1 Home0 Details1 lists1 sources to map
- Home: Pelanggan
Sources are mapped locally and verified before applying.
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 300 — SQL Server",
"id": "630141E8-AD55-575A-AAB0-C475B2D2E541",
"kind": "sqlServer",
"requiredObjects": [
"dbo.ARCUS"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "277E6361-C983-52B7-B7E3-CB0EB9C7B5FA",
"key": "NAMECUST",
"type": "text"
},
{
"direction": "ascending",
"id": "F5EF6A6A-7F5F-5CCD-9991-7FE1D7154BC3",
"key": "IDCUST",
"type": "text"
}
],
"id": "1430A748-C51A-55AF-836F-AB58A24FEEC0",
"mappings": [
{
"commonFieldKey": "",
"key": "IDCUST",
"label": "Kode pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IDCUST",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NAMECUST",
"label": "Pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NAMECUST",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TEXTSNAM",
"label": "Nama singkat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TEXTSNAM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IDGRP",
"label": "Kelompok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IDGRP",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SWACTV",
"label": "Aktif (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SWACTV",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SWHOLD",
"label": "Ditahan (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SWHOLD",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NAMECITY",
"label": "Kota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NAMECITY",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CODECTRY",
"label": "Negara",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CODECTRY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NAMECTAC",
"label": "Kontak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NAMECTAC",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TEXTPHON1",
"label": "Telepon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TEXTPHON1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EMAIL1",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EMAIL1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CODECURN",
"label": "Mata uang pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CODECURN",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTCRLIMT",
"label": "Batas kredit — mata uang pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTCRLIMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AMTBALDUET",
"label": "Saldo — mata uang mitra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTBALDUET",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CNTOPENINV",
"label": "Dokumen belum selesai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CNTOPENINV",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CODETERM",
"label": "Kode syarat pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CODETERM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Pelanggan",
"primaryKey": "IDCUST",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"IDCUST",
"NAMECUST",
"TEXTSNAM",
"IDGRP",
"NAMECITY",
"CODECTRY",
"NAMECTAC",
"TEXTPHON1",
"EMAIL1",
"CODECURN",
"CODETERM"
],
"sourceID": "630141E8-AD55-575A-AAB0-C475B2D2E541",
"sqlQuery": "",
"tableName": "dbo.ARCUS"
}
],
"pages": [
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NAMECITY",
"label": "Kota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NAMECTAC",
"label": "Kontak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TEXTPHON1",
"label": "Telepon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CODECURN",
"label": "Mata uang pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTBALDUET",
"label": "Saldo — mata uang mitra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CNTOPENINV",
"label": "Dokumen belum selesai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "1430A748-C51A-55AF-836F-AB58A24FEEC0",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IDCUST",
"label": "Kode pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NAMECUST",
"label": "Pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TEXTSNAM",
"label": "Nama singkat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IDGRP",
"label": "Kelompok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SWACTV",
"label": "Aktif (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SWHOLD",
"label": "Ditahan (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NAMECITY",
"label": "Kota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CODECTRY",
"label": "Negara",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NAMECTAC",
"label": "Kontak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TEXTPHON1",
"label": "Telepon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EMAIL1",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CODECURN",
"label": "Mata uang pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTCRLIMT",
"label": "Batas kredit — mata uang pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTBALDUET",
"label": "Saldo — mata uang mitra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CNTOPENINV",
"label": "Dokumen belum selesai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CODETERM",
"label": "Kode syarat pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "A52BF728-94DC-50F4-925B-8F0A9FD6A6A1",
"openFilters": [
{
"id": "5AE98E36-FD68-5AD9-B279-FD1555128C7B",
"includeAllOption": true,
"key": "IDGRP",
"title": "Kelompok",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "277E6361-C983-52B7-B7E3-CB0EB9C7B5FA",
"key": "NAMECUST",
"type": "text"
},
{
"direction": "ascending",
"id": "F5EF6A6A-7F5F-5CCD-9991-7FE1D7154BC3",
"key": "IDCUST",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "IDCUST",
"systemImage": "person.2",
"title": "Pelanggan",
"titleKey": "NAMECUST"
}
],
"relations": [],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sage 300",
"configurationLanguages": [
"id"
],
"countries": [
"ID"
],
"createdAt": "2026-10-03T00:00:00Z",
"description": "BELUM DIVALIDASI PADA INSTALASI ERP NYATA. Struktur berdasarkan AOM resmi Sage 300 2023; diuji dengan data sintetis dan antarmuka Cifru. Saat impor, petakan sumber milik Anda dan jalankan uji baca/kompatibilitas. Periksa versi, kolom, hak akses dan hasil sebelum pemakaian bisnis. Gambar adalah DEMO sintetis, bukan data atau koneksi Sage nyata.\n\nUntuk staf penjualan, penagihan, dan manajer: periksa kontak, saldo, batas kredit, dan syarat pembayaran pelanggan. Saldo dan batas kredit memakai mata uang pelanggan yang ditampilkan; bukan jumlah tunggakan lewat jatuh tempo. Jumlah dokumen belum selesai bukan hanya jumlah faktur. Tidak ada penjumlahan antar mata uang.\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\nFree: satu sumber, satu daftar, dan rincian baris yang sama. Tanpa SQL khusus, relasi antar daftar, widget, atau langganan berbayar untuk paket ini. Pilih kelompok/kategori saat membuka daftar; pencarian dan filter lokal hanya mencakup baris yang sudah dimuat. Status aktif/nonaktif dan ditahan tersedia dalam rincian; keduanya tidak disamakan. Maksimum 2.000 baris per pembacaan, tanpa penyegaran berkala. Persempit pilihan jika batas tercapai. Hak akses SQL harus dibatasi ke informasi yang boleh dilihat pengguna; filter tampilan bukan kontrol keamanan.\n\nMemerlukan Sage 300 dengan basis data perusahaan Microsoft SQL Server dan akses baca yang sah. Bukan Sage 300 Construction and Real Estate. Konfigurasi tidak menyertakan server, kredensial, atau data bisnis. Konfigurasi komunitas tidak resmi. Nama tabel dan kolom berdasarkan AOM resmi 2023; belum diuji pada instalasi Sage nyata. Periksa edisi, skema dbo, kolom, keunikan kode, hak akses, dan kinerja sebelum digunakan. Bukan klaim kompatibilitas dengan versi 2026. Contoh DEMO tidak membuktikan kompatibilitas basis data. Dokumentasi: https://ca-kb.sage.com/portal/app/portlets/results/viewdocument.jsp?solutionid=232425080400014",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "free",
"packageID": "37ED3CC6-AC0D-5F13-9DC6-7939F8B19972",
"rootButtonCount": 1,
"summary": "Kontak, saldo dan batas kredit pelanggan, mata uang, status, serta jumlah dokumen belum selesai.",
"tags": [
"Sage 300",
"SQL Server",
"Pelanggan",
"Free"
],
"title": "Pelanggan — Free"
}
}