Jul 25, 2014

Epicor get Field Mapping of Executive Query

select * from [dbo].[ProcessTaskParam] where ProcessID ='POAnalysis'
select * from [dbo].[ProcessTaskParam] where ParamCharacter = 'POAnalysis'


No. BAQ EBAQ



1 EPIC03-DelivPerf




2
POAnalysis



3 EPIC03-Receipts









BAQID EPIC03-Receipts


























CubeID POAnalysis




















































































Dimension 1 ID Dimension 1 ID Text Dimension 2 ID Dimension 2 ID Text Map Decimal Value 01 To Map Decimal Value 02 To Map Decimal Value 03 To Map Decimal Value 04 To Map Decimal Value 05 To Map Decimal Value 06 To MapDecimal Value 07 To Map Decimal Value 08 To Map Decimal Value 09 To Map Decimal Value 10 To Map Integer Value 01 To Map Integer Value 02 To Map Integer Value 03 To Map Integer Value 04 To Map Integer Value 05 To Map Character Value 01 To Map Character Value 02 To Map Character Value 03 To Map Character Value 04 To Map Character Value 05 To Map Character Value 06 To Map Character Value 07 To Map Character Value 08 To Map Character Value 09 To Map Character Value 10 To
Vendor.VendorID Supplier ID Late3 Late2 Late1 OnTime Early1 Early2 Early3 Count RcvDtl.OurQty ReceiptValue Vendor.Name
All All Late3 Late2 Late1 OnTime Early1 Early2 Early3 Count RcvDtl.OurQty ReceiptValue




0 comments:

Post a Comment

Nam Le © 2014 - Designed by Templateism.com, Distributed By Templatelib