| RETDOCID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| Return_Record_Type |
smallint
0
|
|
|
|
|
| RMA_Status |
smallint
0
|
|
|
|
|
| Received |
tinyint
0
|
|
|
|
|
| RETORIG |
smallint
0
|
|
|
|
|
| RETREF |
char(31)
''
|
|
|
|
|
| RETSTAT |
char(3)
''
|
|
|
|
|
| RETTYPE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| ENTDTE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| ENTTME |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| ETADTE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| ETATME |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| RETUDATE |
datetime
'1/1/1900'
|
|
|
|
|
| Return_Time |
datetime
'1/1/1900'
|
|
|
|
|
| COMPDTE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| COMPTME |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| OFFID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| RTRNNAME |
char(45)
''
|
|
|
|
|
| RETADDR1 |
char(61)
''
|
|
|
|
|
| RETADDR2 |
char(61)
''
|
|
|
|
|
| RETADDR3 |
char(61)
''
|
|
|
|
|
| RTRNCITY |
char(21)
''
|
|
|
|
|
| SVC_Return_State |
char(29)
''
|
|
|
|
|
| RTRNZIP |
char(11)
''
|
|
|
|
|
| Return_Country |
char(61)
''
|
|
|
|
|
| LOCNCODE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| CUSTNMBR |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ADRSCODE |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| CUSTNAME |
char(65)
''
|
Field Type...(more) Join Now
|
|
|
|
| CONTACT |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS1 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS3 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| CITY |
char(35)
''
|
Field Type...(more) Join Now
|
|
|
|
| STATE |
char(29)
''
|
Field Type...(more) Join Now
|
|
|
|
| ZIPCODE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| CALLNBR |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| SRVRECTYPE |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| EQPLINE |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| LNITMSEQ |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| Bill_of_Lading |
char(31)
''
|
|
|
|
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
RM20101.SHIPMTHD
|
|
join ... more text available
|
| SOPTYPE |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| SOPNUMBE |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| SOP_Line_Item_Sequence |
int
0
|
|
|
|
|
| CMPNTSEQ |
int
0
|
Component ...(more) Join Now
|
|
|
|
| Bill_To_Customer |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Bill_To_Address_Code |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| Commit_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Commit_Time |
datetime
'1/1/1900'
|
|
|
|
|
| USERDEF1 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| USRDEF03 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| USRDEF04 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| USRDEF05 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| RATETPID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| EXGTBLID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| EXCHDATE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| DECPLACS |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| RATECALC |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| VIEWMODE |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| ISMCTRX |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| EXPNDATE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| MCTRXSTT |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| CSTPONBR |
char(21)
''
|
Tax Schedu...(more) Join Now
|
RM10301.CSTPONBR
|
|
|
| SVC_RMA_Reason_Code |
char(3)
''
|
|
|
|
|
| SVC_RMA_Reason_Code_Desc |
char(31)
''
|
|
|
|
|
| SVC_RMA_From_Service |
tinyint
0
|
|
|
|
|
| SVC_FO_ID |
char(51)
''
|
Field Type...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|