QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
grx_mstr
GL Report Writer Report Content Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
grx__qadc01
 
 
x(8)
 
 
grx_add_date
Date Created
 
99/99/99
 
 
grx_add_id
Originator
 
x(8)
 
 
grx_cmtindx
Comment Index
 
>>>>>>>9
 
 
grx_col_group
Column Group
 
x(8)
 
 
grx_cont_pg
Continuous Page Numbers
C-Pg
yes/no
 
 
grx_ctl_ac
Using Analysis Code
A-Code
x(8)
 
 
grx_ctl_gl
Control Report By
C
x(1)
 
 
grx_defprt
Printer Template
 
x(8)
 
 
grx_desc
Description
 
x(24)
 
 
grx_domain
Domain
 
x(8)
 
 
grx_format
Format
 
x(20)
 
 
grx_lab_bc
Row Labels Before Column
 
>>>9
 
 
grx_mod_date
Modified Date
Mod Date
99/99/99
 
 
grx_mod_id
Modified By
 
x(8)
 
 
grx_mrg_bot
Bottom Margin
BM
>9
 
 
grx_mrg_left
Left Margin
LM
>9
 
 
grx_mrg_right
Right Margin
RM
>9
 
 
grx_mrg_top
Top Margin
TM
>9
 
 
grx_mt_group
Maintenance Security Groups
 
x(72)
 
 
grx_report
Report
 
x(8)
 
 
grx_round
Rounding
RM
x(3)
 
 
grx_row_group
Row Group
 
x(8)
 
 
grx_rp_group
Report Security Groups
 
x(72)
 
 
grx_status
Status
 
Live/Test
 
 
grx_text_ix[3]
String Index
Strng Ix
>>>>>>>9
 
 
grx_user1
Ufld1
 
x(8)
 
 
grx_user2
Ufld2
 
Ufld2
 
 
grx_zero_suppress
Zero Suppression
ZS
x(1)
 
 
oid_grx_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
grx_col_group
no
grx_domain
yes
no
 
 
 
grx_col_group
yes
no
 
grx_ctl_ac
no
grx_domain
yes
no
 
 
 
grx_ctl_ac
yes
no
 
 
 
grx_ctl_gl
yes
no
 
 
 
grx_report
yes
no
grx_report
yes
grx_domain
yes
no
 
 
 
grx_report
yes
no
 
grx_row_group
no
grx_domain
yes
no
 
 
 
grx_row_group
yes
no
 
oid_grx_mstr
yes
oid_grx_mstr
yes
no
gr_ctrl
GL Report Writer Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
gr__qadc01
 
 
x(8)
 
 
gr_ac_cmmts
Analysis Code Comments
 
yes/no
 
 
gr_cg_cmmts
Column Group Comments
 
yes/no
 
 
gr_col_width
Column Width
 
>9
 
 
gr_cyis
Current Year Income Offset
 
x(8)
 
 
gr_cyre
Current Year Retained Earnings
 
x(8)
 
 
gr_domain
Domain
 
x(8)
 
 
gr_format
Format
 
x(20)
 
 
gr_index1
Index
 
>>>>>9
 
 
gr_per
Current Period
Per
>>9
 
 
gr_precedence
Precedence
 
Row/Column
 
 
gr_qtr_lbl[4]
Quarter
 
x(10)
 
 
gr_rg_cmmts
Row Group Comments
 
yes/no
 
 
gr_rg_width
Row Width
 
z9
 
 
gr_round
Rounding
 
x(3)
 
 
gr_rp_cmmts
Report Comments
 
yes/no
 
 
gr_run_id
Next Report Run ID
 
>>>>>>9
 
 
gr_txt_ix
Text Index
Txt Ix
>>>>>>>9
 
 
gr_user1
Ufld1
 
x(8)
 
 
gr_user2
Ufld2
 
x(8)
 
 
gr_year
Current Year
 
>>>9
 
 
oid_gr_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
gr_index1
yes
gr_domain
yes
no
 
oid_gr_ctrl
yes
oid_gr_ctrl
yes
no
gtidh_hist
Golden Tax Invoice History Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
gtidh__qadc01
 
 
x(24)
 
 
gtidh__qadc02
 
 
x(24)
 
 
gtidh_amt
Invoice Line Amount
Amount
->,>>>,>>>,>>9.99
10
 
gtidh_code_version
Commodity Code Version
 
x(20)
 
 
gtidh_comm_code
Commodity Code
 
x(20)
 
 
gtidh_curr_amt
Invoice Line Curr Amt
 
->,>>>,>>>,>>9.99
10
 
gtidh_custpart
Customer Item
 
x(18)
 
 
gtidh_desc
Description
 
x(30)
 
 
gtidh_disc_amt
Discount Amount
 
->,>>>,>>>,>>9.99
10
 
gtidh_docnbr
Golden Tax Document Number
Document
x(20)
 
 
gtidh_domain
Domain
 
x(8)
 
 
gtidh_group
Product Group
Group
x(5)
 
 
gtidh_gt_inv_nbr
Golden Tax Invoice Number
GT Invoice
x(8)
 
 
gtidh_inv_nbr
Invoice Number
 
x(22)
 
 
gtidh_line
Golden Tax Invoice Line
GT!Line
>>>9
 
 
gtidh_mod_date
Modified Date
Mod Date
99/99/99
 
 
gtidh_mod_userid
User ID
 
x(8)
 
 
gtidh_pref_policy
Preferential Policy
 
Yes/No
 
 
gtidh_pref_policy_desc
Policy Description
 
x(50)
 
 
gtidh_price
Invoice Line Price
 
>,>>>,>>>,>>9.99
10
 
gtidh_pt_desc1
Item Description
 
x(24)
 
 
gtidh_pt_desc2
Item Description
 
x(24)
 
 
gtidh_qty
Invoice Line Quantity
Quantity
->,>>>,>>9.9<<<
10
 
gtidh_sod_line
Sales Order Line
SO!Line
>>>9
 
 
gtidh_sod_nbr
Sales Order Number
 
x(8)
 
 
gtidh_sod_part
Item Number
 
x(18)
 
 
gtidh_tax_amt
Tax Amount
 
->,>>>,>>>,>>9.99
10
 
gtidh_tax_code
Tax Code
 
x(8)
 
 
gtidh_tax_in
Tax In
 
yes/no
 
 
gtidh_tax_rate
Tax Rate
 
>9.999
10
 
gtidh_tot_amt
Amount
 
->,>>>,>>>,>>9.99
10
 
gtidh_tot_curr_amt
Currency Amount
 
->,>>>,>>>,>>9.99
10
 
