<taUpdateCreateItemRcd>*

  • Article

Element name

Data type

Length

Required

Default

Description

ITEMNMBR

string

30

Y

Not applicable

Item number

ITEMDESC

string

100

N

Default from setup

Item description

ITMSHNAM

string

15

N

Default from setup

Short description

ITMGEDSC

string

10

N

Default from setup

Generic description

ITMCLSCD

string

10

N

Default from setup

Class ID

ITEMTYPE

i4

2

N

Default from setup

Item type

1=Sales inventory;

2=Discontinued;

3=Kit;

4=Miscellaneous charges;

5=Services;

6=Flat fee

Default is one on new record

VCTNMTHD

i4

2

N

Default from setup

Valuation method:

0=Any ITEMTYPE other than 1 or 2;

1=FIFO perpetual;

2=LIFO perpetual;

3=Average perpetual;

4=FIFO periodic;

5=LIFO periodic

Default is one on new record

TAXOPTNS

i4

2

N

Default from setup

Sales tax options:

1=Taxable;

2=Nontaxable;

3=Base on customers

Default is one on new record

ITMTSHID

string

15

N

Default from setup

Tax schedule ID

UOMSCHDL

string

10

N

Default from setup

Unit of measure schedule ID

Required for a new record, but can roll down from class

ITEMSHWT

number

 

N

Default from setup

Shipping weight; only used when ITEMTYPE=1, 2, or 3

TCC

string

30

N

Default from setup

Tax community code; only used if the "Enable Intrastat Tracking" option is enabled in Company Setup

CNTRYORGN

string

6

N

Default from setup

Country origin; only used if the "Enable Intrastat Tracking" option is enabled in Company Setup

DECPLQTY

i4

2

N

Default from setup

Quantity Decimals; DECPLQTY can equal 0, 1, 2, 3, 4, or 5; if ITEMTYPE=3, then DECPLQTY must be set to zero

Default is zero on new record

DECPLCUR

i4

2

N

Default from setup

Currency Decimals; used for item if not registered for multi-currency or used for functional currency

If registered for multi-currency and want other currencies, use the <taUpdateCreateItemCurrencyRcd> node.

Purchase_Tax_Options

i4

2

N

Default from setup

Purchasing tax option:

1=Taxable;

2=Nontaxable;

3=Base on vendors

Default is one on new record

Purchase_Item_Tax_Schedu

string

15

N

Default from setup

Purchase tax schedule ID

STNDCOST

number

21

N

Default from setup

Standard cost

CURRCOST

number

21

N

Default from setup

Current cost

LISTPRCE

number

21

N

Default from setup

List price; used if multi-currency is not registered or used for functional currency if multi-currency is registered

NOTETEXT

string

8000

N

Default from setup

Note text

ALTITEM1

string

30

N

Default from setup

Alternate item 1

ALTITEM2

string

30

N

Default from setup

Alternate item 2

ITMTRKOP

i4

2

N

Default from setup

Item tracking:

1=None;

2=Serial Numbers;

3=Lot Numbers

Used when ITEMTYPE= 1 or 2

Default is one on new record

LOTTYPE

string

10

N

Default from setup

Lot category

LOTEXPWARN

i4

1

N

0

Lot Expiration Warn:

0 = no warning

1 = warnings enabled

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

LOTEXPWARNDAYS

i4

2

N

0

Days Before Lot Expires:

Valid entries equal 0 - 999.

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

INCLUDEINDP

i4

1

N

Default from setup

Include in Demand Planning;

0=Do Not Include;

1=Include

Default is zero on new record

MINSHELF1

i4

2

N

Default from setup

Minimum shelf life 1:

Valid entries equal 0-9999

Use when ITMTRKOP=3

Default is zero on new record

MINSHELF2

i4

2

N

Default from setup

Minimum shelf life 2:

Valid entries equal 0-9999

Use when ITMTRKOP=3

Default is zero on new record

ALWBKORD

i4

1

N

Default from setup

Allow back orders:

0=Do not allow back orders;

1=Allow back orders

Default is zero on new record

WRNTYDYS

i4

2

N

Default from setup

Warranty days; valid entries equal 0-9999

Default is zero on new record

ABCCODE

i4

2

N

Default from setup

ABC code:

1=None;

2=A;

3=B;

4=C

Default is one on new record

USCATVLS_1

string

10

N

Default from setup

User category 1

USCATVLS_2

string

10

N

Default from setup

