Production Order Processing Tables

==================================

------------------------------------------------------------------------

initsc Production Order Processing Table

Description - one row for control information established at setup

Column Description

init_key_is char(1) not null Always '1'

inv_noinv_sup_is char(1) not null Not in use

dflt_order_type_is char(2) not null Default Production Order Type. Used for new orders

dflt_comp_type_is char(1) not null Not in use

order_hst_sup_is char(1) not null Order History activated, Y or N

wip_account_is char(12) not null Default Work in Process General Ledger account

auto_order_num_is char(1) Y or N. Auto-assign next producion order number

next_order_num_is integer Next order number (if auto-assigned)

default_cost_is char(1) Not in use

reason_rqd_is char(1) Y or N. Reason code required for scrap transactions

next_gl_trx_seq_is integer Next General Ledger transaction sequence number

dflt_dept_is char(3) Default General Ledger dept for Wip account postings

inventory_acct_is char(12) Not in use

wip_matl_acct_is char(12) Default General Ledger account for material added to WIP.

Only used when a valid account is not set up in acctcd table.

wip_labor_acct_is char(12) Default General Ledger account for labor cost added to WIP.

Only used when a valid account is not set up in acctcd table.

wip_ovh_acct_is char(12) Default General Ledger Account for overhead cost added to WIP.

Only used when a valid account is not set up in acctcd table.

wip_outs_acct_is char(12) Default General Ledger Account for outside process cost added to WIP.

Only used when a valid account is not set up in acctcd table.

wip_scrap_acct_is char(12) Default General Ledger account for end item scrapped from WIP

Only used when a valid account is not set up in acctcd table.

wip_rec_acct_is char(12) Default General Ledget Account for end item received from WIP

Only used when a valid account is not set up in acctcd table.

scrap_exp_acct_is char(12) Default General Ledger account for end item scrapped to expense

auto_pick_type_is smallint 1=restart at 1 for each new order

2=global sequential number

next_pick_is decimal(10,0) Next global sequential number

pick_sort_seq_is char(1) I=by item, L=by location

auto_alloc_is char(1) Not in use

alloc_method_is char(1) Not in use

setup_done_is char(1) Y=completed, N=not completed

next_gl_pst_seq_is integer Next General Ledger posting sequence number

dflt_ic_update_is char(1) Default method for posting inventory updates

Y=update online

N=update via separate menu option

dflt_acctcd_is char(13) Default accounting code. Initially set to DEFAULT

wosumm Production Order Summary Table

Description - one row for each production order entered or generated

Column Description

order_ws char(7) not null Order Number

order_lot_ws char(3) not null Order Release Number - used with order splits

item_ws char(20) not null End Item Code

whse_ws char(10) not null End Item Warehouse Code

type_ws char(3) Order Type - validated against ordertypesc

status_ws char(1) not null A=Active, H=Held, C=Closed

hold_code_ws char(3) Hold Code identifier, if held. Validated against holdsc

start_date_ws date Date order is to start

orig_due_date_ws date Order Original Due Date

cur_due_date_ws date Order Current Due Date

completion_date_ws date Not in use

close_date_ws date Date Order Closed

orig_order_qty_ws decimal(10,3) Original Order Quantity

cur_order_qty_ws decimal(10,3) Current Order Quantity

qty_remain_ws decimal(10,3) Quantity Remaining to produce

hours_remain_ws decimal(10,3) Labor Hours remaining to produce

compl_qty_ws decimal(10,3) Quantity Completed

scrap_qty_ws decimal(10,3) Quantity Scrapped

std_hours_ws decimal(10,3) Hours worked based on standard hours per unit

act_hours_ws decimal(10,3) Actual hours reported

rwk_hours_ws decimal(10,3) Actual rework hours reported

std_rec_cost_ws money(11,4) Not in use

act_psc_cost_ws money(11,4) Not in use

act_rec_cost_ws money(11,4) Total cost of end item received units

stock_uom_ws char(2) Stocking unit of measure

desc_ws char(30) Order Desctiption. Defaults to end item description

sales_order_ws char(20) Sales Order Number, if related via MTO/MTN order type

sales_line_ws decimal(4,0) Sales Order Line Number, if related via MTO/MTN order type

add_date_ws date Date added

change_date_ws date Date of last change

std_order_qty_ws decimal(10,3) End item standard order quantity

inv_noinv_ws char(1) S=Stock Item, N=non-stock item

packet_count_ws smallint Number of times Production Packet has been printed

job_ws char(10) Free-form Job identifier

project_ws char(10) Free-form Project identifier

std_hrs_tot_ws decimal(10,5) Not in use

act_hrs_tot_ws decimal(10,5) Not in use

split_order_lot_ws char(3) Not in use

cur_per_active_ws char(1) Not in use

priority_ws char(4) Management Priority (1-9)

mrp_qty_ws decimal(10,3) Work quantity used by MRP generation

critical_ratio_ws decimal(10,5) Order Critical Ratio

reschedule_flag_ws char(1) Y=reschedule needed, N=not needed

calc_start_date_ws date Production Scheduling - Scheduled Start Date

calc_compl_date_ws date Production Scheduling - Scheduled Completion Date

comp_issue_sts_ws smallint Component Issue Status:

0 = Not issued

1 = Partially issued

2 = All components issued

labor_rept_sts_ws smallint Labor Reporting status:

0 = No labor reported

1 = Partially reported

2 = All labor reported

var_post_sts_ws smallint Order Variance Posting Status

0 = No variances posted

1 = Vaiances posted

acctcd_ws char(13) General Ledger Accounting Code

department_ws char(3) General Ledger Department

revision_level_ws char(10) Engineering Revision Level

user1_ws char(10) User-Defined Field

user2_ws char(10) User-Defined Field

user3_ws char(10) User-Defined Field

bill_ws char(5) Bill of Material Code

routing_ws char(5) Standard Routing Code

alloc_sts_ws char(1) Components Allocated (Y=Yes, N=No)

bom_effective_ws date Bill of Material Effective Date

configurable_ws char(1) End Item Configured (Y=Yes, N=No)

select_number_ws decimal(9,0) Configuration Select Number

prod_line_ws char(5) Production Line identifier

release_sts_ws char(1) Not in use

pick_count_ws smallint Number of times Production Pick List has been printed

responsible_ws char(10) Responsible Party. Validated against responsible

total_price_ws decimal(11,3) Total Price, for MTO/MTN order types

margin_pct_ws decimal(5,2) Margin Percent

ext_desc_ws varchar(255) Extended Description. Defaults to end item extended description

contact_name char(20) Customer contact name, for MTO/MTN order types

contact_phone char(20) Customer contact phone, for MTO/MTN order types

wocomp Production Order Components Table

Description - one row for each component on a production order

Column Description

order_wm char(7) not null Order Number

order_lot_wm char(3) not null Order Release Number

comp_sequence_wm char(10) Component Sequence Number

component_item_wm char(20) Component Item Code

whse_wm char(10) Component Warehouse Code

desc1_wm char(30) Component Item Description - Line 1

desc2_wm char(30) Component Item Desctiption - Line 2

op_where_used_wm char(4) Labor Routing Step where-used (see worout)

op_consumed_wm char(4) Not in use

total_qty_rqd_wm decimal(10,3) Total Quantity required to produce end item order qty

status_wm char(1) A=Active, C=Complete

date_required_wm date Date Required

iss_qty_wm decimal(10,3) Quantity Issued

scrp_qty_wm decimal(10,3) Quantity Scrapped

add_date_wm date Date Added

change_date_wm date Date of Last Change

qty_per_unit_wm decimal(14,7) Quantity required to product one unit of end item

inv_noinv_wm char(1) S=Stock, N=Non-stock

consumed_qty_wm decimal(10,3) Not in use

issue_type_wm char(1) Not in use

ofst_from_strt_wm smallint Number of days after order start that component is needed

revision_level_wm char(10) Engineering revision level

entry_source_wm char(1) Not in use

packet_print_wm char(1) Print on Production Packet (Y or N)

issue_method_wm char(1) Component Issue Method:

C=Issue via Component Issue function

P=Issue via Production Receipt function

O=Issue via Component Issue at Operation function

N=Do not issue

user1_wm char(10) User-Defined Field

user2_wm char(10) User-Defined Field

user3_wm char(10) User-Defined Field

user4_wm char(10) User-Defined Field

user5_wm char(10) User-Defined Field

phantom_wm char(1) Phantom Item (1=Phantom, 0=not phantom)

option_wm char(10) Configuration Option

pick_list_qty_wm decimal(10,3) Quantity on open pick lists

allocated_qty_wm decimal(10,3) Not in use

shrinkage_wm decimal(5,2) Shrinkage percent

ext_desc_wm varchar(255) Extended Description

unit_price_wm decimal(11,3) Unit Price, for MTO/MTN order types

include_price_wm char(1) Include Price in end item Total Price (Y or N)

nonstk_cost_wm decimal(11,4) Non-stock item unit cost

ack_print_wm char(1) Print Component Item on Sales Order Acknowledgement (Y or N)

quo_print_wm char(1) Print Component Item on Sales Quote (Y or N)

inv_print_wm char(1) Print Component Item on Sales Invoice (y or N)

po_no_wm integer Associated Purchase Order, if ordered direct

po_line_wm smallint Associated Purchase Order Line, if ordered direct

taxable_wm char(1) In component at price to calculate tax of end item, for

MTO/MTN order type

worout Production Order Routing Table

Description - one row for each labor routing step on a production order

Column Description

order_wr char(7) Order Number

order_lot_wr char(3) Order Release Number

routing_seq_wr char(4) Routing Step Identifier

lbr_or_mach_hr_wr char(1) Schedule based on (L=Labor Hours, or M=Machine hours)

operation_wr char(4) Standard Operation (see operation table)

desc_wr char(80) Free-form description

workctr_wr char(4) Work Center

machine_wr char(4) Machine

tool_item_wr char(15) Tooling item identifier

queue_time_wr decimal(10,5) Expected Queue Time

move_time_wr decimal(10,5) Move Time

sch_start_date_wr date Production Scheduling Generated - scheduled start date

sch_compl_date_wr date Production Scheduling Generated - scheduled completion date

activity_date_wr date Date of Last Activity

std_sethr_wr decimal(14,7) Standard Setup Hours

std_runhr_unit_wr decimal(14,7) Standard Run Hours per unit of end item

std_runhr_basis_wr char(1) P=Pieces per hour, H=Hours per piece

std_machr_unit_wr decimal(14,7) Standard Machine Hours per unit of end item

std_machr_basis_wr char(1) P=Pieces per hour, H=Hours per piece

start_quantity_wr decimal(10,3) Routing Step start quantity

remain_hours_wr decimal(7,2) Routing Step hours remaining to complete

status_wr char(1) One of the following values:

0 = Packet not printed

1 = Not started, previous not started

2 = Not Started, previous started

3 = Not started, previous complete

4 = Started

5 = Completed

priority_wr char(1) Not in use

std_run_hr_wr decimal(14,7) Standard run labor hours completed

std_mach_hr_wr decimal(14,7) Standard run machine hours completed

act_run_hr_wr decimal(14,7) Actual run labor hours reported

act_mach_hr_wr decimal(14,7) Actual run machine hours reported

act_su_hr_wr decimal(14,7) Actual setup hours reported

rwk_run_hr_wr decimal(14,7) Actual rework labor hours reported

rwk_mach_hr_wr decimal(14,7) Actual rework machine hours reported

rwk_su_hr_wr decimal(14,7) Actual rework setup hours reported

compl_qty_wr decimal(14,7) Completed Quantity

discr_qty_wr decimal(14,7) Not in use

scrp_qty_wr decimal(14,7) Scrapped Quantity

rwk_qty_wr decimal(14,7) Rework Quantity

act_su_cost_wr money(11,4) Actual Setup Cost

rwk_su_cost_wr money(11,4) Rework Setup Cost

lbr_rate_cur_wr money(11,4) Labor Rate per Hour

ovh_rate_cur_wr money(11,4) Overhead Rate per hour

add_date_wr date Date added

change_date_wr date Date last changed

set_pct_compl_wr decimal(5,2) Setup percent complete

run_pct_compl_wr decimal(5,2) Run percent complete

inside_outside_wr char(1) I=Inside operation, O=Outside operation

outs_unit_cost_wr money(11,4) Outside Process cost per unit

outs_order_wr char(7) Outside Process Purchase Order

outs_line_wr decimal(4,0) Outside Process Purchase Order Line Item

outs_blkt_rel_wr decimal(4,0) Not in use

dept_wr char(3) General Ledger Department

team_wr char(5) Labor Team

packet_print_wr char(1) Print on Production Packet (Y or N)

lbr_tran_type_wr char(1) Labor Transaction Type:

L = Entered via Labor Processing

O = Entered Operation Complete entry

P = backflushed at Prod Receipt (not in use)

N = Labor not reported

user1_wr char(10) User-Defined field

user2_wr char(10) User-Defined field

user3_wr char(10) User-Defined field

option_wr char(10) Configuration Option

job_class_wr char(3) Job Class. See table jobclass