gtidh_trl_amt
Trailer Amount
 
->,>>>,>>>,>>9.9
10
 
gtidh_trl_cd
Trailer Code
 
x(2)
 
 
gtidh_trl_tax_amt
Trailer Tax Amount
Tax Amount
->,>>>,>>>,>>9.9
10
 
gtidh_um
UM
 
x(2)
 
 
gtidh_user1
User Field Character 1
 
x(24)
 
 
gtidh_user2
User Field Character 2
 
x(24)
 
 
gtidh_zero_tax_flag
Zero Tax Rate Flag
 
x(2)
 
 
oid_gtidh_hist
OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
gtidh_domain
yes
gtidh_domain
yes
no
 
 
 
gtidh_docnbr
yes
no
 
 
 
gtidh_line
yes
no
 
gtidh_inv_doc
no
gtidh_domain
yes
no
 
 
 
gtidh_inv_nbr
yes
no
 
 
 
gtidh_docnbr
yes
no
 
gtidh_inv_sod
no
gtidh_domain
yes
no
 
 
 
gtidh_inv_nbr
yes
no
 
 
 
gtidh_sod_nbr
yes
no
 
oid_gtidh_hist
yes
oid_gtidh_hist
yes
no
gtih_hist
Golden Tax Invoice History Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
gtih__qadc01
 
 
x(24)
 
 
gtih__qadc02
 
 
x(24)
 
 
gtih_cm_addr_tel
Customer Address And Telephone
 
x(50)
 
 
gtih_cm_bk_acct
Customer Bank Account
 
x(24)
 
 
gtih_cm_name
Customer Name
 
x(36)
 
 
gtih_cm_vat_reg
Customer VAT Register
 
x(18)
 
 
gtih_comment
Comment
 
x(70)
 
 
gtih_docnbr
Golden Tax Document Number
Document
x(20)
 
 
gtih_domain
Domain
 
x(8)
 
 
gtih_entity
Entity
 
x(20)
 
 
gtih_exp_by
Export By
 
x(8)
 
 
gtih_exp_date
Export Date
 
99/99/99
 
 
gtih_exported
Golden Tax Exported
Exported
yes/no
 
 
gtih_gt_inv_date
Golden Tax Invoice Date
GT Date
99/99/99
 
 
gtih_gt_inv_nbr
Golden Tax Invoice Number
GT Inv Number
x(8)
 
 
gtih_gt_trans_type
GT Trans Type
 
x(25)
 
 
gtih_gt_type
Golden Tax Invoice Type
Type
x(10)
 
 
gtih_gtprocess
Process Golden Tax Invoice
Process
yes/no
 
 
gtih_ih_bill
Bill-To ID
 
x(8)
 
 
gtih_ih_cust
Customer ID
 
x(8)
 
 
gtih_inv_checker
Invoice Verifier
 
x(8)
 
 
gtih_inv_creator
Invoice Creator
 
x(8)
 
 
gtih_inv_date
Invoice Date
 
99/99/99
 
 
gtih_inv_nbr
Invoice Number
 
x(22)
 
 
gtih_mod_date
Modified Date
Mod Date
99/99/99
 
 
gtih_mod_userid
User ID
 
x(8)
 
 
gtih_own_addr_tel
Own Company Address And Telephone
 
x(50)
 
 
gtih_own_bk_acct
Own Bank Account
 
x(24)
 
 
gtih_own_name
Own Name
 
x(36)
 
 
gtih_own_vat_reg
Own VAT Register
 
x(18)
 
 
gtih_payment_receiver
Payment Receiver
 
x(8)
 
 
gtih_tot_amt
Total Amount
 
->>>>>>>>>>9.99
10
 
gtih_tot_curr_amt
Total Currency Amount
 
->>,>>>,>>>,>>9.99
10
 
gtih_tot_line
Total Lines
Lines
>>>9
 
 
gtih_user1
User Field Character 1
 
x(24)
 
 
gtih_user2
User Field Character 2
 
x(24)
 
 
gtih_void
Void
 
yes/no
 
 
oid_gtih_hist
OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
gtih_domain
yes
gtih_domain
yes
no
 
 
 
gtih_docnbr
yes
no
 
gtih_exported
no
gtih_domain
yes
no
 
 
 
gtih_exported
yes
no
 
gtih_extrpt
no
gtih_entity
yes
no
 
 
 
gtih_inv_nbr
yes
no
 
 
 
gtih_inv_creator
yes
no
 
 
 
gtih_exported
yes
no
 
gtih_gtcr
no
gtih_entity
yes
no
 
 
 
gtih_inv_nbr
yes
no
 
 
 
gtih_ih_cust
yes
no
 
 
 
gtih_ih_bill
yes
no
 
 
 
gtih_gt_inv_date
yes
no
 
 
 
gtih_inv_creator
yes
no
 
 
 
gtih_exported
yes
no
 
gtih_gtrpt
no
gtih_domain
yes
no
 
 
 
gtih_gt_inv_date
yes
no
 
oid_gtih_hist
yes
oid_gtih_hist
yes
no
gtnbr_det
Golden Tax Invoice Cross Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
gtnbr__qadc01
 
 
x(24)
 
 
gtnbr__qadc02
 
 
x(24)
 
 
gtnbr_domain
Domain
 
x(8)
 
 
gtnbr_gtinvnbr
Golden Tax Invoice Number
 
x(8)
 
 
gtnbr_invnbr
Invoice Number
 
x(22)
 
 
gtnbr_mod_date
Modified Date
Mod Date
99/99/99
 
 
gtnbr_mod_userid
User ID
 
x(8)
 
 
gtnbr_sonbr
Sales Order Number
 
x(8)
 
 
gtnbr_type
Type
 
x(1)
 
 
gtnbr_user1
User Field Character 1
 
x(24)
 
 
gtnbr_user2
User Field Character 2
 
x(24)
 
 
oid_gtnbr_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
gtnbr_invnbr_gtnbr
no
gtnbr_invnbr
yes
no
 
 
 
gtnbr_gtinvnbr
yes
no
 
 
 
gtnbr_domain
yes
no
 
gtnbr_type_nbr
no
gtnbr_domain
yes
no
 
 
 
gtnbr_type
yes
no
 
 
 
gtnbr_invnbr
yes
no
 
 
 
gtnbr_gtinvnbr
yes
no
 
oid_gtnbr_det
yes
oid_gtnbr_det
yes
no
gt_ctrl
Golden Tax Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
gt__qadc01
 
 
x(24)
 
 
gt__qadc02
 
 
x(24)
 
 
gt_com_code_version
Commodity Code Version
 
