KS_RMA_RECEIPTS

1

Receipt Number

string

30

Y

Used to lookup and either update or insert the delivery_no PK field

2

Receipt Line No

integer

4

Y

3

Order Number

string

30

Y

This is the RMA (refer to Order Type)

4

Order Item Number

integer

4

Y

This is the RMA line item number (may not correspond with the Receipt Line Item number

5

Part Number

string

25

If the item exists in item_master, the FK will be updated. Regardless the delivery_item_
xref_id will be updated as well from this field.

6

Receipt Date

datetime

7

Return
Quantity

integer

4

8

Ship Via

string

50

9

Waybill

string

50

Not applicable on RMA receipts - leave blank

10

Status

string

1

Any character is valid however recognized statuses include: R=received, X=canceled. If updated with "D" then this receipt will be considered deleted and will not be selected for display.

11

Order Type

string

1

Y

'R' Return
Material
Authorization

This field determines what type of order produced the receipt. Only RMAs supported at this release 'R'. Used for lookup only.

12

Delivery Line Desc

string

50

This is a description of the delivery line item. In the case where a standard product is received the product description is usually customary. This field is displayed in the RMA Receipt Detail page

13

Receiving UOM

string

10

Y

The receiving unit of measure for this RMA item.

14

Deliver to Name

string

50

The name of the entity for the receiving destination (e.g. customer name or branch location)

15

Deliver to Address 1

string

75

Delivered to address line 1 of 3

16

Deliver to Address 2

string

75

Delivered to address line 2 of 3

17

Deliver to Address 3

string

75

Delivered to address line 3 of 3

18

Deliver to City

string

50

The city in which the receipt landed

19

Deliver to State

string

50

The state in which the receipt landed

20

Deliver to Postal

string

20

The postal code (zip) in which the receipt landed

21

Deliver to Country

string

50

The country in which the receipt landed

22

Deliver to Attention

string

50

The person receiving the shipment

23

Deliver to Phone

string

20

The phone number to contact (required by some carriers)