Sage X3 Data Warehouse Pre-mapped Tables

Home/Sage X3 Data Warehouse Pre-mapped Tables

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

AFCTFCY
ATEXTRA
BALANA
BALANCE
BPADDRESS
BPARTNER
BPCCATEG
BPCUSTOMER
BPDLVCUST
BPSCATEG
BPSUPPLIER
BUD
BUDODS
CACCE
COMPANY
CPTANALIN
FACGROUP
FACILITY
FISCALYEAR
GACCCLS
GACCCODE
GACCDUDATE
GACCENTRY
GACCENTRYA
GACCENTRYD
GACCOUNT
GCOA
ITMBPC
ITMBPS
ITMCATEG
ITMFACILIT
ITMMASTER
ITMMVT
PERIOD
PINVOICE
PINVOICED
PORDER
PORDERP
PORDERQ
POSCOD
PVCRFOOT
SALESREP
SINVOICE
SINVOICED
SINVOICEV
SORDER
SORDERP
SORDERQ
SPRICLIST
STOJOU
TABCHANGE
TABCUR
TABLINCFG
TABPAYTERM
TABPIVTYP
TABUNIT
TMPBLA

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.