aurora_standard.stuinvcd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| inv_doc_no | int(11) | YES | MUL | |||
| inv_line_no | smallint(6) | YES | ||||
| po_doc_no | int(11) | YES | MUL | |||
| po_line_no | smallint(6) | YES | MUL | |||
| cost_qty | decimal(10,2) | YES | ||||
| cost | decimal(12,3) | YES | ||||
| net_price | decimal(10,2) | YES | ||||
| gl_acct_no | int(11) | YES | ||||
| department | varchar(3) | YES | ||||
| mtaxg_code | varchar(6) | YES | ||||
| exp_tax_amt | decimal(10,2) | YES | ||||
| exp_tax_frz | varchar(1) | YES | ||||
| fac_no | varchar(3) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |