QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
wopm_det
Periodwise (Cost calculation) WO master WIP information
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_glccp_det
Identifier Cost Calculation Period
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_wo_mstr
Identifier WO Master
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_wopm_det
Identifier WO Master (WIP) Periodwise(Cost calculation)
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wopm__qadc01
 
 
x(24)
 
 
wopm__qadc02
 
 
x(24)
 
 
wopm_mod_date
Modified Date
Mod Date
99/99/99
 
 
wopm_mod_userid
User ID
 
x(8)
 
 
wopm_qty_rcvd
WO Period Qty Received
 
->,>>>,>>9.9<<<<<<<<
10
 
wopm_qty_rcvd_tot
WO Qty Received
 
->,>>>,>>9.9<<<<<<<<
10
 
wopm_qty_rjct
WO Period Qty Rejected
 
->,>>>,>>9.9<<<<<<<<
10
 
wopm_qty_rjct_tot
WO Qty Rejected
 
->,>>>,>>9.9<<<<<<<<
10
 
wopm_user1
User Field Character 1
 
x(24)
 
 
wopm_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
oid_wopm_det
yes
oid_wopm_det
yes
no
 
wopm_cost_cal_pd_wo
yes
oid_glccp_det
yes
no
 
 
 
oid_wo_mstr
yes
no
wopr_det
Periodwise (Cost calculation) WO Routing (WIP) information
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wopm_det
Identifier WO Master (WIP) Periodwise(Cost calculation)
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_wopr_det
Identifier WO Route (WIP) Periodwise(Cost calculation)
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_wr_route
Identifier WO Route
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wopr__qadc01
 
 
x(24)
 
 
wopr__qadc02
 
 
x(24)
 
 
wopr_lbr_hrs
Labor Hours
 
->,>>9.9<<
10
 
wopr_lbr_hrs_tot
Labor Hours total
 
->,>>9.9<<
10
 
wopr_mod_date
Modified Date
Mod Date
99/99/99
 
 
wopr_mod_userid
User ID
 
x(8)
 
 
wopr_qty_proc
Period Qty Processed
 
->,>>>,>>9.9<<<<<<<<
10
 
wopr_qty_proc_tot
Qty Processed total
 
->,>>>,>>9.9<<<<<<<<
10
 
wopr_setup_hrs
Setup Hours
 
->,>>9.9<<
10
 
wopr_setup_hrs_tot
Setup Hours Total
 
->,>>9.9<<
10
 
wopr_user1
User Field Character 1
 
x(24)
 
 
wopr_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
oid_wopr_det
yes
oid_wopr_det
yes
no
 
wopr_wopm_wr_route
yes
oid_wopm_det
yes
no
 
 
 
oid_wr_route
yes
no
WorkClass
Work Object Class
 
 
Field Name
Label
Col-Label
Format
Dec
 
BusActivity_ID
Business Activty
 
-99999999999
 
 
BusComponent_ID
Business Component
 
-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)
 
 
ObjectFlexStatus_ID
Custom Object Status
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Role_ID
Role
 
-99999999999
 
 
Usr_ID
User
 
-99999999999
 
 
WorkClass_ID
Record ID
 
-99999999999
 
 
WorkClassDescription
Description
 
x(40)
 
 
WorkClassInstruction
Instruction
 
x(40)
 
 
WorkClassIsActive
Active
Act
yes/no
 
 
WorkClassIsReturnToSender
Return to Sender
 
yes/no
 
 
WorkClassIsSendMail
E-mail Notification
 
yes/no
 
 
WorkClassScopeBusinessFld
Business Field
 
x(40)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BusActivityIdx
no
BusActivity_ID
yes
no
 
BusComponentIdx
no
BusComponent_ID
yes
no
 
FlexStatusIdx
no
ObjectFlexStatus_ID
yes
no
 ∗
Prim
yes
WorkClass_ID
yes
no
 
RoleIdx
no
Role_ID
yes
no
 
UsrIdx
no
Usr_ID
yes
no
 
WorkClassDescr
yes
WorkClassDescription
yes
no
WorkLoadD
Warehousing Work Load Group Details
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
LoadGroup
Workload Group
Grp
x(8)
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_WorkLoadD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
Picks
Optimal Picks per Wave
Picks/Wave
>>>,>>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
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
Seq
Sequence
Seq
>>>9
 
 
Site
Site
 
x(8)
 
 
TimePerPick
Time Per Pick (min)
Pick (min)
>9.99
2
 
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
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
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 1
 
99/99/99
 
 
Whse
Warehouse
Whse
x(8)
 
 
WLocGp
Work Loc Group
WLocGrp
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_WorkLoadD
yes
oid_WorkLoadD
yes
no
 
SiteWhseWLocGp
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
WLocGp
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
WorkLoad
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
LoadGroup
yes
no
 
 
 
Seq
yes
no
 
 
 
WLocGp
yes
no
WorkLoadM
Warehousing Work Load Group Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(24)
 
 
Domain
Domain
 
x(8)
 
 
LoadGroup
Workload Group
Grp
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_WorkLoadM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
ShiftSize
Shift Size
 
->>,>>9.99
10
 
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
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
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 1
 
99/99/99
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
LoadGroup
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
LoadGroup
yes
no
 
oid_WorkLoadM
yes
oid_WorkLoadM
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
wo_mstr
Work Order Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wo_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wo__chr01
 
 
x(8)
 
 
wo__chr02
 
 
x(8)
 
 
wo__chr03
 
 
x(8)
 
 
wo__chr04
 
 
x(8)
 
 
wo__chr05
 
 
x(8)
 
 
wo__dec01
 
 
>>>,>>>,>>9.99
10
 
wo__dec02
 
 
>>>,>>>,>>9.99
10
 
wo__dec03
 
 
->>>,>>>,>>9.99
10
 
wo__dec04
 
 
->>>,>>>,>>9.99
10
 
wo__dte01
 
 
99/99/99
 
 
wo__dte02
 
 
99/99/99
 
 
wo__log01
 
 
yes/no
 
 
wo__qad01
 
 
x(8)
 
 
wo__qadc01
QAD Character Field 1
 
X(8)
 
 
wo__qadc02
QAD Character Field 2
 
X(8)
 
 
wo__qadc03
QAD Character Field 3
 
X(8)
 
 
wo__qade01
QAD Decimal Field 1
 
->,>>>,>>9.9<<<
10
 
wo__qade02
QAD Decimal Field 2
 
->,>>>,>>9.9<<<
10
 
wo__qade03
QAD Decimal Field 3
 
->,>>>,>>9.9<<<
10
 
wo__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
wo__qadi02
QAD Integer Field 2
 
->,>>>,>>9
 
 
wo__qadl01
QAD Logical Field 1
 
yes/no
 
 
wo__qadl02
QAD Logical Field 2
 
yes/no
 
 
wo__qadt01
QAD Date Field 1
 
99/99/99
 
 
wo__qadt02
QAD Date Field 2
 
99/99/99
 
 
wo_acct
Account
 
x(8)
 
 
wo_acct_close
Accounting Closed
Cls
yes/no
 
 
wo_app_owner
Owner Application
 
x(12)
 
 
wo_assay
Assay %
 
>>9.99%
10
 
wo_base_id
Base ID
 
x(8)
 
 
wo_batch
Batch
 
x(18)
 
 
wo_bdn_tot
Burden Cost
 
->>>,>>>,>>9.99<<<
10
 
wo_bdn_totx
Burden Cost
 
->>>,>>>,>>9.99<<<
10
 
wo_bdn_up
Update Current Burden Cost
 
yes/no
 
 
wo_bdn_var
Bdn Variance
 
->>>>,>>9.99
10
 
wo_bo_chg
Qty B/O
 
->,>>>,>>9.9<<<<<<<<
10
 
wo_bom_code
BOM/Formula
 
x(18)
 
 
wo_ca_int_type
Work Code
 
x(8)
 
 
wo_cc
Cost Center
CC
x(4)
 
 
wo_close_date
Accounting Close Date
Acctg Close
99/99/99
 
 
wo_close_eff
Effective
Eff Date
99/99/99
 
 
wo_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
wo_date_posted
 
 
99/99/99
 
 
wo_doc_id
Document ID
 
x(24)
 
 
wo_domain
Domain
 
x(8)
 
 
wo_draw
Drawing
 
x(18)
 
 
wo_due_date
Due Date
Due
99/99/99
 
 
wo_due_date_anchor
Due Date Anchored
 
yes/no
 
 
wo_duration_buffer
Duration Buffer
 
>>>>>9
 
 
wo_eng_code
Engineer
 
X(8)
 
 
wo_expire
Expire Date
Expire
99/99/99
 
 
wo_flr_acct
Floor Stock Account
Flr Acct
x(8)
 
 
wo_flr_cc
Floor Stock CC
CC
x(4)
 
 
wo_flr_sub
Floor Stock Sub-Acct
Sub-Acct
x(8)
 
 
wo_fsm_type
SSM Type
 
x(8)
 
 
wo_gl_bdn
Create GL for Burden Variance
 
yes/no
 
 
wo_gl_lbr
Create GL for Labor Variance
 
yes/no
 
 
wo_grade
Grade
Grd
x(2)
 
 
wo_iss_site
Issue Site
 
x(8)
 
 
wo_itm_line
Item Line
 
>>>>>>>>9
 
 
wo_joint_type
Co/By Type
CT
x(1)
 
 
wo_lbr_tot
Labor Cost
 
->>>,>>9.99
10
 
wo_lbr_totx
Labor Cost
 
->>>,>>9.99
10
 
