aurora_standard.stuordrd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| doc_no | int(11) | YES | MUL | |||
| line_no | smallint(6) | YES | ||||
| cm_dm_reason | varchar(3) | YES | ||||
| mtaxg_code | varchar(6) | YES | ||||
| line_type | varchar(3) | YES | ||||
| line_stage | varchar(3) | YES | MUL | |||
| receiver_printed | smallint(6) | YES | ||||
| request_date | date | YES | ||||
| po_date | date | YES | ||||
| rcpt_date | date | YES | ||||
| inv_date | date | YES | ||||
| required_date | date | YES | ||||
| whse_shipto | varchar(10) | YES | ||||
| whse_billto | varchar(10) | YES | ||||
| item_code | varchar(20) | YES | MUL | |||
| desc1 | varchar(30) | YES | ||||
| desc2 | varchar(30) | YES | ||||
| td_disc_allowed | varchar(1) | YES | ||||
| bo_allowed | varchar(1) | YES | ||||
| ordr_qty | decimal(10,2) | YES | ||||
| rlse_qty | decimal(10,2) | YES | ||||
| rjct_qty | decimal(10,2) | YES | ||||
| recv_qty | decimal(10,2) | YES | ||||
| cost_qty | decimal(10,2) | YES | ||||
| acpt_qty | decimal(10,2) | YES | ||||
| exp_rec_qty | decimal(10,2) | YES | ||||
| exp_inv_qty | decimal(10,2) | YES | ||||
| sell_unit | varchar(2) | YES | ||||
| purch_unit | varchar(2) | YES | ||||
| stock_unit | varchar(2) | YES | ||||
| unit_factor | decimal(6,5) | YES | ||||
| cost | decimal(12,3) | YES | ||||
| gl_acct_no | int(11) | YES | ||||
| net_price | decimal(10,2) | YES | ||||
| department | varchar(3) | YES | ||||
| instruct_code | varchar(6) | YES | ||||
| authorization_code | varchar(6) | YES | ||||
| inspection_code | varchar(6) | YES | ||||
| alias_code | varchar(20) | YES | ||||
| weight | decimal(9,2) | YES | ||||
| staging_area | varchar(6) | YES | ||||
| order_doc_no | int(11) | YES | ||||
| order_line_no | int(11) | YES | ||||
| order_ship_no | int(11) | YES | ||||
| note_flag | varchar(1) | YES | ||||
| fac_no | varchar(3) | YES | ||||
| brand_name | varchar(10) | YES | ||||
| po_property | varchar(20) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |