Sage 300 Data Warehouse Pre-mapped Tables

Home/Sage 300 Data Warehouse Pre-mapped Tables

List of pre-mapped Sage 300 tables available as of 05/05/2018:

APIBDO
APIBD
APIBHO
APIBH
APOBS
APPJD
APRAS
APRDC
APRTA
APVEN
APVGR
ARCSP
ARCUSO
ARCUS
ARGRO
ARIBDO
ARIBD
ARIBHO
ARIBH
ARITH
AROBL
AROBS
ARPJD
ARRAS
ARSAP
BKACCT
CSCOM
CSFSC
CSOPTFD
CSOPTFH
GLACGRP
GLAFS
GLAMFO
GLAMF
GLASV
GLPOSTO
GLPOST
GLSRCE
ICACCT
ICCATG
ICHIST
ICILOC
ICITEMO
ICITEM
ICLOC
ICPRIC
ICUNIT
OEAUDDP
OEAUDD
OEAUDD
OEAUDHP
OEAUDH
OEAUDH
OEAUDH
OECRDDO
OECRDD
OECRDHO
OECRDH
OEINVDO
OEINVD
OEINVHO
OEINVH
OEMISC
OEORDDO
OEORDD
OEORDHO
OEORDH
OESHDT
OESTATS
OETERMI
PMCATGT
PMCONTS
PMCONTT
PMPROJS
PMPROJT
PMRES
PMTRAN
POHSTL
POPORH1
POPORHO
POPORLO
POPORL

Only the most popular fields for reporting purposes are pre-mapped out of the box. It’s simple to import additional fields from pre-mapped tables.