|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SafConcept_ID
|
Record ID
|
|
-99999999999
|
|
|
|
SafConceptCode
|
SAF Concept Code
|
|
x(20)
|
|
|
|
SafConceptDescription
|
SAF Concept Description
|
|
x(40)
|
|
|
|
SafConceptIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
SafConceptIsSystem
|
System
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
SafConceptCode
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
SafConcept_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
SafConceptIsActive
|
yes
|
no
|
|
|
|
|
SafConceptCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SafStructure_ID
|
Record ID
|
|
-99999999999
|
|
|
|
SafStructureCode
|
Structure Code
|
Structure
|
x(20)
|
|
|
|
SafStructureDescription
|
Description
|
|
x(40)
|
|
|
|
SafStructureIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
SafStructureCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
SafStructure_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
SafStructureIsActive
|
yes
|
no
|
|
|
|
|
SafStructureCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
SafConcept_ID
|
Link to SafConcept
|
|
-99999999999
|
|
|
|
SafStructure_ID
|
Link to SafStructure
|
|
-99999999999
|
|
|
|
SafStructureLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
SafStructureLineBComponent
|
Business Component
|
|
x(30)
|
|
|
|
SafStructureLineNumber
|
Line Number
|
Line
|
->,>>>,>>9
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BusinessComp
|
no
|
SafStructureLineBComponent
|
yes
|
no
|
|
|
Line
|
no
|
SafStructure_ID
|
yes
|
no
|
|
|
|
|
SafStructureLineNumber
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
SafStructureLine_ID
|
yes
|
no
|
|
|
SafConcept
|
no
|
SafConcept_ID
|
yes
|
no
|
|
|
SafIdx
|
no
|
Saf_ID
|
yes
|
no
|
|
|
SafStructure
|
no
|
SafStructure_ID
|
yes
|
no
|
|
|
StructConcpt
|
yes
|
SafStructure_ID
|
yes
|
no
|
|
|
|
|
SafConcept_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CostCentre_ID
|
Cost Center Code
|
|
-99999999999
|
|
|
|
GL_ID
|
GL Account
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Project_ID
|
Project
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SafStructure_ID
|
Structure Code
|
Structure
|
-99999999999
|
|
|
|
SafStructureLink_ID
|
Record ID
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AltPrim
|
yes
|
SafStructure_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
Project_ID
|
yes
|
no
|
|
|
|
|
CostCentre_ID
|
yes
|
no
|
|
|
CostCentre
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
Job
|
no
|
Project_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
SafStructureLink_ID
|
yes
|
no
|
|
|
SafStructure
|
no
|
SafStructure_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sah_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sah__chr01
|
User Field#1
|
|
x(8)
|
|
|
|
sah__chr02
|
User Field #1
|
|
x(8)
|
|
|
|
sah__chr03
|
User Field #3
|
|
x(8)
|
|
|
|
sah__chr04
|
User Field #4
|
|
x(8)
|
|
|
|
sah__chr05
|
User Field #5
|
|
x(8)
|
|
|
|
sah__chr06
|
User Field #6
|
|
x(8)
|
|
|
|
sah__chr07
|
User Field #7
|
|
x(8)
|
|
|
|
sah__chr08
|
User Field #8
|
|
x(8)
|
|
|
|
sah__chr09
|
User Field #9
|
|
x(8)
|
|
|
|
sah__chr10
|
User Field #10
|
|
x(8)
|
|
|
|
sah__dec01
|
User Decimal #1
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sah__dec02
|
User Decimal #2
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sah__dec03
|
User Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sah__dte01
|
User Date #1
|
|
99/99/99
|
|
|
|
sah__dte02
|
User Date #2
|
|
99/99/99
|
|
|
|
sah__dte03
|
User Date #3
|
|
99/99/99
|
|
|
|
sah__log01
|
User Logical #1
|
|
yes/no
|
|
|
|
sah__log02
|
User Logical #2
|
|
yes/no
|
|
|
|
sah__log03
|
User Logical #3
|
|
yes/no
|
|
|
|
sah__qadc01
|
Qad Field #1
|
|
x(8)
|
|
|
|
sah__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
sah__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
sah__qadc04
|
Qad Field #4
|
|
x(8)
|
|
|
|
sah__qadc05
|
|
|
x(8)
|
|
|
|
sah__qadc06
|
|
|
x(4)
|
|
|
|
sah__qadd01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sah__qadd02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sah__qadd03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sah__qadl01
|
Qad Logical #1
|
|
yes/no
|
|
|
|
sah__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
sah__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
sah__qadl04
|
QAD Logical Field
|
|
yes/no
|
|
|
|
sah__qadt01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
sah__qadt02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
sah__qadt03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
sah_area
|
Area
|
|
x(8)
|
|
|
|
sah_arrears
|
Bill Arrears
|
Arrear
|
yes/no
|
|
|
|
sah_autornew
|
Auto Renew
|
A Renew
|
yes/no
|
|
|
|
sah_base_pct
|
Contract Base
|
|
>>>9.99<<<
|
10
|
|
|
sah_bill_cnt
|
Bill Count
|
Bill Cnt
|
->,>>>,>>9
|
|
|
|
sah_bill_to
|
Bill To
|
|
x(8)
|
|
|
|
sah_bill_type
|
Billing Type
|
|
x(8)
|
|
|
|
sah_blanket
|
Blanket Contract
|
|
yes/no
|
|
|
|
sah_bol
|
BOL
|
|
x(18)
|
|
|
|
sah_calls_allow
|
Calls Allowed
|
|
>>>,>>9
|
|
|
|
sah_calls_total
|
Total Calls
|
|
>>>,>>9
|
|
|
|
sah_can_tax
|
PST Pct
|
|
->>9.99<<%
|
10
|
|
|
sah_cancel
|
Cancel Date
|
|
99/99/99
|
|
|
|
sah_channel
|
Channel
|
|
x(8)
|
|
|
|
sah_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
sah_comm_pct[4]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
sah_complete
|
Complete
|
Cplt
|
yes/no
|
|
|
|
sah_conf_date
|
Confirmed Date
|
Confirmed
|
99/99/99
|
|
|
|
sah_cr_card
|
Credit Card
|
Card
|
x(2)
|
|
|
|
sah_cr_init
|
Cr Initials
|
Initials
|
x(2)
|
|
|
|
sah_cr_terms
|
Credit Terms
|
Terms
|
x(8)
|
|
|
|
sah_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
sah_cust
|
Customer
|
|
x(8)
|
|
|
|
sah_cycle
|
Billing Cycle
|
Cyc
|
x(2)
|
|
|
|
sah_date_printed
|
Date Printed
|
|
99/99/99
|
|
|
|
sah_disc_pct
|
Disc %
|
|
->9.99%
|
10
|
|
|
sah_domain
|
Domain
|
|
x(8)
|
|
|
|
sah_end_date
|
End Date
|
|
99/99/99
|
|
|
|
sah_enduser
|
End User
|
|
x(8)
|
|
|
|
sah_ent_ex
|
Exch Rate
|
|
>>,>>9.99999<<<<<
|
10
|
|
|
sah_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sah_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sah_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
sah_exp_date
|
Expire Date
|
Exp Date
|
99/99/99
|
|
|
|
sah_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
sah_ext_date
|
Extend Date
|
Ext Date
|
99/99/9999
|
|
|
|
sah_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
sah_fix_rate
|
Fixed Rate
|
Fixed
|
yes/no
|
|
|
|
sah_fob
|
FOB Point
|
|
x(20)
|
|
|
|
sah_free_frm
|
Free Coverage From
|
|
99/99/99
|
|
|
|
sah_free_to
|
Free Coverage To
|
|
99/99/99
|
|
|
|
sah_fst_id
|
FST ID
|
|
x(16)
|
|
|
|
sah_gen_0itm
|
Generate 0$ Items
|
|
yes/no
|
|
|
|
sah_hold
|
Hold Contract
|
Hld
|
yes/no
|
|
|
|
sah_inv_date
|
Invoice Date
|
Inv Date
|
99/99/99
|
|
|
|
sah_invoiced
|
Invoiced
|
|
yes/no
|
|
|
|
sah_lang
|
Language
|
|
x(2)
|
|
|
|
sah_last_bill
|
Last Billed
|
Last Bill
|
99/99/99
|
|
|
|
sah_limit_copy
|
Renew Limits From
|
|
X(1)
|
|
|
|
sah_lst_bill
|
Last Bill
|
|
99/99/99
|
|
|
|
sah_lst_cover
|
Last Bill
|
Lst Bill
|
99/99/99
|
|
|
|
sah_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sah_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sah_mref
|
Master Contract
|
Master
|
x(8)
|
|
|
|
sah_mrp
|
Link to MRP
|
|
yes/no
|
|
|
|
sah_nbr
|
Number
|
|
x(10)
|
|
|
|
sah_next_dur
|
Next Duration
|
|
>>9.99
|
10
|
|
|
sah_nxt_bill
|
Next Bill
|
|
99/99/99
|
|
|
|
sah_off_hours_pt
|
Off Hours Item
|
|
x(18)
|
|
|
|
sah_ord_date
|
Order Date
|
Ord Date
|
99/99/99
|
|
|
|
sah_orig_date
|
Original Start
|
|
99/99/99
|
|
|
|
sah_part
|
Service Type
|
Svc Type
|
x(8)
|
|
|
|
sah_periodic
|
Periodic Billing
|
|
yes/no
|
|
|
|
sah_po
|
Purchase Order
|
|
x(20)
|
|
|
|
sah_pr_list
|
Price List
|
List
|
x(8)
|
|
|
|
sah_pr_list2
|
List Price List
|
List
|
x(8)
|
|
|
|
sah_prefix
|
Pf
|
|
x(1)
|
|
|
|
sah_prepaid
|
Prepaid
|
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
sah_print
|
Print Sales Order
|
Print SO
|
yes/no
|
|
|
|
sah_print_pl
|
Print Pack List
|
Print Pack
|
yes/no
|
|
|
|
sah_prodline
|
Product Line
|
Line
|
x(4)
|
|
|
|
sah_project
|
Project
|
|
X(8)
|
|
|
|
sah_prt_0itm
|
Print 0$ Items
|
|
yes/no
|
|
|
|
sah_pst
|
PST
|
|
yes/no
|
|
|
|
sah_pst_id
|
PST ID
|
|
x(16)
|
|
|
|
sah_qty_per
|
Duration
|
|
->>>9.9<<<
|
10
|
|
|
sah_qty_plst
|
Last Qty Billed
|
Last Qty
|
->>>9.9<<<
|
10
|
|
|
sah_quote
|
Quote
|
|
x(8)
|
|
|
|
sah_quote_mod
|
Quote Modified
|
|
yes/no
|
|
|
|
sah_rel_date
|
Release Date
|
Rel Date
|
99/99/99
|
|
|
|
sah_release
|
Release to Contract
|
Rel
|
yes/no
|
|
|
|
sah_renew_count
|
Renewal Count
|
|
>>9
|
|
|
|
sah_renew_period
|
Renewal Periods
|
|
>>9
|
|
|
|
sah_renewal_date
|
Renewal Date
|
|
99/99/99
|
|
|
|
sah_renewed_from
|
Renewed From
|
|
X(8)
|
0
|
|
|
sah_renewed_to
|
Renewed To
|
|
X(8)
|
0
|
|
|
sah_reval_index
|
Revaluation Index Month
|
|
>>9
|
|
|
|
sah_reval_period
|
Revaluation Period
|
|
>>9
|
|
|
|
sah_revalue_date
|
Revaluation Date
|
|
99/99/99
|
|
|
|
sah_rmks
|
Remarks
|
|
x(40)
|
|
|
|
sah_rsn_lost
|
Reason Lost
|
|
x(8)
|
|
|
|
sah_sah_type
|
Type
|
|
x(8)
|
|
|
|
sah_sched_start
|
PM Start Date
|
Start
|
yes/no
|
|
|
|
sah_schedule
|
Billing Schedule File
|
|
yes/no
|
|
|
|
sah_serial_det
|
Serial Detail
|
|
yes/no
|
|
|
|
sah_ship_date
|
Ship Date
|
|
99/99/99
|
|
|
|
sah_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
sah_site
|
Site
|
|
x(8)
|
|
|
|
sah_slspsn[4]
|
Salesperson
|
Salespsn
|
X(8)
|
0
|
|
|
sah_so_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
sah_source
|
Order Source
|
Source
|
x(8)
|
|
|
|
sah_st_cover
|
Coverage
|
|
99/99/99
|
|
|
|
sah_st_date
|
Start Date
|
|
99/99/99
|
|
|
|
sah_stat
|
Action Status
|
St
|
x(2)
|
|
|
|
sah_summarize
|
Summarize
|
|
yes/no
|
|
|
|
sah_tax_date
|
Tax Date
|
|
99/99/99
|
|
|
|
sah_tax_env
|
Tax Environment
|
Tax Env.
|
x(16)
|
0
|
|
|
sah_tax_pct[3]
|
Tax
|
|
->9.99%
|
10
|
|
|
sah_tax_usage
|
Nature of Operation
|
Nature
|
x(8)
|
|
|
|
sah_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
sah_taxc
|
Tax Code
|
T
|
x(3)
|
|
|
|
sah_total_billed
|
Total Billed
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sah_total_cost
|
Total Cost
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sah_trl1_amt
|
Trailer Amt 1
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
sah_trl1_cd
|
Trailer 1
|
Trl1
|
x(2)
|
|
|
|
sah_trl2_amt
|
Trailer Amt 2
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
sah_trl2_cd
|
Trailer 2
|
Trl2
|
x(2)
|
|
|
|
sah_trl3_amt
|
Trailer Amt 3
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
sah_trl3_cd
|
Trailer 3
|
Trl3
|
x(2)
|
|
|
|
sah_trnbr
|
Transaction
|
|
>>>>>>>>>>>9
|
|
|
|
sah_type
|
Type
|
|
x(8)
|
|
|
|
sah_um
|
UM
|
|
x(2)
|
|
|
|
sah_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sah_user2
|
Ufld2
|
|
x(8)
|
|
|
|
sah_visits
|
Visits
|
|
>>9
|
10
|
|
|
sah_xcomm_pct[2]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
sah_xslspsn[2]
|
Salesperson
|
Salespsn
|
x(8)
|
0
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sah_hist
|
yes
|
oid_sah_hist
|
yes
|
no
|
|
|
sah_enduser
|
no
|
sah_domain
|
yes
|
no
|
|
|
|
|
sah_enduser
|
yes
|
no
|
|
|
|
|
sah_prefix
|
yes
|
no
|
|
|
|
|
sah_nbr
|
yes
|
no
|
|
|
sah_nbr
|
no
|
sah_domain
|
yes
|
no
|
|
|
|
|
sah_nbr
|
yes
|
no
|
|
|
|
|
sah_prefix
|
yes
|
no
|
|
|
|
|
sah_end_date
|
yes
|
no
|
|
∗
|
sah_trnbr
|
yes
|
sah_domain
|
yes
|
no
|
|
|
|
|
sah_trnbr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SalesCode
|
Code
|
|
x(20)
|
|
|
|
SalesCode_ID
|
Record ID
|
|
-99999999999
|
|
|
|
SalesCodeDescription
|
Description
|
|
x(40)
|
|
|
|
SalesCodeIsActive
|
Active
|
|
yes/no
|
|
|
|
SalesCodeType
|
Type
|
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Active
|
no
|
SalesCodeIsActive
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
SalesCode_ID
|
yes
|
no
|
|
|
SalesCode
|
yes
|
SalesCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
SalesCodeIsActive
|
yes
|
no
|
|
|
|
|
SalesCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CostOfSalesGL_ID
|
Link to CostOfSales
|
|
-99999999999
|
|
|
|
DebtorSalesCode_ID
|
Link to DebtorSalesCode
|
|
-99999999999
|
|
|
|
DiscountGL_ID
|
Link to DiscountGL
|
|
-99999999999
|
|
|
|
ItemSalesCode_ID
|
Link to ItemSalesCode
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SalesGL_ID
|
Link to SalesGL
|
|
-99999999999
|
|
|
|
SalesGLMatrix_ID
|
Record ID
|
|
-99999999999
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CostOfSalesGL
|
no
|
CostOfSalesGL_ID
|
yes
|
no
|
|
|
DebItemSet
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
DebtorSalesCode_ID
|
yes
|
no
|
|
|
|
|
ItemSalesCode_ID
|
yes
|
no
|
|
|
DebtorSalesCode
|
no
|
DebtorSalesCode_ID
|
yes
|
no
|
|
|
DiscountGL
|
no
|
DiscountGL_ID
|
yes
|
no
|
|
|
ItemSalesCode
|
no
|
ItemSalesCode_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
SalesGLMatrix_ID
|
yes
|
no
|
|
|
SalesGL
|
no
|
SalesGL_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_salh_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
salh__chr01
|
User Field #1
|
|
x(8)
|
|
|
|
salh__chr02
|
User Field #2
|
|
x(8)
|
|
|
|
salh__chr03
|
User Field #3
|
|
x(8)
|
|
|
|
salh__chr04
|
User Field #4
|
|
x(8)
|
|
|
|
salh__dec01
|
User Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
salh__dec02
|
User Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
salh__dec03
|
User Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
salh__dte01
|
User Date #1
|
|
99/99/99
|
|
|
|
salh__dte02
|
User Date #2
|
|
99/99/99
|
|
|
|
salh__dte03
|
User Date #3
|
|
99/99/99
|
|
|
|
salh__log01
|
User Logical #1
|
|
yes/no
|
|
|
|
salh__log02
|
User Logical #2
|
|
yes/no
|
|
|
|
salh__log03
|
User Logical #3
|
|
yes/no
|
|
|
|
salh__qadc01
|
Qad Field #1
|
|
x(8)
|
|
|
|
salh__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
salh__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
salh__qadc04
|
Qad Field #4
|
|
x(8)
|
|
|
|
salh__qadd01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
salh__qadd02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
salh__qadd03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
salh__qadd04
|
Qad Decimal #4
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
salh__qadl01
|
Qad Logical #1
|
|
yes/no
|
|
|
|
salh__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
salh__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
salh__qadl04
|
QAD Field
|
|
yes/no
|
|
|
|
salh__qadt01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
salh__qadt02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
salh__qadt03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
salh_budget
|
Budget
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
salh_ca_int_type
|
Work Code
|
|
x(8)
|
|
|
|
salh_call
|
Call
|
|
X(8)
|
0
|
|
|
salh_calls_allow
|
Calls Allowed
|
|
>>9
|
|
|
|
salh_calls_total
|
Total Calls
|
|
>>9
|
|
|
|
salh_category
|
Category
|
|
X(8)
|
0
|
|
|
salh_code
|
Limit Code
|
|
x(8)
|
|
|
|
salh_consumed_amt
|
Consumed Amount
|
Consumed
|
>>>>,>>>,>>9.99
|
10
|
|
|
salh_consumed_date
|
Activity Date
|
|
99/99/99
|
|
|
|
salh_days
|
Days of Coverage
|
|
>,>>>,>>9
|
|
|
|
salh_domain
|
Domain
|
|
x(8)
|
|
|
|
salh_end
|
End Date
|
|
99/99/99
|
|
|
|
salh_fcg_code
|
Charge Code
|
Charge
|
x(8)
|
|
|
|
salh_file
|
File
|
|
x(16)
|
|
|
|
salh_first_activity
|
First Activity
|
|
99/99/99
|
|
|
|
salh_fis_sort
|
Invoice Sort
|
|
x(18)
|
|
|
|
salh_fsc_code
|
Service Category
|
|
x(8)
|
|
|
|
salh_itm_line
|
Call Item
|
Line
|
>>9
|
|
|
|
salh_itm_part
|
Item Serviced
|
|
x(18)
|
|
|
|
salh_last_activity
|
Last Activity Date
|
|
99/99/99
|
|
|
|
salh_limit_amt
|
Limit Amount
|
Amount
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
salh_line
|
Line
|
|
>>9
|
|
|
|
salh_listpr_limit
|
List Price Limit
|
|
->>>>,>>>,>>9.99
|
10
|
|
|
salh_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
salh_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
salh_nbr
|
Number
|
|
x(10)
|
|
|
|
salh_op
|
Operation
|
Oper
|
>>>>>9
|
|
|
|
salh_ov_fcg_code
|
Over Limit Charge Code
|
Ovr Chg
|
x(8)
|
|
|
|
salh_pct_covered
|
Percent Covered
|
%Cv
|
>>9
|
10
|
|
|
salh_per_call
|
Per Call Limit
|
|
yes/no
|
|
|
|
salh_prefix
|
|
|
x(2)
|
|
|
|
salh_report
|
Report
|
|
X(8)
|
0
|
|
|
salh_sequence
|
Sequence
|
|
>>9
|
|
|
|
salh_start
|
Start
|
|
99/99/99
|
|
|
|
salh_total
|
Consumed
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
salh_trnbr
|
Trans
|
|
>>>>>>>>
|
|
|
|
salh_type
|
Type
|
|
x(2)
|
|
|
|
salh_unposted_amt
|
Unpost Amounts
|
|
->>>>,>>>,>>9.99
|
10
|
|
|
salh_usage
|
Usage
|
|
X(18)
|
0
|
|
|
salh_user1
|
Ufld1
|
|
x(8)
|
|
|
|
salh_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_salh_hist
|
yes
|
oid_salh_hist
|
yes
|
no
|
|
|
salh_call
|
no
|
salh_domain
|
yes
|
no
|
|
|
|
|
salh_category
|
yes
|
no
|
|
|
|
|
salh_call
|
yes
|
no
|
|
|
|
|
salh_itm_line
|
yes
|
no
|
|
|
|
|
salh_report
|
yes
|
no
|
|
|
|
|
salh_op
|
yes
|
no
|
|
|
|
|
salh_usage
|
yes
|
no
|
|
|
|
|
salh_trnbr
|
yes
|
no
|
|
|
salh_days
|
no
|
salh_domain
|
yes
|
no
|
|
|
|
|
salh_file
|
yes
|
no
|
|
|
|
|
salh_prefix
|
yes
|
no
|
|
|
|
|
salh_nbr
|
yes
|
no
|
|
|
|
|
salh_line
|
yes
|
no
|
|
|
|
|
salh_type
|
yes
|
no
|
|
|
|
|
salh_fis_sort
|
yes
|
no
|
|
|
|
|
salh_ca_int_type
|
yes
|
no
|
|
|
|
|
salh_fsc_code
|
yes
|
no
|
|
|
|
|
salh_sequence
|
yes
|
no
|
|
|
salh_nbr
|
no
|
salh_domain
|
yes
|
no
|
|
|
|
|
salh_file
|
yes
|
no
|
|
|
|
|
salh_prefix
|
yes
|
no
|
|
|
|
|
salh_nbr
|
yes
|
no
|
|
|
|
|
salh_line
|
yes
|
no
|
|
|
|
|
salh_type
|
yes
|
no
|
|
|
|
|
salh_fis_sort
|
yes
|
no
|
|
|
|
|
salh_ca_int_type
|
yes
|
no
|
|
|
|
|
salh_fsc_code
|
yes
|
no
|
|
|
|
|
salh_start
|
yes
|
no
|
|
|
|
|
salh_trnbr
|
yes
|
no
|
|
∗
|
salh_trnbr
|
yes
|
salh_domain
|
yes
|
no
|
|
|
|
|
salh_trnbr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sal_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sal__chr01
|
User Field #1
|
|
x(8)
|
|
|
|
sal__chr02
|
User Field #2
|
|
x(8)
|
|
|
|
sal__chr03
|
User Field #3
|
|
x(8)
|
|
|
|
sal__chr04
|
User Field #4
|
|
x(8)
|
|
|
|
sal__dec01
|
User Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sal__dec02
|
User Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sal__dec03
|
User Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sal__dte01
|
User Date #1
|
|
99/99/99
|
|
|
|
sal__dte02
|
User Date #2
|
|
99/99/99
|
|
|
|
sal__dte03
|
User Date #3
|
|
99/99/99
|
|
|
|
sal__log01
|
User Logical #1
|
|
yes/no
|
|
|
|
sal__log02
|
User Logical #2
|
|
yes/no
|
|
|
|
sal__log03
|
User Logical #3
|
|
yes/no
|
|
|
|
sal__qadc01
|
Qad Field #1
|
|
x(8)
|
|
|
|
sal__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
sal__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
sal__qadc04
|
Qad Field #4
|
|
x(8)
|
|
|
|
sal__qadd01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
sal__qadd02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
sal__qadd03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
sal__qadde01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sal__qadde02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sal__qadde03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sal__qadl01
|
Qad Logical #1
|
|
yes/no
|
|
|
|
sal__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
sal__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
sal__qadl04
|
QAD Field
|
|
yes/no
|
|
|
|
sal_bg_price
|
Price
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
sal_budget
|
Budget
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sal_ca_int_type
|
Work Code
|
Wk Code
|
x(8)
|
|
|
|
sal_calls_allow
|
Calls Allowed
|
|
>>9
|
|
|
|
sal_calls_total
|
Total Calls
|
|
>>9
|
|
|
|
sal_code
|
Limit Code
|
|
x(8)
|
|
|
|
sal_days
|
Days of Coverage
|
Days
|
>,>>>,>>9
|
|
|
|
sal_domain
|
Domain
|
|
x(8)
|
|
|
|
sal_end
|
End Date
|
|
99/99/99
|
|
|
|
sal_fcg_code
|
Charge Code
|
Charge
|
x(8)
|
|
|
|
sal_file
|
File
|
|
x(16)
|
|
|
|
sal_first_activity
|
First Activity
|
|
99/99/99
|
|
|
|
sal_fis_sort
|
Invoice Sort
|
|
x(18)
|
|
|
|
sal_fsc_code
|
Service Category
|
Svc Cat
|
x(8)
|
|
|
|
sal_last_activity
|
Last Activity
|
|
99/99/99
|
|
|
|
sal_limit_amt
|
Limit Amount
|
Amount
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sal_line
|
Line
|
|
>>>>>>>9
|
|
|
|
sal_listpr_limit
|
List Price Limit
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sal_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sal_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sal_nbr
|
Number
|
|
x(36)
|
|
|
|
sal_ov_fcg_code
|
Over Limit Charge Code
|
Ovr Chg
|
x(8)
|
|
|
|
sal_pct_covered
|
Percent Covered
|
%Cv
|
>>9
|
10
|
|
|
sal_per_call
|
Per Call Limit
|
Call
|
yes/no
|
|
|
|
sal_prefix
|
|
|
x(3)
|
|
|
|
sal_sequence
|
Sequence
|
Seq
|
>>9
|
|
|
|
sal_start
|
Start
|
|
99/99/99
|
|
|
|
sal_total
|
Consumed
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sal_type
|
Type
|
|
x(2)
|
|
|
|
sal_unposted_amt
|
Used/Unposted
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sal_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sal_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sal_mstr
|
yes
|
oid_sal_mstr
|
yes
|
no
|
|
|
sal_days
|
no
|
sal_domain
|
yes
|
no
|
|
|
|
|
sal_file
|
yes
|
no
|
|
|
|
|
sal_prefix
|
yes
|
no
|
|
|
|
|
sal_nbr
|
yes
|
no
|
|
|
|
|
sal_line
|
yes
|
no
|
|
|
|
|
sal_type
|
yes
|
no
|
|
|
|
|
sal_fis_sort
|
yes
|
no
|
|
|
|
|
sal_ca_int_type
|
yes
|
no
|
|
|
|
|
sal_fsc_code
|
yes
|
no
|
|
|
|
|
sal_sequence
|
yes
|
no
|
|
∗
|
sal_nbr
|
yes
|
sal_domain
|
yes
|
no
|
|
|
|
|
sal_file
|
yes
|
no
|
|
|
|
|
sal_prefix
|
yes
|
no
|
|
|
|
|
sal_nbr
|
yes
|
no
|
|
|
|
|
sal_line
|
yes
|
no
|
|
|
|
|
sal_type
|
yes
|
no
|
|
|
|
|
sal_fis_sort
|
yes
|
no
|
|
|
|
|
sal_ca_int_type
|
yes
|
no
|
|
|
|
|
sal_fsc_code
|
yes
|
no
|
|
|
|
|
sal_start
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sap_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sap__qadc01
|
QAD Characater Field 1
|
|
X(8)
|
|
|
|
sap__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
sap__qadd01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
sap__qadd02
|
QAD Date Field 2
|
|
99/99/99
|
|
|
|
sap__qadi01
|
QAD Integer Field 1
|
|
->,>>>,>>9
|
|
|
|
sap__qadi02
|
QAD Integer Field 2
|
|
->,>>>,>>9
|
|
|
|
sap__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
sap__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
sap_act_date
|
Actual Date
|
Actual
|
99/99/99
|
|
|
|
sap_assign
|
Assigned
|
|
X(8)
|
|
|
|
sap_bom_type
|
BOM Type
|
|
x(8)
|
|
|
|
sap_ca_nbr
|
Call ID
|
|
x(8)
|
|
|
|
sap_confirmed
|
MRP Confirmed
|
|
yes/no
|
|
|
|
sap_desc
|
Comments
|
|
x(34)
|
|
|
|
sap_domain
|
Domain
|
|
x(8)
|
|
|
|
sap_group
|
Schedule Group
|
|
x(8)
|
|
|
|
sap_line
|
Contract Line
|
|
>>>>>>>9
|
|
|
|
sap_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sap_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sap_mrp
|
Link to MRP
|
|
yes/no
|
|
|
|
sap_nbr
|
Contract Number
|
|
x(8)
|
|
|
|
sap_prefix
|
Prefix
|
|
x(2)
|
|
|
|
sap_sched_date
|
Schedule Date
|
Schedule
|
99/99/99
|
|
|
|
sap_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sap_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sap_det
|
yes
|
oid_sap_det
|
yes
|
no
|
|
|
sap_assign
|
no
|
sap_domain
|
yes
|
no
|
|
|
|
|
sap_assign
|
yes
|
no
|
|
|
|
|
sap_sched_date
|
yes
|
no
|
|
|
sap_grpsch
|
no
|
sap_domain
|
yes
|
no
|
|
|
|
|
sap_nbr
|
yes
|
no
|
|
|
|
|
sap_prefix
|
yes
|
no
|
|
|
|
|
sap_group
|
yes
|
no
|
|
|
|
|
sap_sched_date
|
yes
|
no
|
|
∗
|
sap_nbrln
|
yes
|
sap_domain
|
yes
|
no
|
|
|
|
|
sap_nbr
|
yes
|
no
|
|
|
|
|
sap_prefix
|
yes
|
no
|
|
|
|
|
sap_line
|
yes
|
no
|
|
|
|
|
sap_sched_date
|
yes
|
no
|
|
|
sap_sched
|
no
|
sap_domain
|
yes
|
no
|
|
|
|
|
sap_group
|
yes
|
no
|
|
|
|
|
sap_sched_date
|
yes
|
no
|
|
|
|
|
sap_prefix
|
yes
|
no
|
|
|
|
|
sap_nbr
|
yes
|
no
|
|
|
sap_sched_date
|
no
|
sap_domain
|
yes
|
no
|
|
|
|
|
sap_sched_date
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sar_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sar__chr01
|
|
|
x(8)
|
|
|
|
sar__chr02
|
|
|
x(8)
|
|
|
|
sar__chr03
|
|
|
x(8)
|
|
|
|
sar__dec01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
sar__dec02
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
sar__dte01
|
|
|
99/99/99
|
|
|
|
sar__dte02
|
|
|
99/99/99
|
|
|
|
sar__log01
|
|
|
yes/no
|
|
|
|
sar__log02
|
|
|
yes/no
|
|
|
|
sar__qadc01
|
|
|
x(8)
|
|
|
|
sar_domain
|
Domain
|
|
x(8)
|
|
|
|
sar_nbr
|
Service Contract
|
Contract
|
x(8)
|
|
|
|
sar_part
|
Item
|
|
x(18)
|
|
|
|
sar_prefix
|
Prefix
|
P
|
x(1)
|
|
|
|
sar_ref
|
Ref
|
|
x(18)
|
|
|
|
sar_sad_line
|
Contract Line
|
|
>>>>>>>9
|
|
|
|
sar_serial
|
Lot/Serial
|
|
x(18)
|
|
|
|
sar_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sar_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sar_mstr
|
yes
|
oid_sar_mstr
|
yes
|
no
|
|
∗
|
sar_nbrln
|
yes
|
sar_domain
|
yes
|
no
|
|
|
|
|
sar_nbr
|
yes
|
no
|
|
|
|
|
sar_prefix
|
yes
|
no
|
|
|
|
|
sar_sad_line
|
yes
|
no
|
|
|
|
|
sar_serial
|
yes
|
no
|
|
|
|
|
sar_ref
|
yes
|
no
|
|
|
sar_serial
|
no
|
sar_domain
|
yes
|
no
|
|
|
|
|
sar_prefix
|
yes
|
no
|
|
|
|
|
sar_serial
|
yes
|
no
|
|
|
|
|
sar_part
|
yes
|
no
|
|
|
|
|
sar_ref
|
yes
|
no
|
|
|
|
|
sar_nbr
|
yes
|
no
|
|
|
|
|
sar_sad_line
|
yes
|
no
|
|
|
sar_serialref
|
yes
|
sar_domain
|
yes
|
no
|
|
|
|
|
sar_part
|
yes
|
no
|
|
|
|
|
sar_serial
|
yes
|
no
|
|
|
|
|
sar_ref
|
yes
|
no
|
|
|
|
|
sar_prefix
|
yes
|
no
|
|
|
|
|
sar_nbr
|
yes
|
no
|
|
|
|
|
sar_sad_line
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sa_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sa__chr01
|
|
|
x(8)
|
|
|
|
sa__chr02
|
|
|
x(8)
|
|
|
|
sa__chr03
|
|
|
x(8)
|
|
|
|
sa__chr04
|
|
|
x(8)
|
|
|
|
sa__chr05
|
|
|
x(8)
|
|
|
|
sa__chr06
|
|
|
x(8)
|
|
|
|
sa__chr07
|
|
|
x(8)
|
|
|
|
sa__chr08
|
|
|
x(8)
|
|
|
|
sa__chr09
|
|
|
x(8)
|
|
|
|
sa__chr10
|
|
|
x(8)
|
|
|
|
sa__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sa__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sa__dec03
|
User Decimal Field
|
|
->>,>>9.99
|
10
|
|
|
sa__dte01
|
|
|
99/99/99
|
|
|
|
sa__dte02
|
|
|
99/99/99
|
|
|
|
sa__dte03
|
User Date Field
|
|
99/99/99
|
|
|
|
sa__log01
|
|
|
yes/no
|
|
|
|
sa__log02
|
User Logical field
|
|
yes/no
|
|
|
|
sa__log03
|
User Logical Field
|
|
yes/no
|
|
|
|
sa__qadc01
|
Qad Field #1
|
|
x(8)
|
|
|
|
sa__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
sa__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
sa__qadc04
|
Qad Field #4
|
|
x(8)
|
|
|
|
sa__qadc05[2]
|
|
|
x(8)
|
0
|
|
|
sa__qadd01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sa__qadd02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sa__qadd03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sa__qadl01
|
Qad Logical #1
|
|
yes/no
|
|
|
|
sa__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
sa__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
sa__qadl04
|
QAD Logical Field
|
|
yes/no
|
|
|
|
sa__qadt01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
sa__qadt02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
sa__qadt03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
sa_ar_acct
|
AR Account
|
AR
|
x(8)
|
|
|
|
sa_ar_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
sa_ar_sub
|
AR Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
sa_area
|
Area
|
|
x(8)
|
|
|
|
sa_arrears
|
Bill Arrears
|
Arrear
|
yes/no
|
|
|
|
sa_autornew
|
Auto Renew
|
A Renew
|
yes/no
|
|
|
|
sa_base_pct
|
Contract Base
|
|
>>>9.99<<<
|
10
|
|
|
sa_bill_cnt
|
Bill Count
|
Bill Cnt
|
->,>>>,>>9
|
|
|
|
sa_bill_enduser
|
Bill End Users
|
|
yes/no
|
|
|
|
sa_bill_summary
|
Bill Summary
|
|
yes/no
|
|
|
|
sa_bill_to
|
Bill To
|
|
x(8)
|
|
|
|
sa_bill_type
|
Billing Type
|
|
x(8)
|
|
|
|
sa_blanket
|
Blanket Contract
|
|
yes/no
|
|
|
|
sa_bol
|
BOL
|
|
x(18)
|
|
|
|
sa_call_price
|
Call Price List
|
Price
|
x(8)
|
|
|
|
sa_calls_allow
|
Calls Allowed
|
|
>>>,>>9
|
|
|
|
sa_calls_total
|
Total Calls
|
|
>>>,>>9
|
|
|
|
sa_can_tax
|
PST Pct
|
|
->>9.99<<%
|
10
|
|
|
sa_cancel
|
Cancel Date
|
|
99/99/99
|
|
|
|
sa_channel
|
Channel
|
|
x(8)
|
|
|
|
sa_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
sa_comm_pct[4]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
sa_complete
|
Complete
|
Cplt
|
yes/no
|
|
|
|
sa_conf_date
|
Confirmed Date
|
Confirmed
|
99/99/99
|
|
|
|
sa_cr_card
|
Credit Card
|
Card
|
x(2)
|
|
|
|
sa_cr_init
|
Cr Initials
|
Initials
|
x(3)
|
|
|
|
sa_cr_terms
|
Credit Terms
|
Terms
|
x(8)
|
|
|
|
sa_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
sa_cust
|
Customer
|
|
x(8)
|
|
|
|
sa_cycle
|
Billing Cycle
|
Cyc
|
x(2)
|
|
|
|
sa_date_printed
|
Date Printed
|
|
99/99/99
|
|
|
|
sa_daybookset
|
Daybook Set
|
Dybk Set
|
x(8)
|
|
|
|
sa_disc_pct
|
Disc %
|
|
->9.99%
|
10
|
|
|
sa_domain
|
Domain
|
|
x(8)
|
|
|
|
sa_end_date
|
End Date
|
|
99/99/99
|
|
|
|
sa_enduser
|
End User
|
|
x(8)
|
|
|
|
sa_ent_ex
|
Exch Rate
|
|
>>,>>9.99999<<<<<
|
10
|
|
|
sa_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sa_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sa_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
sa_exp_date
|
Expire Date
|
Exp Date
|
99/99/99
|
|
|
|
sa_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
sa_ext_date
|
Extend Date
|
Ext Date
|
99/99/9999
|
|
|
|
sa_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
sa_fix_rate
|
Fixed Rate
|
Fixed
|
yes/no
|
|
|
|
sa_fob
|
FOB Point
|
|
x(20)
|
|
|
|
sa_free_frm
|
Free Coverage From
|
|
99/99/99
|
|
|
|
sa_free_to
|
Free Coverage To
|
|
99/99/99
|
|
|
|
sa_fsaccr_acct
|
Accrued Revenue
|
Accrued
|
x(8)
|
|
|
|
sa_fsaccr_cc
|
Accrued Revenue CC
|
|
x(4)
|
|
|
|
sa_fsaccr_sub
|
Accrued Revenue Sub-Acct
|
|
x(8)
|
|
|
|
sa_fsdef_acct
|
Deferred Revenue
|
Deferred
|
x(8)
|
|
|
|
sa_fsdef_cc
|
Deferred Revenue CC
|
|
x(4)
|
|
|
|
sa_fsdef_sub
|
Deferred Revenue Sub-Acct
|
|
x(8)
|
|
|
|
sa_fst_id
|
FST ID
|
|
x(18)
|
|
|
|
sa_gen_0itm
|
Generate 0$ Items
|
|
yes/no
|
|
|
|
sa_hold
|
Hold Contract
|
Hld
|
yes/no
|
|
|
|
sa_inv_date
|
Invoice Date
|
Inv Date
|
99/99/99
|
|
|
|
sa_invoiced
|
Invoiced
|
|
yes/no
|
|
|
|
sa_item_enduser
|
Item End Users
|
|
yes/no
|
|
|
|
sa_lang
|
Language
|
|
x(2)
|
|
|
|
sa_last_bill
|
Last Billed
|
Last Bill
|
99/99/99
|
|
|
|
sa_limit_copy
|
Renew Limits From
|
|
X(1)
|
|
|
|
sa_lst_bill
|
Last Bill
|
|
99/99/99
|
|
|
|
sa_lst_cover
|
Last Bill
|
Lst Bill
|
99/99/99
|
|
|
|
sa_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sa_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sa_mref
|
Master Contract
|
Master
|
x(8)
|
|
|
|
sa_mrp
|
Link to MRP
|
|
yes/no
|
|
|
|
sa_nbr
|
Number
|
|
x(8)
|
0
|
|
|
sa_next_dur
|
Next Duration
|
|
>>9.99
|
10
|
|
|
sa_nxt_bill
|
Next Bill
|
|
99/99/99
|
|
|
|
sa_off_hours_pt
|
Off Hours Item
|
|
x(18)
|
|
|
|
sa_ord_date
|
Order Date
|
Ord Date
|
99/99/99
|
|
|
|
sa_orig_date
|
Original Start
|
|
99/99/99
|
|
|
|
sa_per_bill
|
Period Based Billing
|
PBB
|
yes/no
|
|
|
|
sa_periodic
|
Periodic Billing
|
|
yes/no
|
|
|
|
sa_po
|
Purchase Order
|
|
x(20)
|
|
|
|
sa_pr_list
|
Price List
|
List
|
x(8)
|
|
|
|
sa_pr_list2
|
List Price List
|
List
|
x(8)
|
|
|
|
sa_prefix
|
Pf
|
|
x(1)
|
|
|
|
sa_prepaid
|
Prepaid
|
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
sa_print
|
Print Sales Order
|
Print SO
|
yes/no
|
|
|
|
sa_print_pl
|
Print Pack List
|
Print Pack
|
yes/no
|
|
|
|
sa_prodline
|
Product Line
|
Line
|
x(4)
|
|
|
|
sa_project
|
Project
|
|
x(8)
|
|
|
|
sa_prorate
|
Prorate Partial Periods
|
Pro
|
yes/no
|
|
|
|
sa_prt_0itm
|
Print 0$ Items
|
|
yes/no
|
|
|
|
sa_pst
|
PST
|
|
yes/no
|
|
|
|
sa_pst_id
|
PST ID
|
|
x(18)
|
|
|
|
sa_qty_per
|
Duration
|
|
->>>9.9<<<
|
10
|
|
|
sa_qty_plst
|
Last Qty Billed
|
Last Qty
|
->>>9.9<<<
|
10
|
|
|
sa_quote
|
Quote
|
|
x(8)
|
|
|
|
sa_quote_mod
|
Quote Modified
|
|
yes/no
|
|
|
|
sa_rel_date
|
Release Date
|
Rel Date
|
99/99/99
|
|
|
|
sa_release
|
Release To Contract
|
Rel
|
yes/no
|
|
|
|
sa_renew_count
|
Renewal Count
|
|
>>9
|
|
|
|
sa_renew_periods
|
Renewal Periods
|
|
>>9
|
|
|
|
sa_renewal_date
|
Renewal Date
|
|
99/99/99
|
|
|
|
sa_renewed_from
|
Renewed From
|
|
X(8)
|
|
|
|
sa_renewed_to
|
Renewed To
|
|
X(8)
|
|
|
|
sa_reval_index
|
Index Month
|
|
>>9
|
|
|
|
sa_reval_period
|
Revaluation Period
|
|
>>9
|
|
|
|
sa_revalue_date
|
Revaluation Date
|
|
99/99/99
|
|
|
|
sa_revenue
|
Revenue Type
|
|
x(1)
|
|
|
|
sa_reviewed
|
Reviewed
|
|
yes/no
|
|
|
|
sa_rmks
|
Remarks
|
|
x(40)
|
|
|
|
sa_rsn_lost
|
Reason Lost
|
|
x(8)
|
|
|
|
sa_sa_type
|
Type
|
|
x(8)
|
|
|
|
sa_sched_start
|
PM Start Date
|
Start
|
yes/no
|
|
|
|
sa_schedule
|
Billing Schedule File
|
|
yes/no
|
|
|
|
sa_serial_det
|
Serial Detail
|
|
yes/no
|
|
|
|
sa_ship_date
|
Ship Date
|
|
99/99/99
|
|
|
|
sa_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
sa_site
|
Site
|
|
x(8)
|
|
|
|
sa_slspsn[4]
|
Salesperson
|
Salespsn
|
X(8)
|
0
|
|
|
sa_so_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
sa_source
|
Order Source
|
Source
|
x(8)
|
|
|
|
sa_st_cover
|
Coverage
|
|
99/99/99
|
|
|
|
sa_st_date
|
Start Date
|
|
99/99/99
|
|
|
|
sa_stat
|
Action Status
|
St
|
x(2)
|
|
|
|
sa_summarize
|
Summarize
|
|
yes/no
|
|
|
|
sa_sv_code
|
Service Type
|
Svc Type
|
x(8)
|
|
|
|
sa_tax_date
|
Tax Date
|
|
99/99/99
|
|
|
|
sa_tax_env
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
sa_tax_pct[3]
|
Tax
|
|
->9.99%
|
10
|
|
|
sa_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
sa_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
sa_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
sa_total_billed
|
Total Billed
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sa_total_cost
|
Total Cost
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sa_trl1_amt
|
Trailer Amt 1
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
sa_trl1_cd
|
Trailer 1
|
Trl1
|
x(2)
|
|
|
|
sa_trl2_amt
|
Trailer Amt 2
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
sa_trl2_cd
|
Trailer 2
|
Trl2
|
x(2)
|
|
|
|
sa_trl3_amt
|
Trailer Amt 3
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
sa_trl3_cd
|
Trailer 3
|
Trl3
|
x(2)
|
|
|
|
sa_type
|
Type
|
|
x(8)
|
|
|
|
sa_um
|
UM
|
|
x(2)
|
|
|
|
sa_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sa_user2
|
Ufld2
|
|
x(8)
|
|
|
|
sa_visits
|
Visits
|
|
>>9
|
10
|
|
|
sa_xcomm_pct[2]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sa_mstr
|
yes
|
oid_sa_mstr
|
yes
|
no
|
|
|
sa_cust
|
yes
|
sa_domain
|
yes
|
no
|
|
|
|
|
sa_cust
|
yes
|
no
|
|
|
|
|
sa_prefix
|
yes
|
no
|
|
|
|
|
sa_nbr
|
yes
|
no
|
|
|
sa_end_date
|
no
|
sa_domain
|
yes
|
no
|
|
|
|
|
sa_end_date
|
yes
|
no
|
|
|
sa_enduser
|
no
|
sa_domain
|
yes
|
no
|
|
|
|
|
sa_enduser
|
yes
|
no
|
|
|
|
|
sa_prefix
|
yes
|
no
|
|
|
|
|
sa_nbr
|
yes
|
no
|
|
∗
|
sa_nbr
|
yes
|
sa_domain
|
yes
|
no
|
|
|
|
|
sa_nbr
|
yes
|
no
|
|
|
|
|
sa_prefix
|
yes
|
no
|
|
|
sa_po_nbr
|
no
|
sa_domain
|
yes
|
no
|
|
|
|
|
sa_po
|
yes
|
no
|
|
|
|
|
sa_cust
|
yes
|
no
|
|
|
|
|
sa_nbr
|
yes
|
no
|
|
|
|
|
sa_prefix
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sbc_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sbc__chr01
|
|
|
x(8)
|
|
|
|
sbc__chr02
|
|
|
x(8)
|
|
|
|
sbc__chr03
|
|
|
x(8)
|
|
|
|
sbc__chr04
|
|
|
x(8)
|
|
|
|
sbc__chr05
|
|
|
x(8)
|
|
|
|
sbc__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
sbc__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
sbc__qadc03
|
QAD Character Field 3
|
|
X(8)
|
|
|
|
sbc__qadd01
|
QAD Decimal Field 1
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
sbc__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
sbc_code
|
Cycle
|
|
x(2)
|
|
|
|
sbc_desc
|
Description
|
|
x(24)
|
|
|
|
sbc_domain
|
Domain
|
|
x(8)
|
|
|
|
sbc_duration
|
Length
|
|
>>>>>9
|
|
|
|
sbc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sbc_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sbc_qty_bill
|
Qty to Bill
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
sbc_um
|
UM
|
|
x(2)
|
|
|
|
sbc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sbc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sbc_mstr
|
yes
|
oid_sbc_mstr
|
yes
|
no
|
|
∗
|
sbc_code
|
yes
|
sbc_domain
|
yes
|
no
|
|
|
|
|
sbc_code
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sbd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sbd__qadc01
|
|
|
x(8)
|
|
|
|
sbd_acc_beg
|
Range of Accounts
|
From!Account
|
x(8)
|
|
|
|
sbd_acc_end
|
To
|
To!Account
|
x(8)
|
|
|
|
sbd_line
|
Line
|
|
>>9
|
|
|
|
sbd_sub
|
Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
sbd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sbd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sbd_det
|
yes
|
oid_sbd_det
|
yes
|
no
|
|
∗
|
sbd_index
|
yes
|
sbd_sub
|
yes
|
no
|
|
|
|
|
sbd_line
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sbic_ctl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sbic__qadc01
|
|
|
X(8)
|
|
|
|
sbic__qadc02
|
|
|
X(8)
|
|
|
|
sbic__qadc03
|
|
|
X(8)
|
|
|
|
sbic__qadc04
|
|
|
X(8)
|
|
|
|
sbic__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbic__qadd02
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbic__qadd03
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbic__qadd04
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbic__qadi01
|
|
|
>>>>>>9
|
|
|
|
sbic__qadi02
|
|
|
>>>>>>9
|
|
|
|
sbic__qadi03
|
|
|
>>>>>>9
|
|
|
|
sbic__qadi04
|
|
|
>>>>>>9
|
|
|
|
sbic__qadl01
|
|
|
yes/no
|
|
|
|
sbic__qadl02
|
|
|
yes/no
|
|
|
|
sbic__qadl03
|
|
|
yes/no
|
|
|
|
sbic__qadl04
|
|
|
yes/no
|
|
|
|
sbic__qadt01
|
|
|
99/99/99
|
|
|
|
sbic__qadt02
|
|
|
99/99/99
|
|
|
|
sbic__qadt03
|
|
|
99/99/99
|
|
|
|
sbic__qadt04
|
|
|
99/99/99
|
|
|
|
sbic_active
|
Enable Self-Billing
|
|
yes/no
|
|
|
|
sbic_daybook
|
Self-Bill Daybook
|
|
x(8)
|
|
|
|
sbic_domain
|
Domain
|
|
x(8)
|
|
|
|
sbic_index1
|
Index
|
|
>>>>>9
|
|
|
|
sbic_next_sb
|
Next Self-Bill
|
|
>>>>>>>>>>>>>>>>>>>9
|
|
|
|
sbic_prefix
|
Self-Bill Prefix
|
|
X(3)
|
|
|
|
sbic_user1
|
Ufld1
|
|
X(8)
|
|
|
|
sbic_user2
|
Ufld2
|
|
X(8)
|
|
|
|
sbic_user3
|
|
|
X(8)
|
|
|
|
sbic_user4
|
|
|
X(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sbic_ctl
|
yes
|
oid_sbic_ctl
|
yes
|
no
|
|
∗
|
sbic_index1
|
yes
|
sbic_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sbid_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sbid__qadc01
|
|
|
X(8)
|
|
|
|
sbid__qadc02
|
|
|
X(8)
|
|
|
|
sbid__qadc03
|
|
|
X(8)
|
|
|
|
sbid__qadc04
|
|
|
X(8)
|
|
|
|
sbid__qadc05
|
|
|
X(8)
|
|
|
|
sbid__qadc06
|
|
|
X(8)
|
|
|
|
sbid__qadc07
|
|
|
X(8)
|
|
|
|
sbid__qadc08
|
|
|
X(8)
|
|
|
|
sbid__qadc09
|
|
|
X(8)
|
|
|
|
sbid__qadc10
|
|
|
X(8)
|
|
|
|
sbid__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbid__qadd02
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbid__qadd03
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbid__qadd04
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbid__qadd05
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbid__qadi01
|
|
|
>>>>>>9
|
|
|
|
sbid__qadi02
|
|
|
>>>>>>9
|
|
|
|
sbid__qadi03
|
|
|
>>>>>>9
|
|
|
|
sbid__qadi04
|
|
|
>>>>>>9
|
|
|
|
sbid__qadi05
|
|
|
>>>>>>9
|
|
|
|
sbid__qadl01
|
|
|
yes/no
|
|
|
|
sbid__qadl02
|
|
|
yes/no
|
|
|
|
sbid__qadl03
|
|
|
yes/no
|
|
|
|
sbid__qadl04
|
|
|
yes/no
|
|
|
|
sbid__qadl05
|
|
|
yes/no
|
|
|
|
sbid__qadt01
|
|
|
99/99/99
|
|
|
|
sbid__qadt02
|
|
|
99/99/99
|
|
|
|
sbid__qadt03
|
|
|
99/99/99
|
|
|
|
sbid__qadt04
|
|
|
99/99/99
|
|
|
|
sbid__qadt05
|
|
|
99/99/99
|
|
|
|
sbid_amt
|
Paid Amount
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
sbid_authorization
|
Authorization
|
|
x(24)
|
|
|
|
sbid_bill
|
Bill-To
|
|
x(8)
|
|
|
|
sbid_cust
|
Sold-To
|
|
x(8)
|
|
|
|
sbid_custref
|
Customer Ref
|
|
x(30)
|
|
|
|
sbid_domain
|
Domain
|
|
x(8)
|
|
|
|
sbid_inv_nbr
|
Invoice/Memo
|
Inv/Memo
|
x(22)
|
|
|
|
sbid_line
|
Line
|
|
>>>,>>9
|
|
|
|
sbid_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sbid_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sbid_modelyr
|
Model Year
|
|
x(4)
|
|
|
|
sbid_nbr
|
Self-Bill
|
|
x(20)
|
|
|
|
sbid_order
|
Sales Order
|
SO
|
x(8)
|
|
|
|
sbid_origin
|
Origin
|
O
|
x(1)
|
|
|
|
sbid_part
|
Self-Bill Item
|
|
x(30)
|
|
|
|
sbid_po
|
Customer PO
|
|
x(22)
|
|
|
|
sbid_price
|
Paid Price
|
|
>>,>>>,>>9.99<<<
|
10
|
|
|
sbid_qty
|
Paid Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
sbid_remarks
|
Remarks
|
|
x(40)
|
|
|
|
sbid_ship_id
|
Shipper
|
|
x(20)
|
|
|
|
sbid_tax_amt
|
Tax Amt
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
sbid_tax_pct
|
Tax Rate
|
|
->>9.99<<%
|
10
|
|
|
sbid_trnbr
|
Trans
|
|
>>>>>>>>
|
|
|
|
sbid_type
|
Type
|
T
|
x(1)
|
|
|
|
sbid_um
|
UM
|
|
x(2)
|
|
|
|
sbid_user1
|
Ufld1
|
|
X(8)
|
|
|
|
sbid_user2
|
Ufld2
|
|
X(8)
|
|
|
|
sbid_user3
|
|
|
X(8)
|
|
|
|
sbid_user4
|
|
|
X(8)
|
|
|
|
sbid_user5
|
|
|
X(8)
|
|
|
|
sbid_user6
|
|
|
X(8)
|
|
|
|
sbid_user7
|
|
|
X(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sbid_det
|
yes
|
oid_sbid_det
|
yes
|
no
|
|
|
sbid_authorization
|
no
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_authorization
|
yes
|
no
|
|
|
sbid_inv_nbr
|
no
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_inv_nbr
|
yes
|
no
|
|
∗
|
sbid_nbr_line
|
yes
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_bill
|
yes
|
no
|
|
|
|
|
sbid_nbr
|
yes
|
no
|
|
|
|
|
sbid_line
|
yes
|
no
|
|
|
sbid_order
|
no
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_order
|
yes
|
no
|
|
|
sbid_part
|
no
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_part
|
yes
|
no
|
|
|
|
|
sbid_type
|
yes
|
no
|
|
|
sbid_ship_id
|
no
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_ship_id
|
yes
|
no
|
|
|
sbid_trnbr
|
no
|
sbid_domain
|
yes
|
no
|
|
|
|
|
sbid_trnbr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sbi_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sbi__qadc01
|
|
|
X(8)
|
|
|
|
sbi__qadc02
|
|
|
X(8)
|
|
|
|
sbi__qadc03
|
|
|
X(8)
|
|
|
|
sbi__qadc04
|
|
|
X(8)
|
|
|
|
sbi__qadc05
|
|
|
X(8)
|
|
|
|
sbi__qadc06
|
|
|
X(8)
|
|
|
|
sbi__qadc07
|
|
|
X(8)
|
|
|
|
sbi__qadc08
|
|
|
X(8)
|
|
|
|
sbi__qadc09
|
|
|
X(8)
|
|
|
|
sbi__qadc10
|
|
|
X(8)
|
|
|
|
sbi__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbi__qadd02
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbi__qadd03
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbi__qadd04
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbi__qadd05
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sbi__qadi01
|
|
|
>>>>>>9
|
|
|
|
sbi__qadi02
|
|
|
>>>>>>9
|
|
|
|
sbi__qadi03
|
|
|
>>>>>>9
|
|
|
|
sbi__qadi04
|
|
|
>>>>>>9
|
|
|
|
sbi__qadi05
|
|
|
>>>>>>9
|
|
|
|
sbi__qadl01
|
|
|
yes/no
|
|
|
|
sbi__qadl02
|
|
|
yes/no
|
|
|
|
sbi__qadl03
|
|
|
yes/no
|
|
|
|
sbi__qadl04
|
|
|
yes/no
|
|
|
|
sbi__qadl05
|
|
|
yes/no
|
|
|
|
sbi__qadt01
|
|
|
99/99/99
|
|
|
|
sbi__qadt02
|
|
|
99/99/99
|
|
|
|
sbi__qadt03
|
|
|
99/99/99
|
|
|
|
sbi__qadt04
|
|
|
99/99/99
|
|
|
|
sbi__qadt05
|
|
|
99/99/99
|
|
|
|
sbi_amt
|
Amt Total
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
sbi_bill
|
Bill-To
|
|
x(8)
|
|
|
|
sbi_check
|
Check
|
|
x(8)
|
|
|
|
sbi_confirm
|
Confirm
|
|
yes/no
|
|
|
|
sbi_ctrl_amt
|
Amt Control Total
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
sbi_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
sbi_domain
|
Domain
|
|
x(8)
|
|
|
|
sbi_lines
|
Lines
|
|
>>>>>9
|
|
|
|
sbi_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sbi_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sbi_nbr
|
Self-Bill
|
|
x(20)
|
|
|
|
sbi_resp_date
|
Response Date
|
Response
|
99/99/99
|
|
|
|
sbi_user1
|
Ufld1
|
|
X(8)
|
|
|
|
sbi_user2
|
Ufld2
|
|
X(8)
|
|
|
|
sbi_user3
|
|
|
X(8)
|
|
|
|
sbi_user4
|
|
|
X(8)
|
|
|
|
sbi_user5
|
|
|
X(8)
|
|
|
|
sbi_xmission
|
Transmission
|
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sbi_mstr
|
yes
|
oid_sbi_mstr
|
yes
|
no
|
|
|
sbi_check
|
no
|
sbi_domain
|
yes
|
no
|
|
|
|
|
sbi_bill
|
yes
|
no
|
|
|
|
|
sbi_check
|
yes
|
no
|
|
|
|
|
sbi_nbr
|
yes
|
no
|
|
∗
|
sbi_nbr
|
yes
|
sbi_domain
|
yes
|
no
|
|
|
|
|
sbi_bill
|
yes
|
no
|
|
|
|
|
sbi_nbr
|
yes
|
no
|
|
|
sbi_xmission
|
no
|
sbi_domain
|
yes
|
no
|
|
|
|
|
sbi_bill
|
yes
|
no
|
|
|
|
|
sbi_xmission
|
yes
|
no
|
|
|
|
|
sbi_nbr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sb_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sb__qadc01
|
|
|
x(8)
|
|
|
|
sb_active
|
Active
|
Act
|
yes/no
|
|
|
|
sb_desc
|
Description
|
|
x(24)
|
|
|
|
sb_domain
|
Domain
|
|
x(8)
|
|
|
|
sb_sub
|
Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
sb_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sb_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sb_mstr
|
yes
|
oid_sb_mstr
|
yes
|
no
|
|
|
sb_desc
|
no
|
sb_domain
|
yes
|
no
|
|
|
|
|
sb_desc
|
yes
|
no
|
|
∗
|
sb_sub
|
yes
|
sb_domain
|
yes
|
no
|
|
|
|
|
sb_sub
|
yes
|
no
|
|
|
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
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_scc_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
scc__qadc01
|
|
|
X(24)
|
|
|
|
scc__qadc02
|
|
|
X(24)
|
|
|
|
scc_active
|
Enable Shipment Performance
|
|
yes/no
|
|
|
|
scc_customer_source
|
Customer Source
|
|
x(3)
|
|
|
|
scc_domain
|
Domain
|
|
x(8)
|
|
|
|
scc_include_do
|
Include Distribution Orders
|
|
yes/no
|
|
|
|
scc_include_mo
|
Include Material Orders
|
|
yes/no
|
|
|
|
scc_include_rma
|
Include RMA Shipments
|
|
yes/no
|
|
|
|
scc_include_sched
|
Include Scheduled Orders
|
|
yes/no
|
|
|
|
scc_include_so
|
Include Sales Orders
|
|
yes/no
|
|
|
|
scc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
scc_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
scc_part
|
Item Number
|
|
x(18)
|
|
|
|
scc_receive_addr
|
Receive Address
|
|
x(8)
|
|
|
|
scc_sched_type
|
Schedule Type
|
|
>9
|
|
|
|
scc_ship_lt
|
Transit Lead Time
|
|
>>9
|
|
|
|
scc_shipfrom
|
Ship-From
|
|
x(8)
|
|
|
|
scc_use_current
|
Use Current Release
|
|
yes/no
|
|
|
|
scc_user1
|
User Field Character 1
|
|
X(24)
|
|
|
|
scc_user2
|
User Field Character 2
|
|
X(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_scc_mstr
|
yes
|
oid_scc_mstr
|
yes
|
no
|
|
∗
|
scc_customer_source
|
yes
|
scc_domain
|
yes
|
no
|
|
|
|
|
scc_customer_source
|
yes
|
no
|
|
|
|
|
scc_shipfrom
|
yes
|
no
|
|
|
|
|
scc_receive_addr
|
yes
|
no
|
|
|
|
|
scc_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_schd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
schd__chr01
|
|
|
x(8)
|
|
|
|
schd__chr02
|
|
|
x(8)
|
|
|
|
schd__chr03
|
|
|
x(8)
|
|
|
|
schd__chr04
|
|
|
x(8)
|
|
|
|
schd__chr05
|
|
|
x(8)
|
|
|
|
schd__chr06
|
|
|
x(8)
|
|
|
|
schd__chr07
|
|
|
x(8)
|
|
|
|
schd__chr08
|
|
|
x(8)
|
|
|
|
schd__chr09
|
|
|
x(8)
|
|
|
|
schd__chr10
|
|
|
x(8)
|
|
|
|
schd__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
schd__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
schd__dec03
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
schd__dec04
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
schd__dec05
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
schd__dec06
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
schd__dec07
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
schd__dec08
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
schd__dec09
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
schd__dec10
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
schd__dte01
|
|
|
99/99/99
|
|
|
|
schd__dte02
|
|
|
99/99/99
|
|
|
|
schd__log01
|
|
|
yes/no
|
|
|
|
schd__log02
|
|
|
yes/no
|
|
|
|
schd_all_qty
|
Qty Pegged
|
|
>,>>>,>>9.9<<<<
|
10
|
|
|
schd_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
schd_cum_qty
|
Cumulative Qty
|
|
>>>,>>>,>>9.9<<<<<<
|
10
|
|
|
schd_date
|
Date
|
|
99/99/99
|
|
|
|
schd_discr_qty
|
Discrete Qty
|
|
>>,>>>,>>9.9<<<<<<<
|
10
|
|
|
schd_domain
|
Domain
|
|
x(8)
|
|
|
|
schd_fc_qual
|
Q
|
|
x(1)
|
|
|
|
schd_interval
|
Interval
|
|
x(1)
|
|
|
|
schd_leadtime
|
Lead Time
|
|
->>>9
|
|
|
|
schd_line
|
Line
|
Ln
|
>>9
|
|
|
|
schd_nbr
|
Order
|
Sls Order
|
x(8)
|
|
|
|
schd_per_date
|
Perform Date
|
Perform
|
99/99/99
|
|
|
|
schd_reference
|
Reference
|
|
x(24)
|
|
|
|
schd_reference_type
|
Reference Type
|
Ref!Type
|
x(2)
|
|
|
|
schd_req_type
|
Requirement Type
|
|
>9
|
|
|
|
schd_rlse_id
|
Release ID
|
|
x(30)
|
|
|
|
schd_ship_qty
|
Qty Shipped
|
|
>>,>>>,>>9.9<<<<<<<
|
10
|
|
|
schd_time
|
Time
|
|
99:99
|
|
|
|
schd_type
|
Schedule Type
|
|
>9
|
|
|
|
schd_upd_qty
|
Quantity
|
|
>>,>>>,>>9.9<<<<<<<
|
10
|
|
|
schd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
schd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_schd_det
|
yes
|
oid_schd_det
|
yes
|
no
|
|
∗
|
schd_dtr
|
yes
|
schd_domain
|
yes
|
no
|
|
|
|
|
schd_type
|
yes
|
no
|
|
|
|
|
schd_nbr
|
yes
|
no
|
|
|
|
|
schd_line
|
yes
|
no
|
|
|
|
|
schd_rlse_id
|
yes
|
no
|
|
|
|
|
schd_date
|
yes
|
no
|
|
|
|
|
schd_time
|
yes
|
no
|
|
|
|
|
schd_interval
|
yes
|
no
|
|
|
|
|
schd_reference
|
yes
|
no
|
|
|
|
|
schd_req_type
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sch_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sch__chr01
|
|
|
x(8)
|
|
|
|
sch__chr02
|
|
|
x(8)
|
|
|
|
sch__chr03
|
|
|
x(8)
|
|
|
|
sch__chr04
|
|
|
x(8)
|
|
|
|
sch__chr05
|
|
|
x(8)
|
|
|
|
sch__chr06
|
|
|
x(8)
|
|
|
|
sch__chr07
|
|
|
x(8)
|
|
|
|
sch__chr08
|
|
|
x(8)
|
|
|
|
sch__chr09
|
|
|
x(8)
|
|
|
|
sch__chr10
|
|
|
x(8)
|
|
|
|
sch__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sch__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sch__dec03
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sch__dec04
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sch__dec05
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sch__dec06
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sch__dec07
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sch__dec08
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sch__dec09
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sch__dec10
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sch__dte01
|
|
|
99/99/99
|
|
|
|
sch__dte02
|
|
|
99/99/99
|
|
|
|
sch__log01
|
|
|
yes/no
|
|
|
|
sch__log02
|
|
|
yes/no
|
|
|
|
sch_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
sch_cr_date
|
Create Date
|
|
99/99/99
|
|
|
|
sch_cr_time
|
Create Time
|
|
>>>>9
|
|
|
|
sch_cumulative
|
Cumulative
|
Cum
|
yes/no
|
|
|
|
sch_cw_days
|
Calendar/Working Firm Days
|
|
x(1)
|
|
|
|
sch_domain
|
Domain
|
|
x(8)
|
|
|
|
sch_eff_end
|
Effective End
|
|
99/99/99
|
|
|
|
sch_eff_start
|
Effective Start
|
|
99/99/99
|
|
|
|
sch_fab_end
|
Fab End
|
|
99/99/99
|
|
|
|
sch_fab_qty
|
Fab Qty
|
|
>>>,>>>,>>9.9<<<<<<
|
10
|
|
|
sch_fab_strt
|
Fab Start
|
|
99/99/99
|
|
|
|
sch_from_pid
|
From Plan Id
|
|
x(30)
|
|
|
|
sch_from_sid
|
From Ship Id
|
|
x(30)
|
|
|
|
sch_line
|
Line
|
Ln
|
>>9
|
|
|
|
sch_lr_asn[10]
|
ASN/Shipper Nbr
|
|
x(24)
|
|
|
|
sch_lr_cum_qty[10]
|
Cum Receipt Qty
|
|
>>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
sch_lr_date[10]
|
Receipt Date
|
|
99/99/99
|
|
|
|
sch_lr_qty[10]
|
Receipt Qty
|
|
>>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
sch_lr_time[10]
|
Time
|
|
99:99
|
|
|
|
sch_nbr
|
Order
|
Sls Order
|
x(8)
|
|
|
|
sch_pcr_qty
|
Prior Cum Req
|
|
>>>,>>>,>>9.9<<<<<<
|
10
|
|
|
sch_pcs_date
|
Prior Cum Date
|
|
99/99/99
|
|
|
|
sch_pdr_qty
|
Prior Discrete Req
|
|
>>>,>>>,>>9.9<<<<<<
|
10
|
|
|
sch_prp_ext
|
Ext Purpose Code
|
|
x(10)
|
|
|
|
sch_prp_int
|
Int Purpose Code
|
|
x(10)
|
|
|
|
sch_raw_end
|
Raw End
|
|
99/99/99
|
|
|
|
sch_raw_qty
|
Raw Qty
|
|
>>>,>>>,>>9.9<<<<<<
|
10
|
|
|
sch_raw_strt
|
Raw Start
|
|
99/99/99
|
|
|
|
sch_rlse_id
|
Release ID
|
|
x(30)
|
|
|
|
sch_sd_dates
|
Schedule Date Type
|
|
Ship/Delivery
|
|
|
|
sch_sd_pat
|
Ship/Dlvy Pattern
|
|
x(2)
|
|
|
|
sch_sd_time
|
Ship/Dlvy Time
|
|
x(2)
|
|
|
|
sch_ship
|
Ship To
|
|
x(8)
|
|
|
|
sch_type
|
Schedule Type
|
|
>9
|
|
|
|
sch_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sch_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sch_mstr
|
yes
|
oid_sch_mstr
|
yes
|
no
|
|
|
sch_cr_date
|
no
|
sch_domain
|
yes
|
no
|
|
|
|
|
sch_type
|
yes
|
no
|
|
|
|
|
sch_nbr
|
yes
|
no
|
|
|
|
|
sch_line
|
yes
|
no
|
|
|
|
|
sch_cr_date
|
yes
|
no
|
|
|
|
|
sch_cr_time
|
yes
|
no
|
|
∗
|
sch_tnlr
|
yes
|
sch_domain
|
yes
|
no
|
|
|
|
|
sch_type
|
yes
|
no
|
|
|
|
|
sch_nbr
|
yes
|
no
|
|
|
|
|
sch_line
|
yes
|
no
|
|
|
|
|
sch_rlse_id
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_scs_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
scs__qadc01
|
|
|
x(24)
|
|
|
|
scs__qadc02
|
|
|
x(24)
|
|
|
|
scs_domain
|
Domain
|
|
x(8)
|
|
|
|
scs_enter_shipper
|
Manual Shipper Update
|
Manual!Update
|
yes/no
|
|
|
|
scs_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
scs_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
scs_scrap_material
|
Scrap Unreturned Material
|
Scrap
|
yes/no
|
|
|
|
scs_unassign_sup
|
Unassigned Suppliers
|
Unassigned!Suppliers
|
yes/no
|
|
|
|
scs_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
scs_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_scs_ctrl
|
yes
|
oid_scs_ctrl
|
yes
|
no
|
|
∗
|
scs_domain
|
yes
|
scs_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sct_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sct__qadc01
|
|
|
x(8)
|
|
|
|
sct_bdn_ll
|
Burden LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sct_bdn_tl
|
Burden
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sct_cost_changed
|
Cost Changed
|
|
yes/no
|
|
|
|
sct_cst_date
|
Cost Update
|
Updated
|
99/99/99
|
|
|
|
sct_cst_tot
|
Cost Total
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sct_domain
|
Domain
|
|
x(8)
|
|
|
|
sct_lbr_ll
|
Labor LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sct_lbr_tl
|
Labor
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sct_mtl_ll
|
Material LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sct_mtl_tl
|
Material
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sct_nrv
|
Net Realized Value
|
NR!Value
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sct_ovh_ll
|
Overhead LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sct_ovh_tl
|
Overhead
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sct_part
|
Item Number
|
|
x(18)
|
|
|
|
sct_rollup
|
Freeze
|
Frz
|
yes/no
|
|
|
|
sct_rollup_id
|
Rollup ID
|
|
x(18)
|
|
|
|
sct_serial
|
Lot/Serial
|
|
x(18)
|
|
|
|
sct_sim
|
Cost Set
|
|
x(18)
|
|
|
|
sct_site
|
Site
|
|
x(8)
|
|
|
|
sct_sub_ll
|
Subcontract LL
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sct_sub_tl
|
Subcontract
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sct_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sct_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sct_det
|
yes
|
oid_sct_det
|
yes
|
no
|
|
|
sct_part_sim
|
no
|
sct_domain
|
yes
|
no
|
|
|
|
|
sct_part
|
yes
|
no
|
|
|
|
|
sct_sim
|
yes
|
no
|
|
∗
|
sct_sim_pt_site
|
yes
|
sct_domain
|
yes
|
no
|
|
|
|
|
sct_sim
|
yes
|
no
|
|
|
|
|
sct_part
|
yes
|
no
|
|
|
|
|
sct_site
|
yes
|
no
|
|
|
sct_site_part
|
no
|
sct_domain
|
yes
|
no
|
|
|
|
|
sct_site
|
yes
|
no
|
|
|
|
|
sct_part
|
yes
|
no
|
|
|
sct_site_sim
|
no
|
sct_domain
|
yes
|
no
|
|
|
|
|
sct_site
|
yes
|
no
|
|
|
|
|
sct_sim
|
yes
|
no
|