aurora_standard.strinvce
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| doc_no | bigint(20) unsigned | NO | PRI | auto_increment | ||
| inv_no | varchar(10) | YES | MUL | |||
| department | varchar(3) | YES | ||||
| file_type | varchar(1) | YES | ||||
| ref_no | int(11) | YES | ||||
| tax | varchar(6) | YES | ||||
| inv_desc | varchar(30) | YES | ||||
| inv_date | date | YES | ||||
| inv_note | varchar(30) | YES | ||||
| cust_code | varchar(6) | YES | MUL | |||
| ship_to_code | varchar(6) | YES | ||||
| posted | varchar(1) | YES | ||||
| recurring | varchar(1) | YES | ||||
| terms_code | varchar(6) | YES | ||||
| due_date | date | YES | ||||
| disc_date | date | YES | ||||
| disc_pct | decimal(6,0) | YES | ||||
| po_no | varchar(10) | YES | ||||
| po_date | date | YES | ||||
| disc_acct_no | int(11) | YES | ||||
| disc_department | varchar(3) | YES | ||||
| disc_amount | decimal(12,0) | YES | ||||
| disc_debit_credit | varchar(2) | YES | ||||
| tax_acct_no | int(11) | YES | ||||
| tax_department | varchar(3) | YES | ||||
| tax_amount | decimal(12,0) | YES | ||||
| tax_debit_credit | varchar(2) | YES | ||||
| frght_acct_no | int(11) | YES | ||||
| frght_department | varchar(3) | YES | ||||
| frght_amount | decimal(12,0) | YES | ||||
| frght_debit_credit | varchar(2) | YES | ||||
| misc_acct_no | int(11) | YES | ||||
| misc_department | varchar(3) | YES | ||||
| misc_amount | decimal(12,0) | YES | ||||
| misc_debit_credit | varchar(2) | YES | ||||
| ar_acct_no | int(11) | YES | ||||
| ar_department | varchar(3) | YES | ||||
| ar_amount | decimal(12,0) | YES | ||||
| ar_debit_credit | varchar(2) | YES | ||||
| ok_to_post | varchar(1) | YES | ||||
| recurr_ref | varchar(10) | YES | ||||
| gross_entry | varchar(1) | YES | ||||
| currency_code | varchar(3) | YES | ||||
| curr_ex_rate | decimal(16,0) | YES | ||||
| home_curr_amount | decimal(12,0) | YES | ||||
| fac_no | varchar(3) | YES |