aurora_standard.stuordre
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| doc_no | int(11) | YES | UNI | |||
| orig_doc_no | int(11) | YES | ||||
| po_no | varchar(10) | YES | MUL | |||
| buyer_code | varchar(6) | YES | ||||
| po_type | varchar(3) | YES | ||||
| po_date | date | YES | ||||
| po_status | varchar(3) | YES | MUL | |||
| po_stage | varchar(3) | YES | MUL | |||
| complete_date | date | YES | ||||
| required_date | date | YES | ||||
| whse_billto | varchar(10) | YES | ||||
| whse_shipto | varchar(10) | YES | ||||
| department | varchar(3) | YES | ||||
| mtaxg_code | varchar(6) | YES | ||||
| vend_code | varchar(6) | YES | ||||
| pay_to_code | varchar(6) | YES | ||||
| bus_name | varchar(30) | YES | ||||
| order_doc_no | int(11) | YES | ||||
| cust_code | varchar(6) | YES | ||||
| order_no_vnd | varchar(10) | YES | ||||
| order_reference | varchar(13) | YES | ||||
| currency_code | varchar(3) | YES | ||||
| ord_printed | varchar(1) | YES | ||||
| total_weight | decimal(12,2) | YES | ||||
| item_amount | decimal(12,2) | YES | ||||
| discountable | decimal(12,2) | YES | ||||
| trd_ds_amount | decimal(12,2) | YES | ||||
| tax_amount | decimal(12,2) | YES | ||||
| frght_amount | decimal(12,2) | YES | ||||
| misc_amount | decimal(12,2) | YES | ||||
| goods_amount | decimal(12,2) | YES | ||||
| total_amount | decimal(12,2) | YES | ||||
| prepay_amount | decimal(12,2) | YES | ||||
| freight_terms | varchar(6) | YES | ||||
| create_date | date | YES | ||||
| create_time | varchar(8) | YES | ||||
| create_id | varchar(8) | YES | ||||
| l_mod_date | date | YES | ||||
| l_mod_time | varchar(8) | YES | ||||
| l_mod_id | varchar(8) | YES | ||||
| ship_via | varchar(15) | YES | ||||
| fob_point | varchar(15) | YES | ||||
| reprint_no | smallint(6) | YES | ||||
| confirmed_to | varchar(20) | YES | ||||
| curr_rate_type | varchar(6) | YES | ||||
| currency_rate | decimal(16,2) | YES | ||||
| terms_code | varchar(6) | YES | ||||
| spec_shipping | varchar(40) | YES | ||||
| authorized_by | varchar(8) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |