Return_Record_Type

i4

2

Y

Not applicable

RMA record type

RETDOCID

string

15

Y

Not applicable

RMA number

LNSEQNBR

number

21

N

0

The sequence number for the line. If not provided on an update a new line will be created.

RETTYPE

string

11

N

Default from setup

Return Type

RETSTAT

string

3

N

Default from setup

RMA Status Code

CUSTNMBR

string

15

Y

Not applicable

Customer number

ADRSCODE

string

15

Y

Not applicable

Customer address code

ITEMNMBR

string

31

Y

Not applicable

Item number of item being returned

ITEMDESC

string

101

N

Not applicable

Description of item being returned

LOCNCODE

string

11

Y

<blank>

Return location code

SVC_Ready_To_Close

i4

1

N

0

Flag to indicate whether the line is ready for closing or not ;

0=No,

1=Yes

SVC_RMA_Reason_Code

string

3

N

<blank>

RMA Reason code

NOTETXT

string

2000

N

<blank>

Notes field

RETORIG

i4

2

N

1

Return Origin ;

1=None,

2=Service Call,

3=SOP

RETREF

string

31

N

<blank>

Return reference document number – SOP Invoice or Service Call Number

EQPLINE

i4

4

N

Not applicable

Equipment sequence line number of the service call line

LNITMSEQ

i4

4

N

Not applicable

The sequence number for the service call line

SVC_RMA_From_Service

i4

1

N

Not applicable

Flag to indicate whether RMA was created from Service Call ;

0=No,

1=Yes

CMPNTSEQ

i4

4

N

Not applicable

The component sequence number for the sales invoice line

SOP_Line_Item_Sequence

i4

4

N

Not applicable

The line sequence number for the sales invoice line

ENTDTE

datetime

16

N

Not applicable

The date the RMA was entered

ENTTME

datetime

16

N

Not applicable

The time the RMA was entered

ETADTE

datetime

16

N

Not applicable

The date the item being returned is expected to arrive

ETATME

datetime

16

N

Not applicable

The time the item being returned is expected to arrive

Commit_Date

datetime

16

N

Not applicable

The commit date for the RMA

Commit_Time

datetime

16

N

Not applicable

The commit time for the RMA

RETUDATE

datetime

16

N

Not applicable

The date the item being returned was received

Return_Time

datetime

16

N

Not applicable

The time the item being returned was received

COMPDTE

datetime

16

N

Not applicable

The date the RMA was closed

COMPTME

datetime

16

N

Not applicable

The time the RMA was closed

PRMDATE

datetime

16

N

Not applicable

The promise date for the RMA

USERID

string

15

N

<blank>

The user who created the RMA

OFFID

string

11

N

<blank>

Office ID responsible for the RMA

RTRNNAME

string

45

N

<blank>

Return location name

RETADDR1

string

61

N

<blank>

Return address line 1

RETADDR2

string

61

N

<blank>

Return address line 2

RETADDR3

string

61

N

<blank>

Return address line 2

RTRNCITY

string

21

N

<blank>

Return city

SVC_Return_State

string

29

N

<blank>

Return state code

RTRNZIP

string

11

N

<blank>

Return ZIP Code

Return_Country

string

61

N

<blank>

Return country

CUSTNAME

string

65

N

<blank>

Customer name

CONTACT

string

61

N

<blank>

Customer contact

ADDRESS1

string

61

N

<blank>

Customer address line 1

ADDRESS2

string

61

N

<blank>

Customer address line 2

ADDRESS3

string

61

N

<blank>

Customer address line 2

CITY

string

35

N

<blank>

Customer city

STATE

string

29

N

<blank>

Customer state code

ZIPCODE

string

11

N

<blank>

Customer ZIP Code

COUNTRY

string

61

N

<blank>

Customer country

CSTPONBR

string

21

N

<blank>

Customer PO number

QUANTITY

number

21

N

Not applicable

Quantity of item being returned

UOFM

string

9

N

<blank>

Unit of measure

UNITCOST

number

21

N

0

Unit cost of item being returned

UNITPRCE

number

21

N

0

Unit price of item being returned

XTNDPRCE

number

21

N

0

Extended price of item being returned

CUSTOWN

i4

1

N

0

Flag to indicate if item was owned by customer.

0=No,

1=Yes

FACTSEAL

i4

1

N

0

Flag to indicate if item was factory sealed.

0=No,

1=Yes

Flat_Rate_Repair_Price

number

21

N

0

Flat rate repair price

Repair_Price

number

21

N

0

Repair price

NTE_Price

number

21

N

0

Not to exceed price

Repair_Cost

number

21

N

0

Repair cost

Bill_of_Lading

string

31

N

<blank>

Bill of Lading for shipping out to customer

SHIPMTHD

string

15

N

<blank>

Shipping method

Location_Code_Replacemen

string

11

N

<blank>

Replacement location code

Replace_Item_Number

string

31

N

<blank>

Replacement item number

Replace_U_Of_M

string

9

N

<blank>

Replacement unit of measure

Replace_Price_Level

string

11

N

<blank>

Replacement price level

Replace_QTY

number

21

N

0

Replacement quantity

Replace_Cost

number

21

N

0

Replacement unit cost

Replace_Price

number

21

N

0

Replacement unit price

Item_Number_Invoice

string

31

N

<blank>

Invoice item number

USERDEF1

string

21

N

<blank>

User defined 1

USERDEF2

string

21

N

<blank>

User defined 2

USRDEF03

string

21

N

<blank>

User defined 3

USRDEF04

string

21

N

<blank>

User defined 4

USRDEF05

string

21

N

<blank>

User defined 5

CURNCYID

string

15

N

<blank>

Currency ID

Return_Item_Number

string

31

N

<blank>

Item number of item that was returned

Return_Item_Description

string

51

N

<blank>

Description of item that was returned

Return_Location_Code

string

11

N

<blank>

Location code where item was returned

Return_QTY

number

21

N

0

Quantity of item that was returned

Return_U_Of_M

string

8

N

<blank>

Return unit of measure

RETCOST

number

21

N

0

Return unit cost

SVC_Return_Price_Level

string

11

N

<blank>

Return price level

SVC_Return_Price

number

21

N

0

Return unit price

SVC_Extended_Return_Pric

number

21

N

0

Return extended price

SVC_FO_ID

string

51

N

<blank>

Front office integration ID

SVC_SCM_Complete

i4

2

N

0

Flag to indicate whether SCM is complete;

0=False,

1=True

UpdateIfExists

i4

1

N

1

Flag to allow data to be updated if it exists:

0=Do not update;

1=Update

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