DYNAMIC 3i STATUS CODES

Sales Order Header (oehmst – header_status)

1 – header exists but no details on the order
2 – fully backordered
3 – future order
5 – stock allocated
15 – packing slip printed
20 – shipment confirmed
22 – direct order entered
23 – credit note entered
24 – order split (ROUTE ACCOUNTING ONLY)
25 – invoice/credit printed
30 – invoice journal printed
31 – driver update (ROUTE ACCOUNTING ONLY)
35 – order cancelled

Sales Order Detail (oedmst – detail_status)

0 – stock allocated
1 – fully backordered
4 – packing slip printed
5 – shipment confirmed
6 – printed on invoice
9 – unreleased future backorder

Sales Order Types (oehmst – order_type)

N – normal
D – direct order
C – credit note
F – future orderG – gratis
B – blanket order
Q – quotation only
T – inter-warehouse transfer
W – inter-warehouse transfer with no update to sales analysis
I – inter-company sale

Purchase Order Header (pohmst – header_status)

1 – purchase order entered
2 – purchase order printed
3 – partially received
4 – fully received
9 – cancelled

Purchase Order Requistion Header (rqhmst – header_status)

1 – header only, no details
2 – entered with details
3 – partially approved
4 – fully approved
5 – partially posted (po created)
6 – fully posted (po created)

Requisition Details (rqhmst – detail_status)

1 – detail line entered
2 – approved
3 – posted (po created for the line

Accounts Payable Header (apmmst – header_status)

0 – entered but not posted to the GL
5 – updated to the GL
S – invoice is on suspense

Accounts Payable Payment (appmst – detail_status)

0 – payment record created on the invoice but no payment made
1 – cash requirements report printed
3 – cheque printed
4 – cheque printed and updated to the GL
5 – reconciled cheque

Accounts payable GL distribution (apglmst – detail_status)

0 – entered, not updated
1 – posted to the GL through ap/gl update

Product types (stkmst – product_type)

1 – assembly
2 – fabricated item
3 – raw material
4 – purchased item
5 – finished good
6 – scrap
7 – tool
8 – option
9 – kit
10 – phantom part
11 – routing code
12 – feature
13 – labour activity
14 – plant hire activity
15 – sub contract
16 – service

Inventory Movement (imvmst – movement_code)

1 – inventory adjustments
5 – inventory issue, returned to stock
6 – inventory issue, taken from stock
10 – inter warehouse transfer receipt
11 – inter warehouse transfer shipment
15 – sales order credit order
16 – sales order debit order
17 – sales order shipment confirmed
18 – sales order movement for gratis order
25 – purchase order receipt
31 – retail return (From Retail Module)
32 – retail sales (From Retail Module)
35 – material usage
40 – manual job confirmation
45 – kit build
46 – kit usage
50 – inventory receipts from inventory receipts program (in2100)
55 – physical inventory adjustment
60 – bin transfer

*90 – cost adjustment
*91 – cost correction
*92 – accounts payable matching
*93 – sales adjustment

* These statuses will not be found on any listing or inquiry. These are used exclusively for SDC internal programming.

Inter Warehouse Transfer (iwhmst – header_status)

0 – transfer entered
2 – transfer printed
3 – partially filled
4 – shipping confirmed
6 – receiving confirmed

Job Status (jhdmst – job_status)

1 – entered
2 – quote
3 – open
4 – work Order
5 – WIP
6 – done
7 – quote cancelled
9 – cancelled

General Ledger transactions (gltmst – detail_status)

0 – transaction entered
3 – transaction posted

General Ledger Journals Source Codes (gltmst – gl_source_flag)

je – manual journal
rv – reversal journal
rj – repetitive journal
ar – accounts receivable
ap – accounts payable
fa – fixed assets
gl – general ledger
po – purchase order
oe – sales order entry
mb – membership
py – payroll
in – inventory
rt – retail
pc – production control
sp – subscription

Accounts receivable cheques (chqmst – detail_status)

0 – Entered
3 – Applied
5 – NFS (insufficient funds)

Manufacturing Jobs (jhdmst – job_status)

1 – Entered
2 – Quote
3 – Open
4 – Work Order
5 – WIP
6 – Done
7 – Quote cancelled
9 – Cancelled

Future Movements – (fmvmst – rec_type)

1 – Allocated Sales
2 – Back Order
3 – Purchase Order (Distribution) / Planned Production (Manufacturing)
4 – Work Order
5 – Inter-warehouse Transfer (Receiving)
7 – Inter-warehouse Transfer (Sending)
8 – Inter-company transfer – Order Entry transfer order receiving
10 – Future Order

Manufacturing Requirements planning (rppmst – rec_type)

21 – Sales Forecast
22 – Suggested Work Order
23 – Suggested Purchase Order
24 – Warehouse transfer