Microsoft Dynamics GP 10

Cubes

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

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
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
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
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
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
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
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
Source Field Name Destination Field Name
SALSTERR SALSTERR
SLTERDSC SLTERDSC
SLPRSNID SLPRSNID
COUNTRY COUNTRY
Source Field Name Destination Field Name
SLPRSNID SLPRSNID
SLPRSNFN SLPRSNFN
SPRSNSMN SPRSNSMN
SPRSNSLN SPRSNSLN
SALSTERR SALSTERR
INACTIVE INACTIVE
Source Field Name Destination Field Name
CCode CCode
CCodeDesc CCodeDesc
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
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
Source Field Name Destination Field Name
ACCATNUM ACCATNUM
ACCATDSC ACCATDSC
Source Field Name Destination Field Name
BUDGETID BUDGETID
BUDCOMNT BUDCOMNT
YEAR1 YEAR1
DEX_ROW_ID DEX_ROW_ID
Source Field Name Destination Field Name
BUDGETID BUDGETID
PERIODDT PERIODDT
PERIODID PERIODID
BUDGETAMT BUDGETAMT
ACTINDX ACTINDX
YEAR1 YEAR1
DEX_ROW_ID DEX_ROW_ID
Source Field Name Destination Field Name
RERINDX RERINDX
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
Source Field Name Destination Field Name
YEAR1 YEAR1
FSTFSCDY FSTFSCDY
LSTFSCDY LSTFSCDY
NUMOFPER NUMOFPER
HISTORYR HISTORYR
DEX_ROW_ID DEX_ROW_ID
Source Field Name Destination Field Name
CUSTNMBR CUSTNMBR
APFRDCNM APFRDCNM
APTODCTY APTODCTY
APTODCDT APTODCDT
ApplyToGLPostDate ApplyToGLPostDate
GLPOSTDT GLPOSTDT
ORAPTOAM ORAPTOAM
CURNCYID CURNCYID
APFRDCTY APFRDCTY
Source Field Name Destination Field Name
CLASSID CLASSID
CLASDSCR CLASDSCR
Source Field Name Destination Field Name
INDEX1 INDEX1
RMPERDSC RMPERDSC
RMPEREND RMPEREND
DEX_ROW_ID DEX_ROW_ID
Source Field Name Destination Field Name
SOURCDOC SOURCDOC
SDOCDSCR SDOCDSCR
DEX_ROW_ID DEX_ROW_ID
Source Field Name Destination Field Name
FUNLCURR FUNLCURR
FUNCRIDX FUNCRIDX
RPTGCURR RPTGCURR
RPTCRIDX RPTCRIDX
RPTXRATE RPTXRATE
RPRTCLMD RPRTCLMD
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
Source Field Name Destination Field Name
ITMCLSCD ITMCLSCD
ITMCLSDC ITMCLSDC
Source Field Name Destination Field Name
LOCNCODE LOCNCODE
LOCNDSCR LOCNDSCR
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
Source Field Name Destination Field Name
ITEMNMBR ITEMNMBR
VENDORID VENDORID
ITMVNDTY ITMVNDTY
Source Field Name Destination Field Name
VENDORID VENDORID
VENDNAME VENDNAME
VNDCHKNM VNDCHKNM
VENDSHNM VENDSHNM
PYMTRMID PYMTRMID
CCode CCode
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
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
Source Field Name Destination Field Name
REPORTID REPORTID
ROWNUMBR ROWNUMBR
ROWTYPE ROWTYPE
CATNUMBR CATNUMBR
ROWDESC ROWDESC
Source Field Name Destination Field Name
RPRTNAME RPRTNAME
REPORTID REPORTID
RPRTTYPE RPRTTYPE
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
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
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
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
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
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
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
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
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
Source Field Name Destination Field Name
POPRCTNM POPRCTNM
POPTYPE POPTYPE
VNDDOCNM VNDDOCNM
receiptdate receiptdate
GLPOSTDT GLPOSTDT
DEX_ROW_ID DEX_ROW_ID
Source Field Name Destination Field Name
POPRCTNM POPRCTNM
POPTYPE POPTYPE
VNDDOCNM VNDDOCNM
receiptdate receiptdate
GLPOSTDT GLPOSTDT
DEX_ROW_ID DEX_ROW_ID
Source Field Name Destination Field Name
SGMTNUMB SGMTNUMB
SGMNTID SGMNTID
DSCRIPTN DSCRIPTN
SEGCOUNT SEGCOUNT
NOTEINDX NOTEINDX
DEX_ROW_ID DEX_ROW_ID