aurora_standard.stpinvce
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| doc_no | bigint(20) unsigned | NO | PRI | auto_increment | ||
| inv_no | varchar(15) | YES | ||||
| department | varchar(3) | YES | ||||
| file_type | varchar(1) | YES | ||||
| ref_no | int(11) | YES | ||||
| inv_desc | varchar(30) | YES | ||||
| doc_date | date | YES | ||||
| vend_code | varchar(6) | YES | ||||
| pay_to_code | varchar(6) | YES | ||||
| posted | varchar(1) | YES | ||||
| recurring | varchar(1) | YES | ||||
| terms_code | varchar(6) | YES | ||||
| inv_date | date | YES | ||||
| to_pay_date | date | YES | ||||
| due_date | date | YES | ||||
| disc_date | date | YES | ||||
| disc_pct | decimal(6,2) | YES | ||||
| po_date | date | YES | ||||
| po_no | varchar(10) | YES | ||||
| disc_acct_no | int(11) | YES | ||||
| disc_department | varchar(3) | YES | ||||
| disc_amount | decimal(12,2) | YES | ||||
| disc_debit_credit | varchar(2) | YES | ||||
| ap_acct_no | int(11) | YES | ||||
| ap_department | varchar(3) | YES | ||||
| ap_amount | decimal(12,2) | YES | ||||
| ap_debit_credit | varchar(2) | YES | ||||
| ok_to_post | varchar(1) | YES | ||||
| cash_acct_no | int(11) | YES | ||||
| cash_department | varchar(3) | YES | ||||
| recurr_ref | varchar(10) | YES | ||||
| def_mtaxcd | varchar(6) | YES | ||||
| gross_entry | varchar(1) | YES | ||||
| currency_code | varchar(3) | YES | ||||
| curr_ex_rate | decimal(16,2) | YES | ||||
| home_curr_amount | decimal(12,2) | YES | ||||
| fix_date_flag | varchar(1) | YES | ||||
| fac_no | varchar(3) | YES | ||||
| cash_fac_no | varchar(3) | YES | ||||
| user_login | char(8) | YES | ||||
| internet_taxable | char(1) | YES |