Pemasok — Free
Kontak pemasok, saldo dalam mata uang pemasok, status, dan 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 pembelian, keuangan, dan manajer: temukan kontak pemasok serta lihat saldo dan statusnya. Saldo memakai mata uang pemasok yang ditampilkan; bukan total pengeluaran atau tunggakan lewat jatuh tempo. Jumlah dokumen belum selesai tidak ditafsirkan sebagai jumlah faktur saja. 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: Pemasok
Sources are mapped locally and verified before applying.
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 300 — SQL Server",
"id": "35FEF566-2BB5-5FD1-AACA-DF292AF8F6E2",
"kind": "sqlServer",
"requiredObjects": [
"dbo.APVEN"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "4F40E7DE-5D5B-5A48-AF93-30EC861BFC6E",
"key": "VENDNAME",
"type": "text"
},
{
"direction": "ascending",
"id": "44EA15AF-43DA-5B5D-8A52-17FD850DB6B6",
"key": "VENDORID",
"type": "text"
}
],
"id": "3DC1AFBF-564F-518C-9698-1B357D3ED54F",
"mappings": [
{
"commonFieldKey": "",
"key": "VENDORID",
"label": "Kode pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VENDORID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDNAME",
"label": "Pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VENDNAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHORTNAME",
"label": "Nama singkat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHORTNAME",
"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": "CURNCODE",
"label": "Mata uang pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CURNCODE",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"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
}
],
"maxRows": 2000,
"name": "Pemasok",
"primaryKey": "VENDORID",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VENDORID",
"VENDNAME",
"SHORTNAME",
"IDGRP",
"NAMECITY",
"CODECTRY",
"NAMECTAC",
"TEXTPHON1",
"EMAIL1",
"CURNCODE"
],
"sourceID": "35FEF566-2BB5-5FD1-AACA-DF292AF8F6E2",
"sqlQuery": "",
"tableName": "dbo.APVEN"
}
],
"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": "CURNCODE",
"label": "Mata uang pemasok",
"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": "3DC1AFBF-564F-518C-9698-1B357D3ED54F",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VENDORID",
"label": "Kode pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VENDNAME",
"label": "Pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SHORTNAME",
"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": "CURNCODE",
"label": "Mata uang pemasok",
"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"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "ED53808D-E8E8-5E83-8076-4F32BC2ACB99",
"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": "4F40E7DE-5D5B-5A48-AF93-30EC861BFC6E",
"key": "VENDNAME",
"type": "text"
},
{
"direction": "ascending",
"id": "44EA15AF-43DA-5B5D-8A52-17FD850DB6B6",
"key": "VENDORID",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "VENDORID",
"systemImage": "person.2",
"title": "Pemasok",
"titleKey": "VENDNAME"
}
],
"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 pembelian, keuangan, dan manajer: temukan kontak pemasok serta lihat saldo dan statusnya. Saldo memakai mata uang pemasok yang ditampilkan; bukan total pengeluaran atau tunggakan lewat jatuh tempo. Jumlah dokumen belum selesai tidak ditafsirkan sebagai jumlah faktur saja. 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": "A37866B0-8CCE-55E4-8259-F9314A835210",
"rootButtonCount": 1,
"summary": "Kontak pemasok, saldo dalam mata uang pemasok, status, dan jumlah dokumen belum selesai.",
"tags": [
"Sage 300",
"SQL Server",
"Pemasok",
"Free"
],
"title": "Pemasok — Free"
}
}