Faktur pelanggan dan rincian — Pro
Periode faktur, jatuh tempo, sisa saat ini, profil mitra, dan rincian A/R 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 penjualan dan penagihan serta manajer: pilih periode tanggal faktur sebelum membaca data. Lihat faktur pelanggan, 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 A/R memuat uraian, kode barang A/R, jumlah, satuan, harga, nilai baris termasuk pajak dalam harga dan total pajak. Pajak tidak ditambahkan dua kali. Kode barang A/R tidak diasumsikan sama dengan kode persediaan I/C. 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 pelanggan
- Details: Rincian A/R tersimpan
- Details: Profil pelanggan
- Sub-button: Rincian A/R faktur
- Sub-button: Profil 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(RTRIM(d.IDCUST)), N':', RTRIM(d.IDCUST), N':', RTRIM(d.IDINVC)) AS DocumentKey, d.IDCUST AS PartnerCode, COALESCE(p.NAMECUST, d.IDCUST) 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.DATEDUE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 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.AROBL d LEFT JOIN dbo.ARCUS p ON p.IDCUST = d.IDCUST LEFT JOIN dbo.ARIBH h ON h.CNTBTCH = d.CNTBTCH AND h.CNTITEM = d.CNTITEM AND h.IDCUST = d.IDCUST AND h.IDINVC = d.IDINVC AND h.TEXTTRX = 1 AND h.CODECURN = d.CODECURN WHERE d.TRXTYPETXT = 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.IDCUST)), N':', RTRIM(d.IDCUST), N':', RTRIM(d.IDINVC)) AS DocumentKey, l.CNTLINE, h.IDINVC, h.CODECURN, l.IDITEM, l.TEXTDESC, l.UNITMEAS, l.QTYINVC, l.AMTPRIC, l.AMTEXTN, l.TOTTAX FROM dbo.ARIBD l INNER JOIN dbo.ARIBH h ON h.CNTBTCH = l.CNTBTCH AND h.CNTITEM = l.CNTITEM INNER JOIN dbo.AROBL d ON h.CNTBTCH = d.CNTBTCH AND h.CNTITEM = d.CNTITEM AND h.IDCUST = d.IDCUST AND h.IDINVC = d.IDINVC AND h.TEXTTRX = 1 AND h.CODECURN = d.CODECURN WHERE d.TRXTYPETXT = 1 AND d.CNTBTCH = :batch AND d.CNTITEM = :entry AND d.IDCUST = :partner AND d.IDINVC = :document
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT p.IDCUST, p.NAMECUST, p.TEXTSNAM, p.IDGRP, p.SWACTV, p.SWHOLD, p.NAMECITY, p.CODECTRY, p.NAMECTAC, p.TEXTPHON1, p.EMAIL1, p.CODECURN, p.AMTCRLIMT, p.AMTBALDUET, p.CNTOPENINV, p.CODETERM FROM dbo.ARCUS p WHERE p.IDCUST = :partner
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 300 — SQL Server",
"id": "6727D3E6-A090-5CFD-8168-CB5E9EAA124E",
"kind": "sqlServer",
"requiredObjects": [
"dbo.ARCUS",
"dbo.ARIBD",
"dbo.ARIBH",
"dbo.AROBL"
],
"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": "511B0E48-37B7-50DD-9998-156521CB71D6",
"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 pelanggan",
"primaryKey": "DocumentKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocumentDate",
"id": "C174E84A-DDF5-5236-8355-00C31445BB19",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocumentDate",
"id": "C6F344B7-CF39-5549-A36A-49B6303BB1D6",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"PartnerName",
"IDINVC",
"DESCINVC",
"CODECURN",
"PaymentState",
"DetailAvailability"
],
"sourceID": "6727D3E6-A090-5CFD-8168-CB5E9EAA124E",
"sqlQuery": "SELECT CONCAT(LEN(RTRIM(d.IDCUST)), N':', RTRIM(d.IDCUST), N':', RTRIM(d.IDINVC)) AS DocumentKey, d.IDCUST AS PartnerCode, COALESCE(p.NAMECUST, d.IDCUST) 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.DATEDUE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), d.DATEDUE, 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.AROBL d LEFT JOIN dbo.ARCUS p ON p.IDCUST = d.IDCUST LEFT JOIN dbo.ARIBH h ON h.CNTBTCH = d.CNTBTCH AND h.CNTITEM = d.CNTITEM AND h.IDCUST = d.IDCUST AND h.IDINVC = d.IDINVC AND h.TEXTTRX = 1 AND h.CODECURN = d.CODECURN WHERE d.TRXTYPETXT = 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": "DCC62BE8-E73A-5408-8DEA-976B62EA2200",
"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": "IDITEM",
"label": "Kode barang A/R",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IDITEM",
"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": "UNITMEAS",
"label": "Satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UNITMEAS",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QTYINVC",
"label": "Jumlah",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTYINVC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTPRIC",
"label": "Harga satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTPRIC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTEXTN",
"label": "Nilai baris termasuk pajak dalam harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTEXTN",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TOTTAX",
"label": "Total pajak baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TOTTAX",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Rincian A/R faktur",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CNTBTCH",
"id": "2B029EA8-5D38-5860-9266-F606ED65C2C0",
"name": "batch",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CNTITEM",
"id": "6B9E6FA3-DBF9-5384-8B7A-00396790E47C",
"name": "entry",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartnerCode",
"id": "1473DC20-BB15-56B6-B0AB-5C235EA59941",
"name": "partner",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "IDINVC",
"id": "8FAF50D3-273B-5684-ACC9-920232CA7205",
"name": "document",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"IDINVC",
"CODECURN",
"IDITEM",
"TEXTDESC",
"UNITMEAS"
],
"sourceID": "6727D3E6-A090-5CFD-8168-CB5E9EAA124E",
"sqlQuery": "SELECT CONCAT(l.CNTBTCH, N':', l.CNTITEM, N':', l.CNTLINE) AS LineKey, CONCAT(LEN(RTRIM(d.IDCUST)), N':', RTRIM(d.IDCUST), N':', RTRIM(d.IDINVC)) AS DocumentKey, l.CNTLINE, h.IDINVC, h.CODECURN, l.IDITEM, l.TEXTDESC, l.UNITMEAS, l.QTYINVC, l.AMTPRIC, l.AMTEXTN, l.TOTTAX FROM dbo.ARIBD l INNER JOIN dbo.ARIBH h ON h.CNTBTCH = l.CNTBTCH AND h.CNTITEM = l.CNTITEM INNER JOIN dbo.AROBL d ON h.CNTBTCH = d.CNTBTCH AND h.CNTITEM = d.CNTITEM AND h.IDCUST = d.IDCUST AND h.IDINVC = d.IDINVC AND h.TEXTTRX = 1 AND h.CODECURN = d.CODECURN WHERE d.TRXTYPETXT = 1 AND d.CNTBTCH = :batch AND d.CNTITEM = :entry AND d.IDCUST = :partner AND d.IDINVC = :document",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "F5EF6A6A-7F5F-5CCD-9991-7FE1D7154BC3",
"key": "IDCUST",
"type": "text"
}
],
"id": "2C0E478F-A05B-541E-B6C9-EBF4E64277D1",
"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": "Profil pelanggan",
"primaryKey": "IDCUST",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartnerCode",
"id": "370593BA-9FD4-5060-9781-DA6CDF918DDA",
"name": "partner",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"IDCUST",
"NAMECUST",
"TEXTSNAM",
"IDGRP",
"NAMECITY",
"CODECTRY",
"NAMECTAC",
"TEXTPHON1",
"EMAIL1",
"CODECURN",
"CODETERM"
],
"sourceID": "6727D3E6-A090-5CFD-8168-CB5E9EAA124E",
"sqlQuery": "SELECT p.IDCUST, p.NAMECUST, p.TEXTSNAM, p.IDGRP, p.SWACTV, p.SWHOLD, p.NAMECITY, p.CODECTRY, p.NAMECTAC, p.TEXTPHON1, p.EMAIL1, p.CODECURN, p.AMTCRLIMT, p.AMTBALDUET, p.CNTOPENINV, p.CODETERM FROM dbo.ARCUS p WHERE p.IDCUST = :partner",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "9AA4B482-D230-541D-89B1-ED098098DFAE",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "CB27D1A4-6BFD-5B8B-BB6D-413B2737474E",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "DCC62BE8-E73A-5408-8DEA-976B62EA2200",
"title": "Rincian A/R tersimpan",
"urlKey": ""
},
{
"id": "96AF7557-5AAE-5E08-8871-06DF4D47BBBE",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "EA30F4C0-DFA4-5D66-816D-A70A6F06DC8A",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "2C0E478F-A05B-541E-B6C9-EBF4E64277D1",
"title": "Profil pelanggan",
"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": "511B0E48-37B7-50DD-9998-156521CB71D6",
"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": "A99261BC-A702-5211-9CBE-B725355129B8",
"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 pelanggan",
"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": "UNITMEAS",
"label": "Satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYINVC",
"label": "Jumlah",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTPRIC",
"label": "Harga satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTEXTN",
"label": "Nilai baris termasuk pajak dalam harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TOTTAX",
"label": "Total pajak baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "DCC62BE8-E73A-5408-8DEA-976B62EA2200",
"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": "IDITEM",
"label": "Kode barang A/R",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TEXTDESC",
"label": "Uraian baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UNITMEAS",
"label": "Satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYINVC",
"label": "Jumlah",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTPRIC",
"label": "Harga satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTEXTN",
"label": "Nilai baris termasuk pajak dalam harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TOTTAX",
"label": "Total pajak baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "21DEAFCF-B3D0-5D70-B6C0-34265F8CFE0F",
"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": "IDITEM",
"systemImage": "doc.text",
"title": "Rincian A/R 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": "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": "2C0E478F-A05B-541E-B6C9-EBF4E64277D1",
"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": "0DC9FC01-F058-56C1-9CAF-B13DDFAAF81E",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "F5EF6A6A-7F5F-5CCD-9991-7FE1D7154BC3",
"key": "IDCUST",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "IDCUST",
"systemImage": "doc.text",
"title": "Profil pelanggan",
"titleKey": "NAMECUST"
}
],
"relations": [
{
"childDatasetID": "DCC62BE8-E73A-5408-8DEA-976B62EA2200",
"childKey": "DocumentKey",
"id": "CB27D1A4-6BFD-5B8B-BB6D-413B2737474E",
"name": "Rincian A/R tersimpan",
"parentDatasetID": "511B0E48-37B7-50DD-9998-156521CB71D6",
"parentKey": "DocumentKey"
},
{
"childDatasetID": "2C0E478F-A05B-541E-B6C9-EBF4E64277D1",
"childKey": "IDCUST",
"id": "EA30F4C0-DFA4-5D66-816D-A70A6F06DC8A",
"name": "Profil pelanggan",
"parentDatasetID": "511B0E48-37B7-50DD-9998-156521CB71D6",
"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 penjualan dan penagihan serta manajer: pilih periode tanggal faktur sebelum membaca data. Lihat faktur pelanggan, 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 A/R memuat uraian, kode barang A/R, jumlah, satuan, harga, nilai baris termasuk pajak dalam harga dan total pajak. Pajak tidak ditambahkan dua kali. Kode barang A/R tidak diasumsikan sama dengan kode persediaan I/C. 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": "26E9E9A8-385F-5215-A2E5-301EC4E13888",
"rootButtonCount": 1,
"summary": "Periode faktur, jatuh tempo, sisa saat ini, profil mitra, dan rincian A/R saat diminta.",
"tags": [
"Sage 300",
"SQL Server",
"Faktur",
"pelanggan",
"Pro"
],
"title": "Faktur pelanggan dan rincian — Pro"
}
}