x(20)
 
 
gt_docnbr
Golden Tax Document Number
 
>>>>>>>9
 
 
gt_domain
Domain
 
x(8)
 
 
gt_gt_type
Golden Tax Invoice Type
Type
x(10)
 
 
gt_gtflag
Enable Golden Tax
 
yes/no
 
 
gt_in_path
Input Path
 
x(60)
 
 
gt_mod_date
Modified Date
Mod Date
99/99/99
 
 
gt_mod_userid
User ID
 
x(8)
 
 
gt_out_path
Output Path
 
x(60)
 
 
gt_user1
User Field Character 1
 
x(24)
 
 
gt_user2
User Field Character 2
 
x(24)
 
 
oid_gt_ctrl
OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
gt_domain
yes
gt_domain
yes
no
 
oid_gt_ctrl
yes
oid_gt_ctrl
yes
no
hd_mstr
Holiday Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
hd__qadc01
 
 
x(8)
 
 
hd_date
Date
Date
99/99/99
 
 
hd_desc
Holiday
 
x(24)
 
 
hd_domain
Domain
 
x(8)
 
 
hd_site
Site
 
x(8)
 
 
hd_user1
Ufld1
 
x(8)
 
 
hd_user2
Ufld2
 
x(8)
 
 
oid_hd_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
hd_mstr
yes
hd_domain
yes
no
 
 
 
hd_site
yes
no
 
 
 
hd_date
yes
no
 
oid_hd_mstr
yes
oid_hd_mstr
yes
no
hlp_mstr
Help Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
hlp__qadc01
 
 
x(8)
 
 
hlp_context_nbr
Context Number
Context
>>>,>>>,>>9
 
 
hlp_context_str
Context String
 
x(32)
0
 
hlp_file
Help File
 
X(12)
0
 
hlp_user1
Ufld1
 
x(8)
 
 
hlp_user2
Ufld2
 
x(8)
 
 
oid_hlp_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
hlp_primary
no
hlp_context_str
yes
no
 
oid_hlp_mstr
yes
oid_hlp_mstr
yes
no
HoldM
Warehousing Hold Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
AllowCycle
Allow Cycle Counts
Cycle
yes/no
 
 
AllowInReturn
Allow Incoming Returns
InRet
yes/no
 
 
AllowIssue
Allow Issues
Iss
yes/no
 
 
AllowOutReturn
Allow Outgoing Returns
OutRet
yes/no
 
 
AllowPick
Allow Picking
Pick
yes/no
 
 
AllowReceipt
Allow Receipts
Rec
yes/no
 
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
FromDate
From
 
99/99/99
 
 
FromTime
 
 
->,>>>,>>9
 
 
HoldReason
Reason
 
x(8)
 
 
Loc
Location
 
x(8)
 
 
Lot
Lot/Serial
 
x(18)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_HoldM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
Part
Item Number
 
x(18)
 
 
PartType
Warehouse Item Type
Warehouse!Item Type
x(8)
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
Ref
Reference
 
x(8)
 
 
Site
Site
 
x(8)
 
 
SLocGp
Store Loc Group
SLocGrp
x(8)
 
 
ToDate
To
 
99/99/99
 
 
ToTime
 
 
->,>>>,>>9
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 2
 
99/99/99
 
 
Whse
Warehouse
Whse
x(8)
 
 
WLocGp
Work Loc Group
WLocGrp
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
HoMIdx
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
SLocGp
yes
no
 
 
 
WLocGp
yes
no
 
 
 
Loc
yes
no
 
 
 
Part
yes
no
 
 
 
PartType
yes
no
 
 
 
Lot
yes
no
 
 
 
Ref
yes
no
 
oid_HoldM
yes
oid_HoldM
yes
no
 
Part
no
Domain
yes
no
 
 
 
Part
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
Holiday
Holiday
 
 
Field Name
Label
Col-Label
Format
Dec
 
Company_ID
Link to Company
 
-99999999999
 
 
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)
 
 
Holiday_ID
Record ID
 
-99999999999
 
 
HolidayDate
Holiday Date
 
99/99/9999
 
 
HolidayDescription
Description
 
x(40)
 
 
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
 
CyDateIdx
yes
Company_ID
yes
no
 
 
 
HolidayDate
yes
no
 
CyIdx
no
Company_ID
yes
no
 
DateIdx
no
HolidayDate
yes
no
 ∗
Prim
yes
Holiday_ID
yes
no
iach_hist
Inventory Consumption History
 
 
Field Name
Label
Col-Label
Format
Dec
 
iach__qadc01
 
 
x(24)
 
 
iach__qadc02
 
 
x(24)
 
 
iach_domain
Domain
 
x(8)
 
 
iach_mod_date
Modified Date
Mod Date
99/99/99
 
 
iach_mod_userid
User ID
 
x(8)
 
 
iach_part
Item Number
 
x(18)
 
 
iach_period
Period
 
99
 
 
iach_qty
Quantity
 
->>,>>>,>>9.9<<<<<<<<<
10
 
iach_qty_oh
Qty On Hand
 
->>,>>>,>>9.9<<<<<<<<<
10
 
iach_quarter
Quarter
 
9
 
 
iach_site
Site
 
x(8)
 
 
iach_um
Unit of Measure
UM
x(2)
 
 
iach_user1
User Field Character 1
 
x(24)
 
 
iach_user2
User Field Character 2
 
x(24)
 
 
iach_year
Year
 
9999
 
 
oid_iach_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
iach_part
yes
iach_domain
yes
no
 
 
 
iach_part
yes
no
 
 
 
iach_site
yes
no
 
 
 
iach_year
yes
no
 
 
 
iach_period
yes
no
 
oid_iach_hist
yes
oid_iach_hist
yes
no
iac_ctrl
Obsolete Inventory Control Parameters
 
 
Field Name
Label
Col-Label
Format
Dec
 
iac__qadc01
 
 
x(24)
 
 
iac__qadc02
 
 
x(24)
 
 
iac_conflict
Conflicting Inventory Types
 
x(1)
 
 
iac_consum_program
Consumption Filter Program
 
x(12)
 
 
iac_domain
Domain
 
x(8)
 
 
iac_extract_date
Last Extract Date
 
99/99/99
 
 
iac_extract_time
Last Extract Time
 
99999
 
 
iac_index1
Index
 
>>>>>9
 
 
iac_logic
Display logical expression
 
yes/no
 
 
iac_mod_date
Modified Date
Mod Date
99/99/99
 
 
iac_mod_userid
User ID
 
x(8)
 
 
iac_path
Path for Reserve Output
 
