aurora_standard.strcntrc

Field Type Null Default Key Extra Comment
terms_code varchar(6) YES
tax_pct decimal(6,0) YES
ar_acct_no int(11) YES
ar_sales_acct_no int(11) YES
ar_tax_acct_no int(11) YES
ar_frght_acct_no int(11) YES
ar_misc_acct_no int(11) YES
ar_fc_acct_no int(11) YES
cr_cash_acct_no int(11) YES
cr_disc_acct_no int(11) YES
ar_doc_no int(11) YES
ar_post_no int(11) YES
ar_balanced varchar(1) YES
cr_doc_no int(11) YES
cr_post_no int(11) YES
disc_misc varchar(1) YES
disc_frght varchar(1) YES
disc_tax varchar(1) YES
auto_inactive_days smallint(6) YES
inactive_ret_days smallint(6) 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
mtax_misc varchar(6) YES
mtax_frght varchar(6) YES
def_mtaxcd varchar(6) YES
gross_entry varchar(1) YES
mtax_dsc varchar(1) YES
mtax_fc varchar(6) YES
last_inv_no int(11) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References