<taSopLineIvcInsert>*

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

Invoice number

CUSTNMBR

string

15

Y

Not applicable

Customer number

DOCDATE

datetime

8 bytes

(19 to 23 chars)

Y

Not applicable

Invoice date

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

ITEMNMBR

string

30

Y

Not applicable

Item number

If you have a document with more than one taSopLineIvcInsert node, use the values in the ITEMNMBR element to specify the sequence where each node appears in the document.

AutoAssignBin

i4

2

N

1

Auto assign bin will use either the SOFULFILLMENT or SORETURN bin

UNITPRCE

number

21

N

0

Unit price for item

XTNDPRCE

number

21

N

0

Extended price for line item

QUANTITY

number

21

Y

Not applicable

Quote=Quantity to order;

Order and Bkorder=Quantity to invoice;

Invoice=Billed quantity;

Return=Total quantity

MRKDNAMT

number

21

N

Default from setup

Markdown amount

MRKDNPCT

number

21

N

Default from setup

Markdown percent; if MRKDNPCT is utilized, in <taSopHdrIvcInsert> the element DEFPRICING must be set to 1 or error 67 will occur.

COMMNTID

string

15

N

<blank>

Comment ID

COMMENT_1

string

50

N

<blank>

Comment 1

COMMENT_2

string

50

N

<blank>

Comment 2

COMMENT_3

string

50

N

<blank>

Comment 3

COMMENT_4

string

50

N

<blank>

Comment 4

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.

PRCLEVEL

string

10

N

<blank>

Price level

ITEMDESC

string

100

N

<blank>

Item description

TAXAMNT

number

21

N

0

Tax amount on line item without freight and miscellaneous tax

QTYONHND

number

21

N

0

Return quantity type: On hand

QTYRTRND

number

21

N

0

Return quantity type: Returned

QTYINUSE

number

21

N

0

Return quantity type: In use

QTYINSVC

number

21

N

0

Return quantity type: In service

QTYDMGED

number

21

N

0

Return quantity type: Damaged

NONINVEN

i4

2

N

0

Non-inventory:

0=No;

1=Yes

LNITMSEQ

i4

4

N

0

Line item sequence number; by default, the line item sequence number will be autoincremented by 16,384 for each SOP line if it is not passed in; if the value needs to be passed in, we recommend passing in a value of 16,384 for the first line and increment the value by 16,384 for each subsequent line (that is, pass in a value of 16,384 for the first SOP line and then 32,768 for the second SOP line)

DROPSHIP

i4

2

N

0

Drop ship flag 1=Drop ship

QTYTBAOR

number

21

N

0

Quantity to back order

DOCID

string

15

N

<blank>

Document ID; if left blank, line will autoallocate and fulfill

SALSTERR

string

15

N

Default from setup

Sales territory

SLPRSNID

string

15

N

Default from setup

Salesperson ID

ITMTSHID

string

15

N

Default from setup

Item tax schedule ID; if user wants to pass in a blank schedule ID, '' (tick tick) must be passed in for ITMTSHID

IVITMTXB

i4

2

N

0

IV item taxable; user can change item tax option per line:

0=Default;

1=Tax;

2=Nontax;

3=Based on customer

TAXSCHID

string

15

N

Default from setup

Delivery method tax schedule ID; can be used to override the default delivery method tax schedule; if user wants to pass in a blank schedule ID, '' (tick tick) must be passed in for TAXSCHID

PRSTADCD

string

15

N

Default from setup

Primary ship to address code

ShipToName

string

64

N

<blank>

Ship to name:

The default gets the ship to name from the customer ship to address.

CNTCPRSN

string

60

N

<blank>

Contact person

ADDRESS1

string

60

N

<blank>

Customer address one per ship to line item

ADDRESS2

string

60

N

<blank>

Customer address two per ship to line item

ADDRESS3

string

60

N

<blank>

Customer address three per ship to line item

CITY

string

35

N

<blank>

City per ship to line item

STATE

string

29

N

<blank>

State per ship to line item

ZIPCODE

string

10

N

<blank>

ZIP Code per ship to line item

COUNTRY

string

60

N

<blank>

Country per ship to line item

PHONE1

string

21

N

<blank>

Phone 1 per ship to line item

PHONE2

string

21

N

<blank>

Phone 2 per ship to line item

PHONE3

string

21

N

<blank>

Phone 3 per ship to line item

FAXNUMBR

string

21

N

<blank>

Fax per ship to line item

Print_Phone_NumberGB

i4

2

N

Default from setup

Print phone number:

0=Do not print;

1=Phone 1;

2=Phone 2;

3=Phone 3;

4=Fax

EXCEPTIONALDEMAND

i4

1

N

0

Resource planning

ReqShipDate

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Requested ship date

FUFILDAT

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Fulfill date

ACTLSHIP

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Actual ship date

SHIPMTHD

string

15

N

Default from setup

Shipping method

INVINDX

string

75

N

<blank>

Inventory account number string

CSLSINDX

string

75

N

<blank>

Cost of goods sold account number string

SLSINDX

string

75

N

<blank>

Sales account number string

MKDNINDX

string

75

N

<blank>

Markdowns account number string

RTNSINDX

string

75

N

<blank>

Returns account number string

INUSINDX

string

75

N

<blank>

In use account number string

INSRINDX

string

75

N

<blank>

In service account number string

DMGDINDX

string

75

N

<blank>

Damaged account number string

AUTOALLOCATESERIAL

i4

4

N

0

Autoallocate serial numbers on the fly: 0=Auto; 1=Manual; 2=Mixed

AUTOALLOCATELOT

i4

4

N

0

Autoallocate lot numbers on the fly:

0=Auto;

1=Manual;

2=Mixed

GPSFOINTEGRATIONID

string

30

N

<blank>

Front office integration ID

INTEGRATIONSOURCE

i4

2

N

0

Integration source

INTEGRATIONID

string

30

N

<blank>

Integration ID

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

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

QTYCANCE

number

21

N

0

Quantity canceled; will subtract from the QUANTITY passed in

QTYFULFI

number

21

N

Default from setup

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

ALLOCATE

i4

2

N

0

Allocates quantities; 0=Use DOCID default; 1=Allocate quantities

UpdateIfExists

i4

2

N

0

Used to add or modify existing documents; 1=Add/modify--entire line will need to be resent

RecreateDist

i4

2

N

0

Used only if UpdateIfExists=1;

0=Do not re-create distributions;

1=Re-create distributions

QUOTEQTYTOINV

number

21

N

0

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

TOTALQTY

number

21

N

0

Total line quantity; used if total line quantity exceeds individual quantity amounts being sent in

CMMTTEXT

string

500

N

<blank>

Comment text; used only if COMMENT_1 through COMMENT_4 are not being used

KitCompMan

i4

2

N

0

Manually passing kit components:

0=False;

1=True (if 1, LNITMSEQ is required)

DEFPRICING

i4

4

N

0

1=Unit price and extended price will use default

DEFEXTPRICE

i4

4

N

0

Extended price will use the default based on the unit price and quantity passed in

CURNCYID

string

15

N

<blank>

Currency ID

UOFM

string

8

N

<blank>

Unit of measure

IncludePromo

i4

2

N

0

Include extended pricing promotion, including free items

CKCreditLimit

i4

1

N

0

Check credit limit at line level:

0=Do not check credit limit;

1=Check limit (users still have the ability to check credit limit at the header level)

QtyShrtOpt

i4

2

N

2

Quantity shortage option:

1=Sell balance;

2=Override shortage;

3=Back Order all;

4=Back Order balance;

5=Cancel all;

6=Cancel balance

More information available in SOP Transaction General Information.

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 <taSopLineIvcInsert> node is to use document exchange to provide update functionality. To use field level updates, set UpdateIfExists to 1.