Microsoft Dynamics GP 9

Cubes

Name	Quick Links
Sales and Receivables
Receivables	Overview	Measures	Dimensions
Sales	Overview	Measures	Dimensions
SCM
Inventory	Overview	Measures	Dimensions
Finance
Financials	Overview	Measures	Dimensions
Purchase and Payables
Payables	Overview	Measures	Dimensions
Purchase	Overview	Measures	Dimensions

Financials

Bus Matrix

	Account	Budget	Company	Financial Details	Period	Reporting	Transaction Origin
Beginning Balance	x		x	x	x	x	x
Budget Amount	x	x	x		x	x
Budget Beginning Balance	x	x	x		x	x
Budget Ending Balance	x	x	x		x	x
Credit Change	x		x	x	x	x	x
Debit Change	x		x	x	x	x	x
Ending Balance	x		x	x	x	x	x
Net Change	x		x	x	x	x	x

Measures

Calculations

Debit Change
Expression	[CurrencySelectionID]=2,[RepDebit], [CurrencySelectionID]=1,[OrigDebit],[FuncDebit]))
Visible to Users	True

Credit Change
Expression	[CurrencySelectionID]=2,[RepCredit], [CurrencySelectionID]=1,[OrigCredit],[FuncCredit]))
Visible to Users	True

Net Change
Expression	[CurrencySelectionID]=2,[RepDebit]-[RepCredit], [CurrencySelectionID]=1,[OrigDebit]-[OrigCredit],[FuncDebit]-[FuncCredit]))
Visible to Users	True

Ending Balance
Function	End Balance
Expression	[Max Date]
Visible to Users	True

Beginning Balance
Expression	[Ending Balance]-[wChangeAmount]
Visible to Users	True

Budget Amount
Expression	[CurrencySelectionID]=2,[RepBudgetAmount],[FuncBudgetAmount])
Visible to Users	True

Budget Ending Balance
Function	End Balance
Expression	[Max Date]
Visible to Users	True

Budget Beginning Balance
Expression	[Budget Ending Balance]-[wBudgetAmount]
Visible to Users	True

Dimensions

Account
Attributes
Name	Source	Description
Posting Type	wdPstngTyp.Text
Type	wdAcctType.Text
Description	dGL00100.ACTDESCR
Alias	dGL00100.ACTALIAS
Category	dGL00102.ACCATDSC
Number	dGL00100.wACTNUMBR
Main Segment	dGL00100.MNACSGMT
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Segment 1	Segment 1
Segment 2	Segment 2
Segment 3	Segment 3
Segment 4	Segment 4
Segment 5	Segment 5
Segment 6	Segment 6
Segment 7	Segment 7
Segment 8	Segment 8
Segment 9	Segment 9
Segment 10	Segment 10

Budget
Attributes
Name	Source	Description
Name	dGL00200.BUDGETID
Comment	dGL00200.BUDCOMNT

Company
Attributes
Name	Source	Description
Name	wdCompany.wCompanyName

Currency
Attributes
Name	Source	Description
Selector	wdCurrencySelector.Text

Financial Details
Attributes
Name	Source	Description
Journal Entry	fGL20000.JRNENTRY
Source	dSY00900.SDOCDSCR
Series	wdSeries.Text
Currency	fGL20000.CURNCYID
Intercompany Type	wdICTRX.Text
Description	fGL20000.DSCRIPTN

Period
Attributes
Name	Source	Description
Year	wdPeriod.YearName
Quarter	wdPeriod.QuarterName
Month	wdPeriod.MonthName
Date	wdPeriod.DateName
Fiscal Year	wdFiscalPeriod.Year
Fiscal Period	wdFiscalPeriod.PeriodName
Calendar Date	wdPeriod.DateName
Calendar Month	wdPeriod.CalendarMonthName
Calendar Quarter	wdPeriod.CalendarQuarterName
Calendar Year	wdPeriod.CalendarYearName
Week	wdPeriod.WeekName
Week Year	wdPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Fiscal Hierarchy
Level Name	Source Attribute	Description
Fiscal Year	Fiscal Year
Fiscal Period	Fiscal Period
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Reporting
Attributes
Name	Source	Description
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Report	Report
Row	Row
Account	Account

Transaction Origin
Attributes
Name	Source	Description
Text	wdHistType.Text

Inventory

Bus Matrix

	Company	Customer	Inventory Details	Item	Period	Site	Transaction Origin	Transaction Type	Vendor
Average Unit Cost	x	x	x	x	x	x	x	x	x
Average Value at Cost	x	x	x	x	x	x	x	x	x
Closing On Hand	x	x	x	x	x	x	x	x	x
Closing Value	x	x	x	x	x	x	x	x	x
COGS	x	x	x	x	x	x	x	x	x
Cost	x	x	x	x	x	x	x	x	x
Current Cost	x	x	x	x	x	x	x	x	x
Inventory Turnover at Cost	x	x	x	x	x	x	x	x	x
Opening On Hand	x	x	x	x	x	x	x	x	x
Opening Value	x	x	x	x	x	x	x	x	x
Quantity	x	x	x	x	x	x	x	x	x
Quantity in Base UoM	x	x	x	x	x	x	x	x	x
Running Cost	x	x	x	x	x	x	x	x	x
Standard Cost	x	x	x	x	x	x	x	x	x

Measures

Quantity
Aggregate function	Sum
Source	fIV30300.TRXQTY
Visible to Users	True

Running Cost
Aggregate function	Sum
Source	fIV30300.EXTDCOST
Visible to Users	True

Quantity in Base UoM
Aggregate function	Sum
Source	fIV30300.wBaseUOMQuantity
Visible to Users	True

Standard Cost
Aggregate function	Sum
Source	fIV30300.wStandardCost
Visible to Users	True

Current Cost
Aggregate function	Sum
Source	fIV30300.wCurrentCost
Visible to Users	True

Calculations

Cost
Expression	[ValuationSelectionID]=2,[Standard Cost], [ValuationSelectionID]=1,[Current Cost],[Running Cost]))
Visible to Users	True

Closing On Hand
Function	End Balance
Expression	[Quantity in Base UoM]
Visible to Users	True

Opening On Hand
Expression	[Closing On Hand]-[Quantity in Base UoM]
Visible to Users	True

Closing Value
Function	End Balance
Expression	[wCostBase]
Visible to Users	True

Opening Value
Expression	[Closing Value]-[Cost]
Visible to Users	True

Average Unit Cost
Expression	[Cost]/[Quantity in Base UoM]
Visible to Users	True

Average Value at Cost
Expression	([Opening Value]+[Closing Value])/2
Visible to Users	True

COGS
Expression	(([wTransactionType].[Document Type].&[6],[Cost])+([wTransactionType].[Document Type].&[5],[Cost]))*(-1)
Visible to Users	True

Inventory Turnover at Cost
Expression	[COGS]/[Average Value at Cost]
Visible to Users	True

Dimensions

Company
Attributes
Name	Source	Description
Name	wdCompany.wCompanyName

Customer
Attributes
Name	Source	Description
Name	dRM00101.CUSTNAME
Short Name	dRM00101.SHRTNAME
Statement Name	dRM00101.STMTNAME
Number	dRM00101.CUSTNMBR
Priority	wdCustPriority.Text
Sales Territory	dRM00303.SLTERDSC
Sales Person	dRM00301.wFullName
Country Code	dVAT10001.CCodeDesc
Credit Limit	wdCrLmtTyp.Text
Class	dRM00201.CLASDSCR
Payment Terms	dRM00101.PYMTRMID

Inventory Details
Attributes
Name	Source	Description
Document Number	fIV30300.DOCNUMBR
History Module	fIV30300.HSTMODUL
Transaction Source	fIV30300.TRXSORCE

Item
Attributes
Name	Source	Description
Number	dIV00101.ITEMNMBR
Description	dIV00101.ITEMDESC
Type	wdItemType.Text
Short Name	dIV00101.ITMSHNAM
ABC Code	wdABCCode.Text
Class	dIV40400.ITMCLSDC
Selling Base UoM	dIV00101.SELNGUOM
Purchasing Base UoM	dIV00101.PRCHSUOM
Primary Vendor	dPM00200.VENDNAME

