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