aurora_standard.stxratid
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| acct_no | int(11) | YES | ||||
| principal_payment | varchar(1) | YES | ||||
| allowances_contr | varchar(1) | YES | ||||
| ar_net_patient | varchar(1) | YES | ||||
| assets_current | varchar(1) | YES | ||||
| assets_net | varchar(1) | YES | ||||
| assets_net_fixed | varchar(1) | YES | ||||
| assets_total | varchar(1) | YES | ||||
| cash | varchar(1) | YES | ||||
| debt_long_term | varchar(1) | YES | ||||
| depreciation_accum | varchar(1) | YES | ||||
| inventory | varchar(1) | YES | ||||
| investments_st | varchar(1) | YES | ||||
| invest_unrest_lt | varchar(1) | YES | ||||
| liabilities_cur | varchar(1) | YES | ||||
| expense_bad_debt | varchar(1) | YES | ||||
| expense_depr | varchar(1) | YES | ||||
| expense_interest | varchar(1) | YES | ||||
| expenses_total | varchar(1) | YES | ||||
| fringe_benefits | varchar(1) | YES | ||||
| revenue_gross_pat | varchar(1) | YES | ||||
| revenue_net_ip | varchar(1) | YES | ||||
| revenue_net_nonop | varchar(1) | YES | ||||
| revenue_net_op | varchar(1) | YES | ||||
| revenue_net_pat | varchar(1) | YES | ||||
| revenue_operating | varchar(1) | YES | ||||
| revenues_total | varchar(1) | YES | ||||
| salaries | varchar(1) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |