Share via


<taSopLotAuto>*

Element name

Data type

Length

Required

Default

Description

SOPTYPE

i4

2

Y

Not applicable

2=Order;

3=Invoice;

4=Return;

5=Bkorder;

6=Fulfillment order

SOPNUMBE

string

21

Y

Not applicable

Document number

USERDATE

datetime

8 bytes

(19 to 23 chars)

N

System date

User Date:

Used to determine if a lot is expired.

LNITMSEQ

i4

4

Y

Not applicable

Line item sequence; used to order line items; internally, the number is incremented by 16384 and the same value that is passed in to the related <taSopLineIvcInsert> node should be used

ITEMNMBR

string

30

Y

Not applicable

Item number

LOCNCODE

string

10

N

<blank>

Location code

QUANTITY

number

21

Y

Not applicable

Total quantity for line item

BIN

string

15

N

<blank>

Bin; BIN is required if multi bins are enabled and creating a lot # on the fly, otherwise defaults from IV00300

CREATEBIN

i4

1

N

0

Create Bin*: 0=No; 1=Yes

*CREATEBIN is only used when automatically creating lot number and multi bins are enabled

LOTNUMBR

string

20

N

<blank>

Lot number for autocreation

EXPNDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Expiration Date:

Used to specify the date for a newly created lot layer. If an expiration date is supplied for a decrease adjustment/variance, a lot layer needs to exist.

MFGDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Manufacturing Date:

Used to specify the date for a newly created lot layer.

QTYTYPE

i4

2

N

1

Quantity type:

1= on hand;

2= returned;

3= in se;

4= in service;

5= damaged

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

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

DOCID

string

15

N

<blank>

Document ID; should match DOCID passed to <taSopLineIvcInsert>

DROPSHIP

i4

2

N

0

Drop ship flag;

1=Drop ship--should match drop ship passed to <taSopLineIvcInsert>

QTYFULFI

number

21

N

Default from startup

Quantity fulfilled; the sum of this field on all <taSopLotAuto> nodes should match QTYFULFI passed to <taSopLineIvcInsert>; if set to a value other than null, that value is used (this is to help users because this node shouldn't be called if not fulfilling

ALLOCATE

i4

2

N

0

Allocates quantities; should match ALLOCATE passed to <taSopLineIvcInsert> node; 0=Use DOCID default; 1=Allocate quantities if DOCID allows--this is to help users because this node shouldn't be called if not fulfilling

CMPNTSEQ

i4

4

N

0

Component sequence

LOTNUMBRToReplace

string

20

N

<blank>

Previous lot number; used only if modifying an existing lot number; quantity has to match to an existing line

AUTOCREATELOT

i4

4

N

0

Autocreate lot number on the fly (for the amount over any existing amount for the lot being used):

0=False;

1=True

UOFM

string

8

N

<blank>

Unit of measure; should match SOP line

DATERECD

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Date received

UpdateIfExists

i4

2

N

1

Used to add or modify existing documents:

0=New document;

1=Modify existing

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 <taSopLotAuto> node uses field level updates to provide update functionality.