x(100)
 
 
iac_retain_consum
Retain Consumption Data
 
yes/no
 
 
iac_use_abc
Use ABC Analysis Usage
 
yes/no
 
 
iac_user1
User Field Character 1
 
x(24)
 
 
iac_user2
User Field Character 2
 
x(24)
 
 
oid_iac_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
iac_index1
yes
iac_domain
yes
no
 
oid_iac_ctrl
yes
oid_iac_ctrl
yes
no
iad_mstr
Obsolete Inventory Depreciation Rate Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
iad__qadc01
 
 
x(24)
 
 
iad__qadc02
 
 
x(24)
 
 
iad_comment
Comment
 
x(8)
 
 
iad_depr_rate
Depreciation Rate
 
>>9.9<<
3
 
iad_domain
Domain
 
x(8)
 
 
iad_exception
Exception
 
x(1)
 
 
iad_inven_type
Inventory Type
 
x(8)
 
 
iad_mod_date
Modified Date
Mod Date
99/99/99
 
 
iad_mod_userid
User ID
 
x(8)
 
 
iad_periods
Up To Number Of Periods
 
>>>9
 
 
iad_user1
User Field Character 1
 
x(24)
 
 
iad_user2
User Field Character 2
 
x(24)
 
 
oid_iad_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
iad_inven_type
yes
iad_domain
yes
no
 
 
 
iad_inven_type
yes
no
 
 
 
iad_exception
yes
no
 
 
 
iad_periods
yes
no
 
oid_iad_mstr
yes
oid_iad_mstr
yes
no
iaod_det
Output File Field Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
iaod__qadc01
 
 
x(24)
 
 
iaod__qadc02
 
 
x(24)
 
 
iaod_domain
Domain
 
x(8)
 
 
iaod_extract_seq
Extract Sequence
 
>>9
 
 
iaod_field_nbr
Field Number
 
>>9
 
 
iaod_file_type
Output File Type
 
x(8)
 
 
iaod_mod_date
Modified Date
Mod Date
99/99/99
 
 
iaod_mod_userid
User ID
 
x(8)
 
 
iaod_user1
User Field Character 1
 
x(24)
 
 
iaod_user2
User Field Character 2
 
x(24)
 
 
oid_iaod_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
iaod_file_type
yes
iaod_domain
yes
no
 
 
 
iaod_file_type
yes
no
 
 
 
iaod_field_nbr
yes
no
 
oid_iaod_det
yes
oid_iaod_det
yes
no
iao_mstr
Output File Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
iao__qadc01
 
 
x(24)
 
 
iao__qadc02
 
 
x(24)
 
 
iao_desc
Description
 
x(40)
 
 
iao_domain
Domain
 
x(8)
 
 
iao_file_type
Output File Type
 
x(8)
 
 
iao_header_row
Header Row
 
yes/no
 
 
iao_mod_date
Modified Date
Mod Date
99/99/99
 
 
iao_mod_userid
User ID
 
x(8)
 
 
iao_program_name
Program Name
 
x(12)
 
 
iao_quote
Quote Character
 
x
 
 
iao_separator
Separator Character
 
x
 
 
iao_user1
User Field Character 1
 
x(24)
 
 
iao_user2
User Field Character 2
 
x(24)
 
 
oid_iao_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
iao_file_type
yes
iao_domain
yes
no
 
 
 
iao_file_type
yes
no
 
oid_iao_mstr
yes
oid_iao_mstr
yes
no
iasd_det
Obsolete Inventory Control Site Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
iasd__qadc01
 
 
x(24)
 
 
iasd__qadc02
 
 
x(24)
 
 
iasd_domain
Domain
 
x(8)
 
 
iasd_mod_date
Modified Date
Mod Date
99/99/99
 
 
iasd_mod_userid
User ID
 
x(8)
 
 
iasd_site
Site
 
x(8)
 
 
iasd_trans_types
Extract Issue Transactions
 
x(100)
 
 
iasd_user1
User Field Character 1
 
x(24)
 
 
iasd_user2
User Field Character 2
 
x(24)
 
 
oid_iasd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
iasd_site
yes
iasd_domain
yes
no
 
 
 
iasd_site
yes
no
 
oid_iasd_det
yes
oid_iasd_det
yes
no
iatd_det
Inventory Type Field Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
iatd__qadc01
 
 
x(24)
 
 
iatd__qadc02
 
 
x(24)
 
 
iatd_domain
Domain
 
x(8)
 
 
iatd_field_nbr
Field Number
 
>>9
 
 
iatd_field_set
Field Set
 
>>9
 
 
iatd_from_value
From
 
x(18)
 
 
iatd_inven_type
Inventory Type
 
x(8)
 
 
iatd_mod_date
Modified Date
Mod Date
99/99/99
 
 
iatd_mod_userid
User ID
 
x(8)
 
 
iatd_to_value
To
 
x(18)
 
 
iatd_user1
User Field Character 1
 
x(24)
 
 
iatd_user2
User Field Character 2
 
x(24)
 
 
iatd_value_nbr
Value Number
 
>>9
 
 
oid_iatd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
iatd_inven_type
yes
iatd_domain
yes
no
 
 
 
iatd_inven_type
yes
no
 
 
 
iatd_field_set
yes
no
 
 
 
iatd_field_nbr
yes
no
 
 
 
iatd_value_nbr
yes
no
 
oid_iatd_det
yes
oid_iatd_det
yes
no
iat_mstr
Inventory Type Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
iat__qadc01
 
 
x(24)
 
 
iat__qadc02
 
 
x(24)
 
 
iat_desc
Description
 
x(40)
 
 
iat_domain
Domain
 
x(8)
 
 
iat_inven_type
Inventory Type
 
x(8)
 
 
iat_mod_date
Modified Date
Mod Date
99/99/99
 
 
iat_mod_userid
User ID
 
x(8)
 
 
iat_user1
User Field Character 1
 
x(24)
 
 
iat_user2
User Field Character 2
 
x(24)
 
 
oid_iat_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
iat_inven_type
yes
iat_domain
yes
no
 
 
 
iat_inven_type
yes
no
 
oid_iat_mstr
yes
oid_iat_mstr
yes
no
ibh_hist
Sales Order Configuration Bill History
 
 
Field Name
Label
Col-Label
Format
Dec
 
ibh__qadc01
 
 
x(8)
 
 
ibh_bo_chg
Qty B/O
 
->,>>>,>>9.9<<<<<<<<
10
 
ibh_cfg_type
Configuration
Config
x(1)
 
 
ibh_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ibh_domain
Domain
 
x(8)
 
 
ibh_feature
Feature
 
