Tables [dbo].[SOSARCustomersAgingEX]
PropertyValue
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
Periodint4
False
ARCurrentmoney8
True
AR1to30money8
True
AR31to60money8
True
AR61to90money8
True
AROver90money8
True
TotalARmoney8
True
SalesTotalmoney8
True
SalesCountint4
True
ServiceTotalmoney8
True
ServiceInvCountint4
True
ContractInvTotalmoney8
True
ContractInvCountint4
True
AvgDSOfloat8
True
IsMostCurrentbit1
True
LastUpdatedatetime8
True
PctOver60decimal(18,2)9
True
CREATE TABLE [dbo].[SOSARCustomersAgingEX]
(
[Customerid] [int] NOT NULL,
[Period] [int] NOT NULL,
[ARCurrent] [money] NULL,
[AR1to30] [money] NULL,
[AR31to60] [money] NULL,
[AR61to90] [money] NULL,
[AROver90] [money] NULL,
[TotalAR] [money] NULL,
[SalesTotal] [money] NULL,
[SalesCount] [int] NULL,
[ServiceTotal] [money] NULL,
[ServiceInvCount] [int] NULL,
[ContractInvTotal] [money] NULL,
[ContractInvCount] [int] NULL,
[AvgDSO] [float] NULL,
[IsMostCurrent] [bit] NULL,
[LastUpdate] [datetime] NULL,
[PctOver60] [decimal] (18, 2) NULL
) ON [PRIMARY]
GO