|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|