| RTV_Number |
char(15)
''
|
|
|
|
|
| RTV_Type |
char(11)
''
|
|
|
|
|
| RTV_Return_Status |
char(3)
''
|
|
|
|
|
| RTV_Status |
smallint
0
|
|
|
|
|
| VRMA_Document_ID |
char(15)
''
|
|
|
|
|
| RETDOCID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| LNSEQNBR |
numeric(19,5)
0
|
Line SEQ N...(more) Join Now
|
|
|
|
| DSCRIPTN |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
|
| VENDORID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| VENDNAME |
char(65)
''
|
Vendor Nam...(more) Join Now
|
POP10100.VENDNAME
|
|
|
| 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
|
|
|
|
| LOCCODEB |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| LOCNCODE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| 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
|
|
|
|
|
| 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
|
| OFFID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| 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
|
|
|
|
|
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| 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
|
|
|
|
| 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
|
|
|
|
|
| VOIDSTTS |
smallint
0
|
Void Statu...(more) Join Now
|
POP30300.VOIDSTTS
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|