Remove the special characters using X++ in AX 2012

Use below code to remove the special character from the string

strRem('string','*')

Sale Order and Purchase Order Tables and Classes

Sale Order classes and Tables:

SalesTableType and SaleslineType classes will get called while creating the Sales Orders.
SalesFormLetter_Confirm
SalesFormLetter_PickingLlst
SalesFormLetter_PackingSlip
SalesFormLetter_Invoice
Classes used to post the sales order at various document status (packing, invoice etc).
Tables:

Sales Table contains all Sales Order 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 Packing Slip 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.

Purchase Order classes and Tables:

PurchTableType and PurchTableLine classes will get called while creating the PurchaseOrders.
PurchFormLetter_PurchOrder
PurchFormLetter_PackingSlip
PurchFormLetter_ReceiptsList
PurchFormLetter_Invoice
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.

Joins concept

Joins:

In ax 4 types of joins is there:

1) Inner join : Select the record from Main Table that have matching record form child table. These two records together and gives single record.

2) Outer join : select all records from Main Table and select the related records from child table. If there is no match ,it gives empty value

3)Exist join : select the records from Main table if there is any records matching in child table. It should return only main table not child table records.

4)Not Exist join : select the records from Main Table if there is no matching records in Child Table. opposite of Exist join.