| RTV_Number |
char(15)
''
|
|
|
|
|
| RTV_Line |
numeric(19,5)
0.00
|
|
|
|
|
| RTV_Type |
char(11)
''
|
|
|
|
|
| RTV_Status |
smallint
0
|
|
|
|
|
| RTV_Return_Status |
char(3)
''
|
|
|
|
|
| VRMA_Document_ID |
char(15)
''
|
|
|
|
|
| RETDOCID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| LNSEQNBR |
numeric(19,5)
0
|
Line SEQ N...(more) Join Now
|
|
|
|
| SVC_Process_SEQ_Number |
numeric(19,5)
0.00
|
|
|
|
|
| DSCRIPTN |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
|
| REFRENCE |
char(31)
''
|
Reference:...(more) Join Now
|
POP30300.REFRENCE
|
|
|
| Reference2 |
char(31)
''
|
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ITEMDESC |
char(101)
''
|
Field Type...(more) Join Now
|
|
|
|
| ITMTRKOP |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| QUANTITY |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| QTYSHPPD |
numeric(19,5)
0.00
|
QTY Shippe...(more) Join Now
|
POP10500.QTYSHPPD
|
|
|
| QTY_To_Receive |
numeric(19,5)
0.00
|
|
|
|
|
| QTYRECVD |
numeric(19,5)
0.00
|
QTY Receiv...(more) Join Now
|
SOP10200.QTYRECVD
|
|
|
| QTYCANCE |
numeric(19,5)
0.00
|
QTY Cancel...(more) Join Now
|
|
|
|
| UOFM |
char(9)
''
|
Field Type...(more) Join Now
|
|
|
See I... more text available
|
| VENDORID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| VNDITNUM |
char(31)
''
|
Vendor Ite...(more) Join Now
|
IV00103.VNDITNUM
|
|
|
| Return_Item_Number |
char(31)
''
|
|
|
|
|
| OFFID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| LOCCODEB |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| LOCNCODE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ADRSCODE |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| Ship_Address_Name |
char(65)
''
|
|
|
|
|
| Ship_Address_1 |
char(61)
''
|
|
|
|
|
| Ship_Address_2 |
char(61)
''
|
|
|
|
|
| Ship_Address_3 |
char(61)
''
|
|
|
|
|
| Ship_City |
char(35)
''
|
|
|
|
|
| Ship_State |
char(29)
''
|
|
|
|
|
| ZIPCODE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| Ship_Country |
char(61)
''
|
|
|
|
|
| ENTDTE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| ENTTME |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| PRMDATE |
datetime
'1/1/1900'
|
Promised D...(more) Join Now
|
POP10100.PRMDATE
|
|
|
| Promised_Time |
datetime
'1/1/1900'
|
|
|
|
|
| Shipped_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Shipped_Time |
datetime
'1/1/1900'
|
|
|
|
|
| receiptdate |
datetime
'1/1/1900'
|
Receipt Da...(more) Join Now
|
POP10300.receiptdate
|
|
|
| Receipt_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
|
|
|
|
| PONMBRSTR |
char(17)
''
|
Field Type...(more) Join Now
|
|
|
|
| POLNSEQ |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| POPRCTNM |
char(17)
''
|
POP Receip...(more) Join Now
|
POP10300.POPRCTNM
|
|
|
| RCPTLNNM |
int
0
|
Receipt Li...(more) Join Now
|
POP10500.RCPTLNNM
|
|
|
| Transfer_Reference |
char(31)
''
|
|
|
|
|
| TRANSLINESEQ |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| CALLNBR |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| EQPLINE |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| LINITMTYP |
char(3)
''
|
Field Type...(more) Join Now
|
|
|
|
| LNITMSEQ |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| Bill_of_Lading_Out |
char(31)
''
|
|
|
|
|
| Shipping_Method_Out |
char(15)
''
|
|
|
|
|
| Bill_of_Lading |
char(31)
''
|
|
|
|
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
RM20101.SHIPMTHD
|
|
join ... more text available
|
| Tracking_Number |
char(41)
''
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| VCHNUMWK |
char(17)
''
|
Voucher Nu...(more) Join Now
|
PM10000.VCHNUMWK
|
|
|
| Voucher_Number_Invoice |
char(17)
''
|
|
|
|
|
| Voucher_Number_Reimburse |
char(17)
''
|
|
|
|
|
| CUSTOWN |
tinyint
0
|
|
|
|
|
| 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
|
|
|
|
| Part_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Part_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Labor_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Labor_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Expense_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Expense_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Travel_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Travel_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Part_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Part_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Labor_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Labor_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_ExpensePrice |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Expense_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Travel_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Travel_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| QTYTYPE |
smallint
0
|
QTY Type...(more) Join Now
|
WOUF0132.QTYTYPE
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|