Page Comparison

...

The following pre-mapped ETL+ tables (or SQL Views) are available for JAMIS Prime v7.0 or newer as of 07/2023. This applies to JAMIS Prime on-premises, private cloud, or public cloud (OData v3 and v4). Subject to change without notice.

Source	Table Name	BI Template Code
Acumatica	Account	CF, GF, GT, IT, PO
Acumatica	AccountClass	CF, GF, GT, PO
Acumatica	Address	AR, SI, SO
Acumatica	AMBomItem	MB
Acumatica	AMBomMatl	MB
Acumatica	AMBomOper	MB
Acumatica	AMBomOvhd	MB
Acumatica	AMBomStep	MB
Acumatica	AMOrderType	MW
Acumatica	AMProdItem	MW
Acumatica	AMProdMatl	MW
Acumatica	AMProdOper	MW
Acumatica	AMProdOvhd	MW
Acumatica	AMProdStep	MW
Acumatica	AMProdTool	MW
Acumatica	AMProdTotal	MW
Acumatica	APInvoice	AP
Acumatica	APRegister	AP, CF
Acumatica	ARInvoice	AR, CF
Acumatica	ARRegister	AR, CF
Acumatica	ARTran	SI
Acumatica	BAccount	AP, AR, CA, CF, IO, IH, IP, IT, PM, PO, SI, SO
Acumatica	Branch	ALL
Acumatica	Company	ALL
Acumatica	Contact	CA, CO
Acumatica	CRActivity	CA
Acumatica	CRAddress	CA, CO
Acumatica	CRCampaign	CA, CO
Acumatica	CRContact	CA, CO
Acumatica	CROpportunity	CO
Acumatica	CROpportunityProbability	CO
Acumatica	CROpportunityRevision	CO
Acumatica	CRSMEmail	CO
Acumatica	CSAnswers	TBD
Acumatica	Customer	AR, SI, SO
Acumatica	CustomerClass	AR, SI, SO
Acumatica	CustSalespeople	AR, SI, SO
Acumatica	EPEmployee	FS
Acumatica	FinPeriod	ALL
Acumatica	GLHistory	GF
Acumatica	GLHistoryByPeriod	GF
Acumatica	GLTran	CF, GT
Acumatica	INItemClass	IO, IH, IP, IT, PO, SI, SO
Acumatica	INItemCostHist	IH
Acumatica	INItemCostHistByPeriod	IH
Acumatica	INItemStats	IO, IH
Acumatica	INLocation	AR, IO, IH, IP, IT, PO, SI, SO
Acumatica	INLocationStatus	IO, IH
Acumatica	INRegister	IT
Acumatica	INSite	IO, IH, IP, IT, PO, SI, SO
Acumatica	INTran	IT
Acumatica	InventoryItem	IO, IH, IP, IT, PO, SI, SO
Acumatica	InventoryItemAMExtension	MB, MW
JAMIS Prime	EPEmployee	JDW
JAMIS Prime	JBPDetail	JDW
JAMIS Prime	JBPDetailValues	JDW
JAMIS Prime	JBPForecastBurdenAmountDetail	JDW
JAMIS Prime	JBPMaster	JDW
JAMIS Prime	JBPResourcePersonnel	JDW
JAMIS Prime	JBPType	JDW
JAMIS Prime	JCSOBS	JDW
JAMIS Prime	JCSOBSLevel	JDW
JAMIS Prime	JPMBillingRule	JDW
JAMIS Prime	JPMBillRevSummary	JDW
JAMIS Prime	JPMBurden	JDW
JAMIS Prime	JPMBurdenAmountType	JDW
JAMIS Prime	JPMBurdenPool	JDW
JAMIS Prime	JPMContract	JDW
JAMIS Prime	JPMContractClass	JDW
JAMIS Prime	JPMCostClass	JDW
JAMIS Prime	JPMCostClassType	JDW
JAMIS Prime	JPMCostElement	JDW
JAMIS Prime	JPMCosts	JDW
JAMIS Prime	JPMCostTypeCode	JDW
JAMIS Prime	JPMInvoiceHeader	JDW
JAMIS Prime	JPMInvoiceRule	JDW
JAMIS Prime	JPMJobCostBillingStatus	JDW
JAMIS Prime	JPMJobCostBurdenDetail	JDW
JAMIS Prime	JPMJobCostBurdenType	JDW
JAMIS Prime	JPMJobCostRevenueStatus	JDW
JAMIS Prime	JPMJobCostTran	JDW
JAMIS Prime	JPMLaborCategory	JDW
JAMIS Prime	JPMProjectBilling	JDW
JAMIS Prime	JPMSubContract	JDW
JAMIS Prime	JPMSubContractDetail	JDW
JAMIS Prime	JState	JDW
JAMIS Prime	JVendor	JDW
Acumatica	Ledger	GF, GT
Acumatica	Location	IO, IH, IP, IT, PO, SI, SO
Acumatica	PMAccountGroup	PM
Acumatica	PMBudget	PM
Acumatica	PMProforma	PM
Acumatica	PMProformaLine	PM
Acumatica	PMProject	PM
Acumatica	PMRegister	PM
Acumatica	PMTask	PM
Acumatica	PMTran	PM
Acumatica	POLine	PO
Acumatica	POOrder	PO
Acumatica	Salesperson	AR, SI, SO
Acumatica	Segment	GF, GT
Acumatica	SegmentValue	GF. GT
Acumatica	SOAddress	SI, SO
Acumatica	SOLine	SO
Acumatica	SOOrder	SI, SO
Acumatica	SOOrderType	SO
Acumatica	SOShipment	SO
Acumatica	Sub	ALL
Acumatica	Users	TBD
Acumatica	Vendor	AP, CF, IP, IT, MB, PO
Data Warehouse ACM	4_Today	ALL
Data Warehouse ACM	5_Date	ALL
Data Warehouse ACM	6_DatePeriod	GF, GT
Data Warehouse ACM	GLz_02_AccountOverrides	GF, GT
Data Warehouse ACM	GLz_03_SubAccountSegments	GF, GT
Data Warehouse ACM	GLz_10_C3_Detail	GF, GT
Data Warehouse ACM	GLz_12_C1_MajorTotal	GF
Data Warehouse ACM	GLz_14_C15_MinorTotal	GF
Data Warehouse ACM	GLz_16_C2_MinorTotal	GF
Data Warehouse ACM	GLz_50_Budget	GF, GT
Data Warehouse ACM	GLz_60_History_PL_YTD	GF
Data Warehouse ACM	GLz_70_CashFlow	CF
Data Warehouse ACM	INz_10_Inventory_Planning	IP
Data Warehouse JAMIS	JDW-FactTran_r	JDW
Data Warehouse JAMIS	JDW-FacTranSum_r	JDW
Data Warehouse JAMIS	JDW-JCSOBS_r	JDW
Data Warehouse JAMIS	JDW-JPMBillingRule_r	JDW
Data Warehouse JAMIS	JDW-JPMContract_r	JDW
Data Warehouse JAMIS	JDW-JPMCosts_r	JDW
Data Warehouse JAMIS	JDW-JPMInvoiceRule_r	JDW
Data Warehouse ACM	MFGz_BOM01_Item	MB
Data Warehouse ACM	MFGz_BOM02_Component	MB
Data Warehouse ACM	MFGz_BOM03_Header	MB
Data Warehouse ACM	MFGz_BOM10_Level0	MB
Data Warehouse ACM	MFGz_BOM11_Level1	MB
Data Warehouse ACM	MFGz_BOM12_Level2	MB
Data Warehouse ACM	MFGz_BOM13_Level3	MB
Data Warehouse ACM	MFGz_BOM14_Level4	MB
Data Warehouse ACM	MFGz_BOM15_Level5	MB
Data Warehouse ACM	MFGz_ProdOrder01_FixedOH	MW
Data Warehouse ACM	MFGz_ProdOrder02_Header	MW
Data Warehouse ACM	MFGz_ProdOrder03_Labor	MW
Data Warehouse ACM	MFGz_ProdOrder04_Mach	MW
Data Warehouse ACM	MFGz_ProdOrder05_Matl	MW
Data Warehouse ACM	MFGz_ProdOrder06_Tool	MW
Data Warehouse ACM	MFGz_ProdOrder07_ToolDetail	MW
Data Warehouse ACM	MFGz_ProdOrder08_VariableOH	MW
Data Warehouse	zLists_Acumatica	GF, GT, IT
Data Warehouse	zEntity	ALL

Notes:

Some of the above tables and views will only be deployed using customized SOWs or via services.
All DAC tables can be extracted into the data warehouse using OData.
All JAMIS Prime SQL tables can be extracted when you have direct access to JAMIS Prime’s database.
We only recommend extracting tables and columns that are important for your reporting purposes.

...

Versions Compared

Old Version 5

New Version Current

Key