QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
ShipViaM
Warehousing Ship Via/Service Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(40)
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_ShipViaM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
QadC01
QAD Field
 
x(24)
0
 
QadC02
QAD Field
 
x(24)
0
 
QadC03
QAD Field
 
x(24)
0
 
QadC04
QAD Field
 
x(24)
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
 
 
Service
Service
 
x(20)
 
 
ShipVia
Carrier
 
x(20)
 
 
UserC01
User Field Character 1
 
x(24)
 
 
UserC02
User Field Character 2
 
x(24)
 
 
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
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_ShipViaM
yes
oid_ShipViaM
yes
no
 
Service
no
Domain
yes
no
 
 
 
Service
yes
no
ShipViaMIdx
yes
Domain
yes
no
 
 
 
ShipVia
yes
no
 
 
 
Service
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
UserC01
yes
no
 
 
 
UserC02
yes
no
shm_mstr
Shipping Schedule Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shm__qadc01
 
 
x(8)
 
 
shm_cmtindx
Comment Index
Comment
>>>,>>>,>>9
 
 
shm_code
Transport ID
Trans ID
x(8)
 
 
shm_domain
Domain
 
x(8)
 
 
shm_end
End
 
99/99/99
 
 
shm_load_lt
Load LT
 
->>9.9<
10
 
shm_no_units
Available Units
Units
->,>>>,>>9
 
 
shm_rec_day[7]
Receive Days
 
yes/no
 
 
shm_rec_site
Receiving Site
Rec Site
x(8)
 
 
shm_ship_day[7]
Ship Days
 
yes/no
 
 
shm_src_site
Source Site
Source
x(8)
 
 
shm_start
Start
 
99/99/99
 
 
shm_transit
Transit LT
Transit
->>9.9<
10
 
shm_unld_lt
Unload LT
 
->>9.9<
10
 
shm_user1
Ufld1
 
x(8)
 
 
shm_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shm_mstr
yes
oid_shm_mstr
yes
no
shm_code
yes
shm_domain
yes
no
 
 
 
shm_code
yes
no
 
 
 
shm_src_site
yes
no
 
 
 
shm_rec_site
yes
no
 
 
 
shm_start
yes
no
 
shm_rec_site
yes
shm_domain
yes
no
 
 
 
shm_rec_site
yes
no
 
 
 
shm_src_site
yes
no
 
 
 
shm_code
yes
no
 
 
 
shm_start
yes
no
 
shm_src_site
yes
shm_domain
yes
no
 
 
 
shm_src_site
yes
no
 
 
 
shm_rec_site
yes
no
 
 
 
shm_code
yes
no
 
 
 
shm_start
yes
no
shop_cal
Shop Calendar
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shop_cal
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shop__qadc01
 
 
x(8)
 
 
shop_domain
Domain
 
x(8)
 
 
shop_hours[7]
Daily Hours
Hours
->>,>>9.99
10
 
shop_mch
Machine
 
x(8)
 
 
shop_shifts[7]
Shifts
 
yes/no
 
 
shop_site
Site
 
x(8)
 
 
shop_user1
Ufld1
 
x(8)
 
 
shop_user2
Ufld2
 
x(8)
 
 
shop_wdays[7]
Workdays
 
yes/no
 
 
shop_wkctr
Work Center
Work Ctr
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shop_cal
yes
oid_shop_cal
yes
no
shop_cal
yes
shop_domain
yes
no
 
 
 
shop_site
yes
no
 
 
 
shop_wkctr
yes
no
 
 
 
shop_mch
yes
no
ShortcutAct
shortcut key
 
 
Field Name
Label
Col-Label
Format
Dec
 
BusActivity_ID
Business Activity
 
-99999999999
 
 
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
 
 
ShortcutAct_ID
Record ID
 
-99999999999
 
 
ShortcutActKey
Shortcut Key
 
x(10)
 
 
Usr_ID
User
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BusActivity
no
BusActivity_ID
yes
no
 ∗
prim
yes
ShortcutAct_ID
yes
no
 
Usr
no
Usr_ID
yes
no
 
UsrIdBusActivity
yes
Usr_ID
yes
no
 
 
 
BusActivity_ID
yes
no
 
UsrIdShortcActKey
yes
Usr_ID
yes
no
 
 
 
ShortcutActKey
yes
no
shpc_ctrl
Shipment Performance Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shpc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shpc__qadc01
 
 
X(24)
 
 
shpc__qadc02
 
 
X(24)
 
 
shpc__qadi01
 
 
->>>>>>>9
 
 
shpc_active
Enable Shipment Performance
 
yes/no
 
 
shpc_domain
Domain
 
x(8)
 
 
shpc_include_do
Include Distribution Orders
 
yes/no
 
 
shpc_include_mo
Include Material Orders
 
yes/no
 
 
shpc_include_rma
Include RMA Shipments
 
yes/no
 
 
shpc_include_sched
Include Scheduled Orders
 
yes/no
 
 
shpc_include_so
Include Sales Orders
 
yes/no
 
 
shpc_meas_subtype
Measurement Sub Type
 
9
 
 
shpc_mod_date
Modified Date
Mod Date
99/99/99
 
 
shpc_mod_userid
User ID
 
x(8)
 
 
shpc_sched_type
Schedule Type
 
>9
 
 
shpc_shipper_reasons
Enter Reason Codes in Workbench
 
yes/no
 
 
shpc_use_current
Use Current Release
 
yes/no
 
 
shpc_user1
User Field Character 1
 
X(24)
 
 
shpc_user2
User Field Character 2
 
X(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shpc_ctrl
yes
oid_shpc_ctrl
yes
no
shpc_index1
yes
shpc_domain
yes
no
shpd_hist
Shipment Performance Detail History
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shpd_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shpd__qadc01
 
 
X(24)
 
 
shpd__qadc02
 
 
X(24)
 
 
shpd_acceptable
Acceptable
 
yes/no
 
 
shpd_domain
Domain
 
x(8)
 
 
shpd_meas_subtype
Measurement Sub Type
Sub Type
9
 
 
shpd_measurement_type
Type
 
>
 
 
shpd_mod_date
Modified Date
Mod Date
99/99/99
 
 
shpd_mod_userid
User ID
 
X(8)
 
 
shpd_rsn_code
Reason
 
x(8)
 
 
shpd_rsn_type
Reason Type
Rsn Type
x(8)
 
 
shpd_status_code
Status
 
x(8)
 
 
shpd_tran_id
Tran ID
 
>>>>>>>>9
 
 
shpd_user1
User Field Character 1
 
X(24)
 
 
shpd_user2
User Field Character 2
 
X(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shpd_hist
yes
oid_shpd_hist
yes
no
 
shpd_reason
no
shpd_domain
yes
no
 
 
 
shpd_acceptable
yes
no
 
 
 
shpd_measurement_type
yes
no
 
 
 
shpd_meas_subtype
yes
no
 
 
 
shpd_rsn_code
yes
no
 
shpd_status
no
shpd_domain
yes
no
 
 
 
shpd_acceptable
yes
no
 
 
 
shpd_measurement_type
yes
no
 
 
 
shpd_meas_subtype
yes
no
 
 
 
shpd_status_code
yes
no
shpd_tran_id
yes
shpd_domain
yes
no
 
 
 
shpd_tran_id
yes
no
 
 
 
shpd_measurement_type
yes
no
 
 
 
shpd_meas_subtype
yes
no
shphr_det
Data Validation Rule Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_dv_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_shphr_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shphr__qadc01
 
 
x(24)
 
 
shphr__qadc02
 
 
x(24)
 
 
shphr_allow_import
Allow Import
 
yes/no
 
 
shphr_category
Category
 
x(8)
 
 
shphr_desc
Description
 
x(24)
 
 
shphr_domain
Domain
 
x(8)
 
 
shphr_id
Rule ID
 
x(8)
 
 
shphr_import_date
Last Imported
 
99/99/99
 
 
shphr_import_filename
Import Filename
 
x(18)
 
 
shphr_import_userid
User ID
 
x(8)
 
 
shphr_mod_date
Modified Date
Mod Date
99/99/99
 
 
shphr_mod_userid
User ID
 
x(8)
 
 
shphr_user1
User Field Character 1
 
x(24)
 
 
shphr_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shphr_det
yes
oid_shphr_det
yes
no
 
shphr_category
no
shphr_domain
yes
no
 
 
 
shphr_category
yes
no
 
shphr_domain
no
shphr_domain
yes
no
 
 
 
shphr_id
yes
no
shphr_id
yes
oid_dv_mstr
yes
no
 
 
 
shphr_id
yes
no
shphvd_det
Field Validation Allowed Value Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shphv_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_shphvd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shphvd__qadc01
 
 
x(24)
 
 
shphvd__qadc02
 
 
x(24)
 
 
shphvd_field_value
Field Value
 
x(30)
 
 
shphvd_mod_date
Modified Date
Mod Date
99/99/99
 
 
shphvd_mod_userid
User ID
 
x(8)
 
 
shphvd_user1
User Field Character 1
 
x(24)
 
 
shphvd_user2
User Field Character 2
 
x(24)
 
 
shphvd_value_desc
Value Description
 
x(30)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shphvd_det
yes
oid_shphvd_det
yes
no
shphvd_field_value
yes
oid_shphv_det
yes
no
 
 
 
shphvd_field_value
yes
no
shphvpv_det
Validation/Prompt Location Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shphv_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_shphvpv_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shphvpv__qadc01
 
 
x(24)
 
 
shphvpv__qadc02
 
 
x(24)
 
 
shphvpv_location
Location
 
x(22)
 
 
shphvpv_mod_date
Modified Date
Mod Date
99/99/99
 
 
shphvpv_mod_userid
User ID
 
x(8)
 
 
shphvpv_prompt
Prompt
 
yes/no
 
 
shphvpv_type
Type
 
9
 
 
shphvpv_user1
User Field Character 1
 
x(24)
 
 
shphvpv_user2
User Field Character 2
 
x(24)
 
 
shphvpv_val_level
Validation Level
 
9
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shphvpv_det
yes
oid_shphvpv_det
yes
no
shphvpv_location
yes
oid_shphv_det
yes
no
 
 
 
shphvpv_type
yes
no
 
 
 
shphvpv_location
yes
no
shphv_det
Rule Field Validation Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shphr_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_shphv_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shphv__qadc01
 
 
x(24)
 
 
shphv__qadc02
 
 
x(24)
 
 
shphv_allow_blank
Allow Blank
 
yes/no
 
 
shphv_allow_undefined
Allow Undefined
 
yes/no
 
 
shphv_cmtindx
Comments
 
>>>>>>>9
 
 
shphv_default
Default Value
 
x(30)
 
 
shphv_desc
Description
 
x(40)
 
 
shphv_domain
Domain
 
x(8)
 
 
shphv_end_eff
End Effective
 
99/99/99
 
 
shphv_enforce_case
Enforce Case
 
yes/no
 
 
shphv_field
Field
 
x(32)
 
 
shphv_field_type
Type
 
9
 
 
shphv_gen_code
Generalized code
 
x(32)
 
 
shphv_internal_proc
Internal Procedure
 
x(32)
 
 
shphv_invalid_char
Invalid Characters
 
x(8)
 
 
shphv_launch_fieldname
Launch Fieldname
 
x(32)
 
 
shphv_max_length
Max Length
 
>,>>>,>>9
 
 
shphv_min_length
Min Length
 
>,>>>,>>9
 
 
shphv_mod_date
Modified Date
Mod Date
99/99/99
 
 
shphv_mod_userid
User ID
 
x(8)
 
 
shphv_start_eff
Start Effective
 
99/99/99
 
 
shphv_user1
User Field Character 1
 
x(24)
 
 
shphv_user2
User Field Character 2
 
x(24)
 
 
shphv_usrfld_applyto
Apply-To
 
999
 
 
shphv_validate_msg1
Message
 
x(45)
 
 
shphv_validate_msg2
Message
 
x(75)
 
 
shphv_validate_point
Validation Point
 
9
 
 
shphv_validate_program
Validation Program
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
oid_shphr_det
yes
oid_shphr_det
yes
no
 
 
 
shphv_field
yes
no
 
 
 
shphv_start_eff
yes
no
 
oid_shphv_det
yes
oid_shphv_det
yes
no
 
shphv_field
no
shphv_field
yes
no
 
 
 
oid_shphv_det
yes
no
shph_hist
Shipping History
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shph_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shph__qadc01
 
 
x(24)
 
 
shph__qadc02
 
 
x(24)
 
 
shph_ad_city
City
 
x(20)
 
 
shph_ad_country
Country
 
x(28)
 
 
shph_ad_name
Name
 
x(36)
 
 
shph_ad_state
State
 
x(4)
 
 
shph_domain
Domain
 
x(8)
 
 
shph_fob
FOB
 
x(20)
 
 
shph_master_id
Master Bill ID
 
x(20)
 
 
shph_mod_date
Modified Date
Mod Date
99/99/99
 
 
shph_mod_userid
User ID
 
x(8)
 
 
shph_ord_line
Line
 
x(8)
 
 
shph_ord_nbr
Order
 
x(8)
 
 
shph_packing_slip
Packing Slip
 
x(20)
 
 
shph_program
Program
 
x(12)
 
 
shph_ship_type
Type
 
x(1)
 
 
shph_shipto
Ship-to Id
 
x(8)
 
 
shph_shipvia
Ship Via
 
x(20)
 
 
shph_shp_from
Shipping From
 
x(8)
 
 
shph_shp_id
Shipper ID
 
x(20)
 
 
shph_table_name
Shipping Table Name
 
x(18)
 
 
shph_timestamp
Date/Time
 
99/99/9999 HH:MM:SS.SSS
 
 
shph_trans_type
Transaction Type
 
x(8)
 
 
shph_user1
User Field Character 1
 
x(24)
 
 
shph_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shph_hist
yes
oid_shph_hist
yes
no
shph_timestamp
yes
shph_domain
yes
no
 
 
 
shph_shp_from
yes
no
 
 
 
shph_shp_id
yes
no
 
 
 
shph_ord_nbr
yes
no
 
 
 
shph_ord_line
yes
no
 
 
 
shph_packing_slip
yes
no
 
 
 
shph_timestamp
yes
no
 
shph_trans_time
no
shph_domain
yes
no
 
 
 
shph_trans_type
yes
no
 
 
 
shph_timestamp
yes
no
shpordh_hist
Shipping Serial-Order History
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shpordh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_shpserh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shpordh__qadc01
 
 
x(24)
 
 
shpordh__qadc02
 
 
x(24)
 
 
shpordh_consignment
Consignment
 
yes/no
 
 
shpordh_domain
Domain
 
x(8)
 
 
shpordh_line
Line
 
x(8)
 
 
shpordh_mod_date
Modified Date
Mod Date
99/99/99
 
 
shpordh_mod_userid
User ID
 
x(8)
 
 
shpordh_nbr
Order
 
x(8)
 
 
shpordh_net_weight
Net Weight
 
->>,>>9.99<<<<
10
 
shpordh_net_weight_um
Net Weight UM
UM
x(2)
 
 
shpordh_order_table
Record Table Name
 
x(18)
 
 
shpordh_order_um
UM
 
x(2)
 
 
shpordh_qty_pck
Pick Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
shpordh_trnbr
Identifier Transaction History
 
>>>>>>>>>>
 
 
shpordh_um
UM
 
x(2)
 
 
shpordh_um_conv
UM Conv
 
>>>>9.9999<<<<
10
 
shpordh_user1
User Field Character 1
 
x(24)
 
 
shpordh_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shpordh_hist
yes
oid_shpordh_hist
yes
no
shpordh_line
yes
oid_shpserh_hist
yes
no
 
 
 
shpordh_nbr
yes
no
 
 
 
shpordh_line
yes
no
 
shpordh_nbr_line
no
shpordh_domain
yes
no
 
 
 
shpordh_nbr
yes
no
 
 
 
shpordh_line
yes
no
 
shpordh_tr_hist
no
shpordh_domain
yes
no
 
 
 
shpordh_trnbr
yes
no
shpschh_hist
Shipping History of Schedule Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shpschh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_shpserh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shpschh__qadc01
 
 
x(24)
 
 
shpschh__qadc02
 
 
x(24)
 
 
shpschh_auth_nbr
Auth Number
 
x(24)
 
 
shpschh_date
Date
 
99/99/99
 
 
shpschh_domain
Domain
 
x(8)
 
 
shpschh_interval
Interval
 
x(1)
 
 
shpschh_line
Line
Ln
>>9
 
 
shpschh_mod_date
Modified Date
Mod Date
99/99/99
 
 
shpschh_mod_userid
User ID
 
x(8)
 
 
shpschh_nbr
Order
 
x(8)
 
 
shpschh_open_qty
Qty Open
 
>>,>>>,>>9.9<<<<<<<
10
 
shpschh_peg_qty
Qty Pegged
 
>>,>>>,>>9.9<<<<<<<
10
 
shpschh_reference
Reference
 
x(24)
 
 
shpschh_req_type
Requirement Type
 
>9
 
 
shpschh_rlse_id
Release ID
 
x(30)
 
 
shpschh_time
Time
 
99:99
 
 
shpschh_type
Schedule Type
 
>9
 
 
shpschh_user1
User Field Character 1
 
x(24)
 
 
shpschh_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shpschh_hist
yes
oid_shpschh_hist
yes
no
shpschh_dtr
yes
oid_shpserh_hist
yes
no
 
 
 
shpschh_type
yes
no
 
 
 
shpschh_nbr
yes
no
 
 
 
shpschh_line
yes
no
 
 
 
shpschh_rlse_id
yes
no
 
 
 
shpschh_date
yes
no
 
 
 
shpschh_time
yes
no
 
 
 
shpschh_interval
yes
no
 
 
 
shpschh_reference
yes
no
 
 
 
shpschh_req_type
yes
no
 
shpschh_nbr_line
no
shpschh_domain
yes
no
 
 
 
shpschh_nbr
yes
no
 
 
 
shpschh_line
yes
no
 
 
 
shpschh_rlse_id
yes
no
 
 
 
shpschh_date
yes
no
 
 
 
shpschh_time
yes
no
 
 
 
shpschh_interval
yes
no
 
 
 
shpschh_reference
yes
no
 
 
 
shpschh_req_type
yes
no
shpserh_hist
Shipping Serial History
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shph_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_shpserh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shpserh__qadc01
 
 
x(24)
 
 
shpserh__qadc02
 
 
x(24)
 
 
shpserh_content_qty
Avail Pack Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
shpserh_content_um
Content UM
 
x(2)
 
 
shpserh_gross_weight
Gross Weight
 
->>,>>9.99<<<<
10
 
shpserh_gross_weight_um
Gross Weight UM
 
x(2)
 
 
shpserh_loc
Location
 
x(8)
 
 
shpserh_lotser
Lot/Ser
 
x(18)
 
 
shpserh_master_id
Master Ser ID
 
x(40)
 
 
shpserh_master_stage
Stage
 
x(18)
 
 
shpserh_mod_date
Modified Date
Mod Date
99/99/99
 
 
shpserh_mod_userid
User ID
 
x(8)
 
 
shpserh_pack_code
Pack Code
 
x(18)
 
 
shpserh_parent_id
Parent Ser ID
 
x(40)
 
 
shpserh_part
Item
 
x(18)
 
 
shpserh_phantom
Phantom Pack
 
yes/no
 
 
shpserh_ref
Reference
 
x(8)
 
 
shpserh_serial_id
Serial ID
 
x(40)
 
 
shpserh_site
Site
 
x(8)
 
 
shpserh_size
Volume
 
->>,>>9.99
10
 
shpserh_size_um
Volume UM
UM
x(2)
 
 
shpserh_stage
Stage
 
x(10)
 
 
shpserh_tare_weight
Tare Weight
 
->>,>>9.99<<<<
10
 
shpserh_tare_weight_um
Tare Weight UM
UM
x(2)
 
 
shpserh_truck_loaded
Truck Loaded
 
yes/no
 
 
shpserh_user1
User Field Character 1
 
x(24)
 
 
shpserh_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shpserh_hist
yes
oid_shpserh_hist
yes
no
 
shpserh_mstr_id
no
oid_shph_hist
yes
no
 
 
 
shpserh_master_id
yes
no
 
shpserh_par_id
no
oid_shph_hist
yes
no
 
 
 
shpserh_parent_id
yes
no
 
shpserh_ser_id
no
shpserh_serial_id
yes
no
shpserh_serial
yes
oid_shph_hist
yes
no
 
 
 
shpserh_serial_id
yes
no
 
shpserh_shph_part
no
oid_shph_hist
yes
no
 
 
 
shpserh_part
yes
no
 
 
 
shpserh_lotser
yes
no
 
 
 
shpserh_ref
yes
no
shpsobh_hist
Shipping History of Sales Order Configuration Bill Detail.
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shph_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_shpsobh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shpsobh__qadc01
 
 
x(24)
 
 
shpsobh__qadc02
 
 
x(24)
 
 
shpsobh_domain
Domain
 
x(8)
 
 
shpsobh_line
Line
Ln
>>9
 
 
shpsobh_mod_date
Modified Date
Mod Date
99/99/99
 
 
shpsobh_mod_userid
User ID
 
x(8)
 
 
shpsobh_nbr
Order
 
x(8)
 
 
shpsobh_order_um
UM
 
x(2)
 
 
shpsobh_part
Item Number
 
x(18)
 
 
shpsobh_qty_ship
Qty Shipped
 
->,>>>,>>9.9<<<<<<<<
10
 
shpsobh_um
UM
 
x(2)
 
 
shpsobh_um_conv
UM Conv
 
>>>>9.9999<<<<
10
 
shpsobh_user1
User Field Character 1
 
x(24)
 
 
shpsobh_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shpsobh_hist
yes
oid_shpsobh_hist
yes
no
shpsobh_line
yes
oid_shph_hist
yes
no
 
 
 
shpsobh_nbr
yes
no
 
 
 
shpsobh_line
yes
no
 
shpsobh_nbr_line
no
shpsobh_domain
yes
no
 
 
 
shpsobh_nbr
yes
no
 
 
 
shpsobh_line
yes
no
shp_hist
Shipment Performance History
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shp_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shp__qadc01
 
 
X(24)
 
 
shp__qadc02
 
 
X(24)
 
 
shp_abs_id
Shipper
 
x(20)
 
 
shp_cmtindx
Comment
 
>>>>>>>9
 
 
shp_currency
Currency
 
x(3)
 
 
shp_cust
Customer
 
x(8)
 
 
shp_cust_part
Customer Item
 
x(30)
 
 
shp_customer_source
Customer Source
 
x(3)
 
 
shp_do_req
Requisition
 
x(8)
 
 
shp_domain
Domain
 
x(8)
 
 
shp_due_date
Due Date
 
99/99/99
 
 
shp_ext_price
Extended Price
 
->>>>,>>>,>>9.99<<<
10
 
shp_include
Include in Reporting
 
yes/no
 
 
shp_line
Line
 
>>9
 
 
shp_mod_date
Modified Date
Mod Date
99/99/99
 
 
shp_mod_userid
User ID
 
x(8)
 
 
shp_nbr
Order
 
x(8)
 
 
shp_open_qty
Open Qty
 
->>,>>>,>>9.9<<<<<<<<
10
 
shp_ord_um
UM
 
x(2)
 
 
shp_ord_um_conv
UM Conversion
 
>>>>9.9999<<<<
10
 
shp_order_category
Category
 
x(8)
 
 
shp_part
Item Number
 
x(18)
 
 
shp_perf_date
Performance Date
 
99/99/99
 
 
shp_qty_pct
Shipment Percentage
 
->>9.99
10
 
shp_rel_id
Release
 
x(30)
 
 
shp_req_date
Required Date
 
99/99/99
 
 
shp_sched_time
Schedule Time
 
99:99
 
 
shp_ship_date
Ship Date
 
99/99/99
 
 
shp_ship_price
Ship Price
 
->>>>,>>>,>>9.99<<<
10
 
shp_ship_qty
Ship Qty
 
->>,>>>,>>9.9<<<<<<<<
10
 
shp_ship_time
Ship Time
 
99:99
 
 
shp_ship_um
UM
 
x(2)
 
 
shp_ship_um_conv
UM Conversion
 
>>>>9.9999<<<<
10
 
shp_shipfrom
Ship-From
 
x(8)
 
 
shp_shipto
Ship-To
 
x(8)
 
 
shp_tran_id
Tran ID
 
>>>>>>>>9
 
 
shp_user1
User Field Character 1
 
X(24)
 
 
shp_user2
User Field Character 2
 
X(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shp_hist
yes
oid_shp_hist
yes
no
 
shp_abs_id
no
shp_domain
yes
no
 
 
 
shp_shipfrom
yes
no
 
 
 
shp_abs_id
yes
no
 
shp_cust
no
shp_domain
yes
no
 
 
 
shp_include
yes
no
 
 
 
shp_cust
yes
no
 
 
 
shp_shipto
yes
no
 
 
 
shp_shipfrom
yes
no
 
 
 
shp_nbr
yes
no
 
 
 
shp_line
yes
no
 
shp_customer_source
no
shp_domain
yes
no
 
 
 
shp_include
yes
no
 
 
 
shp_customer_source
yes
no
 
 
 
shp_cust
yes
no
 
 
 
shp_shipto
yes
no
 
 
 
shp_shipfrom
yes
no
 
 
 
shp_nbr
yes
no
 
 
 
shp_line
yes
no
 
 
 
shp_ship_date
yes
no
 
shp_part
no
shp_domain
yes
no
 
 
 
shp_include
yes
no
 
 
 
shp_part
yes
no
 
 
 
shp_shipfrom
yes
no
 
 
 
shp_nbr
yes
no
 
 
 
shp_line
yes
no
 
shp_ship_date
no
shp_domain
yes
no
 
 
 
shp_include
yes
no
 
 
 
shp_ship_date
yes
no
 
 
 
shp_shipfrom
yes
no
 
 
 
shp_shipto
yes
no
 
 
 
shp_nbr
yes
no
 
 
 
shp_line
yes
no
shp_tran_id
yes
shp_domain
yes
no
 
 
 
shp_tran_id
yes
no
shtr_det
Shipment Trailer Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shtr_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shtr__qad01
 
 
-z,zzz,zzz,zz9.99
10
 
shtr__qad02
 
 
-z,zzz,zzz,zz9.99
10
 
shtr__qad03
 
 
-z,zzz,zzz,zz9.99
10
 
shtr__qad04
 
 
>
 
 
shtr__qad05[2]
 
 
>>9.9<<
10
 
shtr_amt
Trailer Amt 1
 
-zzzz,zzz,zz9.99
10
 
shtr_cd
Trailer 1
Trl1
x(2)
 
 
shtr_curr
Currency
Cur
x(3)
 
 
shtr_domain
Domain
 
x(8)
 
 
shtr_inv_nbr
Invoice Number
Invoice
x(22)
 
 
shtr_nbr
Sales Order
Order
x(8)
 
 
shtr_ship_date
Ship Date
 
99/99/99
 
 
shtr_ship_id
Ship Id
 
x(8)
 
 
shtr_site
Site
 
x(8)
 
 
shtr_user1
Ufld1
 
x(8)
 
 
shtr_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shtr_det
yes
oid_shtr_det
yes
no
shtr_nbrcd
yes
shtr_domain
yes
no
 
 
 
shtr_nbr
yes
no
 
 
 
shtr_ship_id
yes
no
 
 
 
shtr_cd
yes
no
 
shtr_shipcd
yes
shtr_domain
yes
no
 
 
 
shtr_ship_id
yes
no
 
 
 
shtr_cd
yes
no
shv_mstr
Ship Via Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shv_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shv__qadc01
 
 
x(24)
 
 
shv__qadc02
 
 
x(24)
 
 
shv_domain
Domain
 
x(8)
 
 
shv_mod_date
Modified Date
Mod Date
99/99/99
 
 
shv_mod_userid
User ID
 
x(8)
 
 
shv_mode_transp
Mode Of Transport
 
x(1)
 
 
shv_name
Name
 
x(24)
 
 
shv_port_mandatory
Port Mandatory
 
yes/no
 
 
shv_shipvia
Ship Via
 
x(20)
 
 
shv_user1
User Field Character 1
 
x(24)
 
 
shv_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shv_mstr
yes
oid_shv_mstr
yes
no
 
shv_mode_transp
no
shv_domain
yes
no
 
 
 
shv_mode_transp
yes
no
shv_shipvia
yes
shv_domain
yes
no
 
 
 
shv_shipvia
yes
no
sigd_det
Site grouping for linked sites.
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_si_mstr_child
Identifier of Child Site
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_si_mstr_master
Identifier of Master Site
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_sigd_det
Indentifier for Site group table (Linked Sites)
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sigd__qadc01
 
 
x(24)
 
 
sigd__qadc02
 
 
x(24)
 
 
sigd_grp_active
Active
 
yes/no
 
 
sigd_mod_date
Modified Date
Mod Date
99/99/99
 
 
sigd_mod_userid
User ID
 
x(8)
 
 
sigd_user1
User Field Character 1
 
x(24)
 
 
sigd_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
oid_sigd_det
yes
oid_sigd_det
yes
no
 
sigd_master_child
yes
oid_si_mstr_master
yes
no
 
 
 
oid_si_mstr_child
yes
no
 
sigd_si_child
no
oid_si_mstr_child
yes
no
sim_det
Inventory Movement Site Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sim_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sim__qadc01
 
 
x(8)
 
 
sim_canrun[15]
Roles
 
x(60)
 
 
sim_domain
Domain
 
x(8)
 
 
sim_inv_mov
Inventory Movement Code
Inv Mov
x(8)
 
 
sim_site
Site
 
x(8)
 
 
sim_user1
Ufld1
 
x(8)
 
 
sim_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sim_det
yes
oid_sim_det
yes
no
 
sim_inv_mov
yes
sim_domain
yes
no
 
 
 
sim_inv_mov
yes
no
 
 
 
sim_site
yes
no
sim_site
yes
sim_domain
yes
no
 
 
 
sim_site
yes
no
 
 
 
sim_inv_mov
yes
no
six_ref
Shipment Detail/Invoice Number Cross-Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_six_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
six__qadc01
 
 
X(8)
 
 
six__qadc02
 
 
X(8)
 
 
six__qadc03
 
 
X(8)
 
 
six__qadc04
 
 
X(8)
 
 
six__qadc05
 
 
X(8)
 
 
six__qadc06
 
 
X(8)
 
 
six__qadc07
 
 
X(8)
 
 
six__qadc08
 
 
X(8)
 
 
six__qadc09
 
 
X(8)
 
 
six__qadc10
 
 
X(8)
 
 
six__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
six__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
six__qadd03
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
six__qadd04
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
six__qadd05
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
six__qadi01
 
 
>>>>>>9
 
 
six__qadi02
 
 
>>>>>>9
 
 
six__qadi03
 
 
>>>>>>9
 
 
six__qadi04
 
 
>>>>>>9
 
 
six__qadi05
 
 
>>>>>>9
 
 
six__qadl01
 
 
yes/no
 
 
six__qadl02
 
 
yes/no
 
 
six__qadl03
 
 
yes/no
 
 
six__qadl04
 
 
yes/no
 
 
six__qadl05
 
 
yes/no
 
 
six__qadt01
 
 
99/99/99
 
 
six__qadt02
 
 
99/99/99
 
 
six__qadt03
 
 
99/99/99
 
 
six__qadt04
 
 
99/99/99
 
 
six__qadt05
 
 
99/99/99
 
 
six_amt
Ship Amt
 
->>>>,>>>,>>9.99<<<
10
 
six_amt_appld
Amt Applied
 
->>>>,>>>,>>9.99<<<
10
 
six_amt_paid
Paid Amt
 
->>>>,>>>,>>9.99<<<
10
 
six_authorization
Authorization
 
x(24)
 
 
six_bill
Bill-To
 
x(8)
 
 
six_closed
Close Shipment Line
C
yes/no
 
 
six_curr
Currency
Cur
x(3)
 
 
six_cust
Sold-To
 
x(8)
 
 
six_custref
Customer Ref
 
x(30)
 
 
six_domain
Domain
 
x(8)
 
 
six_inv_nbr
Invoice
 
x(22)
 
 
six_line
Line
 
>>>9
 
 
six_mod_date
Modified Date
Mod Date
99/99/99
 
 
six_mod_userid
User ID
 
X(8)
 
 
six_modelyr
Model Year
 
x(4)
 
 
six_order
Sales Order
Order
x(8)
 
 
six_part
Item
 
x(18)
 
 
six_po
Customer PO
 
x(22)
 
 
six_price
Price
 
>>,>>>,>>9.99<<<
10
 
six_qty
Ship Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
six_qty_paid
Paid Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
six_ship
Ship-To
 
x(8)
 
 
six_ship_id
Shipper
 
x(20)
 
 
six_shipdt
Ship Date
 
99/99/99
 
 
six_site
Ship-From
 
x(8)
 
 
six_sopart
Self-Bill Item
 
x(30)
 
 
six_trnbr
Trans
 
>>>>>>>>
 
 
six_type
Type
T
x(1)
 
 
six_um
UM
 
x(2)
 
 
six_user1
Ufld1
 
X(8)
 
 
six_user2
Ufld2
 
X(8)
 
 
six_user3
 
 
X(8)
 
 
six_user4
 
 
X(8)
 
 
six_user5
 
 
X(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_six_ref
yes
oid_six_ref
yes
no
 
six_auth_sopart
no
six_domain
yes
no
 
 
 
six_authorization
yes
no
 
 
 
six_sopart
yes
no
 
six_bill_inv
no
six_domain
yes
no
 
 
 
six_bill
yes
no
 
 
 
six_inv_nbr
yes
no
 
 
 
six_type
yes
no
 
 
 
six_order
yes
no
 
 
 
six_line
yes
no
 
 
 
six_ship_id
yes
no
 
 
 
six_authorization
yes
no
 
six_order_sopart
no
six_domain
yes
no
 
 
 
six_order
yes
no
 
 
 
six_sopart
yes
no
 
six_part
no
six_domain
yes
no
 
 
 
six_part
yes
no
 
six_po_sopart
no
six_domain
yes
no
 
 
 
six_po
yes
no
 
 
 
six_sopart
yes
no
 
six_ship_sopart
no
six_domain
yes
no
 
 
 
six_ship_id
yes
no
 
 
 
six_sopart
yes
no
 
six_sopart
no
six_domain
yes
no
 
 
 
six_sopart
yes
no
six_trnbr
yes
six_domain
yes
no
 
 
 
six_trnbr
yes
no
si_mstr
Site Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_si_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
si__chr01
 
 
x(8)
 
 
si__chr02
 
 
x(8)
 
 
si__chr03
 
 
x(8)
 
 
si__chr04
 
 
x(8)
 
 
si__chr05
 
 
x(8)
 
 
si__dec01
 
 
>>>,>>>,>>9.99
10
 
si__dec02
 
 
>>>,>>>,>>9.99
10
 
si__dte01
 
 
99/99/99
 
 
si__dte02
 
 
99/99/99
 
 
si__log01
 
 
yes/no
 
 
si_arap_sub
AR/AP Sub-Account
 
x(8)
 
 
si_auto_loc
Automatic Locations
Auto Loc
yes/no
 
 
si_btb_vend
EMT Supplier
EMT Supp
x(8)
 
 
si_canrun
Roles
 
x(189)
 
 
si_cur_set
Current Cost Set
Cur Set
x(8)
 
 
si_db
Domain
 
x(8)
 
 
si_decl
Declarant
 
x(8)
 
 
si_desc
Description
 
x(24)
 
 
si_domain
Domain
 
x(8)
 
 
si_entity
Entity
 
x(20)
 
 
si_ext_vd
External Supplier
Ext Supp
yes/no
 
 
si_git_acct
Goods In Transit Acct
GIT Acct
x(8)
 
 
si_git_cc
Cost Center
CC
x(4)
 
 
si_git_location
PO Transit Location
GIT Loc
x(8)
 
 
si_git_sub
GIT Sub-Acct
Sub-Acct
x(8)
 
 
si_gl_set
GL Cost Set
GL Set
x(8)
 
 
si_insp_loc
Inspection Location
Inspect
x(8)
 
 
si_mod_date
Modified Date
Mod Date
99/99/99
 
 
si_mod_userid
User ID
 
x(8)
 
 
si_site
Site
 
x(8)
 
 
si_status
Default Inventory Status
Status
x(8)
 
 
si_type
Type
 
Primary/Connection
 
 
si_useplansched_wbs
Use Plan/Sched Workbenches
 
yes/no
 
 
si_user1
Ufld1
 
x(8)
 
 
si_user2
Ufld2
 
x(8)
 
 
si_xfer_acct
Transfer Variance Acct
Transfer
x(8)
 
 
si_xfer_cc
Transfer Variance Cost Ctr
CC
x(4)
 
 
si_xfer_ownership
Transfer Ownership
Transfer!Ownership
yes/no
 
 
si_xfer_sub
Transfer Variance Sub
Sub-Acct
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_si_mstr
yes
oid_si_mstr
yes
no
 
si_decl
no
si_domain
yes
no
 
 
 
si_decl
yes
no
si_site
yes
si_domain
yes
no
 
 
 
si_site
yes
no
 
si_type
yes
si_type
yes
no
 
 
 
si_domain
yes
no
 
 
 
si_site
yes
no
SLGListD
Warehousing Storage Location Group List Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_SLGListD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
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
 
 
Site
Site
 
x(8)
 
 
SLGList
SLG List
 
x(8)
 
 
SLGSeq
Seq
 
>>9
 
 
SLocGp
Store Loc Group
SLocGrp
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
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_SLGListD
yes
oid_SLGListD
yes
no
 
SLGGroup
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
SLGList
yes
no
 
 
 
SLocGp
yes
no
SLGIdx
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
SLGList
yes
no
 
 
 
SLGSeq
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
SLGListM
Warehousing Storage Location Group List Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(24)
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_SLGListM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
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
 
 
Site
Site
 
x(8)
 
 
SLGList
SLG List
 
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
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_SLGListM
yes
oid_SLGListM
yes
no
SLGList
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
SLGList
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
SLGM
Warehousing Storage Location Group Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
AcquisUM
Acquis UM
Acq!UM
x(2)
 
 
AllowInReturn
Allow Incoming Returns
InRet
yes/no
 
 
AllowIssue
Allow Issues
Iss
yes/no
 
 
AllowOutReturn
Allow Outgoing Returns
OutRet
yes/no
 
 
AllowReceipt
Allow Receipts
Rec
yes/no
 
 
CapacityCheckOTF
Capacity Check when OTF
 
yes/no
 
 
CheckDigits
Check Digits
Chk
yes/no
 
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CntStatusOpt
Count Status Option
Cnt!Stat
>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(24)
 
 
DetOFSlocGp
Det.OverFlow Gr.
Det.OF.Gr.
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ExcludePicking
Exclude From Picking
Excl!Pick
yes/no
 
 
IntRouteGroup
Internal Routing Group
Internal!Routing!Group
x(8)
 
 
MixStatus
Allow Mixed Status Codes
Mix!Status
yes/no
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
MultTrans
Multi-Trans
Multi!Trans
yes/no
 
 
oid_SLGM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OPCActive
Opportunity Counts
OPC
yes/no
 
 
OPCFreq
OPC Frequency
OPC Freq
>>>9
 
 
Optimized
Optimized Storage
Optim
yes/no
 
 
OverPick
Over Pick
Over!Pick
yes/no
 
 
PickLevel
Picking Level
Pick!Level
>>9
 
 
PickMultUM
Pick/Mult of
Pk/!Mult!of
x(2)
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
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
 
 
RecountUM
Recount UM
Rcnt!UM
x(2)
 
 
Site
Site
 
x(8)
 
 
SLocGp
Store Loc Group
SLocGrp
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
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_SLGM
yes
oid_SLGM
yes
no
 
SiteWhseIntGroup
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
IntRouteGroup
yes
no
SiteWhseSLocGp
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
SLocGp
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no