Bill of Material Tables

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

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

initbm Bill of Material Control Table

Description - one row for control information established at setup

Column Description

init_key_ib char(1) not null Always '1'

user_1_text_ib char(20) Item Master user-defined column heading

user_2_text_ib char(20) Item Master user-defined column heading

user_3_text_ib char(20) Item Master user-defined column heading

user_4_text_ib char(20) Item Master user-defined column heading

user_5_text_ib char(20) Item Master user-defined column heading

dflt_iss_meth_ib char(1) C=component issue

P=production receipt

O=Issue at routing step operation

dflt_bill_ib char(5) Default to assign to new items created

setup_done_ib char(1) Y=Yes, N=No

acctcd Accounting Code Table

Description - one row per accounting code/element combination. Used to cross-

reference an accouting code and type of financial transaction to

a General Ledger Account. The base software includes rows for the

11 elements listed below, all with acctcd_ac = DEFAULT. The user

can create additional accounting codes, if needed, but each code

must also have 11 entries, from each of the elements below. This table

is used when posting material or labor transactions from Production

Order Processing and Labor Processing modules to General Ledger.

Column Description

acctcd_ac char(13) not null Accounting code (default is 'DEFAULT')

element_ac char(20), desc_ac char(25) One of the following values:

LABOR LABOR

LABOR CONTROL LABOR CONTROL ACCOUNT

MATERIAL DEFAULT ACCOUNTS

MATERIAL USAGE VAR DEFAULT ACCOUNTS

NON-STOCK MATERIAL NOSTOCK MDSE

OUTSIDE PROCESS OUTSIDE PROCESS

OVERHEAD OVERHEAD

OVERHEAD CONTROL OVERHEAD CONTROL OFFSET

SCRAP EXPENSE SCRAP EXPENSE

WIP RECEIPT RECPT TO FG

WIP SCRAP WIP CHARGED TO SCRAP

account_ac char(13) GL Account number

add_date_ac date Date row added

change_date_ac date Date row last changed

status_ac char(1) Not in use

billsumm Bill of Material Summary

Description - one row per unique bill of material

for a produced item. Each produced

item can have one or more BOM's. Each

unique BOM has a list of components in

billcomp

Column Description

parent_item_bs char(20) Parent Item Code

bill_bs char(5) Unique bill of material identifier

start_date_bs date Bill start effective Date

stop_date_bs date Bill stop effective date

revision_level_bs char(3) Engineering Revision Level

num_eng_change_bs char(6) Engineering Change Number

date_eng_change_bs date Date engineering change activated

eng_drawing_bs char(15) Engineering Drawing number

comment_bs char(480) User-Defined comment

add_date_bs date Date Row added

change_date_bs date Date row last changed

component_count_bs smallint Number of components

billcomp Bill of Material Components

Description - one row per parent item/bill of material/component

item combination.

Column Description

parent_item_bc char(20) Parent Item Code

bill_bc char(5) Unique bill of material identifier

comp_item_bc char(20) Component Sequence identifier

comp_sequence_bc char(10) Component Item Code

op_where_used_bc char(4) Routing step operation where used (see routoper)

qty_per_unit_bc decimal(14,7) Quantity needed to produce one unit of parent item

ofst_from_strt_bc smallint Number of Days after production start when needed

start_date_bc date Component effective start date

stop_date_bc date Component effective stop date

engchng_parent_bc char(6) Parent Engineering change number

low_level_bc smallint Not in use

sply_to_vendor_bc char(1) Not in use

shrinkage_bc decimal(5,2) Percent loss when issued as a component

issue_method_bc char(1) C=Component Issue

P=Production Receipt

O=Issue at routing step operation

issue_type_bc char(1) T=Inventory transaction

C=Cost only

packet_print_bc char(1) Y=include on Production Packet print

N=do not print on Production Packet print

user1_bc char(10) User-Defined value

user2_bc char(10) User-Defined value

user3_bc char(10) User-Defined value

itemgroup Item Group Codes

Description - one row per item group. Items may be assigned a group, to aid in standard

reporting, or custom reporting. For example, a report may be requested for

all items with Item Group "AUTO".

Column Description

group_ig char(3) not null Item group code

desc_ig char(25) not null Free-format description

add_date_ig date Date row added

change_date_ig date Date row last changed

status_ig char(1) Not in use

itemsubst Component Item Substitutions

Description - one row per component item/substitute item. Established alternate or

substitute items to be used when a component item is short

Column Description

item_ix char(20) Component Item Code begin substituted

sequence_ix smallint Substitute sequence number

substitute_item_ix char(20) Substituting item code

qty_per_unit_ix decimal(12,6) Substituting item replacement qty. In some cases,

it may require multiple units (or some fraction of

a unit) of a substitute to replace one unit

of the base component.

comment_ix char(40) User-defined comment

add_date_ix date Date row added

change_date_ix date Date row last changed

product Item Product Codes

Description - one row per item product. Items may be assigned a product code, to aid in standard

reporting, or custom reporting. For example, a report may be requested for

all items with Product Code "STEEL".

Column Description

product_pu char(3) not null Product Code

desc_pu char(25) Free-form text

account_pu char(12) Not in use

pt_qty_order_pu decimal(12,5) Not in use

pt_qty_ship_pu decimal(12,5) Not in use

yt_qty_order_pu decimal(12,5) Not in use

yt_qty_ship_pu decimal(12,5) Not in use

pt_amt_order_pu money(16,2) Not in use

pt_amt_ship_pu money(16,2) Not in use

pt_amt_cost_pu money(16,2) Not in use

pt_comm_amt_pu money(16,2) Not in use

pt_disc_amt_pu money(16,2) Not in use

pt_invc_amt_pu money(16,2) Not in use

yt_amt_order_pu money(16,2) Not in use

yt_amt_ship_pu money(16,2) Not in use

yt_amt_cost_pu money(16,2) Not in use

yt_comm_amt_pu money(16,2) Not in use

yt_disc_amt_pu money(16,2) Not in use

yt_invc_amt_pu money(16,2) Not in use

activity_date_pu date Not in use

add_date_pu date Date row added

change_date_pu date Date row last changed

status_pu char(1) Not in use