wo_lbr_up
Update Current Labor Cost
 
yes/no
 
 
wo_lbr_var
Lbr Variance
 
->>>>,>>9.99
10
 
wo_lead_time
W/O Lead Time
W/O Lead
->,>>>,>>9
 
 
wo_line
Production Line
Line
x(8)
 
 
wo_loc
Location
 
x(8)
 
 
wo_lot
ID
 
x(8)
 
 
wo_lot_next
Lot/Serial
 
x(18)
 
 
wo_lot_prev
Previous ID
Prev ID
x(8)
 
 
wo_lot_rcpt
Single Lot
 
yes/no
 
 
wo_mix_var
Mix Variance
 
->>>>,>>9.99
10
 
wo_mthd_var
Mthd Chg Var
 
->>>>,>>9.99
10
 
wo_mtl_tot
Material Cost
 
->>>,>>>,>>9.99<<<
10
 
wo_mtl_totx
Material Cost
 
->>>,>>>,>>9.99<<<
10
 
wo_mtl_var
Mtl Variance
 
->>>>,>>9.99
10
 
wo_mvar_acct
Material Usage Var
Mtl Use
x(8)
 
 
wo_mvar_cc
Material Usage Variance CC
CC
x(4)
 
 
wo_mvar_sub
Mtl Usage Var Sub
Sub-Acct
x(8)
 
 
wo_mvrr_acct
Material Rate Var
Mtl Rate
x(8)
 
 
wo_mvrr_cc
Material Rate Variance CC
CC
x(4)
 
 
wo_mvrr_sub
Mtl Rate Var Sub
Sub-Acct
x(8)
 
 
wo_myld_var
Mix & Yield Var
M&Y Var
->>>>,>>9.99
10
 
wo_nbr
Work Order
 
x(18)
 
 
wo_nbr_lines
Number of Production Lines
 
>>9.9<
2
 
wo_ord_date
Order Date
 
99/99/99
 
 
wo_order_sheet_printed
Route Printed
 
yes/no
 
 
wo_ovh_tot
Ovhead Cost
 
->>>,>>9.999
10
 
wo_ovh_totx
Ovhead Cost
 
->>>,>>9.999
10
 
wo_part
Item Number
 
x(18)
 
 
wo_per_date
Performance Date
Perform
99/99/99
 
 
wo_prod_pct
Process
 
>>9.99%
10
 
wo_project
Project
 
x(8)
 
 
wo_qty_booked
Qty Ser Booked
 
>,>>>,>>9
 
 
wo_qty_chg
Receipt Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
wo_qty_comp
Qty Completed
 
->,>>>,>>9.9<<<<<<<<
10
 
wo_qty_ord
Qty Ordered
 
->,>>>,>>9.9<<<<<<<<
10
 
wo_qty_rjct
Qty Reject
 
->,>>>,>>9.9<<<<<<<<
10
 
wo_qty_type
Qty Type
QT
x(1)
 
 
wo_queue_eff
Queue Pct
 
>>9.9<
10
 
wo_rate
Production Rate
Prod Rate
>>>,>>>,>>9.99
10
 
wo_rctstat
Receipt Status
Status
x(8)
 
 
wo_rctstat_active
Active
Act
yes/no
 
 
wo_record_date
Last Record Date
 
99/99/99
 
 
wo_ref
Reference
 
x(8)
 
 
wo_rel_date
Release Date
Release
99/99/99
 
 
wo_rev
Rev
 
x(4)
 
 
wo_rjct_chg
Reject Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
wo_rjct_tot
Rejected Cost
 
->>>,>>>,>>9.99<<<
10
 
wo_rmks
Remarks
 
x(40)
 
 
wo_routing
Routing Code
 
x(18)
 
 
wo_run_size
Run Crew Size
 
>>>9
 
 
wo_rval_tot
Revalued Total
 
->>>,>>>,>>9.99<<<
10
 
wo_schd_type
Schedule Code
 
x(1)
 
 
wo_selected_for_print
Selected For Print
 
yes/no
 
 
wo_seq
Sequence
 
>>>>9.9<
2
 
wo_serial
Lot/Serial
 
x(18)
 
 
wo_setup_time
Setup Time
 
999999
 
 
wo_shift
Shift
 
x(2)
 
 
wo_site
Site
 
x(8)
 
 
wo_so_job
Sales/Job
SO/Job
x(8)
 
 
wo_stat_close_date
WO Close Date
WO Close
99/99/99
 
 
wo_stat_close_userid
WO Close UserID
 
x(8)
 
 
wo_status
Status
St
x(1)
 
 
wo_sub
Sub-Account
Sub-Acct
x(8)
 
 
wo_sub_tot
Subcontract Cost
 
->>>,>>>,>>9.99<<<
10
 
wo_sub_totx
Subcontract Cost
 
->>>,>>>,>>9.99<<<
10
 
