_436_archive_testing.ledger_running_balance
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| lrb_id | int(11) | NO | PRI | auto_increment | ||
| lrb_cus_id | int(11) | NO | Customer id | |||
| lrb_cli_id | int(11) | NO | MUL | Client id | ||
| lrb_led_id | int(11) | NO | UNI | Ledger id | ||
| lrb_ecp_id | int(11) | NO | MUL | Encounter CPT id | ||
| lrb_next_payer_bill_type | char(1) | NO | MUL | Next payer bill type, not to be confused with led_bil_type. 2=insurance 3=patient | ||
| lrb_next_payer_pri_sec_ter | char(1) | NO | MUL | For next payer insurance indicates which type | ||
| lrb_subtotal | varchar(20) | NO | current total | |||
| lrb_is_credit | char(1) | NO | Indicates Balance is a credit |
References
| Local Column | References |
|---|