x(12)
 
 
ibh_inv_nbr
Invoice
 
x(22)
 
 
ibh_iss_date
Issue Date
Iss Date
99/99/99
 
 
ibh_line
Line
 
>>9
 
 
ibh_loc
Location
 
x(8)
 
 
ibh_nbr
Sales Order
Order
x(8)
 
 
ibh_parent
Parent Item
 
x(18)
 
 
ibh_part
Item Number
 
x(18)
 
 
ibh_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
ibh_qty_all
Qty Allocated
 
->,>>>,>>9.9<<<<<<<<
10
 
ibh_qty_chg
Qty to Issue
 
->,>>>,>>9.9<<<<<<<<
10
 
ibh_qty_iss
Qty Issued
 
->,>>>,>>9.9<<<<<<<<
10
 
ibh_qty_pick
Qty Picked
 
->,>>>,>>9.9<<<<<<<<
10
 
ibh_qty_req
Qty Required
 
->,>>>,>>9.9<<<<<<<<
10
 
ibh_serial
Lot/Serial
 
x(18)
 
 
ibh_site
Site
 
x(8)
 
 
ibh_tot_std
Std Cost
 
->>>,>>9.999
10
 
ibh_user1
Ufld1
 
x(8)
 
 
ibh_user2
Ufld2
 
x(8)
 
 
oid_ibh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ibd_inv_nbr
yes
ibh_domain
yes
no
 
 
 
ibh_inv_nbr
yes
no
 
 
 
ibh_nbr
yes
no
 
 
 
ibh_line
yes
no
 
 
 
ibh_feature
yes
no
 
 
 
ibh_part
yes
no
 
ibh_part
yes
ibh_domain
yes
no
 
 
 
ibh_part
yes
no
 
 
 
ibh_inv_nbr
yes
no
 
 
 
ibh_line
yes
no
 
 
 
ibh_feature
yes
no
 
oid_ibh_hist
yes
oid_ibh_hist
yes
no
ib_det
Service/Support Installed Configuration Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ib__qadc01
 
 
x(8)
 
 
ib_comp
Component
Comp Item
x(18)
 
 
ib_comp_ref
Comp Ref
Ref
>>>>>>>9
 
 
ib_comp_ser
Component Serial
Comp Serial
x(18)
 
 
ib_config
 
 
x(1)
 
 
ib_contract
Contract
 
x(8)
 
 
ib_cover
 
 
x(1)
 
 
ib_desc
Description
 
x(24)
 
 
ib_domain
Domain
 
x(8)
 
 
ib_eu_nbr
End User
 
x(8)
 
 
ib_int_level
 
 
>>9
 
 
ib_level
Level
 
x(8)
 
 
ib_sys_part
System Item
 
x(18)
 
 
ib_sys_ref
System Ref
 
>>>>>>>9
 
 
ib_sys_seq
Sequence
 
>>>>>>9
 
 
ib_sys_serial
System Serial
 
x(18)
 
 
ib_tag
 
 
*/
 
 
ib_user1
Ufld1
 
x(8)
 
 
ib_user2
Ufld2
 
x(8)
 
 
oid_ib_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ib_compser
yes
ib_domain
yes
no
 
 
 
ib_comp
yes
no
 
 
 
ib_comp_ser
yes
no
 
 
 
ib_comp_ref
yes
no
 
ib_eu_comp
yes
ib_domain
yes
no
 
 
 
ib_eu_nbr
yes
no
 
 
 
ib_comp
yes
no
 
 
 
ib_comp_ref
yes
no
 
 
 
ib_comp_ser
yes
no
 
ib_eutag
no
ib_domain
yes
no
 
 
 
ib_eu_nbr
yes
no
 
 
 
ib_tag
yes
no
 
 
 
ib_sys_seq
yes
no
 
ib_serial
no
ib_domain
yes
no
 
 
 
ib_sys_serial
yes
no
 
 
 
ib_sys_ref
yes
no
ib_sys_seq
yes
ib_domain
yes
no
 
 
 
ib_eu_nbr
yes
no
 
 
 
ib_config
yes
no
 
 
 
ib_sys_part
yes
no
 
 
 
ib_sys_serial
yes
no
 
 
 
ib_sys_ref
yes
no
 
 
 
ib_sys_seq
yes
no
 
 
 
ib_comp
yes
no
 
oid_ib_det
yes
oid_ib_det
yes
no
icc_ctrl
Inventory Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
icc__qad01
 
 
>>>>>>9
 
 
icc__qad02
 
 
9
 
 
icc__qad03
 
 
9
 
 
icc__qadc01
 
 
x(24)
 
 
icc__qadc02
 
 
x(24)
 
 
icc__qadc03
 
 
x(24)
 
 
icc__qadi02
 
 
->>>>>>>9
 
 
icc__qadi04
 
 
>>>>>>>9
 
 
icc_ascend
Ascending or Descending
 
yes/no
 
 
icc_cogs
Sum LL Costs Into Matl Cost
COGS
yes/no
 
 
icc_cur_ap
Current Cost from AP
 
yes/no
 
 
icc_cur_cost
Current Cost (AVG/LAST/NONE)
 
x(4)
 
 
icc_cur_set
Default Current Cost Set
Cur Set
x(8)
 
 
icc_domain
Domain
 
x(8)
 
 
icc_gl_set
Default GL Cost Set
GL Set
x(8)
 
 
icc_gl_sum
Summarized Journal
 
yes/no
 
 
icc_gl_tran
Create GL Transactions
 
yes/no
 
 
icc_iss_days
Issue Days
 
->,>>>,>>9
 
 
icc_jrnl
Next Journal
 
999999
 
 
icc_mirror
Mirror Accounting
Mirror
yes/no
 
 
icc_pk_ord
Picking Order
 
>
 
 
icc_site
Default Site
Site
x(8)
 
 
icc_tol_a
Class A
 
->>>,>>9.99
10
 
icc_tol_a_pct
Class A
 
->9.99%
10
 
icc_tol_b
Class B
 
->>>,>>9.99
10
 
icc_tol_b_pct
Class B
 
->9.99%
10
 
icc_tol_c
Class C
 
->>>,>>9.99
10
 
icc_tol_c_pct
Class C
 
->9.99%
10
 
icc_tol_flag
Tolerance Method
 
Qoh/Usage
 
 
icc_tol_o
All Others
 
->>>,>>9.99
10
 
icc_tol_o_pct
All Others
 
->9.99%
10
 
icc_user1
Ufld1
 
x(8)
 
 
icc_user2
Ufld2
 
x(8)
 
 
icc_xclr_acct
Transfer Clearing Acct
 