wo_sub_var
Sub Variance
 
->>>>,>>9.99
10
 
wo_svar_acct
Subcontract Usage Var
Sub Use
x(8)
 
 
wo_svar_cc
Subcontract Usage Variance CC
CC
x(4)
 
 
wo_svar_sub
Sub Usage Var Sub
Sub-Acct
x(8)
 
 
wo_svrr_acct
Subcontract Rate Var
Sub Rate
x(8)
 
 
wo_svrr_cc
Subcontract Rate Variance CC
CC
x(4)
 
 
wo_svrr_sub
Sub Rate Var Sub
Sub-Acct
x(8)
 
 
wo_tool
Tool Code
Tool
x(8)
 
 
wo_type
Type
T
x(1)
 
 
wo_unit_cost
Unit Cost
 
->>>,>>>,>>9.99<<<
10
 
wo_user1
Ufld1
 
x(8)
 
 
wo_user2
Ufld2
 
x(8)
 
 
wo_var
Post variances at SFC
 
yes/no
 
 
wo_vend
Supplier
 
x(8)
 
 
wo_wip_tot
Wip Cost
 
->>>,>>>,>>9.99<<<
10
 
wo_xvar_acct
Mix Variance
Mix
x(8)
 
 
wo_xvar_cc
Mix Variance CC
CC
x(4)
 
 
wo_xvar_sub
Mix Variance Sub-Acct
Sub-Acct
x(8)
 
 
wo_yield_pct
Yield
 
>>9.99%
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wo_mstr
yes
oid_wo_mstr
yes
no
 
wo_due_part
no
wo_domain
yes
no
 
 
 
wo_due_date
yes
no
 
 
 
wo_part
yes
no
 
 
 
wo_site
yes
no
 
wo_fsm_type
no
wo_domain
yes
no
 
 
 
wo_fsm_type
yes
no
 
 
 
wo_nbr
yes
no
 
 
 
wo_itm_line
yes
no
 
wo_line_due
no
wo_domain
yes
no
 
 
 
wo_site
yes
no
 
 
 
wo_line
yes
no
 
 
 
wo_due_date
yes
no
 
 
 
wo_part
yes
no
 
wo_lot
yes
wo_domain
yes
no
 
 
 
wo_lot
yes
no
wo_nbr
yes
wo_domain
yes
no
 
 
 
wo_nbr
yes
no
 
 
 
wo_lot
yes
no
 
wo_part
no
wo_domain
yes
no
 
 
 
wo_part
yes
no
 
 
 
wo_site
yes
no
 
 
 
wo_due_date
yes
no
 
wo_part_rel
no
wo_domain
yes
no
 
 
 
wo_part
yes
no
 
 
 
wo_site
yes
no
 
 
 
wo_rel_date
yes
no
 
wo_rel_date
no
wo_domain
yes
no
 
 
 
wo_site
yes
no
 
 
 
wo_line
yes
no
 
 
 
wo_rel_date
yes
no
 
wo_site
no
wo_domain
yes
no
 
 
 
wo_site
yes
no
 
 
 
wo_nbr
yes
no
 
 
 
wo_part
yes
no
 
wo_type_nbr
yes
wo_domain
yes
no
 
 
 
wo_type
yes
no
 
 
 
wo_nbr
yes
no
 
 
 
wo_lot
yes
no
 
wo_type_part
no
wo_domain
yes
no
 
 
 
wo_type
yes
no
 
 
 
wo_part
yes
no
 
 
 
wo_site
yes
no
 
 
 
wo_due_date
yes
no
wr_route
Work Order Routing
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wr_route
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wr__chr01
 
 
x(8)
 
 
wr__chr02
 
 
x(8)
 
 
wr__chr03
 
 
x(8)
 
 
wr__chr04
 
 
x(8)
 
 
wr__chr05
 
 
x(8)
 
 
wr__dec01
 
 
>>>,>>>,>>9.99
10
 
wr__dec02
 
 
>>>,>>>,>>9.99
10
 
wr__dte01
 
 
99/99/99
 
 
wr__dte02
 
 
99/99/99
 
 
wr__log01
 
 
yes/no
 
 
wr__qadc01
QAD Character Field 1
 
X(8)
 
 
wr__qadc02
QAD Character Field 2
 
X(8)
 
 
wr__qadc03
QAD Character Field 3
 
X(8)
 
 
wr__qadc04
QAD Character Field 4
 
X(8)
 
 
wr__qadd05
QAD Decimal Field 5
 
->,>>>,>>9.99<<<
10
 
wr__qade01
QAD Decimal Field 1
 
->,>>>,>>9.99<<<
10
 
wr__qade02
QAD Decimal Field 2
 
->,>>>,>>9.99<<<
10
 
wr__qade03
QAD Decimal Field 3
 
->,>>>,>>9.99<<<
10
 
wr__qade04
QAD Decimal Field 4
 