User category 2

USCATVLS_3

string

10

N

Default from setup

User category 3

USCATVLS_4

string

10

N

Default from setup

User category 4

USCATVLS_5

string

10

N

Default from setup

User category 5

USCATVLS_6

string

10

N

Default from setup

User category 6

KPCALHST

i4

1

N

Default from setup

Maintain history--calendar year:

0=Do not keep history;

1=Keep history

Default is 0 on new record

KPERHIST

i4

1

N

Default from setup

Maintain history--fiscal year:

0=Do not keep history;

1=Keep history

Default is 0 on new record

KPTRXHST

i4

1

N

Default from setup

Maintain history--transaction:

0=Do not keep history;

1=Keep history

Default is 0 on new record

KPDSTHST

i4

1

N

Default from setup

Maintain history--distribution:

0=Do not keep history;

1=Keep history

Default is 0 on new record

IVIVACTNUMST

string

75

N

Default from setup

Inventory account

IVIVOFACTNUMST

string

75

N

Default from setup

Inventory offset account

IVCOGSACTNUMST

string

75

N

Default from setup

Cost of goods sold account

IVSLSACTNUMST

string

75

N

Default from setup

Sales account

IVSLDSACTNUMST

string

75

N

Default from setup

Markdown account

IVSLRNACTNUMST

string

75

N

Default from setup

Sales return account

IVINUSACTNUMST

string

75

N

Default from setup

In use account

IVINSVACTNUMST

string

75

N

Default from setup

In service account

IVDMGACTNUMST

string

75

N

Default from setup

Damaged account

IVVARACTNUMST

string

75

N

Default from setup

Variance account

DPSHPACTNUMST

string

75

N

Default from setup

Drop-ship items account

PURPVACTNUMST

string

75

N

Default from setup

Purchase price variance account

UPPVACTNUMST

string

75

N

Default from setup

Unrealized purchase price variance account

IVRETACTNUMST

string

75

N

Default from setup

Inventory returns account

ASMVRACTNUMST

string

75

N

Default from setup

Assembly variance account

KTACCTSR

i4

2

N

Default from setup

Cost of goods sold account source:

0=From component item;

1=From kit item

Default is zero on new record

PRCHSUOM

string

8

N

Default from setup

Purchasing unit of measure

Revalue_Inventory

i4

1

N

Default from setup

Revalue inventory for cost variance:

0=Do not revalue;

1=Revalue

Default is zero on new record

Tolerance_Percentage

number

21

N

Default from setup

Tolerance percentage

LOCNCODE

string

10

N

Default from setup

Location code; assigns site to item if it is not already assigned

PRICMTHD

i4

2

N

Default from setup

Price method:

1=Currency amount;

2=Percent of List price;

3=Percent of markup of current cost;

4=Percent markup of standard cost;

5=Percent margin of current cost;

6=Percent margin of standard cost

Default is one

PriceGroup

string

10

N

Default from setup

Price group

UseQtyOverageTolerance

i4

1

N

Default from setup

Use quantity overage tolerance:

0=Do not use;

1=Use

UseQtyShortageTolerance

i4

1

N

Default from setup

Use quantity shortage tolerance:

0=Do not use;

1=Use

QtyOverTolerancePercent

i4

4

N

Default from setup

Quantity over tolerance percent:

Provide a value of 0 - 99999. For example, 99999 equals 99.999.

QtyShortTolerancePercent

i4

4

N

Default from setup

Quantity short tolerance percent:

Provide a value of 0 - 99999. For example, 99999 equals 99.999.

UseItemClass

i4

1

N

0

Flag to have class setting roll down to elements that are not passed in; uses the ITMCLSCD class

UpdateIfExists

i4

1

N

1

Flag to allow item data to be updated if it exists: 0=Do not update;

1=Update if exists;

2=Create if record does not exist and exits without error if record does exist

RequesterTrx

i4

2

N

0

Requester transaction

0=False;

1=True (if True, it populates the requester shadow table)

USRDEFND1

string

50

N

Default from setup

User-defined field--developer use only

USRDEFND2

string

50

N

Default from setup

User-defined field--developer use only

USRDEFND3

string

50

N

Default from setup

User-defined field--developer use only

USRDEFND4

string

8000

N

Default from setup

User-defined field--developer use only

USRDEFND5

string

8000

N

Default from setup

User-defined field--developer use only

* The <taUpdateCreateItemRcd> node uses field level updates to provide update functionality.