Return_Record_Type

i4

2

Y

Not applicable

RMA record type

RETDOCID

string

15

Y

Not applicable

RMA number

RETORIG

i4

2

N

Default from setup

Return Origin ;

1=None,

2=Service Call,

3=SOP

RETREF

string

31

N

<blank>

Return reference document number – SOP Invoice or Service Call Number

RETSTAT

string

3

N

Default from setup

RMA Status Code

RETTYPE

string

15

Y

Default from setup

Return Type

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

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

LOCNCODE

string

11

N

Default from setup

Return location code

CUSTNMBR

string

15

Y

Not applicable

Customer ID

ADRSCODE

string

15

Y

Not applicable

Customer Address ID

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

NOTETXT

string

2000

N

<blank>

Notes field

Bill_of_Lading

string

31

N

<blank>

Bill of Lading for shipping out to customer

SHIPMTHD

string

15

N

<blank>

Shipping Method

Bill_To_Customer

string

15

N

Default from setup

Bill To Customer ID

SVC_Bill_To_Address_Code

string

15

N

Default from setup

Bill To Customer Address ID

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

CSTPONBR

string

21

N

<blank>

Customer PO number

SVC_RMA_Reason_Code

string

3

N

<blank>

RMA Reason code

SVC_RMA_From_Service

i4

1

N

Not applicable

Flag to indicate whether RMA was created from Service Call ;0=No, 1=Yes

SVC_FO_ID

string

51

N

<blank>

Front office integration ID

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