<taSopLineIvcInsertComponent>*

Element name

Data type

Length

Required

Default

Description

SOPTYPE

i4

2

Y

Not applicable

1=Quote;

2=Order;

3=Invoice;

4=Return;

5=Back order;

6=Fulfillment order

SOPNUMBE

string

21

Y

Not applicable

SOP number

USERDATE

datetime

8 bytes

(19 to 23 chars)

N

System date

User Date:

Used to determine if a lot is expired., defaults to system date

LOCNCODE

string

10

N

<blank>

Location code; default is from IV setup if not passed in

LNITMSEQ

i4

4

Y

Not applicable

Line sequence; must match kit item line sequence

ITEMNMBR

string

30

Y

Not applicable

Component item number

AutoAssignBin

i4

2

N

1

Autoassign bin; either the SOFULFILLMENT bin or the SORETURN bin will be used (item site combination or site default)

ITEMDESC

string

100

N

<blank>

Item description

QUANTITY

number

21

Y

Not applicable

Quantity to invoice when SOPTYPE=1,2, and 5; billed quantity for SOPTYPE=3

QTYTBAOR

number

21

N

0

Quantity to back order

QTYCANCE

number

21

N

0

Quantity canceled

QTYFULFI

number

21

N

Default from setup

Quantity fulfilled--if set to a value other than null, that quantity will be used

QUOTEQTYTOINV

number

21

N

0

Quote quantity to invoice; added to QUANTITY and QTYCANCE for total amount

QTYONHND

number

21

N

0

Quantity on hand; used for SOPTYPE=4

QTYRTRND

number

21

N

0

Quantity returned; used for SOPTYPE=4

QTYINUSE

number

21

N

0

Quantity in use; used for SOPTYPE=4

QTYINSVC

number

21

N

0

Quantity in service; used for SOPTYPE=4

QTYDMGED

number

21

N

0

Quantity damaged; used for SOPTYPE=4

CUSTNMBR

string

15

Y

Not applicable

Customer number

DOCID

string

15

N

<blank>

Document ID; should be same as DOCID passed to the <taSopLineIvcInsert> node for Kit

UNITCOST

number

21

N

Default from setup

Unit cost

Used with non-inventory items or return type documents.

If null, the default is pulled for inventory or 0 for non-inventory.

A kit item return does not use the specified unit cost value, the value defaults to the current cost or standard cost of the item.

NONINVEN

i4

2

N

0

0=Inventoried component item;

1=Non-inventoried component item

AUTOALLOCATESERIAL

i4

4

N

0

Autofulfill serial numbers on the fly;

0=Auto;

1=Manual;

2=Mixed

AUTOALLOCATELOT

i4

4

N

0

Auto-fulfill lot numbers on the fly;

0=Auto;

1=Manual; 2=Mixed

CMPNTSEQ

i4

4

N

0

Component sequence; required if UpdateIfExists=1; uses the default if not passed in and not required

CMPITUOM

string

9

N

<blank>

Component unit of measure; uses the default if not passed in

CURNCYID

string

15

N

<blank>

Currency ID

UpdateIfExists

i4

2

N

0

Used to add or modify existing components:

0=Add;

1=Modify

RecreateDist

i4

2

N

0

Used only is UpdateIfExists=1; determines if distributions auto recreate

RequestrTrx

i4

2

N

0

Requester transaction:

0=False;

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

QtyShrtOpt

i4

2

N

2

Quantity shortage option:

1=Sell balance;

2=Override shortage;

3=BO all;

4=BO balance;

5=Cancel all;

6=Cancel balance

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

* The default action for the <taSopLineIvcInsertComponent> node is to use document exchange to provide update functionality. To use field level updates, set UpdateIfExists to 1.