->,>>>,>>9.99<<<
10
 
wr__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
wr__qadi02
QAD Integer Field 2
 
->,>>>,>>9
 
 
wr__qadl01
QAD Logical Field 1
 
yes/no
 
 
wr__qadl02
QAD Logical Field 2
 
yes/no
 
 
wr_act_posted
Quantity Posted
 
>>>,>>>,>>9.9<<<
10
 
wr_act_run
Act Run Time
 
->,>>9.9<<
10
 
wr_act_setup
Act Setup Time
Act Setup
->,>>9.9<<
10
 
wr_auto_lbr
Auto Labor Report
 
yes/no
 
 
wr_bdn_act
Burden Act
Act Burden
->>>>,>>9.99
10
 
wr_bdn_ll_act
Burden LL Act
 
->>>>,>>9.99
10
 
wr_bdn_ll_totx
Burden
 
->>>,>>>,>>9.99<<<
10
 
wr_bdn_pct
Lbr Bdn %
 
>>9.99%
10
 
wr_bdn_rate
Lbr Bdn Rate
 
>>>,>>9.99
10
 
wr_bdn_std
Burden Std
Std Burden
->>>>,>>9.99
10
 
wr_bdn_totx
Burden
 
->>>,>>>,>>9.99<<<
10
 
wr_bvrte_accr
Bdn Rate Accrued
Accrued
->>>>,>>9.99
10
 
wr_bvrte_post
Bdn Rate Posted
Posted
->>>>,>>9.99
10
 
wr_bvrte_rval
Bdn Rate Revalued
Revalued
->>>>,>>9.99
10
 
wr_bvuse_accr
Bdn Usage Accrued
Accrued
->>>>,>>9.99
10
 
wr_bvuse_post
Bdn Use Posted
Posted
->>>>,>>9.99
10
 
wr_bvuse_rval
Bdn Use Revalued
Revalued
->>>>,>>9.99
10
 
wr_ca_int_type
Work Code
 
x(8)
 
 
wr_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
wr_covered_amt
Covered Amount
 
>>>>,>>>,>>9.99<<<
10
 
wr_covered_post
 
 
>>>>,>>>,>>9.99<<<
10
 
wr_curr
Currency
Cur
x(3)
 
 
wr_desc
Description
 
x(24)
 
 
wr_domain
Domain
 
x(8)
 
 
wr_due
Due Date
Due
99/99/99
 
 
wr_due_datetime
Due Date/Time
 
99/99/99 HH:MM:SS
 
 
wr_end_time
End
 
99:99
 
 
wr_eng_code
Engineer
 
x(8)
 
 
wr_expense
 
 
yes/no
 
 
wr_fbdn_std
 
 
->>>>,>>9.99
10
 
wr_fcg_code
Charge Code
Charge
x(8)
 
 
wr_fcg_index
 
 
->,>>>,>>9
 
 
wr_fis_column
 
 
>>9
 
 
wr_fis_sort
 
 
x(18)
 
 
wr_flbr_cstd
Standard Cost
 
->>>>,>>9.99
10
 
wr_flbr_std
Standard Cost
 
->>>>,>>9.99
10
 
wr_fsc_code
Service Category
Svc Cat
x(8)
 
 
wr_fsm_type
FSM Type
 
x(8)
 
 
wr_itm_line
 
 
>>>9
 
 
wr_lbr_act
Labor Act
Act Labor
->>>>,>>9.99
10
 
wr_lbr_ll_act
Labor LL Act
 
->>>>,>>9.99
10
 
wr_lbr_ll_totx
Labor
 
->>>,>>>,>>9.99<<<
10
 
wr_lbr_ovhd
Labor Overhead
Labor Ovhd
>>,>>9.999
10
 
wr_lbr_rate
Labor Rate
 
>>>,>>9.99
10
 
wr_lbr_std
Labor Std
Std Labor
->>>>,>>9.99
10
 
wr_lbr_totx
Labor
 
->>>,>>>,>>9.99<<<
10
 
wr_list_pr
List Price
 
>>>>,>>>,>>9.99<<<
10
 
wr_lot
ID
 
x(8)
 
 
wr_lvrte_accr
Lbr Rate Accrued
Accrued
->>>>,>>9.99
10
 
wr_lvrte_post
Lbr Rate Posted
Posted
->>>>,>>9.99
10
 
wr_lvrte_rval
Lbr Rate Revalued
Revalued
->>>>,>>9.99
10
 
wr_lvuse_accr
Lbr Use Accrued
Accrued
->>>>,>>9.99
10
 
wr_lvuse_post
Lbr Usage Posted
Posted
->>>>,>>9.99
10
 
wr_lvuse_rval
Lbr Use Revalued
Revalued
->>>>,>>9.99
10
 
wr_mch
Machine
 
x(8)
 
 
wr_mch_bdn
Mach Bdn Rate
Mach Bdn
>>>,>>9.99
10
 
