aurora_standard.stucntrc
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| exempt_tax_code | varchar(6) | YES | ||||
| frght_tax_code | varchar(6) | YES | ||||
| misc_tax_code | varchar(6) | YES | ||||
| mtaxg_code | varchar(6) | YES | ||||
| gross_entry | varchar(1) | YES | ||||
| entry_by_line | varchar(1) | YES | ||||
| whse_shipto | varchar(10) | YES | ||||
| whse_billto | varchar(10) | YES | ||||
| po_type | varchar(3) | YES | ||||
| retention_days | smallint(6) | YES | ||||
| eta_days | smallint(6) | YES | ||||
| cm_reason | varchar(3) | YES | ||||
| dm_reason | varchar(3) | YES | ||||
| terms_code | varchar(6) | YES | ||||
| ap_acct_no | int(11) | YES | ||||
| disc_acct_no | int(11) | YES | ||||
| frght_acct_no | int(11) | YES | ||||
| misc_acct_no | int(11) | YES | ||||
| inv_acct_no | int(11) | YES | ||||
| adj_acct_no | int(11) | YES | ||||
| prepaid_acct_no | int(11) | YES | ||||
| supp_acct_no | int(11) | YES | ||||
| cap_acct_no | int(11) | YES | ||||
| non_acct_no | int(11) | YES | ||||
| diff_acct_no | int(11) | YES | ||||
| cash_acct_no | int(11) | YES | ||||
| buyer_code | varchar(6) | YES | ||||
| price_tolerance | decimal(10,2) | YES | ||||
| line_type | varchar(3) | YES | ||||
| use_department | varchar(1) | YES | ||||
| req_doc_no | int(11) | YES | ||||
| po_doc_no | int(11) | YES | ||||
| rec_doc_no | int(11) | YES | ||||
| inv_doc_no | int(11) | YES | ||||
| req_post_no | int(11) | YES | ||||
| rec_post_no | int(11) | YES | ||||
| inv_post_no | int(11) | YES | ||||
| merge_requisitions | varchar(1) | YES | ||||
| ship_via | varchar(15) | YES | ||||
| fob_point | varchar(15) | YES | ||||
| print_notes | varchar(1) | YES | ||||
| ret_doc_no | int(11) | YES | ||||
| ret_acct_no | int(11) | YES | ||||
| ret_fee_acct_no | int(11) | YES | ||||
| ret_post_no | int(11) | YES | ||||
| gl_cut_off | date | YES | ||||
| fac_no | varchar(3) | YES | ||||
| cash_fac_no | varchar(3) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |