AutoCount Documents and Table Names Mapping

Home » References » AutoCount Documents and Table Names Mapping
References No Comments

The following are common use AutoCount Document and its database table names.

Document name Master table name Detail table name
Quotation QT QTDTL
Sales Order SO SODTL
Delivery Order DO DODTL
Invoice IV IVDTL
Cash Sale CS CSDTL
Credit Note CN CNDTL
Debit Note DN DNDTL
Cancel S/O XS XSDTL
Delivery Return DR DRDTL
Request Quotation RQ RQDTL
Purchase Order PO PODTL
Goods Received Note GR GRDTL
Purchase Invoice PI PIDTL
Cash Purchase CP CPDTL
Purchase Return PR PRDTL
Cancel P/O XP XPDTL
Goods Return GT GTDTL
Stock Adjustment ADJ ADJDTL
Stock Issue ISS ISSDTL
Stock Receive RCV RCVDTL
Stock Transfer XFER XFERDTL
Stock Write Off WOFF WOFFDTL