aurora_standard.cftrbal

Field Type Null Default Key Extra Comment
old_acct varchar(12) NO
debit decimal(12,2) NO
credit decimal(12,2) NO
doc_date date NO
chs_rowID bigint(20) unsigned NO PRI auto_increment

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