QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
RGD
Warehousing Release Group Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
DSet
Data Set
 
x(12)
 
 
DueDate
Due Date
 
99/99/99
 
 
Line
Line/ID
 
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
Nbr
Order
 
x(18)
 
 
NetWeight
Net Weight
Net Wgt
->>,>>9.99
2
 
oid_RGD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OrdSite
Order Site
Order!Site
x(8)
 
 
PartType
Warehouse Item Type
Warehouse!Item Type
x(8)
 
 
Picks
Picks
Picks
>>>,>>9
 
 
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
 
 
RelNbr
Release Group Nbr
Rel Grp
>>>>>>>9
 
 
ShipVia
Carrier
Carrier
x(20)
 
 
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
 
 
WaveNbr
Wave Number
Wave Nbr
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_RGD
yes
oid_RGD
yes
no
 ∗
RelGroup
yes
Domain
yes
no
 
 
 
RelNbr
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
DueDate
yes
no
 
 
 
ShipVia
yes
no
 
 
 
PartType
yes
no
 
 
 
DSet
yes
no
 
 
 
Nbr
yes
no
 
 
 
Line
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
 
Wave
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
RelNbr
yes
no
RGM
Warehousing Release Group Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
Algo
Algorithm
Algo
>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
DueDate
Due Date
 
99/99/99
 
 
Include
Include
Inc
yes/no
 
 
Lane
Lane
 
x(8)
 
 
LoadNbr
Load Number
Load Nbr
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
NetWeight
Net Weight
Net Wgt
->>,>>9.99
2
 
oid_RGM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
PartType
Warehouse Item Type
Warehouse!Item Type
x(8)
 
 
Picks
Picks
Picks
>>>,>>9
 
 
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
 
 
Released
Released
 
yes/no
 
 
RelNbr
Release Group Nbr
Rel Grp
>>>>>>>9
 
 
ShipVia
Carrier
Carrier
x(20)
 
 
Site
Site
 
x(8)
 
 
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
 
 
WaveNbr
Wave Number
Wave Nbr
x(8)
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Include
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
Include
yes
no
 
oid_RGM
yes
oid_RGM
yes
no
 ∗
RelGroup
yes
Domain
yes
no
 
 
 
RelNbr
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
DueDate
yes
no
 
 
 
ShipVia
yes
no
 
 
 
PartType
yes
no
 
SiteWhse
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
 
Wave
yes
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
RelNbr
yes
no
rhd_hist
Return Material Authorization Detail History
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rhd_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rhd__chr01
 
 
x(8)
 
 
rhd__chr02
 
 
x(8)
 
 
rhd__chr03
 
 
x(8)
 
 
rhd__chr04
 
 
x(8)
 
 
rhd__chr05
 
 
x(8)
 
 
rhd__chr06
 
 
x(8)
 
 
rhd__chr07
 
 
x(8)
 
 
rhd__chr08
 
 
x(8)
 
 
rhd__chr09
 
 
x(8)
 
 
rhd__chr10
 
 
x(8)
 
 
rhd__dec01
 
 
>>>,>>>,>>9.99
10
 
rhd__dec02
 
 
>>>,>>>,>>9.99
10
 
rhd__dte01
 
 
99/99/99
 
 
rhd__dte02
 
 
99/99/99
 
 
rhd__log01
 
 
yes/no
 
 
rhd__qadc01
QAD Character Field 1
 
X(8)
 
 
rhd__qadc02
QAD Character Field 2
 
X(8)
 
 
rhd__qadc03
QAD Character Field 3
 
X(8)
 
 
rhd__qadd01
QAD Date Field 1
 
99/99/99
 
 
rhd__qadd02
QAD Date Field 2
 
99/99/99
 
 
rhd__qadd03
QAD Date Field 3
 
99/99/99
 
 
rhd__qadd04
QAD Date Field 4
 
99/99/99
 
 
rhd__qadd05
QAD Date Field 5
 
99/99/99
 
 
rhd__qadde01
QAD Decimal Field 1
 
->>,>>9.99
10
 
rhd__qadde02
QAD Decimal Field 2
 
->>,>>9.99
10
 
rhd__qadde03
QAD decimal Field 3
 
->>,>>9.99
10
 
rhd__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
rhd__qadi02
QAD Integer Field 2
 
->,>>>,>>9
 
 
rhd__qadi03
QAD Integer Field 3
 
->,>>>,>>9
 
 
rhd__qadl01
QAD Logical Field 1
 
yes/no
 
 
rhd__qadl02
QAD Logical Field 2
 
yes/no
 
 
rhd__qadl03
QAD Logical Field 3
 
yes/no
 
 
rhd_chg_type
Charge Type
 
x(8)
 
 
rhd_cmtindx
Comment Index
 
>>>>>>>9
 
 
rhd_covered
Covered Amount
 
>>>>,>>>,>>9.99<<<
10
 
rhd_cpl_date
Received Date
Rec Date
99/99/99
 
 
rhd_cust
Customer
 
x(8)
 
 
rhd_customs
Customs Value
 
>>>>,>>>,>>9.99
10
 
rhd_cvr_pct
Coverage Percent
Cvr Per
->>,>>9.99
10
 
rhd_desc
Description
 
X(24)
 
 
rhd_domain
Domain
 
x(8)
 
 
rhd_done
Received
 
yes/no
 
 
rhd_edit_isb
Edit Installed Base
 
yes/no
 
 
rhd_end
End Time
 
99:99
 
 
rhd_enduser
End User
 
x(8)
 
 
rhd_eng_area
Eng Area
 
x(8)
 
 
rhd_eng_code
Engineer Code
Eng Code
x(8)
 
 
rhd_eu_area
End User Area
 
x(8)
 
 
rhd_exp_date
Expected Date
Exp Date
99/99/99
 
 
rhd_fault_cd
Fault Code
Fault
x(8)
 
 
rhd_file_type
 
 
x(3)
 
 
rhd_histype
History Type
 
