Faktur pelanggan, baris dan pelanggan penagihan — Pro
Faktur pesanan per periode/partisi/perusahaan; nilai, jatuh tempo, diskon, baris dan master penagihan saat ini.
TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA.
Untuk penjualan, administrasi penagihan dan manajer: pilih periode faktur, partisi dan perusahaan. Lihat nama penagihan yang tersimpan, nilai dan mata uang faktur, jatuh tempo, diskon serta referensi pembukuan. Baris membuka barang, jumlah jual/inventaris, harga, diskon, pesanan asal dan dimensi. Pelanggan membuka kondisi master penagihan SAAT INI. 95 posisi berguna dalam Detil.
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.
EDISI KHUSUS: AX 2012 R3 on-premises SQL Server, untuk instalasi lama yang sudah ada. Dukungan diperpanjang berakhir 11 Januari 2023; bukan rekomendasi pemasangan ERP lama atau server terbuka ke internet. Bukan AX 2009, Dynamics 365 Finance/SCM, Business Central atau SQL cloud. Pro nyata: satu sumber, satu Home, tiga daftar dan dua sub-tombol lazy. Tidak ada refresh berkala.
LINGKUP: hanya RefNum=SalesOrder(0) dan Proforma=No(0), dari tipe dan rantai EDT resmi masing-masing. Bukan semua modul faktur/proyek/piutang/bunga. Retur, koreksi dan uang muka tidak dihapus diam-diam: jenis pesanan serta penanda asli terlihat. Ya pada koreksi bukan otomatis status nota kredit; nilai negatif/nol/NULL dipertahankan. Kode asing dan NULL penanda ditampilkan, bukan ditebak.
TAUTAN BARIS: hanya ParentRecId dengan partisi dan DATAAREAID tersimpan tepat. Field Int64 dan relasi bernama CustInvoiceJour_ParentRecId tersedia dalam AOT R3, tetapi daftar kolom FK fisik pada referensi kosong. Administrator WAJIB memverifikasi pemetaan, populasi ParentRecId, kunci, indeks dan kelengkapan setiap alur posting pada instalasi sebelum memakai konfigurasi. Belum diverifikasi pada ERP nyata. Tidak ada fallback nomor faktur/tanggal/SalesId yang dapat mencampur dokumen. Baris bernomor/tanggal berbeda tetap ditampilkan dengan peringatan; jumlah konflik terlihat di Detil faktur. Jumlah baris hanya tautan ini, bukan jaminan seluruh baris faktur tersedia. Nol bukan bukti faktur tanpa baris. Dokumen konsolidasi dapat memiliki SalesId baris berbeda; tidak dipaksa sama dengan antet. Baris anak tidak difilter ulang menurut periode.
NILAI ASLI: InvoiceAmount adalah total sumber dalam CurrencyCode faktur, bukan saldo belum dibayar. SalesBalance adalah total baris setelah diskon baris; EndDisc adalah jumlah diskon total, bukan kode grup. SumLineDisc, SumMarkup dan InvoiceRoundOff tidak dijumlah ulang menjadi formula faktur. Diskon tunai bersyarat bukan bukti pembayaran atau potongan yang benar-benar digunakan. Kode syarat/jadwal pembayaran dan nomor voucher bukan status lunas. Tidak ada saldo, margin, pembayaran, pajak atau total lintas mata uang dihitung. SumTax dengan deskripsi referensi ambigu dan TaxAmount dalam mata uang penyelesaian pajak tidak disalahlabeli sebagai PPN dalam mata uang faktur. Semua jumlah MST dihilangkan tanpa bukti mata uang akuntansi.
KUANTITAS/HARGA: Qty dalam SalesUnit, InventQty dalam satuan inventaris; satuan inventaris tidak ditebak. SalesPrice dan diskon nominal per PriceUnit, bukan otomatis per satu barang. Nilai LineAmount dan mata uang baris dipertahankan sendiri. PriceUnit=0/NULL tidak dibagi; tidak ada Qty x harga, total campuran satuan, konversi atau deduplikasi kosmetik. Dimensi InventDim opsional adalah kode konteks saat ini, bukan stok, nama produk terjemahan atau dimensi akuntansi. Dimensi hilang tidak menghapus baris.
KONTEKS PELANGGAN: nama InvoicingName adalah salinan pada faktur; sub-tombol memakai InvoiceAccount penagihan saat ini, bukan OrderAccount atau nama historis. Mata uang/syarat master dapat berbeda dengan faktur. Master hilang tidak menghapus faktur/baris. Tidak ada alamat lengkap, kontak privat, bank, identitas pemerintah, audit atau CreditMax dengan mata uang yang ditebak. Nama bisnis bisa merupakan data pribadi; hanya gunakan akses berwenang.
AKSES/KINERJA: periode InvoiceDate, partisi dan perusahaan dipilih sebelum batas 1.000 baris; batas bukan jaminan kueri murah, kelengkapan atau ekspor. Seluruh anak meneruskan partisi, perusahaan, RecId dan nomor faktur tepat; Int64 sebagai teks utuh, pencocokan biner membedakan huruf besar/kecil dan spasi akhir. Filter bukan ACL; SQL langsung tidak mewarisi AOS/XDS atau izin AX. Gunakan akun SELECT terbatas pada server; perusahaan virtual perlu pemetaan administrator.
DOKUMENTASI: AOT asli Microsoft, bukan sertifikat DDL SQL instalasi. Verifikasi R3, modul, schema pemilik, kolom, FK, kunci, izin, waktu dan kelengkapan lokal, lalu lakukan uji baca terbatas saat impor. Paket/DEMO tanpa kredensial/server/data perusahaan nyata. Tes SQLite adaptasi bukan SQL Server atau ERP nyata.
Referensi faktur: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg942113(v=ax.60)
Referensi baris: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg943036(v=ax.60)
Siklus dukungan: https://learn.microsoft.com/en-us/lifecycle/products/dynamics-ax-2012-r3
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Faktur pelanggan
- Details: Baris
- Details: Pelanggan
- Sub-button: Baris faktur pelanggan
- Sub-button: Pelanggan penagihan saat ini
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS InvoiceKey, CAST(o.Partition AS nvarchar(30)) AS PartitionId, CAST(o.RecId AS nvarchar(30)) AS InvoiceRecId, CAST(o.InvoiceDate AS date) AS PeriodDate, o.InvoiceId AS InvoiceId, o.InvoiceDate AS InvoiceDate, o.InvoicingName AS InvoicingName, o.InvoiceAccount AS InvoiceAccount, o.OrderAccount AS OrderAccount, pt.PartitionKey AS PartitionKey, o.dataAreaId AS dataAreaId, o.CurrencyCode AS CurrencyCode, o.InvoiceAmount AS InvoiceAmount, o.SalesBalance AS SalesBalance, o.EndDisc AS EndDisc, o.SumLineDisc AS SumLineDisc, o.SumMarkup AS SumMarkup, o.InvoiceRoundOff AS InvoiceRoundOff, o.DueDate AS DueDate, o.FixedDueDate AS FixedDueDate, o.Payment AS Payment, o.PaymentSched AS PaymentSched, o.PaymDayId AS PaymDayId, o.CashDiscCode AS CashDiscCode, o.CashDisc AS CashDisc, o.CashDiscPercent AS CashDiscPercent, o.CashDiscDate AS CashDiscDate, o.CashDiscBaseDate AS CashDiscBaseDate, o.LedgerVoucher AS LedgerVoucher, o.DocumentNum AS DocumentNum, o.DocumentDate AS DocumentDate, o.SalesId AS SalesId, o.PurchaseOrder AS PurchaseOrder, o.CustomerRef AS CustomerRef, o.CustGroup AS CustGroup, o.PostingProfile AS PostingProfile, o.DlvMode AS DlvMode, o.DlvTerm AS DlvTerm, o.DeliveryName AS DeliveryName, o.inventLocationId AS inventLocationId, CASE WHEN o.SalesType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.SalesType WHEN 0 THEN N'Jurnal' WHEN 1 THEN N'DEL_Quotation (kode lama)' WHEN 2 THEN N'Langganan' WHEN 3 THEN N'Pesanan penjualan' WHEN 4 THEN N'Retur' WHEN 5 THEN N'DEL_Blanket (kode lama)' WHEN 6 THEN N'Permintaan barang' ELSE CONCAT(N'Kode sumber ',o.SalesType) END END AS OrderType, CASE WHEN o.RefNum IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.RefNum WHEN 0 THEN N'Pesanan penjualan' WHEN 1 THEN N'Proyek' WHEN 2 THEN N'Piutang pelanggan' WHEN 3 THEN N'Bunga' WHEN 100 THEN N'Faktur pelengkap' ELSE CONCAT(N'Kode sumber ',o.RefNum) END END AS Origin, CASE WHEN o.IsCorrection IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.IsCorrection WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',o.IsCorrection) END END AS Correction, CASE WHEN o.Prepayment IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.Prepayment WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',o.Prepayment) END END AS AdvanceInvoice, (SELECT COUNT_BIG(*) FROM CustInvoiceTrans l WHERE l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND l.ParentRecId=o.RecId) AS LineCount, (SELECT COUNT_BIG(*) FROM CustInvoiceTrans l WHERE l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND l.ParentRecId=o.RecId AND CASE WHEN CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate THEN 0 ELSE 1 END=1) AS LineReferenceConflictCount FROM CustInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition WHERE o.RefNum=0 AND o.Proforma=0 AND o.Partition IS NOT NULL AND o.Partition<>0 AND o.RecId IS NOT NULL AND o.RecId<>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.InvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'CustInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustInvoiceJour',N'U') AND OBJECT_ID(N'CustInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustInvoiceTrans',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':'),CONCAT(LEN(CONCAT(l.Partition,N'#')),N':',l.Partition,N':',LEN(CONCAT(l.dataAreaId,N'#')),N':',l.dataAreaId,N':',LEN(CONCAT(l.RecId,N'#')),N':',l.RecId,N':')) AS LineKey, CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS ParentInvoiceKey, l.ItemId AS ItemId, l.Name AS Name, l.ExternalItemId AS ExternalItemId, l.LineNum AS LineNum, l.CustomerLineNum AS CustomerLineNum, l.InvoiceId AS InvoiceId, l.InvoiceDate AS InvoiceDate, l.SalesId AS SalesId, l.OrigSalesId AS OrigSalesId, CASE WHEN CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate THEN N'Sama dengan antet' ELSE N'Berbeda atau kosong — verifikasi lokal' END AS InvoiceReferenceCheck, l.CurrencyCode AS CurrencyCode, l.Qty AS Qty, l.SalesUnit AS SalesUnit, l.InventQty AS InventQty, l.SalesPrice AS SalesPrice, l.PriceUnit AS PriceUnit, l.LineAmount AS LineAmount, l.LineDisc AS LineDisc, l.LinePercent AS LinePercent, l.MultiLnDisc AS MultiLnDisc, l.MultiLnPercent AS MultiLnPercent, l.DiscAmount AS DiscAmount, l.DiscPercent AS DiscPercent, l.SalesMarkup AS SalesMarkup, l.SumLineDisc AS SumLineDisc, l.DlvDate AS DlvDate, l.TaxGroup AS TaxGroup, l.TaxItemGroup AS TaxItemGroup, l.InventRefId AS InventRefId, d.InventSiteId AS InventSiteId, d.InventLocationId AS InventLocationId, d.wMSLocationId AS wMSLocationId, d.inventBatchId AS inventBatchId, d.inventSerialId AS inventSerialId, d.configId AS configId, d.InventColorId AS InventColorId, d.InventSizeId AS InventSizeId, d.InventStyleId AS InventStyleId FROM CustInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition INNER JOIN CustInvoiceTrans l ON l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND l.ParentRecId=o.RecId LEFT JOIN InventDim d ON d.Partition=l.Partition AND CAST(d.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND l.InventDimId IS NOT NULL AND DATALENGTH(l.InventDimId)>0 AND CAST(d.inventDimId AS varbinary(max))=CAST(l.InventDimId AS varbinary(max)) WHERE o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:invoiceRecId AS bigint) AND CAST(o.InvoiceId AS varbinary(max))=CAST(:invoiceId AS varbinary(max)) AND o.RefNum=0 AND o.Proforma=0 AND o.Partition IS NOT NULL AND o.Partition<>0 AND o.RecId IS NOT NULL AND o.RecId<>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.InvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND l.RecId IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'CustInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustInvoiceJour',N'U') AND OBJECT_ID(N'CustInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustInvoiceTrans',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':'),CONCAT(LEN(CONCAT(m.Partition,N'#')),N':',m.Partition,N':',LEN(CONCAT(m.dataAreaId,N'#')),N':',m.dataAreaId,N':',LEN(CONCAT(m.RecId,N'#')),N':',m.RecId,N':')) AS CustomerKey, CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS ParentInvoiceKey, COALESCE(NULLIF(p.Name,N''),m.AccountNum) AS CustomerName, m.AccountNum AS AccountNum, p.KnownAs AS KnownAs, p.NameAlias AS NameAlias, p.PartyNumber AS PartyNumber, m.CustGroup AS CustGroup, m.Currency AS Currency, m.InvoiceAccount AS InvoiceAccount, m.PaymTermId AS PaymTermId, m.PaymMode AS PaymMode, m.OurAccountNum AS OurAccountNum, m.DlvMode AS DlvMode, m.DlvTerm AS DlvTerm, CASE WHEN m.Blocked IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE m.Blocked WHEN 0 THEN N'Tidak ditangguhkan' WHEN 1 THEN N'Faktur' WHEN 2 THEN N'Semua' WHEN 3 THEN N'Pembayaran' WHEN 4 THEN N'Permintaan' WHEN 5 THEN N'Never (kode sumber)' ELSE CONCAT(N'Kode sumber ',m.Blocked) END END AS BlockStatus, m.CreditRating AS CreditRating FROM CustInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition INNER JOIN CustTable m ON m.Partition=o.Partition AND CAST(m.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(m.AccountNum AS varbinary(max))=CAST(o.InvoiceAccount AS varbinary(max)) LEFT JOIN DirPartyTable p ON p.Partition=m.Partition AND p.RecId=m.Party WHERE o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:invoiceRecId AS bigint) AND CAST(o.InvoiceId AS varbinary(max))=CAST(:invoiceId AS varbinary(max)) AND o.RefNum=0 AND o.Proforma=0 AND o.Partition IS NOT NULL AND o.Partition<>0 AND o.RecId IS NOT NULL AND o.RecId<>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.InvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND m.RecId IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'CustInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustInvoiceJour',N'U') AND OBJECT_ID(N'CustInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustInvoiceTrans',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U')
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Dynamics AX 2012 R3 — SQL Server lokal berizin",
"id": "662FB10E-0FDE-5D84-B03F-3DC26657BCBD",
"kind": "sqlServer",
"requiredObjects": [
"CustInvoiceJour",
"CustInvoiceTrans",
"Partitions",
"CustTable",
"DirPartyTable",
"InventDim"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "859554C5-01D8-52DC-99BB-01C93F2B75C9",
"key": "PeriodDate",
"type": "date"
},
{
"direction": "ascending",
"id": "002A79F1-506E-5C36-93B7-CB7C709835B6",
"key": "InvoiceId",
"type": "text"
},
{
"direction": "ascending",
"id": "1FBAFB24-87C8-5993-9B00-F74D2B1076CD",
"key": "InvoiceKey",
"type": "text"
}
],
"id": "D08FAD4E-AE98-5ADB-BDA3-65DD4031B8C2",
"mappings": [
{
"commonFieldKey": "",
"key": "InvoiceKey",
"label": "Internal InvoiceKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartitionId",
"label": "Internal PartitionId",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PartitionId",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceRecId",
"label": "Internal InvoiceRecId",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceRecId",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PeriodDate",
"label": "Internal PeriodDate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PeriodDate",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceId",
"label": "Nomor faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceDate",
"label": "Tanggal faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoicingName",
"label": "Nama penagihan pada faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoicingName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceAccount",
"label": "Akun pelanggan penagih",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderAccount",
"label": "Akun pelanggan pemesan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartitionKey",
"label": "Partisi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PartitionKey",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dataAreaId",
"label": "Perusahaan tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "dataAreaId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Mata uang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceAmount",
"label": "Total faktur sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SalesBalance",
"label": "Total baris setelah diskon baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SalesBalance",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EndDisc",
"label": "Diskon total faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EndDisc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SumLineDisc",
"label": "Jumlah diskon baris faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SumLineDisc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SumMarkup",
"label": "Biaya tambahan pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SumMarkup",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceRoundOff",
"label": "Pembulatan faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceRoundOff",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DueDate",
"label": "Tanggal jatuh tempo faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DueDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FixedDueDate",
"label": "Jatuh tempo tetap sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "FixedDueDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Payment",
"label": "Kode syarat pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Payment",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymentSched",
"label": "Kode jadwal pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymentSched",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymDayId",
"label": "Kode hari pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymDayId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CashDiscCode",
"label": "Kode diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CashDiscCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CashDisc",
"label": "Jumlah diskon tunai bersyarat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CashDisc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CashDiscPercent",
"label": "Diskon tunai (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CashDiscPercent",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CashDiscDate",
"label": "Batas diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CashDiscDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CashDiscBaseDate",
"label": "Tanggal dasar diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CashDiscBaseDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LedgerVoucher",
"label": "Nomor voucher pembukuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LedgerVoucher",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocumentNum",
"label": "Nomor dokumen transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DocumentNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocumentDate",
"label": "Tanggal dokumen transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DocumentDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalesId",
"label": "Referensi pesanan atau proyek antet",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SalesId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchaseOrder",
"label": "Nomor permintaan pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PurchaseOrder",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerRef",
"label": "Referensi pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerRef",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustGroup",
"label": "Grup pelanggan faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingProfile",
"label": "Kode profil pembukuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PostingProfile",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DlvMode",
"label": "Kode cara pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DlvMode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DlvTerm",
"label": "Kode syarat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DlvTerm",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DeliveryName",
"label": "Nama alamat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DeliveryName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "inventLocationId",
"label": "Kode gudang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "inventLocationId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderType",
"label": "Jenis pesanan sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrderType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Origin",
"label": "Asal dokumen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Origin",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Correction",
"label": "Penanda koreksi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Correction",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AdvanceInvoice",
"label": "Penanda faktur uang muka",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AdvanceInvoice",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineCount",
"label": "Jumlah baris dengan tautan antet",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineReferenceConflictCount",
"label": "Tautan dengan nomor atau tanggal berbeda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineReferenceConflictCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Faktur pelanggan",
"primaryKey": "InvoiceKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"InvoiceId",
"InvoiceDate",
"InvoicingName",
"InvoiceAccount",
"OrderAccount",
"PartitionKey",
"dataAreaId",
"CurrencyCode",
"InvoiceAmount",
"SalesBalance",
"EndDisc",
"SumLineDisc",
"SumMarkup",
"InvoiceRoundOff",
"DueDate",
"FixedDueDate",
"Payment",
"PaymentSched",
"PaymDayId",
"CashDiscCode",
"CashDisc",
"CashDiscPercent",
"CashDiscDate",
"CashDiscBaseDate",
"LedgerVoucher",
"DocumentNum",
"DocumentDate",
"SalesId",
"PurchaseOrder",
"CustomerRef",
"CustGroup",
"PostingProfile",
"DlvMode",
"DlvTerm",
"DeliveryName",
"inventLocationId",
"OrderType",
"Origin",
"Correction",
"AdvanceInvoice",
"LineCount",
"LineReferenceConflictCount"
],
"sourceID": "662FB10E-0FDE-5D84-B03F-3DC26657BCBD",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS InvoiceKey, CAST(o.Partition AS nvarchar(30)) AS PartitionId, CAST(o.RecId AS nvarchar(30)) AS InvoiceRecId, CAST(o.InvoiceDate AS date) AS PeriodDate, o.InvoiceId AS InvoiceId, o.InvoiceDate AS InvoiceDate, o.InvoicingName AS InvoicingName, o.InvoiceAccount AS InvoiceAccount, o.OrderAccount AS OrderAccount, pt.PartitionKey AS PartitionKey, o.dataAreaId AS dataAreaId, o.CurrencyCode AS CurrencyCode, o.InvoiceAmount AS InvoiceAmount, o.SalesBalance AS SalesBalance, o.EndDisc AS EndDisc, o.SumLineDisc AS SumLineDisc, o.SumMarkup AS SumMarkup, o.InvoiceRoundOff AS InvoiceRoundOff, o.DueDate AS DueDate, o.FixedDueDate AS FixedDueDate, o.Payment AS Payment, o.PaymentSched AS PaymentSched, o.PaymDayId AS PaymDayId, o.CashDiscCode AS CashDiscCode, o.CashDisc AS CashDisc, o.CashDiscPercent AS CashDiscPercent, o.CashDiscDate AS CashDiscDate, o.CashDiscBaseDate AS CashDiscBaseDate, o.LedgerVoucher AS LedgerVoucher, o.DocumentNum AS DocumentNum, o.DocumentDate AS DocumentDate, o.SalesId AS SalesId, o.PurchaseOrder AS PurchaseOrder, o.CustomerRef AS CustomerRef, o.CustGroup AS CustGroup, o.PostingProfile AS PostingProfile, o.DlvMode AS DlvMode, o.DlvTerm AS DlvTerm, o.DeliveryName AS DeliveryName, o.inventLocationId AS inventLocationId, CASE WHEN o.SalesType IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.SalesType WHEN 0 THEN N'Jurnal' WHEN 1 THEN N'DEL_Quotation (kode lama)' WHEN 2 THEN N'Langganan' WHEN 3 THEN N'Pesanan penjualan' WHEN 4 THEN N'Retur' WHEN 5 THEN N'DEL_Blanket (kode lama)' WHEN 6 THEN N'Permintaan barang' ELSE CONCAT(N'Kode sumber ',o.SalesType) END END AS OrderType, CASE WHEN o.RefNum IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.RefNum WHEN 0 THEN N'Pesanan penjualan' WHEN 1 THEN N'Proyek' WHEN 2 THEN N'Piutang pelanggan' WHEN 3 THEN N'Bunga' WHEN 100 THEN N'Faktur pelengkap' ELSE CONCAT(N'Kode sumber ',o.RefNum) END END AS Origin, CASE WHEN o.IsCorrection IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.IsCorrection WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',o.IsCorrection) END END AS Correction, CASE WHEN o.Prepayment IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE o.Prepayment WHEN 0 THEN N'Tidak' WHEN 1 THEN N'Ya' ELSE CONCAT(N'Kode sumber ',o.Prepayment) END END AS AdvanceInvoice, (SELECT COUNT_BIG(*) FROM CustInvoiceTrans l WHERE l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND l.ParentRecId=o.RecId) AS LineCount, (SELECT COUNT_BIG(*) FROM CustInvoiceTrans l WHERE l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND l.ParentRecId=o.RecId AND CASE WHEN CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate THEN 0 ELSE 1 END=1) AS LineReferenceConflictCount FROM CustInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition WHERE o.RefNum=0 AND o.Proforma=0 AND o.Partition IS NOT NULL AND o.Partition<>0 AND o.RecId IS NOT NULL AND o.RecId<>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.InvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'CustInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustInvoiceJour',N'U') AND OBJECT_ID(N'CustInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustInvoiceTrans',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "AA367C24-B913-596B-AFB8-936AF6AA00E1",
"key": "LineNum",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "BC0259DB-B976-5D4D-98F8-0A8FAD4F1599",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Internal LineKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentInvoiceKey",
"label": "Internal ParentInvoiceKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentInvoiceKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemId",
"label": "Kode barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ItemId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Name",
"label": "Deskripsi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Name",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ExternalItemId",
"label": "Kode barang pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ExternalItemId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineNum",
"label": "Nomor urut baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineNum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerLineNum",
"label": "Nomor baris pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerLineNum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceId",
"label": "Nomor faktur pada baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceDate",
"label": "Tanggal faktur pada baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalesId",
"label": "Pesanan pada baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SalesId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrigSalesId",
"label": "Pesanan asal tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OrigSalesId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceReferenceCheck",
"label": "Konsistensi nomor dan tanggal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceReferenceCheck",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrencyCode",
"label": "Mata uang baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CurrencyCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Qty",
"label": "Jumlah faktur (satuan jual)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Qty",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SalesUnit",
"label": "Satuan jual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SalesUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InventQty",
"label": "Jumlah dalam satuan inventaris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InventQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalesPrice",
"label": "Harga per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SalesPrice",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PriceUnit",
"label": "Satuan per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PriceUnit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineAmount",
"label": "Nilai baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineDisc",
"label": "Diskon baris per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineDisc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LinePercent",
"label": "Diskon baris (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LinePercent",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MultiLnDisc",
"label": "Diskon multibaris per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MultiLnDisc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MultiLnPercent",
"label": "Diskon multibaris (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MultiLnPercent",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscAmount",
"label": "Jumlah diskon transaksi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscAmount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscPercent",
"label": "Diskon transaksi (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscPercent",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalesMarkup",
"label": "Biaya harga tetap sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SalesMarkup",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SumLineDisc",
"label": "Total diskon baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SumLineDisc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DlvDate",
"label": "Pengiriman dikonfirmasi atau diminta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DlvDate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TaxGroup",
"label": "Kode grup pajak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TaxGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TaxItemGroup",
"label": "Kode pajak barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TaxItemGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventRefId",
"label": "Referensi pesanan proyek atau produksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventRefId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventSiteId",
"label": "Kode lokasi dimensi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventSiteId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventLocationId",
"label": "Kode gudang dimensi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventLocationId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "wMSLocationId",
"label": "Kode tempat gudang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "wMSLocationId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "inventBatchId",
"label": "Kode batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "inventBatchId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "inventSerialId",
"label": "Nomor seri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "inventSerialId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "configId",
"label": "Kode konfigurasi barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "configId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventColorId",
"label": "Kode warna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventColorId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventSizeId",
"label": "Kode ukuran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventSizeId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InventStyleId",
"label": "Kode gaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InventStyleId",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Baris faktur pelanggan",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "0C97B503-F5F4-527F-AD15-C1E850C23249",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "DB850F98-FFC5-5227-8EFD-E43A6CC78FE0",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "InvoiceRecId",
"id": "3BAD9717-8B08-5B92-96AA-D6D0CE3F933B",
"name": "invoiceRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "InvoiceId",
"id": "4F13B6DA-7E9E-510D-8E82-2913A97A8BAC",
"name": "invoiceId",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemId",
"Name",
"ExternalItemId",
"LineNum",
"CustomerLineNum",
"InvoiceId",
"InvoiceDate",
"SalesId",
"OrigSalesId",
"InvoiceReferenceCheck",
"CurrencyCode",
"Qty",
"SalesUnit",
"InventQty",
"SalesPrice",
"PriceUnit",
"LineAmount",
"LineDisc",
"LinePercent",
"MultiLnDisc",
"MultiLnPercent",
"DiscAmount",
"DiscPercent",
"SalesMarkup",
"SumLineDisc",
"DlvDate",
"TaxGroup",
"TaxItemGroup",
"InventRefId",
"InventSiteId",
"InventLocationId",
"wMSLocationId",
"inventBatchId",
"inventSerialId",
"configId",
"InventColorId",
"InventSizeId",
"InventStyleId"
],
"sourceID": "662FB10E-0FDE-5D84-B03F-3DC26657BCBD",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':'),CONCAT(LEN(CONCAT(l.Partition,N'#')),N':',l.Partition,N':',LEN(CONCAT(l.dataAreaId,N'#')),N':',l.dataAreaId,N':',LEN(CONCAT(l.RecId,N'#')),N':',l.RecId,N':')) AS LineKey, CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS ParentInvoiceKey, l.ItemId AS ItemId, l.Name AS Name, l.ExternalItemId AS ExternalItemId, l.LineNum AS LineNum, l.CustomerLineNum AS CustomerLineNum, l.InvoiceId AS InvoiceId, l.InvoiceDate AS InvoiceDate, l.SalesId AS SalesId, l.OrigSalesId AS OrigSalesId, CASE WHEN CAST(l.InvoiceId AS varbinary(max))=CAST(o.InvoiceId AS varbinary(max)) AND l.InvoiceDate=o.InvoiceDate THEN N'Sama dengan antet' ELSE N'Berbeda atau kosong — verifikasi lokal' END AS InvoiceReferenceCheck, l.CurrencyCode AS CurrencyCode, l.Qty AS Qty, l.SalesUnit AS SalesUnit, l.InventQty AS InventQty, l.SalesPrice AS SalesPrice, l.PriceUnit AS PriceUnit, l.LineAmount AS LineAmount, l.LineDisc AS LineDisc, l.LinePercent AS LinePercent, l.MultiLnDisc AS MultiLnDisc, l.MultiLnPercent AS MultiLnPercent, l.DiscAmount AS DiscAmount, l.DiscPercent AS DiscPercent, l.SalesMarkup AS SalesMarkup, l.SumLineDisc AS SumLineDisc, l.DlvDate AS DlvDate, l.TaxGroup AS TaxGroup, l.TaxItemGroup AS TaxItemGroup, l.InventRefId AS InventRefId, d.InventSiteId AS InventSiteId, d.InventLocationId AS InventLocationId, d.wMSLocationId AS wMSLocationId, d.inventBatchId AS inventBatchId, d.inventSerialId AS inventSerialId, d.configId AS configId, d.InventColorId AS InventColorId, d.InventSizeId AS InventSizeId, d.InventStyleId AS InventStyleId FROM CustInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition INNER JOIN CustInvoiceTrans l ON l.Partition=o.Partition AND CAST(l.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND l.ParentRecId=o.RecId LEFT JOIN InventDim d ON d.Partition=l.Partition AND CAST(d.dataAreaId AS varbinary(max))=CAST(l.dataAreaId AS varbinary(max)) AND l.InventDimId IS NOT NULL AND DATALENGTH(l.InventDimId)>0 AND CAST(d.inventDimId AS varbinary(max))=CAST(l.InventDimId AS varbinary(max)) WHERE o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:invoiceRecId AS bigint) AND CAST(o.InvoiceId AS varbinary(max))=CAST(:invoiceId AS varbinary(max)) AND o.RefNum=0 AND o.Proforma=0 AND o.Partition IS NOT NULL AND o.Partition<>0 AND o.RecId IS NOT NULL AND o.RecId<>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.InvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND l.RecId IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'CustInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustInvoiceJour',N'U') AND OBJECT_ID(N'CustInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustInvoiceTrans',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "81F2AA9E-89D6-59B0-8AF0-BE212938DABE",
"key": "CustomerName",
"type": "text"
},
{
"direction": "ascending",
"id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
"key": "CustomerKey",
"type": "text"
}
],
"id": "A53C9550-FFCC-5C5B-A869-A9D38FE64F7C",
"mappings": [
{
"commonFieldKey": "",
"key": "CustomerKey",
"label": "Internal CustomerKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentInvoiceKey",
"label": "Internal ParentInvoiceKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ParentInvoiceKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerName",
"label": "Nama pelanggan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountNum",
"label": "Akun pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "KnownAs",
"label": "Nama dikenal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "KnownAs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NameAlias",
"label": "Alias pencarian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "NameAlias",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartyNumber",
"label": "Nomor pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PartyNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustGroup",
"label": "Grup pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustGroup",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Currency",
"label": "Mata uang faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Currency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceAccount",
"label": "Akun penerima faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "InvoiceAccount",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaymTermId",
"label": "Kode syarat pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymTermId",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PaymMode",
"label": "Kode metode pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PaymMode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OurAccountNum",
"label": "Akun kita pada pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OurAccountNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DlvMode",
"label": "Kode cara pengiriman bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DlvMode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DlvTerm",
"label": "Kode syarat pengiriman bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DlvTerm",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BlockStatus",
"label": "Penangguhan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BlockStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CreditRating",
"label": "Peringkat kredit tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CreditRating",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Pelanggan penagihan saat ini",
"primaryKey": "CustomerKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "PartitionId",
"id": "0C97B503-F5F4-527F-AD15-C1E850C23249",
"name": "partition",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "dataAreaId",
"id": "DB850F98-FFC5-5227-8EFD-E43A6CC78FE0",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "InvoiceRecId",
"id": "3BAD9717-8B08-5B92-96AA-D6D0CE3F933B",
"name": "invoiceRecId",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "InvoiceId",
"id": "4F13B6DA-7E9E-510D-8E82-2913A97A8BAC",
"name": "invoiceId",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"CustomerName",
"AccountNum",
"KnownAs",
"NameAlias",
"PartyNumber",
"CustGroup",
"Currency",
"InvoiceAccount",
"PaymTermId",
"PaymMode",
"OurAccountNum",
"DlvMode",
"DlvTerm",
"BlockStatus",
"CreditRating"
],
"sourceID": "662FB10E-0FDE-5D84-B03F-3DC26657BCBD",
"sqlQuery": "SELECT CONCAT(CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':'),CONCAT(LEN(CONCAT(m.Partition,N'#')),N':',m.Partition,N':',LEN(CONCAT(m.dataAreaId,N'#')),N':',m.dataAreaId,N':',LEN(CONCAT(m.RecId,N'#')),N':',m.RecId,N':')) AS CustomerKey, CONCAT(LEN(CONCAT(o.Partition,N'#')),N':',o.Partition,N':',LEN(CONCAT(o.dataAreaId,N'#')),N':',o.dataAreaId,N':',LEN(CONCAT(o.RecId,N'#')),N':',o.RecId,N':') AS ParentInvoiceKey, COALESCE(NULLIF(p.Name,N''),m.AccountNum) AS CustomerName, m.AccountNum AS AccountNum, p.KnownAs AS KnownAs, p.NameAlias AS NameAlias, p.PartyNumber AS PartyNumber, m.CustGroup AS CustGroup, m.Currency AS Currency, m.InvoiceAccount AS InvoiceAccount, m.PaymTermId AS PaymTermId, m.PaymMode AS PaymMode, m.OurAccountNum AS OurAccountNum, m.DlvMode AS DlvMode, m.DlvTerm AS DlvTerm, CASE WHEN m.Blocked IS NULL THEN N'Tidak diketahui (NULL)' ELSE CASE m.Blocked WHEN 0 THEN N'Tidak ditangguhkan' WHEN 1 THEN N'Faktur' WHEN 2 THEN N'Semua' WHEN 3 THEN N'Pembayaran' WHEN 4 THEN N'Permintaan' WHEN 5 THEN N'Never (kode sumber)' ELSE CONCAT(N'Kode sumber ',m.Blocked) END END AS BlockStatus, m.CreditRating AS CreditRating FROM CustInvoiceJour o INNER JOIN Partitions pt ON pt.RecId=o.Partition INNER JOIN CustTable m ON m.Partition=o.Partition AND CAST(m.dataAreaId AS varbinary(max))=CAST(o.dataAreaId AS varbinary(max)) AND CAST(m.AccountNum AS varbinary(max))=CAST(o.InvoiceAccount AS varbinary(max)) LEFT JOIN DirPartyTable p ON p.Partition=m.Partition AND p.RecId=m.Party WHERE o.Partition=CAST(:partition AS bigint) AND CAST(o.dataAreaId AS varbinary(max))=CAST(:company AS varbinary(max)) AND o.RecId=CAST(:invoiceRecId AS bigint) AND CAST(o.InvoiceId AS varbinary(max))=CAST(:invoiceId AS varbinary(max)) AND o.RefNum=0 AND o.Proforma=0 AND o.Partition IS NOT NULL AND o.Partition<>0 AND o.RecId IS NOT NULL AND o.RecId<>0 AND o.dataAreaId IS NOT NULL AND DATALENGTH(o.dataAreaId)>0 AND o.InvoiceId IS NOT NULL AND DATALENGTH(o.InvoiceId)>0 AND pt.PartitionKey IS NOT NULL AND DATALENGTH(pt.PartitionKey)>0 AND m.RecId IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'CustInvoiceJour',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustInvoiceJour',N'U') AND OBJECT_ID(N'CustInvoiceTrans',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustInvoiceTrans',N'U') AND OBJECT_ID(N'Partitions',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.Partitions',N'U') AND OBJECT_ID(N'CustTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CustTable',N'U') AND OBJECT_ID(N'DirPartyTable',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DirPartyTable',N'U') AND OBJECT_ID(N'InventDim',N'U')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.InventDim',N'U')",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "82B0DD9E-1D69-59B3-A381-7C7887D02A1C",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "4C5BE69D-2A2F-5123-962D-F950C9364293",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "BC0259DB-B976-5D4D-98F8-0A8FAD4F1599",
"title": "Baris",
"urlKey": ""
},
{
"id": "41D43444-C1CD-5519-8C62-461F67FC79D8",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "5CE7F7DB-21F5-5FE7-9061-57CCC4BF13A7",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "A53C9550-FFCC-5C5B-A869-A9D38FE64F7C",
"title": "Pelanggan",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDate",
"label": "Tanggal faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun pelanggan penagih",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAmount",
"label": "Total faktur sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Tanggal jatuh tempo faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Jumlah baris dengan tautan antet",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "D08FAD4E-AE98-5ADB-BDA3-65DD4031B8C2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceId",
"label": "Nomor faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDate",
"label": "Tanggal faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "InvoicingName",
"label": "Nama penagihan pada faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun pelanggan penagih",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "OrderAccount",
"label": "Akun pelanggan pemesan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "PartitionKey",
"label": "Partisi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "dataAreaId",
"label": "Perusahaan tersimpan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "Origin",
"label": "Asal dokumen",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "OrderType",
"label": "Jenis pesanan sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "Correction",
"label": "Penanda koreksi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Faktur dan lingkup",
"detailRole": "information",
"isVisible": true,
"key": "AdvanceInvoice",
"label": "Penanda faktur uang muka",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Nilai faktur asli",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Nilai faktur asli",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAmount",
"label": "Total faktur sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nilai faktur asli",
"detailRole": "information",
"isVisible": true,
"key": "SalesBalance",
"label": "Total baris setelah diskon baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nilai faktur asli",
"detailRole": "information",
"isVisible": true,
"key": "EndDisc",
"label": "Diskon total faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nilai faktur asli",
"detailRole": "information",
"isVisible": true,
"key": "SumLineDisc",
"label": "Jumlah diskon baris faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nilai faktur asli",
"detailRole": "information",
"isVisible": true,
"key": "SumMarkup",
"label": "Biaya tambahan pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nilai faktur asli",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceRoundOff",
"label": "Pembulatan faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Jatuh tempo dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Tanggal jatuh tempo faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jatuh tempo dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "FixedDueDate",
"label": "Jatuh tempo tetap sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jatuh tempo dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "Payment",
"label": "Kode syarat pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jatuh tempo dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "PaymentSched",
"label": "Kode jadwal pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Jatuh tempo dan pembayaran",
"detailRole": "information",
"isVisible": true,
"key": "PaymDayId",
"label": "Kode hari pembayaran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon tunai bersyarat",
"detailRole": "information",
"isVisible": true,
"key": "CashDiscCode",
"label": "Kode diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon tunai bersyarat",
"detailRole": "information",
"isVisible": true,
"key": "CashDisc",
"label": "Jumlah diskon tunai bersyarat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Diskon tunai bersyarat",
"detailRole": "information",
"isVisible": true,
"key": "CashDiscPercent",
"label": "Diskon tunai (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Diskon tunai bersyarat",
"detailRole": "information",
"isVisible": true,
"key": "CashDiscDate",
"label": "Batas diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Diskon tunai bersyarat",
"detailRole": "information",
"isVisible": true,
"key": "CashDiscBaseDate",
"label": "Tanggal dasar diskon tunai",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi pembukuan dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "LedgerVoucher",
"label": "Nomor voucher pembukuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi pembukuan dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "DocumentNum",
"label": "Nomor dokumen transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi pembukuan dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDate",
"label": "Tanggal dokumen transaksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi pembukuan dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "SalesId",
"label": "Referensi pesanan atau proyek antet",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi pembukuan dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "PurchaseOrder",
"label": "Nomor permintaan pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi pembukuan dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "CustomerRef",
"label": "Referensi pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi pembukuan dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "CustGroup",
"label": "Grup pelanggan faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Referensi pembukuan dan pesanan",
"detailRole": "information",
"isVisible": true,
"key": "PostingProfile",
"label": "Kode profil pembukuan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan tautan baris",
"detailRole": "information",
"isVisible": true,
"key": "DlvMode",
"label": "Kode cara pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan tautan baris",
"detailRole": "information",
"isVisible": true,
"key": "DlvTerm",
"label": "Kode syarat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan tautan baris",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryName",
"label": "Nama alamat pengiriman",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan tautan baris",
"detailRole": "information",
"isVisible": true,
"key": "inventLocationId",
"label": "Kode gudang faktur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan tautan baris",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Jumlah baris dengan tautan antet",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Pengiriman dan tautan baris",
"detailRole": "information",
"isVisible": true,
"key": "LineReferenceConflictCount",
"label": "Tautan dengan nomor atau tanggal berbeda",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "1A1E52AE-9436-5F0E-931C-34C495D0AA02",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "65384408-41EC-555C-8D05-E3777B3945C3",
"includeAllOption": false,
"key": "PeriodDate",
"title": "Periode tanggal faktur",
"type": "date"
},
{
"id": "2ABFB427-27FD-5002-8E5A-D1782FECAED0",
"includeAllOption": false,
"key": "PartitionKey",
"title": "Partisi",
"type": "text"
},
{
"id": "66C2D089-E1AE-5E36-A893-61BBE5E755AC",
"includeAllOption": false,
"key": "dataAreaId",
"title": "Perusahaan tersimpan",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "859554C5-01D8-52DC-99BB-01C93F2B75C9",
"key": "PeriodDate",
"type": "date"
},
{
"direction": "ascending",
"id": "002A79F1-506E-5C36-93B7-CB7C709835B6",
"key": "InvoiceId",
"type": "text"
},
{
"direction": "ascending",
"id": "1FBAFB24-87C8-5993-9B00-F74D2B1076CD",
"key": "InvoiceKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "InvoicingName",
"systemImage": "doc.text",
"title": "Faktur pelanggan",
"titleKey": "InvoiceId"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Qty",
"label": "Jumlah faktur (satuan jual)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SalesUnit",
"label": "Satuan jual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SalesPrice",
"label": "Harga per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PriceUnit",
"label": "Satuan per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineAmount",
"label": "Nilai baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "BC0259DB-B976-5D4D-98F8-0A8FAD4F1599",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Baris dan referensi faktur",
"detailRole": "information",
"isVisible": true,
"key": "ItemId",
"label": "Kode barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan referensi faktur",
"detailRole": "information",
"isVisible": true,
"key": "Name",
"label": "Deskripsi baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan referensi faktur",
"detailRole": "information",
"isVisible": true,
"key": "ExternalItemId",
"label": "Kode barang pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan referensi faktur",
"detailRole": "information",
"isVisible": true,
"key": "LineNum",
"label": "Nomor urut baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Baris dan referensi faktur",
"detailRole": "information",
"isVisible": true,
"key": "CustomerLineNum",
"label": "Nomor baris pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Baris dan referensi faktur",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceId",
"label": "Nomor faktur pada baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan referensi faktur",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDate",
"label": "Tanggal faktur pada baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan referensi faktur",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceReferenceCheck",
"label": "Konsistensi nomor dan tanggal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan referensi faktur",
"detailRole": "information",
"isVisible": true,
"key": "SalesId",
"label": "Pesanan pada baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan referensi faktur",
"detailRole": "information",
"isVisible": true,
"key": "OrigSalesId",
"label": "Pesanan asal tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Baris dan referensi faktur",
"detailRole": "information",
"isVisible": true,
"key": "InventRefId",
"label": "Referensi pesanan proyek atau produksi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan satuan",
"detailRole": "information",
"isVisible": true,
"key": "Qty",
"label": "Jumlah faktur (satuan jual)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Kuantitas dan satuan",
"detailRole": "information",
"isVisible": true,
"key": "SalesUnit",
"label": "Satuan jual",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Kuantitas dan satuan",
"detailRole": "information",
"isVisible": true,
"key": "InventQty",
"label": "Jumlah dalam satuan inventaris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "CurrencyCode",
"label": "Mata uang baris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "SalesPrice",
"label": "Harga per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "PriceUnit",
"label": "Satuan per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "LineAmount",
"label": "Nilai baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "LineDisc",
"label": "Diskon baris per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "LinePercent",
"label": "Diskon baris (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "MultiLnDisc",
"label": "Diskon multibaris per unit harga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "MultiLnPercent",
"label": "Diskon multibaris (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "DiscAmount",
"label": "Jumlah diskon transaksi sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "DiscPercent",
"label": "Diskon transaksi (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "SalesMarkup",
"label": "Biaya harga tetap sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Harga dan diskon sumber",
"detailRole": "information",
"isVisible": true,
"key": "SumLineDisc",
"label": "Total diskon baris sumber",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InventSiteId",
"label": "Kode lokasi dimensi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InventLocationId",
"label": "Kode gudang dimensi",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "wMSLocationId",
"label": "Kode tempat gudang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "inventBatchId",
"label": "Kode batch",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "inventSerialId",
"label": "Nomor seri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "configId",
"label": "Kode konfigurasi barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InventColorId",
"label": "Kode warna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InventSizeId",
"label": "Kode ukuran",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dimensi barang saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InventStyleId",
"label": "Kode gaya",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "DlvDate",
"label": "Pengiriman dikonfirmasi atau diminta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "TaxGroup",
"label": "Kode grup pajak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan kode pajak",
"detailRole": "information",
"isVisible": true,
"key": "TaxItemGroup",
"label": "Kode pajak barang",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "5D103763-4AF2-5DAA-B1D1-8F93307D331A",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "AA367C24-B913-596B-AFB8-936AF6AA00E1",
"key": "LineNum",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemId",
"systemImage": "list.bullet",
"title": "Baris faktur pelanggan",
"titleKey": "Name"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CustGroup",
"label": "Grup pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PaymTermId",
"label": "Kode syarat pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BlockStatus",
"label": "Penangguhan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "A53C9550-FFCC-5C5B-A869-A9D38FE64F7C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "CustomerName",
"label": "Nama pelanggan saat ini",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "AccountNum",
"label": "Akun pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "KnownAs",
"label": "Nama dikenal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "NameAlias",
"label": "Alias pencarian",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PartyNumber",
"label": "Nomor pihak",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Identitas saat ini",
"detailRole": "information",
"isVisible": true,
"key": "CustGroup",
"label": "Grup pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Mata uang faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAccount",
"label": "Akun penerima faktur bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PaymTermId",
"label": "Kode syarat pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "PaymMode",
"label": "Kode metode pembayaran bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Penagihan bawaan saat ini",
"detailRole": "information",
"isVisible": true,
"key": "OurAccountNum",
"label": "Akun kita pada pelanggan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan status saat ini",
"detailRole": "information",
"isVisible": true,
"key": "DlvMode",
"label": "Kode cara pengiriman bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan status saat ini",
"detailRole": "information",
"isVisible": true,
"key": "DlvTerm",
"label": "Kode syarat pengiriman bawaan",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan status saat ini",
"detailRole": "information",
"isVisible": true,
"key": "BlockStatus",
"label": "Penangguhan tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pengiriman dan status saat ini",
"detailRole": "information",
"isVisible": true,
"key": "CreditRating",
"label": "Peringkat kredit tercatat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "ADEF52E3-B710-5AF8-A202-84D29BC8DD2C",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "81F2AA9E-89D6-59B0-8AF0-BE212938DABE",
"key": "CustomerName",
"type": "text"
},
{
"direction": "ascending",
"id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
"key": "CustomerKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountNum",
"systemImage": "person.2",
"title": "Pelanggan penagihan saat ini",
"titleKey": "CustomerName"
}
],
"relations": [
{
"childDatasetID": "BC0259DB-B976-5D4D-98F8-0A8FAD4F1599",
"childKey": "ParentInvoiceKey",
"id": "4C5BE69D-2A2F-5123-962D-F950C9364293",
"name": "Baris",
"parentDatasetID": "D08FAD4E-AE98-5ADB-BDA3-65DD4031B8C2",
"parentKey": "InvoiceKey"
},
{
"childDatasetID": "A53C9550-FFCC-5C5B-A869-A9D38FE64F7C",
"childKey": "ParentInvoiceKey",
"id": "5CE7F7DB-21F5-5FE7-9061-57CCC4BF13A7",
"name": "Pelanggan",
"parentDatasetID": "D08FAD4E-AE98-5ADB-BDA3-65DD4031B8C2",
"parentKey": "InvoiceKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Microsoft Dynamics AX",
"configurationLanguages": [
"id"
],
"countries": [
"ID"
],
"createdAt": "2026-10-09T00:00:00Z",
"description": "TIDAK RESMI — BELUM DIVALIDASI PADA INSTALASI ERP NYATA.\n\nUntuk penjualan, administrasi penagihan dan manajer: pilih periode faktur, partisi dan perusahaan. Lihat nama penagihan yang tersimpan, nilai dan mata uang faktur, jatuh tempo, diskon serta referensi pembukuan. Baris membuka barang, jumlah jual/inventaris, harga, diskon, pesanan asal dan dimensi. Pelanggan membuka kondisi master penagihan SAAT INI. 95 posisi berguna dalam Detil.\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\nEDISI KHUSUS: AX 2012 R3 on-premises SQL Server, untuk instalasi lama yang sudah ada. Dukungan diperpanjang berakhir 11 Januari 2023; bukan rekomendasi pemasangan ERP lama atau server terbuka ke internet. Bukan AX 2009, Dynamics 365 Finance/SCM, Business Central atau SQL cloud. Pro nyata: satu sumber, satu Home, tiga daftar dan dua sub-tombol lazy. Tidak ada refresh berkala.\n\nLINGKUP: hanya RefNum=SalesOrder(0) dan Proforma=No(0), dari tipe dan rantai EDT resmi masing-masing. Bukan semua modul faktur/proyek/piutang/bunga. Retur, koreksi dan uang muka tidak dihapus diam-diam: jenis pesanan serta penanda asli terlihat. Ya pada koreksi bukan otomatis status nota kredit; nilai negatif/nol/NULL dipertahankan. Kode asing dan NULL penanda ditampilkan, bukan ditebak.\n\nTAUTAN BARIS: hanya ParentRecId dengan partisi dan DATAAREAID tersimpan tepat. Field Int64 dan relasi bernama CustInvoiceJour_ParentRecId tersedia dalam AOT R3, tetapi daftar kolom FK fisik pada referensi kosong. Administrator WAJIB memverifikasi pemetaan, populasi ParentRecId, kunci, indeks dan kelengkapan setiap alur posting pada instalasi sebelum memakai konfigurasi. Belum diverifikasi pada ERP nyata. Tidak ada fallback nomor faktur/tanggal/SalesId yang dapat mencampur dokumen. Baris bernomor/tanggal berbeda tetap ditampilkan dengan peringatan; jumlah konflik terlihat di Detil faktur. Jumlah baris hanya tautan ini, bukan jaminan seluruh baris faktur tersedia. Nol bukan bukti faktur tanpa baris. Dokumen konsolidasi dapat memiliki SalesId baris berbeda; tidak dipaksa sama dengan antet. Baris anak tidak difilter ulang menurut periode.\n\nNILAI ASLI: InvoiceAmount adalah total sumber dalam CurrencyCode faktur, bukan saldo belum dibayar. SalesBalance adalah total baris setelah diskon baris; EndDisc adalah jumlah diskon total, bukan kode grup. SumLineDisc, SumMarkup dan InvoiceRoundOff tidak dijumlah ulang menjadi formula faktur. Diskon tunai bersyarat bukan bukti pembayaran atau potongan yang benar-benar digunakan. Kode syarat/jadwal pembayaran dan nomor voucher bukan status lunas. Tidak ada saldo, margin, pembayaran, pajak atau total lintas mata uang dihitung. SumTax dengan deskripsi referensi ambigu dan TaxAmount dalam mata uang penyelesaian pajak tidak disalahlabeli sebagai PPN dalam mata uang faktur. Semua jumlah MST dihilangkan tanpa bukti mata uang akuntansi.\n\nKUANTITAS/HARGA: Qty dalam SalesUnit, InventQty dalam satuan inventaris; satuan inventaris tidak ditebak. SalesPrice dan diskon nominal per PriceUnit, bukan otomatis per satu barang. Nilai LineAmount dan mata uang baris dipertahankan sendiri. PriceUnit=0/NULL tidak dibagi; tidak ada Qty x harga, total campuran satuan, konversi atau deduplikasi kosmetik. Dimensi InventDim opsional adalah kode konteks saat ini, bukan stok, nama produk terjemahan atau dimensi akuntansi. Dimensi hilang tidak menghapus baris.\n\nKONTEKS PELANGGAN: nama InvoicingName adalah salinan pada faktur; sub-tombol memakai InvoiceAccount penagihan saat ini, bukan OrderAccount atau nama historis. Mata uang/syarat master dapat berbeda dengan faktur. Master hilang tidak menghapus faktur/baris. Tidak ada alamat lengkap, kontak privat, bank, identitas pemerintah, audit atau CreditMax dengan mata uang yang ditebak. Nama bisnis bisa merupakan data pribadi; hanya gunakan akses berwenang.\n\nAKSES/KINERJA: periode InvoiceDate, partisi dan perusahaan dipilih sebelum batas 1.000 baris; batas bukan jaminan kueri murah, kelengkapan atau ekspor. Seluruh anak meneruskan partisi, perusahaan, RecId dan nomor faktur tepat; Int64 sebagai teks utuh, pencocokan biner membedakan huruf besar/kecil dan spasi akhir. Filter bukan ACL; SQL langsung tidak mewarisi AOS/XDS atau izin AX. Gunakan akun SELECT terbatas pada server; perusahaan virtual perlu pemetaan administrator.\n\nDOKUMENTASI: AOT asli Microsoft, bukan sertifikat DDL SQL instalasi. Verifikasi R3, modul, schema pemilik, kolom, FK, kunci, izin, waktu dan kelengkapan lokal, lalu lakukan uji baca terbatas saat impor. Paket/DEMO tanpa kredensial/server/data perusahaan nyata. Tes SQLite adaptasi bukan SQL Server atau ERP nyata.\n\nReferensi faktur: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg942113(v=ax.60)\nReferensi baris: https://learn.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg943036(v=ax.60)\nSiklus dukungan: https://learn.microsoft.com/en-us/lifecycle/products/dynamics-ax-2012-r3",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "AD2D9D24-5F97-5C14-BDDA-AF20D0753473",
"rootButtonCount": 1,
"summary": "Faktur pesanan per periode/partisi/perusahaan; nilai, jatuh tempo, diskon, baris dan master penagihan saat ini.",
"tags": [
"Dynamics AX 2012 R3",
"SQL Server",
"Faktur pelanggan",
"Jatuh tempo",
"Baris faktur",
"Pro"
],
"title": "Faktur pelanggan, baris dan pelanggan penagihan — Pro"
}
}