Pesanan pelanggan lengkap — Pro
Periode pesanan, status, rincian kuantitas dan satuan, profil barang I/C dan mitra.
TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA. Berdasarkan dokumentasi resmi dan pengujian data sintetis. Saat impor, periksa versi, tabel, kolom, kunci, tipe tanggal, hasil dan izin bersama administrator Sage. Tangkapan layar native memakai data DEMO fiktif, tanpa koneksi ERP nyata.
Untuk staf penjualan dan pengiriman serta manajer: pilih periode tanggal pesanan sebelum membaca data. Lihat mitra, nomor, rencana kirim/tiba, mata uang, jenis, status penyelesaian dan blokir. Buka rincian pesanan untuk kuantitas, satuan, harga/biaya, lalu profil barang I/C bila tersedia. Tombol lain membuka profil mitra beserta kontak dan saldo dalam mata uang mitra. Saldo mitra bukan sisa pesanan. Rencana kirim/tiba bukan pengiriman/penerimaan yang sudah terjadi. Mencakup jenis aktif, mendatang dan berulang; penawaran tidak dicampur. Jumlah nilai barang dan biaya lain ditampilkan terpisah, bukan disebut total akhir termasuk pajak. Jumlah kirim saat ini, terkirim kumulatif dan backorder adalah nilai native yang berbeda. Satuan pesanan dan satuan harga beserta faktornya ditampilkan; tidak mengalikan harga dengan jumlah secara buta. Biaya lain tetap terlihat dan tidak dipaksakan menjadi barang I/C. Semua status selesai/ditahan yang masih tersimpan tetap terlihat, bukan hanya pesanan terbuka. Riwayat yang telah dibersihkan Sage tidak dapat dipulihkan oleh paket ini. Tidak menjumlahkan antar mata uang, tidak menghitung stok tersedia, aging, laba atau saldo historis. Setiap subdaftar dimuat saat dibuka dengan identitas pesanan/baris lengkap.
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, empat daftar, tiga relasi dan SQL baca-saja. Maksimum 2.000 baris per pembacaan; tanpa refresh berkala. Persempit periode bila batas tercapai. Batas hasil tidak menjamin scan murah; periksa indeks, rencana eksekusi dan timeout. Filter bukan kontrol keamanan; gunakan izin SELECT minimum yang disetujui perusahaan. Tidak ada server, kredensial atau baris bisnis dalam paket.
Sage 300 AOM 2023, SQL Server 2012+ compatibility 110+, skema dbo. Bukan Sage 300 Construction and Real Estate atau klaim kompatibilitas 2026. Adapter tanggal menerima YYYYMMDD, desimal nol atau tipe SQL date/datetime; tanggal rusak/format lain menjadi NULL dan tidak masuk periode. Dokumentasi: https://ca-kb.sage.com/portal/app/portlets/results/viewdocument.jsp?solutionid=232425080400014
Screenshots
What this package creates
1 Home3 Details4 lists1 sources to map
- Home: Pesanan pelanggan
- Details: Rincian pesanan
- Details: Profil barang I/C jika tersedia
- Details: Profil pelanggan
- Sub-button: Rincian pesanan pelanggan
- Sub-button: Profil barang I/C
- Sub-button: Profil pelanggan
Sources are mapped locally and verified before applying.
Custom queriesPRO4 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(h.ORDUNIQ, N'') AS OrderKey, h.ORDUNIQ AS OrderID, h.CUSTOMER AS PartnerCode, COALESCE(NULLIF(h.BILNAME, N''), p.NAMECUST, h.CUSTOMER) AS PartyName, h.ORDNUMBER AS OrderNumber, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 8) ELSE NULL END, 112) AS DocumentDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112))), 8) ELSE NULL END, 112) AS ExpectedDate, CASE h.TYPE WHEN 1 THEN N'Aktif' WHEN 2 THEN N'Mendatang' WHEN 3 THEN N'Berulang' WHEN 4 THEN N'Penawaran' ELSE N'Tidak diketahui' END AS OrderType, CASE h.COMPLETE WHEN 1 THEN N'Belum selesai (1)' WHEN 2 THEN N'Belum selesai (2)' WHEN 3 THEN N'Selesai (3)' WHEN 4 THEN N'Selesai (4)' WHEN 5 THEN N'Selesai / Day End' ELSE N'Tidak diketahui' END AS Completion, CASE h.ONHOLD WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE N'Tidak diketahui' END AS HoldState, h.ORSOURCURR AS Currency, h.REFERENCE, h.[DESC] AS Description, h.COMMENT, h.BILCITY AS CITY, h.BILCONTACT AS CONTACT, h.VIADESC AS Carrier, h.ORDTOTAL, h.ORDMTOTAL, h.ORDLINES, h.SHPNAME AS ShippingName, h.SHPCITY AS ShippingCity, h.SHPCOUNTRY AS ShippingCountry, h.PONUMBER AS CustomerPO FROM dbo.OEORDH h LEFT JOIN dbo.ARCUS p ON p.IDCUST = h.CUSTOMER WHERE h.TYPE IN (1,2,3) AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 8) ELSE NULL END, 112) >= :date_from AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 8) ELSE NULL END, 112) < :date_until
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(l.ORDUNIQ, N':', l.LINENUM) AS LineKey, CONCAT(l.ORDUNIQ, N'') AS OrderKey, l.ORDUNIQ AS OrderID, l.LINENUM AS LineID, h.CUSTOMER AS PartnerCode, h.ORDNUMBER AS OrderNumber, l.[DESC] AS LineDescription, CASE WHEN l.LINETYPE = 2 THEN l.MISCCHARGE ELSE l.ITEM END AS ItemCode, CASE l.LINETYPE WHEN 1 THEN N'Barang' WHEN 2 THEN N'Biaya lain' ELSE N'Tidak diketahui' END AS LineType, COALESCE(w.[DESC], l.LOCATION) AS LocationName, l.LOCATION, h.ORSOURCURR AS Currency, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112))), 8) ELSE NULL END, 112) AS ExpectedDate, CASE l.COMPLETE WHEN 0 THEN N'Belum selesai' WHEN 1 THEN N'Selesai / tidak tersimpan' WHEN 2 THEN N'Selesai' WHEN 3 THEN N'Diproses Day End' ELSE N'Tidak diketahui' END AS Completion, CASE WHEN i.ITEMNO IS NULL THEN N'Tidak tersedia' ELSE N'Tersedia' END AS ProductAvailability, i.STOCKUNIT AS StockUnit, l.ORDUNIT, l.QTYORDERED, l.QTYSHIPPED, l.QTYSHPTODT, l.QTYBACKORD, l.QTYCOMMIT, l.UNITPRICE, l.EXTOPRICE, l.PRICEUNIT, l.PRIUNTPRC, l.UNITCONV, l.PRIUNTCONV FROM dbo.OEORDD l INNER JOIN dbo.OEORDH h ON h.ORDUNIQ = l.ORDUNIQ LEFT JOIN dbo.ICITEM i ON l.LINETYPE = 1 AND i.ITEMNO = l.ITEM LEFT JOIN dbo.ICLOC w ON w.LOCATION = l.LOCATION WHERE h.ORDUNIQ = :order_id AND h.ORDNUMBER = :document AND h.CUSTOMER = :partner AND h.TYPE IN (1,2,3)
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(l.ORDUNIQ, N':', l.LINENUM) AS LineKey, i.ITEMNO, i.[DESC], i.FMTITEMNO, i.CATEGORY, i.INACTIVE, i.STOCKITEM, i.STOCKUNIT, i.UNITWGT, i.WEIGHTUNIT, i.SELLABLE, i.SERIALNO, i.LOTITEM, i.COMMENT1, i.COMMENT2 FROM dbo.OEORDD l INNER JOIN dbo.OEORDH h ON h.ORDUNIQ = l.ORDUNIQ INNER JOIN dbo.ICITEM i ON l.LINETYPE = 1 AND i.ITEMNO = l.ITEM WHERE h.ORDUNIQ = :order_id AND h.ORDNUMBER = :document AND h.CUSTOMER = :partner AND h.TYPE IN (1,2,3) AND l.LINENUM = :line_id
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.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": "6AB8C1EE-7DB3-59C8-8714-97AF7D1C7318",
"kind": "sqlServer",
"requiredObjects": [
"dbo.ARCUS",
"dbo.ICITEM",
"dbo.ICLOC",
"dbo.OEORDD",
"dbo.OEORDH"
],
"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": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"id": "7720DE43-CB21-5B85-8FC1-5FDFDDF9A7C0",
"mappings": [
{
"commonFieldKey": "",
"key": "OrderKey",
"label": "Kunci pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderID",
"label": "ID pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartnerCode",
"label": "Kunci mitra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PartnerCode",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartyName",
"label": "Mitra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PartyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderNumber",
"label": "Nomor pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocumentDate",
"label": "Tanggal pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ExpectedDate",
"label": "Rencana kirim / tiba",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ExpectedDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderType",
"label": "Jenis pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Completion",
"label": "Status penyelesaian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Completion",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HoldState",
"label": "Ditahan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HoldState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Currency",
"label": "Mata uang pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Currency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "REFERENCE",
"label": "Referensi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "REFERENCE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Keterangan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMMENT",
"label": "Catatan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "COMMENT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CITY",
"label": "Kota pada pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CITY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CONTACT",
"label": "Kontak pada pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CONTACT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Carrier",
"label": "Pengiriman melalui",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Carrier",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORDTOTAL",
"label": "Jumlah nilai barang — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDTOTAL",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ORDMTOTAL",
"label": "Jumlah biaya lain — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDMTOTAL",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ORDLINES",
"label": "Jumlah baris Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDLINES",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShippingName",
"label": "Nama tujuan kirim",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ShippingName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShippingCity",
"label": "Kota tujuan kirim",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ShippingCity",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShippingCountry",
"label": "Negara tujuan kirim",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ShippingCountry",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerPO",
"label": "Nomor PO pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerPO",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Pesanan pelanggan",
"primaryKey": "OrderKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocumentDate",
"id": "1ACB0E7C-D62E-57A2-A87D-F062859FF4A3",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocumentDate",
"id": "C4690E91-5234-5444-A3C4-64BD181D9E36",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"PartyName",
"OrderNumber",
"OrderType",
"Completion",
"HoldState",
"Currency",
"REFERENCE",
"Description",
"COMMENT",
"CITY",
"CONTACT",
"Carrier",
"ShippingName",
"ShippingCity",
"ShippingCountry",
"CustomerPO"
],
"sourceID": "6AB8C1EE-7DB3-59C8-8714-97AF7D1C7318",
"sqlQuery": "SELECT CONCAT(h.ORDUNIQ, N'') AS OrderKey, h.ORDUNIQ AS OrderID, h.CUSTOMER AS PartnerCode, COALESCE(NULLIF(h.BILNAME, N''), p.NAMECUST, h.CUSTOMER) AS PartyName, h.ORDNUMBER AS OrderNumber, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 8) ELSE NULL END, 112) AS DocumentDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPDATE, 112))), 8) ELSE NULL END, 112) AS ExpectedDate, CASE h.TYPE WHEN 1 THEN N'Aktif' WHEN 2 THEN N'Mendatang' WHEN 3 THEN N'Berulang' WHEN 4 THEN N'Penawaran' ELSE N'Tidak diketahui' END AS OrderType, CASE h.COMPLETE WHEN 1 THEN N'Belum selesai (1)' WHEN 2 THEN N'Belum selesai (2)' WHEN 3 THEN N'Selesai (3)' WHEN 4 THEN N'Selesai (4)' WHEN 5 THEN N'Selesai / Day End' ELSE N'Tidak diketahui' END AS Completion, CASE h.ONHOLD WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE N'Tidak diketahui' END AS HoldState, h.ORSOURCURR AS Currency, h.REFERENCE, h.[DESC] AS Description, h.COMMENT, h.BILCITY AS CITY, h.BILCONTACT AS CONTACT, h.VIADESC AS Carrier, h.ORDTOTAL, h.ORDMTOTAL, h.ORDLINES, h.SHPNAME AS ShippingName, h.SHPCITY AS ShippingCity, h.SHPCOUNTRY AS ShippingCountry, h.PONUMBER AS CustomerPO FROM dbo.OEORDH h LEFT JOIN dbo.ARCUS p ON p.IDCUST = h.CUSTOMER WHERE h.TYPE IN (1,2,3) AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 8) ELSE NULL END, 112) >= :date_from AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.ORDDATE, 112))), 8) ELSE NULL END, 112) < :date_until",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "30A9FCED-D1D3-5CFF-92BB-1381C3DC6A99",
"key": "LineID",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "C3F955EB-5832-5982-9CAF-102D16CDABB7",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Kunci baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderKey",
"label": "Kunci pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderID",
"label": "ID pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineID",
"label": "ID baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartnerCode",
"label": "Kunci mitra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PartnerCode",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderNumber",
"label": "Nomor pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineDescription",
"label": "Uraian baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineDescription",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Kode barang / biaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineType",
"label": "Jenis baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineType",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LocationName",
"label": "Lokasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LocationName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LOCATION",
"label": "Kode lokasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LOCATION",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Currency",
"label": "Mata uang pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Currency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ExpectedDate",
"label": "Rencana kirim / tiba",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ExpectedDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Completion",
"label": "Status penyelesaian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Completion",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductAvailability",
"label": "Profil barang I/C",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StockUnit",
"label": "Satuan persediaan I/C",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StockUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ORDUNIT",
"label": "Satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDUNIT",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QTYORDERED",
"label": "Jumlah dipesan — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTYORDERED",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QTYSHIPPED",
"label": "Jumlah kirim saat ini — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTYSHIPPED",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QTYSHPTODT",
"label": "Jumlah terkirim kumulatif — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTYSHPTODT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QTYBACKORD",
"label": "Backorder native — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTYBACKORD",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QTYCOMMIT",
"label": "Jumlah dialokasikan Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QTYCOMMIT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UNITPRICE",
"label": "Harga per satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UNITPRICE",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EXTOPRICE",
"label": "Nilai baris pesanan — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EXTOPRICE",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRICEUNIT",
"label": "Satuan harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRICEUNIT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRIUNTPRC",
"label": "Harga per satuan harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRIUNTPRC",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UNITCONV",
"label": "Faktor satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UNITCONV",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRIUNTCONV",
"label": "Faktor satuan harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PRIUNTCONV",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Rincian pesanan pelanggan",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderID",
"id": "B5035A78-92EA-56B3-9A3F-C1C011FD15A4",
"name": "order_id",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderNumber",
"id": "E2B8EFCD-EAFE-5E47-8C04-F515F809AC71",
"name": "document",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartnerCode",
"id": "E0D5F6CC-01AF-552E-A470-ACB634DB05FD",
"name": "partner",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"OrderNumber",
"LineDescription",
"ItemCode",
"LineType",
"LocationName",
"LOCATION",
"Currency",
"Completion",
"ProductAvailability",
"StockUnit",
"ORDUNIT",
"PRICEUNIT"
],
"sourceID": "6AB8C1EE-7DB3-59C8-8714-97AF7D1C7318",
"sqlQuery": "SELECT CONCAT(l.ORDUNIQ, N':', l.LINENUM) AS LineKey, CONCAT(l.ORDUNIQ, N'') AS OrderKey, l.ORDUNIQ AS OrderID, l.LINENUM AS LineID, h.CUSTOMER AS PartnerCode, h.ORDNUMBER AS OrderNumber, l.[DESC] AS LineDescription, CASE WHEN l.LINETYPE = 2 THEN l.MISCCHARGE ELSE l.ITEM END AS ItemCode, CASE l.LINETYPE WHEN 1 THEN N'Barang' WHEN 2 THEN N'Biaya lain' ELSE N'Tidak diketahui' END AS LineType, COALESCE(w.[DESC], l.LOCATION) AS LocationName, l.LOCATION, h.ORSOURCURR AS Currency, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPDATE, 112))), 8) ELSE NULL END, 112) AS ExpectedDate, CASE l.COMPLETE WHEN 0 THEN N'Belum selesai' WHEN 1 THEN N'Selesai / tidak tersimpan' WHEN 2 THEN N'Selesai' WHEN 3 THEN N'Diproses Day End' ELSE N'Tidak diketahui' END AS Completion, CASE WHEN i.ITEMNO IS NULL THEN N'Tidak tersedia' ELSE N'Tersedia' END AS ProductAvailability, i.STOCKUNIT AS StockUnit, l.ORDUNIT, l.QTYORDERED, l.QTYSHIPPED, l.QTYSHPTODT, l.QTYBACKORD, l.QTYCOMMIT, l.UNITPRICE, l.EXTOPRICE, l.PRICEUNIT, l.PRIUNTPRC, l.UNITCONV, l.PRIUNTCONV FROM dbo.OEORDD l INNER JOIN dbo.OEORDH h ON h.ORDUNIQ = l.ORDUNIQ LEFT JOIN dbo.ICITEM i ON l.LINETYPE = 1 AND i.ITEMNO = l.ITEM LEFT JOIN dbo.ICLOC w ON w.LOCATION = l.LOCATION WHERE h.ORDUNIQ = :order_id AND h.ORDNUMBER = :document AND h.CUSTOMER = :partner AND h.TYPE IN (1,2,3)",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "DE4E3706-B1BE-5814-8007-4C20E785E2E6",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Kunci baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ITEMNO",
"label": "Kode internal barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ITEMNO",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DESC",
"label": "Nama barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DESC",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FMTITEMNO",
"label": "Kode barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FMTITEMNO",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CATEGORY",
"label": "Kategori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CATEGORY",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "INACTIVE",
"label": "Nonaktif (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "INACTIVE",
"type": "boolean",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STOCKITEM",
"label": "Barang persediaan (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STOCKITEM",
"type": "boolean",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "STOCKUNIT",
"label": "Satuan persediaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "STOCKUNIT",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UNITWGT",
"label": "Berat per satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UNITWGT",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "WEIGHTUNIT",
"label": "Satuan berat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WEIGHTUNIT",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SELLABLE",
"label": "Dapat dijual (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SELLABLE",
"type": "boolean",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SERIALNO",
"label": "Menggunakan nomor seri (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SERIALNO",
"type": "boolean",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LOTITEM",
"label": "Menggunakan nomor lot (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LOTITEM",
"type": "boolean",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMMENT1",
"label": "Catatan 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "COMMENT1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "COMMENT2",
"label": "Catatan 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "COMMENT2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Profil barang I/C",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderID",
"id": "B5035A78-92EA-56B3-9A3F-C1C011FD15A4",
"name": "order_id",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderNumber",
"id": "E2B8EFCD-EAFE-5E47-8C04-F515F809AC71",
"name": "document",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartnerCode",
"id": "E0D5F6CC-01AF-552E-A470-ACB634DB05FD",
"name": "partner",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "LineID",
"id": "0BEE8440-03D7-5964-9526-BAA62948BC49",
"name": "line_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DESC",
"FMTITEMNO",
"CATEGORY",
"STOCKUNIT",
"WEIGHTUNIT",
"COMMENT1",
"COMMENT2"
],
"sourceID": "6AB8C1EE-7DB3-59C8-8714-97AF7D1C7318",
"sqlQuery": "SELECT CONCAT(l.ORDUNIQ, N':', l.LINENUM) AS LineKey, i.ITEMNO, i.[DESC], i.FMTITEMNO, i.CATEGORY, i.INACTIVE, i.STOCKITEM, i.STOCKUNIT, i.UNITWGT, i.WEIGHTUNIT, i.SELLABLE, i.SERIALNO, i.LOTITEM, i.COMMENT1, i.COMMENT2 FROM dbo.OEORDD l INNER JOIN dbo.OEORDH h ON h.ORDUNIQ = l.ORDUNIQ INNER JOIN dbo.ICITEM i ON l.LINETYPE = 1 AND i.ITEMNO = l.ITEM WHERE h.ORDUNIQ = :order_id AND h.ORDNUMBER = :document AND h.CUSTOMER = :partner AND h.TYPE IN (1,2,3) AND l.LINENUM = :line_id",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "F5EF6A6A-7F5F-5CCD-9991-7FE1D7154BC3",
"key": "IDCUST",
"type": "text"
}
],
"id": "25163386-F840-5C82-A2C6-58A390543336",
"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": "0283EE11-C2D1-58D8-98B2-2A17F05A6AF1",
"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": "6AB8C1EE-7DB3-59C8-8714-97AF7D1C7318",
"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": "C831CAC8-25DC-50DC-A124-5BC942ABD8BF",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "EA030CE4-C5B3-5DC5-A7CD-6F50CD17E3E7",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "C3F955EB-5832-5982-9CAF-102D16CDABB7",
"title": "Rincian pesanan",
"urlKey": ""
},
{
"id": "3EFF484B-145E-5BFA-92E8-DC119A49FDFD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "C2103C57-9F8D-5503-945F-71C7228D31FB",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "25163386-F840-5C82-A2C6-58A390543336",
"title": "Profil pelanggan",
"urlKey": ""
}
],
"badgeKey": "Completion",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDate",
"label": "Tanggal pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ExpectedDate",
"label": "Rencana kirim / tiba",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderType",
"label": "Jenis pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HoldState",
"label": "Ditahan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORDTOTAL",
"label": "Jumlah nilai barang — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORDMTOTAL",
"label": "Jumlah biaya lain — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "7720DE43-CB21-5B85-8FC1-5FDFDDF9A7C0",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PartyName",
"label": "Mitra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderNumber",
"label": "Nomor pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDate",
"label": "Tanggal pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ExpectedDate",
"label": "Rencana kirim / tiba",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderType",
"label": "Jenis pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Completion",
"label": "Status penyelesaian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HoldState",
"label": "Ditahan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "REFERENCE",
"label": "Referensi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Keterangan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "COMMENT",
"label": "Catatan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CITY",
"label": "Kota pada pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CONTACT",
"label": "Kontak pada pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Carrier",
"label": "Pengiriman melalui",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORDTOTAL",
"label": "Jumlah nilai barang — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORDMTOTAL",
"label": "Jumlah biaya lain — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORDLINES",
"label": "Jumlah baris Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ShippingName",
"label": "Nama tujuan kirim",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ShippingCity",
"label": "Kota tujuan kirim",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ShippingCountry",
"label": "Negara tujuan kirim",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CustomerPO",
"label": "Nomor PO pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"icon": "cart",
"id": "D98C14E1-9040-5656-8242-06D32EB01E1C",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "78E15A1F-AD8E-5821-87C7-32F8218B46CC",
"includeAllOption": false,
"key": "DocumentDate",
"title": "Periode pesanan",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "EC6CD31E-FABB-5268-AD3A-FF52AD2D2F7E",
"key": "DocumentDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "OrderNumber",
"systemImage": "doc.text",
"title": "Pesanan pelanggan",
"titleKey": "PartyName"
},
{
"actions": [
{
"id": "B046D0EF-B8EC-555C-8307-FA9A5880DC4D",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "85BE7E68-FECD-533F-8C1C-D508234E3698",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "DE4E3706-B1BE-5814-8007-4C20E785E2E6",
"title": "Profil barang I/C jika tersedia",
"urlKey": ""
}
],
"badgeKey": "Completion",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineType",
"label": "Jenis baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LocationName",
"label": "Lokasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORDUNIT",
"label": "Satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYORDERED",
"label": "Jumlah dipesan — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYSHPTODT",
"label": "Jumlah terkirim kumulatif — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYBACKORD",
"label": "Backorder native — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "C3F955EB-5832-5982-9CAF-102D16CDABB7",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderNumber",
"label": "Nomor pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineDescription",
"label": "Uraian baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Kode barang / biaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineType",
"label": "Jenis baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LocationName",
"label": "Lokasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LOCATION",
"label": "Kode lokasi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ExpectedDate",
"label": "Rencana kirim / tiba",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Completion",
"label": "Status penyelesaian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ProductAvailability",
"label": "Profil barang I/C",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StockUnit",
"label": "Satuan persediaan I/C",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORDUNIT",
"label": "Satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYORDERED",
"label": "Jumlah dipesan — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYSHIPPED",
"label": "Jumlah kirim saat ini — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYSHPTODT",
"label": "Jumlah terkirim kumulatif — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYBACKORD",
"label": "Backorder native — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QTYCOMMIT",
"label": "Jumlah dialokasikan Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UNITPRICE",
"label": "Harga per satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EXTOPRICE",
"label": "Nilai baris pesanan — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PRICEUNIT",
"label": "Satuan harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PRIUNTPRC",
"label": "Harga per satuan harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UNITCONV",
"label": "Faktor satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PRIUNTCONV",
"label": "Faktor satuan harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "945AE452-265A-57E0-80D5-5F02E0089DD3",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "30A9FCED-D1D3-5CFF-92BB-1381C3DC6A99",
"key": "LineID",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemCode",
"systemImage": "doc.text",
"title": "Rincian pesanan pelanggan",
"titleKey": "LineDescription"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CATEGORY",
"label": "Kategori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "STOCKUNIT",
"label": "Satuan persediaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UNITWGT",
"label": "Berat per satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WEIGHTUNIT",
"label": "Satuan berat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "DE4E3706-B1BE-5814-8007-4C20E785E2E6",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DESC",
"label": "Nama barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FMTITEMNO",
"label": "Kode barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CATEGORY",
"label": "Kategori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "INACTIVE",
"label": "Nonaktif (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "STOCKITEM",
"label": "Barang persediaan (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "STOCKUNIT",
"label": "Satuan persediaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UNITWGT",
"label": "Berat per satuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WEIGHTUNIT",
"label": "Satuan berat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SELLABLE",
"label": "Dapat dijual (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SERIALNO",
"label": "Menggunakan nomor seri (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LOTITEM",
"label": "Menggunakan nomor lot (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "COMMENT1",
"label": "Catatan 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "COMMENT2",
"label": "Catatan 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "9EA3CB38-DDAF-5807-990A-A06BC7EF2D7B",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "FMTITEMNO",
"systemImage": "doc.text",
"title": "Profil barang I/C",
"titleKey": "DESC"
},
{
"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": "25163386-F840-5C82-A2C6-58A390543336",
"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": "66398067-3BA6-5B17-9D54-F54ADD11A1A4",
"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": "C3F955EB-5832-5982-9CAF-102D16CDABB7",
"childKey": "OrderKey",
"id": "EA030CE4-C5B3-5DC5-A7CD-6F50CD17E3E7",
"name": "Rincian pesanan",
"parentDatasetID": "7720DE43-CB21-5B85-8FC1-5FDFDDF9A7C0",
"parentKey": "OrderKey"
},
{
"childDatasetID": "DE4E3706-B1BE-5814-8007-4C20E785E2E6",
"childKey": "LineKey",
"id": "85BE7E68-FECD-533F-8C1C-D508234E3698",
"name": "Profil barang I/C jika tersedia",
"parentDatasetID": "C3F955EB-5832-5982-9CAF-102D16CDABB7",
"parentKey": "LineKey"
},
{
"childDatasetID": "25163386-F840-5C82-A2C6-58A390543336",
"childKey": "IDCUST",
"id": "C2103C57-9F8D-5503-945F-71C7228D31FB",
"name": "Profil pelanggan",
"parentDatasetID": "7720DE43-CB21-5B85-8FC1-5FDFDDF9A7C0",
"parentKey": "PartnerCode"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sage 300",
"configurationLanguages": [
"id"
],
"countries": [
"ID"
],
"createdAt": "2026-10-03T00:00:00Z",
"description": "TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA. Berdasarkan dokumentasi resmi dan pengujian data sintetis. Saat impor, periksa versi, tabel, kolom, kunci, tipe tanggal, hasil dan izin bersama administrator Sage. Tangkapan layar native memakai data DEMO fiktif, tanpa koneksi ERP nyata.\n\nUntuk staf penjualan dan pengiriman serta manajer: pilih periode tanggal pesanan sebelum membaca data. Lihat mitra, nomor, rencana kirim/tiba, mata uang, jenis, status penyelesaian dan blokir. Buka rincian pesanan untuk kuantitas, satuan, harga/biaya, lalu profil barang I/C bila tersedia. Tombol lain membuka profil mitra beserta kontak dan saldo dalam mata uang mitra. Saldo mitra bukan sisa pesanan. Rencana kirim/tiba bukan pengiriman/penerimaan yang sudah terjadi. Mencakup jenis aktif, mendatang dan berulang; penawaran tidak dicampur. Jumlah nilai barang dan biaya lain ditampilkan terpisah, bukan disebut total akhir termasuk pajak. Jumlah kirim saat ini, terkirim kumulatif dan backorder adalah nilai native yang berbeda. Satuan pesanan dan satuan harga beserta faktornya ditampilkan; tidak mengalikan harga dengan jumlah secara buta. Biaya lain tetap terlihat dan tidak dipaksakan menjadi barang I/C. Semua status selesai/ditahan yang masih tersimpan tetap terlihat, bukan hanya pesanan terbuka. Riwayat yang telah dibersihkan Sage tidak dapat dipulihkan oleh paket ini. Tidak menjumlahkan antar mata uang, tidak menghitung stok tersedia, aging, laba atau saldo historis. Setiap subdaftar dimuat saat dibuka dengan identitas pesanan/baris lengkap.\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, empat daftar, tiga relasi dan SQL baca-saja. Maksimum 2.000 baris per pembacaan; tanpa refresh berkala. Persempit periode bila batas tercapai. Batas hasil tidak menjamin scan murah; periksa indeks, rencana eksekusi dan timeout. Filter bukan kontrol keamanan; gunakan izin SELECT minimum yang disetujui perusahaan. Tidak ada server, kredensial atau baris bisnis dalam paket.\n\nSage 300 AOM 2023, SQL Server 2012+ compatibility 110+, skema dbo. Bukan Sage 300 Construction and Real Estate atau klaim kompatibilitas 2026. Adapter tanggal menerima YYYYMMDD, desimal nol atau tipe SQL date/datetime; tanggal rusak/format lain menjadi NULL dan tidak masuk periode. 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": "5A565DFD-D9AB-55DA-80AB-001BEF2EECF7",
"rootButtonCount": 1,
"summary": "Periode pesanan, status, rincian kuantitas dan satuan, profil barang I/C dan mitra.",
"tags": [
"Sage 300",
"SQL Server",
"Pesanan",
"pelanggan",
"Pro"
],
"title": "Pesanan pelanggan lengkap — Pro"
}
}