Module List >
Module SVC tables
SVC05635
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SVC05635 Table Definition
(COMPANY..SVC_RTV_Closing_WORK)
Field Definitions:
What is the 'source' column?
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| RTV_Number |
char(15)
''
|
|
|
|
|
| RTV_Line |
numeric(19,5)
0.00
|
|
|
|
|
| RTV_Type |
char(11)
''
|
|
|
|
|
| OFFID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| VENDORID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ADRSCODE |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| VENDNAME |
char(65)
''
|
Vendor Nam...(more) Join Now
|
POP10100.VENDNAME
|
|
|
| LOCNCODE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ITEMNMBR |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| VNDITNUM |
char(31)
''
|
Vendor Ite...(more) Join Now
|
IV00103.VNDITNUM
|
|
|
| Part_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Part_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Labor_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Labor_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Expense_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Expense_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Travel_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Travel_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Part_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Part_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Labor_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Labor_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Expense_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_ExpensePrice |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Travel_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Travel_Price |
numeric(19,5)
0.00
|
|
|
|
|
| MKDTOPST |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| POSTED |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| ERMSGNBR |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| ERMSGTXT |
char(255)
''
|
Field Type...(more) Join Now
|
|
|
|
| ERMSGTX2 |
char(255)
''
|
Field Type...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|