<taUpdateCreateItemRcd>*
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.