aurora_standard.strnoted
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| note_code | varchar(6) | YES | ||||
| cust_code | varchar(6) | YES | ||||
| orig_invoice | varchar(10) | YES | ||||
| orig_amount | decimal(12,0) | YES | ||||
| percent_interest | smallint(6) | YES | ||||
| payment_amt | decimal(12,2) | YES | ||||
| term | smallint(6) | YES | ||||
| collateral | varchar(20) | YES | ||||
| ucc_filing | varchar(1) | YES | ||||
| date_paid_off | date | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |