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