aurora_standard.bwork1
Field
Type
Null
Default
Key
Extra
Comment
acct_no
int(11)
YES
ptrep
char(2)
YES
References
Local Column
References
acct_no
Table
Column
aurora_standard.chmcashd
non_pat_acct_no
aurora_standard.chmnbcgd
non_pat_acct_no
aurora_standard.chmnbpyd
non_pat_acct_no
aurora_standard.chmnchgd
non_pat_acct_no
aurora_standard.chmnpatr
non_pat_acct_no
aurora_standard.chmnpayd
non_pat_acct_no
aurora_standard.chmrefnd
contr_acct_no
aurora_standard.chpcashr
cash_acct_no
aurora_standard.chpcobpd
cash_acct_no
aurora_standard.chpcobpd
bal_acct_no
aurora_standard.chrcntrc
rx_inv_acct_no
aurora_standard.chrcntrc
rx_exp_acct_no
aurora_standard.curs_temp
cash_acct_no
aurora_standard.np_statm
non_pat_acct_no
aurora_standard.sticntrc
inv_acct_no
aurora_standard.sticntrc
sales_acct_no
aurora_standard.sticntrc
cog_acct_no
aurora_standard.sticntrc
adj_acct_no
aurora_standard.sticntrc
count_acct_no
aurora_standard.sticntrc
hold_acct_no
aurora_standard.stiinvtr
inv_acct_no
aurora_standard.stiinvtr
cog_acct_no
aurora_standard.stiinvtr
sales_acct_no
aurora_standard.stiinvtr
supp_acct_no
aurora_standard.stitrand
exp_acct_no
aurora_standard.stiwhser
inv_acct_no
aurora_standard.stpcntrc
ap_acct_no
aurora_standard.stpcntrc
cd_cash_acct_no
aurora_standard.stpcntrc
cd_disc_acct_no
aurora_standard.stpinvce
disc_acct_no
aurora_standard.stpinvce
ap_acct_no
aurora_standard.stpinvce
cash_acct_no
aurora_standard.stpopend
ap_acct_no
aurora_standard.stpopend
cash_acct_no
aurora_standard.stpvendr
cash_acct_no
aurora_standard.stpvendr
exp_acct_no
aurora_standard.stpvendr
hosp_acct_no
aurora_standard.strcntrc
ar_acct_no
aurora_standard.strcntrc
ar_sales_acct_no
aurora_standard.strcntrc
ar_tax_acct_no
aurora_standard.strcntrc
ar_frght_acct_no
aurora_standard.strcntrc
ar_misc_acct_no
aurora_standard.strcntrc
ar_fc_acct_no
aurora_standard.strcntrc
cr_cash_acct_no
aurora_standard.strcntrc
cr_disc_acct_no
aurora_standard.strinvce
disc_acct_no
aurora_standard.strinvce
tax_acct_no
aurora_standard.strinvce
frght_acct_no
aurora_standard.strinvce
misc_acct_no
aurora_standard.strinvce
ar_acct_no
aurora_standard.stropend
ar_acct_no
aurora_standard.stucntrc
ap_acct_no
aurora_standard.stucntrc
disc_acct_no
aurora_standard.stucntrc
frght_acct_no
aurora_standard.stucntrc
misc_acct_no
aurora_standard.stucntrc
inv_acct_no
aurora_standard.stucntrc
adj_acct_no
aurora_standard.stucntrc
prepaid_acct_no
aurora_standard.stucntrc
supp_acct_no
aurora_standard.stucntrc
cap_acct_no
aurora_standard.stucntrc
non_acct_no
aurora_standard.stucntrc
diff_acct_no
aurora_standard.stucntrc
cash_acct_no
aurora_standard.stucntrc
ret_acct_no
aurora_standard.stucntrc
ret_fee_acct_no
aurora_standard.stuinvcd
gl_acct_no
aurora_standard.stultypr
gl_acct_no
aurora_standard.stuordrd
gl_acct_no
aurora_standard.stxcurrr
ex_diff_acct_no
aurora_standard.stxfinsd
fin_acct_no
aurora_standard.stxinfor
src_acct_no
aurora_standard.stxmtaxr
ar_acct_no
aurora_standard.stxmtaxr
ar_disc_acct_no
aurora_standard.stxmtaxr
ap_acct_no
aurora_standard.stxmtaxr
ap_disc_acct_no
aurora_standard.stycntrc
co_bank_acct_no
aurora_standard.styddepd
bank_acct_no
aurora_standard.styemplr
bank_acct_no
aurora_standard.styempod
bal_acct_no
aurora_standard.stypayod
bal_acct_no
aurora_standard.stypayre
cash_acct_no
aurora_standard.stypddrd
bank_acct_no
aurora_standard.styrevsd
cash_acct_no
aurora_standard.stytypod
bal_acct_no
aurora_standard.styuimmr
ui_acct_no
aurora_standard.ttiinvtr
inv_acct_no
aurora_standard.ttiinvtr
cog_acct_no
aurora_standard.ttiinvtr
sales_acct_no
aurora_standard.ttiinvtr
supp_acct_no
aurora_standard.wkactvv
inv_acct_no