ASSETID

string

15

Y

Not applicable

Asset ID

ASSETIDSUF

i4

2

N

1

Asset suffix ID

SHRTNAME

string

15

N

Default from setup

Short name

ASSETDESC

string

40

Y

Not applicable

Asset description

EXTASSETDESC

string

40

N

Default from setup

Extended description

Master_Asset_ID

string

19

N

Default from setup

Master asset ID

STRUCTUREID

string

30

N

Default from setup

Structure ID

ASSETCLASSID

string

15

Y

Not applicable

Asset class ID

LOCATNID

string

15

N

Default from setup

Location ID

ACQDATE

datetime

16

Y

Not applicable

Acquisition date

Acquisition_Cost

number

21

N

Default from setup

Acquisition cost

ASSETTYPE

i4

2

N

Default from setup

Asset type:

1=New;

2=Used;

3=Leased

ASSETSTATUS

i4

2

N

Default from setup

Asset status:

1=Active;

2=Deleted;

3=Partial open;

4=Retired

PROPTYPE

i4

2

N

Default from setup

Property type:

1=Personal;

2=Personal, listed;

3=Real;

4=Real, listed;

5=Real, conservation;

6=Real, energy;

7=Real, farms;

8=Real, low-income housing;

9=Amortization

ASSETQTY

i4

4

N

Default from setup

Quantity

ASSETBEGQTY

i4

4

N

Default from setup

Beginning quantity

ASSETCURRMAINT

number

21

N

Default from setup

Current year maintenance

ASSETYTDMAINT

number

21

N

Default from setup

YTD maintenance

ASSETLTDMAINT

number

21

N

Default from setup

LTD maintenance

LASTMAINTDATE

datetime

16

N

Default from setup

Last maintenance date

ASSESSEDVALUE

number

21

N

Default from setup

Assessed value

MFGRNAME

string

25

N

Default from setup

Manufacturers name

SERLNMBR

string

20

N

Default from setup

Serial number

MODELNUMBER

string

20

N

Default from setup

Model number

WARRENTYDATE

datetime

16

N

Default from setup

Warranty date

CUSTODIAN

string

25

N

Default from setup

Custodian

DATEADDED

datetime

16

N

Default from setup

Date added

DELETEDATE

datetime

16

N

Default from setup

Date deleted

Physical_Location_ID

string

15

N

Default from setup

Physical location ID

Asset_Label

string

19

N

Default from setup

Asset label

Verified_Date

datetime

16

N

Default from setup

Verified date

PIN

string

15

N

Default from setup

PIN

UpdateIfExists

i4

1

N

1

Flag to allow data to be updated, if it exists:

0=No;

1=Yes

USRDEFND1

string

50

N

<blank>

User-defined field—developer use only

USRDEFND2

string

50

N

<blank>

User-defined field—developer use only

USRDEFND3

string

50

N

<blank>

User-defined field—developer use only

USRDEFND4

string

8000

N

<blank>

User-defined field—developer use only

USRDEFND5

string

8000

N

<blank>

User-defined field—developer use only