SQL Journal/ Report Writer Conversion Table

Design Reports

When you run the DBF to SQL data import in the EnsiteEBS Utility Program, you create specific fields in the SQL tables that mimic fields from Report Writer Dynamic files. The following table maps the connection between the Report Writer and SQL table fields.

SQL Table	SQL Field	Report Writer Totals File	Report Writer Field Name
SalesOrderJournalDetail	ShippedGross	U1-TOTALS	ITEM EXT LIST
SalesOrderJournalDetail	ShippedHoldDiscount	U6-TOTALS	Item Ext Hold Disc
SalesOrderJournalDetail	ShippedTotalTax	U-TOTALS	TAX AMOUNT
SalesOrderJournalDetail	ShippedGSTTax	U1-TOTALS	TOTAL GST TAX
SalesOrderJournalDetail	ShippedNet	U-TOTALS	EXT. SELL
SalesOrderJournalDetail	ShippedNonTaxable	U-TOTALS	NON TAXABLE
SalesOrderJournalDetail	ShippedSalesCost	U-TOTALS	EXT. COST
SalesOrderJournalDetail	OrderedGross	U1-TOTALS	ITEM EXT LIST
SalesOrderJournalDetail	OrderedHoldDiscount	U6-TOTALS	Item Ext Hold Disc
SalesOrderJournalDetail	OrderedTotalTax	U-TOTALS	TAX AMOUNT
SalesOrderJournalDetail	OrderedGSTTax	U1-TOTALS	TOTAL GST TAX
SalesOrderJournalDetail	OrderedNet	U-TOTALS	EXT. SELL
SalesOrderJournalDetail	OrderedNonTaxable	U-TOTALS	NON TAXABLE
SalesOrderJournalDetail	OrderedSalesCost	U-TOTALS	EXT. COST

SalesOrderJournal	ShippedGross	U1-TOTALS	ITEM EXT LIST
SalesOrderJournal	ShippedHoldDiscount	U6-TOTALS	Item Ext Hold Disc
SalesOrderJournal	ShippedTotalTax	U-TOTALS	TAX AMOUNT
SalesOrderJournal	ShippedGSTTax	U1-TOTALS	TOTAL GST TAX
SalesOrderJournal	ShippedNet	U-TOTALS	EXT. SELL
SalesOrderJournal	ShippedNonTaxable	U-TOTALS	NON TAXABLE
SalesOrderJournal	ShippedSalesCost	U-TOTALS	EXT. COST
SalesOrderJournal	OrderedGross	U1-TOTALS	ITEM EXT LIST
SalesOrderJournal	OrderedHoldDiscount	U6-TOTALS	Item Ext Hold Disc
SalesOrderJournal	OrderedTotalTax	U-TOTALS	TAX AMOUNT
SalesOrderJournal	OrderedGSTTax	U1-TOTALS	TOTAL GST TAX
SalesOrderJournal	OrderedNet	U-TOTALS	EXT. SELL
SalesOrderJournal	OrderedNonTaxable	U-TOTALS	NON TAXABLE
SalesOrderJournal	OrderedSalesCost	U-TOTALS	EXT. COST