<taIVTransactionLineInsert>

Element name

Data type

Length

Required

Default

Description

IVDOCNBR

string

17

Y

Not applicable

IV document number

IVDOCTYP

i4

2

Y

Not applicable

IV document types:

1=Adjustment;

2=Variance

ITEMNMBR

string

30

Y

Not applicable

Item number

Reason_Code

string

15

N

<blank>

Reason code

LNSEQNBR

number

21

N

0

Line item sequence number

UOFM

string

8

N

<blank>

Unit of measure; the base unit of measure will default if left blank

TRXQTY

number

21

N

0

Transaction quantity

UNITCOST

number

21

N

0

Unit cost

TRXLOCTN

string

10

Y

Not applicable

Location ID

IVIVINDX

i4

4

N

0

Inventory index

InventoryAccount

string

75

N

<blank>

Inventory account number string

IVIVOFIX

i4

4

N

0

Inventory offset index

InventoryAccountOffSet

string

75

N

<blank>

Inventory account number string for offset account

OverrideQty

i4

1

N

1

Override quantity flag; to use this element, inventory control must allow for adjustment overrides:

0=Reset TRXQTY with quantity available;

1=Override quantity available and use TRXQTY

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

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

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

This node uses document exchange for updates. All existing values are overwritten with the value specified by the update document. If a field in the update is blank, the existing value is changed to be blank.