Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 12:58:50 AM Thursday, March 21, 2019 |
Last Modified | 1:05:46 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls | Identity | Default |
---|---|---|---|---|---|
RowID | int | 4 | False | 1 - 1 | |
ReportLeaseID | int | 4 | False | ||
TransactionDetailID | int | 4 | True | ||
AccountID | int | 4 | False | ||
DeptID | int | 4 | True | ||
ItemID | int | 4 | True | ||
ModelID | int | 4 | True | ||
ParentModelID | int | 4 | True | ||
EquipmentID | int | 4 | True | ||
MeterID | int | 4 | True | ||
OrigAmount | money | 8 | False | ||
Amount | money | 8 | False | ||
MonthlyAmount | money | 8 | False | ((0)) | |
TransactionTypeID | int | 4 | False | ||
Reference | varchar(512) | 512 | True | ||
SubReference | varchar(64) | 64 | True | ||
Date | datetime | 8 | False | ||
Period | int | 4 | False | ||
BranchID | int | 4 | True | ||
Description | varchar(255) | 255 | True | ||
ContractID | int | 4 | True | ||
CustomerID | int | 4 | True | ||
BillToID | int | 4 | True | ||
SegmentID | int | 4 | True | ||
CategoryID | int | 4 | True | ||
Category | varchar(64) | 64 | True | ||
PresAccountID | varchar(64) | 64 | True | ||
Percentage | decimal(16,4) | 9 | True | ||
Multiplier | int | 4 | False | ((1)) | |
CountedCopies | int | 4 | True | ||
OrigMeterCovCopies | int | 4 | True | ||
CoveredCopies | int | 4 | True | ||
MonthlyCovCopies | int | 4 | True | ||
BillableCopies | int | 4 | True | ||
MonthlyBillableCopies | int | 4 | True | ||
FromDate | datetime | 8 | True | ||
ToDate | datetime | 8 | True | ||
NoMonths | int | 4 | True | ||
TypeID | int | 4 | True |