outside_item_wr char(20) Outside Process Item Code for service

ext_desc_wr varchar(255) Extended Description

unit_price_wr decimal(11,3) Unit Price, for MTO/MTN order types

include_price_wr char(1) Include Price in Total Price, for MTN/MTO order types

ack_print_wr char(1) Print on Sales Acknowledgement (Y or N)

quo_print_wr char(1) Print on Sales Quote (Y or N)

inv_print_wr char(1) Print on Sales Invoice (Y or N)

taxable_wr char(1) Include in tax calculations for end item (Y or N)

womisc Production Order Miscellaneous Charges Table

Description - one row for each Miscellaneous Charge for a Production order

Column Description

order_wb char(7) Order Number

order_lot_wb char(3) Order Release Number

element_wb char(20) Cost Element (see table costelement)

std_unit_wb decimal(10,3) Standard Cost Per Unit

act_unit_wb decimal(10,3) Actual Cost Per Unit

std_cost_wb decimal(11,4) Total Standard Cost

act_cost_wb decimal(11,4) Total Actual Cost

trans_basis_wb char(1) Not in use

status_wb char(1) Not in use

option_wb char(10) Configuration Option

ext_desc_wb varchar(255) Extended Description

unit_price_wb decimal(11,3) Unit Price, used with MTO/MTN orders

include_price_wb char(1) Include Price in end item Total Price, for MTO/MTN orders

packet_print_wb char(1) Print on Poduction Packet (Y or N)

ack_print_wb char(1) Print on Sales Acknowledgement (Y or N)

quo_print_wb char(1) Print on Sales Quote (Y or N)

inv_print_wb char(1) Print on Sales Invoice (Y or N)

taxable_wb char(1) Include in tax calculations (Y or N)

woisssumm Production Order Component Issue - Summary Record

Description - one row each time a Component Issue transaction is entered for an order. Each issue

transaction is assigned a sequential issue number. All of the component items issued

in the transaction are assigned the same issue number (see also woisscomp, woissloc)

Column Description

order_wi char(7) Order Number

order_lot_wi char(3) Order Release Number

iss_number_wi decimal(7,0) Issue Number

issue_type_wi char(1) C=via Component Issue

P=via Production Receipt

R=via Component Issue by Routing

pick_number_wi decimal(7,0) If issued by Pick List, the associated pick number

whse_wi char(10) Warehouse

comments_wi char(30) Free-form comments

iss_date_wi date User-Entered transaction date

iss_status_wi char(1) C=complete

add_date_wi date Date row added

change_date_wi date Date of last change

session_wi integer Session Number (see invsession)

rec_number_wi decimal(7,0) If issue_type_wi = P, assocated Production Receipt Number

ic_update_wi char(1) Online update. Y=Yes, N=No

gl_doc_number_wi integer General Ledger posting document number

routing_seq_wi char(4) If issue_type_wi=R, the labor routing sequence number

woisscomp Production Order Component Issue - Component Detail

Description - one row for each component issued in a Component Issue Transaction. Components can be

issued via Component Issue (sc/sc203), Component Issue by Routing (sc/sc202),

or Production Receipt (sc/sc204), depending on the setting in wocomp.issue_method_wm.

Column Description

order_wj char(7) Order Number

order_lot_wj char(3) Order Release Number

iss_number_wj decimal(7,0) Issue Number

comp_sequence_wj char(10) Component Sequence Number

component_item_wj char(20) Component Item Code

whse_wj char(10) Warehouse issued from

exp_iss_qty_wj decimal(10,3) Expected Issue Quantity

iss_qty_wj decimal(10,3) Issued Quantity

iss_qty_tmp_wj decimal(10,3) Issue Work Quantity - Used temporarily in the Issue program

comments_wj char(30) User-defined free form comments

date_iss_wj date Date of Issue transaction

time_iss_wj datetime hour to second Time of Issue transaction

revision_level_wj char(5) Engineering Revision level of issued component

iss_status_wj char(1) "A" = more to be issued, "C" = issued complete

unit_cost_wj money(11,4) Unit cost of issued item - if not serialized or lot-controlled

ic_update_wj char(1) N - Update Later, Y - Update immediately

woissloc Production Order Component Issue - Component Lot/Location/Serial Number Detail

Description - one row for each component issued in a Component Issue Transaction, where a bin location,

lot number, or serial number is recorded. Component items which are controlled by lot

number or serial number, or in warehouses which are location-controlled, must have entries

