Tables [dbo].[ARSaleRepBillCodeOutcost]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:57:00 AM Thursday, March 21, 2019
Last Modified1:01:47 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
SRBillCodeIDint4
False
1 - 1
BillCodeIDint4
False
BillCodevarchar(32)32
True
LaborRateOutcostmoney8
True
OvertimeRateOutcostmoney8
True
MinHoursOutcostfloat8
True
TravelBaseOutcostmoney8
True
TravelRateOutcostmoney8
True
MileageRateOutcostmoney8
True
ReportPeriodint4
True
PeriodLockedbit1
True
((0))
CREATE TABLE [dbo].[ARSaleRepBillCodeOutcost]
(
[SRBillCodeID] [int] NOT NULL IDENTITY(1, 1),
[BillCodeID] [int] NOT NULL,
[BillCode] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LaborRateOutcost] [money] NULL,
[OvertimeRateOutcost] [money] NULL,
[MinHoursOutcost] [float] NULL,
[TravelBaseOutcost] [money] NULL,
[TravelRateOutcost] [money] NULL,
[MileageRateOutcost] [money] NULL,
[ReportPeriod] [int] NULL,
[PeriodLocked] [bit] NULL CONSTRAINT [DF_ARSaleRepBillCodeOutcost_PeriodLocked] DEFAULT ((0))
) ON [PRIMARY]
GO