Pesanan pemasok 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 pembelian dan penerimaan 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, berulang, mendatang dan blanket. Kuantitas OQ memakai satuan pesanan; SQ memakai satuan persediaan I/C yang ditampilkan. Sisa, pembatalan dan penerimaan lebih dibaca dari kolom native; tidak dihitung ulang dengan asumsi konversi. Nilai sebelum pajak, pajak termasuk/di luar biaya, total pajak, diskon dan total pesanan ditampilkan terpisah; pajak termasuk biaya tidak ditambahkan lagi. Barang non-inventory atau sumber daya proyek tanpa profil I/C tetap terlihat pada rincian; subdaftar profil I/C akan kosong. 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 pemasok
- Details: Rincian pesanan
- Details: Profil barang I/C jika tersedia
- Details: Profil pemasok
- Sub-button: Rincian pesanan pemasok
- Sub-button: Profil barang I/C
- Sub-button: Profil pemasok
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.PORHSEQ, N'') AS OrderKey, h.PORHSEQ AS OrderID, h.VDCODE AS PartnerCode, COALESCE(NULLIF(h.VDNAME, N''), p.VENDNAME, h.VDCODE) AS PartyName, h.PONUMBER AS OrderNumber, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 8) ELSE NULL END, 112) AS DocumentDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112))), 8) ELSE NULL END, 112) AS ExpectedDate, CASE h.PORTYPE WHEN 1 THEN N'Aktif' WHEN 2 THEN N'Berulang' WHEN 3 THEN N'Mendatang' WHEN 4 THEN N'Blanket' ELSE N'Tidak diketahui' END AS OrderType, CASE h.ISCOMPLETE WHEN 0 THEN N'Belum selesai' WHEN 1 THEN N'Selesai' 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.CURRENCY AS Currency, h.REFERENCE, h.DESCRIPTIO AS Description, h.COMMENT, h.VDCITY AS CITY, h.VDCONTACT AS CONTACT, h.VIANAME AS Carrier, h.DOCTOTAL, h.EXTENDED, h.DISCOUNT, h.TAXAMOUNT, h.TXBASEALLO, h.TXINCLUDED, h.TXEXCLUDED, h.RCPCOUNT FROM dbo.POPORH1 h LEFT JOIN dbo.APVEN p ON p.VENDORID = h.VDCODE WHERE h.PORTYPE IN (1,2,3,4) AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 8) ELSE NULL END, 112) >= :date_from AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 8) ELSE NULL END, 112) < :date_until
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(l.PORHSEQ, N':', l.PORLREV) AS LineKey, CONCAT(l.PORHSEQ, N'') AS OrderKey, l.PORHSEQ AS OrderID, l.PORLREV AS LineID, h.VDCODE AS PartnerCode, h.PONUMBER AS OrderNumber, l.ITEMDESC AS LineDescription, l.ITEMNO AS ItemCode, CASE WHEN l.ITEMEXISTS = 1 THEN N'Barang I/C' WHEN l.ITEMEXISTS = 0 THEN N'Tanpa profil I/C' ELSE N'Tidak diketahui' END AS LineType, COALESCE(w.[DESC], l.LOCATION) AS LocationName, l.LOCATION, h.CURRENCY AS Currency, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112))), 8) ELSE NULL END, 112) AS ExpectedDate, CASE l.COMPLETION WHEN 1 THEN N'Belum selesai' WHEN 2 THEN N'Selesai (2)' WHEN 3 THEN N'Selesai (3)' 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.ORDERUNIT, l.ORDERCONV, l.OQORDERED, l.OQRECEIVED, l.OQCANCELED, l.OQOUTSTAND, l.OQRCPEXTRA, l.SQORDERED, l.SQRECEIVED, l.SQCANCELED, l.SQOUTSTAND, l.UNITCOST, l.EXTENDED, l.DISCPCT, l.DISCOUNT, l.TXBASEALLO, l.TAXAMOUNT, l.TXINCLUDED, l.TXEXCLUDED, l.VENDITEMNO FROM dbo.POPORL l INNER JOIN dbo.POPORH1 h ON h.PORHSEQ = l.PORHSEQ LEFT JOIN dbo.ICITEM i ON l.ITEMEXISTS = 1 AND i.ITEMNO = l.ITEMNO LEFT JOIN dbo.ICLOC w ON w.LOCATION = l.LOCATION WHERE h.PORHSEQ = :order_id AND h.PONUMBER = :document AND h.VDCODE = :partner AND h.PORTYPE IN (1,2,3,4)
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(l.PORHSEQ, N':', l.PORLREV) 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.POPORL l INNER JOIN dbo.POPORH1 h ON h.PORHSEQ = l.PORHSEQ INNER JOIN dbo.ICITEM i ON l.ITEMEXISTS = 1 AND i.ITEMNO = l.ITEMNO WHERE h.PORHSEQ = :order_id AND h.PONUMBER = :document AND h.VDCODE = :partner AND h.PORTYPE IN (1,2,3,4) AND l.PORLREV = :line_id
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT p.VENDORID, p.VENDNAME, p.SHORTNAME, p.IDGRP, p.SWACTV, p.SWHOLD, p.NAMECITY, p.CODECTRY, p.NAMECTAC, p.TEXTPHON1, p.EMAIL1, p.CURNCODE, p.AMTBALDUET, p.CNTOPENINV FROM dbo.APVEN p WHERE p.VENDORID = :partner
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 300 — SQL Server",
"id": "4467B143-FA26-5D64-BEC5-702855910B88",
"kind": "sqlServer",
"requiredObjects": [
"dbo.APVEN",
"dbo.ICITEM",
"dbo.ICLOC",
"dbo.POPORH1",
"dbo.POPORL"
],
"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": "6517C815-9B72-56B2-959D-03026F340EA7",
"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": "DOCTOTAL",
"label": "Total pesanan — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DOCTOTAL",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EXTENDED",
"label": "Nilai biaya — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EXTENDED",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DISCOUNT",
"label": "Diskon — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DISCOUNT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TAXAMOUNT",
"label": "Total pajak — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TAXAMOUNT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TXBASEALLO",
"label": "Nilai sebelum pajak — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TXBASEALLO",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TXINCLUDED",
"label": "Pajak termasuk biaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TXINCLUDED",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TXEXCLUDED",
"label": "Pajak di luar biaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TXEXCLUDED",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RCPCOUNT",
"label": "Jumlah penerimaan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RCPCOUNT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Pesanan pemasok",
"primaryKey": "OrderKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocumentDate",
"id": "5865BF53-803B-5605-AFEA-9572DEBAE297",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocumentDate",
"id": "355F1B5B-3889-566F-BB9A-0D4B1A2AA5CF",
"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"
],
"sourceID": "4467B143-FA26-5D64-BEC5-702855910B88",
"sqlQuery": "SELECT CONCAT(h.PORHSEQ, N'') AS OrderKey, h.PORHSEQ AS OrderID, h.VDCODE AS PartnerCode, COALESCE(NULLIF(h.VDNAME, N''), p.VENDNAME, h.VDCODE) AS PartyName, h.PONUMBER AS OrderNumber, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 8) ELSE NULL END, 112) AS DocumentDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.EXPARRIVAL, 112))), 8) ELSE NULL END, 112) AS ExpectedDate, CASE h.PORTYPE WHEN 1 THEN N'Aktif' WHEN 2 THEN N'Berulang' WHEN 3 THEN N'Mendatang' WHEN 4 THEN N'Blanket' ELSE N'Tidak diketahui' END AS OrderType, CASE h.ISCOMPLETE WHEN 0 THEN N'Belum selesai' WHEN 1 THEN N'Selesai' 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.CURRENCY AS Currency, h.REFERENCE, h.DESCRIPTIO AS Description, h.COMMENT, h.VDCITY AS CITY, h.VDCONTACT AS CONTACT, h.VIANAME AS Carrier, h.DOCTOTAL, h.EXTENDED, h.DISCOUNT, h.TAXAMOUNT, h.TXBASEALLO, h.TXINCLUDED, h.TXEXCLUDED, h.RCPCOUNT FROM dbo.POPORH1 h LEFT JOIN dbo.APVEN p ON p.VENDORID = h.VDCODE WHERE h.PORTYPE IN (1,2,3,4) AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 8) ELSE NULL END, 112) >= :date_from AND TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), h.DATE, 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": "CA177847-6C28-57CB-A827-60D43CA27AAE",
"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": "ORDERUNIT",
"label": "Satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDERUNIT",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ORDERCONV",
"label": "Faktor satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ORDERCONV",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OQORDERED",
"label": "Jumlah dipesan — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OQORDERED",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OQRECEIVED",
"label": "Jumlah diterima — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OQRECEIVED",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OQCANCELED",
"label": "Jumlah dibatalkan — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OQCANCELED",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OQOUTSTAND",
"label": "Sisa penerimaan native — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OQOUTSTAND",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OQRCPEXTRA",
"label": "Penerimaan lebih — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OQRCPEXTRA",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SQORDERED",
"label": "Dipesan — satuan persediaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SQORDERED",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SQRECEIVED",
"label": "Diterima — satuan persediaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SQRECEIVED",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SQCANCELED",
"label": "Dibatalkan — satuan persediaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SQCANCELED",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SQOUTSTAND",
"label": "Sisa native — satuan persediaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SQOUTSTAND",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UNITCOST",
"label": "Biaya per satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UNITCOST",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EXTENDED",
"label": "Nilai biaya — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EXTENDED",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DISCPCT",
"label": "Diskon (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DISCPCT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DISCOUNT",
"label": "Diskon — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DISCOUNT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TXBASEALLO",
"label": "Nilai sebelum pajak — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TXBASEALLO",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TAXAMOUNT",
"label": "Total pajak — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TAXAMOUNT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TXINCLUDED",
"label": "Pajak termasuk biaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TXINCLUDED",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TXEXCLUDED",
"label": "Pajak di luar biaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TXEXCLUDED",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDITEMNO",
"label": "Kode barang pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VENDITEMNO",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Rincian pesanan pemasok",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderID",
"id": "3C3FB715-8194-549C-84C5-745AADAB1206",
"name": "order_id",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderNumber",
"id": "74BDE111-54AE-5E58-9743-0A59A5B7E93C",
"name": "document",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartnerCode",
"id": "BB421C8F-E8EB-5C9C-A534-F9B9F98AC89D",
"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",
"ORDERUNIT",
"VENDITEMNO"
],
"sourceID": "4467B143-FA26-5D64-BEC5-702855910B88",
"sqlQuery": "SELECT CONCAT(l.PORHSEQ, N':', l.PORLREV) AS LineKey, CONCAT(l.PORHSEQ, N'') AS OrderKey, l.PORHSEQ AS OrderID, l.PORLREV AS LineID, h.VDCODE AS PartnerCode, h.PONUMBER AS OrderNumber, l.ITEMDESC AS LineDescription, l.ITEMNO AS ItemCode, CASE WHEN l.ITEMEXISTS = 1 THEN N'Barang I/C' WHEN l.ITEMEXISTS = 0 THEN N'Tanpa profil I/C' ELSE N'Tidak diketahui' END AS LineType, COALESCE(w.[DESC], l.LOCATION) AS LocationName, l.LOCATION, h.CURRENCY AS Currency, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112)))) = 8 AND LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112)))) > 9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112))), 8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112))), 9, 1) = '.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112))), 10, 31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), l.EXPARRIVAL, 112))), 8) ELSE NULL END, 112) AS ExpectedDate, CASE l.COMPLETION WHEN 1 THEN N'Belum selesai' WHEN 2 THEN N'Selesai (2)' WHEN 3 THEN N'Selesai (3)' 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.ORDERUNIT, l.ORDERCONV, l.OQORDERED, l.OQRECEIVED, l.OQCANCELED, l.OQOUTSTAND, l.OQRCPEXTRA, l.SQORDERED, l.SQRECEIVED, l.SQCANCELED, l.SQOUTSTAND, l.UNITCOST, l.EXTENDED, l.DISCPCT, l.DISCOUNT, l.TXBASEALLO, l.TAXAMOUNT, l.TXINCLUDED, l.TXEXCLUDED, l.VENDITEMNO FROM dbo.POPORL l INNER JOIN dbo.POPORH1 h ON h.PORHSEQ = l.PORHSEQ LEFT JOIN dbo.ICITEM i ON l.ITEMEXISTS = 1 AND i.ITEMNO = l.ITEMNO LEFT JOIN dbo.ICLOC w ON w.LOCATION = l.LOCATION WHERE h.PORHSEQ = :order_id AND h.PONUMBER = :document AND h.VDCODE = :partner AND h.PORTYPE IN (1,2,3,4)",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "9AC71EB0-45D3-5CF3-8E72-178B09AEF8D0",
"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": "3C3FB715-8194-549C-84C5-745AADAB1206",
"name": "order_id",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderNumber",
"id": "74BDE111-54AE-5E58-9743-0A59A5B7E93C",
"name": "document",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartnerCode",
"id": "BB421C8F-E8EB-5C9C-A534-F9B9F98AC89D",
"name": "partner",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "LineID",
"id": "8B9DF37D-5E25-55E2-B98E-8E36D23922B6",
"name": "line_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DESC",
"FMTITEMNO",
"CATEGORY",
"STOCKUNIT",
"WEIGHTUNIT",
"COMMENT1",
"COMMENT2"
],
"sourceID": "4467B143-FA26-5D64-BEC5-702855910B88",
"sqlQuery": "SELECT CONCAT(l.PORHSEQ, N':', l.PORLREV) 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.POPORL l INNER JOIN dbo.POPORH1 h ON h.PORHSEQ = l.PORHSEQ INNER JOIN dbo.ICITEM i ON l.ITEMEXISTS = 1 AND i.ITEMNO = l.ITEMNO WHERE h.PORHSEQ = :order_id AND h.PONUMBER = :document AND h.VDCODE = :partner AND h.PORTYPE IN (1,2,3,4) AND l.PORLREV = :line_id",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "44EA15AF-43DA-5B5D-8A52-17FD850DB6B6",
"key": "VENDORID",
"type": "text"
}
],
"id": "1D65A794-0B4A-5909-BCC9-9942DB01BBD1",
"mappings": [
{
"commonFieldKey": "",
"key": "VENDORID",
"label": "Kode pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VENDORID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VENDNAME",
"label": "Pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VENDNAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHORTNAME",
"label": "Nama singkat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SHORTNAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IDGRP",
"label": "Kelompok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IDGRP",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SWACTV",
"label": "Aktif (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SWACTV",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SWHOLD",
"label": "Ditahan (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SWHOLD",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NAMECITY",
"label": "Kota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NAMECITY",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CODECTRY",
"label": "Negara",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CODECTRY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NAMECTAC",
"label": "Kontak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NAMECTAC",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TEXTPHON1",
"label": "Telepon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TEXTPHON1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "EMAIL1",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EMAIL1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CURNCODE",
"label": "Mata uang pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CURNCODE",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AMTBALDUET",
"label": "Saldo — mata uang mitra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AMTBALDUET",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CNTOPENINV",
"label": "Dokumen belum selesai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CNTOPENINV",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Profil pemasok",
"primaryKey": "VENDORID",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartnerCode",
"id": "5967EC7F-01C7-55CA-8434-FCBB9577C4A7",
"name": "partner",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VENDORID",
"VENDNAME",
"SHORTNAME",
"IDGRP",
"NAMECITY",
"CODECTRY",
"NAMECTAC",
"TEXTPHON1",
"EMAIL1",
"CURNCODE"
],
"sourceID": "4467B143-FA26-5D64-BEC5-702855910B88",
"sqlQuery": "SELECT p.VENDORID, p.VENDNAME, p.SHORTNAME, p.IDGRP, p.SWACTV, p.SWHOLD, p.NAMECITY, p.CODECTRY, p.NAMECTAC, p.TEXTPHON1, p.EMAIL1, p.CURNCODE, p.AMTBALDUET, p.CNTOPENINV FROM dbo.APVEN p WHERE p.VENDORID = :partner",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "404A0988-5076-5A3B-99F9-4A93C0DDFEBD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "2F22E8CA-A06A-5E53-9CF8-D7439521BC6E",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "CA177847-6C28-57CB-A827-60D43CA27AAE",
"title": "Rincian pesanan",
"urlKey": ""
},
{
"id": "817F633A-D78D-5B91-8CE9-025400F5A20C",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "5C74296C-5375-5D11-91E9-1B654DF2984A",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "1D65A794-0B4A-5909-BCC9-9942DB01BBD1",
"title": "Profil pemasok",
"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": "DOCTOTAL",
"label": "Total pesanan — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "6517C815-9B72-56B2-959D-03026F340EA7",
"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": "DOCTOTAL",
"label": "Total pesanan — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EXTENDED",
"label": "Nilai biaya — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DISCOUNT",
"label": "Diskon — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TAXAMOUNT",
"label": "Total pajak — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TXBASEALLO",
"label": "Nilai sebelum pajak — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TXINCLUDED",
"label": "Pajak termasuk biaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TXEXCLUDED",
"label": "Pajak di luar biaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "RCPCOUNT",
"label": "Jumlah penerimaan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"icon": "shippingbox.and.arrow.backward",
"id": "DA8A18F4-F42F-55A7-98F0-2AE83D841F04",
"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 pemasok",
"titleKey": "PartyName"
},
{
"actions": [
{
"id": "A0B415EB-10D5-53AB-A9E0-79D719B12FA0",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "A0A50CC4-EDB2-5045-B309-5D97B59A93D8",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "9AC71EB0-45D3-5CF3-8E72-178B09AEF8D0",
"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": "ORDERUNIT",
"label": "Satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OQORDERED",
"label": "Jumlah dipesan — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OQRECEIVED",
"label": "Jumlah diterima — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OQOUTSTAND",
"label": "Sisa penerimaan native — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "CA177847-6C28-57CB-A827-60D43CA27AAE",
"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": "ORDERUNIT",
"label": "Satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ORDERCONV",
"label": "Faktor satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OQORDERED",
"label": "Jumlah dipesan — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OQRECEIVED",
"label": "Jumlah diterima — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OQCANCELED",
"label": "Jumlah dibatalkan — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OQOUTSTAND",
"label": "Sisa penerimaan native — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OQRCPEXTRA",
"label": "Penerimaan lebih — satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SQORDERED",
"label": "Dipesan — satuan persediaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SQRECEIVED",
"label": "Diterima — satuan persediaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SQCANCELED",
"label": "Dibatalkan — satuan persediaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SQOUTSTAND",
"label": "Sisa native — satuan persediaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UNITCOST",
"label": "Biaya per satuan pesanan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EXTENDED",
"label": "Nilai biaya — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DISCPCT",
"label": "Diskon (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DISCOUNT",
"label": "Diskon — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TXBASEALLO",
"label": "Nilai sebelum pajak — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TAXAMOUNT",
"label": "Total pajak — mata uang tertera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TXINCLUDED",
"label": "Pajak termasuk biaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TXEXCLUDED",
"label": "Pajak di luar biaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VENDITEMNO",
"label": "Kode barang pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "D26ECA5F-96F7-5936-AD82-AE395414D6D0",
"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 pemasok",
"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": "9AC71EB0-45D3-5CF3-8E72-178B09AEF8D0",
"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": "259EC3B2-2A16-5548-BCE6-B30B1815A683",
"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": "CURNCODE",
"label": "Mata uang pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTBALDUET",
"label": "Saldo — mata uang mitra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CNTOPENINV",
"label": "Dokumen belum selesai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "1D65A794-0B4A-5909-BCC9-9942DB01BBD1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VENDORID",
"label": "Kode pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VENDNAME",
"label": "Pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SHORTNAME",
"label": "Nama singkat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IDGRP",
"label": "Kelompok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SWACTV",
"label": "Aktif (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SWHOLD",
"label": "Ditahan (0 tidak, 1 ya)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NAMECITY",
"label": "Kota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CODECTRY",
"label": "Negara",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NAMECTAC",
"label": "Kontak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TEXTPHON1",
"label": "Telepon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EMAIL1",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CURNCODE",
"label": "Mata uang pemasok",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AMTBALDUET",
"label": "Saldo — mata uang mitra",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CNTOPENINV",
"label": "Dokumen belum selesai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "FCFE2173-7D48-523D-8FBA-4C284A5B1B6C",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "44EA15AF-43DA-5B5D-8A52-17FD850DB6B6",
"key": "VENDORID",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "VENDORID",
"systemImage": "doc.text",
"title": "Profil pemasok",
"titleKey": "VENDNAME"
}
],
"relations": [
{
"childDatasetID": "CA177847-6C28-57CB-A827-60D43CA27AAE",
"childKey": "OrderKey",
"id": "2F22E8CA-A06A-5E53-9CF8-D7439521BC6E",
"name": "Rincian pesanan",
"parentDatasetID": "6517C815-9B72-56B2-959D-03026F340EA7",
"parentKey": "OrderKey"
},
{
"childDatasetID": "9AC71EB0-45D3-5CF3-8E72-178B09AEF8D0",
"childKey": "LineKey",
"id": "A0A50CC4-EDB2-5045-B309-5D97B59A93D8",
"name": "Profil barang I/C jika tersedia",
"parentDatasetID": "CA177847-6C28-57CB-A827-60D43CA27AAE",
"parentKey": "LineKey"
},
{
"childDatasetID": "1D65A794-0B4A-5909-BCC9-9942DB01BBD1",
"childKey": "VENDORID",
"id": "5C74296C-5375-5D11-91E9-1B654DF2984A",
"name": "Profil pemasok",
"parentDatasetID": "6517C815-9B72-56B2-959D-03026F340EA7",
"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 pembelian dan penerimaan 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, berulang, mendatang dan blanket. Kuantitas OQ memakai satuan pesanan; SQ memakai satuan persediaan I/C yang ditampilkan. Sisa, pembatalan dan penerimaan lebih dibaca dari kolom native; tidak dihitung ulang dengan asumsi konversi. Nilai sebelum pajak, pajak termasuk/di luar biaya, total pajak, diskon dan total pesanan ditampilkan terpisah; pajak termasuk biaya tidak ditambahkan lagi. Barang non-inventory atau sumber daya proyek tanpa profil I/C tetap terlihat pada rincian; subdaftar profil I/C akan kosong. 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": "BA678730-C441-5E10-B85A-C95BAF87FD33",
"rootButtonCount": 1,
"summary": "Periode pesanan, status, rincian kuantitas dan satuan, profil barang I/C dan mitra.",
"tags": [
"Sage 300",
"SQL Server",
"Pesanan",
"pemasok",
"Pro"
],
"title": "Pesanan pemasok lengkap — Pro"
}
}