ASSETID

string

15

Y

Not applicable

Asset ID

ASSETIDSUF

i4

2

N

1

Asset suffix ID

BOOKID

string

15

Y

Not applicable

Book ID

PLINSERVDATE

datetime

16

N

<blank>

Place In service date

DATEADDED

datetime

16

N

<blank>

Date added

DEPRTODATE

datetime

16

N

<blank>

Depreciate to date

COSTBASIS

number

21

N

<blank>

Cost basis

SALVAGEVALUE

number

21

N

<blank>

Salvage value

YTDDEPRAMT

number

21

Y

Not applicable

YTD depreciation

LTDDEPRAMT

number

21

Y

Not applicable

LTD depreciation

DEPRECIATIONMETHOD

i4

2

N

<blank>

Depreciation method:

1=Straight-line orig. life;

2=Straight-line rem. life;

3=125%DB;

4=150% DB;

5=175% DB;

6=200% DB;

7=SOY digits;

8=Remaining life;

9=Amortization;

10=ACRS personal;

11=ACRS real;

12=ACRS real MSL;

13=ACRS LIH;

14=ACRS foreign real;

15=No depreciation;

16=Declining balance

AVERAGINGCONV

i4

2

N

<blank>

Averaging convention:

1=Half-year;

2=Modified half-year;

3=Mid-month (1st);

4=Mid-month (15th);

5=Mid-quarter;

6=Next month;

7=Full month;

8=Next year;

9=Full year;

10=Full year all year;

11=None;

12=Next period;

13=Full period

SWITCHOVER

i4

2

N

<blank>

Switch over:

1=No switch;

2=Straight-line

ORIGINALLIFEYEARS

i4

2

N

<blank>

Original life years

ORIGINALLIFEDAYS

i4

2

N

<blank>

Original life days

AMORTIZATIONCODE

i4

2

N

<blank>

Amortization code:

0=None;

1=Daily;

2=Weekly;

3=Monthly;

4=Quarterly;

5=Yearly;

6=Percentage;

7=Rate

AMORTIZATIONAMOUNT

number

21

N

<blank>

Amortization amount/percentage

Initial_Allowance_Perc

number

21

N

<blank>

Initial allowance percentage

SPECDEPRALLOW

i4

2

N

<blank>

Special depreciation allowance:

1=False;

2=True

SPECDEPRALLOWPCT

number

21

N

<blank>

Special depreciation allowance percentage

LUXAUTOIND

i4

2

N

<blank>

Luxury auto:

1=False;

2=True

LUXVANTRUCK

i4

1

N

<blank>

Luxury van or truck:

0=False;

1=True

LUXELAUTO

i4

1

N

<blank>

Luxury electric auto:

0=False;

1=True

USERID

string

15

N

<blank>

ID of user who entered

UpdateIfExists

i4

1

N

0

Flag to allow data to be updated if it exists:

0=No;

1=Yes

Do not use 1. taCreateAssetBook does not currently support updates. Update functionality will be added in a future release.

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