aurora_standard.sticntrc
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| item_type | varchar(1) | YES | ||||
| item_class | varchar(6) | YES | ||||
| inv_acct_no | int(11) | YES | ||||
| sales_acct_no | int(11) | YES | ||||
| cog_acct_no | int(11) | YES | ||||
| adj_acct_no | int(11) | YES | ||||
| count_acct_no | int(11) | YES | ||||
| count_cycle | varchar(1) | YES | ||||
| comm_code | varchar(6) | YES | ||||
| allow_bo | varchar(1) | YES | ||||
| taxable | varchar(1) | YES | ||||
| terms_disc | varchar(1) | YES | ||||
| trade_disc | varchar(1) | YES | ||||
| ic_setup_done | varchar(1) | YES | ||||
| doc_no | int(11) | YES | ||||
| post_no | int(11) | YES | ||||
| use_department | varchar(1) | YES | ||||
| cost_method | varchar(1) | YES | ||||
| ilocar_ina_days | smallint(6) | YES | ||||
| ilocar_ret_days | smallint(6) | YES | ||||
| class1 | decimal(6,2) | YES | ||||
| class2 | decimal(6,2) | YES | ||||
| class3 | decimal(6,2) | YES | ||||
| class4 | decimal(6,2) | YES | ||||
| class5 | decimal(6,2) | YES | ||||
| class6 | decimal(6,2) | YES | ||||
| class7 | decimal(6,2) | YES | ||||
| class8 | decimal(6,2) | YES | ||||
| class9 | decimal(6,2) | YES | ||||
| class10 | decimal(6,2) | YES | ||||
| class11 | decimal(6,2) | YES | ||||
| class12 | decimal(6,2) | YES | ||||
| class13 | decimal(6,2) | YES | ||||
| hold_acct_no | int(11) | YES | ||||
| issue_no | int(11) | YES | ||||
| gl_cut_off | date | YES | ||||
| fac_no | varchar(3) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |