eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AX_MTL_CATEGORY_ACCOUNTS_V2

Product:	AX - Global Accounting Engine
Description:	Duplicate of AX_MTL_CATEGORY_ACCOUNTS_V1
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ORGANIZATION_ID ORGANIZATION_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, COST_GROUP_ID COST_GROUP_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT RESOURCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT
, OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT
, EXPENSE_ACCOUNT EXPENSE_ACCOUNT
, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT
, BRIDGING_ACCOUNT BRIDGING_ACCOUNT
, ANALYTICAL_IPV ANALYTICAL_IPV
, ANALYTICAL_PO_MIRROR ANALYTICAL_PO_MIRROR
, NON_INVOICED_SO NON_INVOICED_SO
, NON_INVOICED_REVENUE NON_INVOICED_REVENUE
, ANALYTICAL_REVENUE_MIRROR ANALYTICAL_REVENUE_MIRROR
, ANALYTICAL_MOGS ANALYTICAL_MOGS
FROM AX_MTL_CATEGORY_ACCOUNTS_V1

Columns

Name
ORGANIZATION_ID
SUBINVENTORY_CODE
COST_GROUP_ID
INVENTORY_ITEM_ID
MATERIAL_ACCOUNT
MATERIAL_OVERHEAD_ACCOUNT
RESOURCE_ACCOUNT
OUTSIDE_PROCESSING_ACCOUNT
OVERHEAD_ACCOUNT
EXPENSE_ACCOUNT
ENCUMBRANCE_ACCOUNT
BRIDGING_ACCOUNT
ANALYTICAL_IPV
ANALYTICAL_PO_MIRROR
NON_INVOICED_SO
NON_INVOICED_REVENUE
ANALYTICAL_REVENUE_MIRROR
ANALYTICAL_MOGS