Period
Attributes
Name	Source	Description
Year	wdPeriod.YearName
Quarter	wdPeriod.QuarterName
Month	wdPeriod.MonthName
Date	wdPeriod.DateName
Fiscal Year	wdFiscalPeriod.Year
Fiscal Period	wdFiscalPeriod.PeriodName
Calendar Date	wdPeriod.DateName
Calendar Month	wdPeriod.CalendarMonthName
Calendar Quarter	wdPeriod.CalendarQuarterName
Calendar Year	wdPeriod.CalendarYearName
Week	wdPeriod.WeekName
Week Year	wdPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Fiscal Hierarchy
Level Name	Source Attribute	Description
Fiscal Year	Fiscal Year
Fiscal Period	Fiscal Period
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Site
Attributes
Name	Source	Description
Name	dIV40700.LOCNDSCR
Code	dIV40700.LOCNCODE

Transaction Origin
Attributes
Name	Source	Description
Text	wdHistType.Text

Transaction Type
Attributes
Name	Source	Description
Document Type	wdInventoryTransDirection.DocTypeName
Hierarchies
Direction
Level Name	Source Attribute	Description
wDirection	wDirection
Document Type	Document Type

Valutation Method
Attributes
Name	Source	Description
Selector	wdInventoryValutationMethod.Text

Vendor
Attributes
Name	Source	Description
Number	dPM00200.VENDORID
Name	dPM00200.VENDNAME
Short Name	dPM00200.VENDSHNM
Payment Terms	dPM00200.PYMTRMID
Country	dVAT10001.CCodeDesc

Payables

Bus Matrix

	Company	Due Period	Payables Details	Period	Transaction Origin	Vendor
Amount On Account	x	x	x	x	x	x
Average Balance	x	x	x	x	x	x
Closing Balance	x	x	x	x	x	x
Current Amount Remaining	x	x	x	x	x	x
Opening Balance	x	x	x	x	x	x
Original Amount	x	x	x	x	x	x
Payables Turnover Ratio	x	x	x	x	x	x
Purchase Amount	x	x	x	x	x	x

Measures

Amount On Account
Aggregate function	Sum
Source	wfPayables.ONACCOUNT
Visible to Users	True

Purchase Amount
Aggregate function	Sum
Source	wfPayables.PRCHAMNT
Visible to Users	True

Original Amount
Aggregate function	Sum
Source	wfPayables.DOCAMNT
Visible to Users	True

Current Amount Remaining
Aggregate function	Sum
Source	wfPayables.CURTRXAM
Visible to Users	True

Calculations

Closing Balance
Function	End Balance
Expression	[Amount On Account]
Visible to Users	True

Opening Balance
Expression	[Closing Balance]-[Amount On Account]
Visible to Users	True

Average Balance
Expression	([Closing Balance]+[Opening Balance])/2
Visible to Users	True

Payables Turnover Ratio
Expression	[Purchase Amount]/[Average Balance]
Visible to Users	True

Dimensions

Company
Attributes
Name	Source	Description
Name	wdCompany.wCompanyName

Due Period
Attributes
Name	Source	Description
Year	wdDuePeriod.YearName
Quarter	wdDuePeriod.QuarterName
Month	wdDuePeriod.MonthName
Date	wdDuePeriod.DateName
Week	wdDuePeriod.WeekName
Week Year	wdDuePeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Payables Details
Attributes
Name	Source	Description
Document Number	wfPayables.DOCNUMBR
Document Type	wdPMDOCTYPE.Text
Payment Type	wdPyentTyp.Text
Payment Terms	wfPayables.PYMTRMID

Period
Attributes
Name	Source	Description
Year	wdPeriod.YearName
Quarter	wdPeriod.QuarterName
Month	wdPeriod.MonthName
Date	wdPeriod.DateName
Fiscal Year	wdFiscalPeriod.Year
Fiscal Period	wdFiscalPeriod.PeriodName
Calendar Date	wdPeriod.DateName
Calendar Month	wdPeriod.CalendarMonthName
Calendar Quarter	wdPeriod.CalendarQuarterName
Calendar Year	wdPeriod.CalendarYearName
Week	wdPeriod.WeekName
Week Year	wdPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Fiscal Hierarchy
Level Name	Source Attribute	Description
Fiscal Year	Fiscal Year
Fiscal Period	Fiscal Period
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Transaction Origin
Attributes
Name	Source	Description
Text	wdHistType.Text

Vendor
Attributes
Name	Source	Description
Number	dPM00200.VENDORID
Name	dPM00200.VENDNAME
Short Name	dPM00200.VENDSHNM
Payment Terms	dPM00200.PYMTRMID
Country	dVAT10001.CCodeDesc

Purchase

Bus Matrix

	Company	Item	Order Period	Period	Purchase Order	Receipt_Invoice Details	Site	Transaction Origin	Vendor
Amount - Open Orders	x	x	x	x	x		x	x	x
Amount Cancelled - Open Orders	x	x	x	x	x		x	x	x
Amount Invoiced - Open Orders	x	x	x	x	x	x	x	x	x
Amount Received - Open Orders	x	x	x	x	x	x	x	x	x
Avg. Price - History	x	x	x	x	x		x	x	x
Avg. Price - Open Orders	x	x	x	x	x		x	x	x
Avg. Price - Total	x	x	x	x	x		x	x	x
Cancelled Amount - History	x	x	x	x	x		x	x	x
Cancelled Amount Total	x	x	x	x	x		x	x	x
Cancelled Quantity Total	x	x	x	x	x		x	x	x
Invoiced Amount - History	x	x	x	x	x	x	x	x	x
Invoiced Amount - Leaks	x	x	x	x	x	x	x	x	x
Invoiced Amount Total	x	x	x	x	x	x	x	x	x
Invoiced Quantity - Leaks	x	x	x	x	x	x	x	x	x
Invoiced Quantity Total	x	x	x	x	x	x	x	x	x
Number of Historic Orders	x	x	x	x	x		x	x	x
Number of Open Orders	x	x	x	x	x		x	x	x
Number of Total Orders	x	x	x	x	x		x	x	x
Order Amount - History	x	x	x	x	x		x	x	x
Order Amount Total	x	x	x	x	x		x	x	x
Order Quantity in Base UoM Total	x	x	x	x	x		x	x	x
Order Quantity Total	x	x	x	x	x		x	x	x
Quantity - History	x	x	x	x	x		x	x	x
Quantity - Open Orders	x	x	x	x	x		x	x	x
Quantity Cancelled - History	x	x	x	x	x		x	x	x
Quantity Cancelled - Open Orders	x	x	x	x	x		x	x	x
Quantity Invoiced - History	x	x	x	x	x	x	x	x	x
Quantity Invoiced - Open Orders	x	x	x	x	x	x	x	x	x
Quantity Received - History	x	x	x	x	x	x	x	x	x
Quantity Received - Open Orders	x	x	x	x	x	x	x	x	x
Received Amount - History	x	x	x	x	x	x	x	x	x
Received Amount - Leaks	x	x	x	x	x	x	x	x	x
Received Amount Total	x	x	x	x	x	x	x	x	x
Received not Invoiced Amount	x	x	x	x	x	x	x	x	x
Received not Invoiced Quantity	x	x	x	x	x	x	x	x	x
Received Quantity - Leaks	x	x	x	x	x	x	x	x	x
Received Quantity Total	x	x	x	x	x	x	x	x	x
Remaining Amount to Invoice	x	x	x	x	x	x	x	x	x
Remaining Amount to Receive	x	x	x	x	x	x	x	x	x
Remaining Quantity to Invoice	x	x	x	x	x	x	x	x	x
Remaining Quantity to Receive	x	x	x	x	x	x	x	x	x

Measures

Order Quantity Total
Aggregate function	Sum
Source	wfPurchaseOrderLines.wQtyOnOrder
Visible to Users	True

Cancelled Quantity Total
Aggregate function	Sum
Source	wfPurchaseOrderLines.QTYCANCE
Visible to Users	True

Order Quantity in Base UoM Total
Aggregate function	Sum
Source	wfPurchaseOrderLines.wQtyOnOrderBaseUoM
Visible to Users	True

Number of Total Orders
Aggregate function	DistinctCount
Source	wfPurchaseOrderLines.wInvoiceCount
Visible to Users	True

Received Quantity Total
Aggregate function	Sum
Source	wfPurchaseReceiptLines.QTYSHPPD
Visible to Users	True

Invoiced Quantity Total
Aggregate function	Sum
Source	wfPurchaseReceiptLines.QTYINVCD
Visible to Users	True

Calculations

