| CONSTS |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| CONTNBR |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| LNSEQNBR |
numeric(19,5)
0
|
Line SEQ N...(more) Join Now
|
|
|
|
| Contract_Transfer_Status |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Transfer_Date |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| CNTPRCOVR |
tinyint
0
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| ADRSCODE |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| QUANTITY |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| CONFGREF |
char(21)
''
|
|
|
|
|
| EQUIPID |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| SERLNMBR |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| FRZEND |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| FRXSTRT |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| BLKTIM |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| VALTIM |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| DSCPCTAM |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| COMDLRAM |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| PRCSTAT |
char(1)
''
|
Field Type...(more) Join Now
|
|
|
|
| PORDNMBR |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| DSCRIPTN |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
|
| PARTPCT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| LABPCT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| MISCPCT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| PMMSCPCT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| PMPRTPCT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| PMLABPCT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| VENDORID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| RETNAGAM |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| RTNBILLD |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| SLPRSNID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| COMMCODE |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| COMPRCNT |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| BILSTRT |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| BILEND |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| BILLNGTH |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| BILPRD |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| FRSTBLDTE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| Last_Amount_Billed |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| LSTBLDTE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| NBRCAL |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| TOTAL |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ACTCAL |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| TOTVALCAL |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| CONTACT |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| NXTBLDTE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| CNTTYPE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| PRICSHED |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| CUSTNMBR |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ENTDTE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| MINBIL |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| MAXBIL |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| MAXBILL |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| AUTOREN |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| priorityLevel |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| MSTCNTRCT |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| SRVTYPE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| BILFRRET |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| TOTBIL |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| PREPAID |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| BILONDY |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| BILCYC |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| UOFM |
char(9)
''
|
Field Type...(more) Join Now
|
|
|
See I... more text available
|
| BILSTAT |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| ENTTME |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| STRTDATE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| ENDDATE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| CNTCOVPD_1 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| CNTCOVPD_2 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| CNTCOVPD_3 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| CNTCOVPD_4 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| CNTCOVPD_5 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| CNTCOVPD_6 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| CNTCOVPD_7 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Coverage_Period_1 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Coverage_Period_2 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Coverage_Period_3 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Coverage_Period_4 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Coverage_Period_5 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Coverage_Period_6 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Coverage_Period_7 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| USECVPD_1 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| USECVPD_2 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| USECVPD_3 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| USECVPD_4 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| USECVPD_5 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| USECVPD_6 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| USECVPD_7 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| TAXSCHID |
char(15)
''
|
|
|
|
join ... more text available
|
| CNFGLVL |
smallint
0
|
|
|
|
|
| CNFGSEQ |
smallint
0
|
|
|
|
|
| Contract_Length |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Period |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| Invoiced_Amount |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Amount_To_Invoice |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Liabiltiy_Reduction |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| Liability_Amount |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Total_Liability_Amount |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| NUMOFINV |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| New_Invoice_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| Contract_Line_Status |
char(1)
''
|
|
|
|
|
| Contract_Renewal_Contact |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Response_Time |
char(7)
''
|
Field Type...(more) Join Now
|
|
|
|
| Liability_Months |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| Next_Liability_Date |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| Last_Liability_Date |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| Total_Liability_Billed |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| TAXEXMT1 |
char(25)
''
|
Field Type...(more) Join Now
|
|
|
|
| TAXEXMT2 |
char(25)
''
|
Field Type...(more) Join Now
|
|
|
|
| Total_Unit |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| UNITCOST |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Unit_Cost_Total |
numeric(19,5)
0.00
|
|
|
|
|
| SVC_Liability_Type |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Contract_Signed |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| RETTYPE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Monthly_Price |
numeric(19,5)
0.00
|
|
|
|
|
| Location_Segment |
char(67)
''
|
Field Type...(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
|
|
|
|
| DSCDLRAM |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Invoiced_Discount |
numeric(19,5)
0.00
|
|
|
|
|
| SVC_Discount_Recognized |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Discount_Remaining |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Discount_Next |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| SVC_PM_Date |
smallint
0
|
|
|
|
|
| SVC_PM_Day |
smallint
0
|
|
|
|
|
| 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
|
|
|
|
| ORIGVALTIM |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORCOMAMT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORIGRETNAGAM |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORIGRTNBILLD |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORIGLASTAmountBilled |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORIGTOTAL |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORIGTOTVALCAL |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORIGMINBIL |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORIGMAXBIL |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Originating_Max_Billable |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORIGTOTBIL |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Orig_Invoiced_Amount |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Orig_Amount_To_Invoice |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Orig_Liability_Amount |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| OrigTotLiabilityAmount |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| OrigTotLiabBilled |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Originating_Total_Unit |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORUNTCST |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORDDLRAT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| OrigDiscountReceived |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| OrigDiscountRemaining |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| OrigDiscountNext |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORIGUNITCOSTTOTAL |
numeric(19,5)
0.00
|
|
|
|
|
| ORIGMONTHPRICE |
numeric(19,5)
0.00
|
|
|
|
|
| ORIGINVOICEDDISC |
numeric(19,5)
0.00
|
|
|
|
|
| OrigNewInvoiceAmount |
numeric(19,5)
0.00
|
|
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| ORTAXAMT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| SVC_FO_ID |
char(51)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Contract_Version |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| MovedRevenue |
numeric(19,5)
0.00
|
|
|
|
|
| OriginalTotal |
numeric(19,5)
0.00
|
|
|
|
|
| OrigMovedRevenue |
numeric(19,5)
0.00
|
|
|
|
|
| OrigOriginalTotal |
numeric(19,5)
0.00
|
|
|
|
|
| Credit_Hold |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| ITEMDESC |
char
''
|
Item Descr...(more) Join Now
|
WO010116.ITEMDESC
|
|
|