aurora_standard.stotrbal

Field Type Null Default Key Extra Comment
acct_no varchar(14) YES
debit decimal(12,2) YES
credit decimal(12,2) YES
doc_date date NO

References

Local Column References
credit
TableColumn
_1.billing_codesbil_credit
_1.closed_periods_dailyclpd_payments_credit
_1.closed_periods_dailyclpd_adjustments_credit
_1188.billing_codesbil_credit
_1188.closed_periods_dailyclpd_payments_credit
_1188.closed_periods_dailyclpd_adjustments_credit
_1218.billing_codesbil_credit
_1218.closed_periods_dailyclpd_payments_credit
_1218.closed_periods_dailyclpd_adjustments_credit
_1548.billing_codesbil_credit
_1548.closed_periods_dailyclpd_payments_credit
_1548.closed_periods_dailyclpd_adjustments_credit
_435.billing_codesbil_credit
_435.closed_periods_dailyclpd_payments_credit
_435.closed_periods_dailyclpd_adjustments_credit
_435.ledger_running_balancelrb_is_credit
_436.billing_codesbil_credit
_436.closed_periods_dailyclpd_payments_credit
_436.closed_periods_dailyclpd_adjustments_credit
_436.ledger_running_balancelrb_is_credit
_436_archive_testing.billing_codesbil_credit
_436_archive_testing.closed_periods_dailyclpd_payments_credit
_436_archive_testing.closed_periods_dailyclpd_adjustments_credit
_436_archive_testing.ledger_running_balancelrb_is_credit
_437.billing_codesbil_credit
_437.closed_periods_dailyclpd_payments_credit
_437.closed_periods_dailyclpd_adjustments_credit
_437.ledger_running_balancelrb_is_credit
_8.billing_codesbil_credit
_8.closed_periods_dailyclpd_payments_credit
_8.closed_periods_dailyclpd_adjustments_credit
_8.daily_close_calculationsdcc_bil_credit
_81.billing_codesbil_credit
_81.closed_periods_dailyclpd_payments_credit
_81.closed_periods_dailyclpd_adjustments_credit
_999.billing_codesbil_credit
_999.closed_periods_dailyclpd_payments_credit
_999.closed_periods_dailyclpd_adjustments_credit
aurora_standard.chmperxdcharge_credit
aurora_standard.chmpxchdcharge_credit
aurora_standard.chpcashddebit_credit
aurora_standard.chpempcdceu_credit
aurora_standard.chpinsrcceu_credit
aurora_standard.chrpxordcharge_credit
aurora_standard.dtgactvddebit_credit
aurora_standard.stgactvddebit_credit
aurora_standard.stgactvvdebit_credit
aurora_standard.stgjourddebit_credit
aurora_standard.stgwhseddebit_credit
aurora_standard.stitrantdebit_credit
aurora_standard.stpapckvdebit_credit
aurora_standard.stpinvcddebit_credit
aurora_standard.strinvcddebit_credit
aurora_standard.stxckrgddebit_credit
aurora_standard.stxmtaxddebit_credit
aurora_standard.stxtaxlddebit_credit
debit
TableColumn
_1.closed_periods_dailyclpd_payments_debit
_1.closed_periods_dailyclpd_adjustments_debit
_1188.closed_periods_dailyclpd_payments_debit
_1188.closed_periods_dailyclpd_adjustments_debit
_1218.closed_periods_dailyclpd_payments_debit
_1218.closed_periods_dailyclpd_adjustments_debit
_1548.closed_periods_dailyclpd_payments_debit
_1548.closed_periods_dailyclpd_adjustments_debit
_435.closed_periods_dailyclpd_payments_debit
_435.closed_periods_dailyclpd_adjustments_debit
_436.closed_periods_dailyclpd_payments_debit
_436.closed_periods_dailyclpd_adjustments_debit
_436_archive_testing.closed_periods_dailyclpd_payments_debit
_436_archive_testing.closed_periods_dailyclpd_adjustments_debit
_437.closed_periods_dailyclpd_payments_debit
_437.closed_periods_dailyclpd_adjustments_debit
_8.closed_periods_dailyclpd_payments_debit
_8.closed_periods_dailyclpd_adjustments_debit
_81.closed_periods_dailyclpd_payments_debit
_81.closed_periods_dailyclpd_adjustments_debit
_999.closed_periods_dailyclpd_payments_debit
_999.closed_periods_dailyclpd_adjustments_debit
aurora_standard.stpinvcedisc_debit_credit
aurora_standard.stpinvceap_debit_credit
aurora_standard.strinvcedisc_debit_credit
aurora_standard.strinvcetax_debit_credit
aurora_standard.strinvcefrght_debit_credit
aurora_standard.strinvcemisc_debit_credit
aurora_standard.strinvcear_debit_credit
aurora_standard.stycntrcoffset_debit
acct_no
TableColumn
aurora_standard.chmcashdnon_pat_acct_no
aurora_standard.chmnbcgdnon_pat_acct_no
aurora_standard.chmnbpydnon_pat_acct_no
aurora_standard.chmnchgdnon_pat_acct_no
aurora_standard.chmnpatrnon_pat_acct_no
aurora_standard.chmnpaydnon_pat_acct_no
aurora_standard.chmrefndcontr_acct_no
aurora_standard.chpcashrcash_acct_no
aurora_standard.chpcobpdcash_acct_no
aurora_standard.chpcobpdbal_acct_no
aurora_standard.chrcntrcrx_inv_acct_no
aurora_standard.chrcntrcrx_exp_acct_no
aurora_standard.curs_tempcash_acct_no
aurora_standard.np_statmnon_pat_acct_no
aurora_standard.sticntrcinv_acct_no
aurora_standard.sticntrcsales_acct_no
aurora_standard.sticntrccog_acct_no
aurora_standard.sticntrcadj_acct_no
aurora_standard.sticntrccount_acct_no
aurora_standard.sticntrchold_acct_no
aurora_standard.stiinvtrinv_acct_no
aurora_standard.stiinvtrcog_acct_no
aurora_standard.stiinvtrsales_acct_no
aurora_standard.stiinvtrsupp_acct_no
aurora_standard.stitrandexp_acct_no
aurora_standard.stiwhserinv_acct_no
aurora_standard.stpcntrcap_acct_no
aurora_standard.stpcntrccd_cash_acct_no
aurora_standard.stpcntrccd_disc_acct_no
aurora_standard.stpinvcedisc_acct_no
aurora_standard.stpinvceap_acct_no
aurora_standard.stpinvcecash_acct_no
aurora_standard.stpopendap_acct_no
aurora_standard.stpopendcash_acct_no
aurora_standard.stpvendrcash_acct_no
aurora_standard.stpvendrexp_acct_no
aurora_standard.stpvendrhosp_acct_no
aurora_standard.strcntrcar_acct_no
aurora_standard.strcntrcar_sales_acct_no
aurora_standard.strcntrcar_tax_acct_no
aurora_standard.strcntrcar_frght_acct_no
aurora_standard.strcntrcar_misc_acct_no
aurora_standard.strcntrcar_fc_acct_no
aurora_standard.strcntrccr_cash_acct_no
aurora_standard.strcntrccr_disc_acct_no
aurora_standard.strinvcedisc_acct_no
aurora_standard.strinvcetax_acct_no
aurora_standard.strinvcefrght_acct_no
aurora_standard.strinvcemisc_acct_no
aurora_standard.strinvcear_acct_no
aurora_standard.stropendar_acct_no
aurora_standard.stucntrcap_acct_no
aurora_standard.stucntrcdisc_acct_no
aurora_standard.stucntrcfrght_acct_no
aurora_standard.stucntrcmisc_acct_no
aurora_standard.stucntrcinv_acct_no
aurora_standard.stucntrcadj_acct_no
aurora_standard.stucntrcprepaid_acct_no
aurora_standard.stucntrcsupp_acct_no
aurora_standard.stucntrccap_acct_no
aurora_standard.stucntrcnon_acct_no
aurora_standard.stucntrcdiff_acct_no
aurora_standard.stucntrccash_acct_no
aurora_standard.stucntrcret_acct_no
aurora_standard.stucntrcret_fee_acct_no
aurora_standard.stuinvcdgl_acct_no
aurora_standard.stultyprgl_acct_no
aurora_standard.stuordrdgl_acct_no
aurora_standard.stxcurrrex_diff_acct_no
aurora_standard.stxfinsdfin_acct_no
aurora_standard.stxinforsrc_acct_no
aurora_standard.stxmtaxrar_acct_no
aurora_standard.stxmtaxrar_disc_acct_no
aurora_standard.stxmtaxrap_acct_no
aurora_standard.stxmtaxrap_disc_acct_no
aurora_standard.stycntrcco_bank_acct_no
aurora_standard.styddepdbank_acct_no
aurora_standard.styemplrbank_acct_no
aurora_standard.styempodbal_acct_no
aurora_standard.stypayodbal_acct_no
aurora_standard.stypayrecash_acct_no
aurora_standard.stypddrdbank_acct_no
aurora_standard.styrevsdcash_acct_no
aurora_standard.stytypodbal_acct_no
aurora_standard.styuimmrui_acct_no
aurora_standard.ttiinvtrinv_acct_no
aurora_standard.ttiinvtrcog_acct_no
aurora_standard.ttiinvtrsales_acct_no
aurora_standard.ttiinvtrsupp_acct_no
aurora_standard.wkactvvinv_acct_no