x(4)
 
 
rhd_ins_date
Install Date
Ins Date
99/99/99
 
 
rhd_iss
Inv Iss
 
yes/no
 
 
rhd_line
Line
Ln
>>9
 
 
rhd_link
Line to Line
 
>>9
 
 
rhd_loaner
Loaner Sent
 
yes/no
 
 
rhd_loc
To Location
 
x(8)
 
 
rhd_mod_date
Modified Date
Mod Date
99/99/99
 
 
rhd_mod_userid
User ID
 
X(8)
 
 
rhd_nbr
Sales Order
Order
x(8)
 
 
rhd_op_tran
Op Tran
 
X(8)
 
 
rhd_par_date
Parent Install Date
Par Ins
99/99/99
 
 
rhd_par_part
Parent Item
 
x(18)
 
 
rhd_par_ser
Parent Serial
 
x(18)
 
 
rhd_part
Item
 
x(18)
 
 
rhd_prefix
Prefix
 
x(1)
 
 
rhd_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
rhd_process
Processing
 
x(2)
 
 
rhd_prodline
Product Line
Line
x(4)
 
 
rhd_qty_acp
Qty Received
 
->,>>>,>>9.9<<<<<<<<
10
 
rhd_qty_non
Qty Due Billed
 
->,>>>,>>9.9<<<
10
 
rhd_qty_ord
Qty Expected
 
->,>>>,>>9.9<<<<<<<<
10
 
rhd_qty_rel
Qty Released
 
->,>>>,>>9.9<<<
10
 
rhd_ref
Ref
 
>>>>>>>9
 
 
rhd_restock
Restock
 
>>>,>>9.99<<<
10
 
rhd_rev
Item Revision
 
x(8)
 
 
rhd_rma_line
RMA Line
Ln
>>9
 
 
rhd_rma_nbr
Return Id
Return
x(8)
 
 
rhd_rma_rtrn
Parts Return
 
yes/no
 
 
rhd_sa_nbr
Service Contract
 
x(8)
 
 
rhd_ser_lon
Loaner Serial
 
X(18)
 
 
rhd_serial
Serial
 
x(18)
 
 
rhd_ship
Ship To
 
x(8)
 
 
rhd_site
To Site
 
x(8)
 
 
rhd_start
Start Time
 
99:99
 
 
rhd_status
Status
 
x(8)
 
 
rhd_sv_code
Contract Type
 
x(8)
 
 
rhd_trans
Transaction
Tr
x(4)
 
 
rhd_trnbr
Transaction
 
>>>>>>>>>9
 
 
rhd_type
Type
 
x(2)
 
 
rhd_um
UM
 
X(2)
 
 
rhd_um_conv
UM Conv
 
>>>>9.9999<<<<
10
 
rhd_user1
Ufld1
 
x(8)
 
 
rhd_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rhd_hist
yes
oid_rhd_hist
yes
no
 
rhd_nbr
no
rhd_domain
yes
no
 
 
 
rhd_nbr
yes
no
 
rhd_part
no
rhd_domain
yes
no
 
 
 
rhd_part
yes
no
 
 
 
rhd_nbr
yes
no
 
 
 
rhd_prefix
yes
no
 
 
 
rhd_line
yes
no
rhd_trnbr
yes
rhd_domain
yes
no
 
 
 
rhd_file_type
yes
no
 
 
 
rhd_trnbr
yes
no
rma_mstr
Return Material Authorization Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rma_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rma__chr01
 
 
x(8)
 
 
rma__chr02
 
 
x(8)
 
 
rma__chr03
 
 
x(8)
 
 
rma__chr04
 
 
x(8)
 
 
rma__chr05
 
 
x(8)
 
 
rma__chr06
 
 
x(8)
 
 
rma__chr07
 
 
x(8)
 
 
rma__chr08
 
 
x(8)
 
 
rma__chr09
 
 
x(8)
 
 
rma__chr10
 
 
x(8)
 
 
rma__dec01
PST
 
>>>,>>>,>>9.99
10
 
rma__dec02
 
 
>>>,>>>,>>9.99
10
 
rma__dte01
 
 
99/99/99
 
 
rma__dte02
 
 
99/99/99
 
 
rma__log01
 
 
yes/no
 
 
rma__qadc01
QAD Character Field 1
 
X(8)
 
 
rma__qadc02
QAD Character Field 2
 
X(8)
 
 
rma__qadc03
QAD Character Field 3
 
X(8)
 
 
rma__qadc04
QAD Character Field 4
 
x(8)
 
 
rma__qadc05
QAD Character Field 5
 
x(8)
 
 
rma__qadd01
QAD Decimal Field 1
 
->>>>,>>>,>>9.99<<<
10
 
rma__qadd02
QAD Decimal Field 2
 
->>>>,>>>,>>9.99<<<
10
 
rma__qadd03
QAD Decimal Field 3
 
->>>>,>>>,>>9.99<<<
10
 
rma__qadd04
QAD Decimal Field 4
 
->>>>,>>>,>>9.99<<<
10
 
rma__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
rma__qadi02
QAD Integer Field 2
 
->,>>>,>>9
 
 
rma__qadi03
QAD Integer Field 3
 
->,>>>,>>9
 
 
rma__qadl01
QAD Logical Field 1
 
yes/no
 
 
rma__qadl02
QAD Logical Field 2
 
yes/no
 
 
rma__qadt01
QAD Date Field 1
 
99/99/99
 
 
rma__qadt02
QAD Date Field 2
 
99/99/99
 
 
rma__qadt03
QAD Date Field 3
 
99/99/99
 
 
rma_bill_to
Bill To
 
x(8)
 
 
rma_ca_nbr
Call Id
 
x(8)
 
 
rma_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
rma_complete
Complete
Cmp
yes/no
 
 
rma_contract
RMA Contract
 
x(8)
 
 
rma_crprlist
Credit Price List
Cr Price
x(8)
 
 
rma_cstmlist
Customs List
Customs
x(8)
 
 
rma_ctype
Contract Type
 
x(8)
 
 
rma_cust_ven
Customer
 
x(8)
 
 
rma_domain
Domain
 
x(8)
 
 
rma_enduser
End User
 
x(8)
 
 
rma_eng_code
Engineer Code
Eng Code
x(8)
 
 
rma_exp_date
Expected Date
Expected
99/99/99
 
 
rma_loc_iss
Issue Location
 
x(8)
 
 
rma_loc_rec
Receive Location
 
x(8)
 
 
rma_mod_date
Modified Date
Mod Date
99/99/99
 
 
rma_mod_userid
User ID
 
X(8)
 
 
rma_nbr
RMA
 
x(8)
 
 
rma_ord_date
Order Date
Ord Date
99/99/99
 
 
rma_pr_list
Price List
List
x(8)
 
 
rma_prefix
Prefix
 
x(1)
 
 
rma_prt_rec
Print Receiving Doc
Print Rec
yes/no
 
 
rma_req_date
Required Date
Required
99/99/99
 
 
rma_rstk_pct
Restocking Charge
Restock
->>9.99%
10
 
rma_rts_bol
BOL
 
x(18)
 
 
rma_ship
Ship-To
 
x(8)
 
 
rma_shipdate
Ship Date
 
99/99/99
 
 
rma_site_iss
Issue Site
 
x(8)
 
 
rma_site_rec
Receive Site
 
x(8)
 
 
rma_source
Order Source
Source
x(8)
 
 
rma_stat
Action Status
St
x(2)
 
 
rma_taxable
Taxable
Tax
yes/no
 
 
rma_taxc
Tax Class
TxC
x(3)
 
 
rma_type
Type
 
x(8)
 
 
rma_user1
Ufld1
 
x(8)
 
 
rma_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rma_mstr
yes
oid_rma_mstr
yes
no
 
rma_ca_nbr
no
rma_domain
yes
no
 
 
 
rma_ca_nbr
yes
no
 
 
 
rma_nbr
yes
no
 
rma_cust_ven
yes
rma_domain
yes
no
 
 
 
rma_cust_ven
yes
no
 
 
 
rma_nbr
yes
no
 
 
 
rma_prefix
yes
no
rma_nbr
yes
rma_domain
yes
no
 
 
 
rma_nbr
yes
no
 
 
 
rma_prefix
yes
no
rmc_ctrl
Return Material Authorization Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rmc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rmc__chr01
 
 
x(8)
 
 
rmc__chr02
 
 
x(8)
 
 
rmc__chr03
 
 
x(8)
 
 
rmc__chr04
 
 
x(8)
 
 
rmc__chr05
 
 
x(8)
 
 
rmc__chr06
 
 
x(8)
 
 
rmc__chr07
 
 
x(8)
 
 
rmc__chr08
 
 
x(8)
 
 
rmc__chr09
 
 
x(8)
 
 
rmc__chr10
 
 
x(8)
 
 
rmc__dec01
 
 
->>>,>>>,>>9.99
10
 
rmc__dec02
 
 
->>>,>>>,>>9.99
10
 
rmc__dec03
 
 
->>>,>>>,>>9.99
10
 
rmc__dte01
 
 
99/99/99
 
 
rmc__dte02
 
 
99/99/99
 
 
rmc__dte03
 
 
99/99/99
 
 
rmc__dte04
 
 
99/99/99
 
 
rmc__log01
 
 
yes/no
 
 
rmc__log02
 
 
yes/no
 
 
rmc__log03
 
 
yes/no
 
 
rmc__log04
 
 
yes/no
 
 
rmc__log05
 
 
yes/no
 
 
rmc__qadc01
QAD Character Field 1
 
X(8)
 
 
rmc__qadc02
QAD Character Field 2
 
X(8)
 
 
rmc__qadc03
QAD Character Field 3
 
X(8)
 
 
rmc__qadc04
 
 
x(4)
 
 
rmc__qadc05
 
 
x(8)
 
 
rmc__qadc06
 
 
x(4)
 
 
rmc__qadd01
QAD Decimal Field 1
 
->>>>,>>>,>>9.99<<<
10
 
rmc__qadd02
QAD Decimal Field 2
 
->>>>,>>>,>>9.99<<<
10
 
rmc__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
rmc__qadi02
QAD Integer Field 2
 
->,>>>,>>9
 
 
rmc__qadi03
 
 
>>>>>>9
 
 
rmc__qadi04
 
 
->>>>>>>9
 
 
rmc__qadl01
QAD Logical Field 1
 
yes/no
 
 
rmc__qadl02
QAD Logical Field 2
 
yes/no
 
 
rmc__qadl03
QAD Logical Field 3
 
yes/no
 
 
rmc_all_days
Allocate Days
 
>>>>>9
 
 
rmc_consume
Consume Forecast
Consume Fcst
yes/no
 
 
rmc_det_all
Detail Allocations
 
yes/no
 
 
rmc_dflt_rma
Default RMA Contract
 
x(8)
 
 
rmc_disp_trail
RMA Trailer Display
 
yes/no
 
 
rmc_domain
Domain
 
x(8)
 
 
rmc_edit_isb
Edit Installed Base
 
yes/no
 
 
rmc_hcmmts
RMA Header Comments
 
yes/no
 
 
rmc_hist
Return History
 
yes/no
 
 
rmc_history
Keep Booking History
 
yes/no
 
 
rmc_issues
Issues First
 
yes/no
 
 
rmc_lcmmts
RMA Line Comments
 
yes/no
 
 
rmc_loc_is
Customer Return Location
 
x(8)
 
 
rmc_loc_iv
Return From Supplier Loc
 
x(8)
 
 
rmc_loc_os
Customer Spares Location
 
x(8)
 
 
rmc_loc_ov
At Supplier Location
 
x(8)
 
 
rmc_mod_date
Modified Date
Mod Date
99/99/99
 
 
rmc_mod_userid
User ID
 
X(8)
 
 
rmc_node
Node
 
x(8)
 
 
rmc_pl
Item Product Line
 
yes/no
 
 
rmc_po_nbr
Next RTS Purchase Order
 
>>>>>>>9
 
 
rmc_po_pre
Purchase Order Prefix
 
x(3)
 
 
rmc_po_ratetype
RTS Rate Type
 
x(8)
 
 
rmc_print_trail
Print Trailer
 
yes/no
 
 
rmc_prt_rtn
Print No Charge Receipts
 
yes/no
 
 
rmc_rct_to_inv
RMA Receipt Ready to Invoice
RMA Receipt Invoice
yes/no
 
 
rmc_repair_cd
Repair Code
 
x(8)
 
 
rmc_rma_accounts
Display RMA accounts
 
yes/no
 
 
rmc_route
Schedule
 
x(8)
 
 
rmc_rtn_taxc
Tax Class for Returns
 
x(3)
 
 
rmc_rtv_trn
Default RTV Transaction
 
x(4)
 
 
rmc_site_is
Customer Return Site
 
x(8)
 
 
rmc_site_iv
Return From Supplier Site
 
x(8)
 
 
rmc_site_lb
Default Labor Site
 
x(8)
 
 
rmc_site_os
Customer Spares Site
 
x(8)
 
 
rmc_site_ov
At Supplier Site
 
x(8)
 
 
rmc_so_nbr
Next RMA Sales Order
 
>>>>>>>9
 
 
rmc_so_pre
RMA Sales Order Prefix
 
x(3)
 
 
rmc_so_ratetype
RMA Rate Type
 
x(8)
 
 
rmc_swsa
Display Service Contracts
 
yes/no
 
 
rmc_turn_days
Turn Around Days
 
>>9
 
 
rmc_user1
Ufld1
 
x(8)
 
 
rmc_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rmc_ctrl
yes
oid_rmc_ctrl
yes
no
rmc_node
yes
rmc_domain
yes
no
 
 
 
rmc_node
yes
no
rmd_det
Return Material Authorization Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rmd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rmd__chr01
 
 
x(8)
 
 
rmd__chr02
 
 
x(8)
 
 
rmd__chr03
 
 
x(8)
 
 
rmd__chr04
 
 
x(8)
 
 
rmd__chr05
 
 
x(8)
 
 
rmd__chr06
 
 
x(8)
 
 
rmd__chr07
 
 
x(8)
 
 
rmd__chr08
 
 
x(8)
 
 
rmd__chr09
 
 
x(8)
 
 
rmd__chr10
 
 
x(8)
 
 
rmd__dec01
 
 
>>>,>>>,>>9.99
10
 
rmd__dec02
 
 
>>>,>>>,>>9.99
10
 
rmd__dte01
 
 
99/99/99
 
 
rmd__dte02
 
 
99/99/99
 
 
rmd__log01
 
 
yes/no
 
 
rmd__qadc01
QAD Character Field 1
 
X(8)
 
 
rmd__qadc02
QAD Character Field 2
 
X(8)
 
 
rmd__qadc03
QAD Character Field 3
 
X(8)
 
 
rmd__qadc04
 
 
x(4)
 
 
rmd__qadd01
QAD Decimal Field 1
 
->>>>,>>>,>>9.99
10
 
rmd__qadd02
QAD Decimal Field 2
 
->>>>,>>>,>>9.99
10
 
rmd__qadd03
QAD Decimal Field 3
 
->>,>>9.99
10
 
rmd__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
rmd__qadi02
QAD Integer Field 2
 
->,>>>,>>9
 
 
rmd__qadi03
QAD Integer Field 3
 
->,>>>,>>9
 
 
rmd__qadl01
QAD Logical Field 1
 
yes/no
 
 
rmd__qadl02
QAD Logical Field 2
 
yes/no
 
 
rmd__qadl03
QAD Logical Field 3
 
yes/no
 
 
rmd__qadt01
QAD Date Field 1
 
99/99/99
 
 
rmd__qadt02
QAD Date Field 2
 
99/99/99
 
 
rmd__qadt03
QAD Date Field 3
 
99/99/99
 
 
rmd__qadt04
QAD Date Field 4
 
99/99/99
 
 
rmd__qadt05
QAD Date Field 5
 
99/99/99
 
 
rmd_chg_type
Charge Type
CT
x(2)
 
 
rmd_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
rmd_comment[5]
Comments
 
x(40)
 
 
rmd_covered
Covered Amount
 
>>>>,>>>,>>9.99<<<
10
 
rmd_cpl_date
Received Date
Rec Date
99/99/99
 
 
rmd_customs
Customs Value
 
>>>>,>>>,>>9.99<<<
10
 
rmd_cvr_pct
Coverage Percent
Cvr Per
->>,>>9.99
10
 
rmd_desc
Description
 
x(24)
 
 
rmd_domain
Domain
 
x(8)
 
 
rmd_done
Received
 
yes/no
 
 
rmd_edit_isb
Edit Installed Base
 
yes/no
 
 
rmd_end
End Time
End
99:99
 
 
rmd_eng_code
Engineer Code
Eng Code
x(8)
 
 
rmd_exp_date
Expected Date
Exp Date
99/99/99
 
 
rmd_fault_cd
Fault Code
Fault
x(8)
 
 
rmd_ins_date
Install Date
 
99/99/99
 
 
rmd_iss
Inv Iss
 
yes/no
 
 
rmd_line
Line
Ln
>>9
 
 
rmd_link
Line to Line
 
>>9
 
 
rmd_loaner
Loaner Sent
 
yes/no
 
 
rmd_loc
To Location
 
x(8)
 
 
rmd_mod_date
Modified Date
Mod Date
99/99/99
 
 
rmd_mod_userid
User ID
 
X(8)
 
 
rmd_nbr
Sales Order
Order
x(8)
 
 
rmd_op_tran
Op Tran
 
x(8)
 
 
rmd_par_date
Parent Install Date
 
99/99/99
 
 
rmd_par_part
Parent Item
 
x(18)
 
 
rmd_par_ser
Parent Serial
 
x(18)
 
 
rmd_part
Item
 
x(18)
 
 
rmd_prefix
Prefix
 
x(1)
 
 
rmd_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
rmd_process
Processing
 
x(2)
 
 
rmd_prodline
Product Line
Line
x(4)
 
 
rmd_qty_acp
Qty Received
 
->,>>>,>>9.9<<<<<<<<
10
 
rmd_qty_non
Qty Due Billed
 
->,>>>,>>9.9<<<<<<<<
10
 
rmd_qty_ord
Qty Expected
 
->,>>>,>>9.9<<<<<<<<
10
 
rmd_qty_rel
Qty Released
 
->,>>>,>>9.9<<<<<<<<
10
 
rmd_ref
Ref
 
>>>>>>>9
 
 
rmd_restock
Restock
 
>>>,>>9.99<<<
10
 
rmd_rev
Item Revision
 
x(8)
 
 
rmd_rma_line
RMA Line
Ln
>>9
 
 
rmd_rma_nbr
Return Id
Return
x(8)
 
 
rmd_rma_rtrn
Parts Return
 
yes/no
 
 
rmd_route
Schedule
 
x(8)
 
 
rmd_sa_nbr
Service Contract
 
x(8)
 
 
rmd_ser
Lot/Serial
 
x(18)
 
 
rmd_ser_lon
Loaner Serial
 
x(18)
 
 
rmd_site
To Site
 
x(8)
 
 
rmd_start
Start Time
Start
99:99
 
 
rmd_status
Status
 
x(8)
 
 
rmd_sv_code
Contract Type
 
x(8)
 
 
rmd_type
Type
 
x(2)
 
 
rmd_um
UM
 
x(2)
 
 
rmd_um_conv
UM Conversion
UM Conv
>>>>9.9999<<<<
10
 
rmd_user1
Ufld1
 
x(8)
 
 
rmd_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rmd_det
yes
oid_rmd_det
yes
no
 
rmd_link
no
rmd_domain
yes
no
 
 
 
rmd_rma_nbr
yes
no
 
 
 
rmd_rma_line
yes
no
 
 
 
rmd_prefix
yes
no
rmd_nbrln
yes
rmd_domain
yes
no
 
 
 
rmd_nbr
yes
no
 
 
 
rmd_prefix
yes
no
 
 
 
rmd_line
yes
no
 
rmd_part
no
rmd_domain
yes
no
 
 
 
rmd_part
yes
no
 
 
 
rmd_exp_date
yes
no
 
 
 
rmd_fault_cd
yes
no
 
rmd_type
no
rmd_domain
yes
no
 
 
 
rmd_prefix
yes
no
 
 
 
rmd_type
yes
no
 
 
 
rmd_nbr
yes
no
 
 
 
rmd_line
yes
no
rndc_mstr
Country Code and Currency with Rounding Method
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rndc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rndc__qadc01
QAD Character Field 1
 
x(24)
 
 
rndc__qadc02
QAD Character Field 2
 
x(24)
 
 
rndc__qadd01
QAD Decimal Field 1
 
->>>,>>>,>>9.99<<
10
 
rndc__qadt01
QAD Date Field 1
 
99/99/99
 
 
rndc_acct
Account
Account
x(8)
 
 
rndc_curr
Currency
Cur
x(3)
 
 
rndc_dest_ctry
Destination Country
Dest Ctry
x(3)
 
 
rndc_domain
Domain
 
x(8)
 
 
rndc_mod_date
Modified Date
Mod Date
99/99/99
 
 
rndc_mod_userid
User ID
 
x(8)
 
 
rndc_orig_ctry
Originating Country
Orig Ctry
x(3)
 
 
rndc_rnd_mthd
Rounding Method
Rnd!Mthd
x(1)
 
 
rndc_sub
Sub-Account
Sub-Acct
x(8)
 
 
rndc_user1
User Field Character 1
 
x(24)
 
 
rndc_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rndc_mstr
yes
oid_rndc_mstr
yes
no
rndc_rnd_mthd
yes
rndc_domain
yes
no
 
 
 
rndc_curr
yes
no
 
 
 
rndc_orig_ctry
yes
no
 
 
 
rndc_dest_ctry
yes
no
rnd_mstr
Rounding Method Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rnd_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rnd__chr01
 
 
x(8)
 
 
rnd__chr02
 
 
x(8)
 
 
rnd__chr03
 
 
x(8)
 
 
rnd__chr04
 
 
x(8)
 
 
rnd__qad01
 
 
x(8)
 
 
rnd__qad02
 
 
x(8)
 
 
rnd__qad03
 
 
x(8)
 
 
rnd__qad04
 
 
x(8)
 
 
rnd__qadc01
 
 
x(24)
 
 
rnd__qadc02
 
 
x(24)
 
 
rnd_desc
Description
 
x(24)
 
 
rnd_rnd_mthd
Rounding Method
Rnd!Mthd
x(1)
 
 
rnd_thrshld
Rounding Threshold
Threshold
>,>>9.9999
10
 
rnd_unit
Rounding Unit
Rnd Unit
>,>>9.999
10
 
rnd_user1
Ufld1
 
x(8)
 
 
rnd_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rnd_mstr
yes
oid_rnd_mstr
yes
no
 
rnd_desc
no
rnd_desc
yes
no
 
 
 
rnd_rnd_mthd
yes
no
rnd_rnd_mthd
yes
rnd_rnd_mthd
yes
no
Role
Role
 
 
Field Name
Label
Col-Label
Format
Dec
 
BusComponent_ID
Business Component
 
-99999999999
 
 
CustomCombo0
 
 
x(20)
 
 
CustomCombo1
 
 
x(20)
 
 
CustomCombo2
 
 
x(20)
 
 
CustomCombo3
 
 
x(20)
 
 
CustomCombo4
 
 
x(20)
 
 
CustomCombo5
 
 
x(20)
 
 
CustomCombo6
 
 
x(20)
 
 
CustomCombo7
 
 
x(20)
 
 
CustomCombo8
 
 
x(20)
 
 
CustomCombo9
 
 
x(20)
 
 
CustomDate0
 
 
99/99/9999
 
 
CustomDate1
 
 
99/99/9999
 
 
CustomDate2
 
 
99/99/9999
 
 
CustomDate3
 
 
99/99/9999
 
 
CustomDate4
 
 
99/99/9999
 
 
CustomDecimal0
 
 
->,>>>,>>9.99
4
 
CustomDecimal1
 
 
->,>>>,>>9.99
4
 
CustomDecimal2
 
 
->,>>>,>>9.99
4
 
CustomDecimal3
 
 
->,>>>,>>9.99
4
 
CustomDecimal4
 
 
->,>>>,>>9.99
4
 
CustomInteger0
 
 
->,>>>,>>9
 
 
CustomInteger1
 
 
->,>>>,>>9
 
 
CustomInteger2
 
 
->,>>>,>>9
 
 
CustomInteger3
 
 
->,>>>,>>9
 
 
CustomInteger4
 
 
->,>>>,>>9
 
 
CustomLong0
 
 
x(255)
 
 
CustomLong1
 
 
x(255)
 
 
CustomNote
 
 
x(2000)
 
 
CustomShort0
 
 
x(20)
 
 
CustomShort1
 
 
x(20)
 
 
CustomShort2
 
 
x(20)
 
 
CustomShort3
 
 
x(20)
 
 
CustomShort4
 
 
x(20)
 
 
CustomShort5
 
 
x(20)
 
 
CustomShort6
 
 
x(20)
 
 
CustomShort7
 
 
x(20)
 
 
CustomShort8
 
 
x(20)
 
 
CustomShort9
 
 
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
 
 
Role_ID
Record ID
 
-99999999999
 
 
RoleBusComponentConcept
Component Concept
 
x(20)
 
 
RoleDescription
Role Description
 
x(24)
 
 
RoleIsActive
Active
 
yes/no
 
 
RoleModuleURI
Module URI
 
x(170)
 
 
RoleName
Role Name
 
x(20)
 
 
RoleSODException
is SOD exception
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Component
no
BusComponent_ID
yes
no
 ∗
Prim
yes
Role_ID
yes
no
 
RoleName
yes
RoleName
yes
no
 
SODExcptIdx
no
RoleSODException
yes
no
RoleResource
Link Role-Resource
 
 
Field Name
Label
Col-Label
Format
Dec
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Resource_ID
Resource
 
-99999999999
 
 
Role_ID
Role
 
-99999999999
 
 
RoleResource_ID
Record ID
 
-99999999999
 
 
RoleResourceIsDefault
Default
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
Prim
yes
RoleResource_ID
yes
no
 
Resource_FK
no
Resource_ID
yes
no
 
Role_FK
no
Role_ID
yes
no
RoundingMethod
Rounding Method
 
 
Field Name
Label
Col-Label
Format
Dec
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
RoundingMethod_ID
Record ID
 
-99999999999
 
 
RoundingMethodCode
Code
 
x(1)
 
 
RoundingMethodDescription
Description
 
x(24)
 
 
RoundingMethodThreshold
Threshold
 
>,>>9.9999
4
 
RoundingMethodUnit
Unit
 
>,>>9.999
3
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Code
yes
RoundingMethodCode
yes
no
 ∗
Prim
yes
RoundingMethod_ID
yes
no
ro_det
Routing Operation Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_ro_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ro__chr01
 
 
x(8)
 
 
ro__chr02
 
 
x(8)
 
 
ro__chr03
 
 
x(8)
 
 
ro__chr04
 
 
x(8)
 
 
ro__chr05
 
 
x(8)
 
 
ro__dec01
 
 
>>>,>>>,>>9.99
10
 
ro__dec02
 
 
>>>,>>>,>>9.99
10
 
ro__dte01
 
 
99/99/99
 
 
ro__dte02
 
 
99/99/99
 
 
ro__log01
 
 
yes/no
 
 
ro__qadc01
QAD Character Field 1
 
X(8)
 
 
ro__qadc02
QAD Character Field 2
 
X(8)
 
 
ro__qadc03
QAD Character Field 3
 
X(8)
 
 
ro__qade01
QAD Decimal Field 1
 
->>>,>>>,>>9.99<<
10
 
ro__qade02
QAD Decimal Field 2
 
->>>,>>>,>>9.99<<
10
 
ro__qadl01
QAD Logical Field 1
 
yes/no
 
 
ro__qadl02
QAD Logical Field 2
 
yes/no
 
 
ro__qadt01
QAD Date Field 1
 
99/99/99
 
 
ro__qadt02
QAD Date Field 2
 
99/99/99
 
 
ro_auto_lbr
Auto Labor Report
 
yes/no
 
 
ro_batch
Batch Qty
Batch!Qty
>,>>>,>>9.9<<<<<<<<
10
 
ro_bom_code
BOM Code
 
x(18)
 
 
ro_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ro_cost
Cost
 
>>>>,>>>,>>9.99<<<
10
 
ro_cyc_rate
Cycles/Hour
 
>>>,>>9.999
10
 
ro_cyc_unit
Units/Cycle
 
>>>>>9
10
 
ro_desc
Description
 
x(24)
 
 
ro_domain
Domain
 
x(8)
 
 
ro_elm_bdn
Burden Element
Bdn Elmt
x(8)
 
 
ro_elm_lbr
Labor Element
Lbr Elmt
x(8)
 
 
ro_elm_sub
Subcontract Element
Sub Elmt
x(8)
 
 
ro_end
End Date
End
99/99/99
 
 
ro_end_ecn
End ECN
 
x(8)
 
 
ro_fsc_code
Service Category
 
X(8)
 
 
ro_fsm_type
FSM Type
 
x(8)
 
 
ro_inv_value
Inventory Value
 
>>>>,>>>,>>9.99<<<
10
 
ro_lbr_ovhd
Labor Overhead
Labor Ovhd
>>,>>9.999
10
 
ro_mch
Machine
 
x(8)
 
 
ro_mch_op
Machines per Op
Mach / Op
->,>>>,>>9
 
 
ro_men_mch
Run Crew
 
->>,>>9.99
10
 
ro_milestone
Milestone Operation
Milestone
yes/no
 
 
ro_mod_date
Modified Date
Mod Date
99/99/99
 
 
ro_mod_userid
User ID
 
X(8)
 
 
ro_move
Move Time
Move
>,>>9.9<<
10
 
ro_mv_nxt_op
Move Next Op
 
yes/no
 
 
ro_op
Operation
Op
>>>>9
 
 
ro_po_line
Line
Ln
>>9
 
 
ro_po_nbr
Purchase Order
PO
x(8)
 
 
ro_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
ro_queue
Queue Time
Queue
>,>>9.9<<
10
 
ro_rollup
Rollup Reqd
 
yes/no
 
 
ro_rollup_id
Rollup ID
 
x(8)
 
 
ro_routing
Routing Code
 
x(18)
 
 
ro_run
Run Time
Run
>>>,>>>,>>9.9<<<<<<<<
10
 
ro_setup
Setup Time
Setup
>,>>9.9<<
10
 
ro_setup_men
Setup Crew
 
->>,>>9.99
10
 
ro_start
Start Date
Start
99/99/99
 
 
ro_start_ecn
Start ECN
 
x(8)
 
 
ro_std_batch
Standard Batch Size
Batch
>>>,>>9.9
10
 
ro_std_op
Standard Operation
Std Op
x(8)
 
 
ro_sub_cost
Subcontract Cost
Subcontract
>>>>,>>>,>>9.99<<<
10
 
ro_sub_lead
Subcontract LT
Sub LT
>>9
 
 
ro_tool
Tool Code
Tool
x(8)
 
 
ro_tran_qty
Overlap Units
Overlap
->,>>>,>>9
 
 
ro_user1
Ufld1
 
x(8)
 
 
ro_user2
Ufld2
 
x(8)
 
 
ro_vend
Supplier
 
x(8)
 
 
ro_wait
Wait Time
Wait
>,>>9.9<<
10
 
ro_wipmtl_part
WIP Item
 
x(18)
 
 
ro_wkctr
Work Center
Work Ctr
x(8)
 
 
ro_yield_pct
Yield%
 
>>9.99%
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_ro_det
yes
oid_ro_det
yes
no
 
ro_fsm_type
no
ro_domain
yes
no
 
 
 
ro_fsm_type
yes
no
 
 
 
ro_routing
yes
no
 
 
 
ro_op
yes
no
ro_routing
yes
ro_domain
yes
no
 
 
 
ro_routing
yes
no
 
 
 
ro_op
yes
no
 
 
 
ro_start
yes
no
 
ro_wkctr
no
ro_domain
yes
no
 
 
 
ro_wkctr
yes
no
 
 
 
ro_mch
yes
no
rpc_ctrl
Repetitive Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rpc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rpc__qadc01
 
 
x(8)
 
 
rpc__qadi01
 
 
->>>>>>>9
 
 
rpc_allow_rate
Allow Zero Run Rate
 
yes/no
 
 
rpc_domain
Domain
 
x(8)
 
 
rpc_eff_days
End Eff Days
 
>>9
 
 
rpc_eff_dflt
End Eff Default Method
 
X(1)
 
 
rpc_inc_yld
Include Yield
 
yes/no
 
 
rpc_nbr
Next Picklist
P/L Nbr
>>>>>>>9
 
 
rpc_nbr_pre
P/L Prefix
Pre
x(3)
 
 
rpc_sch_bck
Consume Back
Back
->>9
 
 
rpc_sch_fwd
Consume Forward
Fwd
->>9
 
 
rpc_user1
Ufld1
 
x(8)
 
 
rpc_user2
Ufld2
 
x(8)
 
 
rpc_using_new
Enable New Repetitive
 
yes/no
 
 
rpc_wk_start
Start Week
Week!Day
9
 
 
rpc_wxfer_acct
WIP Transfer Acct
 
X(8)
 
 
rpc_wxfer_cc
WIP Transfer CC
 
X(4)
 
 
rpc_wxfer_sub
WIP Transit Sub-Acct
Sub-Acct
x(8)
 
 
rpc_xfer_wip
Transfer WIP
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rpc_ctrl
yes
oid_rpc_ctrl
yes
no
rpc_index1
yes
rpc_domain
yes
no
rps_mstr
Repetitive Production Schedule Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rps_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rps__qadc01
 
 
x(8)
 
 
rps_bom_code
BOM/Formula
 
x(18)
 
 
rps_domain
Domain
 
x(8)
 
 
rps_due_date
Due Date
 
99/99/99
 
 
rps_line
Production Line
Line
x(8)
 
 
rps_part
Item Number
 
x(18)
 
 
rps_qty_comp
Qty Completed
 
->,>>>,>>9.9<<<<<<<<
10
 
rps_qty_req
Qty Scheduled
 
->,>>>,>>9.9<<<<<<<<
10
 
rps_record
 
 
>>>>>>9
 
 
rps_rel_date
Release
Rel Date
99/99/99
 
 
rps_routing
Routing Code
 
x(18)
 
 
rps_site
Site
 
x(8)
 
 
rps_user1
Ufld1
 
x(8)
 
 
rps_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rps_mstr
yes
oid_rps_mstr
yes
no
rps_part
yes
rps_domain
yes
no
 
 
 
rps_part
yes
no
 
 
 
rps_site
yes
no
 
 
 
rps_line
yes
no
 
 
 
rps_due_date
yes
no
 
rps_record
yes
rps_domain
yes
no
 
 
 
rps_record
yes
no
 
rps_site
yes
rps_domain
yes
no
 
 
 
rps_site
yes
no
 
 
 
rps_part
yes
no
 
 
 
rps_line
yes
no
 
 
 
rps_due_date
yes
no
 
rps_site_line
no
rps_domain
yes
no
 
 
 
rps_site
yes
no
 
 
 
rps_line
yes
no
 
 
 
rps_rel_date
yes
no
 
 
 
rps_part
yes
no
 
rqa_mstr
Requisition Approver Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqa_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqa__chr01
 
 
x(8)
 
 
rqa__chr02
 
 
x(8)
 
 
rqa__chr03
 
 
x(8)
 
 
rqa__chr04
 
 
x(8)
 
 
rqa__qadc01
QAD Field
 
X(8)
 
 
rqa__qadc02
QAD Field
 
X(8)
 
 
rqa__qadc03
QAD Field
 
X(8)
 
 
rqa__qadc04
QAD Field
 
X(8)
 
 
rqa_admin_apr
Administrative Approver
Admin.
x(8)
 
 
rqa_alt_apr[2]
Alternate Approver
Alt.
x(8)
 
 
rqa_apr
User Id
 
x(8)
 
 
rqa_apr_level
Approval Level
Approval!Level
99
 
 
rqa_apr_req
Approval Required
Req
yes/no
 
 
rqa_category
Category
 
x(8)
 
 
rqa_cc_from
Cost Ctr From
From!CC
X(4)
 
 
rqa_cc_to
Cost Ctr To
To!CC
X(4)
 
 
rqa_domain
Domain
 
x(8)
 
 
rqa_end
End Effective
End
99/99/99
 
 
rqa_entity
Entity
 
x(20)
 
 
rqa_job
Job
 
X(8)
 
 
rqa_prod_line
Product Line
Product!Line
x(8)
 
 
rqa_rvw_level
Review Level
Review!Level
99
 
 
rqa_rvw_req
Review Required
Req
yes/no
 
 
rqa_site
Site
 
x(8)
 
 
rqa_start
Start Effective
Start
99/99/99
 
 
rqa_sub_from
Sub-Account From
From!Sub
X(8)
 
 
rqa_sub_to
Sub-Account To
To!Sub
X(8)
 
 
rqa_type
Type
 
>9
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqa_mstr
yes
oid_rqa_mstr
yes
no
rqa_apr_type
yes
rqa_domain
yes
no
 
 
 
rqa_apr
yes
no
 
 
 
rqa_type
yes
no
 
 
 
rqa_site
yes
no
 
 
 
rqa_prod_line
yes
no
 
 
 
rqa_entity
yes
no
 
 
 
rqa_job
yes
no
 
 
 
rqa_category
yes
no
 
 
 
rqa_sub_from
yes
no
 
 
 
rqa_cc_from
yes
no
 
 
 
rqa_start
yes
no
 
rqa_type
yes
rqa_domain
yes
no
 
 
 
rqa_type
yes
no
 
 
 
rqa_site
yes
no
 
 
 
rqa_prod_line
yes
no
 
 
 
rqa_entity
yes
no
 
 
 
rqa_job
yes
no
 
 
 
rqa_category
yes
no
 
 
 
rqa_sub_from
yes
no
 
 
 
rqa_cc_from
yes
no
 
 
 
rqa_start
yes
no
 
 
 
rqa_apr
yes
no
 
rqa_type_apr
yes
rqa_domain
yes
no
 
 
 
rqa_type
yes
no
 
 
 
rqa_apr
yes
no
 
 
 
rqa_site
yes
no
 
 
 
rqa_prod_line
yes
no
 
 
 
rqa_entity
yes
no
 
 
 
rqa_job
yes
no
 
 
 
rqa_category
yes
no
 
 
 
rqa_sub_from
yes
no
 
 
 
rqa_cc_from
yes
no
 
 
 
rqa_start
yes
no
rqcd_det
Requisition Category Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqcd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqcd__chr01
 
 
x(8)
 
 
rqcd__chr02
 
 
x(8)
 
 
rqcd__chr03
 
 
x(8)
 
 
rqcd__chr04
 
 
x(8)
 
 
rqcd__qadc01
QAD Field
 
X(8)
0
 
rqcd__qadc02
QAD Field
 
X(8)
0
 
rqcd__qadc03
QAD Field
 
X(8)
0
 
rqcd__qadc04
QAD Field
 
X(8)
0
 
rqcd_acct_from
Account From
 
x(8)
 
 
rqcd_acct_to
Account To
 
x(8)
 
 
rqcd_category
Category
 
x(8)
 
 
rqcd_domain
Domain
 
x(8)
 
 
rqcd_sub_from
Sub-Account From
 
x(8)
 
 
rqcd_sub_to
Sub-Account To
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqcd_det
yes
oid_rqcd_det
yes
no
 
rqcd_acct_from
no
rqcd_domain
yes
no
 
 
 
rqcd_acct_from
yes
no
 
 
 
rqcd_sub_from
yes
no
 
 
 
rqcd_category
yes
no
rqcd_category
yes
rqcd_domain
yes
no
 
 
 
rqcd_category
yes
no
 
 
 
rqcd_acct_from
yes
no
 
 
 
rqcd_sub_from
yes
no
rqc_mstr
Requisition Category Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rqc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rqc__chr01
 
 
x(8)
 
 
rqc__chr02
 
 
x(8)
 
 
rqc__chr03
 
 
x(8)
 
 
rqc__chr04
 
 
x(8)
 
 
rqc__qadc01
QAD Field
 
X(8)
0
 
rqc__qadc02
QAD Field
 
X(8)
0
 
rqc__qadc03
QAD Field
 
X(8)
0
 
rqc__qadc04
QAD Field
 
X(8)
0
 
rqc_category
Category
 
x(8)
 
 
rqc_desc
Description
 
x(24)
 
 
rqc_domain
Domain
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rqc_mstr
yes
oid_rqc_mstr
yes
no
rqc_category
yes
rqc_domain
yes
no
 
 
 
rqc_category
yes
no
 
rqc_desc
no
rqc_domain
yes
no
 
 
 
rqc_desc
yes
no