Tables [dbo].[SOSARCustomersEX]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:52 AM Thursday, March 21, 2019
Last Modified1:00:52 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
CustomerIDint4
False
AvgDueDTP3Mofloat8
True
AvgBilledDTP3Mofloat8
True
MaxAR3Mofloat8
True
MinAR3Mofloat8
True
Invoices3Moint4
True
TimesLate3Moint4
True
AvgDaysLate3Moint4
True
AvgOver60Balance3Mofloat8
True
AvgDueDTP6Mofloat8
True
AvgBilledDTP6Mofloat8
True
MaxAR6Mofloat8
True
MinAR6Mofloat8
True
Invoices6Moint4
True
TimesLate6Moint4
True
AvgDaysLate6Moint4
True
AvgOver60Balance6Mofloat8
True
AvgDueDTP12Mofloat8
True
AvgBilledDTP12Mofloat8
True
MaxAR12Mofloat8
True
MinAR12Mofloat8
True
Invoices12Moint4
True
TimesLate12Moint4
True
AvgDaysLate12Monchar(10)20
True
AvgOver60Balance12Mofloat8
True
AvgDueDTPLifefloat8
True
AvgBilledDTPLifefloat8
True
MaxARLifefloat8
True
MinARLifefloat8
True
InvoicesLifeint4
True
TimesLateLifeint4
True
AvgDaysLateLifeint4
True
LifeDaysint4
True
LastUpdatedatetime8
True
AvgOver60BalanceLifefloat8
True
PctOver60decimal(18,2)9
True
CREATE TABLE [dbo].[SOSARCustomersEX]
(
[CustomerID] [int] NOT NULL,
[AvgDueDTP3Mo] [float] NULL,
[AvgBilledDTP3Mo] [float] NULL,
[MaxAR3Mo] [float] NULL,
[MinAR3Mo] [float] NULL,
[Invoices3Mo] [int] NULL,
[TimesLate3Mo] [int] NULL,
[AvgDaysLate3Mo] [int] NULL,
[AvgOver60Balance3Mo] [float] NULL,
[AvgDueDTP6Mo] [float] NULL,
[AvgBilledDTP6Mo] [float] NULL,
[MaxAR6Mo] [float] NULL,
[MinAR6Mo] [float] NULL,
[Invoices6Mo] [int] NULL,
[TimesLate6Mo] [int] NULL,
[AvgDaysLate6Mo] [int] NULL,
[AvgOver60Balance6Mo] [float] NULL,
[AvgDueDTP12Mo] [float] NULL,
[AvgBilledDTP12Mo] [float] NULL,
[MaxAR12Mo] [float] NULL,
[MinAR12Mo] [float] NULL,
[Invoices12Mo] [int] NULL,
[TimesLate12Mo] [int] NULL,
[AvgDaysLate12Mo] [nchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AvgOver60Balance12Mo] [float] NULL,
[AvgDueDTPLife] [float] NULL,
[AvgBilledDTPLife] [float] NULL,
[MaxARLife] [float] NULL,
[MinARLife] [float] NULL,
[InvoicesLife] [int] NULL,
[TimesLateLife] [int] NULL,
[AvgDaysLateLife] [int] NULL,
[LifeDays] [int] NULL,
[LastUpdate] [datetime] NULL,
[AvgOver60BalanceLife] [float] NULL,
[PctOver60] [decimal] (18, 2) NULL
) ON [PRIMARY]
GO