Friday, June 18, 2021

Tables used in PO and SO

Purchase Order classes and Tables:

--------------------------------------

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).

Tables:

PurchTable contains all purchase order headers regardless whether they have been posted or not.

PurchParmTable and PurchParmLine contains detailed information regarding posting Purchase headers and Lines.

VendPackingSlipJour and VendPackingSlipTrans tables contains posted packingslip headers and lines.

VendInvoiceJour and VendInvoiceTrans tables contains all invoiced purchase order headers and Lines.

VendReceiptsJour and VendReceiptsTrans tables contains posted receipt header and lines.

VendPurchOrderJour and VendPurchOrderTrans tables contains Purchase requisition headers and lines.



SalesOrder Classes and Tables:

--------------------------------------

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).

Tables:

SalesTable contains all SalesOrder headers regardless whether they have been posted or not.

The SalesParmTable and SalesParmLine contains detailed information regarding posting sales headers and Lines.

CustConfirmJour and CustConfirmTrans tables contains all Sales Confirmation headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines.

CustPackingSlipJour and CustPackingSlipTrans tables contains all sales PackingSlip headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines.

CustInvoiceJour and CustInvoiceTrans tables contains all sales all Sales Invoice headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines.