aurora_standard.strcashd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| doc_no | int(11) | YES | MUL | |||
| inv_doc_no | int(11) | YES | ||||
| inv_no | varchar(10) | YES | ||||
| due_date | date | YES | ||||
| dist_acct | int(11) | YES | ||||
| dist_department | varchar(3) | YES | ||||
| dist_amt | decimal(12,0) | YES | ||||
| dist_deb_cred | varchar(2) | YES | ||||
| mtax_code | varchar(6) | YES | ||||
| goods_amt | decimal(12,0) | YES | ||||
| disc_acct | int(11) | YES | ||||
| disc_department | varchar(3) | YES | ||||
| disc_amt | decimal(12,0) | YES | ||||
| disc_deb_cred | varchar(2) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |