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