_1218.led_temporary_ledger_table_ANM

Field	Type	Null	Default	Key	Extra	Comment
ANM_temp	int(11)	NO	1
led_id	int(11)	NO		PRI	auto_increment
led_cus_id	int(11)	NO
led_cli_id	int(11)	NO
led_enc_id	int(11)	NO		MUL
led_bil_id	int(11)	NO
led_ecp_id	int(11)	NO		MUL
led_apply_to_ecp_id	int(11)	NO		MUL
led_pmt_led_id	int(11)	NO				led_id of a payment that an adjustment is linked to
led_clp_id	int(11)	NO		MUL
led_clpd_id	int(11)	NO		MUL
led_date	varchar(8)	NO		MUL
led_led_id	int(11)	NO		MUL
led_amount	decimal(10,2)	YES		MUL		Currency amount
led_orig_amount	decimal(10,2)	YES				Original currency amount for unapplied payments

References

Local Column

References

led_id

Table	Column
_1.audits	aud_led_id
_1.audits_archive	aud_led_id
_1.encounters_cpt_codes	ecp_reverse_led_id
_1.encounters_cpt_denials	ecd_pmt_led_id
_1.encounters_edi_errors	eep_led_id
_1.ledger	led_pmt_led_id
_1.ledger	led_led_id
_1.ledger_unapplied_payments	lup_led_id
_1.patients_payments_ledger_map	pplm_led_id
_1.voided_payments	vp_led_id
_1188.audits	aud_led_id
_1188.audits_archive	aud_led_id
_1188.encounters_cpt_denials	ecd_pmt_led_id
_1188.encounters_edi_errors	eep_led_id
_1188.encounters_payments_groupings	epg_pmt_led_id
_1188.ledger	led_pmt_led_id
_1188.ledger	led_led_id
_1188.ledger_unapplied_payments	lup_led_id
_1188.patients_payments_ledger_map	pplm_led_id
_1188.voided_payments	vp_led_id
_1218.audits	aud_led_id
_1218.audits_archive	aud_led_id
_1218.encounters_cpt_codes	ecp_reverse_led_id
_1218.encounters_cpt_denials	ecd_pmt_led_id
_1218.encounters_edi_errors	eep_led_id
_1218.encounters_payments_groupings	epg_pmt_led_id
_1218.ledger	led_pmt_led_id
_1218.ledger	led_led_id
_1218.ledger_unapplied_payments	lup_led_id
_1218.patients_payments_ledger_map	pplm_led_id
_1218.voided_payments	vp_led_id
_1548.audits	aud_led_id
_1548.audits_archive	aud_led_id
_1548.encounters_cpt_codes	ecp_reverse_led_id
_1548.encounters_cpt_denials	ecd_pmt_led_id
_1548.encounters_edi_errors	eep_led_id
_1548.ledger	led_pmt_led_id
_1548.ledger	led_led_id
_1548.ledger_unapplied_payments	lup_led_id
_1548.patients_payments_ledger_map	pplm_led_id
_1548.voided_payments	vp_led_id
_435.audits	aud_led_id
_435.audits_archive	aud_led_id
_435.encounters_cpt_codes	ecp_reverse_led_id
_435.encounters_cpt_denials	ecd_pmt_led_id
_435.encounters_edi_errors	eep_led_id
_435.encounters_payments_groupings	epg_pmt_led_id
_435.ledger	led_pmt_led_id
_435.ledger	led_led_id
_435.ledger_running_balance	lrb_led_id
_435.ledger_unapplied_payments	lup_led_id
_435.patients_payments_ledger_map	pplm_led_id
_435.voided_payments	vp_led_id
_436.audits	aud_led_id
_436.audits_archive	aud_led_id
_436.encounters_cpt_codes	ecp_reverse_led_id
_436.encounters_cpt_denials	ecd_pmt_led_id
_436.encounters_edi_errors	eep_led_id
_436.encounters_payments_groupings	epg_pmt_led_id
_436.ledger	led_pmt_led_id
_436.ledger	led_led_id
_436.ledger_running_balance	lrb_led_id
_436.ledger_unapplied_payments	lup_led_id
_436.patients_payments_ledger_map	pplm_led_id
_436.voided_payments	vp_led_id
_436_archive_testing.audits	aud_led_id
_436_archive_testing.audits_archive	aud_led_id
_436_archive_testing.encounters_cpt_codes	ecp_reverse_led_id
_436_archive_testing.encounters_cpt_denials	ecd_pmt_led_id
_436_archive_testing.encounters_edi_errors	eep_led_id
_436_archive_testing.encounters_payments_groupings	epg_pmt_led_id
_436_archive_testing.ledger	led_pmt_led_id
_436_archive_testing.ledger	led_led_id
_436_archive_testing.ledger_running_balance	lrb_led_id
_436_archive_testing.ledger_unapplied_payments	lup_led_id
_436_archive_testing.patients_payments_ledger_map	pplm_led_id
_436_archive_testing.voided_payments	vp_led_id
_437.audits	aud_led_id
_437.audits_archive	aud_led_id
_437.encounters_cpt_codes	ecp_reverse_led_id
_437.encounters_cpt_denials	ecd_pmt_led_id
_437.encounters_edi_errors	eep_led_id
_437.encounters_payments_groupings	epg_pmt_led_id
_437.ledger	led_pmt_led_id
_437.ledger	led_led_id
_437.ledger_running_balance	lrb_led_id
_437.ledger_unapplied_payments	lup_led_id
_437.patients_payments_ledger_map	pplm_led_id
_437.voided_payments	vp_led_id
_8.audits	aud_led_id
_8.audits_archive	aud_led_id
_8.daily_close_calculations	dcc_led_id
_8.encounters_cpt_codes	ecp_reverse_led_id
_8.encounters_cpt_denials	ecd_pmt_led_id
_8.encounters_edi_errors	eep_led_id
_8.ledger	led_pmt_led_id
_8.ledger	led_led_id
_8.ledger_unapplied_payments	lup_led_id
_8.patients_payments_ledger_map	pplm_led_id
_8.voided_payments	vp_led_id
_81.audits	aud_led_id
_81.audits_archive	aud_led_id
_81.encounters_cpt_codes	ecp_reverse_led_id
_81.encounters_cpt_denials	ecd_pmt_led_id
_81.encounters_edi_errors	eep_led_id
_81.encounters_payments_groupings	epg_pmt_led_id
_81.ledger	led_pmt_led_id
_81.ledger	led_led_id
_81.ledger_unapplied_payments	lup_led_id
_81.patients_payments_ledger_map	pplm_led_id
_81.voided_payments	vp_led_id
_999.audits	aud_led_id
_999.audits_archive	aud_led_id
_999.encounters_cpt_codes	ecp_reverse_led_id
_999.encounters_cpt_denials	ecd_pmt_led_id
_999.encounters_edi_errors	eep_led_id
_999.ledger	led_pmt_led_id
_999.ledger	led_led_id
_999.ledger_unapplied_payments	lup_led_id
_999.patients_payments_ledger_map	pplm_led_id
_999.voided_payments	vp_led_id

led_led_id

Table	Column
_8.daily_close_calculations	dcc_led_led_id

led_date

Table	Column
_8.daily_close_calculations	dcc_led_date

led_amount

Table	Column
_8.daily_close_calculations	dcc_led_amount

led_orig_amount

Table	Column
_8.daily_close_calculations	dcc_led_orig_amount