in this table, and the sum of issue quantities will match the woisscomp.iss_qty_wj value.

Column Description

order_wk char(7) Order Number

order_lot_wk char(3),A Order Release Number

iss_number_wk decimal(7,0) Issue Number

comp_sequence_wk char(10) Component Sequence Number

component_item_wk char(20) Component Item Code

whse_wk char(10) Warehouse Code

location_wk char(15) Bin Location

batch_lot_wk char(20) Batch or Lot

serial_number_wk char(20) Serial Number

expire_date_wk date Lot expiration date

onhand_balance_wk decimal(10,3) On Hand at time of issue

allocate_qty_wk decimal(10,3) Not used

iss_qty_wk decimal(10,3) Issued Quantity

iss_qty_tmp_wk decimal(10,3) Issued Quantity - Used temporarily in Issue program

date_iss_wk date Date of Issue transaction

time_iss_wk datetime hour to second Time of Issue transaction

unit_cost_wk money(11,4) Unit Cost for lot or serial number used

serld_seq_wk integer stiserld.seq_no reference

parent_serial_no char(20) Parent Item serial number

parent_lot_no char(20) Parent Item lot number

worecsumm Production Order Production Receipt - Parent Item Received Summary

Description - one row for each Production Receipt transaction. Each receipt is assigned the next sequential

receipt number, in worecsumm.rec_number_we. Each worecsumm may also have an associated

row in woisssumm, if any components are also issued at the same time (backflushing). Components

that would be issued would have wocomp.issue_method_wm="P".

Column Description

order_we char(7) Order Number

order_lot_we char(3) Order Release Number

rec_number_we decimal(7,0) Receipt Number

item_we char(20) Parent Item Code

whse_we char(10) Parent Warehouse Code

exp_rec_qty_we decimal(10,3) Expected Receipt Quantity

rec_qty_we decimal(10,3) Received Quantity

rec_qty_tmp_we decimal(10,3) Received Quantity - used temporarily in the Receipt programs

revision_level_we char(5) Parent Item Revision Level

comment_we char(30) User-Defined free form comment

rec_status_we char(1) Receipt status: A=more to be received, C=complete

rec_date_we date User-Entered Date Received

add_date_we date Date row added

change_date_we date Date row last changed

unit_cost_we money(11,4) Parent item received unit cost

gl_doc_number_we integer GL Posting document number

session_we integer Session number

iss_number_we decimal(7,0) Associated issue number in woisssumm

ic_update_we char(1) N - update later, Y - update immediately

worecloc Production Order Production Receipt - Parent Item Received Lot/Location/Serial Detail

Description - one row for each Production Receipt transaction, where a bin location,

lot number, or serial number is recorded for the parent item received. Parent

items which are controlled by lot number or serial number, or in warehouses

which are location-controlled, must have entries in this table, and the sum

of receipt quantities will match the worecsumm.rec_qty_we value.

Column Description

order_wf char(7) Order Number

order_lot_wf char(3) Order Release Number

rec_number_wf decimal(7,0) Receipt Number

item_wf char(20) Parent Item Code

whse_wf char(10) Parent Warehouse Code

location_wf char(15) Bin Location

batch_lot_wf char(20) Batch or Lot Number

serial_number_wf char(20) Serial Number

expire_date_wf date Lot Expiration Date

onhand_balance_wf decimal(10,3) On Hand Balance at time of receipt

allocate_qty_wf decimal(10,3) Not in use

rec_qty_wf decimal(10,3) Received Quantity

rec_qty_tmp_wf decimal(10,3) Received Quantity - used temporarily in the Receipt programs

date_rec_wf date Date of Receipt

time_rec_wf datetime hour to second Time of Receipt

serld_seq_wf integer stiserld.seq_no

woscpsumm Production Order Production Scrap Transaction

Description - one row for each Production Scrap transaction. A scrap transaction can also have

one or more related component issues, for component items that should be issued

from inventory as part of the parent item that is being scrapped.

Column Description

order_wg char(7) Order Number

order_lot_wg char(3) Order Release Number

scp_number_wg decimal(7,0) Scrap Number - sequentially assigned in sc/sc210

item_wg char(20) Parent Item Code

whse_wg char(10) Parent Warehouse Code

routing_seq_wg char(4) Labor Routing Sequence number where scrap occured

reason_wg char(3) Scrap Reason Code - see table reason

scp_qty_wg decimal(10,3) Scrapped Quantity

scp_qty_tmp_wg decimal(10,3) Scrapped Quantity - used temporarily during scrap entry

