Module List > Module SVC tables SVC30600
You are currently viewing the COMPANY database.
Change

COMPANY..SVC30600 Table Definition

(COMPANY..SVC_Contract_HDR_HIST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CONSTS smallint
0
Field Type...(more) Join Now
CONTNBR char(11)
''
Field Type...(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
SVC_Invoice_Detail tinyint
0
Field Type...(more) Join Now
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
SVC_Bill_To_Address_Code char(15)
''
Field Type...(more) Join Now
DSCDLRAM numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_Paid_Contract tinyint
0
Field Type...(more) Join Now
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
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
ORIGTOTAL numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGLASTAmountBilled 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
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
SmoothInvoiceCalc tinyint
0
Field Type...(more) Join Now
SmoothRevenueCalc tinyint
0
Field Type...(more) Join Now
SVC_Use_Same_Number tinyint
0
Field Type...(more) Join Now
SVC_FO_ID char(51)
''
Field Type...(more) Join Now
SVC_Invoiced_Cost numeric(19,5)
0.00
Field Type...(more) Join Now
Orig_SVC_Invoiced_Cost numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_Contract_Version smallint
0
Field Type...(more) Join Now
SVC_Evergreen_Contract tinyint
0
Field Type...(more) Join Now
SVC_Evergreen_RenewLimit smallint
0
Field Type...(more) Join Now
SVC_Evergreen_Renewals smallint
0
Field Type...(more) Join Now
SVC_New_Contract_Number char(11)
''
Field Type...(more) Join Now
SVC_New_PO_Number char(21)
''
Field Type...(more) Join Now
Workflow_Approval_Status smallint
0
Time: Time...(more) Join Now
Workflow_Priority smallint
0
Workflow A...(more) Join Now SY00500.Workflow_Priority
svcBillingFrequency smallint
0
Field Type...(more) Join Now
svcFrequencyQty smallint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3