ITMCLSCD

string

10

Y

Not applicable

Item class ID

ITMCLSDC

string

30

Y

Not applicable

Item class description

DEFLTCLS

i4

1

N

0

Default class:

0=False;

1=True

ITEMTYPE

i4

2

N

1

Item type:

1=Sales inventory;

2=Discontinued;

3=Kit;

4=Miscellaneous charges;

5=Services;

6=Flat fee

ITMTRKOP

i4

2

N

1

Item tracking option:

1=None;

2=Serial numbers;

3=Lots

LOTTYPE

string

10

N

<blank>

Lot category

LOTEXPWARN

i4

1

N

0

Lot Expiration Warn:

0 = no warning

1 = warnings enabled

If the item is not lot number tracked, the value of this element is not used.

LOTEXPWARN
DAYS

i4

2

N

0

Days Before Lot Expires:

Valid entries equal 0 - 999.

If LOTEXPWARN is 0 then LOTEXPWARNDAYS always defaults to 0. If the item is not lot number tracked, the value of this element is not used.

KPERHIST

i4

1

N

0

Keep period history:

0=False;

1=True

KPTRXHST

i4

1

N

0

Keep transaction history:

0=False; 1=True

KPCALHST

i4

1

N

0

Keep calendar history:

0=False;

1=True

KPDSTHST

i4

1

N

0

Keep distribution history:

0=False;

1=True

ALWBKORD

i4

1

N

0

Allow back orders:

0=False;

1=True

ITMGEDSC

string

10

N

<blank>

Item generic description

TAXOPTNS

i4

2

N

2

Sales tax options:

1=Taxable;

2=Nontaxable

ITMTSHID

string

15

N

<blank>

Sales tax schedule ID

Purchase_Tax_Options

i4

2

N

2

Purchase tax options:

1=Taxable;

2=Nontaxable;

3=Base on vendor

Purchase_Item_Tax_Schedu

string

15

N

<blank>

Purchase tax schedule ID

UOMSCHDL

string

11

N

<blank>

Unit of measure schedule ID

VCTNMTHD

i4

2

N

1

Valuation method:

1=FIFO perpetual;

2=LIFO perpetual;

3=Average perpetual;

4=FIFO periodic;

5=LIFO periodic

USCATVLS_1

string

10

N

<blank>

User defined 1

USCATVLS_2

string

10

N

<blank>

User defined 2

USCATVLS_3

string

10

N

<blank>

User defined 3

USCATVLS_4

string

10

N

<blank>

User defined 4

USCATVLS_5

string

10

N

<blank>

User defined 5

USCATVLS_6

string

10

N

<blank>

User defined 6

DECPLQTY

i4

2

N

1

Decimal places quantity:

1=0;

2=1;

3=2;

4=3;

5=4;

6=5

Inventory_Acct

string

75

N

<blank>

Inventory account

Inventory_Offset_Acct

string

75

N

<blank>

Inventory offset account

Cost_of_Goods_Sold_Acct

string

75

N

<blank>

Cost of goods sold account

Sales_Acct

string

75

N

<blank>

Sales account

Markdowns_Acct

string

75

N

<blank>

Markdowns account

Sales_Returns_Acct

string

75

N

<blank>

Sales returns account

In_Use_Acct

string

75

N

<blank>

In use account

In_Service_Acct

string

75

N

<blank>

In service account

Damaged_Acct

string

75

N

<blank>

Damaged account

Variance_Acct

string

75

N

<blank>

Variance account

Drop_Ship_Items_Acct

string

75

N

<blank>

Drop ship items account

Purchase_Price_Variance_Acct

string

75

N

<blank>

Purchase price variance account

Unrealized_Purchase_Price_Variance_Acct

string

75

N

<blank>

Unrealized purchase price variance account

Inventory_Returns_Acct

string

75

N

<blank>

Inventory returns account

Assembly_Variance_Acct

string

75

N

<blank>

Assembly variance account

PRCLEVEL

string

10

N

<blank>

Price level

PriceGroup

string

10

N

<blank>

Price group

PRICMTHD

i4

2

N

1

Price method:

1=Currency amount;

2=Percentage of list price;

3=Percentage mark-up of current cost;

4=Percentage mark-up of standard cost;

5=Percentage margin of current cost;

6=Percentage margin of standard cost

Revalue_Inventory

i4

1

N

1

Revalue inventory:

0=False;

1=True

Tolerance_Percentage

i4

4

N

0

Tolerance percentage

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