Skip to main content

Software & Licences - Key Tables

Full column listings for the 1 key table in this category.

Licence (38 columns)

# Column Type Length Nullable Default
1 LID int NO
2 LType int NO ((0))
3 LDesc nvarchar 500 YES
4 LCount int NO ((0))
5 Larea int NO ((0))
6 LSite int NO ((0))
7 LPurchasePrice float NO ((0))
8 LPurchaseDate datetime NO ((0))
9 LSnowID nvarchar 500 YES
10 LVendor nvarchar 500 YES
11 LManufacturer nvarchar 500 YES
12 LNotes ntext 1073741823 YES
13 LVendorId int YES ((0))
14 LDueDate datetime YES ((0))
15 LTenantId nvarchar 100 YES ('')
16 LTenantName nvarchar 100 YES ('')
17 LDeleted bit YES ((0))
18 LAssignedAtDeletion int YES ((0))
19 LBillingCycle nvarchar 100 YES ('')
20 lautorenew bit YES
21 ltermduration nvarchar 100 YES
22 lstatus nvarchar 100 YES
23 LPrice float YES ((0))
24 LDistributor nvarchar 100 YES
25 LIsActive bit YES ((1))
26 LAzureConnectionId int YES ((0))
27 LRequestedQuantity int YES ((0))
28 LRequestedQuantityDate datetime YES ((0))
29 lproductsku nvarchar 1000 YES
30 lvendorproductsku nvarchar 1000 YES
31 lparentid int YES
32 lmonthlyprice float YES
33 lmonthlycost float YES
34 lthirdpartyproductid nvarchar 500 YES
35 lthirdpartyproductname nvarchar 500 YES
36 litemid int YES
37 lconsumedcount int YES
38 lelid int YES
Back to top