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

COMPANY..SVC00615 Table Definition

(COMPANY..SVC_Contract_Billing_WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
CONSTS smallint
0
Field Type...(more) Join Now
CONTNBR char(11)
''
Field Type...(more) Join Now
CNTTYPE char(11)
''
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
LSTBLDTE datetime
'1/1/1900'
Field Type...(more) Join Now
NXTBLDTE datetime
'1/1/1900'
Field Type...(more) Join Now
TOTBIL numeric(19,5)
0.00
Field Type...(more) Join Now
Last_Amount_Billed numeric(19,5)
0.00
Field Type...(more) Join Now
Invoiced_Amount numeric(19,5)
0.00
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
MKDTOPST tinyint
0
Field Type...(more) Join Now
POSTED tinyint
0
Field Type...(more) Join Now
ORIGTOTBIL numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGLASTAmountBilled numeric(19,5)
0.00
Field Type...(more) Join Now
Orig_Invoiced_Amount numeric(19,5)
0.00
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
Bill_To_Customer char(15)
''
Field Type...(more) Join Now
SVC_Bill_To_Address_Code char(15)
''
Field Type...(more) Join Now
svcConsolidateContractIn tinyint
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