wr_mch_op
Machines per Operation
Mach/ Op
>>9.999
10
 
wr_men_mch
Run Crew
 
->>,>>9.99
10
 
wr_milestone
Milestone Operation
Milestone
yes/no
 
 
wr_move
Std Move Time
Move
>,>>9.9<<
10
 
wr_mtl_act
Mtl Act
Act Material
->>>>,>>9.99
10
 
wr_mtl_ll_act
Mtl LL Act
 
->>>>,>>9.99
10
 
wr_mtl_ll_totx
Material
 
->>>,>>>,>>9.99<<<
10
 
wr_mtl_totx
Material
 
->>>,>>>,>>9.99<<<
10
 
wr_mv_nxt_op
Move Next Op
 
yes/no
 
 
wr_nbr
Work Order
 
x(18)
 
 
wr_op
Operation
Op
>>>>>9
 
 
wr_ovh_act
Ovh Act
 
->>>>,>>9.99
10
 
wr_ovh_ll_act
Ovh LL Act
 
->>>>,>>9.99
10
 
wr_ovh_ll_totx
Overhead
 
->>>,>>>,>>9.99<<<
10
 
wr_ovh_totx
Overhead
 
>>>>,>>>,>>9.99<<<
10
 
wr_part
Item Number
 
x(18)
 
 
wr_po_line
Line
Ln
>>9
 
 
wr_po_nbr
Purchase Order
PO
x(8)
 
 
wr_posted_run
 
 
>>>,>>>,>>9.9<<<<<<<<
10
 
wr_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
wr_prod_line
Product Line
Line
x(4)
 
 
wr_project
Project
 
x(8)
 
 
wr_qty_comp
Qty Complete
 
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_cummove
Cum Moved Out
Cum!Moved Out Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_cumoadj
Cum Out Adjust
Cum Out Queue!Adjusted Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_cumoscrap
Cum Out Scrap
Cum Out Queue!Scrapped Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_cumproc
Cum Processed
Cum!Processed Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_cumradj
Cum Rjct Adjust
Cum Reject Queue!Adjusted Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_cumrjct
Cum Rejected
Cum!Rejected Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_cumrscrap
Cum Rjct Scrap
Cum Reject Queue!Scrapped Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_cumrwrk
Cum Reworked
Cum!Reworked Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_inque
In Queue
Input!Queue Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_inqueb
Begin In Queue
Begin Input!Queue Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_move
Qty Moved
 
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_ord
Qty Ordered
 
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_outque
Out Queue
Output!Queue Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_outqueb
Begin Out Queue
Begin Output!Queue Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_rejque
Rjct Queue
Reject!Queue Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_rejqueb
Begin Rjct Queue
Begin Reject!Queue Qty
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_rjct
Qty Reject
 
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_rwrk
Qty Rework
 
->,>>>,>>9.9<<<<<<<<
10
 
wr_qty_wip
Qty WIP
 
->,>>>,>>9.9<<<<<<<<
10
 
wr_queue
Queue Time
Queue
>,>>9.9<<
10
 
wr_run
Std Run Time
Std Run
>>>,>>>,>>9.9<<<<<<<<
10
 
wr_sbvuse_post
Setup Bdn Usage Posted
Posted
->>>>,>>9.99
10
 
wr_seq
Sequence
 
>>>>9.9<
2
 
wr_setup
Std Setup Time
Std Setup
>,>>9.9<<
10
 
wr_setup_men
Setup Crew
 
->>,>>9.99
10
 
wr_setup_rte
Setup Rate
 
>>>,>>9.99
10
 
wr_shift
Shift
 
x(2)
 
 
wr_slvuse_post
Setup Lbr Usage Posted
Posted
->>>>,>>9.99
10
 
wr_st_time
Start
 
99:99
 
 
wr_start
Start Date
Start
99/99/99
 
 
wr_start_anchor
Release Date Anchored
 
yes/no
 
 
wr_start_datetime
Start Date/Time
 
99/99/99 HH:MM:SS
 
 
wr_status
Status
St
x(1)
 
 
wr_std_op
Standard Operation
Std Op
x(8)
 
 
wr_sub_act
Subcontract Act
Act Sub
->>>>,>>9.99
10
 
wr_sub_comp
Sub Qty Comp
 
->,>>>,>>9.9<<<<<<<<
10
 
wr_sub_cost
Subcontract Cost
Subcontract
>>>>,>>>,>>9.99<<<
10
 
wr_sub_lead
Subcontract LT
Sub!LT
>>9
 
 
wr_sub_ll_act
Subcontract LL Act
 
->>>>,>>9.99
10
 
wr_sub_ll_totx
Subcontract
 
->>>,>>>,>>9.99<<<
10
 
wr_sub_std
Subcontract Std
Std Sub
->>>>,>>9.99
10
 
wr_sub_totx
Subcontract
 
->>>,>>>,>>9.99<<<
10
 
wr_sv_code
Service Type Used
 
x(8)
 
 
wr_svrte_accr
Sub Rate Accrued
Accrued
->>>>,>>9.99
10
 
wr_svrte_post
Sub Rate Posted
Posted
->>>>,>>9.99
10
 
wr_svrte_rval
Sub Rate Revalued
Revalued
->>>>,>>9.99
10
 
wr_svuse_accr
Sub Use Accrued
Accrued
->>>>,>>9.99
10
 
wr_svuse_post
Sub Usage Posted
Posted
->>>>,>>9.99
10
 
wr_svuse_rval
Sub Use Revalued
Revalued
->>>>,>>9.99
10
 
wr_tool
Tool Code
Tool
x(8)
 
 
wr_tran_qty
Overlap Units
Overlap
->,>>>,>>9
 
 
wr_um
UM
 
x(2)
 
 
wr_unprocessed_amt
Unprocessed Hours
 
->,>>9.9<<
10
 
wr_user1
Ufld1
 
x(8)
 
 
wr_user2
Ufld2
 
x(8)
 
 
wr_vend
Supplier
 
x(8)
 
 
wr_wait
Wait Time
Wait
>,>>9.9<<
10
 
wr_wipmtl_part
WIP Item
 
x(18)
 
 
wr_wkctr
Work Center
Work Ctr
x(8)
 
 
wr_yield_pct
Yield
 
>>9.9%
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wr_route
yes
oid_wr_route
yes
no
 
wr_lot
yes
wr_domain
yes
no
 
 
 
wr_lot
yes
no
 
 
 
wr_op
yes
no
wr_nbrop
yes
wr_domain
yes
no
 
 
 
wr_nbr
yes
no
 
 
 
wr_lot
yes
no
 
 
 
wr_op
yes
no
 
wr_part
no
wr_domain
yes
no
 
 
 
wr_part
yes
no
 
 
 
wr_op
yes
no
 
wr_wkctr
no
wr_domain
yes
no
 
 
 
wr_wkctr
yes
no
 
 
 
wr_mch
yes
no
 
 
 
wr_start
yes
no
wtx_mstr
Withholding Tax Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wtx_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wtx__qadc01
 
 
x(24)
 
 
wtx__qadc02
 
 
x(24)
 
 
wtx__qadc03
 
 
x(24)
 
 
wtx__qadc04
 
 
x(24)
 
 
wtx__qadc05
 
 
x(24)
 
 
wtx__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
wtx__qadd02
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
wtx__qadi01
 
 
->>>>>>>9
 
 
wtx__qadi02
 
 
->>>>>>>9
 
 
wtx__qadl01
 
 
yes/no
 
 
wtx__qadl02
 
 
yes/no
 
 
wtx__qadt01
 
 
99/99/99
 
 
wtx__qadt02
 
 
99/99/99
 
 
wtx_acct
Withholding Tax Account
 
x(8)
 
 
wtx_addr
Supplier
 
x(8)
 
 
wtx_cc
Withholding Tax Cost Center
 
x(4)
 
 
wtx_charge_amt
Charge Amount
 
->>>>,>>>,>>9.99<
10
 
wtx_charge_type
Charge Type
 
Expense/Fee
 
 
wtx_check
Payment Reference
 
x(10)
 
 
wtx_domain
Domain
 
x(8)
 
 
wtx_invoice
Supplier's Invoice Number
 
x(12)
 
 
wtx_ln
Voucher Line
 
>>9
 
 
wtx_mod_date
Modified Date
Mod Date
99/99/99
 
 
wtx_mod_userid
User ID
 
x(8)
 
 
wtx_paid_date
Voucher Payment Date
 
99/99/99
 
 
wtx_printed
Certificate Printed
 
yes/no
 
 
wtx_ref
Voucher Number
 
x(8)
 
 
wtx_ret_amt
Retained Amount
 
->>>>,>>>,>>9.99<
10
 
wtx_rsn_code
Reason Code
 
x(8)
 
 
wtx_set_date
Settlement Date
 
99/99/99
 
 
wtx_sub
Withholding Tax Sub Account
 
x(8)
 
 
wtx_tax_pct
Withholding Tax Rate
 
->>9.9<%
10
 
wtx_taxable_amt
Taxable Fee Amount
 
->>>>,>>>,>>9.99<
10
 
wtx_tot_amt
Total Amount
 
->>>>,>>>,>>9.99<
10
 
wtx_tot_paid
Total Paid
 
->>>>,>>>,>>9.99<
10
 
wtx_user1
User Field Character 1
 
x(24)
 
 
wtx_user2
User Field Character 2
 
x(24)
 
 
wtx_userc03
User Field Character 3
 
x(24)
 
 
wtx_userc04
User Field Character 4
 
x(24)
 
 
wtx_userc05
User Field Character 5
 
