Jurnal dan rincian akun — Pro
Periode, status batch, rincian dengan mata uang sumber dan kurs, serta profil akun terkini.
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 akuntan, staf keuangan, dan manajer: pilih periode tanggal post yang ditentukan, lalu telusuri entri jurnal GL yang masih disimpan. Kartu memuat uraian, nomor batch/entri, status dan jenis batch, periode fiskal, kode sumber, dan jumlah rincian menurut header. Detil memuat tanggal dokumen, pembalikan, kelompok pajak, kesalahan batch, dan mata uang buku. Buka rincian untuk referensi, tanggal, nilai bertanda dan mata uang sumber tiap baris, kuantitas nonfinansial, serta kurs tersimpan. Tombol berikutnya membuka profil akun terkini dengan kelompok, klasifikasi, saldo normal, status aktif, satuan, dan mata uang default.
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: satu sumber SQL Server, tiga daftar, dua tombol bertingkat, dan SQL SELECT baca-saja. Subdaftar dibaca hanya saat dibuka, terikat perusahaan, batch, entri, tanggal header dan kunci baris lengkap; kunci internal tidak ditampilkan. Maksimum 1.000 baris per pembacaan, tanpa refresh berkala. Batas hasil bukan jaminan murah atau lengkap; periksa indeks, timeout dan pemberitahuan batas Cifru, lalu persempit periode bila perlu.
CAKUPAN: tabel fisik GLJEH/GLJED dan GLBCTL Sage 300 AOM 2023, bukan daftar lengkap transaksi buku besar yang telah diposting. Batch terbuka, dihapus, diposting sementara, siap diposting dan diposting dibedakan menurut status native; status asing tidak ditebak. Riwayat yang telah dibersihkan tidak direkonstruksi. Jumlah rincian header bukan bukti semua baris tersimpan atau dimuat. Tanggal post adalah tanggal yang ditentukan di header, BUKAN waktu ketika posting benar-benar selesai; tahun/periode fiskal bukan bulan kalender. Hanya batch non-intercompany (SWICT=0), satu profil CSCOM, dan originator kosong atau sama dengan ID profil yang didukung. ID profil tidak diasumsikan sama dengan nama database. Profil akun tersedia hanya pada konteks baris perusahaan/destination kosong atau sama dengan profil, dengan tepat satu akun yang cocok. Ini pembatasan dukungan paket, bukan penetapan arti bisnis semua nilai kosong; konteks lain memerlukan pemetaan terpisah.
NILAI DAN KURS: SCURNAMT ditampilkan apa adanya dengan SCURNCODE pada baris yang sama. Moneda kosong tetap kosong, bukan otomatis IDR. Nilai negatif, nol atau tidak tersedia dipertahankan; tidak ada ABS, pembagian debit/kredit buatan, konversi atau total lintas mata uang. TRANSAMT dan total uang header sengaja tidak ditampilkan karena denominasi fisik/konversi debit-kredit belum dibuktikan untuk laporan ini. HCURNCODE adalah kode home baris, HOMECUR berasal dari profil perusahaan; keduanya bukan pengganti mata uang sumber. Operator kurs ditampilkan sebagai kode tanpa menebak rumus perkalian/pembagian. Kuantitas nonfinansial bukan saldo uang atau stok; satuan akun merupakan pengaturan terkini, bukan bukti unit historis pada baris. Saldo normal akun bukan nilai saldo. Status aktif akun bukan jaminan izin posting dan default mata uang akun bukan mata uang buku.
BATAS DAN KEAMANAN: ini konfigurasi komunitas tidak resmi untuk Sage 300 2023, bukan Sage 300 Construction and Real Estate. Memerlukan dbo, SQL Server 2012+ dan compatibility level 110+. AOM/API bukan DDL atau sertifikat tipe/index/FK SQL yang terpasang. Kunci TRANSNBR disimpan utuh; protokol native sequenced revisions tidak diganti dengan nomor baris buatan. Verifikasi kunci, revisi, jumlah baris, tanggal, owner dan kinerja saat impor pada versi Anda. Filter UI bukan kontrol akses dan akses SQL tidak mewarisi otomatis hak pengguna Sage. Gunakan akun SELECT minimum pada data yang memang diizinkan. Tidak ada fungsi posting, pembayaran, ekspor pajak tersertifikasi, server atau kredensial dalam paket. Captur DEMO menggunakan data sintetis saja.
Dokumentasi tabel: https://ca-kb.sage.com/portal/app/portlets/results/viewdocument.jsp?solutionid=232425080400014
Bantuan jurnal: https://help.sage300.com/en-us/2023/classic/Content/Financials/General_Ledger/Transactions/JournalEntry/AddingJournalEntry.htm
Profil perusahaan: https://help.sage300.com/en-us/2023/classic/Content/SystemManager/CommonServices/SCREENS/CompanyProfile.htm
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Jurnal GL
- Details: Rincian jurnal
- Details: Profil akun terkini
- Sub-button: Rincian jurnal
- Sub-button: Profil akun terkini
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CONCAT(LEN(CONCAT(p.ORGID,N'#')),N':',p.ORGID,N':',LEN(CONCAT(h.BATCHID,N'#')),N':',h.BATCHID,N':',LEN(CONCAT(h.BTCHENTRY,N'#')),N':',h.BTCHENTRY,N':') AS EntryKey, p.ORGID AS CompanyScope, h.BATCHID AS BatchKey, h.BTCHENTRY AS EntryNumberKey, CONCAT(RTRIM(h.BATCHID),N' / ',RTRIM(h.BTCHENTRY)) AS JournalNumber, h.JRNLDESC, b.BTCHDESC, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) ELSE NULL END, 112) AS PostingDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112))), 8) ELSE NULL END, 112) AS DocumentDate, CONCAT(h.FSCSYR,N' / ',h.FSCSPERD) AS FiscalPeriod, CONCAT(h.SRCELEDGER,N'-',h.SRCETYPE) AS SourceCode, CASE b.BATCHSTAT WHEN '1' THEN N'Terbuka' WHEN '3' THEN N'Dihapus' WHEN '4' THEN N'Diposting' WHEN '6' THEN N'Diposting sementara' WHEN '8' THEN N'Sedang diposting' WHEN '9' THEN N'Siap diposting' WHEN 'A' THEN N'Sedang diposting sementara' ELSE CASE WHEN b.BATCHSTAT IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',b.BATCHSTAT) END END AS BatchStatus, CASE b.BATCHTYPE WHEN '1' THEN N'Dimasukkan' WHEN '2' THEN N'Subledger' WHEN '3' THEN N'Diimpor' WHEN '4' THEN N'Dibuat sistem' WHEN '5' THEN N'Berulang' ELSE CASE WHEN b.BATCHTYPE IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',b.BATCHTYPE) END END AS BatchType, h.DETAILCNT, CASE h.SWREVERSE WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Periode berikutnya' WHEN 2 THEN N'Periode tertentu' ELSE CASE WHEN h.SWREVERSE IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',h.SWREVERSE) END END AS ReverseMode, CASE WHEN h.SWREVERSE=2 THEN CONCAT(h.REVYR,N' / ',h.REVPERD) ELSE N'' END AS ReversalPeriod, CASE h.CLASSTYPE WHEN 0 THEN N'Standar' WHEN 1 THEN N'Pajak penjualan' WHEN 2 THEN N'Pajak pembelian' ELSE CASE WHEN h.CLASSTYPE IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',h.CLASSTYPE) END END AS EntryType, h.CODETAXGRP, p.HOMECUR AS FunctionalCurrency, b.ERRORCNT FROM dbo.GLJEH h INNER JOIN dbo.GLBCTL b ON b.BATCHID=h.BATCHID CROSS JOIN dbo.CSCOM p WHERE b.SWICT=0 AND (SELECT COUNT(*) FROM dbo.CSCOM q)=1 AND p.ORGID IS NOT NULL AND LTRIM(RTRIM(p.ORGID))<>N'' AND h.BATCHID IS NOT NULL AND h.BTCHENTRY IS NOT NULL AND (h.ORIGCOMP=N'' OR h.ORIGCOMP=p.ORGID) AND OBJECT_ID(N'dbo.GLJEH',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLJED',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLBCTL',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.CSCOM',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLAMF',N'U') IS NOT NULL AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) ELSE NULL END, 112)>=:date_from AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) ELSE NULL END, 112)<:date_until
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(LEN(CONCAT(p.ORGID,N'#')),N':',p.ORGID,N':',LEN(CONCAT(h.BATCHID,N'#')),N':',h.BATCHID,N':',LEN(CONCAT(h.BTCHENTRY,N'#')),N':',h.BTCHENTRY,N':',LEN(CONCAT(l.TRANSNBR,N'#')),N':',l.TRANSNBR,N':') AS LineKey, CONCAT(LEN(CONCAT(p.ORGID,N'#')),N':',p.ORGID,N':',LEN(CONCAT(h.BATCHID,N'#')),N':',h.BATCHID,N':',LEN(CONCAT(h.BTCHENTRY,N'#')),N':',h.BTCHENTRY,N':') AS ParentJournalKey, p.ORGID AS CompanyScope, h.BATCHID AS BatchKey, h.BTCHENTRY AS EntryNumberKey, l.TRANSNBR AS TransactionKey, l.ACCTID AS AccountKey, CONCAT(RTRIM(h.BATCHID),N' / ',RTRIM(h.BTCHENTRY)) AS JournalNumber, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) ELSE NULL END, 112) AS PostingDate, l.TRANSDESC, l.TRANSREF, a.ACCTFMTTD AS AccountNumber, a.ACCTDESC AS AccountName, CASE WHEN a.ACCTID IS NULL THEN N'Profil tidak tersedia / konteks tidak cocok' ELSE N'Profil terkini tersedia' END AS AccountProfileState, l.SCURNCODE AS SourceCurrency, l.SCURNAMT, l.HCURNCODE AS HomeCurrency, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112))), 8) ELSE NULL END, 112) AS TransactionDate, l.TRANSQTY, l.RATETYPE, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112))), 8) ELSE NULL END, 112) AS RateDate, l.CONVRATE, l.RATEOPER, CONCAT(l.SRCELDGR,N'-',l.SRCETYPE) AS LineSourceCode FROM dbo.GLJEH h INNER JOIN dbo.GLBCTL b ON b.BATCHID=h.BATCHID CROSS JOIN dbo.CSCOM p INNER JOIN dbo.GLJED l ON l.BATCHNBR=h.BATCHID AND l.JOURNALID=h.BTCHENTRY LEFT JOIN dbo.GLAMF a ON a.ACCTID=l.ACCTID AND (l.COMPANYID=N'' OR l.COMPANYID=p.ORGID) AND (l.DESCOMP=N'' OR l.DESCOMP=p.ORGID) AND (SELECT COUNT(*) FROM dbo.GLAMF z WHERE z.ACCTID=l.ACCTID)=1 WHERE b.SWICT=0 AND (SELECT COUNT(*) FROM dbo.CSCOM q)=1 AND p.ORGID IS NOT NULL AND LTRIM(RTRIM(p.ORGID))<>N'' AND h.BATCHID IS NOT NULL AND h.BTCHENTRY IS NOT NULL AND (h.ORIGCOMP=N'' OR h.ORIGCOMP=p.ORGID) AND OBJECT_ID(N'dbo.GLJEH',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLJED',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLBCTL',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.CSCOM',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLAMF',N'U') IS NOT NULL AND p.ORGID=:company AND h.BATCHID=:batch AND h.BTCHENTRY=:entry AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) ELSE NULL END, 112)=:posting_date AND l.TRANSNBR IS NOT NULL
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(LEN(CONCAT(p.ORGID,N'#')),N':',p.ORGID,N':',LEN(CONCAT(h.BATCHID,N'#')),N':',h.BATCHID,N':',LEN(CONCAT(h.BTCHENTRY,N'#')),N':',h.BTCHENTRY,N':',LEN(CONCAT(l.TRANSNBR,N'#')),N':',l.TRANSNBR,N':') AS AccountProfileKey, CONCAT(LEN(CONCAT(p.ORGID,N'#')),N':',p.ORGID,N':',LEN(CONCAT(h.BATCHID,N'#')),N':',h.BATCHID,N':',LEN(CONCAT(h.BTCHENTRY,N'#')),N':',h.BTCHENTRY,N':',LEN(CONCAT(l.TRANSNBR,N'#')),N':',l.TRANSNBR,N':') AS ParentLineKey, a.ACCTDESC, a.ACCTFMTTD, a.ACCTGRPCOD, CASE a.ACCTTYPE WHEN 'B' THEN N'Neraca' WHEN 'I' THEN N'Laba/rugi' WHEN 'R' THEN N'Laba ditahan' ELSE CASE WHEN a.ACCTTYPE IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',a.ACCTTYPE) END END AS AccountType, CASE a.ACCTBAL WHEN '1' THEN N'Debit' WHEN '2' THEN N'Kredit' ELSE CASE WHEN a.ACCTBAL IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',a.ACCTBAL) END END AS NormalSide, CASE a.ACTIVESW WHEN '0' THEN N'Tidak aktif' WHEN '1' THEN N'Aktif' ELSE CASE WHEN a.ACTIVESW IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',a.ACTIVESW) END END AS AccountActive, a.UOM, a.DEFCURNCOD FROM dbo.GLJEH h INNER JOIN dbo.GLBCTL b ON b.BATCHID=h.BATCHID CROSS JOIN dbo.CSCOM p INNER JOIN dbo.GLJED l ON l.BATCHNBR=h.BATCHID AND l.JOURNALID=h.BTCHENTRY LEFT JOIN dbo.GLAMF a ON a.ACCTID=l.ACCTID AND (l.COMPANYID=N'' OR l.COMPANYID=p.ORGID) AND (l.DESCOMP=N'' OR l.DESCOMP=p.ORGID) AND (SELECT COUNT(*) FROM dbo.GLAMF z WHERE z.ACCTID=l.ACCTID)=1 WHERE b.SWICT=0 AND (SELECT COUNT(*) FROM dbo.CSCOM q)=1 AND p.ORGID IS NOT NULL AND LTRIM(RTRIM(p.ORGID))<>N'' AND h.BATCHID IS NOT NULL AND h.BTCHENTRY IS NOT NULL AND (h.ORIGCOMP=N'' OR h.ORIGCOMP=p.ORGID) AND OBJECT_ID(N'dbo.GLJEH',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLJED',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLBCTL',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.CSCOM',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLAMF',N'U') IS NOT NULL AND p.ORGID=:company AND h.BATCHID=:batch AND h.BTCHENTRY=:entry AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) ELSE NULL END, 112)=:posting_date AND l.TRANSNBR=:transaction AND l.ACCTID=:account AND a.ACCTID IS NOT NULL
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 300 — SQL Server",
"id": "B5F96F01-AD77-58A3-B229-F4F23E4B9AAB",
"kind": "sqlServer",
"requiredObjects": [
"dbo.GLJEH",
"dbo.GLJED",
"dbo.GLBCTL",
"dbo.CSCOM",
"dbo.GLAMF"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "812134CB-FF51-5295-821E-A69E0102937E",
"key": "PostingDate",
"type": "date"
},
{
"direction": "ascending",
"id": "28208454-97DF-56AF-968F-43A5D7841192",
"key": "EntryKey",
"type": "text"
}
],
"id": "B0D62192-1FC1-5042-8058-8614876F0A4C",
"mappings": [
{
"commonFieldKey": "",
"key": "EntryKey",
"label": "Kunci jurnal internal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EntryKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyScope",
"label": "Kunci perusahaan internal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyScope",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BatchKey",
"label": "Kunci batch internal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BatchKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EntryNumberKey",
"label": "Kunci entri internal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EntryNumberKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JournalNumber",
"label": "Batch / nomor entri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JournalNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JRNLDESC",
"label": "Uraian jurnal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JRNLDESC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BTCHDESC",
"label": "Uraian batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BTCHDESC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingDate",
"label": "Tanggal post yang ditentukan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PostingDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocumentDate",
"label": "Tanggal dokumen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FiscalPeriod",
"label": "Tahun / periode fiskal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FiscalPeriod",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SourceCode",
"label": "Kode sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SourceCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BatchStatus",
"label": "Status batch Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BatchStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BatchType",
"label": "Jenis batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BatchType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DETAILCNT",
"label": "Jumlah rincian menurut header",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DETAILCNT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ReverseMode",
"label": "Pembalikan otomatis",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReverseMode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ReversalPeriod",
"label": "Periode pembalikan tertentu",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReversalPeriod",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EntryType",
"label": "Jenis entri pajak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EntryType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CODETAXGRP",
"label": "Kelompok pajak (kode)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CODETAXGRP",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FunctionalCurrency",
"label": "Mata uang buku dari profil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FunctionalCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ERRORCNT",
"label": "Jumlah kesalahan batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ERRORCNT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Jurnal GL",
"primaryKey": "EntryKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PostingDate",
"id": "364D1B5B-CEE4-5D0D-8BAE-6A11B6CF3770",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PostingDate",
"id": "A2EF0F69-6966-5E42-91B4-425F32A9751D",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"JournalNumber",
"JRNLDESC",
"BTCHDESC",
"FiscalPeriod",
"SourceCode",
"BatchStatus",
"BatchType",
"ReverseMode",
"ReversalPeriod",
"EntryType",
"CODETAXGRP",
"FunctionalCurrency"
],
"sourceID": "B5F96F01-AD77-58A3-B229-F4F23E4B9AAB",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(p.ORGID,N'#')),N':',p.ORGID,N':',LEN(CONCAT(h.BATCHID,N'#')),N':',h.BATCHID,N':',LEN(CONCAT(h.BTCHENTRY,N'#')),N':',h.BTCHENTRY,N':') AS EntryKey, p.ORGID AS CompanyScope, h.BATCHID AS BatchKey, h.BTCHENTRY AS EntryNumberKey, CONCAT(RTRIM(h.BATCHID),N' / ',RTRIM(h.BTCHENTRY)) AS JournalNumber, h.JRNLDESC, b.BTCHDESC, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) ELSE NULL END, 112) AS PostingDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DOCDATE, 112))), 8) ELSE NULL END, 112) AS DocumentDate, CONCAT(h.FSCSYR,N' / ',h.FSCSPERD) AS FiscalPeriod, CONCAT(h.SRCELEDGER,N'-',h.SRCETYPE) AS SourceCode, CASE b.BATCHSTAT WHEN '1' THEN N'Terbuka' WHEN '3' THEN N'Dihapus' WHEN '4' THEN N'Diposting' WHEN '6' THEN N'Diposting sementara' WHEN '8' THEN N'Sedang diposting' WHEN '9' THEN N'Siap diposting' WHEN 'A' THEN N'Sedang diposting sementara' ELSE CASE WHEN b.BATCHSTAT IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',b.BATCHSTAT) END END AS BatchStatus, CASE b.BATCHTYPE WHEN '1' THEN N'Dimasukkan' WHEN '2' THEN N'Subledger' WHEN '3' THEN N'Diimpor' WHEN '4' THEN N'Dibuat sistem' WHEN '5' THEN N'Berulang' ELSE CASE WHEN b.BATCHTYPE IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',b.BATCHTYPE) END END AS BatchType, h.DETAILCNT, CASE h.SWREVERSE WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Periode berikutnya' WHEN 2 THEN N'Periode tertentu' ELSE CASE WHEN h.SWREVERSE IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',h.SWREVERSE) END END AS ReverseMode, CASE WHEN h.SWREVERSE=2 THEN CONCAT(h.REVYR,N' / ',h.REVPERD) ELSE N'' END AS ReversalPeriod, CASE h.CLASSTYPE WHEN 0 THEN N'Standar' WHEN 1 THEN N'Pajak penjualan' WHEN 2 THEN N'Pajak pembelian' ELSE CASE WHEN h.CLASSTYPE IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',h.CLASSTYPE) END END AS EntryType, h.CODETAXGRP, p.HOMECUR AS FunctionalCurrency, b.ERRORCNT FROM dbo.GLJEH h INNER JOIN dbo.GLBCTL b ON b.BATCHID=h.BATCHID CROSS JOIN dbo.CSCOM p WHERE b.SWICT=0 AND (SELECT COUNT(*) FROM dbo.CSCOM q)=1 AND p.ORGID IS NOT NULL AND LTRIM(RTRIM(p.ORGID))<>N'' AND h.BATCHID IS NOT NULL AND h.BTCHENTRY IS NOT NULL AND (h.ORIGCOMP=N'' OR h.ORIGCOMP=p.ORGID) AND OBJECT_ID(N'dbo.GLJEH',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLJED',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLBCTL',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.CSCOM',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLAMF',N'U') IS NOT NULL AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) ELSE NULL END, 112)>=:date_from AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) ELSE NULL END, 112)<:date_until",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "8AD59C61-0BC9-5368-9383-54F2FBF6692C",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Kunci baris internal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentJournalKey",
"label": "Kunci jurnal induk",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentJournalKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompanyScope",
"label": "Kunci perusahaan internal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompanyScope",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BatchKey",
"label": "Kunci batch internal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BatchKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EntryNumberKey",
"label": "Kunci entri internal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EntryNumberKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionKey",
"label": "Kunci transaksi internal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountKey",
"label": "Kunci akun internal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JournalNumber",
"label": "Batch / nomor entri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JournalNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingDate",
"label": "Tanggal post yang ditentukan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PostingDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRANSDESC",
"label": "Uraian baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRANSDESC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TRANSREF",
"label": "Referensi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRANSREF",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountNumber",
"label": "Nomor akun terkini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountName",
"label": "Nama akun terkini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountProfileState",
"label": "Profil akun",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountProfileState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SourceCurrency",
"label": "Mata uang sumber baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SourceCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SCURNAMT",
"label": "Nilai sumber bertanda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SCURNAMT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HomeCurrency",
"label": "Mata uang home baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HomeCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionDate",
"label": "Tanggal baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TRANSQTY",
"label": "Kuantitas nonfinansial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TRANSQTY",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RATETYPE",
"label": "Jenis kurs (kode)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RATETYPE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RateDate",
"label": "Tanggal kurs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RateDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CONVRATE",
"label": "Kurs tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CONVRATE",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RATEOPER",
"label": "Operator kurs (kode)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RATEOPER",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineSourceCode",
"label": "Kode sumber baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineSourceCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Rincian jurnal",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CompanyScope",
"id": "8D2E27F3-FA33-5633-89BE-B26650DC258C",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "BatchKey",
"id": "170BD890-3EF5-5DFC-B1B6-47E66F6D7361",
"name": "batch",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "EntryNumberKey",
"id": "268F820C-C7CF-5950-94B0-BDE9AF41B58A",
"name": "entry",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PostingDate",
"id": "E39AFB8E-F907-55EF-8B4C-5F3067ABC5C4",
"name": "posting_date",
"source": "parentField",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"JournalNumber",
"TRANSDESC",
"TRANSREF",
"AccountNumber",
"AccountName",
"AccountProfileState",
"SourceCurrency",
"HomeCurrency",
"RATETYPE",
"RATEOPER",
"LineSourceCode"
],
"sourceID": "B5F96F01-AD77-58A3-B229-F4F23E4B9AAB",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(p.ORGID,N'#')),N':',p.ORGID,N':',LEN(CONCAT(h.BATCHID,N'#')),N':',h.BATCHID,N':',LEN(CONCAT(h.BTCHENTRY,N'#')),N':',h.BTCHENTRY,N':',LEN(CONCAT(l.TRANSNBR,N'#')),N':',l.TRANSNBR,N':') AS LineKey, CONCAT(LEN(CONCAT(p.ORGID,N'#')),N':',p.ORGID,N':',LEN(CONCAT(h.BATCHID,N'#')),N':',h.BATCHID,N':',LEN(CONCAT(h.BTCHENTRY,N'#')),N':',h.BTCHENTRY,N':') AS ParentJournalKey, p.ORGID AS CompanyScope, h.BATCHID AS BatchKey, h.BTCHENTRY AS EntryNumberKey, l.TRANSNBR AS TransactionKey, l.ACCTID AS AccountKey, CONCAT(RTRIM(h.BATCHID),N' / ',RTRIM(h.BTCHENTRY)) AS JournalNumber, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) ELSE NULL END, 112) AS PostingDate, l.TRANSDESC, l.TRANSREF, a.ACCTFMTTD AS AccountNumber, a.ACCTDESC AS AccountName, CASE WHEN a.ACCTID IS NULL THEN N'Profil tidak tersedia / konteks tidak cocok' ELSE N'Profil terkini tersedia' END AS AccountProfileState, l.SCURNCODE AS SourceCurrency, l.SCURNAMT, l.HCURNCODE AS HomeCurrency, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.TRANSDATE, 112))), 8) ELSE NULL END, 112) AS TransactionDate, l.TRANSQTY, l.RATETYPE, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.RATEDATE, 112))), 8) ELSE NULL END, 112) AS RateDate, l.CONVRATE, l.RATEOPER, CONCAT(l.SRCELDGR,N'-',l.SRCETYPE) AS LineSourceCode FROM dbo.GLJEH h INNER JOIN dbo.GLBCTL b ON b.BATCHID=h.BATCHID CROSS JOIN dbo.CSCOM p INNER JOIN dbo.GLJED l ON l.BATCHNBR=h.BATCHID AND l.JOURNALID=h.BTCHENTRY LEFT JOIN dbo.GLAMF a ON a.ACCTID=l.ACCTID AND (l.COMPANYID=N'' OR l.COMPANYID=p.ORGID) AND (l.DESCOMP=N'' OR l.DESCOMP=p.ORGID) AND (SELECT COUNT(*) FROM dbo.GLAMF z WHERE z.ACCTID=l.ACCTID)=1 WHERE b.SWICT=0 AND (SELECT COUNT(*) FROM dbo.CSCOM q)=1 AND p.ORGID IS NOT NULL AND LTRIM(RTRIM(p.ORGID))<>N'' AND h.BATCHID IS NOT NULL AND h.BTCHENTRY IS NOT NULL AND (h.ORIGCOMP=N'' OR h.ORIGCOMP=p.ORGID) AND OBJECT_ID(N'dbo.GLJEH',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLJED',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLBCTL',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.CSCOM',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLAMF',N'U') IS NOT NULL AND p.ORGID=:company AND h.BATCHID=:batch AND h.BTCHENTRY=:entry AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) ELSE NULL END, 112)=:posting_date AND l.TRANSNBR IS NOT NULL",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "ED8F1944-1425-5BCB-8E01-1C2914CC9744",
"key": "AccountProfileKey",
"type": "text"
}
],
"id": "CA5D253B-2425-5692-82A4-D11413DE1A40",
"mappings": [
{
"commonFieldKey": "",
"key": "AccountProfileKey",
"label": "Kunci profil internal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountProfileKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentLineKey",
"label": "Kunci baris induk",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentLineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACCTDESC",
"label": "Nama akun terkini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ACCTDESC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACCTFMTTD",
"label": "Nomor akun terkini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ACCTFMTTD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ACCTGRPCOD",
"label": "Kelompok akun (kode)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ACCTGRPCOD",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountType",
"label": "Jenis akun",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "NormalSide",
"label": "Saldo normal (pengaturan)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NormalSide",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountActive",
"label": "Status aktif akun",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountActive",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UOM",
"label": "Satuan kuantitas terkini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UOM",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DEFCURNCOD",
"label": "Mata uang default transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DEFCURNCOD",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Profil akun terkini",
"primaryKey": "AccountProfileKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CompanyScope",
"id": "8D2E27F3-FA33-5633-89BE-B26650DC258C",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "BatchKey",
"id": "170BD890-3EF5-5DFC-B1B6-47E66F6D7361",
"name": "batch",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "EntryNumberKey",
"id": "268F820C-C7CF-5950-94B0-BDE9AF41B58A",
"name": "entry",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PostingDate",
"id": "E39AFB8E-F907-55EF-8B4C-5F3067ABC5C4",
"name": "posting_date",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TransactionKey",
"id": "DC2C8FAC-529C-5C91-B869-FE22C6D6C4EC",
"name": "transaction",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "AccountKey",
"id": "34AB8CBF-E9B6-5A67-9D6E-FA7AE7CC207E",
"name": "account",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ACCTDESC",
"ACCTFMTTD",
"ACCTGRPCOD",
"AccountType",
"NormalSide",
"AccountActive",
"UOM",
"DEFCURNCOD"
],
"sourceID": "B5F96F01-AD77-58A3-B229-F4F23E4B9AAB",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(p.ORGID,N'#')),N':',p.ORGID,N':',LEN(CONCAT(h.BATCHID,N'#')),N':',h.BATCHID,N':',LEN(CONCAT(h.BTCHENTRY,N'#')),N':',h.BTCHENTRY,N':',LEN(CONCAT(l.TRANSNBR,N'#')),N':',l.TRANSNBR,N':') AS AccountProfileKey, CONCAT(LEN(CONCAT(p.ORGID,N'#')),N':',p.ORGID,N':',LEN(CONCAT(h.BATCHID,N'#')),N':',h.BATCHID,N':',LEN(CONCAT(h.BTCHENTRY,N'#')),N':',h.BTCHENTRY,N':',LEN(CONCAT(l.TRANSNBR,N'#')),N':',l.TRANSNBR,N':') AS ParentLineKey, a.ACCTDESC, a.ACCTFMTTD, a.ACCTGRPCOD, CASE a.ACCTTYPE WHEN 'B' THEN N'Neraca' WHEN 'I' THEN N'Laba/rugi' WHEN 'R' THEN N'Laba ditahan' ELSE CASE WHEN a.ACCTTYPE IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',a.ACCTTYPE) END END AS AccountType, CASE a.ACCTBAL WHEN '1' THEN N'Debit' WHEN '2' THEN N'Kredit' ELSE CASE WHEN a.ACCTBAL IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',a.ACCTBAL) END END AS NormalSide, CASE a.ACTIVESW WHEN '0' THEN N'Tidak aktif' WHEN '1' THEN N'Aktif' ELSE CASE WHEN a.ACTIVESW IS NULL THEN N'Tidak diketahui' ELSE CONCAT(N'Kode ',a.ACTIVESW) END END AS AccountActive, a.UOM, a.DEFCURNCOD FROM dbo.GLJEH h INNER JOIN dbo.GLBCTL b ON b.BATCHID=h.BATCHID CROSS JOIN dbo.CSCOM p INNER JOIN dbo.GLJED l ON l.BATCHNBR=h.BATCHID AND l.JOURNALID=h.BTCHENTRY LEFT JOIN dbo.GLAMF a ON a.ACCTID=l.ACCTID AND (l.COMPANYID=N'' OR l.COMPANYID=p.ORGID) AND (l.DESCOMP=N'' OR l.DESCOMP=p.ORGID) AND (SELECT COUNT(*) FROM dbo.GLAMF z WHERE z.ACCTID=l.ACCTID)=1 WHERE b.SWICT=0 AND (SELECT COUNT(*) FROM dbo.CSCOM q)=1 AND p.ORGID IS NOT NULL AND LTRIM(RTRIM(p.ORGID))<>N'' AND h.BATCHID IS NOT NULL AND h.BTCHENTRY IS NOT NULL AND (h.ORIGCOMP=N'' OR h.ORIGCOMP=p.ORGID) AND OBJECT_ID(N'dbo.GLJEH',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLJED',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLBCTL',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.CSCOM',N'U') IS NOT NULL AND OBJECT_ID(N'dbo.GLAMF',N'U') IS NOT NULL AND p.ORGID=:company AND h.BATCHID=:batch AND h.BTCHENTRY=:entry AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATEENTRY, 112))), 8) ELSE NULL END, 112)=:posting_date AND l.TRANSNBR=:transaction AND l.ACCTID=:account AND a.ACCTID IS NOT NULL",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "8C712580-9EAA-5339-8C11-3A2DDBBDDFB1",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "83518919-02FE-559A-90EB-39F0DCB137E5",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8AD59C61-0BC9-5368-9383-54F2FBF6692C",
"title": "Rincian jurnal",
"urlKey": ""
}
],
"badgeKey": "BatchStatus",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PostingDate",
"label": "Tanggal post yang ditentukan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FiscalPeriod",
"label": "Tahun / periode fiskal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SourceCode",
"label": "Kode sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BatchType",
"label": "Jenis batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DETAILCNT",
"label": "Jumlah rincian menurut header",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B0D62192-1FC1-5042-8058-8614876F0A4C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identitas dan status",
"detailRole": "information",
"isVisible": true,
"key": "JournalNumber",
"label": "Batch / nomor entri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identitas dan status",
"detailRole": "information",
"isVisible": true,
"key": "JRNLDESC",
"label": "Uraian jurnal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identitas dan status",
"detailRole": "information",
"isVisible": true,
"key": "BTCHDESC",
"label": "Uraian batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identitas dan status",
"detailRole": "information",
"isVisible": true,
"key": "BatchStatus",
"label": "Status batch Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identitas dan status",
"detailRole": "information",
"isVisible": true,
"key": "BatchType",
"label": "Jenis batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Tanggal dan periode",
"detailRole": "information",
"isVisible": true,
"key": "PostingDate",
"label": "Tanggal post yang ditentukan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Tanggal dan periode",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDate",
"label": "Tanggal dokumen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Tanggal dan periode",
"detailRole": "information",
"isVisible": true,
"key": "FiscalPeriod",
"label": "Tahun / periode fiskal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Tanggal dan periode",
"detailRole": "information",
"isVisible": true,
"key": "SourceCode",
"label": "Kode sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Tanggal dan periode",
"detailRole": "information",
"isVisible": true,
"key": "FunctionalCurrency",
"label": "Mata uang buku dari profil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Rincian dan pembalikan",
"detailRole": "information",
"isVisible": true,
"key": "DETAILCNT",
"label": "Jumlah rincian menurut header",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Rincian dan pembalikan",
"detailRole": "information",
"isVisible": true,
"key": "ReverseMode",
"label": "Pembalikan otomatis",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Rincian dan pembalikan",
"detailRole": "information",
"isVisible": true,
"key": "ReversalPeriod",
"label": "Periode pembalikan tertentu",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pajak dan pemeriksaan",
"detailRole": "information",
"isVisible": true,
"key": "EntryType",
"label": "Jenis entri pajak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pajak dan pemeriksaan",
"detailRole": "information",
"isVisible": true,
"key": "CODETAXGRP",
"label": "Kelompok pajak (kode)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pajak dan pemeriksaan",
"detailRole": "information",
"isVisible": true,
"key": "ERRORCNT",
"label": "Jumlah kesalahan batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "AC1C81AE-6843-5329-B28F-F922CB542971",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "17C703A9-C893-53AC-AFF4-DFC9D213F208",
"includeAllOption": false,
"key": "PostingDate",
"title": "Periode tanggal post yang ditentukan",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "812134CB-FF51-5295-821E-A69E0102937E",
"key": "PostingDate",
"type": "date"
},
{
"direction": "ascending",
"id": "28208454-97DF-56AF-968F-43A5D7841192",
"key": "EntryKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "JournalNumber",
"systemImage": "doc.text",
"title": "Jurnal GL",
"titleKey": "JRNLDESC"
},
{
"actions": [
{
"id": "4A296378-7830-5396-9C87-BA2B08DFF44B",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "50E99CC1-5655-55F0-AB2C-3C944C3728F6",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "CA5D253B-2425-5692-82A4-D11413DE1A40",
"title": "Profil akun terkini",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountName",
"label": "Nama akun terkini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SourceCurrency",
"label": "Mata uang sumber baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SCURNAMT",
"label": "Nilai sumber bertanda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransactionDate",
"label": "Tanggal baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TRANSREF",
"label": "Referensi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "8AD59C61-0BC9-5368-9383-54F2FBF6692C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Baris dan akun",
"detailRole": "information",
"isVisible": true,
"key": "TRANSDESC",
"label": "Uraian baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Baris dan akun",
"detailRole": "information",
"isVisible": true,
"key": "AccountNumber",
"label": "Nomor akun terkini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Baris dan akun",
"detailRole": "information",
"isVisible": true,
"key": "AccountName",
"label": "Nama akun terkini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Baris dan akun",
"detailRole": "information",
"isVisible": true,
"key": "AccountProfileState",
"label": "Profil akun",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Baris dan akun",
"detailRole": "information",
"isVisible": true,
"key": "TRANSREF",
"label": "Referensi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Jurnal dan tanggal",
"detailRole": "information",
"isVisible": true,
"key": "JournalNumber",
"label": "Batch / nomor entri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Jurnal dan tanggal",
"detailRole": "information",
"isVisible": true,
"key": "PostingDate",
"label": "Tanggal post yang ditentukan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Jurnal dan tanggal",
"detailRole": "information",
"isVisible": true,
"key": "TransactionDate",
"label": "Tanggal baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Jurnal dan tanggal",
"detailRole": "information",
"isVisible": true,
"key": "LineSourceCode",
"label": "Kode sumber baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nilai sumber dan kurs",
"detailRole": "information",
"isVisible": true,
"key": "SourceCurrency",
"label": "Mata uang sumber baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nilai sumber dan kurs",
"detailRole": "information",
"isVisible": true,
"key": "SCURNAMT",
"label": "Nilai sumber bertanda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nilai sumber dan kurs",
"detailRole": "information",
"isVisible": true,
"key": "HomeCurrency",
"label": "Mata uang home baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nilai sumber dan kurs",
"detailRole": "information",
"isVisible": true,
"key": "RATETYPE",
"label": "Jenis kurs (kode)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nilai sumber dan kurs",
"detailRole": "information",
"isVisible": true,
"key": "RateDate",
"label": "Tanggal kurs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nilai sumber dan kurs",
"detailRole": "information",
"isVisible": true,
"key": "CONVRATE",
"label": "Kurs tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nilai sumber dan kurs",
"detailRole": "information",
"isVisible": true,
"key": "RATEOPER",
"label": "Operator kurs (kode)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas nonfinansial",
"detailRole": "information",
"isVisible": true,
"key": "TRANSQTY",
"label": "Kuantitas nonfinansial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "C09FD886-FCE4-5A25-9361-9DD5204140C8",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountNumber",
"systemImage": "doc.text",
"title": "Rincian jurnal",
"titleKey": "TRANSDESC"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ACCTGRPCOD",
"label": "Kelompok akun (kode)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountType",
"label": "Jenis akun",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NormalSide",
"label": "Saldo normal (pengaturan)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountActive",
"label": "Status aktif akun",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "CA5D253B-2425-5692-82A4-D11413DE1A40",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identitas akun terkini",
"detailRole": "information",
"isVisible": true,
"key": "ACCTDESC",
"label": "Nama akun terkini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identitas akun terkini",
"detailRole": "information",
"isVisible": true,
"key": "ACCTFMTTD",
"label": "Nomor akun terkini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identitas akun terkini",
"detailRole": "information",
"isVisible": true,
"key": "ACCTGRPCOD",
"label": "Kelompok akun (kode)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pengaturan akun terkini",
"detailRole": "information",
"isVisible": true,
"key": "AccountType",
"label": "Jenis akun",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pengaturan akun terkini",
"detailRole": "information",
"isVisible": true,
"key": "NormalSide",
"label": "Saldo normal (pengaturan)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pengaturan akun terkini",
"detailRole": "information",
"isVisible": true,
"key": "AccountActive",
"label": "Status aktif akun",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pengaturan akun terkini",
"detailRole": "information",
"isVisible": true,
"key": "UOM",
"label": "Satuan kuantitas terkini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pengaturan akun terkini",
"detailRole": "information",
"isVisible": true,
"key": "DEFCURNCOD",
"label": "Mata uang default transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "BF2BAFD7-32C8-5347-9254-71302FE26134",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "ED8F1944-1425-5BCB-8E01-1C2914CC9744",
"key": "AccountProfileKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ACCTFMTTD",
"systemImage": "list.bullet.rectangle",
"title": "Profil akun terkini",
"titleKey": "ACCTDESC"
}
],
"relations": [
{
"childDatasetID": "8AD59C61-0BC9-5368-9383-54F2FBF6692C",
"childKey": "ParentJournalKey",
"id": "83518919-02FE-559A-90EB-39F0DCB137E5",
"name": "Rincian jurnal",
"parentDatasetID": "B0D62192-1FC1-5042-8058-8614876F0A4C",
"parentKey": "EntryKey"
},
{
"childDatasetID": "CA5D253B-2425-5692-82A4-D11413DE1A40",
"childKey": "ParentLineKey",
"id": "50E99CC1-5655-55F0-AB2C-3C944C3728F6",
"name": "Profil akun terkini",
"parentDatasetID": "8AD59C61-0BC9-5368-9383-54F2FBF6692C",
"parentKey": "LineKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sage 300",
"configurationLanguages": [
"id"
],
"countries": [
"ID"
],
"createdAt": "2026-10-08T00: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 akuntan, staf keuangan, dan manajer: pilih periode tanggal post yang ditentukan, lalu telusuri entri jurnal GL yang masih disimpan. Kartu memuat uraian, nomor batch/entri, status dan jenis batch, periode fiskal, kode sumber, dan jumlah rincian menurut header. Detil memuat tanggal dokumen, pembalikan, kelompok pajak, kesalahan batch, dan mata uang buku. Buka rincian untuk referensi, tanggal, nilai bertanda dan mata uang sumber tiap baris, kuantitas nonfinansial, serta kurs tersimpan. Tombol berikutnya membuka profil akun terkini dengan kelompok, klasifikasi, saldo normal, status aktif, satuan, dan mata uang default.\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: satu sumber SQL Server, tiga daftar, dua tombol bertingkat, dan SQL SELECT baca-saja. Subdaftar dibaca hanya saat dibuka, terikat perusahaan, batch, entri, tanggal header dan kunci baris lengkap; kunci internal tidak ditampilkan. Maksimum 1.000 baris per pembacaan, tanpa refresh berkala. Batas hasil bukan jaminan murah atau lengkap; periksa indeks, timeout dan pemberitahuan batas Cifru, lalu persempit periode bila perlu.\n\nCAKUPAN: tabel fisik GLJEH/GLJED dan GLBCTL Sage 300 AOM 2023, bukan daftar lengkap transaksi buku besar yang telah diposting. Batch terbuka, dihapus, diposting sementara, siap diposting dan diposting dibedakan menurut status native; status asing tidak ditebak. Riwayat yang telah dibersihkan tidak direkonstruksi. Jumlah rincian header bukan bukti semua baris tersimpan atau dimuat. Tanggal post adalah tanggal yang ditentukan di header, BUKAN waktu ketika posting benar-benar selesai; tahun/periode fiskal bukan bulan kalender. Hanya batch non-intercompany (SWICT=0), satu profil CSCOM, dan originator kosong atau sama dengan ID profil yang didukung. ID profil tidak diasumsikan sama dengan nama database. Profil akun tersedia hanya pada konteks baris perusahaan/destination kosong atau sama dengan profil, dengan tepat satu akun yang cocok. Ini pembatasan dukungan paket, bukan penetapan arti bisnis semua nilai kosong; konteks lain memerlukan pemetaan terpisah.\n\nNILAI DAN KURS: SCURNAMT ditampilkan apa adanya dengan SCURNCODE pada baris yang sama. Moneda kosong tetap kosong, bukan otomatis IDR. Nilai negatif, nol atau tidak tersedia dipertahankan; tidak ada ABS, pembagian debit/kredit buatan, konversi atau total lintas mata uang. TRANSAMT dan total uang header sengaja tidak ditampilkan karena denominasi fisik/konversi debit-kredit belum dibuktikan untuk laporan ini. HCURNCODE adalah kode home baris, HOMECUR berasal dari profil perusahaan; keduanya bukan pengganti mata uang sumber. Operator kurs ditampilkan sebagai kode tanpa menebak rumus perkalian/pembagian. Kuantitas nonfinansial bukan saldo uang atau stok; satuan akun merupakan pengaturan terkini, bukan bukti unit historis pada baris. Saldo normal akun bukan nilai saldo. Status aktif akun bukan jaminan izin posting dan default mata uang akun bukan mata uang buku.\n\nBATAS DAN KEAMANAN: ini konfigurasi komunitas tidak resmi untuk Sage 300 2023, bukan Sage 300 Construction and Real Estate. Memerlukan dbo, SQL Server 2012+ dan compatibility level 110+. AOM/API bukan DDL atau sertifikat tipe/index/FK SQL yang terpasang. Kunci TRANSNBR disimpan utuh; protokol native sequenced revisions tidak diganti dengan nomor baris buatan. Verifikasi kunci, revisi, jumlah baris, tanggal, owner dan kinerja saat impor pada versi Anda. Filter UI bukan kontrol akses dan akses SQL tidak mewarisi otomatis hak pengguna Sage. Gunakan akun SELECT minimum pada data yang memang diizinkan. Tidak ada fungsi posting, pembayaran, ekspor pajak tersertifikasi, server atau kredensial dalam paket. Captur DEMO menggunakan data sintetis saja.\n\nDokumentasi tabel: https://ca-kb.sage.com/portal/app/portlets/results/viewdocument.jsp?solutionid=232425080400014\nBantuan jurnal: https://help.sage300.com/en-us/2023/classic/Content/Financials/General_Ledger/Transactions/JournalEntry/AddingJournalEntry.htm\nProfil perusahaan: https://help.sage300.com/en-us/2023/classic/Content/SystemManager/CommonServices/SCREENS/CompanyProfile.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "1FA0D4F9-9B58-578C-8CC1-E41A2F464B6C",
"rootButtonCount": 1,
"summary": "Periode, status batch, rincian dengan mata uang sumber dan kurs, serta profil akun terkini.",
"tags": [
"Sage 300",
"SQL Server",
"Akuntansi",
"Jurnal",
"Pro"
],
"title": "Jurnal dan rincian akun — Pro"
}
}