| field name | data type | mnd. | description |
|---|---|---|---|
| wo_nbr | character(30) | yes | Work Order |
| wo_lot | character(80) | no | ID |
| wo_so_job | character(80) | no | Sales/Job |
| wo_ord_date | date | no | Order Date |
| wo_rel_date | date | no | Release Date |
| wo_due_date | date | no | Due Date |
| wo_per_date | date | no | Performance Date |
| wo_part | character(30) | no | Item Number |
| wo_type | character(30) | no | Type |
| wo_qty_ord | decimal(10) | no | Qty Ordered |
| wo_qty_comp | decimal(10) | no | Qty Completed |
| wo_qty_rjct | decimal(10) | no | Qty Reject |
| wo_status | character(30) | no | Status |
| wo_vend | character(80) | no | Supplier |
| wo_rmks | character(80) | no | Remarks |
| wo_qty_chg | decimal(10) | no | Receipt Qty |
| wo_rjct_chg | decimal(10) | no | Reject Qty |
| wo_bo_chg | decimal(10) | no | Qty B/O |
| wo_yield_pct | decimal(10) | no | Yield |
| wo_rev | character(30) | no | Rev |
| wo_acct | character(80) | no | Account |
| wo_cc | character(30) | no | Cost Center |
| wo__qad01 | character(80) | no | |
| wo_lot_prev | character(80) | no | Previous ID |
| wo_schd_type | character(30) | no | Schedule Code |
| wo_cmtindx | integer | no | Comment Index |
| wo_project | character(80) | no | Project |
| wo_lead_time | integer | no | W/O Lead Time |
| wo_wip_tot | decimal(10) | no | Wip Cost |
| wo_lbr_tot | decimal(10) | no | Labor Cost |
| wo_mtl_tot | decimal(10) | no | Material Cost |
| wo_bdn_tot | decimal(10) | no | Burden Cost |
| wo_sub_tot | decimal(10) | no | Subcontract Cost |
| wo_user1 | character(80) | no | Ufld1 |
| wo_user2 | character(80) | no | Ufld2 |
| wo_ovh_tot | decimal(10) | no | Ovhead Cost |
| wo_loc | character(80) | no | Location |
| wo_serial | character(50) | no | Lot/Serial |
| wo_routing | character(30) | no | Routing Code |
| wo_bom_code | character(30) | no | BOM/Formula |
| wo_site | character(80) | no | Site |
| wo_queue_eff | decimal(10) | no | Queue Pct |
| wo_draw | character(30) | no | Drawing |
| wo_lbr_up | logical | no | Update Current Labor Cost |
| wo_bdn_up | logical | no | Update Current Burden Cost |
| wo_gl_lbr | logical | no | Create GL for Labor Variance |
| wo_gl_bdn | logical | no | Create GL for Burden Variance |
| wo__chr01 | character(80) | no | |
| wo__chr02 | character(80) | no | |
| wo__chr03 | character(80) | no | |
| wo__chr04 | character(80) | no | |
| wo__chr05 | character(80) | no | |
| wo__dte01 | date | no | |
| wo__dte02 | date | no | |
| wo__dec01 | decimal(10) | no | |
| wo__dec02 | decimal(10) | no | |
| wo__log01 | logical | no | |
| wo_line | character(80) | no | Production Line |
| wo_var | logical | no | Post variances at SFC |
| wo_mtl_var | decimal(10) | no | Mtl Variance |
| wo_lbr_var | decimal(10) | no | Lbr Variance |
| wo_bdn_var | decimal(10) | no | Bdn Variance |
| wo_sub_var | decimal(10) | no | Sub Variance |
| wo_mvar_acct | character(80) | no | Material Usage Var |
| wo_mvar_cc | character(30) | no | Material Usage Variance CC |
| wo_mvrr_acct | character(80) | no | Material Rate Var |
| wo_mvrr_cc | character(30) | no | Material Rate Variance CC |
| wo_svar_acct | character(80) | no | Subcontract Usage Var |
| wo_svar_cc | character(30) | no | Subcontract Usage Variance CC |
| wo_svrr_acct | character(80) | no | Subcontract Rate Var |
| wo_svrr_cc | character(30) | no | Subcontract Rate Variance CC |
| wo_flr_acct | character(80) | no | Floor Stock Account |
| wo_flr_cc | character(30) | no | Floor Stock CC |
| wo__dec03 | decimal(10) | no | |
| wo_rjct_tot | decimal(10) | no | Rejected Cost |
| wo_mthd_var | decimal(10) | no | Mthd Chg Var |
| wo_rval_tot | decimal(10) | no | Revalued Total |
| wo_acct_close | logical | no | Accounting Closed |
| wo_close_date | date | no | Accounting Close Date |
| wo_close_eff | date | no | Effective |
| wo_fsm_type | character(80) | no | SSM Type |
| wo_xvar_acct | character(80) | no | Mix Variance |
| wo_xvar_cc | character(30) | no | Mix Variance CC |
| wo_myld_var | decimal(10) | no | Mix & Yield Var |
| wo_joint_type | character(30) | no | Co/By Type |
| wo_prod_pct | decimal(10) | no | Process |
| wo_qty_type | character(30) | no | Qty Type |
| wo__dec04 | decimal(10) | no | |
| wo_base_id | character(80) | no | Base ID |
| wo_unit_cost | decimal(10) | no | Unit Cost |
| wo_mix_var | decimal(10) | no | Mix Variance |
| wo_bdn_totx | decimal(10) | no | Burden Cost |
| wo_lbr_totx | decimal(10) | no | Labor Cost |
| wo_mtl_totx | decimal(10) | no | Material Cost |
| wo_sub_totx | decimal(10) | no | Subcontract Cost |
| wo_ovh_totx | decimal(10) | no | Ovhead Cost |
| wo_rctstat_active | logical | no | Active |
| wo_batch | character(30) | no | Batch |
| wo_assay | decimal(10) | no | Assay % |
| wo_grade | character(30) | no | Grade |
| wo_expire | date | no | Expire Date |
| wo_rctstat | character(80) | no | Receipt Status |
| wo_lot_next | character(30) | no | Lot/Serial |
| wo_lot_rcpt | logical | no | Single Lot |
| wo_ca_int_type | character(80) | no | Work Code |
| wo_iss_site | character(80) | no | Issue Site |
| wo_itm_line | integer | no | Item Line |
| wo_date_posted | date | no | |
| wo__qadc01 | character(80) | no | QAD Character Field 1 |
| wo__qadc02 | character(80) | no | QAD Character Field 2 |
| wo__qadc03 | character(80) | no | QAD Character Field 3 |
| wo__qadt01 | date | no | QAD Date Field 1 |
| wo__qadt02 | date | no | QAD Date Field 2 |
| wo__qade01 | decimal(10) | no | QAD Decimal Field 1 |
| wo__qade02 | decimal(10) | no | QAD Decimal Field 2 |
| wo__qade03 | decimal(10) | no | QAD Decimal Field 3 |
| wo__qadi01 | integer | no | QAD Integer Field 1 |
| wo__qadi02 | integer | no | QAD Integer Field 2 |
| wo__qadl01 | logical | no | QAD Logical Field 1 |
| wo__qadl02 | logical | no | QAD Logical Field 2 |
| wo_eng_code | character(80) | no | Engineer |
| wo_sub | character(80) | no | Sub-Account |
| wo_flr_sub | character(80) | no | Floor Stock Sub-Acct |
| wo_mvar_sub | character(80) | no | Mtl Usage Var Sub |
| wo_mvrr_sub | character(80) | no | Mtl Rate Var Sub |
| wo_svar_sub | character(80) | no | Sub Usage Var Sub |
| wo_svrr_sub | character(80) | no | Sub Rate Var Sub |
| wo_xvar_sub | character(80) | no | Mix Variance Sub-Acct |
| wo_ref | character(80) | no | Reference |
| wo_record_date | date | no | Last Record Date |
| wo_stat_close_date | date | no | WO Close Date |
| wo_stat_close_userid | character(80) | no | WO Close UserID |
| wo_app_owner | character(30) | no | Owner Application |
| wo_domain | character(8) | yes | Domain |
| oid_wo_mstr | decimal(10) | no | |
| wo_doc_id | character(24) | no | Document ID |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| wr_nbr | character(30) | yes | Work Order |
| wr_op | integer | yes | Operation |
| wr_desc | character(80) | no | Description |
| wr_wkctr | character(80) | no | Work Center |
| wr_mch_op | decimal(10) | no | Machines per Operation |
| wr_setup | decimal(10) | no | Std Setup Time |
| wr_run | decimal(10) | no | Std Run Time |
| wr_move | decimal(10) | no | Std Move Time |
| wr_act_setup | decimal(10) | no | Act Setup Time |
| wr_act_run | decimal(10) | no | Act Run Time |
| wr_qty_ord | decimal(10) | no | Qty Ordered |
| wr_qty_wip | decimal(10) | no | Qty WIP |
| wr_qty_comp | decimal(10) | no | Qty Complete |
| wr_qty_rjct | decimal(10) | no | Qty Reject |
| wr_qty_rwrk | decimal(10) | no | Qty Rework |
| wr_status | character(30) | no | Status |
| wr_tool | character(80) | no | Tool Code |
| wr_vend | character(80) | no | Supplier |
| wr_po_nbr | character(80) | no | Purchase Order |
| wr_start | date | no | Start Date |
| wr_due | date | no | Due Date |
| wr_lot | character(80) | no | ID |
| wr_sub_act | decimal(10) | no | Subcontract Act |
| wr_yield_pct | decimal(10) | no | Yield |
| wr_part | character(30) | no | Item Number |
| wr_bdn_std | decimal(10) | no | Burden Std |
| wr_bdn_act | decimal(10) | no | Burden Act |
| wr_lbr_std | decimal(10) | no | Labor Std |
| wr_lbr_act | decimal(10) | no | Labor Act |
| wr_sub_std | decimal(10) | no | Subcontract Std |
| wr_cmtindx | integer | no | Comment Index |
| wr_mch | character(80) | no | Machine |
| wr_milestone | logical | no | Milestone Operation |
| wr_user1 | character(80) | no | Ufld1 |
| wr_user2 | character(80) | no | Ufld2 |
| wr_std_op | character(80) | no | Standard Operation |
| wr_setup_men | decimal(10) | no | Setup Crew |
| wr_men_mch | decimal(10) | no | Run Crew |
| wr_tran_qty | integer | no | Overlap Units |
| wr_lbr_ovhd | decimal(10) | no | Labor Overhead |
| wr_queue | decimal(10) | no | Queue Time |
| wr_wait | decimal(10) | no | Wait Time |
| wr_sub_lead | integer | no | Subcontract LT |
| wr_qty_move | decimal(10) | no | Qty Moved |
| wr__chr01 | character(80) | no | |
| wr__chr02 | character(80) | no | |
| wr__chr03 | character(80) | no | |
| wr__chr04 | character(80) | no | |
| wr__chr05 | character(80) | no | |
| wr__dte01 | date | no | |
| wr__dte02 | date | no | |
| wr__dec01 | decimal(10) | no | |
| wr__dec02 | decimal(10) | no | |
| wr__log01 | logical | no | |
| wr_mtl_totx | decimal(10) | no | Material |
| wr_lbr_totx | decimal(10) | no | Labor |
| wr_bdn_totx | decimal(10) | no | Burden |
| wr_sub_totx | decimal(10) | no | Subcontract |
| wr_ovh_totx | decimal(10) | no | Overhead |
| wr_lvuse_post | decimal(10) | no | Lbr Usage Posted |
| wr_bvuse_post | decimal(10) | no | Bdn Use Posted |
| wr_svuse_post | decimal(10) | no | Sub Usage Posted |
| wr_sub_comp | decimal(10) | no | Sub Qty Comp |
| wr_lvrte_post | decimal(10) | no | Lbr Rate Posted |
| wr_bvrte_post | decimal(10) | no | Bdn Rate Posted |
| wr_svrte_post | decimal(10) | no | Sub Rate Posted |
| wr_lvrte_accr | decimal(10) | no | Lbr Rate Accrued |
| wr_lvuse_accr | decimal(10) | no | Lbr Use Accrued |
| wr_bvrte_accr | decimal(10) | no | Bdn Rate Accrued |
| wr_bvuse_accr | decimal(10) | no | Bdn Usage Accrued |
| wr_svrte_accr | decimal(10) | no | Sub Rate Accrued |
| wr_svuse_accr | decimal(10) | no | Sub Use Accrued |
| wr_lvrte_rval | decimal(10) | no | Lbr Rate Revalued |
| wr_lvuse_rval | decimal(10) | no | Lbr Use Revalued |
| wr_bvrte_rval | decimal(10) | no | Bdn Rate Revalued |
| wr_bvuse_rval | decimal(10) | no | Bdn Use Revalued |
| wr_svrte_rval | decimal(10) | no | Sub Rate Revalued |
| wr_svuse_rval | decimal(10) | no | Sub Use Revalued |
| wr_sub_cost | decimal(10) | no | Subcontract Cost |
| wr_setup_rte | decimal(10) | no | Setup Rate |
| wr_lbr_rate | decimal(10) | no | Labor Rate |
| wr_bdn_pct | decimal(10) | no | Lbr Bdn % |
| wr_bdn_rate | decimal(10) | no | Lbr Bdn Rate |
| wr_mch_bdn | decimal(10) | no | Mach Bdn Rate |
| wr_slvuse_post | decimal(10) | no | Setup Lbr Usage Posted |
| wr_sbvuse_post | decimal(10) | no | Setup Bdn Usage Posted |
| wr_qty_inque | decimal(10) | no | In Queue |
| wr_qty_outque | decimal(10) | no | Out Queue |
| wr_qty_rejque | decimal(10) | no | Rjct Queue |
| wr_qty_inqueb | decimal(10) | no | Begin In Queue |
| wr_qty_outqueb | decimal(10) | no | Begin Out Queue |
| wr_qty_rejqueb | decimal(10) | no | Begin Rjct Queue |
| wr_qty_cumrjct | decimal(10) | no | Cum Rejected |
| wr_qty_cumoscrap | decimal(10) | no | Cum Out Scrap |
| wr_qty_cumrscrap | decimal(10) | no | Cum Rjct Scrap |
| wr_qty_cumoadj | decimal(10) | no | Cum Out Adjust |
| wr_qty_cumradj | decimal(10) | no | Cum Rjct Adjust |
| wr_qty_cummove | decimal(10) | no | Cum Moved Out |
| wr_qty_cumproc | decimal(10) | no | Cum Processed |
| wr_qty_cumrwrk | decimal(10) | no | Cum Reworked |
| wr_po_line | integer | no | Line |
| wr_wipmtl_part | character(30) | no | WIP Item |
| wr_mtl_act | decimal(10) | no | Mtl Act |
| wr_mv_nxt_op | logical | no | Move Next Op |
| wr_lbr_ll_act | decimal(10) | no | Labor LL Act |
| wr_bdn_ll_act | decimal(10) | no | Burden LL Act |
| wr_sub_ll_act | decimal(10) | no | Subcontract LL Act |
| wr_mtl_ll_act | decimal(10) | no | Mtl LL Act |
| wr_ovh_act | decimal(10) | no | Ovh Act |
| wr_ovh_ll_act | decimal(10) | no | Ovh LL Act |
| wr_lbr_ll_totx | decimal(10) | no | Labor |
| wr_bdn_ll_totx | decimal(10) | no | Burden |
| wr_sub_ll_totx | decimal(10) | no | Subcontract |
| wr_mtl_ll_totx | decimal(10) | no | Material |
| wr_ovh_ll_totx | decimal(10) | no | Overhead |
| wr_auto_lbr | logical | no | Auto Labor Report |
| wr_ca_int_type | character(80) | no | Work Code |
| wr_covered_amt | decimal(10) | no | Covered Amount |
| wr_curr | character(30) | no | Currency |
| wr_end_time | character(30) | no | End |
| wr_eng_code | character(80) | no | Engineer |
| wr_fcg_code | character(80) | no | Charge Code |
| wr_fcg_index | integer | no | |
| wr_fis_column | integer | no | |
| wr_fis_sort | character(30) | no | |
| wr_fsc_code | character(80) | no | Service Category |
| wr_fsm_type | character(80) | no | FSM Type |
| wr_list_pr | decimal(10) | no | List Price |
| wr_price | decimal(10) | no | Price |
| wr_prod_line | character(30) | no | Product Line |
| wr_st_time | character(30) | no | Start |
| wr_act_posted | decimal(10) | no | Quantity Posted |
| wr_expense | logical | no | |
| wr_covered_post | decimal(10) | no | |
| wr__qadd05 | decimal(10) | no | QAD Decimal Field 5 |
| wr_sv_code | character(80) | no | Service Type Used |
| wr_posted_run | decimal(10) | no | |
| wr_flbr_std | decimal(10) | no | Standard Cost |
| wr_flbr_cstd | decimal(10) | no | Standard Cost |
| wr_project | character(80) | no | Project |
| wr_um | character(30) | no | UM |
| wr_fbdn_std | decimal(10) | no | |
| wr_itm_line | integer | no | |
| wr__qadc01 | character(80) | no | QAD Character Field 1 |
| wr__qadc02 | character(80) | no | QAD Character Field 2 |
| wr__qadc03 | character(80) | no | QAD Character Field 3 |
| wr__qadc04 | character(80) | no | QAD Character Field 4 |
| wr__qade01 | decimal(10) | no | QAD Decimal Field 1 |
| wr__qade02 | decimal(10) | no | QAD Decimal Field 2 |
| wr__qade03 | decimal(10) | no | QAD Decimal Field 3 |
| wr__qade04 | decimal(10) | no | QAD Decimal Field 4 |
| wr__qadi01 | integer | no | QAD Integer Field 1 |
| wr__qadi02 | integer | no | QAD Integer Field 2 |
| wr__qadl01 | logical | no | QAD Logical Field 1 |
| wr__qadl02 | logical | no | QAD Logical Field 2 |
| wr_unprocessed_amt | decimal(10) | no | Unprocessed Hours |
| wr_domain | character(8) | yes | Domain |
| oid_wr_route | decimal(10) | no | |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = two_mstr.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |