QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
FRWTreeView
Report Tree View
 
 
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)
 
 
FRWAnCode_ID
 
 
-99999999999
 
 
FRWCube_ID
 
 
-99999999999
 
 
FRWTreeNode_ID
 
 
-99999999999
 
 
FRWTreeView_ID
Record ID
 
-99999999999
 
 
FRWTreeViewAmountsIn
Amounts In
 
x(40)
 
 
FRWTreeViewIsShared
Is Shared
 
yes/no
 
 
FRWTreeViewReportPeriodFrom
Report Period From
 
99
 
 
FRWTreeViewReportPeriodTo
Report Period To
 
99
 
 
FRWTreeViewReportYearFrom
Report Year From
 
9999
 
 
FRWTreeViewReportYearTo
Report Year To
 
9999
 
 
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
 
 
Usr_ID
 
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
AnCodeIdx
no
FRWAnCode_ID
yes
no
 
CubeIdx
no
FRWCube_ID
yes
no
 ∗
Prim
yes
FRWTreeView_ID
yes
no
 
TreeNodeIdx
no
FRWTreeNode_ID
yes
no
 
UniqIdx
yes
FRWTreeNode_ID
yes
no
 
 
 
FRWCube_ID
yes
no
 
 
 
FRWAnCode_ID
yes
no
 
 
 
Usr_ID
yes
no
 
 
 
FRWTreeViewReportYearFrom
yes
no
 
 
 
FRWTreeViewReportPeriodFrom
yes
no
 
 
 
FRWTreeViewReportYearTo
yes
no
 
 
 
FRWTreeViewReportPeriodTo
yes
no
 
 
 
FRWTreeViewAmountsIn
yes
no
 
 
 
FRWTreeViewIsShared
yes
no
 
UsrIdx
no
Usr_ID
yes
no
FRWUsrDefault
Financial Report Writer User Default Settings
 
 
Field Name
Label
Col-Label
Format
Dec
 
FRWChart_ID
Link to FRWChart
 
-99999999999
 
 
FRWCube_ID
Link to FRWCube
 
-99999999999
 
 
FRWUsrDefault_ID
Record ID
 
-99999999999
 
 
FRWUsrDefaultFilePath
Default Path for Load-Unload
 
x(255)
 
 
FRWUsrDefaultUsrLogin
User Login
 
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
 
 
Usr_ID
Link to Usr
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ChartIdx
no
FRWChart_ID
yes
no
 
CubeIdx
no
FRWCube_ID
yes
no
 ∗
Prim
yes
FRWUsrDefault_ID
yes
no
 
UniqIdx
yes
FRWUsrDefaultUsrLogin
yes
no
 
UsrIdx
no
Usr_ID
yes
no
frzd_det
Freight Zone Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
frzd__chr01
 
 
x(8)
 
 
frzd__chr02
 
 
x(8)
 
 
frzd__chr03
 
 
x(8)
 
 
frzd__chr04
 
 
x(8)
 
 
frzd__chr05
 
 
x(8)
 
 
frzd__chr06
 
 
x(8)
 
 
frzd__chr07
 
 
x(8)
 
 
frzd__chr08
 
 
x(8)
 
 
frzd__dec01
 
 
>>>,>>>,>>9.99
10
 
frzd__dec02
 
 
>>>,>>>,>>9.99
10
 
frzd__dte01
 
 
99/99/99
 
 
frzd__dte02
 
 
99/99/99
 
 
frzd__log01
 
 
yes/no
 
 
frzd__log02
 
 
yes/no
 
 
frzd_domain
Domain
 
x(8)
 
 
frzd_end
End
 
99/99/99
 
 
frzd_fr_list
Freight List
Frt List
x(8)
 
 
frzd_post_en
Post End
 
x(10)
 
 
frzd_post_st
Post Start
 
x(10)
 
 
frzd_site
Site
 
x(8)
 
 
frzd_start
Start
 
99/99/99
 
 
frzd_user1
Ufld1
 
x(8)
 
 
frzd_user2
Ufld2
 
x(8)
 
 
frzd_zone
Zone
 
x(10)
 
 
oid_frzd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
frzd_fr_list
yes
frzd_domain
yes
no
 
 
 
frzd_fr_list
yes
no
 
 
 
frzd_site
yes
no
 
 
 
frzd_zone
yes
no
 
 
 
frzd_post_st
yes
no
 
 
 
frzd_start
yes
no
 
oid_frzd_det
yes
oid_frzd_det
yes
no
fr_mstr
Freight List Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fr__chr01
 
 
x(8)
 
 
fr__chr02
 
 
x(8)
 
 
fr__chr03
 
 
x(8)
 
 
fr__chr04
 
 
x(8)
 
 
fr__chr05
 
 
x(8)
 
 
fr__chr06
 
 
x(8)
 
 
fr__chr07
 
 
x(8)
 
 
fr__chr08
 
 
x(8)
 
 
fr__dec01
 
 
>>>,>>>,>>9.99
10
 
fr__dec02
 
 
>>>,>>>,>>9.99
10
 
fr__dte01
 
 
99/99/99
 
 
fr__dte02
 
 
99/99/99
 
 
fr__log01
 
 
yes/no
 
 
fr__log02
 
 
yes/no
 
 
fr_curr
Currency
Curr
x(3)
 
 
fr_desc
Description
 
x(24)
 
 
fr_domain
Domain
 
x(8)
 
 
fr_list
Freight List
Frt List
x(8)
 
 
fr_mode
Freight Mode
 
x(8)
 
 
fr_site
Site
 
x(8)
 
 
fr_trl_cd
Trailer Code
Trl
x(2)
 
 
fr_type
Type
 
UNIT/BULK
 
 
fr_um
UM
 
x(2)
 
 
fr_user1
Ufld1
 
x(8)
 
 
fr_user2
Ufld2
 
x(8)
 
 
oid_fr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fr_list
yes
fr_domain
yes
no
 
 
 
fr_list
yes
no
 
 
 
fr_site
yes
no
 
 
 
fr_curr
yes
no
 
oid_fr_mstr
yes
oid_fr_mstr
yes
no
fsc_mstr
Service Category Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fsc__chr01
User Character Field #1
 
x(8)
0
 
fsc__chr02
User Character Field #2
 
x(8)
0
 
fsc__chr03
User Character Field #3
 
x(8)
0
 
fsc__chr04
User Character Field #4
 
x(8)
0
 
fsc__dec01
User Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fsc__dec02
User Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fsc__dec03
User Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fsc__dte01
User Date #1
 
99/99/99
 
 
fsc__dte02
User Date #2
 
99/99/99
 
 
fsc__dte03
User Date #3
 
99/99/99
 
 
fsc__log01
User Logical #1
 
yes/no
 
 
fsc__log02
User Logical #2
 
yes/no
 
 
fsc__log03
User Logical #3
 
yes/no
 
 
fsc__qadc01
QAD Character Field
 
x(8)
0
 
fsc__qadc02
Qad Field #2
 
x(8)
 
 
fsc__qadc03
Qad Field #3
 
x(8)
 
 
fsc__qadc04
Qad Field #4
 
x(8)
 
 
fsc__qadd01
Qad Date #1
 
99/99/99
 
 
fsc__qadd02
Qad Date #2
 
99/99/99
 
 
fsc__qadd03
Qad Date #3
 
99/99/99
 
 
fsc__qadde01
Qad Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fsc__qadde02
Qad Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fsc__qadde03
Qad Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fsc__qadl01
QAD Logical Field
 
yes/no
 
 
fsc__qadl02
Qad Logical #2
 
yes/no
 
 
fsc__qadl03
Qad Logical #3
 
yes/no
 
 
fsc_bdn_pct
Labor Burden Percent
Lbr Bdn %
>>9.99%
10
 
fsc_bdn_rate
Labor Burden Rate
Lbr Bdn Rate
>>>,>>9.99
10
 
fsc_code
Service Category
Svc Cat
x(8)
 
 
fsc_con_parts
Consumable Items
Con
yes/no
 
 
fsc_cus_non_prod
Customer Non-Productive
Cus NP
yes/no
 
 
fsc_customer
Customer Chargable
 
yes/no
 
 
fsc_desc
Description
 
x(24)
 
 
fsc_domain
Domain
 
x(8)
 
 
fsc_exg_parts
Exchanged Items
Exg
yes/no
 
 
fsc_expense
Expense
Exp
yes/no
 
 
fsc_fis_column
Column
Col
>>9
 
 
fsc_fis_sort
Invoice Sort
 
x(18)
 
 
fsc_fiscal_class
Fiscal Class
 
x(18)
 
 
fsc_fiscal_type
Fiscal Type
 
x(2)
 
 
fsc_freight_nature
Freight Nature
 
x(1)
 
 
fsc_gtin_barcode1
GTIN Barcode 1
 
x(24)
 
 
fsc_gtin_barcode2
GTIN Barcode 2
 
x(24)
 
 
fsc_labor
Labor
Lab
yes/no
 
 
fsc_lbr_rate
Standard Labor Rate
Std Lbr Rate
>>>,>>9.99
10
 
fsc_non_prod
Non-Productive
Non P
yes/no
 
 
fsc_origin
Country of Origin
 
x(12)
 
 
fsc_other
Other
Oth
yes/no
 
 
fsc_parts
Items
Itm
yes/no
 
 
fsc_service_code
Service Code
 
x(4)
 
 
fsc_sick
Sick
 
yes/no
 
 
fsc_taxable
Taxable
 
yes/no
 
 
fsc_taxc
Tax Class
 
x(8)
0
 
fsc_training
Training
Trn
yes/no
 
 
fsc_travel_exp
Travel Expenses
TE
yes/no
 
 
fsc_travel_labor
Travel Labor
TL
yes/no
 
 
fsc_user1
Ufld1
 
X(8)
 
 
fsc_user2
Ufld2
 
X(8)
 
 
fsc_vacation
Vacation
Vac
yes/no
 
 
oid_fsc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fsc_code
yes
fsc_domain
yes
no
 
 
 
fsc_code
yes
no
 
oid_fsc_mstr
yes
oid_fsc_mstr
yes
no
fsd_det
Service/Support Call Activity Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
fsd__chr01
User Character Field 1
 
X(8)
 
 
fsd__chr02
User Character Field 2
 
X(8)
 
 
fsd__dec01
User Decimal Field 1
 
->>>,>>>,>>9.9<<<
10
 
fsd__int01
User Integer Field 1
 
->,>>>,>>9
 
 
fsd__log01
User Logical Field 1
 
yes/no
 
 
fsd__qadc01
QAD Character Field 1
 
X(8)
 
 
fsd__qadc02
QAD Character Field 2
 
X(8)
 
 
fsd__qadc03
QAD Character Field
 
X(8)
0
 
fsd__qadd01
QAD Decimal Field 1
 
->>>,>>>,>>9.9<<<
10
 
fsd__qadd02
QAD Decimal Field
 
->>,>>9.99
10
 
fsd__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
fsd__qadi02
QAD Integer Field
 
->,>>>,>>9
 
 
fsd__qadl01
QAD Logical Field 1
 
yes/no
 
 
fsd__qadl02
QAD Logical Field
 
yes/no
 
 
fsd_domain
Domain
 
x(8)
 
 
fsd_file
 
 
x(8)
 
 
fsd_file_line
 
 
>>9
 
 
fsd_inv_ref
Ref
Reference
X(8)
 
 
fsd_isb_ref
Installed Base Reference
ISB Ref
>>>>>>>9
 
 
fsd_line
Line
 
>>>9
 
 
fsd_loc
Location
 
x(8)
 
 
fsd_lotser
Lot/Serial
 
x(18)
 
 
fsd_nbr
 
 
x(8)
 
 
fsd_part
Item
 
x(18)
 
 
fsd_qty_post
 
 
->,>>>,>>9.9<<<<<<<<
10
 
fsd_qty_tran
Quantity
 
->,>>>,>>9.9<<<<<<<<
10
 
fsd_ref
Ref
Reference
x(8)
 
 
fsd_ret_loc
Return Location
 
x(8)
 
 
fsd_ret_site
Return Site
 
x(8)
 
 
fsd_rev
Rev
 
x(4)
 
 
fsd_site
Site
 
x(8)
 
 
fsd_status
Status
 
x(8)
 
 
fsd_user1
Ufld1
 
x(8)
 
 
fsd_user2
Ufld2
 
x(8)
 
 
oid_fsd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fsd_nbr
yes
fsd_domain
yes
no
 
 
 
fsd_nbr
yes
no
 
 
 
fsd_file
yes
no
 
 
 
fsd_file_line
yes
no
 
 
 
fsd_part
yes
no
 
 
 
fsd_line
yes
no
 
fsd_part
no
fsd_domain
yes
no
 
 
 
fsd_nbr
yes
no
 
 
 
fsd_file
yes
no
 
 
 
fsd_file_line
yes
no
 
 
 
fsd_part
yes
no
 
 
 
fsd_site
yes
no
 
 
 
fsd_loc
yes
no
 
 
 
fsd_lotser
yes
no
 
 
 
fsd_ref
yes
no
 
oid_fsd_det
yes
oid_fsd_det
yes
no
fsh_mstr
Service/Support Holiday Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fsh__qadc01
 
 
x(8)
 
 
fsh_addr_line1
Address Line 1
 
x(36)
 
 
fsh_addr_line2
Address Line 2
 
x(36)
 
 
fsh_addr_line3
Address Line 3
 
x(36)
 
 
fsh_city
City
 
x(20)
 
 
fsh_code
Code
 
x(8)
 
 
fsh_code_field
Field
 
x(32)
 
 
fsh_country
Country
 
x(28)
 
 
fsh_county
County
 
x(20)
 
 
fsh_covered
Covered
 
yes/no
 
 
fsh_date
Holiday
 
99/99/99
 
 
fsh_desc
Description
 
x(24)
 
 
fsh_domain
Domain
 
x(8)
 
 
fsh_end_time
End Time
End
99:99
 
 
fsh_full_day
Full Day
 
yes/no
 
 
fsh_rsn_code
Reason Code
Reason
x(8)
 
 
fsh_start_time
Start Time
Start
99:99
 
 
fsh_state
State
 
x(4)
 
 
fsh_user1
Ufld1
 
x(8)
 
 
fsh_user2
Ufld2
 
x(8)
 
 
fsh_zip
Post
 
x(10)
 
 
oid_fsh_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fsh_codefield
yes
fsh_domain
yes
no
 
 
 
fsh_code
yes
no
 
 
 
fsh_code_field
yes
no
 
 
 
fsh_date
yes
no
 
 
 
fsh_start_time
yes
no
 
oid_fsh_mstr
yes
oid_fsh_mstr
yes
no
fslp_pln
Simulation Line Plan
 
 
Field Name
Label
Col-Label
Format
Dec
 
fslp__dec01
 
 
->,>>>,>>9.99<
10
 
fslp__dec02
 
 
->,>>>,>>9.99<
10
 
fslp__dec03[52]
 
 
->,>>>,>>9.99<
10
 
fslp__dec04[52]
 
 
->,>>>,>>9.99<
10
 
fslp_domain
Domain
 
x(8)
 
 
fslp_line
Production Line
 
x(8)
 
 
fslp_part
Item Number
Item
x(18)
 
 
fslp_plan_id
Plan ID
 
x(8)
 
 
fslp_prod_act[52]
Production Actual
Prod Act
->>,>>>,>>9.9<<<<<<<<<
10
 
fslp_prod_fcst[52]
Production Forecast
Prod Fcst
->>,>>>,>>9.9<<<<<<<<<
10
 
fslp_site
Site
 
x(8)
 
 
fslp_user1
Ufld1
 
x(8)
 
 
fslp_user2
Ufld2
 
x(8)
 
 
fslp_year
Year
 
>>>>
 
 
oid_fslp_pln
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fslp_pln
yes
fslp_domain
yes
no
 
 
 
fslp_plan_id
yes
no
 
 
 
fslp_part
yes
no
 
 
 
fslp_site
yes
no
 
 
 
fslp_line
yes
no
 
 
 
fslp_year
yes
no
 
oid_fslp_pln
yes
oid_fslp_pln
yes
no
fsp1_pln
Family Simulation Backlog and Cost Plan
 
 
Field Name
Label
Col-Label
Format
Dec
 
fsp1__qadc01
 
 
x(8)
 
 
fsp1_beg_inv
Begining Inventory
Begin Inv
->>>,>>>,>>9.9<<<<<<<<<
10
 
fsp1_bklg_act[52]
Backlog Actual
Bklg Act
->>,>>>,>>9.9<<<<<<<<<
10
 
fsp1_bklg_fcst[52]
Backlog Forecast
Bklg Fcst
->>,>>>,>>9.9<<<<<<<<<
10
 
fsp1_cost_act[52]
Cost Actual
Cost Act
->>,>>>,>>9.9<<<<<<<<<
10
 
fsp1_cost_fcst[52]
Cost Forecast
Cost Fcst
->>,>>>,>>9.9<<<<<<<<<
10
 
fsp1_domain
Domain
 
x(8)
 
 
fsp1_mod_date
Modified Date
Mod Date
99/99/99
 
 
fsp1_mod_userid
User ID
 
x(8)
 
 
fsp1_part
Item Number
Item
x(18)
 
 
fsp1_percent
Percent
 
->>9.9<%
10
 
fsp1_plan_id
Plan ID
 
x(8)
 
 
fsp1_prod_rate
Production Rate
Prod Rate
>>>>,>>>,>>9.99<<<
10
 
fsp1_sim_rate
Simulation Rate
Sim Rate
>>>>,>>>,>>9.9<<<
10
 
fsp1_site
Site
 
x(8)
 
 
fsp1_src_pct
Percent
 
->>9.9<%
10
 
fsp1_target
Coverage
Cov
>>9.9
10
 
fsp1_user1
Ufld1
 
x(8)
 
 
fsp1_user2
Ufld2
 
x(8)
 
 
fsp1_year
Year
 
>>>>
 
 
oid_fsp1_pln
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fsp1_pln
yes
fsp1_domain
yes
no
 
 
 
fsp1_plan_id
yes
no
 
 
 
fsp1_site
yes
no
 
 
 
fsp1_part
yes
no
 
 
 
fsp1_year
yes
no
 
oid_fsp1_pln
yes
oid_fsp1_pln
yes
no
fsp2_pln
Family Simulation Inventory and Order Plan
 
 
Field Name
Label
Col-Label
Format
Dec
 
fsp2__qadc01
 
 
x(8)
 
 
fsp2_beg_inv
Begining Inventory
Begin Inv
->>>,>>>,>>9.9<<<<<<<<<
10
 
fsp2_domain
Domain
 
x(8)
 
 
fsp2_inv_act[52]
Inventory Actual
Inv Act
->>,>>>,>>9.9<<<<<<<<<
10
 
fsp2_inv_fcst[52]
Inventory Forecast
Inv Fcst
->>,>>>,>>9.9<<<<<<<<<
10
 
fsp2_mod_date
Modified Date
Mod Date
99/99/99
 
 
fsp2_mod_userid
User ID
 
x(8)
 
 
fsp2_ord_act[52]
Orders Actual
Orders Act
->>,>>>,>>9.9<<<<<<<<<
10
 
fsp2_ord_fcst[52]
Orders Forecast
Orders Fcst
->>,>>>,>>9.9<<<<<<<<<
10
 
fsp2_part
Item Number
Item
x(18)
 
 
fsp2_percent
Percent
 
->>9.9<%
10
 
fsp2_plan_id
Plan ID
 
x(8)
 
 
fsp2_prod_rate
Production Rate
Prod Rate
>>>>,>>>,>>9.9<<<
10
 
fsp2_sim_rate
Simulation Rate
Sim Rate
>>>>,>>>,>>9.9<<<
10
 
fsp2_site
Site
 
x(8)
 
 
fsp2_src_pct
Percent
 
->>9.9<%
10
 
fsp2_target
Coverage
Cov
>>9.9
10
 
fsp2_user1
Ufld1
 
x(8)
 
 
fsp2_user2
Ufld2
 
x(8)
 
 
fsp2_year
Year
 
>>>>
 
 
oid_fsp2_pln
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fsp2_pln
yes
fsp2_domain
yes
no
 
 
 
fsp2_plan_id
yes
no
 
 
 
fsp2_site
yes
no
 
 
 
fsp2_part
yes
no
 
 
 
fsp2_year
yes
no
 
oid_fsp2_pln
yes
oid_fsp2_pln
yes
no
fsp3_pln
Family Simulation Production and Shipment Plan
 
 
Field Name
Label
Col-Label
Format
Dec
 
fsp3__qadc01
 
 
x(8)
 
 
fsp3_beg_inv
Begining Inventory
Begin Inv
->>>,>>>,>>9.9<<<<<<<<<
10
 
fsp3_domain
Domain
 
x(8)
 
 
fsp3_mod_date
Modified Date
Mod Date
99/99/99
 
 
fsp3_mod_userid
User ID
 
x(8)
 
 
fsp3_part
Item Number
Item
x(18)
 
 
fsp3_percent
Percent
 
->>9.9<%
10
 
fsp3_plan_id
Plan ID
 
x(8)
 
 
fsp3_prod_act[52]
Production Actual
Prod Act
->>,>>>,>>9.9<<<<<<<<<
10
 
fsp3_prod_fcst[52]
Production Forecast
Prod Fcst
->>,>>>,>>9.9<<<<<<<<<
10
 
fsp3_prod_rate
Production Rate
Prod Rate
>>>>,>>>,>>9.9<<<
10
 
fsp3_ship_act[52]
Ship Actual
Ship Act
->>,>>>,>>9.9<<<<<<<<<
10
 
fsp3_ship_fcst[52]
Ship Forecast
Ship Fcst
->>,>>>,>>9.9<<<<<<<<<
10
 
fsp3_sim_rate
Simulation Rate
Sim Rate
>>>>,>>>,>>9.9<<<
10
 
fsp3_site
Site
 
x(8)
 
 
fsp3_src_pct
Percent
 
->>9.9<%
10
 
fsp3_target
Coverage
Cov
>>9.9
10
 
fsp3_user1
Ufld1
 
x(8)
 
 
fsp3_user2
Ufld2
 
x(8)
 
 
fsp3_year
Year
 
>>>>
 
 
oid_fsp3_pln
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fsp3_pln
yes
fsp3_domain
yes
no
 
 
 
fsp3_plan_id
yes
no
 
 
 
fsp3_site
yes
no
 
 
 
fsp3_part
yes
no
 
 
 
fsp3_year
yes
no
 
oid_fsp3_pln
yes
oid_fsp3_pln
yes
no
fspd_det
Service/Support Parts List Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
fspd__qadc01
 
 
x(24)
 
 
fspd__qadc02
 
 
x(24)
 
 
fspd_bom_code
BOM Code
 
x(18)
 
 
fspd_consumed
Consumed
 
yes/no
 
 
fspd_domain
Domain
 
x(8)
 
 
fspd_itm_qty
Quantity
 
->,>>>,>>9.9<<<<<<<<
10
 
fspd_mod_date
Modified Date
Mod Date
99/99/99
 
 
fspd_mod_userid
User ID
 
x(8)
 
 
fspd_part
Item Number
 
x(18)
 
 
fspd_so_nbr
Material Order
 
x(8)
 
 
fspd_user1
User Field Character 1
 
x(24)
 
 
fspd_user2
User Field Character 2
 
x(24)
 
 
oid_fspd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_itm_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fspd_oid_itm_det
yes
fspd_domain
yes
no
 
 
 
oid_itm_det
yes
no
 
 
 
fspd_part
yes
no
 
 
 
fspd_so_nbr
yes
no
 
oid_fspd_det
yes
oid_fspd_det
yes
no
fsu_mstr
Service/Support User Preference Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fsu__qadc02
 
 
x(8)
 
 
fsu__qadc03
 
 
x(8)
 
 
fsu__qadc04
 
 
x(8)
 
 
fsu__qadc05
 
 
x(8)
 
 
fsu__qadc06
 
 
x(8)
 
 
fsu__qadi01
 
 
>>>>>>>9
 
 
fsu__qadi02
 
 
>>>>>>>9
 
 
fsu__qadi03
 
 
>>>>>>>9
 
 
fsu__qadi04
 
 
>>>>>>>9
 
 
fsu__qadi05
 
 
>>>>>>>9
 
 
fsu__qadl01
 
 
yes/no
 
 
fsu__qadl02
 
 
yes/no
 
 
fsu__qadl03
 
 
yes/no
 
 
fsu__qadl04
 
 
yes/no
 
 
fsu__qadl05
 
 
yes/no
 
 
fsu__qadt01
 
 
99/99/99
 
 
fsu__qadt02
 
 
99/99/99
 
 
fsu_ca_time_wnd
Call Time Window
 
yes/no
 
 
fsu_ca_wo_wnd
Call WO Window
 
yes/no
 
 
fsu_clsf_filter
Filter ISB by Classification
 
yes/no
 
 
fsu_dflt_pri
Call Priority
Call!Priority
>>>9
 
 
fsu_dflt_que
Call Queue
Call!Queue
x(8)
 
 
fsu_domain
Domain
 
x(8)
 
 
fsu_esc_dflt
Escalation Default
Esc Dflt
x(8)
 
 
fsu_que_prog
Queue Manager
 
>>9
 
 
fsu_quote_que
Quote Queue
Quote!Queue
x(8)
 
 
fsu_timezone
Time Zone
 
x(8)
 
 
fsu_user1
Ufld1
 
x(8)
 
 
fsu_user2
Ufld2
 
x(8)
 
 
fsu_userid
User ID
 
x(8)
 
 
oid_fsu_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fsu_userid
yes
fsu_domain
yes
no
 
 
 
fsu_userid
yes
no
 
oid_fsu_mstr
yes
oid_fsu_mstr
yes
no
ftch_hist
Service/Support Trace History
 
 
Field Name
Label
Col-Label
Format
Dec
 
ftch__chr01
User Field #1
 
x(8)
 
 
ftch__dte01
User Date #1
 
99/99/99
 
 
ftch__log01
User Logical #1
 
yes/no
 
 
ftch__qadc02
Qad Field #2
 
x(8)
 
 
ftch__qadd01
Qad Decimal #1
 
->>,>>9.99
10
 
ftch__qadl01
Qad Logical #1
 
yes/no
 
 
ftch__qadt01
Qad Date #1
 
99/99/99
 
 
ftch_desc
Description
 
x(24)
 
 
ftch_domain
Domain
 
x(8)
 
 
ftch_eff_date
Effective Date
 
99/99/99
 
 
ftch_eng_code
Engineer
 
x(8)
 
 
ftch_ent_date
Create Date
 
99/99/99
 
 
ftch_mod_date
Modified Date
Mod Date
99/99/99
 
 
ftch_mod_userid
User ID
 
X(8)
 
 
ftch_model
 
 
x(8)
 
 
ftch_nbr
Order
 
x(8)
 
 
ftch_part
Item
 
x(18)
 
 
ftch_prior_value
Prior Value
 
x(18)
 
 
ftch_serial
Serial
 
x(18)
 
 
ftch_swapped
Model
 
yes/no
 
 
ftch_trans
Transaction Type
TR Type
x(8)
 
 
ftch_trnbr
Tran Number
 
>>>>>>>>>>>>>>9
 
 
ftch_user1
Ufld1
 
x(8)
 
 
ftch_user2
Ufld2
 
x(8)
 
 
oid_ftch_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ftch_engeff
no
ftch_domain
yes
no
 
 
 
ftch_eng_code
yes
no
 
 
 
ftch_eff_date
yes
no
 
ftch_parteff
no
ftch_domain
yes
no
 
 
 
ftch_part
yes
no
 
 
 
ftch_eff_date
yes
no
 
ftch_serialeff
no
ftch_domain
yes
no
 
 
 
ftch_serial
yes
no
 
 
 
ftch_eff_date
yes
no
ftch_trnbr
yes
ftch_domain
yes
no
 
 
 
ftch_trnbr
yes
no
 
oid_ftch_hist
yes
oid_ftch_hist
yes
no
ft_mstr
Freight Terms Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
ft__chr01
 
 
x(8)
 
 
ft__chr02
 
 
x(8)
 
 
ft__chr03
 
 
x(8)
 
 
ft__chr04
 
 
x(8)
 
 
ft__chr05
 
 
x(8)
 
 
ft__chr06
 
 
x(8)
 
 
ft__chr07
 
 
x(8)
 
 
ft__chr08
 
 
x(8)
 
 
ft__dec01
 
 
>>>,>>>,>>9.99
10
 
ft__dec02
 
 
>>>,>>>,>>9.99
10
 
ft__dte01
 
 
99/99/99
 
 
ft__dte02
 
 
99/99/99
 
 
ft__log01
 
 
yes/no
 
 
ft__log02
 
 
yes/no
 
 
ft_accrual_level
Accrual Level
Accrual!Level
x(2)
 
 
ft_desc
Description
 
x(24)
 
 
ft_domain
Domain
 
x(8)
 
 
ft_lc_charge
Logistics Charge Code
Chrg Code
x(8)
 
 
ft_terms
Freight Terms
Fr Terms
x(8)
 
 
ft_type
Type
 
x(8)
 
 
ft_user1
Ufld1
 
x(8)
 
 
ft_user2
Ufld2
 
x(8)
 
 
oid_ft_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ft_terms
yes
ft_domain
yes
no
 
 
 
ft_terms
yes
no
 
oid_ft_mstr
yes
oid_ft_mstr
yes
no
fwk_mstr
Service/Support Work Code Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
fwk__chr01
User Character Field #1
 
x(8)
 
 
fwk__chr02
User Character Field #2
 
x(8)
 
 
fwk__chr03
User Character Field #3
 
x(8)
 
 
fwk__chr04
User Character Field #4
 
x(8)
 
 
fwk__dec01
User Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fwk__dec02
User Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fwk__dec03
User Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fwk__dte01
User Date #1
 
99/99/99
 
 
fwk__dte02
User Date #2
 
99/99/99
 
 
fwk__dte03
User Date #3
 
99/99/99
 
 
fwk__log01
User Logical #1
 
yes/no
 
 
fwk__log02
User Logical #2
 
yes/no
 
 
fwk__log03
User Logical #3
 
yes/no
 
 
fwk__qadc01
Qad Field #1
 
x(8)
 
 
fwk__qadc02
Qad Field #2
 
x(8)
 
 
fwk__qadc03
Qad Field #3
 
x(8)
 
 
fwk__qadc04
Qad Field #4
 
x(8)
 
 
fwk__qadd01
Qad Date #1
 
99/99/99
 
 
fwk__qadd02
Qad Date #2
 
99/99/99
 
 
fwk__qadd03
Qad Date #3
 
99/99/99
 
 
fwk__qadde01
Qad Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
fwk__qadde02
Qad Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
fwk__qadde03
Qad Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
fwk__qadl01
Qad Logical #1
 
yes/no
 
 
fwk__qadl02
Qad Logical #2
 
yes/no
 
 
fwk__qadl03
Qad Logical #3
 
yes/no
 
 
fwk_ca_int_type
Work Code
 
x(8)
 
 
fwk_desc
Description
 
x(24)
 
 
fwk_domain
Domain
 
x(8)
 
 
fwk_egs_type
Skill Type
Skill
x(8)
 
 
fwk_fcg_code
Charge Code
Charge
x(8)
 
 
fwk_fixed_labor
Fix Labor Only
FL
yes/no
 
 
fwk_fixed_price
Fixed Price
Fixed
yes/no
 
 
fwk_mod_date
Modified Date
Mod Date
X(8)
 
 
fwk_mod_userid
User ID
 
X(8)
 
 
fwk_repair_ctr
Repair Center
RC
yes/no
 
 
fwk_user1
Ufld1
 
X(8)
 
 
fwk_user2
Ufld2
 
X(8)
 
 
oid_fwk_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
fwk_ca_int_type
yes
fwk_domain
yes
no
 
 
 
fwk_ca_int_type
yes
no
 
oid_fwk_mstr
yes
oid_fwk_mstr
yes
no
genfldd_det
Generic Field Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
genfldd__qadc01
 
 
x(24)
 
 
genfldd__qadc02
 
 
x(24)
 
 
genfldd_charvalues[25]
Character Values
 
x(255)
 
 
genfldd_datevalues[25]
Date Values
 
99/99/99
 
 
genfldd_decimalvalues[25]
Decimal Values
 
->>,>>>,>>>,>>>,>>9.99
4
 
genfldd_integervalues[25]
Integer Values
 
->>>,>>>,>>9
 
 
genfldd_logicalvalues[25]
Logical Values
 
yes/no
 
 
genfldd_mod_date
Modified Date
Mod Date
99/99/99
 
 
genfldd_mod_userid
User ID
 
x(8)
 
 
genfldd_sequence
Sequence
 
>>>9
 
 
genfldd_tablename
Table
 
x(32)
 
 
genfldd_user1
User Field Character 1
 
x(24)
 
 
genfldd_user2
User Field Character 2
 
x(24)
 
 
oid_genfldd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_owning_record
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
genfldd_tablename
no
genfldd_tablename
yes
no
 
oid_genfldd_det
yes
oid_genfldd_det
yes
no
oid_owning_record
yes
oid_owning_record
yes
no
 
 
 
genfldd_sequence
yes
no
giap_mstr
Application Definition Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
giap__qadc01
 
 
x(24)
 
 
giap__qadc02
 
 
x(24)
 
 
giap_app_code
App Code
 
X(8)
 
 
giap_app_desc
Application Description
 
X(24)
 
 
giap_domain
Domain
 
x(8)
 
 
giap_mod_date
Modified Date
Mod Date
99/99/99
 
 
giap_mod_userid
User ID
 
X(8)
 
 
giap_ref_key
Ref Key
 
>>>>>>>>9
 
 
giap_user1
User Field Character 1
 
x(24)
 
 
giap_user2
User Field Character 2
 
x(24)
 
 
oid_giap_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
giap_app_code
yes
giap_domain
yes
no
 
 
 
giap_app_code
yes
no
 
giap_ref_key
yes
giap_domain
yes
no
 
 
 
giap_ref_key
yes
no
 
oid_giap_mstr
yes
oid_giap_mstr
yes
no
gimd_mstr
Model Definition Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
gimd__qadc01
 
 
x(24)
 
 
gimd__qadc02
 
 
x(24)
 
 
gimd_app_code
App Code
 
x(8)
 
 
gimd_domain
Domain
 
x(8)
 
 
gimd_mod_date
Modified Date
Mod Date
99/99/99
 
 
gimd_mod_userid
User ID
 
x(8)
 
 
gimd_model_desc
Description
 
x(24)
 
 
gimd_model_name
Model Name
 
x(8)
 
 
gimd_ref_key
Ref Key
 
>>>>>>>>9
 
 
gimd_user1
User Field Character 1
 
x(24)
 
 
gimd_user2
User Field Character 2
 
x(24)
 
 
oid_gimd_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
gimd_model
yes
gimd_domain
yes
no
 
 
 
gimd_app_code
yes
no
 
 
 
gimd_model_name
yes
no
 
gimd_ref_key
yes
gimd_domain
yes
no
 
 
 
gimd_ref_key
yes
no
 
oid_gimd_mstr
yes
oid_gimd_mstr
yes
no
gip_det
Table Attribute Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
gip__qadc01
 
 
x(24)
 
 
gip__qadc02
 
 
x(24)
 
 
gip_app_code
App Code
 
x(8)
 
 
gip_attribute
Attribute
 
x(32)
 
 
gip_char
Character Value
 
x(24)
 
 
gip_date
Date Value
 
99/99/99
 
 
gip_decimal
Decimal Value
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
gip_domain
Domain
 
x(8)
 
 
gip_integer
Integer Value
 
->,>>>,>>9
 
 
gip_logical
Logical Value
 
yes/no
 
 
gip_mod_date
Modified Date
Mod Date
99/99/99
 
 
gip_mod_userid
User ID
 
x(8)
 
 
gip_ref_key
Ref Key
 
>>>>>>>>9
 
 
gip_table_name
Table Name
 
x(24)
 
 
gip_user1
User Field Character 1
 
x(24)
 
 
gip_user2
User Field Character 2
 
x(24)
 
 
oid_gip_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
gip_app_table
no
gip_domain
yes
no
 
 
 
gip_app_code
yes
no
 
 
 
gip_table_name
yes
no
 
 
 
gip_attribute
yes
no
 
 
 
gip_ref_key
yes
no
gip_ref_attribute
yes
gip_domain
yes
no
 
 
 
gip_ref_key
yes
no
 
 
 
gip_attribute
yes
no
 
oid_gip_det
yes
oid_gip_det
yes
no
gisi_mstr
Site/Item Model Definition Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
gisi__qadc01
 
 
x(24)
 
 
gisi__qadc02
 
 
x(24)
 
 
gisi_app_code
App Code
 
x(8)
 
 
gisi_domain
Domain
 
x(8)
 
 
gisi_mod_date
Modified Date
Mod Date
99/99/99
 
 
gisi_mod_userid
User ID
 
x(8)
 
 
gisi_model_name
Model Name
 
x(8)
 
 
gisi_part
Item Number
 
x(18)
 
 
gisi_ref_key
Ref Key
 
>>>>>>>>9
 
 
gisi_site
Site
 
x(8)
 
 
gisi_user1
User Field Character 1
 
x(24)
 
 
gisi_user2
User Field Character 2
 
x(24)
 
 
oid_gisi_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
gisi_model
yes
gisi_domain
yes
no
 
 
 
gisi_app_code
yes
no
 
 
 
gisi_model_name
yes
no
 
 
 
gisi_site
yes
no
 
 
 
gisi_part
yes
no
 
gisi_ref_key
yes
gisi_domain
yes
no
 
 
 
gisi_ref_key
yes
no
 
gisi_site_part
no
gisi_domain
yes
no
 
 
 
gisi_app_code
yes
no
 
 
 
gisi_site
yes
no
 
 
 
gisi_part
yes
no
 
oid_gisi_mstr
yes
oid_gisi_mstr
yes
no
GL
GL Account
 
 
Field Name
Label
Col-Label
Format
Dec
 
BankAPDiscountGL_ID
AP Discount Account
AP Discount
-99999999999
 
 
BankAPInterestGL_ID
AP Interest Account
 
-99999999999
 
 
BankARDiscountGL_ID
AR Discount Account
AR Discount
-99999999999
 
 
BankARInterestGL_ID
AR Interest Account
 
-99999999999
 
 
BankDiscountGL_ID
Discount Account
 
-99999999999
 
 
BankJournalProfile_ID
Banking Daybook Profile
 
-99999999999
 
 
BudgetGroup_ID
Budget Group 1
 
-99999999999
 
 
BusinessRelation_ID
Link to BusinessRelation
 
-99999999999
 
 
CashGroup_ID
Cash Group
 
-99999999999
 
 
CashInJournalProfile_ID
Cash Received Daybook Profile
 
-99999999999
 
 
CashOutJournalProfile_ID
Cash Paid Daybook Profile
 
-99999999999
 
 
CostCentreProfile_ID
Link to Profile
 
-99999999999
 
 
Currency_ID
Currency Code
Curr
-99999999999
 
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo10
Custom Combo Field
 
x(20)
 
 
CustomCombo11
Custom Combo Field
 
x(20)
 
 
CustomCombo12
Custom Combo Field
 
x(20)
 
 
CustomCombo13
Custom Combo Field
 
x(20)
 
 
CustomCombo14
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)
 
 
CustomShort10
Custom Short Field
 
x(20)
 
 
CustomShort11
Custom Short Field
 
x(20)
 
 
CustomShort12
Custom Short Field
 
x(20)
 
 
CustomShort13
Custom Short Field
 
x(20)
 
 
CustomShort14
Custom Short Field
 
x(20)
 
 
CustomShort15
Custom Short Field
 
x(20)
 
 
CustomShort16
Custom Short Field
 
x(20)
 
 
CustomShort17
Custom Short Field
 
x(20)
 
 
CustomShort18
Custom Short Field
 
x(20)
 
 
CustomShort19
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)
 
 
DeductionJournalProfile_ID
Deduction Daybook Profile
 
-99999999999
 
 
DivisionProfile_ID
Link to Profile
 
-99999999999
 
 
GL_ID
Record ID
 
-99999999999
 
 
GLAnalysisLimitation
Analysis Limitation
Analysis Limit
x(20)
 
 
GLAnalysisSetOnByUsr_ID
Link to Usr
 
-99999999999
 
 
GLAnalysisSetOnOnDate
GL Analysis Set On Date
 
99/99/9999
 
 
GLCategory
Category
 
x(20)
 
 
GLCode
Account
 
x(8)
 
 
GLDescription
Description
 
x(24)
 
 
GLDivisionSetOnByUsr_ID
Link to Usr
 
-99999999999
 
 
GLDivisionSetOnOnDate
GL Sub-Account Set On Date
 
99/99/9999
 
 
GLExchangeMethod
Consolidation Method
 
x(20)
 
 
GLIsActive
Active
 
yes/no
 
 
GLIsAutomaticAccount
Automatic Account
Auto
yes/no
 
 
GLIsBalanceAccount
Balance Account
 
yes/no
 
 
GLIsConsumptionVat
Consumption Tax
 
yes/no
 
 
GLIsCostCentreAccount
Cost Center Account
 
yes/no
 
 
GLIsDebitAccount
Debit/Credit
 
yes/no
 
 
GLIsDivisionAccount
Sub-Account
 
yes/no
 
 
GLIsFixedInterco
Fixed Intercompany
Fixed IC
yes/no
 
 
GLIsIntercoAccount
Intercompany Account
 
yes/no
 
 
GLIsLocalCurrency
Base Currency Only
Base Curr
yes/no
 
 
GLIsProjectAccount
Project Analysis
Proj Analysis
yes/no
 
 
GLIsQuantityAccount
Quantity
 
yes/no
 
 
GLIsSafAccount
SAF Enabled
SAF
yes/no
 
 
GLIsValueDate
Value Dates
Val Date
yes/no
 
 
GLIsWithBudget
Budget Enabled
 
yes/no
 
 
GLRevaluationCCMethod
SC Revaluation Method
SC Rev Method
x(20)
 
 
GLRevaluationMethod
TC Revaluation Method
TC Rev Method
x(20)
 
 
GLSystemTypeCode
System Type
Sys Type
x(20)
 
 
GLTypeCode
GL Type
 
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)
 
 
ProjectProfile_ID
Link to Profile
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Report2BudgetGroup_ID
Budget Group 2
 
-99999999999
 
 
Report3BudgetGroup_ID
Budget Group 3
 
-99999999999
 
 
Report4BudgetGroup_ID
Budget Group 4
 
-99999999999
 
 
RevalCCExchangeRateType_ID
Link to ExchangeRateType
 
-99999999999
 
 
RevalExchangeRateType_ID
Link to ExchangeRateType
 
-99999999999
 
 
RevaluationGL_ID
Link to GL
 
-99999999999
 
 
SharedSet_ID
Link to SharedSet
 
-99999999999
 
 
Unit_ID
GL Account Unit of Measure
UM
-99999999999
 
 
UnrealizedGainGL_ID
Unrealized Gain GL
 
-99999999999
 
 
UnrealizedLossGL_ID
Unrealized Loss GL
 
-99999999999
 
 
UsrDefExchangeRateType_ID
Consolidation Rate Type
Rate Type
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BankAPDiscGLIdx
no
BankAPDiscountGL_ID
yes
no
 
BankAPIntGLIdx
no
BankAPInterestGL_ID
yes
no
 
BankARDiscGLIdx
no
BankARDiscountGL_ID
yes
no
 
BankARIntGLIdx
no
BankARInterestGL_ID
yes
no
 
BankDiscGLIdx
no
BankDiscountGL_ID
yes
no
 
BankJrnlProfIdx
no
BankJournalProfile_ID
yes
no
 
BudgetGroup
no
BudgetGroup_ID
yes
no
 
BusinessRelation
no
BusinessRelation_ID
yes
no
 
CashGroupIdx
no
CashGroup_ID
yes
no
 
CashInProfIdx
no
CashInJournalProfile_ID
yes
no
 
CashOutProfIdx
no
CashOutJournalProfile_ID
yes
no
 
CCProfIdx
no
CostCentreProfile_ID
yes
no
 
Code
no
GLCode
yes
no
 
CurrencyIdx
no
Currency_ID
yes
no
 
DeductProfile
no
DeductionJournalProfile_ID
yes
no
 
DivOnUsrIdx
no
GLDivisionSetOnByUsr_ID
yes
no
 
DivProfIdx
no
DivisionProfile_ID
yes
no
 
GLAnalOnUsrIdx
no
GLAnalysisSetOnByUsr_ID
yes
no
 
GLDescription
no
GLDescription
yes
no
 
GLIsBalIdx
no
GLIsBalanceAccount
yes
no
 
GLIsWithBudgetIdx
no
GLIsWithBudget
yes
no
 
GLSystemTypeIdx
no
GLSystemTypeCode
yes
no
 
GLType
no
GLTypeCode
yes
no
 
IsActive
no
GLIsActive
yes
no
 
IsConsumptionVat
no
GLIsConsumptionVat
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 ∗
Prim
yes
GL_ID
yes
no
 
ProjProfIdx
no
ProjectProfile_ID
yes
no
 
Rep2BudGrpIdx
no
Report2BudgetGroup_ID
yes
no
 
Rep3BudGrpIdx
no
Report3BudgetGroup_ID
yes
no
 
Rep4BudGrpIdx
no
Report4BudgetGroup_ID
yes
no
 
RevalCCExchRtIdx
no
RevalCCExchangeRateType_ID
yes
no
 
RevalExchRtIdx
no
RevalExchangeRateType_ID
yes
no
 
RevaluationGL
no
RevaluationGL_ID
yes
no
 
SharedSet
no
SharedSet_ID
yes
no
 
SharedSetAndCode
yes
SharedSet_ID
yes
no
 
 
 
GLCode
yes
no
 
UnitIdx
no
Unit_ID
yes
no
 
UsrDefExchRtIdx
no
UsrDefExchangeRateType_ID
yes
no
 
ViewIndex
no
SharedSet_ID
yes
no
 
 
 
GLIsActive
yes
no
 
 
 
GLCode
yes
no
GLCalendar
GL Calendar
 
 
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)
 
 
Domain_ID
Domain
 
-99999999999
 
 
GLCalendar_ID
Record ID
 
-99999999999
 
 
GLCalendarEndDate
End Date
 
99/99/9999
 
 
GLCalendarPeriod
GL Period
GL Pd
99
 
 
GLCalendarStartDate
Start Date
 
99/99/9999
 
 
GLCalendarTypeCode
GL Period Type
 
x(20)
 
 
GLCalendarYear
GL Calendar Year
Year
9999
 
 
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
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
DomainYearPeriod
yes
Domain_ID
yes
no
 
 
 
GLCalendarYear
yes
no
 
 
 
GLCalendarPeriod
yes
no
 ∗
Prim
yes
GLCalendar_ID
yes
no
glccp_det
Cost Calculation period
 
 
Field Name
Label
Col-Label
Format
Dec
 
glccp__qadc01
 
 
x(24)
 
 
glccp__qadc02
 
 
x(24)
 
 
glccp_end
End
 
99/99/99
 
 
glccp_mod_date
Modified Date
Mod Date
99/99/99
 
 
glccp_mod_userid
User ID
 
x(8)
 
 
glccp_start
Start
 
99/99/99
 
 
glccp_user1
User Field Character 1
 
x(24)
 
 
glccp_user2
User Field Character 2
 
x(24)
 
 
oid_cs_mstr
Identifier Parent(Umbrella) Cost Set
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_glc_cal
Identifier GL Calendar
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_glccp_det
Identifier Cost Calculation Period
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
glccp_cs_start
no
oid_cs_mstr
yes
no
 
 
 
glccp_start
yes
no
 
glccp_gl_cs_start
yes
oid_glc_cal
yes
no
 
 
 
oid_cs_mstr
yes
no
 
 
 
glccp_start
yes
no
 
glccp_gl_start
no
oid_glc_cal
yes
no
 
 
 
glccp_start
yes
no
oid_glccp_det
yes
oid_glccp_det
yes
no
glcd_det
General Ledger Calendar Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
glcd__qadc01
 
 
x(8)
 
 
glcd_ap_clsd
AP Closed
!AP
yes/no
 
 
glcd_ar_clsd
AR Closed
!AR
yes/no
 
 
glcd_closed
Modules Closed
Modules!Closed
yes/no
 
 
glcd_domain
Domain
 
x(8)
 
 
glcd_entity
Entity
Enty
x(20)
 
 
glcd_fa_clsd
FA Closed
!FA
yes/no
 
 
glcd_gl_clsd
G/L Closed
G/L!Closed
yes/no
 
 
glcd_ic_clsd
WO/IC Closed
WO!IC
yes/no
 
 
glcd_per
Period
Per
>>9
 
 
glcd_so_clsd
SO Closed
!SO
yes/no
 
 
glcd_user1
Ufld1
 
x(8)
 
 
glcd_user2
Ufld2
 
x(8)
 
 
glcd_year
Year
 
9999
 
 
glcd_yr_clsd
Year Closed
Year!Closed
yes/no
 
 
oid_glcd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
glcd_index
yes
glcd_domain
yes
no
 
 
 
glcd_year
yes
no
 
 
 
glcd_per
yes
no
 
 
 
glcd_entity
yes
no
 
oid_glcd_det
yes
oid_glcd_det
yes
no