Faktur pemasok dan rincian — Pro
Periode faktur, jatuh tempo, sisa saat ini, profil mitra, dan distribusi akun saat diminta.
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 dan pembayaran serta manajer: pilih periode tanggal faktur sebelum membaca data. Lihat faktur pemasok, tanggal jatuh tempo, nilai asli, mata uang, dan sisa saat ini. Buka rincian faktur atau profil mitra dengan kontak, saldo, dan statusnya. Hanya faktur pada catatan transaksi A/P atau A/R; nota kredit, nota debit, pembayaran, dan entri batch yang belum masuk catatan transaksi tidak dicampur. Periode membatasi tanggal faktur, BUKAN menghitung saldo historis atau aging per tanggal. Faktur lunas yang masih disimpan tetap terlihat; status pelunasan berasal dari Sage, bukan kesimpulan dari jatuh tempo. Tidak ada penjumlahan antar mata uang. Rincian yang tersedia adalah distribusi akun buku besar, jumlah sebelum pajak, pajak termasuk harga, total pajak, serta nilai distribusi. Ini bukan daftar produk P/O. Rincian batch lama hanya tersedia selama disimpan oleh Sage. Jika dihapus lewat pembersihan riwayat, faktur dan profil mitra tetap dapat dibaca; ketiadaan rincian tidak berarti faktur bernilai nol. Label ketersediaan menunjukkan header batch cocok, bukan jaminan seluruh rincian masih ada. Semua subdaftar dimuat saat dibuka.
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.
Pro: SQL baca-saja, satu sumber, tiga daftar, dua tombol terkait. Maksimum 2.000 baris per pembacaan; tidak ada refresh berkala. Persempit periode jika batas tercapai. Batas hasil tidak menjamin query murah; periksa rencana eksekusi dan timeout pada basis data perusahaan. Filter tampilan bukan kontrol hak akses. Gunakan akun SQL baca-saja dengan izin minimum yang disetujui perusahaan. Paket tidak berisi server, kredensial, atau data bisnis.
Konfigurasi komunitas tidak resmi. Berdasarkan Sage 300 AOM 2023, bukan Sage 300 Construction and Real Estate, dan bukan klaim kompatibilitas 2026. Memerlukan SQL Server 2012+ dengan compatibility level 110+ dan skema dbo. Adapter tanggal menerima YYYYMMDD, akhiran desimal nol, atau tipe tanggal SQL native. Tanggal kosong, rusak atau format lain menjadi NULL; tanggal faktur seperti itu tidak masuk hasil periode. Tidak ada tanggal pengganti buatan. Jenis SQL fisik belum diverifikasi pada instalasi nyata; periksa metadata, keunikan kunci, tanggal, keterkaitan batch dan performa sebelum pemakaian. Pengujian data sintetis dan captur DEMO bukan bukti eksekusi di ERP nyata. Dokumentasi: https://ca-kb.sage.com/portal/app/portlets/results/viewdocument.jsp?solutionid=232425080400014
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Faktur pemasok
- Details: Distribusi akun tersimpan
- Details: Profil pemasok
- Sub-button: Distribusi akun faktur
- Sub-button: Profil pemasok
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(RTRIM(d.IDVEND)), N':', RTRIM(d.IDVEND), N':', RTRIM(d.IDINVC)) AS DocumentKey, d.IDVEND AS PartnerCode, COALESCE(p.VENDNAME, d.IDVEND) AS PartnerName, d.IDINVC, d.DESCINVC, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 8) ELSE NULL END, 112) AS DocumentDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112))), 8) ELSE NULL END, 112) AS DueDate, d.CODECURN, d.AMTINVCTC, d.AMTDUETC, d.CNTBTCH, d.CNTITEM, CASE d.SWPAID WHEN 0 THEN N'Belum lunas' WHEN 1 THEN N'Lunas' ELSE N'Tidak diketahui' END AS PaymentState, CASE WHEN h.CNTBTCH IS NULL THEN N'Header batch tidak tersimpan' ELSE N'Header batch tersedia' END AS DetailAvailability FROM dbo.APOBL d LEFT JOIN dbo.APVEN p ON p.VENDORID = d.IDVEND LEFT JOIN dbo.APIBH h ON h.CNTBTCH = d.CNTBTCH AND h.CNTITEM = d.CNTITEM AND h.IDVEND = d.IDVEND AND h.IDINVC = d.IDINVC AND h.TEXTTRX = 1 AND h.CODECURN = d.CODECURN WHERE d.TXTTRXTYPE = 1 AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 8) ELSE NULL END, 112) >= :date_from AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 8) ELSE NULL END, 112) < :date_until
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(l.CNTBTCH, N':', l.CNTITEM, N':', l.CNTLINE) AS LineKey, CONCAT(LEN(RTRIM(d.IDVEND)), N':', RTRIM(d.IDVEND), N':', RTRIM(d.IDINVC)) AS DocumentKey, l.CNTLINE, h.IDINVC, h.CODECURN, l.IDDIST, l.TEXTDESC, l.IDGLACCT, l.AMTDISTNET, l.AMTINCLTAX, l.AMTTOTTAX, l.AMTDIST FROM dbo.APIBD l INNER JOIN dbo.APIBH h ON h.CNTBTCH = l.CNTBTCH AND h.CNTITEM = l.CNTITEM INNER JOIN dbo.APOBL d ON h.CNTBTCH = d.CNTBTCH AND h.CNTITEM = d.CNTITEM AND h.IDVEND = d.IDVEND AND h.IDINVC = d.IDINVC AND h.TEXTTRX = 1 AND h.CODECURN = d.CODECURN WHERE d.TXTTRXTYPE = 1 AND d.CNTBTCH = :batch AND d.CNTITEM = :entry AND d.IDVEND = :partner AND d.IDINVC = :document
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT p.VENDORID, p.VENDNAME, p.SHORTNAME, p.IDGRP, p.SWACTV, p.SWHOLD, p.NAMECITY, p.CODECTRY, p.NAMECTAC, p.TEXTPHON1, p.EMAIL1, p.CURNCODE, p.AMTBALDUET, p.CNTOPENINV FROM dbo.APVEN p WHERE p.VENDORID = :partner
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 300 — SQL Server",
"id": "B1DFE5DB-19F1-5805-A500-32D3A30CA43E",
"kind": "sqlServer",
"requiredObjects": [
"dbo.APIBD",
"dbo.APIBH",
"dbo.APOBL",
"dbo.APVEN"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "EC6CD31E-FABB-5268-AD3A-FF52AD2D2F7E",
"key": "DocumentDate",
"type": "date"
},
{
"direction": "ascending",
"id": "6C99D094-05D0-5681-9500-0CA5504BECC9",
"key": "DocumentKey",
"type": "text"
}
],
"id": "B1EB2719-8283-58D8-93F7-1DF4FEEF353A",
"mappings": [
{
"commonFieldKey": "",
"key": "DocumentKey",
"label": "Kunci dokumen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartnerCode",
"label": "Kode mitra internal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PartnerCode",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartnerName",
"label": "Mitra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PartnerName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IDINVC",
"label": "Nomor faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IDINVC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DESCINVC",
"label": "Keterangan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DESCINVC",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocumentDate",
"label": "Tanggal faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DueDate",
"label": "Jatuh tempo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CODECURN",
"label": "Mata uang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CODECURN",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTINVCTC",
"label": "Nilai faktur — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTINVCTC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTDUETC",
"label": "Sisa saat ini — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTDUETC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PaymentState",
"label": "Status pelunasan Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PaymentState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DetailAvailability",
"label": "Rincian tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DetailAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CNTBTCH",
"label": "Kunci batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CNTBTCH",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CNTITEM",
"label": "Kunci entri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CNTITEM",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Faktur pemasok",
"primaryKey": "DocumentKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocumentDate",
"id": "D5AF59BF-0AF2-5098-98B5-B57BCA741553",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocumentDate",
"id": "FC144F12-208F-5ACD-813A-EF4091D76FD2",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"PartnerName",
"IDINVC",
"DESCINVC",
"CODECURN",
"PaymentState",
"DetailAvailability"
],
"sourceID": "B1DFE5DB-19F1-5805-A500-32D3A30CA43E",
"sqlQuery": "SELECT CONCAT(LEN(RTRIM(d.IDVEND)), N':', RTRIM(d.IDVEND), N':', RTRIM(d.IDINVC)) AS DocumentKey, d.IDVEND AS PartnerCode, COALESCE(p.VENDNAME, d.IDVEND) AS PartnerName, d.IDINVC, d.DESCINVC, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 8) ELSE NULL END, 112) AS DocumentDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVCDU, 112))), 8) ELSE NULL END, 112) AS DueDate, d.CODECURN, d.AMTINVCTC, d.AMTDUETC, d.CNTBTCH, d.CNTITEM, CASE d.SWPAID WHEN 0 THEN N'Belum lunas' WHEN 1 THEN N'Lunas' ELSE N'Tidak diketahui' END AS PaymentState, CASE WHEN h.CNTBTCH IS NULL THEN N'Header batch tidak tersimpan' ELSE N'Header batch tersedia' END AS DetailAvailability FROM dbo.APOBL d LEFT JOIN dbo.APVEN p ON p.VENDORID = d.IDVEND LEFT JOIN dbo.APIBH h ON h.CNTBTCH = d.CNTBTCH AND h.CNTITEM = d.CNTITEM AND h.IDVEND = d.IDVEND AND h.IDINVC = d.IDINVC AND h.TEXTTRX = 1 AND h.CODECURN = d.CODECURN WHERE d.TXTTRXTYPE = 1 AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 8) ELSE NULL END, 112) >= :date_from AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEINVC, 112))), 8) ELSE NULL END, 112) < :date_until",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "E9E3755B-4FA8-5524-99E2-C67AD4C91CBA",
"key": "CNTLINE",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "5C1709F9-E957-59D8-86BD-A3A9BC4F44F1",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Kunci baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocumentKey",
"label": "Kunci dokumen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CNTLINE",
"label": "Kunci baris batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CNTLINE",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IDINVC",
"label": "Nomor faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IDINVC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CODECURN",
"label": "Mata uang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CODECURN",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "IDDIST",
"label": "Kode distribusi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IDDIST",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TEXTDESC",
"label": "Uraian baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TEXTDESC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IDGLACCT",
"label": "Akun buku besar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IDGLACCT",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTDISTNET",
"label": "Distribusi sebelum pajak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTDISTNET",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTINCLTAX",
"label": "Pajak termasuk harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTINCLTAX",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTTOTTAX",
"label": "Total pajak distribusi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTTOTTAX",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTDIST",
"label": "Nilai distribusi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTDIST",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Distribusi akun faktur",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CNTBTCH",
"id": "A057A385-D09E-5174-A305-9EFB28C25E96",
"name": "batch",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CNTITEM",
"id": "E3CBBC70-DB9B-54B0-A12A-F3B68E1FF302",
"name": "entry",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartnerCode",
"id": "4EB1E5B2-125E-506F-A5EE-F672C7E66C99",
"name": "partner",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "IDINVC",
"id": "25910DB5-46E9-5BA1-B9B6-449EA6629C3E",
"name": "document",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"IDINVC",
"CODECURN",
"IDDIST",
"TEXTDESC",
"IDGLACCT"
],
"sourceID": "B1DFE5DB-19F1-5805-A500-32D3A30CA43E",
"sqlQuery": "SELECT CONCAT(l.CNTBTCH, N':', l.CNTITEM, N':', l.CNTLINE) AS LineKey, CONCAT(LEN(RTRIM(d.IDVEND)), N':', RTRIM(d.IDVEND), N':', RTRIM(d.IDINVC)) AS DocumentKey, l.CNTLINE, h.IDINVC, h.CODECURN, l.IDDIST, l.TEXTDESC, l.IDGLACCT, l.AMTDISTNET, l.AMTINCLTAX, l.AMTTOTTAX, l.AMTDIST FROM dbo.APIBD l INNER JOIN dbo.APIBH h ON h.CNTBTCH = l.CNTBTCH AND h.CNTITEM = l.CNTITEM INNER JOIN dbo.APOBL d ON h.CNTBTCH = d.CNTBTCH AND h.CNTITEM = d.CNTITEM AND h.IDVEND = d.IDVEND AND h.IDINVC = d.IDINVC AND h.TEXTTRX = 1 AND h.CODECURN = d.CODECURN WHERE d.TXTTRXTYPE = 1 AND d.CNTBTCH = :batch AND d.CNTITEM = :entry AND d.IDVEND = :partner AND d.IDINVC = :document",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "44EA15AF-43DA-5B5D-8A52-17FD850DB6B6",
"key": "VENDORID",
"type": "text"
}
],
"id": "3F667FEF-7F48-57C2-865E-16012BBDFEC5",
"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": "Profil pemasok",
"primaryKey": "VENDORID",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartnerCode",
"id": "12EA1240-88CA-5E49-843D-AB77F5241BBC",
"name": "partner",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VENDORID",
"VENDNAME",
"SHORTNAME",
"IDGRP",
"NAMECITY",
"CODECTRY",
"NAMECTAC",
"TEXTPHON1",
"EMAIL1",
"CURNCODE"
],
"sourceID": "B1DFE5DB-19F1-5805-A500-32D3A30CA43E",
"sqlQuery": "SELECT p.VENDORID, p.VENDNAME, p.SHORTNAME, p.IDGRP, p.SWACTV, p.SWHOLD, p.NAMECITY, p.CODECTRY, p.NAMECTAC, p.TEXTPHON1, p.EMAIL1, p.CURNCODE, p.AMTBALDUET, p.CNTOPENINV FROM dbo.APVEN p WHERE p.VENDORID = :partner",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "C8267FAE-EB05-5766-9289-32A03378CBE1",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "BF9655E0-8876-56AC-81BF-8C03F83DF877",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "5C1709F9-E957-59D8-86BD-A3A9BC4F44F1",
"title": "Distribusi akun tersimpan",
"urlKey": ""
},
{
"id": "E9C41B1F-540C-5B9B-8A0E-37F48E68CE74",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "C509E599-AA12-51F0-8029-96D2C6B36AFA",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "3F667FEF-7F48-57C2-865E-16012BBDFEC5",
"title": "Profil pemasok",
"urlKey": ""
}
],
"badgeKey": "PaymentState",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DESCINVC",
"label": "Keterangan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDate",
"label": "Tanggal faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Jatuh tempo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CODECURN",
"label": "Mata uang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTINVCTC",
"label": "Nilai faktur — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTDUETC",
"label": "Sisa saat ini — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DetailAvailability",
"label": "Rincian tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B1EB2719-8283-58D8-93F7-1DF4FEEF353A",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PartnerName",
"label": "Mitra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IDINVC",
"label": "Nomor faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DESCINVC",
"label": "Keterangan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDate",
"label": "Tanggal faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Jatuh tempo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CODECURN",
"label": "Mata uang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTINVCTC",
"label": "Nilai faktur — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTDUETC",
"label": "Sisa saat ini — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PaymentState",
"label": "Status pelunasan Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DetailAvailability",
"label": "Rincian tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "7D5E8659-1F8C-5D12-A4F5-2C19755CFDFE",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "B4BD3880-2BAC-50E2-9518-BBB51D7C6C70",
"includeAllOption": false,
"key": "DocumentDate",
"title": "Periode tanggal faktur",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "EC6CD31E-FABB-5268-AD3A-FF52AD2D2F7E",
"key": "DocumentDate",
"type": "date"
},
{
"direction": "ascending",
"id": "6C99D094-05D0-5681-9500-0CA5504BECC9",
"key": "DocumentKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "IDINVC",
"systemImage": "doc.text",
"title": "Faktur pemasok",
"titleKey": "PartnerName"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CODECURN",
"label": "Mata uang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTDISTNET",
"label": "Distribusi sebelum pajak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTINCLTAX",
"label": "Pajak termasuk harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTTOTTAX",
"label": "Total pajak distribusi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTDIST",
"label": "Nilai distribusi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "5C1709F9-E957-59D8-86BD-A3A9BC4F44F1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IDINVC",
"label": "Nomor faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CODECURN",
"label": "Mata uang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IDDIST",
"label": "Kode distribusi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TEXTDESC",
"label": "Uraian baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IDGLACCT",
"label": "Akun buku besar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTDISTNET",
"label": "Distribusi sebelum pajak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTINCLTAX",
"label": "Pajak termasuk harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTTOTTAX",
"label": "Total pajak distribusi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTDIST",
"label": "Nilai distribusi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "C7A901DB-2755-5D00-B3E6-45E1173E0C28",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "E9E3755B-4FA8-5524-99E2-C67AD4C91CBA",
"key": "CNTLINE",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "IDGLACCT",
"systemImage": "doc.text",
"title": "Distribusi akun faktur",
"titleKey": "TEXTDESC"
},
{
"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": "3F667FEF-7F48-57C2-865E-16012BBDFEC5",
"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": "AE93562F-1439-5CC2-9672-51455D27863B",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "44EA15AF-43DA-5B5D-8A52-17FD850DB6B6",
"key": "VENDORID",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "VENDORID",
"systemImage": "doc.text",
"title": "Profil pemasok",
"titleKey": "VENDNAME"
}
],
"relations": [
{
"childDatasetID": "5C1709F9-E957-59D8-86BD-A3A9BC4F44F1",
"childKey": "DocumentKey",
"id": "BF9655E0-8876-56AC-81BF-8C03F83DF877",
"name": "Distribusi akun tersimpan",
"parentDatasetID": "B1EB2719-8283-58D8-93F7-1DF4FEEF353A",
"parentKey": "DocumentKey"
},
{
"childDatasetID": "3F667FEF-7F48-57C2-865E-16012BBDFEC5",
"childKey": "VENDORID",
"id": "C509E599-AA12-51F0-8029-96D2C6B36AFA",
"name": "Profil pemasok",
"parentDatasetID": "B1EB2719-8283-58D8-93F7-1DF4FEEF353A",
"parentKey": "PartnerCode"
}
],
"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 dan pembayaran serta manajer: pilih periode tanggal faktur sebelum membaca data. Lihat faktur pemasok, tanggal jatuh tempo, nilai asli, mata uang, dan sisa saat ini. Buka rincian faktur atau profil mitra dengan kontak, saldo, dan statusnya. Hanya faktur pada catatan transaksi A/P atau A/R; nota kredit, nota debit, pembayaran, dan entri batch yang belum masuk catatan transaksi tidak dicampur. Periode membatasi tanggal faktur, BUKAN menghitung saldo historis atau aging per tanggal. Faktur lunas yang masih disimpan tetap terlihat; status pelunasan berasal dari Sage, bukan kesimpulan dari jatuh tempo. Tidak ada penjumlahan antar mata uang. Rincian yang tersedia adalah distribusi akun buku besar, jumlah sebelum pajak, pajak termasuk harga, total pajak, serta nilai distribusi. Ini bukan daftar produk P/O. Rincian batch lama hanya tersedia selama disimpan oleh Sage. Jika dihapus lewat pembersihan riwayat, faktur dan profil mitra tetap dapat dibaca; ketiadaan rincian tidak berarti faktur bernilai nol. Label ketersediaan menunjukkan header batch cocok, bukan jaminan seluruh rincian masih ada. Semua subdaftar dimuat saat dibuka.\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\nPro: SQL baca-saja, satu sumber, tiga daftar, dua tombol terkait. Maksimum 2.000 baris per pembacaan; tidak ada refresh berkala. Persempit periode jika batas tercapai. Batas hasil tidak menjamin query murah; periksa rencana eksekusi dan timeout pada basis data perusahaan. Filter tampilan bukan kontrol hak akses. Gunakan akun SQL baca-saja dengan izin minimum yang disetujui perusahaan. Paket tidak berisi server, kredensial, atau data bisnis.\n\nKonfigurasi komunitas tidak resmi. Berdasarkan Sage 300 AOM 2023, bukan Sage 300 Construction and Real Estate, dan bukan klaim kompatibilitas 2026. Memerlukan SQL Server 2012+ dengan compatibility level 110+ dan skema dbo. Adapter tanggal menerima YYYYMMDD, akhiran desimal nol, atau tipe tanggal SQL native. Tanggal kosong, rusak atau format lain menjadi NULL; tanggal faktur seperti itu tidak masuk hasil periode. Tidak ada tanggal pengganti buatan. Jenis SQL fisik belum diverifikasi pada instalasi nyata; periksa metadata, keunikan kunci, tanggal, keterkaitan batch dan performa sebelum pemakaian. Pengujian data sintetis dan captur DEMO bukan bukti eksekusi di ERP nyata. Dokumentasi: https://ca-kb.sage.com/portal/app/portlets/results/viewdocument.jsp?solutionid=232425080400014",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "30C7C5E1-680A-51FB-B81D-42EEC71ACBA4",
"rootButtonCount": 1,
"summary": "Periode faktur, jatuh tempo, sisa saat ini, profil mitra, dan distribusi akun saat diminta.",
"tags": [
"Sage 300",
"SQL Server",
"Faktur",
"pemasok",
"Pro"
],
"title": "Faktur pemasok dan rincian — Pro"
}
}