| FIELD NAME |
TYPE |
LENGTH |
QRY |
MOD |
INS |
REQ INS |
VALIDATE |
REL |
| ListID |
Varchar |
36 |
True |
False |
False |
N/A |
String |
|
| TimeCreated |
Timestamp |
27 |
True |
False |
False |
N/A |
CCCC-MM-DDThh:mm:ssZ |
|
| TimeModified |
Timestamp |
27 |
True |
False |
False |
N/A |
CCCC-MM-DDThh:mm:ssZ |
|
| EditSequence |
Varchar |
16 |
True |
False |
False |
N/A |
String |
|
| Name |
Varchar |
31 |
True |
True |
True |
Yes |
String |
|
| IsActive |
Bit |
5 |
True |
True |
True |
No |
1 0 true false |
|
| AcquiredAs |
Varchar |
3 |
True |
True |
True |
Yes |
New Old |
|
| PurchaseDesc |
Varchar |
50 |
True |
True |
True |
Yes |
String |
|
| PurchaseDate |
Date |
10 |
True |
True |
True |
Yes |
CCCC-MM-DD |
|
| PurchaseCost |
Decimal |
14 |
True |
True |
True |
No |
8.5 |
|
| VendorOrPayeeName |
Varchar |
50 |
True |
True |
True |
No |
String |
|
| AssetAccountRefListID |
Varchar |
36 |
True |
False |
True |
Yes |
String |
|
| AssetAccountRefFullName |
Varchar |
159 |
True |
True |
True |
Yes |
String |
|
| FixedAssetSalesInfoSalesDesc |
Varchar |
50 |
True |
True |
True |
No |
String |
|
| FixedAssetSalesInfoSalesDate |
Date |
10 |
True |
True |
True |
No |
CCCC-MM-DD |
|
| FixedAssetSalesInfoSalesPrice |
Decimal |
14 |
True |
True |
True |
No |
8.5 |
|
| FixedAssetSalesInfoSalesExpense |
Decimal |
14 |
True |
True |
True |
No |
8.5 |
|
| AssetDesc |
Varchar |
50 |
True |
True |
True |
No |
String |
|
| Location |
Varchar |
50 |
True |
True |
True |
No |
String |
|
| PONumber |
Varchar |
30 |
True |
True |
True |
No |
String |
|
| SerialNumber |
Varchar |
30 |
True |
True |
True |
No |
String |
|
| WarrantyExpDate |
Date |
10 |
True |
True |
True |
No |
CCCC-MM-DD |
|
| Notes |
Varchar |
4096 |
True |
True |
True |
No |
String |
|
| AssetNumber |
Varchar |
10 |
True |
True |
True |
No |
String |
|
| CostBasis |
Decimal |
11 |
True |
True |
True |
No |
8.2 |
|
| YearEndAccumulatedDepreciation |
Decimal |
11 |
True |
True |
True |
No |
8.2 |
|
| YearEndBookValue |
Decimal |
11 |
True |
True |
True |
No |
8.2 |
|