Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 1:00:52 AM Thursday, March 21, 2019 |
Last Modified | 1:00:52 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls |
---|---|---|---|
CustomerID | int | 4 | False |
AvgDueDTP3Mo | float | 8 | True |
AvgBilledDTP3Mo | float | 8 | True |
MaxAR3Mo | float | 8 | True |
MinAR3Mo | float | 8 | True |
Invoices3Mo | int | 4 | True |
TimesLate3Mo | int | 4 | True |
AvgDaysLate3Mo | int | 4 | True |
AvgOver60Balance3Mo | float | 8 | True |
AvgDueDTP6Mo | float | 8 | True |
AvgBilledDTP6Mo | float | 8 | True |
MaxAR6Mo | float | 8 | True |
MinAR6Mo | float | 8 | True |
Invoices6Mo | int | 4 | True |
TimesLate6Mo | int | 4 | True |
AvgDaysLate6Mo | int | 4 | True |
AvgOver60Balance6Mo | float | 8 | True |
AvgDueDTP12Mo | float | 8 | True |
AvgBilledDTP12Mo | float | 8 | True |
MaxAR12Mo | float | 8 | True |
MinAR12Mo | float | 8 | True |
Invoices12Mo | int | 4 | True |
TimesLate12Mo | int | 4 | True |
AvgDaysLate12Mo | nchar(10) | 20 | True |
AvgOver60Balance12Mo | float | 8 | True |
AvgDueDTPLife | float | 8 | True |
AvgBilledDTPLife | float | 8 | True |
MaxARLife | float | 8 | True |
MinARLife | float | 8 | True |
InvoicesLife | int | 4 | True |
TimesLateLife | int | 4 | True |
AvgDaysLateLife | int | 4 | True |
LifeDays | int | 4 | True |
LastUpdate | datetime | 8 | True |
AvgOver60BalanceLife | float | 8 | True |
PctOver60 | decimal(18,2) | 9 | True |