x(8)
 
 
icc_xclr_cc
Intercompany Cost Center
CC
x(4)
 
 
icc_xclr_sub
Tsfr Clearing Sub-Acct
Sub-Acct
x(8)
 
 
oid_icc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
icc_index1
yes
icc_domain
yes
no
 
oid_icc_ctrl
yes
oid_icc_ctrl
yes
no
idhlc_hist
Invoice History Line Charge Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
idhlc__qadc01
 
 
x(24)
 
 
idhlc__qadc02
 
 
x(24)
 
 
idhlc_acct
Sales Acct
Account
x(8)
 
 
idhlc_cc
Cost Ctr
CC
x(4)
 
 
idhlc_charge_category
Category
 
x(8)
 
 
idhlc_charge_type
Charge Type
Charge!Type
x(8)
 
 
idhlc_desc
Description
 
x(24)
 
 
idhlc_desc1
Description
 
x(24)
 
 
idhlc_desc2
Description
 
x(24)
 
 
idhlc_domain
Domain
 
x(8)
 
 
idhlc_fr_class
Freight Class
 
x(8)
 
 
idhlc_fr_wt
Unit Ship Weight
 
->>,>>>,>>9.9<<<<<<<<<
10
 
idhlc_fr_wt_um
UM
 
x(2)
 
 
idhlc_inv_nbr
Invoice
 
x(22)
 
 
idhlc_line
SO Line
SO!Line
>>9
 
 
idhlc_mod_date
Modified Date
Mod Date
99/99/99
 
 
idhlc_mod_userid
User ID
 
X(8)
 
 
idhlc_nbr
Sales Order
Order
x(8)
 
 
idhlc_part
Item Number
 
x(18)
 
 
idhlc_price
Price
 
->>>>,>>>,>>9.99<<<
10
 
idhlc_prodline
Product Line
Line
x(4)
 
 
idhlc_project
Project
 
x(8)
 
 
idhlc_qty_inv
Qty Invoiced
 
->>,>>>,>>9.9<<<<<<<<<
10
 
idhlc_sub
Sales Sub-Acct
Sub-Acct
x(8)
 
 
idhlc_sub_line
Charge Line
Charge!Ln
>>>>9
 
 
idhlc_tax_env
Tax Environment
Tax Env
x(16)
 
 
idhlc_tax_usage
Tax Usage
TaxUsage
x(8)
 
 
idhlc_taxable
Taxable
Tax
yes/no
 
 
idhlc_taxc
Tax Class
TxC
x(3)
 
 
idhlc_trl
Trailer
Trl
x(4)
 
 
idhlc_um
UM
 
x(2)
 
 
idhlc_userc01
User Field Character 1
 
x(24)
 
 
idhlc_userc02
User Field Character 2
 
x(24)
 
 
oid_idhlc_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
idhlc_invln
yes
idhlc_domain
yes
no
 
 
 
idhlc_inv_nbr
yes
no
 
 
 
idhlc_nbr
yes
no
 
 
 
idhlc_line
yes
no
 
 
 
idhlc_sub_line
yes
no
 
idhlc_part
no
idhlc_domain
yes
no
 
 
 
idhlc_inv_nbr
yes
no
 
 
 
idhlc_nbr
yes
no
 
 
 
idhlc_line
yes
no
 
 
 
idhlc_part
yes
no
 
 
 
idhlc_charge_category
yes
no
 
 
 
idhlc_price
yes
no
 
idhlc_trl
no
idhlc_domain
yes
no
 
 
 
idhlc_inv_nbr
yes
no
 
 
 
idhlc_nbr
yes
no
 
 
 
idhlc_line
yes
no
 
 
 
idhlc_charge_category
yes
no
 
 
 
idhlc_trl
yes
no
 
oid_idhlc_hist
yes
oid_idhlc_hist
yes
no
idhr_hist
Invoice History Relationship Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
idhr__qadc01
 
 
x(8)
 
 
idhr__qadc02
 
 
x(8)
 
 
idhr__qadc03
 
 
x(8)
 
 
idhr__qadd01
 
 
->>>>,>>>,>>9.9
10
 
idhr__qadd02
 
 
->>>>,>>>,>>9.9
10
 
idhr__qadi01
 
 
->,>>>,>>9
 
 
idhr__qadi02
 
 
->,>>>,>>9
 
 
idhr__qadl01
 
 
yes/no
 
 
idhr__qadl02
 
 
yes/no
 
 
idhr__qadt01
 
 
99/99/99
 
 
idhr__qadt02
 
 
99/99/99
 
 
idhr_div
Division
 
x(8)
 
 
idhr_domain
Domain
 
x(8)
 
 
idhr_group
Group
 
x(8)
 
 
idhr_inv_nbr
Invoice
 
x(22)
 
 
idhr_line
Line
 
>>9
 
 
idhr_nbr
Sales Order
 
x(8)
 
 
idhr_pricing
Pricing
 
>9
 
 
idhr_seq
Sequence
 
>>9
 
 
idhr_type
Type
 
>>>9
 
 
idhr_user1
Ufld1
 
x(8)
 
 
idhr_user2
Ufld2
 
x(8)
 
 
oid_idhr_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
idhr_invln_seq
yes
idhr_domain
yes
no
 
 
 
idhr_inv_nbr
yes
no
 
 
 
idhr_nbr
yes
no
 
 
 
idhr_line
yes
no
 
 
 
idhr_seq
yes
no
 
idhr_type
no
idhr_domain
yes
no
 
 
 
idhr_type
yes
no
 
oid_idhr_hist
yes
oid_idhr_hist
yes
no
idh_hist
Invoice History Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
idh__chr01
 
 
x(8)
 
 
idh__chr02
 
 
x(8)
 
 
idh__chr03
 
 
x(8)
 
 
idh__chr04
 
 
x(8)
 
 
idh__chr05
 
 
x(8)
 
 
idh__chr06
 
 
x(8)
 
 
idh__chr07
 
 
x(8)
 
 
idh__chr08
 
 
x(8)
 
 
idh__chr09
 
 
x(8)
 
 
idh__chr10
 
 
x(8)
 
 
idh__dec01
 
 
>>>,>>>,>>9.99
10
 
idh__dec02
 
 
>>>,>>>,>>9.99
10
 
idh__dec03
 
 
>>>,>>>,>>9.99
10
 
idh__dec04
 
 
>>>,>>>,>>9.99
10
 
idh__dec05
 
 
>>>,>>>,>>9.99
10
 
