List of Classes and Tables used for Module

Sales & Purchase  Classes & Tables

SalesOrder Classes:

• SalesTableType and SaleslineType classes will get called while creating the SalesOrders.

SalesFormLetter_Confirm,
SalesFormLetter_Invoice,
SalesFormLetter_PackingSlip,
SalesFormLetter_PickingLlst,
classes will be used to post the sales order at various document status (packing, invoice etc).

SalesOrder Tables:

• SalesTable : Contains all SalesOrder headers regardless whether they have been posted or not.
• SalesParmTable &SalesParmLine : Contains detailed information regarding posting sales headers and Lines.
• CustConfirmJour,CustConfirmTrans: Contains all Sales Confirmation headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines.
• CustInvoiceJour &CustInvoiceTrans : Contains all sales all Sales Invoice headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines.
• CustPackingSlipJour,CustPackingSlipTrans:Contains all Sales PackingSlip headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines.

PurchaseOrder Classes :

• PurchTableType and PurchTableLine classes will get called while creating the PurchaseOrders.

PurchFormLetter_PurchOrder,

PurchFormLetter_ApproveJournal,

PurchFormLetter_Invoice,

PurchFormLetter_PackingSlip,

PurchFormLetter_ReceiptsList

classes will be used to post the PurchaseOrder at various document status (packing, invoice etc).

PurchaseOrder Tables :

• PurchTable :contains all purchase order headers regardless whether they have been posted or not.
• PurchParmTable,PurchParmLine:contains information regarding posting Purchase headers and Lines. 
• VendPackingSlipJour,VendPackingSlipTrans tables contains posted packingslip headers and lines.
• VendInvoiceJour & VendInvoiceTrans: tables contains all invoiced purchase order headers and Lines.
• VendReceiptsJour & VendReceiptsTrans: tables contains posted receipt header and lines.
• VendPurchOrderJour,VendPurchOrderTrans: contains Purchase requisition headers and lines.

• Inventory Classes & Tables

  
  

  Inventory Classes :

  InventSum classes are used to find the on-hand information of a certain item at a certain date.
  
  InventOnHand class is used to find the current on-hand information.
  
  InventMovement class validates and prepares data that will be used to generate inventory transactions. All the classes related to the inventMovement class will be prefixed with InvMov
  
  InventUpdate classes are used to insert and update inventory transactions.Whenever a transaction should be posted, the updateNow()method in the correct InventUpdate subclass will execute. The super class in the hierarchy is the InventUpdate class, and the other classes in the hierarchy are prefixed ‘InventUpd_’.

  InventUpd_Estimated is triggered so that the inventory transactions will reflect that the item is on-order can is taken into consideration when the same item is ordered.
  

  
  Inventory Tables 

  Invent Dim : (Fields of invent DIM)
  1. InventColorId Item table contains information about colors.
  2. InventSizeId Item table contains information about item size.
  3. ConfigId  table contains information about available configuration of the various items.
  4. InventBatchId table contains information about batches.
  5. InventSerialId table contains information about item serial numbers.
  6. InventLocationId table contains information about warehouses.
  7. InventSiteId table contains information about sites.
  8. wmsLocationId table contains information about locations.
  9. wmsPalletId table contains information about pallets.
   InventTrans : parent table of all transactions. represents a flow of inventory transactions as data leaves and enters a company 

classes involved in Journal, Sales order Invoice, Purchase order invoice posting.

Journal Posting               : LedgerJournalCheckPost

Sales Order Posting        : SalesFormLetter, SalesFormLetter_Invoice

Purchase Order Posting : PurchFormLetter,

                                          PurchFormLetter_PurchOrder,

                                          PurchFormLetter_ReceiptList, 

                                          PurchFormLetter_PackingSlip, 

                                          PurchFormLetter_invoice.

Retail Statement Processing Details:

Statement posting is quite complex process, that includes the creation and posting of sales orders, payment journals, transferring of inventory transactions, etc.

Statement calculate classes:

1. RetailStatementCalculate

Statement clear classes:

1. RetailStatementClear

Statement posting classes:

1. RetailStatementPost
2. RetailStatementPostSalesOrders
3. RetailStatementPaymentJournal
4. RetailStatementSalesOrderCreator  

for Posting Retail Retailstorepicker, RetailPostingInvoiceJournal

Other Details

CustTrans -The CustTrans table contains posted transaction information for the customer. 

VendTrans -The VendTrans table contains posted transaction information for the vendor. 
CustSettlement– The CustSettlement table contains information relating to the settlement or reverse settlement of two transactions. They are used to link a transaction with the transaction it was settled against. 
VendSettlement– The VendSettlement table contains information relating to the settlement or reverse settlement of two transactions. They are used to link a transaction with the transaction it was settled against.
CustGroup – The CustGroup table contains a list of groups into which customers can be added. Every customer must specify a CustGroup with which it is associated.
VendGroup – The VendGroup table contains definitions of vendor groups.
CustTable – The CustTable table contains the list of customers for accounts receivable and customer relationship management.
VendTable – The VendTable table contains vendors for accounts payable.
SalesTable – The SalesTable table contains all sales order headers,
regardless of whether they have been posted or not.
PurchTable – The PurchTable table contains all purchase order headers, regardless of whether they have been posted or not.
SalesLine – The SalesLine table contains all sales order lines, regardless of whether they have been posted or not.
PurchLine – The PurchLine table contains all purchase order lines, regardless of whether they have been posted or not.
LedgerTable – The LedgerTable contains the definitions of the general

ledger accounts, also called the chart of accounts.

LedgerTrans – The LedgerTrans table contains the posted general ledger

transactions.

LedgerAccountCategory – The LedgerAccountCategory contains the financial categories that accounts fall into. The categories are assigned to accounts to allow easier grouping of accounts on financial statements.

Dimensions – The Dimensions table contains the dimension values for all of the defined dimensions. This is explained further later on.

LedgerTableInterval – The LedgerTableInterval table contains ranges of accounts associated with a Total ledger account.

LedgerBalancesTrans – The LedgerBalancesTrans table contains the posted ledger amounts per account and date.

LedgerBalancesDimTrans – The LedgerBalancesTrans table contains the posted ledger.

Thursday, September 10, 2015

List of important tables for Role Based Security in AX 2009 and AX 2012

AX 2009 Tables :-

UserGroupList :- The UserGroupList table contains the list of users associated with each user groups in Ax.

UserGroupInfo:- The UserGroupInfo table contains the list of available user groups in Ax.

UserInfo           :-The UserInfo table contains the list of users in Ax and their Active Directory information and default company information.

AccessRightsList Table :- Group rights

UtilIdElements :- The UtilIdElements table contains the application model shown in the AOT.

UtilElements :- The UtilElements table contains the application model shown in the AOT.

AX 2012 Tables :-

SecurityRole            :-The SecurityRole table reflects the list of roles defined by the security AOT role node.

SecurityUserRole    :-The SecurityUserRole table contains the user to role mappings.

SecurityTask           :-The SecurityTask table contains the list of duties and privileges that have been defined by the AOT security duty and security privilege nodes.

SecuritySubTask    :- The SecuritySubTask table contains the duty to privilege mappings that have been specified on the security duty AOT nodes.

SecurityRoleTaskGrant  :-The SecurityRoleTaskGrant table contains the list of role to duty mappings and role to privilege mappings as defined by the AOT security role node.

SecurityTaskEntryPoint :- The SecurityTaskEntryPoint table contains the list of privilege to entry point mappings that have been specified on the AOT security privilege node.

OMUserRoleOrganization :-The OMUserRoleOrganization table maintains the mapping between user roles and organizations.

OMInternalOrganization  :-The OMInternalOrganization table is the base table for each of the organizations.