Module List >
Module SV tables
SVA0547
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SVA0547 Table Definition
(COMPANY..SV_Revenue_Recognition_WORK_Archive)
Field Definitions:
What is the 'source' column?
| YEAR1 |
smallint
|
Field Type...(more) Join Now
|
|
|
|
| PERIODID |
smallint
|
Field Type...(more) Join Now
|
|
|
|
| CUSTNMBR |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ADRSCODE |
char(15)
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Number |
char(11)
|
|
|
|
|
| WSCONTSQ |
int
|
|
|
|
|
| Actual_Equipment |
numeric(19,5)
|
|
|
|
|
| Actual_Material |
numeric(19,5)
|
|
|
|
|
| Actual_Labor |
numeric(19,5)
|
|
|
|
|
| Actual_Subs |
numeric(19,5)
|
|
|
|
|
| Actual_Other |
numeric(19,5)
|
|
|
|
|
| TTD_Billed |
numeric(19,5)
|
|
|
|
|
| YTD_Equipment |
numeric(19,5)
|
|
|
|
|
| YTD_Material |
numeric(19,5)
|
|
|
|
|
| YTD_Labor |
numeric(19,5)
|
|
|
|
|
| YTD_Subcontractor |
numeric(19,5)
|
|
|
|
|
| YTD_Other |
numeric(19,5)
|
|
|
|
|
| TTD_Contract_Earned |
numeric(19,5)
|
|
|
|
|
| Division |
smallint
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|