| 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
|
|
|
|
| TAXSCHID |
char(15)
''
|
|
|
|
join ... more text available
|
| priorityLevel |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| ADRSCODE |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| TIMEZONE |
char(3)
''
|
Field Type...(more) Join Now
|
|
|
|
| CONTPRC |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| RENCNTTYP |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| RENPRCSCHD |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| PCTCRYFWD |
numeric(19,5)
0.00
|
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
|
|
|
|
| MXINCPCT |
numeric(19,5)
0.00
|
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
|
|
|
|
| TOTAL |
numeric(19,5)
0.00
|
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
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| Liabiltiy_Reduction |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| Amount_To_Invoice |
numeric(19,5)
0.00
|
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
|
|
|
|
| Quote_Status |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| QUOEXPDA |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| Credit_Hold |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| TAXEXMT1 |
char(25)
''
|
Field Type...(more) Join Now
|
|
|
|
| TAXEXMT2 |
char(25)
''
|
Field Type...(more) Join Now
|
|
|
|
| New_PO_Required |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Renewal_Contact |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
|
| Source_Contract_Number |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| Source_Contract_Type |
smallint
0
|
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
|
|
|
|
| Total_Unit |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Created_User_ID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| Source_User_ID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Contract_Signed |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Liability_Type |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| RETTYPE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| Location_Segment |
char(67)
''
|
Field Type...(more) Join Now
|
|
|
|
| Bill_To_Customer |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| Cover_All |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| canceled |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| SVC_Bill_To_Address_Code |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| svcBillingFrequency |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|