idh__dte01
 
 
99/99/99
 
 
idh__dte02
 
 
99/99/99
 
 
idh__dte03
 
 
99/99/99
 
 
idh__log01
 
 
yes/no
 
 
idh__qad01
 
 
>
 
 
idh__qad02
 
 
yes/no
 
 
idh__qadc01
QAD Field
 
X(8)
0
 
idh__qadc02
QAD Field
 
X(8)
0
 
idh__qadc03
QAD field
 
X(8)
0
 
idh__qadc04
QAD field
 
X(8)
0
 
idh__qadc05
QAD field
 
X(8)
0
 
idh__qadc06
QAD field
 
X(8)
0
 
idh__qadd01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
idh__qadd02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
idh__qadd03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
idh__qadd04
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
idh__qadd05
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
idh__qadi01
QAD Field
 
->,>>>,>>9
 
 
idh__qadi02
QAD Field
 
->,>>>,>>9
 
 
idh__qadi03
QAD Field
 
->,>>>,>>9
 
 
idh__qadi04
QAD Field
 
->,>>>,>>9
 
 
idh__qadl01
QAD Field
 
yes/no
 
 
idh__qadl02
QAD Field
 
yes/no
 
 
idh__qadl03
QAD Field
 
yes/no
 
 
idh__qadl04
QAD Field
 
yes/no
 
 
idh__qadl05
QAD Field
 
yes/no
 
 
idh__qadt01
QAD Field
 
99/99/99
 
 
idh__qadt02
QAD Field
 
99/99/99
 
 
idh__qadt03
QAD Field
 
99/99/99
 
 
idh__qadt04
QAD Field
 
99/99/99
 
 
idh__qadt05
QAD Field
 
99/99/99
 
 
idh_abnormal
Abnormal Demand
Abnormal
yes/no
 
 
idh_acct
Sales Acct
Sales
x(8)
 
 
idh_act_price
Actual Price
 
>>>>,>>>,>>9.99<<<
10
 
idh_auto_ins
Installation Call
 
yes/no
 
 
idh_bo_chg
Qty Backord
 
->,>>>,>>9.9<<<<<<<<
10
 
idh_bonus
Bonus Stock Line
 
yes/no
 
 
idh_btb_po
EMT PO
 
x(8)
 
 
idh_btb_pod_line
EMT PO Line
EMT PO Ln
>>9
 
 
idh_btb_type
EMT Type
 
xx
 
 
idh_btb_vend
EMT Supplier
EMT Supp
X(8)
 
 
idh_ca_line
Call Line
 
>>9
 
 
idh_ca_nbr
Call Number
 
X(8)
 
 
idh_calc_isb
Calculate Isb
 
yes/no
 
 
idh_car_load
Call Act. Rec. Load
 
yes/no
 
 
idh_cc
Cost Ctr
CC
x(4)
 
 
idh_cfg_type
Configuration
Config
x(1)
 
 
idh_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
idh_comm_pct[4]
Commission
Comm%
>>9.99%
10
 
idh_comment[5]
Comments
 
x(40)
 
 
idh_config_id
Configuration ID
 
x(8)
 
 
idh_conrep
Netting Logic
C/R
X(1)
 
 
idh_consume
Consume Forecast
Consume Fcst
yes/no
 
 
idh_contr_id
Contract ID
 
x(30)
 
 
idh_covered_amt
Covered Amount
 
>>>>,>>>,>>9.99<<<
10
 
idh_crt_int
Credit Terms Int
CRT Int
->>>9.99
10
 
idh_cum_date[4]
Cum Start
 
99/99/99
 
 
idh_cum_qty[4]
Cum Shipped
 
->>>>,>>>,>>9.9<<<<<<<<
10
 
idh_curr_rlse_id[3]
Current Rlse ID
 
x(30)
 
 
idh_custpart
Customer Item
 
x(18)
 
 
idh_custref
Customer Ref
 
x(30)
 
 
idh_desc
Description
 
x(24)
 
 
idh_disc_pct
Disc %
 
->>9.99%
10
 
idh_div
Division
 
x(8)
 
 
idh_dock
Dock
 
X(8)
 
 
idh_domain
Domain
 
x(8)
 
 
idh_drp_ref
DRP Ref
 
X(8)
 
 
idh_dsc_acct
Disc Acct
?
x(8)
 
 
idh_dsc_cc
Disc CC
CC
x(4)
 
 
idh_dsc_project
Disc Project
 
x(8)
 
 
idh_dsc_sub
Disc Sub-Acct
Sub-Acct
x(8)
 
 
idh_due_date
Due Date
Due
99/99/99
 
 
idh_end_eff[4]
End Effective
 
99/99/99
 
 
idh_enduser
End User
 
x(8)
 
 
idh_excl_amd
Exclude from Amendment
 
yes/no
 
 
idh_exp_del
Exp Delivery Date
Exp Date
99/99/99
 
 
idh_expire
Expires
 
99/99/99
 
 
idh_fa_nbr
FAS W/O
Final Assembly W/O
x(18)
 
 
idh_fab_days
Fab Auth Days
 
>,>>9
 
 
idh_fix_pr
Fixed Price
 
yes/no
 
 
idh_fixed_price
Fixed Price
 
>>>>,>>>,>>9.99<<<
10
 
idh_for
For
 
x(18)
 
 
idh_for_serial
Parent Item Serial
 
X(18)
 
 
idh_fr_chg
Unit Freight Charge
 
->>>,>>>,>>9.99
10
 
idh_fr_class
Freight Class
 
x(8)
 
 
idh_fr_list
Freight List
Frt List
x(8)
 
 
idh_fr_rate
Freight Rate
 
>>>,>>>,>>9.99<<
10
 
idh_fr_wt
Unit Ship Weight
 
->,>>>,>>9.<<<<<<
10
 
idh_fr_wt_um
UM
 
x(2)
 
 
idh_fsm_type
FSM Type
 
x(8)
 
 
idh_fst_list
FST on List
 
yes/no
 
 
idh_inv_cost
Invoice Cost
 
->>>,>>>,>>9.99<<<
10
 
idh_inv_nbr
Invoice
 
x(22)
 
 
idh_isb_loc
Installed Base Location
 
x(22)
 
 
idh_isb_ref
ISB Ref
 
>>>>>>>9
 
 
idh_line
Line
Ln
>>9
 
 
idh_list_pr
List Price
 
>>>>,>>>,>>9.99<<<
10
 
idh_ln_ref
Line Ref
 
X(8)
 
 
idh_loc
Location
 
x(8)
 
 
idh_lot
ID
 
x(8)
 
 
idh_mod_date
Modified Date
Mod Date
99/99/99
 
 
idh_mod_userid
User ID
 
