MonthlyAgingBalance_outs


Description

Monthly aging balance for outside sources tracking outstanding balances by aging periods specifically for external or outside source billing and accounts receivable. This specialized aging table manages balance analysis for outside source billing including aging periods, site-specific balances, and collection tracking, supporting financial management and accounts receivable processes for external billing relationships.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AgeID int identity 4 √ null

Primary key - Unique identifier for each outside source aging balance record
AsOfDate smalldatetime 16 √ null

Report date - Date as of which the outside source aging balance was calculated
Sitename varchar 50 √ null

Site name - Name of the healthcare site or location for this outside source aging report
Day30 money 21,4 √ null

30-day balance - Outstanding outside source balance for accounts 0-30 days old
Day60 money 21,4 √ null

60-day balance - Outstanding outside source balance for accounts 31-60 days old
Day90 money 21,4 √ null

90-day balance - Outstanding outside source balance for accounts 61-90 days old
Day120 money 21,4 √ null

120-day balance - Outstanding outside source balance for accounts 91-120 days old
Day365 money 21,4 √ null

365-day balance - Outstanding outside source balance for accounts 121-365 days old
Over365 money 21,4 √ null

Over 365-day balance - Outstanding outside source balance for accounts over 365 days old
SiteAmount money 21,4 √ null

Total site amount - Total outstanding outside source balance for the site
Day180 money 21,4 √ null

180-day balance - Outstanding outside source balance for accounts 121-180 days old
Day270 money 21,4 √ null

270-day balance - Outstanding outside source balance for accounts 181-270 days old

Relationships

Close relationships within degrees of separation