aurora_standard.stpcntrc
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| terms_code | varchar(6) | YES | ||||
| ap_acct_no | int(11) | YES | ||||
| cd_cash_acct_no | int(11) | YES | ||||
| cd_disc_acct_no | int(11) | YES | ||||
| ap_doc_no | int(11) | YES | ||||
| ap_post_no | int(11) | YES | ||||
| ap_balanced | varchar(1) | YES | ||||
| cd_doc_no | int(11) | YES | ||||
| cd_post_no | int(11) | YES | ||||
| age_datetype | varchar(1) | YES | ||||
| age_per1 | smallint(6) | YES | ||||
| age_per2 | smallint(6) | YES | ||||
| age_per3 | smallint(6) | YES | ||||
| age_dsc1 | varchar(15) | YES | ||||
| age_dsc2 | varchar(15) | YES | ||||
| age_dsc3 | varchar(15) | YES | ||||
| age_dsc4 | varchar(15) | YES | ||||
| federal_tax_id | varchar(10) | YES | ||||
| dflt_1099 | varchar(1) | YES | ||||
| def_mtaxcd | varchar(6) | YES | ||||
| gross_entry | varchar(1) | YES | ||||
| mtax_dsc | varchar(1) | YES | ||||
| entry_by_line | varchar(1) | YES | ||||
| disc_frght | varchar(1) | YES | ||||
| disc_tax | varchar(1) | YES | ||||
| fac_no | varchar(3) | YES | ||||
| cash_fac_no | varchar(3) | YES | ||||
| disc_fac_no | varchar(3) | YES | ||||
| due_to_acct | int(11) | YES | ||||
| due_from_acct | int(11) | YES | ||||
| gl_cut_off | date | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |