|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sca_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sca__chr01
|
User Character Field 1
|
|
X(8)
|
|
|
|
sca__chr02
|
User Character Field 2
|
|
X(8)
|
|
|
|
sca__chr03
|
User Character Field 3
|
|
X(8)
|
|
|
|
sca__dec01
|
User Decimal Field 1
|
|
->>>>,>>>,>>9.99
|
10
|
|
|
sca__dte01
|
User Date Field 1
|
|
99/99/99
|
|
|
|
sca__dte02
|
User Date Field 2
|
|
99/99/99
|
|
|
|
sca__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
sca__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
sca__qadc03
|
QAD Character Field 3
|
|
X(8)
|
|
|
|
sca__qade01
|
QAD Decimal Field 1
|
|
->>>>,>>>,>>9.99
|
10
|
|
|
sca__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
sca__qadt02
|
QAD Date Field 2
|
|
99/99/99
|
|
|
|
sca_amount
|
Amount
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sca_amt_type
|
Amount Type
|
|
x(1)
|
|
|
|
sca_cycle
|
Billing Cycle
|
|
x(8)
|
|
|
|
sca_desc
|
Description
|
|
x(40)
|
|
|
|
sca_domain
|
Domain
|
|
x(8)
|
|
|
|
sca_expire
|
Expire Date
|
|
99/99/99
|
|
|
|
sca_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sca_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sca_part
|
Item
|
|
x(18)
|
|
|
|
sca_pct_type
|
Percent Type
|
|
x(8)
|
|
|
|
sca_priority
|
Priority
|
|
>>9
|
|
|
|
sca_prodline
|
Product Line
|
Line
|
x(4)
|
|
|
|
sca_service
|
Service Type
|
|
x(8)
|
|
|
|
sca_start
|
Start Date
|
|
99/99/99
|
|
|
|
sca_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sca_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sca_mstr
|
yes
|
oid_sca_mstr
|
yes
|
no
|
|
|
sca_part
|
no
|
sca_domain
|
yes
|
no
|
|
|
|
|
sca_part
|
yes
|
no
|
|
|
|
|
sca_service
|
yes
|
no
|
|
∗
|
sca_service
|
yes
|
sca_domain
|
yes
|
no
|
|
|
|
|
sca_service
|
yes
|
no
|
|
|
|
|
sca_part
|
yes
|
no
|