revision_level_wg char(5) Parent Item Engineering Revision Level

comment_wg char(30) User-defined free format comment

scp_date_wg date Date Scrapped

add_date_wg date Date row added

change_date_wg date Date row last changed

unit_cost_wg money(11,4) Unit cost of parent item scrapped

gl_doc_number_wg integer GL Document Number

session_wg integer Session number

iss_number_wg decimal(7,0) Associated Issue number for entries in woisssumm, woisscomp, woissloc

ic_update_wg char(1) N=Update later, Y=Update immediately

wosummce Production Order Cost Element Summary

Description - one row for each cost element on a production order. Cost elements are defined

for stock material issued, non-stock material issued, labor reported,

overhead reported, outside process reported, and other user-defined elements.

Cost element tables also exist for component materials (wocompce) and labor routing

(woroutce).

Column Description

order_wu char(7) Order Number

order_lot_wu char(3) Order Release Number

element_wu char(20) Cost Element - see table costelement

cost_driver_wu char(2) Cost Driver - see costelement

std_unit_cost_wu decimal(11,4) Standard Unit Cost - used when sticntrc.cost_method="S"

std_cost_wu decimal(11,4) Total Standard Cost - std_unit_cost_wu * wosumm.compl_qty_ws

act_cost_wu decimal(11,4) Actual reported cost - order level

NOTE: act_cost_wu is the sum of wocompce.act_cost_wl and

woroutce.act_cost_wn, grouped by cost element

rwk_cost_wu decimal(11,4) Actual rework cost reported - order level

wocompce Production Order Component Cost Element Summary

Description - one row for each cost element on a production order component. Cost lements are defined

for stock material issued and non-stock material issued.

Column Description

order_wl char(7) Order Number

order_lot_wl char(3) Order Release Number

comp_sequence_wl char(10) Component Sequence

component_item_wl char(20) Component Item

element_wl char(20) Cost Element

std_unit_cost_wl decimal(11,4) Component Standard Unit Cost - used when sticntrc.cost_method="S"

std_cost_wl decimal(11,4) Total Standard Cost - std_unit_cost_wl * wocomp.iss_qty_wm

act_cost_wl decimal(11,4) Total Actual Cost - wocomp.iss_qty_wm * stilocar.avg_unit_cost or

wocomp.iss_qty_wm * stiserld.unit (for serialized items)

woroutce Production Order Labor/Overhead Cost Element Summary

Description - one row for each cost element on a production order routing step. Cost lements are defined

for labor, overhead, and outside process.

Column Description

order_wn char(7) Order Number

order_lot_wn char(3) Order Release Number

routing_seq_wn char(4) Labor Routing Step

element_wn char(20) Cost Element

std_unit_cost_wn decimal(11,4) Labor Step Standard Unit Cost - used when sticntrc.cost_method="S"

std_cost_wn decimal(11,4) Total Standard Cost - one of the following calculations:

1. When cost element is for labor,

std_unit_cost_wn * (worout.std_sethr_wr +

(worout.std_runhr_unit_wr *

wosumm.cur_order_qty_ws))

2. When cost element is for overhead,

std_unit_cost_wn * (worout.std_sethr_wr +

(worout.std_machr_unit_wr *

wosumm.cur_order_qty_ws))

2. When cost element is for outside process,

std_unit_cost_wn * worout.outs_unit_cost_wr

act_cost_wn decimal(11,4) Total actual cost reported

rwk_cost_wn decimal(11,4) Total actual rework cost reported

costelement Cost Element Master

Description - one row for each cost element defined within an organization. Items can be setup

in Standard Costing to be composed of one or more cost elements, usually divided into material

cost (stock and non-stock), labor, overhead, and outside process. Pre-defined cost elements for

each of these are included in the base system, but additional user-defined costs can be created.

When a production order is created, the above cost elements are used to populate rows in tables

wosummce, wocompce, and woroutce.

NOTE: if Standard Costing is not used, a production order will automatically be assigned cost

elements of:

MATERIAL - Stock Material

NON-STOCK MATERIAL - Non-Stock Material

LABOR - Labor

OVERHEAD - Overhead

OUTSIDE - Outside Process

Column Description

element_ce char(20) Cost Element

desc_ce char(40) Description

cost_basis_ce char(1) Cost Basis. One of the following values:

cost_driver_ce char(2) Cost Driver. One of the following values:

unit_cost_dflt_ce decimal(11,4) Not in use