x(24)
 
 
wtx_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
wtx_userd02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
wtx_useri01
User Field Integer 1
 
->>>>>>>9
 
 
wtx_useri02
User Field Integer 2
 
->>>>>>>9
 
 
wtx_userl01
User Field Logical 1
 
yes/no
 
 
wtx_userl02
User Field Logical 2
 
yes/no
 
 
wtx_usert01
User Field Date 1
 
99/99/99
 
 
wtx_usert02
User Field Date 2
 
99/99/99
 
 
wtx_vat_amt
Value Added Tax Amount
 
->>>>,>>>,>>9.99<
10
 
wtx_vo_date
Voucher Effective Date
 
99/99/99
 
 
wtx_wt_amt
Withholding Tax Amount
 
->>>>,>>>,>>9.99<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wtx_mstr
yes
oid_wtx_mstr
yes
no
wtx_advoln
yes
wtx_domain
yes
no
 
 
 
wtx_addr
yes
no
 
 
 
wtx_ref
yes
no
 
 
 
wtx_ln
yes
no
 
 
 
wtx_check
yes
no
 
wtx_vo_date
no
wtx_domain
yes
no
 
 
 
wtx_vo_date
yes
no
XmlDaemonQueueObject
XML Daemon Queue Object
 
 
Field Name
Label
Col-Label
Format
Dec
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
XmlDaemonQODraftID
Draft ID
 
9999999999
 
 
XmlDaemonQOPrimaryKey
Primary Key
 
x(80)
 
 
XmlDaemonQOReturnStatus
Return Status
 
->>>9
 
 
XmlDaemonQORowid
RowID
 
x(20)
 
 
XmlDaemonQOSeq
Sequence
Seq
>>>9
 
 
XmlDaemonQueue_ID
XML Daemon Queue
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
prim
yes
XmlDaemonQueue_ID
yes
no
 
 
 
XmlDaemonQOSeq
yes
no
XmlDaemonQueueSegment
Daemon queue segment
 
 
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
 
 
XmlDaemonQueue_ID
XML Daemon Queue
 
-99999999999
 
 
XmlDaemonQueueSegmentSeq
Sequence
Seq
>>9
 
 
XmlDaemonQueueSegmentText
Text
 
X(2000)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
prim
yes
XmlDaemonQueue_ID
yes
no
 
 
 
XmlDaemonQueueSegmentSeq
yes
no
YearClosing
Year Closing
 
 
Field Name
Label
Col-Label
Format
Dec
 
ClosingBalanceDivGL_ID
Balance Sheet Closing Sub-Account
 
-99999999999
 
 
ClosingBalanceGL_ID
Balance Sheet Closing Account
 
-99999999999
 
 
ClosingBalanceJournal_ID
Closing Balance Daybook
 
-99999999999
 
 
ClosingPLDivGL_ID
Profit/Loss Closing Sub-Account
 
-99999999999
 
 
ClosingPLGL_ID
Profit/Loss Closing Account
 
-99999999999
 
 
ClosingPLJournal_ID
Closing Profit/Loss Daybook
 
-99999999999
 
 
ClosingTransferJournal_ID
Automated Profit/Loss Transfer Daybook
Automated P&L Transfer Daybook
-99999999999
 
 
Company_ID
Link to Company
 
-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)
 
 
Layer_ID
Link to Layer
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
YearClosing_ID
Record ID
 
-99999999999
 
 
YearClosingAccountingYear
GL Calendar Year
 
9999
 
 
YearClosingCloAddGLNbrDate
Closing Numbering Date
 
99/99/9999
 
 
YearClosingDefTaxCode
Default Tax Code
 
x(8)
 
 
YearClosingIsInclDivision
Include Sub-Accounts
 
yes/no
 
 
YearClosingIsTransPLToBal
Auto-Transfer Profit/Loss to BS
 
yes/no
 
 
YearClosingReoAddGLNbrDate
Reopen Numbering Date
 
99/99/9999
 
 
YearClosingTrnAddGLNbrDate
Transfer Numbering Date
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BalDivGLIdx
no
ClosingBalanceDivGL_ID
yes
no
 
BalGLIdx
no
ClosingBalanceGL_ID
yes
no
 
BalJrnIdx
no
ClosingBalanceJournal_ID
yes
no
 
Company
no
Company_ID
yes
no
 
LayerIdx
no
Layer_ID
yes
no
 
PLDivGlIdx
no
ClosingPLDivGL_ID
yes
no
 
PLGLIdx
no
ClosingPLGL_ID
yes
no
 
PLJrnl_ID
no
ClosingPLJournal_ID
yes
no
 ∗
Prim
yes
YearClosing_ID
yes
no
 
TransJrnlIdx
no
ClosingTransferJournal_ID
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
YearClosingAccountingYear
yes
no
 
 
 
Layer_ID
yes
no