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