RTV_Number

string

15

Y

Not applicable

RTV number

RTV_Type

string

11

Y

Default from setup

RTV Type

RTV_Return_Status

string

3

N

Default from setup

RTV Status

VRMA_Document_ID

string

15

N

<blank>

Vendor’s RMA Document Number

RETDOCID

string

15

N

<blank>

Customer’s RMA Number

DSCRIPTN

string

31

N

<blank>

RTV description

VENDORID

string

15

Y

Not applicable

Vendor ID

VENDNAME

string

65

N

<blank>

Vendor name

CKHOLD

i4

2

N

0

A flag to determine whether the vendor's hold status is checked when the document is created.

0=Do not check;

1=check

ADRSCODE

string

15

Y

Not applicable

Vendor Address ID

Ship_Address_Name

string

65

N

<blank>

Name of Contact Person for Vendor’s Ship To Address

Ship_Address_1

string

61

N

<blank>

Ship to address line 1

Ship_Address_2

string

61

N

<blank>

Ship to address line 2

Ship_Address_3

string

61

N

<blank>

Ship to address line 3

Ship_City

string

35

N

<blank>

City name of vendor’s ship to address

Ship_State

string

29

N

<blank>

State of vendor’s ship to address

ZIPCODE

string

11

N

<blank>

Zip Code of vendor’s ship to address

Ship_Country

string

61

N

<blank>

Country name of vendor’s ship to address

ENTDTE

datetime

16

N

Not applicable

The date the RTV was entered

ENTTME

datetime

16

N

Not applicable

The time the RTV was entered

LOCCODEB

string

11

N

<blank>

Location Code from where item was shipped to vendor

LOCNCODE

string

11

N

<blank>

Location Code from where item will be received

Bill_of_Lading_Out

string

31

N

<blank>

Bill of Lading number for shipment to vendor

Shipping_Method_Out

string

15

N

<blank>

Shipping method for shipment to vendor

Bill_of_Lading

string

31

N

<blank>

Bill of Lading number for returning

SHIPMTHD

string

15

N

<blank>

Shipment method for returning

OFFID

string

11

N

<blank>

Office ID responsible for RTV

NOTETXT

string

2000

N

<blank>

Notes field

USERID

string

15

N

<blank>

User who created the Return To Vendor

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

Y

<blank>

Currency 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