Order Amount Total
Expression	[CurrencySelectionID]=2,[RepAmount], [CurrencySelectionID]=1,[OrigAmount],[FuncAmount]))
Visible to Users	True

Cancelled Amount Total
Expression	[RepCancelledAmount]), OrigCancelledAmount], FuncCancelledAmount])
Visible to Users	True

Received Amount Total
Expression	[CurrencySelectionID]=2,[RepReceivedAmount], [CurrencySelectionID]=1,[OrigReceivedAmount],[FuncReceivedAmount]))
Visible to Users	True

Invoiced Amount Total
Expression	[CurrencySelectionID]=2,[RepInvoicedAmount], [CurrencySelectionID]=1,[OrigInvoicedAmount],[FuncInvoicedAmount]))
Visible to Users	True

Received not Invoiced Amount
Expression	([wTransactionOrigin].[Text].&[2],[wReceivednotInvoicedAmount])
Visible to Users	True

Received not Invoiced Quantity
Expression	([wTransactionOrigin].[Text].&[2],[wReceivednotInvoicedQuantity])
Visible to Users	True

Remaining Amount to Invoice
Expression	([wTransactionOrigin].[Text].&[2],[wAmounttoInvoice])
Visible to Users	True

Remaining Amount to Receive
Expression	([wTransactionOrigin].[Text].&[2],[wAmounttoReceive])
Visible to Users	True

Remaining Quantity to Invoice
Expression	([wTransactionOrigin].[Text].&[2],[wQuantitytoInvoice])
Visible to Users	True

Remaining Quantity to Receive
Expression	([wTransactionOrigin].[Text].&[2],[wQuantitytoReceive])
Visible to Users	True

Number of Open Orders
Expression	([wTransactionOrigin].[Text].&[2],[Number of Total Orders])
Visible to Users	True

Amount - Open Orders
Expression	([wTransactionOrigin].[Text].&[2],[Order Amount Total])
Visible to Users	True

Amount Cancelled - Open Orders
Expression	([wTransactionOrigin].[Text].&[2],[Cancelled Amount Total])
Visible to Users	True

Amount Received - Open Orders
Expression	([wTransactionOrigin].[Text].&[2],[Received Amount Total])
Visible to Users	True

Amount Invoiced - Open Orders
Expression	([wTransactionOrigin].[Text].&[2],[Invoiced Amount Total])
Visible to Users	True

Quantity - Open Orders
Expression	([wTransactionOrigin].[Text].&[2],[Order Quantity Total])
Visible to Users	True

Quantity Cancelled - Open Orders
Expression	([wTransactionOrigin].[Text].&[2],[Cancelled Quantity Total])
Visible to Users	True

Quantity Received - Open Orders
Expression	([wTransactionOrigin].[Text].&[2],[Received Quantity Total])
Visible to Users	True

Quantity Invoiced - Open Orders
Expression	([wTransactionOrigin].[Text].&[2],[Invoiced Quantity Total])
Visible to Users	True

Number of Historic Orders
Expression	([wTransactionOrigin].[Text].&[1],[Number of Total Orders])
Visible to Users	True

Order Amount - History
Expression	([wTransactionOrigin].[Text].&[1],[Order Amount Total])
Visible to Users	True

Cancelled Amount - History
Expression	([wTransactionOrigin].[Text].&[1],[Cancelled Amount Total])
Visible to Users	True

Received Amount - History
Expression	([wTransactionOrigin].[Text].&[1],[Received Amount Total])
Visible to Users	True

Invoiced Amount - History
Expression	([wTransactionOrigin].[Text].&[1],[Invoiced Amount Total])
Visible to Users	True

Quantity - History
Expression	([wTransactionOrigin].[Text].&[1],[Order Quantity Total])
Visible to Users	True

Quantity Cancelled - History
Expression	([wTransactionOrigin].[Text].&[1],[Cancelled Quantity Total])
Visible to Users	True

Quantity Received - History
Expression	([wTransactionOrigin].[Text].&[1],[Received Quantity Total])
Visible to Users	True

Quantity Invoiced - History
Expression	([wTransactionOrigin].[Text].&[1],[Invoiced Quantity Total])
Visible to Users	True

Avg. Price - History
Expression	[Order Amount - History]/[Quantity - History]
Visible to Users	True

Avg. Price - Open Orders
Expression	[Amount - Open Orders]/[Quantity - Open Orders]
Visible to Users	True

Avg. Price - Total
Expression	[Order Amount Total]/[Order Quantity Total]
Visible to Users	True

Received Amount - Leaks
Expression	([wTransactionOrigin].[Text].&[5],[Received Amount Total])
Visible to Users	True

Invoiced Amount - Leaks
Expression	([wTransactionOrigin].[Text].&[5],[Invoiced Amount Total])
Visible to Users	True

Received Quantity - Leaks
Expression	([wTransactionOrigin].[Text].&[5],[Received Quantity Total])
Visible to Users	True

Invoiced Quantity - Leaks
Expression	([wTransactionOrigin].[Text].&[5],[Invoiced Quantity Total])
Visible to Users	True

Dimensions

Company
Attributes
Name	Source	Description
Name	wdCompany.wCompanyName

Currency
Attributes
Name	Source	Description
Selector	wdCurrencySelector.Text

Item
Attributes
Name	Source	Description
Number	dIV00101.ITEMNMBR
Description	dIV00101.ITEMDESC
Type	wdItemType.Text
Short Name	dIV00101.ITMSHNAM
ABC Code	wdABCCode.Text
Class	dIV40400.ITMCLSDC
Selling Base UoM	dIV00101.SELNGUOM
Purchasing Base UoM	dIV00101.PRCHSUOM
Primary Vendor	dPM00200.VENDNAME

Order Period
Attributes
Name	Source	Description
Year	wdPeriod.YearName
Quarter	wdPeriod.QuarterName
Month	wdPeriod.MonthName
Date	wdPeriod.DateName
Fiscal Year	wdFiscalPeriod.Year
Fiscal Period	wdFiscalPeriod.PeriodName
Calendar Date	wdPeriod.DateName
Calendar Month	wdPeriod.CalendarMonthName
Calendar Quarter	wdPeriod.CalendarQuarterName
Calendar Year	wdPeriod.CalendarYearName
Week	wdPeriod.WeekName
Week Year	wdPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Fiscal Hierarchy
Level Name	Source Attribute	Description
Fiscal Year	Fiscal Year
Fiscal Period	Fiscal Period
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Period
Attributes
Name	Source	Description
Year	wdPeriod.YearName
Quarter	wdPeriod.QuarterName
Month	wdPeriod.MonthName
Date	wdPeriod.DateName
Fiscal Year	wdFiscalPeriod.Year
Fiscal Period	wdFiscalPeriod.PeriodName
Calendar Date	wdPeriod.DateName
Calendar Month	wdPeriod.CalendarMonthName
Calendar Quarter	wdPeriod.CalendarQuarterName
Calendar Year	wdPeriod.CalendarYearName
Week	wdPeriod.WeekName
Week Year	wdPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Fiscal Hierarchy
Level Name	Source Attribute	Description
Fiscal Year	Fiscal Year
Fiscal Period	Fiscal Period
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Purchase Order
Attributes
Name	Source	Description
Number	wdPurchaseOrders.PONUMBER
Status	wdPOStatus.Text
Type	wdPOType.Text
Main Status	wdHistType.Text

Receipt_Invoice Details
Attributes
Name	Source	Description
PO Number	wfPurchaseReceiptLines.PONUMBER
Receipt Number	wfPurchaseReceiptLines.POPRCTNM
Receipt Type	wdPOPType.Text

Site
Attributes
Name	Source	Description
Name	dIV40700.LOCNDSCR
Code	dIV40700.LOCNCODE

Transaction Origin
Attributes
Name	Source	Description
Text	wdHistType.Text

Vendor
Attributes
Name	Source	Description
Number	dPM00200.VENDORID
Name	dPM00200.VENDNAME
Short Name	dPM00200.VENDSHNM
Payment Terms	dPM00200.PYMTRMID
Country	dVAT10001.CCodeDesc

Receivables

Bus Matrix

	Aging Bucket	Company	Customer	Due Period	Period	Receivable Details	Transaction Origin
