Tables hit while creating Service orders up to invoice posting in ax 2012

Tables hit while creating Service orders up to invoice posting  in ax 2012

The flow data will be as follows.

SMAServiceOrderTable >> SMAServiceOrderLine>> InventJournalTrans>> ProjItemTrans>> ProjProposalItem>> ProjInvoiceItem>> ProjProposalItemDetail>> ProjItemTransSale

SMAServiceOrderTable: The SMAServiceOrderTable table contains service orders. The service orders can be linked to agreements or be stand-alone orders that are linked to projects.

SMAServiceOrderLine: The SMAServiceOrderLine table contains service order lines that specify the detailed work, items, fees, and expenses of an individual service order.

InventJournalTrans : The InventJournalTrans table contains information about items and represents a line in an inventory journal. Each record has information related to a specific item and is related to a record in the InventJournalTable table, which is the journal header.

ProjItemTrans: The ProjItemTrans table is used to store posted item transactions of projects.  Posting an item journal will create records on this table.(i.e Posted service orders).

ProjProposalItem :The ProjProposalItem table stores project invoice proposal lines of the item transaction type.  The ProjProposalItem records are the item transactions that will be billed to the customer when the invoice proposal is posted.

ProjInvoiceItem :The ProjInvoiceItem table stores posted project invoice lines of the item transaction type.  Posting an invoice proposal with item transactions will create records in the ProjInvoiceItem table.

ProjProposalItemDetail :The ProjProposalItemDetail table stores the project invoice proposal lines of item transactions. These records are the item transactions that will be billed to the customer when the invoice proposal is posted.

ProjItemTransSale:The ProjItemTransSale table contains project item sale transactions.

Keep Daxing !!!