aurora_standard.stpcashe
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| chk_date | date | YES | ||||
| doc_no | bigint(20) unsigned | NO | PRI | auto_increment | ||
| vend_code | varchar(6) | YES | MUL | |||
| pay_to_code | varchar(6) | YES | ||||
| gross_entry | varchar(1) | YES | ||||
| def_mtaxcd | varchar(6) | YES | ||||
| check_no | varchar(10) | YES | ||||
| doc_desc | varchar(30) | YES | ||||
| cash_amt | decimal(12,2) | YES | ||||
| cash_acct | int(11) | YES | ||||
| cash_department | varchar(3) | YES | ||||
| cash_deb_cred | varchar(2) | YES | ||||
| oa_amt | decimal(12,2) | YES | ||||
| oa_acct | int(11) | YES | ||||
| oa_department | varchar(3) | YES | ||||
| oa_deb_cred | varchar(2) | YES | ||||
| print_chk | varchar(1) | YES | ||||
| ok_to_post | varchar(1) | YES | ||||
| chk_printed | varchar(1) | YES | ||||
| ap_type | varchar(1) | YES | ||||
| fac_no | varchar(3) | YES | ||||
| cash_fac_no | varchar(3) | YES | ||||
| credit_card_vend | char(1) | YES |