Amount On Account	x	x	x	x	x	x	x
Average Balance	x	x	x	x	x	x	x
Closing Balance	x	x	x	x	x	x	x
Cost Amount	x	x	x	x	x	x	x
Credit Limit			x
Current Amount Remaining	x	x	x	x	x	x	x
Current Credit Utilization			x
Current Remaining Credit			x
Discounts taken	x	x	x	x	x	x	x
Opening Balance	x	x	x	x	x	x	x
Original Amount	x	x	x	x	x	x	x
Periodic Credit Utilization			x
Receivables Turnover Ratio	x	x	x	x	x	x	x
Sales Amount	x	x	x	x	x	x	x
Writeoffs	x	x	x	x	x	x	x

Measures

Original Amount
Description	Original Customer Transaction Amount
Aggregate function	Sum
Source	fRM20101.ORTRXAMT
Visible to Users	True

Current Amount Remaining
Description	Amount Currently Open for Customer Accounts
Aggregate function	Sum
Source	fRM20101.CURTRXAM
Visible to Users	True

Amount On Account
Description	Part of Transaction Amount actually on Customer accounts after Writeoffs, Discounts taken etc.
Aggregate function	Sum
Source	fRM20101.ONACCOUNT
Visible to Users	True

Sales Amount
Description	Sales Amount for Customer transactions
Aggregate function	Sum
Source	fRM20101.SLSAMNT
Visible to Users	True

Cost Amount
Description	Cost Amount for Customer transactions
Aggregate function	Sum
Source	fRM20101.COSTAMNT
Visible to Users	True

Discounts taken
Description	Discounts taken by customers that have been calculated against Original Transaction Amount
Aggregate function	Sum
Source	fRM20101.DISTKNAM
Visible to Users	True

Writeoffs
Description	Writeoffs calculated against transaction amount
Aggregate function	Sum
Source	fRM20101.WROFAMNT
Visible to Users	True

Calculations

Credit Limit
Expression	[wCreditLimit]
Visible to Users	True

Closing Balance
Function	End Balance
Expression	[Amount On Account]
Visible to Users	True

Opening Balance
Expression	[Closing Balance]-[Amount On Account]
Visible to Users	True

Current Remaining Credit
Expression	[Credit Limit]-[Current Amount Remaining]
Visible to Users	True

Current Credit Utilization
Expression	([Current Amount Remaining]/[Credit Limit])*100
Visible to Users	True

Periodic Credit Utilization
Expression	([Closing Balance]/[Credit Limit])*100
Visible to Users	True

Average Balance
Expression	([Closing Balance]+[Opening Balance])/2
Visible to Users	True

Receivables Turnover Ratio
Expression	[Sales Amount]/[Average Balance]
Visible to Users	True

Dimensions

Aging Bucket
Aging Distribution for Current Customer Balances. Aging Distribution for Current Customer Balances
Attributes
Name	Source	Description
Description	dRM40201.RMPERDSC

Company
Attributes
Name	Source	Description
Name	wdCompany.wCompanyName

Customer
Attributes
Name	Source	Description
Name	dRM00101.CUSTNAME
Short Name	dRM00101.SHRTNAME
Statement Name	dRM00101.STMTNAME
Number	dRM00101.CUSTNMBR
Priority	wdCustPriority.Text
Sales Territory	dRM00303.SLTERDSC
Sales Person	dRM00301.wFullName
Country Code	dVAT10001.CCodeDesc
Credit Limit	wdCrLmtTyp.Text
Class	dRM00201.CLASDSCR
Payment Terms	dRM00101.PYMTRMID

Due Period
Attributes
Name	Source	Description
Year	wdDuePeriod.YearName
Quarter	wdDuePeriod.QuarterName
Month	wdDuePeriod.MonthName
Date	wdDuePeriod.DateName
Week	wdDuePeriod.WeekName
Week Year	wdDuePeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Period
Attributes
Name	Source	Description
Year	wdPeriod.YearName
Quarter	wdPeriod.QuarterName
Month	wdPeriod.MonthName
Date	wdPeriod.DateName
Fiscal Year	wdFiscalPeriod.Year
Fiscal Period	wdFiscalPeriod.PeriodName
Calendar Date	wdPeriod.DateName
Calendar Month	wdPeriod.CalendarMonthName
Calendar Quarter	wdPeriod.CalendarQuarterName
Calendar Year	wdPeriod.CalendarYearName
Week	wdPeriod.WeekName
Week Year	wdPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Fiscal Hierarchy
Level Name	Source Attribute	Description
Fiscal Year	Fiscal Year
Fiscal Period	Fiscal Period
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Receivable Details
Attributes
Name	Source	Description
Document Number	fRM20101.DOCNUMBR
Document Type	wdRMDTyPal.Text

Transaction Origin
Attributes
Name	Source	Description
Text	wdHistType.Text

Sales

Bus Matrix

	Company	Customer	Document Type	Due Period	Item	Order Details	Period	Sales Details	Sales Person	Site	Transaction Origin
Cost	x	x	x	x	x		x	x	x	x	x
Cost on Open Invoices	x	x	x	x	x		x	x	x	x	x
Days Since Last Invoice	x	x	x	x	x		x	x	x	x	x
Discount on Open Invoices	x	x	x	x	x		x	x	x	x	x
Gross Order Amount	x	x	x	x	x	x	x		x	x	x
Gross Profit	x	x	x	x	x		x	x	x	x	x
Gross Profit on Open Invoices	x	x	x	x	x		x	x	x	x	x
Gross Sales	x	x	x	x	x		x	x	x	x	x
Gross Sales on Open Invoices	x	x	x	x	x		x	x	x	x	x
Number of Invoices	x	x	x	x	x		x	x	x	x	x
Number of Open Invoices	x	x	x	x	x		x	x	x	x	x
Number of Orders	x	x	x	x	x	x	x		x	x	x
Order Amount	x	x	x	x	x	x	x		x	x	x
Order Cost	x	x	x	x	x	x	x		x	x	x
Order Discount	x	x	x	x	x	x	x		x	x	x
Order Profit	x	x	x	x	x	x	x		x	x	x
Order Profit Margin	x	x	x	x	x	x	x		x	x	x
Order Quantity	x	x	x	x	x	x	x		x	x	x
Order Quantity in BAse UoM	x	x	x	x	x	x	x		x	x	x
Profit Margin	x	x	x	x	x		x	x	x	x	x
Profit Margin on Open Invoices	x	x	x	x	x		x	x	x	x	x
Qty in Base UoM on Open Invoices	x	x	x	x	x		x	x	x	x	x
Qty on Open Invoices	x	x	x	x	x		x	x	x	x	x
Quantity Sold	x	x	x	x	x		x	x	x	x	x
Quantity Sold in Base UoM	x	x	x	x	x		x	x	x	x	x
Sales	x	x	x	x	x		x	x	x	x	x
Sales on Open Invoices	x	x	x	x	x		x	x	x	x	x
Trade Discount	x	x	x	x	x		x	x	x	x	x

Measures

Order Quantity in BAse UoM
Aggregate function	Sum
Source	wfOrderLines.wBaseUOMQuantity
Visible to Users	True

Order Quantity
Aggregate function	Sum
Source	wfOrderLines.wQuantity
Visible to Users	True

Number of Orders
Aggregate function	DistinctCount
Source	wfOrderLines.wOrderCount
Visible to Users	True

Calculations

Gross Order Amount
Expression	[CurrencySelectionID]=2,[RepOrderAmount], [CurrencySelectionID]=1,[OrigOrderAmount],[FuncOrderAmount]))
Visible to Users	True

Order Discount
Expression	[CurrencySelectionID]=2,[RepOrderDiscount], [CurrencySelectionID]=1,[OrigOrderDiscount],[FuncOrderDiscount]))
Visible to Users	True

Order Amount
Expression	[Gross Order Amount]-[Order Discount]
Visible to Users	True

Order Cost
Expression	[CurrencySelectionID]=2,[RepOrderCost], [CurrencySelectionID]=1,[OrigOrderCost],[FuncOrderCost]))
Visible to Users	True

Order Profit
Expression	[Order Amount]-[Order Cost]
Visible to Users	True

Order Profit Margin
Expression	([Order Profit]/[Order Amount])*100
Visible to Users	True

Gross Sales
Expression	([wTransactionOrigin].[Text].&[1],[wGrossSales])
Visible to Users	True

Sales
Expression	([wTransactionOrigin].[Text].&[1],[wSales])
Visible to Users	True

Cost
Expression	([wTransactionOrigin].[Text].&[1],[wCost])
Visible to Users	True

Trade Discount
Expression	([wTransactionOrigin].[Text].&[1],[wTradeDiscount])
Visible to Users	True

Gross Profit
Expression	([wTransactionOrigin].[Text].&[1],[wGrossProfit])
Visible to Users	True

Profit Margin
Expression	([wTransactionOrigin].[Text].&[1],[wProfitMargin])
Visible to Users	True

Number of Invoices
Expression	([wTransactionOrigin].[Text].&[1],[wNumberofInvoices])
Visible to Users	True

Days Since Last Invoice
Expression	([wTransactionOrigin].[Text].&[1],[wDaysSinceLastInvoice])
Visible to Users	True

Quantity Sold
Expression	([wTransactionOrigin].[Text].&[1],[wQuantitySold])
Visible to Users	True

Quantity Sold in Base UoM
Expression	([wTransactionOrigin].[Text].&[1],[wQuantitySoldinBaseUoM])
Visible to Users	True

Gross Sales on Open Invoices
Expression	([wTransactionOrigin].[Text].&[0],[wGrossSales])
Visible to Users	True

Discount on Open Invoices
Expression	([wTransactionOrigin].[Text].&[0],[wTradeDiscount])
Visible to Users	True

Sales on Open Invoices
Expression	([wTransactionOrigin].[Text].&[0],[wSales])
Visible to Users	True

Cost on Open Invoices
Expression	([wTransactionOrigin].[Text].&[0],[wCost])
Visible to Users	True

Gross Profit on Open Invoices
Expression	([wTransactionOrigin].[Text].&[0],[wGrossProfit])
Visible to Users	True

Profit Margin on Open Invoices
Expression	([wTransactionOrigin].[Text].&[0],[wProfitMargin])
Visible to Users	True

Number of Open Invoices
Expression	([wTransactionOrigin].[Text].&[0],[wNumberofInvoices])
Visible to Users	True

Qty on Open Invoices
Expression	([wTransactionOrigin].[Text].&[0],[wQuantitySold])
Visible to Users	True

Qty in Base UoM on Open Invoices
Expression	([wTransactionOrigin].[Text].&[0],[wQuantitySoldinBaseUoM])
Visible to Users	True

Dimensions

Company
Attributes
Name	Source	Description
Name	wdCompany.wCompanyName

Currency
Attributes
Name	Source	Description
Selector	wdCurrencySelector.Text

Customer
CubeDimensionDescription
Attributes
Name	Source	Description
Name	dRM00101.CUSTNAME
Short Name	dRM00101.SHRTNAME
Statement Name	dRM00101.STMTNAME
Number	dRM00101.CUSTNMBR
Priority	wdCustPriority.Text
Sales Territory	dRM00303.SLTERDSC
Sales Person	dRM00301.wFullName
Country Code	dVAT10001.CCodeDesc
Credit Limit	wdCrLmtTyp.Text
Class	dRM00201.CLASDSCR
Payment Terms	dRM00101.PYMTRMID

Document Type
Attributes
Name	Source	Description
Name	wdSopType.Text

Due Period
Attributes
Name	Source	Description
Year	wdDuePeriod.YearName
Quarter	wdDuePeriod.QuarterName
Month	wdDuePeriod.MonthName
Date	wdDuePeriod.DateName
Week	wdDuePeriod.WeekName
Week Year	wdDuePeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Item
Attributes
Name	Source	Description
Number	dIV00101.ITEMNMBR
Description	dIV00101.ITEMDESC
Type	wdItemType.Text
Short Name	dIV00101.ITMSHNAM
ABC Code	wdABCCode.Text
Class	dIV40400.ITMCLSDC
Selling Base UoM	dIV00101.SELNGUOM
Purchasing Base UoM	dIV00101.PRCHSUOM
Primary Vendor	dPM00200.VENDNAME

Order Details
Attributes
Name	Source	Description
Unit of Measure	wfOrderLines.UOFM
Currency	wdOrderHeaders.CURNCYID
Document Number	wdOrderHeaders.SOPNUMBE
Payment Terms	wdOrderHeaders.PYMTRMID

Period
Attributes
Name	Source	Description
Year	wdPeriod.YearName
Quarter	wdPeriod.QuarterName
Month	wdPeriod.MonthName
Date	wdPeriod.DateName
Fiscal Year	wdFiscalPeriod.Year
Fiscal Period	wdFiscalPeriod.PeriodName
Calendar Date	wdPeriod.DateName
Calendar Month	wdPeriod.CalendarMonthName
Calendar Quarter	wdPeriod.CalendarQuarterName
Calendar Year	wdPeriod.CalendarYearName
Week	wdPeriod.WeekName
Week Year	wdPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Fiscal Hierarchy
Level Name	Source Attribute	Description
Fiscal Year	Fiscal Year
Fiscal Period	Fiscal Period
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Sales Details
Attributes
Name	Source	Description
Document Number	wdSOP30200_Sales.SOPNUMBE
Currency	wdSOP30200_Sales.CURNCYID
Unit of Measure	wfSOP30300_Sales.UOFM
Payment Terms	wdSOP30200_Sales.PYMTRMID

Sales Person
Attributes
Name	Source	Description
Name	dRM00301.wFullName

Site
Attributes
Name	Source	Description
Name	dIV40700.LOCNDSCR
Code	dIV40700.LOCNCODE

Transaction Origin
Attributes
Name	Source	Description
Text	wdHistType.Text

Data Transformations

GL20000 (YTD Transaction Open)	fGL20000
Source Field Name	Destination Field Name
OPENYEAR	OPENYEAR
JRNENTRY	JRNENTRY
SOURCDOC	SOURCDOC
REFRENCE	REFRENCE
DSCRIPTN	DSCRIPTN
TRXDATE	TRXDATE
TRXSORCE	TRXSORCE
ACTINDX	ACTINDX
CURNCYID	CURNCYID
CURRNIDX	CURRNIDX
XCHGRATE	XCHGRATE
EXCHDATE	EXCHDATE
PERIODID	PERIODID
DEBITAMT	DEBITAMT
ORCRDAMT	ORCRDAMT
ORDBTAMT	ORDBTAMT
DOCDATE	DOCDATE
CRDTAMNT	CRDTAMNT
ORGNATYP	ORGNATYP
SERIES	SERIES
ICTRX	ICTRX
DEX_ROW_ID	DEX_ROW_ID

GL00100 (Account)	dGL00100
Source Field Name	Destination Field Name
ACTINDX	ACTINDX
ACTNUMBR_1	ACTNUMBR_1
ACTNUMBR_2	ACTNUMBR_2
ACTNUMBR_3	ACTNUMBR_3
ACTNUMBR_4	ACTNUMBR_4
ACTALIAS	ACTALIAS
ACCTTYPE	ACCTTYPE
ACTDESCR	ACTDESCR
PSTNGTYP	PSTNGTYP
ACCATNUM	ACCATNUM
ACTIVE	ACTIVE
MNACSGMT	MNACSGMT
ACTNUMBR_5	ACTNUMBR_5
ACTNUMBR_6	ACTNUMBR_6
ACTNUMBR_7	ACTNUMBR_7
ACTNUMBR_8	ACTNUMBR_8
ACTNUMBR_9	ACTNUMBR_9
ACTNUMBR_10	ACTNUMBR_10

GL30000 (Account Transaction History)	fGL30000
Source Field Name	Destination Field Name
JRNENTRY	JRNENTRY
SOURCDOC	SOURCDOC
REFRENCE	REFRENCE
DSCRIPTN	DSCRIPTN
TRXDATE	TRXDATE
TRXSORCE	TRXSORCE
ACTINDX	ACTINDX
CURNCYID	CURNCYID
CURRNIDX	CURRNIDX
XCHGRATE	XCHGRATE
EXCHDATE	EXCHDATE
PERIODID	PERIODID
DEBITAMT	DEBITAMT
ORCRDAMT	ORCRDAMT
ORDBTAMT	ORDBTAMT
DOCDATE	DOCDATE
CRDTAMNT	CRDTAMNT
ORGNATYP	ORGNATYP
HSTYEAR	HSTYEAR
SERIES	SERIES
ICTRX	ICTRX
DEX_ROW_ID	DEX_ROW_ID

IV00101 (Item Master)	dIV00101
Source Field Name	Destination Field Name
ITEMNMBR	ITEMNMBR
ITEMDESC	ITEMDESC
ITMSHNAM	ITMSHNAM
ITEMTYPE	ITEMTYPE
ITMGEDSC	ITMGEDSC
STNDCOST	STNDCOST
CURRCOST	CURRCOST
ITMCLSCD	ITMCLSCD
VCTNMTHD	VCTNMTHD
ITEMCODE	ITEMCODE
ABCCODE	ABCCODE
Revalue_Inventory	Revalue_Inventory
ITMPLNNNGTYP	ITMPLNNNGTYP
UOMSCHDL	UOMSCHDL
PRCHSUOM	PRCHSUOM
SELNGUOM	SELNGUOM

RM00101 (Customer Master)	dRM00101
Source Field Name	Destination Field Name
CUSTNMBR	CUSTNMBR
CUSTNAME	CUSTNAME
CUSTCLAS	CUSTCLAS
CNTCPRSN	CNTCPRSN
STMTNAME	STMTNAME
SHRTNAME	SHRTNAME
ADRSCODE	ADRSCODE
SHIPMTHD	SHIPMTHD
COUNTRY	COUNTRY
PRBTADCD	PRBTADCD
PRSTADCD	PRSTADCD
STADDRCD	STADDRCD
SLPRSNID	SLPRSNID
PYMTRMID	PYMTRMID
CRLMTTYP	CRLMTTYP
CRLMTAMT	CRLMTAMT
CURNCYID	CURNCYID
SALSTERR	SALSTERR
INACTIVE	INACTIVE
CUSTPRIORITY	CUSTPRIORITY
CCode	CCode

SOP30300 (Sales transaction lines)	fSOP30300
Source Field Name	Destination Field Name
SOPTYPE	SOPTYPE
SOPNUMBE	SOPNUMBE
ITEMNMBR	ITEMNMBR
UOFM	UOFM
LOCNCODE	LOCNCODE
UNITCOST	UNITCOST
ORUNTCST	ORUNTCST
UNITPRCE	UNITPRCE
ORUNTPRC	ORUNTPRC
XTNDPRCE	XTNDPRCE
OXTNDPRC	OXTNDPRC
REMPRICE	REMPRICE
OREPRICE	OREPRICE
EXTDCOST	EXTDCOST
OREXTCST	OREXTCST
MRKDNAMT	MRKDNAMT
ORMRKDAM	ORMRKDAM
MRKDNPCT	MRKDNPCT
MRKDNTYP	MRKDNTYP
INVINDX	INVINDX
TAXAMNT	TAXAMNT
ORTAXAMT	ORTAXAMT
TXBTXAMT	TXBTXAMT
OTAXTAMT	OTAXTAMT
QUANTITY	QUANTITY
ATYALLOC	ATYALLOC
QTYINSVC	QTYINSVC
QTYINUSE	QTYINUSE
QTYDMGED	QTYDMGED
QTYRTRND	QTYRTRND
QTYONHND	QTYONHND
QTYCANCE	QTYCANCE
QTYCANOT	QTYCANOT
QTYORDER	QTYORDER
QTYPRBAC	QTYPRBAC
QTYPRBOO	QTYPRBOO
QTYPRINV	QTYPRINV
QTYPRORD	QTYPRORD
QTYPRVRECVD	QTYPRVRECVD
QTYRECVD	QTYRECVD
QTYREMAI	QTYREMAI
QTYREMBO	QTYREMBO
QTYTBAOR	QTYTBAOR
QTYTOINV	QTYTOINV
QTYTORDR	QTYTORDR
QTYFULFI	QTYFULFI
QTYSLCTD	QTYSLCTD
QTYBSUOM	QTYBSUOM
EXTQTYAL	EXTQTYAL
EXTQTYSEL	EXTQTYSEL
FUFILDAT	FUFILDAT
ACTLSHIP	ACTLSHIP
SHIPMTHD	SHIPMTHD
SALSTERR	SALSTERR
SLPRSNID	SLPRSNID
PRCLEVEL	PRCLEVEL
PRSTADCD	PRSTADCD
DEX_ROW_ID	DEX_ROW_ID
TRDISAMT	TRDISAMT
ORTDISAM	ORTDISAM

SOP30200 (Sales transaction headers)	fSOP30200
Source Field Name	Destination Field Name
SOPTYPE	SOPTYPE
SOPNUMBE	SOPNUMBE
DOCID	DOCID
DOCDATE	DOCDATE
GLPOSTDT	GLPOSTDT
QUOTEDAT	QUOTEDAT
QUOEXPDA	QUOEXPDA
ORDRDATE	ORDRDATE
INVODATE	INVODATE
BACKDATE	BACKDATE
RETUDATE	RETUDATE
FUFILDAT	FUFILDAT
ReqShipDate	ReqShipDate
ACTLSHIP	ACTLSHIP
DISCDATE	DISCDATE
DUEDATE	DUEDATE
PYMTRMID	PYMTRMID
PRCLEVEL	PRCLEVEL
LOCNCODE	LOCNCODE
CUSTNMBR	CUSTNMBR
PRBTADCD	PRBTADCD
PRSTADCD	PRSTADCD
CNTCPRSN	CNTCPRSN
CCode	CCode
COUNTRY	COUNTRY
SALSTERR	SALSTERR
SLPRSNID	SLPRSNID
CURNCYID	CURNCYID
CURRNIDX	CURRNIDX
POSTEDDT	POSTEDDT
CREATDDT	CREATDDT
MODIFDT	MODIFDT
SALEDATE	SALEDATE
VOIDSTTS	VOIDSTTS
XCHGRATE	XCHGRATE
DEX_ROW_ID	DEX_ROW_ID
TRDISAMT	TRDISAMT
ORTDISAM	ORTDISAM

RM00303 (Sales Territory)	dRM00303
Source Field Name	Destination Field Name
SALSTERR	SALSTERR
SLTERDSC	SLTERDSC
SLPRSNID	SLPRSNID
COUNTRY	COUNTRY

RM00301 (Sales Person)	dRM00301
Source Field Name	Destination Field Name
SLPRSNID	SLPRSNID
SLPRSNFN	SLPRSNFN
SPRSNSMN	SPRSNSMN
SPRSNSLN	SPRSNSLN
SALSTERR	SALSTERR
INACTIVE	INACTIVE

VAT10001 (Country Code)	dVAT10001
Source Field Name	Destination Field Name
CCode	CCode
CCodeDesc	CCodeDesc

RM20101 (Receivables Open)	fRM20101
Source Field Name	Destination Field Name
CUSTNMBR	CUSTNMBR
DOCNUMBR	DOCNUMBR
RMDTYPAL	RMDTYPAL
CSHRCTYP	CSHRCTYP
DUEDATE	DUEDATE
DOCDATE	DOCDATE
POSTDATE	POSTDATE
GLPOSTDT	GLPOSTDT
ORTRXAMT	ORTRXAMT
CURTRXAM	CURTRXAM
SLPRSNID	SLPRSNID
SLSTERCD	SLSTERCD
VOIDSTTS	VOIDSTTS
AGNGBUKT	AGNGBUKT
CURNCYID	CURNCYID
PYMTRMID	PYMTRMID
SLSAMNT	SLSAMNT
COSTAMNT	COSTAMNT
FRTAMNT	FRTAMNT
MISCAMNT	MISCAMNT
TAXAMNT	TAXAMNT
COMDLRAM	COMDLRAM
CASHAMNT	CASHAMNT
DISTKNAM	DISTKNAM
DISAVAMT	DISAVAMT
DISAVTKN	DISAVTKN
WROFAMNT	WROFAMNT
TRDISAMT	TRDISAMT

RM30101 (Receivables History)	fRM30101
Source Field Name	Destination Field Name
CUSTNMBR	CUSTNMBR
DOCNUMBR	DOCNUMBR
RMDTYPAL	RMDTYPAL
CSHRCTYP	CSHRCTYP
DUEDATE	DUEDATE
DOCDATE	DOCDATE
POSTDATE	POSTDATE
GLPOSTDT	GLPOSTDT
ORTRXAMT	ORTRXAMT
CURTRXAM	CURTRXAM
SLPRSNID	SLPRSNID
SLSTERCD	SLSTERCD
VOIDSTTS	VOIDSTTS
CURNCYID	CURNCYID
PYMTRMID	PYMTRMID
SLSAMNT	SLSAMNT
COSTAMNT	COSTAMNT
FRTAMNT	FRTAMNT
MISCAMNT	MISCAMNT
TAXAMNT	TAXAMNT
COMDLRAM	COMDLRAM
CASHAMNT	CASHAMNT
DISTKNAM	DISTKNAM
DISAVAMT	DISAVAMT
WROFAMNT	WROFAMNT
TRDISAMT	TRDISAMT
DEX_ROW_ID	DEX_ROW_ID

GL00102 (Account Category)	dGL00102
Source Field Name	Destination Field Name
ACCATNUM	ACCATNUM
ACCATDSC	ACCATDSC

GL00200 (Budget Master)	dGL00200
Source Field Name	Destination Field Name
BUDGETID	BUDGETID
BUDCOMNT	BUDCOMNT
YEAR1	YEAR1
DEX_ROW_ID	DEX_ROW_ID

GL00201 (Budget Summary Master)	fGL00201
Source Field Name	Destination Field Name
BUDGETID	BUDGETID
PERIODDT	PERIODDT
PERIODID	PERIODID
BUDGETAMT	BUDGETAMT
ACTINDX	ACTINDX
YEAR1	YEAR1
DEX_ROW_ID	DEX_ROW_ID

GL40000 (System)	tGL40000
Source Field Name	Destination Field Name
RERINDX	RERINDX

SY40100 (Periods)	tSY40100
Source Field Name	Destination Field Name
CLOSED	CLOSED
ODESCTN	ODESCTN
FORIGIN	FORIGIN
PERIODID	PERIODID
PERIODDT	PERIODDT
PERNAME	PERNAME
YEAR1	YEAR1
PERDENDT	PERDENDT
DEX_ROW_ID	DEX_ROW_ID

SY40101 (Period Headers)	tSY40101
Source Field Name	Destination Field Name
YEAR1	YEAR1
FSTFSCDY	FSTFSCDY
LSTFSCDY	LSTFSCDY
NUMOFPER	NUMOFPER
HISTORYR	HISTORYR
DEX_ROW_ID	DEX_ROW_ID

RM20201 (Receivables Apply open file)	fRM20201
Source Field Name	Destination Field Name
CUSTNMBR	CUSTNMBR
APFRDCNM	APFRDCNM
APTODCTY	APTODCTY
APTODCDT	APTODCDT
ApplyToGLPostDate	ApplyToGLPostDate
GLPOSTDT	GLPOSTDT
ORAPTOAM	ORAPTOAM
CURNCYID	CURNCYID
APFRDCTY	APFRDCTY

RM00201 (Customer Class)	dRM00201
Source Field Name	Destination Field Name
CLASSID	CLASSID
CLASDSCR	CLASDSCR

RM40201 (Aging Periods)	dRM40201
Source Field Name	Destination Field Name
INDEX1	INDEX1
RMPERDSC	RMPERDSC
RMPEREND	RMPEREND
DEX_ROW_ID	DEX_ROW_ID

SY00900 (Source Document	dSY00900
Source Field Name	Destination Field Name
SOURCDOC	SOURCDOC
SDOCDSCR	SDOCDSCR
DEX_ROW_ID	DEX_ROW_ID

MC40000 (Currency Setup)	tMC40000
Source Field Name	Destination Field Name
FUNLCURR	FUNLCURR
FUNCRIDX	FUNCRIDX
RPTGCURR	RPTGCURR
RPTCRIDX	RPTCRIDX
RPTXRATE	RPTXRATE
RPRTCLMD	RPRTCLMD

IV30300 (Inventory Amounts History)	fIV30300
Source Field Name	Destination Field Name
TRXSORCE	TRXSORCE
DOCTYPE	DOCTYPE
DOCNUMBR	DOCNUMBR
DOCDATE	DOCDATE
HSTMODUL	HSTMODUL
CUSTNMBR	CUSTNMBR
ITEMNMBR	ITEMNMBR
UOFM	UOFM
TRXQTY	TRXQTY
UNITCOST	UNITCOST
EXTDCOST	EXTDCOST
TRXLOCTN	TRXLOCTN
TRNSTLOC	TRNSTLOC
TRFQTYTY	TRFQTYTY
TRTQTYTY	TRTQTYTY
QTYBSUOM	QTYBSUOM
LNSEQNBR	LNSEQNBR
DEX_ROW_ID	DEX_ROW_ID

IV40400 (Item Class)	dIV40400
Source Field Name	Destination Field Name
ITMCLSCD	ITMCLSCD
ITMCLSDC	ITMCLSDC

IV40700 (Sites)	dIV40700
Source Field Name	Destination Field Name
LOCNCODE	LOCNCODE
LOCNDSCR	LOCNDSCR

IV00102	tIV00102
Source Field Name	Destination Field Name
ITEMNMBR	ITEMNMBR
LOCNCODE	LOCNCODE
RCRDTYPE	RCRDTYPE
BGNGQTY	BGNGQTY
LSORDQTY	LSORDQTY
LRCPTQTY	LRCPTQTY
LSTORDDT	LSTORDDT
LSORDVND	LSORDVND
LSRCPTDT	LSRCPTDT
QTYRQSTN	QTYRQSTN
QTYONORD	QTYONORD
QTYBKORD	QTYBKORD
QTYINUSE	QTYINUSE
QTYINSVC	QTYINSVC
QTYRTRND	QTYRTRND
QTYDMGED	QTYDMGED
QTYONHND	QTYONHND
ATYALLOC	ATYALLOC
QTYCOMTD	QTYCOMTD
QTYSOLD	QTYSOLD
LSTCNTDT	LSTCNTDT
LSTCNTTM	LSTCNTTM

IV00103 (Item Vendor)	tIV00103
Source Field Name	Destination Field Name
ITEMNMBR	ITEMNMBR
VENDORID	VENDORID
ITMVNDTY	ITMVNDTY

PM00200 (Vendor)	dPM00200
Source Field Name	Destination Field Name
VENDORID	VENDORID
VENDNAME	VENDNAME
VNDCHKNM	VNDCHKNM
VENDSHNM	VENDSHNM
PYMTRMID	PYMTRMID
CCode	CCode

SOP10100 (Sales Transaction Work headers)	dSOP10100
Source Field Name	Destination Field Name
SOPTYPE	SOPTYPE
SOPNUMBE	SOPNUMBE
ORIGTYPE	ORIGTYPE
ORIGNUMB	ORIGNUMB
DOCID	DOCID
DOCDATE	DOCDATE
GLPOSTDT	GLPOSTDT
ORDRDATE	ORDRDATE
INVODATE	INVODATE
BACKDATE	BACKDATE
RETUDATE	RETUDATE
DUEDATE	DUEDATE
PYMTRMID	PYMTRMID
LOCNCODE	LOCNCODE
CUSTNMBR	CUSTNMBR
SALSTERR	SALSTERR
PSTGSTUS	PSTGSTUS
SLPRSNID	SLPRSNID
CURNCYID	CURNCYID
CURRNIDX	CURRNIDX
VOIDSTTS	VOIDSTTS
TRDISAMT	TRDISAMT
ORTDISAM	ORTDISAM

SOP10200 (Sales Transaction Work Lines	fSOP10200
Source Field Name	Destination Field Name
SOPTYPE	SOPTYPE
SOPNUMBE	SOPNUMBE
ITEMNMBR	ITEMNMBR
UOFM	UOFM
LOCNCODE	LOCNCODE
XTNDPRCE	XTNDPRCE
OXTNDPRC	OXTNDPRC
REMPRICE	REMPRICE
OREPRICE	OREPRICE
EXTDCOST	EXTDCOST
OREXTCST	OREXTCST
QUANTITY	QUANTITY
QTYINSVC	QTYINSVC
QTYREMAI	QTYREMAI
QTYORDER	QTYORDER
QTYPRBAC	QTYPRBAC
QTYTOINV	QTYTOINV
QTYTORDR	QTYTORDR
QTYBSUOM	QTYBSUOM
SLPRSNID	SLPRSNID
SALSTERR	SALSTERR
TRDISAMT	TRDISAMT
ORTDISAM	ORTDISAM

AF40106	tAF40106
Source Field Name	Destination Field Name
REPORTID	REPORTID
ROWNUMBR	ROWNUMBR
ROWTYPE	ROWTYPE
CATNUMBR	CATNUMBR
ROWDESC	ROWDESC

AF40100	tAF40100
Source Field Name	Destination Field Name
RPRTNAME	RPRTNAME
REPORTID	REPORTID
RPRTTYPE	RPRTTYPE

PM30200 (Payables History)	fPM30200
Source Field Name	Destination Field Name
VENDORID	VENDORID
DOCNUMBR	DOCNUMBR
DOCTYPE	DOCTYPE
PYENTTYP	PYENTTYP
DUEDATE	DUEDATE
DOCDATE	DOCDATE
POSTEDDT	POSTEDDT
PSTGDATE	PSTGDATE
DOCAMNT	DOCAMNT
CURTRXAM	CURTRXAM
CURNCYID	CURNCYID
PYMTRMID	PYMTRMID
PRCHAMNT	PRCHAMNT
FRTAMNT	FRTAMNT
TAXAMNT	TAXAMNT
DISTKNAM	DISTKNAM
WROFAMNT	WROFAMNT
TRDISAMT	TRDISAMT
DEX_ROW_ID	DEX_ROW_ID

PM20000 (Payables Open)	fPM20000
Source Field Name	Destination Field Name
VENDORID	VENDORID
DOCNUMBR	DOCNUMBR
DOCTYPE	DOCTYPE
PYENTTYP	PYENTTYP
DUEDATE	DUEDATE
DOCDATE	DOCDATE
POSTEDDT	POSTEDDT
PSTGDATE	PSTGDATE
DOCAMNT	DOCAMNT
CURTRXAM	CURTRXAM
CURNCYID	CURNCYID
PYMTRMID	PYMTRMID
PRCHAMNT	PRCHAMNT
FRTAMNT	FRTAMNT
TAXAMNT	TAXAMNT
DISTKNAM	DISTKNAM
WROFAMNT	WROFAMNT
TRDISAMT	TRDISAMT
DEX_ROW_ID	DEX_ROW_ID

PM10300 (Payables Payments Work_Unposted)	fPM10300
Source Field Name	Destination Field Name
VENDORID	VENDORID
DOCNUMBR	DOCNUMBR
DOCTYPE	DOCTYPE
DOCDATE	DOCDATE
POSTEDDT	POSTEDDT
PSTGDATE	PSTGDATE
APPLDAMT	APPLDAMT
CURTRXAM	CURTRXAM
CURNCYID	CURNCYID
DISTKNAM	DISTKNAM
WROFAMNT	WROFAMNT
DEX_ROW_ID	DEX_ROW_ID

PM10400 (Payables Payments Work_Unposted Manual)	fPM10400
Source Field Name	Destination Field Name
VENDORID	VENDORID
DOCNUMBR	DOCNUMBR
DOCTYPE	DOCTYPE
DOCDATE	DOCDATE
POSTEDDT	POSTEDDT
PSTGDATE	PSTGDATE
APPLDAMT	APPLDAMT
CURTRXAM	CURTRXAM
CURNCYID	CURNCYID
DISTKNAM	DISTKNAM
WROFAMNT	WROFAMNT
DEX_ROW_ID	DEX_ROW_ID
PYENTTYP	PYENTTYP

POP30110 (Purchase Order Line History)	fPOP30110
Source Field Name	Destination Field Name
PONUMBER	PONUMBER
ORD	ORD
POLNESTA	POLNESTA
POTYPE	POTYPE
ITEMNMBR	ITEMNMBR
VENDORID	VENDORID
VNDITNUM	VNDITNUM
VNDITDSC	VNDITDSC
NONINVEN	NONINVEN
LOCNCODE	LOCNCODE
UOFM	UOFM
UMQTYINB	UMQTYINB
QTYORDER	QTYORDER
QTYCANCE	QTYCANCE
UNITCOST	UNITCOST
EXTDCOST	EXTDCOST
DOCTYPE	DOCTYPE
CURRNIDX	CURRNIDX
ORUNTCST	ORUNTCST
OREXTCST	OREXTCST
TAXAMNT	TAXAMNT
ORTAXAMT	ORTAXAMT
BCKTXAMT	BCKTXAMT
OBTAXAMT	OBTAXAMT
DEX_ROW_ID	DEX_ROW_ID

POP30100 (Purchase Order History)	fPOP30100
Source Field Name	Destination Field Name
PONUMBER	PONUMBER
POSTATUS	POSTATUS
POTYPE	POTYPE
DOCDATE	DOCDATE
PRMDATE	PRMDATE
PRMSHPDTE	PRMSHPDTE
REQDATE	REQDATE
VENDORID	VENDORID
PYMTRMID	PYMTRMID
DUEDATE	DUEDATE
CURNCYID	CURNCYID
CURRNIDX	CURRNIDX
XCHGRATE	XCHGRATE
DEX_ROW_ID	DEX_ROW_ID
TRDISAMT	TRDISAMT
ORTDISAM	ORTDISAM

POP10500 (Receipt Line Quantities)	fPOP10500
Source Field Name	Destination Field Name
PONUMBER	PONUMBER
POLNENUM	POLNENUM
POPRCTNM	POPRCTNM
RCPTLNNM	RCPTLNNM
QTYSHPPD	QTYSHPPD
QTYINVCD	QTYINVCD
QTYREJ	QTYREJ
QTYMATCH	QTYMATCH
QTYRESERVED	QTYRESERVED
QTYINVRESERVE	QTYINVRESERVE
UMQTYINB	UMQTYINB
ORCPTCOST	ORCPTCOST
OSTDCOST	OSTDCOST
APPYTYPE	APPYTYPE
POPTYPE	POPTYPE
VENDORID	VENDORID
ITEMNMBR	ITEMNMBR
UOFM	UOFM
TRXLOCTN	TRXLOCTN
DATERECD	DATERECD
PCHRPTCT	PCHRPTCT
SPRCPTCT	SPRCPTCT
OREXTCST	OREXTCST
RUPPVAMT	RUPPVAMT
CURNCYID	CURNCYID
CURRNIDX	CURRNIDX
XCHGRATE	XCHGRATE
DEX_ROW_ID	DEX_ROW_ID
Status	Status
RATECALC	RATECALC

POP10110 (Purchase Order Line Work)	fPOP10110
Source Field Name	Destination Field Name
PONUMBER	PONUMBER
ORD	ORD
POLNESTA	POLNESTA
POTYPE	POTYPE
ITEMNMBR	ITEMNMBR
VENDORID	VENDORID
VNDITNUM	VNDITNUM
VNDITDSC	VNDITDSC
NONINVEN	NONINVEN
LOCNCODE	LOCNCODE
UOFM	UOFM
UMQTYINB	UMQTYINB
QTYORDER	QTYORDER
QTYCANCE	QTYCANCE
UNITCOST	UNITCOST
EXTDCOST	EXTDCOST
DOCTYPE	DOCTYPE
CURRNIDX	CURRNIDX
ORUNTCST	ORUNTCST
OREXTCST	OREXTCST
TAXAMNT	TAXAMNT
ORTAXAMT	ORTAXAMT
BCKTXAMT	BCKTXAMT
OBTAXAMT	OBTAXAMT
DEX_ROW_ID	DEX_ROW_ID

POP10100 (Purchase Order Work)	dPOP10100
Source Field Name	Destination Field Name
PONUMBER	PONUMBER
POSTATUS	POSTATUS
POTYPE	POTYPE
DOCDATE	DOCDATE
PRMDATE	PRMDATE
PRMSHPDTE	PRMSHPDTE
REQDATE	REQDATE
VENDORID	VENDORID
PYMTRMID	PYMTRMID
DUEDATE	DUEDATE
CURNCYID	CURNCYID
CURRNIDX	CURRNIDX
XCHGRATE	XCHGRATE
TRDISAMT	TRDISAMT
ORTDISAM	ORTDISAM

POP30300 (Receipt Work)	fPOP30300
Source Field Name	Destination Field Name
POPRCTNM	POPRCTNM
POPTYPE	POPTYPE
VNDDOCNM	VNDDOCNM
receiptdate	receiptdate
GLPOSTDT	GLPOSTDT
DEX_ROW_ID	DEX_ROW_ID

POP10300 (Receipt History)	tPOP10300
Source Field Name	Destination Field Name
POPRCTNM	POPRCTNM
POPTYPE	POPTYPE
VNDDOCNM	VNDDOCNM
receiptdate	receiptdate
GLPOSTDT	GLPOSTDT
DEX_ROW_ID	DEX_ROW_ID

GL40200 (Segment Description)	tGL40200
Source Field Name	Destination Field Name
SGMTNUMB	SGMTNUMB
SGMNTID	SGMNTID
DSCRIPTN	DSCRIPTN
SEGCOUNT	SEGCOUNT
NOTEINDX	NOTEINDX
DEX_ROW_ID	DEX_ROW_ID