X(8)
 
 
idh_modelyr
Model Year
 
x(4)
 
 
idh_nbr
Sales Order
Order
x(8)
 
 
idh_ord_mult
Ord Mult
Mult
>>,>>>,>>9
0
 
idh_out_po
Display PO Number
 
X(30)
 
 
idh_override_lmt
Override Limits
Lmt
yes/no
 
 
idh_owner
Ownership
 
x(8)
 
 
idh_part
Item Number
 
x(18)
 
 
idh_partial
Partial OK
Partial
yes/no
 
 
idh_pastdue
Past Due Logic
 
X(1)
 
 
idh_per_date
Perform Date
Perform
99/99/99
 
 
idh_pickdate
Pick Date
 
99/99/99
 
 
idh_pkg_code
Pkg Code
 
x(18)
 
 
idh_pl_priority
P/L Priority
 
>9
 
 
idh_pr_list
Price List
 
X(8)
 
 
idh_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
idh_pricing_dt
Pricing Date
Price Dt
99/99/99
 
 
idh_prig1
Pricing Group 1
 
x(8)
 
 
idh_prig2
Pricing Group 2
 
x(8)
 
 
idh_prodline
Product Line
Line
x(4)
 
 
idh_project
Project
 
x(8)
 
 
idh_promise_date
Promise Date
Promise
99/99/99
 
 
idh_pst
PST Taxable
 
yes/no
 
 
idh_qty_all
Qty Allocated
 
->,>>>,>>9.9<<<<<<<<
10
 
idh_qty_chg
Qty To Ship
 
->,>>>,>>9.9<<<<<<<<
10
 
idh_qty_cons
Qty Consumed
 
->,>>>,>>9.9<<<
10
 
idh_qty_exch
Qty Exchanged
 
->,>>>,>>9.9<<<
10
 
idh_qty_inv
Qty Invoiced
 
->,>>>,>>9.9<<<<<<<<
10
 
idh_qty_item
Item Quantity
Item Qty
->>,>>9.9<<<<
10
 
idh_qty_ord
Qty Ordered
 
->,>>>,>>9.9<<<<<<<<
10
 
idh_qty_pend
Qty Pending
 
->,>>>,>>9.9<<<
10
 
idh_qty_per
Duration
 
->>>9.9<<<
10
 
idh_qty_pick
Qty Picked
 
->,>>>,>>9.9<<<<<<<<
10
 
idh_qty_qote
Qty Quoted
 
->,>>>,>>9.9<<<<<<<<
10
 
idh_qty_ret
Qty Returned
 
->,>>>,>>9.9<<<
10
 
idh_qty_ship
Qty Shipped
 
->,>>>,>>9.9<<<<<<<<
10
 
idh_raw_days
Raw Auth Days
 
>,>>9
 
 
idh_rbkt_days
Req Schedule Days
 
>>9
 
 
idh_rbkt_mths
Req Schedule Months
 
>>9
 
 
idh_rbkt_weeks
Req Schedule Weeks
 
>>9
 
 
idh_ref
Ref
 
>>>>>>>9
 
 
idh_req_date
Required Date
Required
99/99/99
 
 
idh_retro_price
Retro Invoice Price
 
>>>>,>>>,>>9.99<<<
10
 
idh_rlse_nbr
Next Release ID
 
99999999
 
 
idh_rma_type
RMA Type
 
x(1)
 
 
idh_sa_nbr
Service Contract
Contract
x(8)
 
 
idh_sad_line
Contract Line
 
>>>>>>>9
 
 
idh_sch_data
Schedule Data
 
x(8)
 
 
idh_sch_mrp
Sched MRP Req
 
yes/no
 
 
idh_sched
Scheduled
 
yes/no
 
 
idh_sched_chgd
Schedule Changed
 
yes/no
 
 
idh_serial
Lot/Serial
 
x(18)
 
 
idh_ship
Ship-To
 
x(8)
 
 
idh_shipvia
Ship Via
 
x(20)
 
 
idh_site
Site
 
x(8)
 
 
idh_slspsn[4]
Salesperson
Salespsn
x(8)
 
 
idh_sob_rev
Revised Date
Revised
99/99/99
 
 
idh_sob_std
Standard Bill
Std BOM
yes/no
 
 
idh_start_eff[4]
Start Effective
 
99/99/99
 
 
idh_status
Status
 
x(8)
 
 
idh_std_cost
Cost
 
->>>,>>>,>>9.99<<<
10
 
idh_sub
Sales Sub-Acct
Sub-Acct
x(8)
 
 
idh_sv_code
Warranty Type
 
X(8)
 
 
idh_tax_env
Tax Environment
Tax Env
x(16)
 
 
idh_tax_in
Tax In
 
yes/no
 
 
idh_tax_max
Max Taxable Amount
Max Amount
->>>,>>>,>>9.99
10
 
idh_tax_usage
Tax Usage
TaxUsage
x(8)
 
 
idh_taxable
Taxable
Tax
yes/no
 
 
idh_taxc
Tax Class
TxC
x(3)
 
 
idh_to_loc
Location
 
X(8)
 
 
idh_to_ref
Kit Ref
 
X(8)
 
 
idh_to_site
Site
 
X(8)
 
 
idh_trans_lt
Transport Leadtime
 
>>9.99
10
 
idh_translt_hrs
Transport Hours
 
>>9.99
10
 
idh_type
Ship Type
T
x(1)
 
 
idh_um
UM
 
x(2)
 
 
idh_um_conv
UM Conversion
UM Conv
>>>>9.9999<<<<
10
 
idh_upd_isb
Update Installed Base
 
yes/no
 
 
idh_user1
Ufld1
 
x(8)
 
 
idh_user2
Ufld2
 
x(8)
 
 
idh_warr_start
Warranty Start Date
 
99/99/99
 
 
idh_xcomm_pct[2]
Commission
Comm%
>>9.99%
10
 
idh_xslspsn[3]
Salesperson
Salespsn
x(8)
 
 
oid_idh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
idh_fsm_type
no
idh_domain
yes
no
 
 
 
idh_fsm_type
yes
no
 
 
 
idh_nbr
yes
no
 
 
 
idh_line
yes
no
idh_invln
yes
idh_domain
yes
no
 
 
 
idh_inv_nbr
yes
no
 
 
 
idh_nbr
yes
no
 
 
 
idh_line
yes
no
 
idh_part
no
idh_domain
yes
no
 
 
 
idh_part
yes
no
 
 
 
idh_inv_nbr
yes
no
 
 
 
idh_line
yes
no
 
oid_idh_hist
yes
oid_idh_hist
yes
no