|
Ordinal
|
Data
Description
|
Data
Type
|
Data
Length
|
Required
|
Check
Constraints
|
Comments
|
|
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)
|