aurora_standard.stropend
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| cust_code | varchar(6) | YES | MUL | |||
| inv_no | varchar(10) | YES | MUL | |||
| doc_no | int(11) | YES | UNI | |||
| inv_desc | varchar(30) | YES | ||||
| inv_date | date | YES | ||||
| orig_amount | decimal(12,0) | YES | ||||
| disc_amt | decimal(12,0) | YES | ||||
| balance | decimal(12,0) | YES | ||||
| disc_bal | decimal(12,0) | YES | ||||
| due_date | date | YES | ||||
| disc_date | date | YES | ||||
| ar_acct_no | int(11) | YES | ||||
| ar_department | varchar(3) | YES | ||||
| po_no | varchar(10) | YES | ||||
| po_date | date | YES | ||||
| item_type | varchar(2) | YES | ||||
| currency_code | varchar(3) | YES | ||||
| curr_ex_rate | decimal(16,0) | YES | ||||
| home_curr_amount | decimal(12,0) | YES | ||||
| last_pay_date | date | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |