Tables [dbo].[ARInvUniDetBillingDeptAllocationExtended]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:56:50 AM Thursday, March 21, 2019
Last Modified12:56:50 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
IDint4
False
InvoiceIDint4
False
SalesRepIDint4
True
ItemTypevarchar(37)37
False
Amountmoney8
True
Costmoney8
True
GPmoney8
True
Descriptionvarchar(1068)1068
True
BSABillForServicesint4
False
Billint4
False
BillingDeptIDint4
True
BillingDeptDistributionnumeric(21,6)13
True
CREATE TABLE [dbo].[ARInvUniDetBillingDeptAllocationExtended]
(
[ID] [int] NOT NULL,
[InvoiceID] [int] NOT NULL,
[SalesRepID] [int] NULL,
[ItemType] [varchar] (37) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Amount] [money] NULL,
[Cost] [money] NULL,
[GP] [money] NULL,
[Description] [varchar] (1068) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSABillForServices] [int] NOT NULL,
[Bill] [int] NOT NULL,
[BillingDeptID] [int] NULL,
[BillingDeptDistribution] [numeric] (21, 6) NULL
) ON [PRIMARY]
GO