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