Export Financial Dimensions using x++.
Tables list is mentioned below.
public class ExportFinancialDimensionService extends SysOperationServiceBase { public void processOperation() { DimAttributeMainAccount dimAttributeMainAccount; DimAttributeOMCostCenter dimAttributeOMCostCenter; DimAttributeProjTable dimAttributeProjTable; DimAttributeAssetTable dimAttributeAssetTable; DimAttributeOMDepartment dimAttributeDepartment; DimAttributeOMBusinessUnit dimAttributeBusinessUnit; DimAttributeVendTable dimAttributeVendTable; DimAttributeCustTable dimAttributeCustTable; // BusinessUnit while select dimAttributeBusinessUnit { info(Strfmt('%1 - %2',dimAttributeBusinessUnit.Value, dimAttributeBusinessUnit.Name); } DimensionFinancialTag siteDimensionFinancialTag; DimensionAttributeDirCategory dimensionAttributeDirCategory; // Site while select siteDimensionFinancialTag join dimensionAttributeDirCategory where siteDimensionFinancialTag.FINANCIALTAGCATEGORY == dimensionAttributeDirCategory.DirCategory && dimensionAttributeDirCategory.DimensionAttribute == DimensionAttribute::findByName(#Site).RecId { info(Strfmt('%1 - %2',siteDimensionFinancialTag.Value, siteDimensionFinancialTag.Description)); } // Department while select dimAttributeDepartment { info(Strfmt('%1 - %2',dimAttributeDepartment.Value, dimAttributeDepartment.Name); } // MainAccount while select dimAttributeMainAccount { info(Strfmt('%1 - %2',dimAttributeMainAccount.Value, dimAttributeMainAccount.Name); } //Assets while select dimAttributeAssetTable { info(Strfmt('%1 - %2',dimAttributeAssetTable.Value, dimAttributeAssetTable.Name); } // Customers while select dimAttributeCustTable { info(Strfmt('%1 - %2',dimAttributeCustTable.Value, dimAttributeCustTable.Name)); } } }
Keep Daxing.
No comments:
Post a Comment