| SOPTYPE |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| SOPNUMBE |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| CUSTNMBR |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| CUSTNAME |
char(65)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADRSCODE |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| CNTTYPE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Length |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| Contract_Period |
smallint
0
|
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
|
|
|
|
| PREPAID |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| PRICSHED |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| BILLNGTH |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| BILPRD |
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
|
|
|
|
| BILONDY |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| BILCYC |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Liability_Type |
smallint
0
|
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
|
|
|
|
| PORDNMBR |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Invoice_Detail |
tinyint
0
|
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
|
|
|
|
| PMPRTPCT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| PMLABPCT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| PMMSCPCT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Paid_Contract |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| DSCPCTAM |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| 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
|
|
|
|
| TIME1 |
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
|
|
|
|
| svcBillingFrequency |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| svcFrequencyQty |
smallint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|