Replenishment Tables

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

stiperdr - RL Period Definition Table

period_code char(6), # Period Code

period_desc char(30), # Period Description

days_duration smallint, # number of days in period

no_periods smallint # number of periods to track

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

stifrmlr - Formula Definition Table

formula_code char(14), # Resultant Variable

formula_desc char(30), # Resultant Variable Description

formula_equation char(200) # formula to resolve resultant variable

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

stirldtd - Calculations detail table

doc_no integer, # doc number

line_no smallint, # line no

formula_code char(14), # formula

formula_value decimal(12), # formula value

formula_type char(1), # resultant variable's type

user_override decimal(12) # user override

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

stirldtr - Calculations header table

doc_no serial not null , # doc number

script_code char(6), # script code

warehouse_code char(10), # warehouse

vend_code char(20), # vendor

item_code char(20) # item

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

stirlscr - Script Definition Table

script_code char(6), # script code

script_desc char(30), # script description

period_code char(6), # period code

replen_code char(6), # replenishment code

line_code char(6), # line code

warehouse_code char(10), # warehouse code

item_code char(20), # item code

s_date date, # start date

e_date date, # end date

n_date date, # usage next date

calc_delay smallint, # calc delay

buy_delay smallint, # buy delay

usage_c_date date, # usage trx date

calc_c_date date, # calc trx date

calc_n_date date, # calc next date

buy_c_date date, # buy trx date

buy_n_date date, # buy next date

skip_usage char(1), # skip usage?

skip_calc char(1), # skip calc?

skip_buy char(1) # skip buy

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

stirplnd - RL definition detail table

replen_code char(6), # RL code

line_no smallint, # line number

formula_code char(14), # formula code

formula_equation char(200), # formula equation

formula_type char(1), # formula type

create_column char(1) # create column?

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

stirplnr - RL definition header table

replen_code char(6), # RL code

replen_desc char(30) # description

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

stirrard - Recommendations Detail Table

doc_no integer, # doc number

item_code char(20), # item code

stock_type char(1), # stock type

purch_unit char(2), # purch unit

avail_qty decimal(10), # avail qty.

on_order_qty decimal(10), # on order qty.

sug_order_qty decimal(10), # sugg. order qty.

actual_ord_qty decimal(10), # actual order qty.

desc1 char(30), # description

desc2 char(30), # description

abc_code char(1), # abc code

avg_lead_time decimal(3), # avg. lead time

except_flag char(1), # except flag

discount_flag char(1), # discount flag

price decimal(14,4), # price

volume decimal(10), # volume

weight decimal(10), # weight

extension decimal(20), # extension

weight_ext decimal(10), # weight extension

volume_ext decimal(10), # volume ext.

on_po_qty decimal(10), # on po qty.

from_tran_qty decimal(10), # from transfer qty.

to_tran_qty decimal(10), # to transfer qty.

qty_on_hand decimal(10), # qty on hand

order_point_qty decimal(10) # order point qty.

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

stirrare - Recommendations Header Table

doc_no serial not null , # document number

script_code char(6), # script code

line_code char(6), # line code

warehouse_code char(10), # warehouse

vend_code char(20), # vendor code

buyer_code char(6), # buyer code

review_cycle decimal(6), # review cycle

next_review date, # next review date

minimum_order decimal(20), # minimum order

target_order decimal(20), # target order

order_total decimal(20), # order total

stock_total decimal(20), # stock total

nonstk_total decimal(20), # nonstk total

weight_total decimal(20), # weight total

volume_total decimal(20) # volume total

po_no char(20) # PO Number

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

stiusged - Usage Detail Table

doc_no integer, # document

period_no smallint, # period number

s_date date, # start date

e_date date, # end date

actual_act decimal(10), # actual activity

pure_usage decimal(10), # usage

user_override decimal(10) # user override usage

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

stiusger - Usage Header Table

doc_no serial not null , # document

script_code char(6), # script code

warehouse_code char(10), # warehouse

item_code char(20) # item code

line_code char6) # line code

buyer_code char(6) # buyer code

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

stiprlnd - Product Line Detail Table

line_code char(6), # line code

warehouse_code char(10), # warehouse code

buyer_code char(6), # buyer code

review_cycle decimal(6), # review cycle

last_review date, # last review

next_review date, # next review

start_date date, # start date

end_date date, # end date

annual_dollars decimal(20), # annual dollars

annual_volume decimal(10), # annual volume

annual_weight decimal(10), # annual weight

annual_qty decimal(10), # annual qty.

target_type char(1), # target type

minimum_order decimal(20), # minimum order

target_order decimal(20), # target order

achievement_1 decimal(10),

achievement_2 decimal(10),

achievement_3 decimal(10)

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

stiprlne - Product Line Header Table

line_code char(6), # line code

vend_code char(20), # vendor code

line_desc1 char(30), # line desc 1

line_desc2 char(30) # line desc 2

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

stxlookd - Look Up Detail Table

lookup_code char(14) Look up code

colname char(37) Column name

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

stxlookr - Look Up Header Table

lookup_code char(14) Look up code

description char(30) Description

select_statement char(200) Select Statement

hard_filter char(250) Hard Filter

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

stisfltr - Use to validate values in stxlookd table

colname char(37),

scr_colname char(37)

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

stiwhall - Warehouse Reallocation Table

item_code char(20) not null, # item code

warehouse_code char(10) not null, # warehouse

usage_qty decimal(10), # usage qty

qty_on_hand decimal(10), # qty on hand

on_order_qty decimal(10), # on order qty.

on_po_qty decimal(10), # on po qty.

on_tran_qty decimal(10), # on transfer qty.

avail_qty decimal(10), # avail qty.

reallocate_qty decimal(10), # reallocate qty.

reallocate_factor decimal(10) # reallocate factor

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

sturepln - Purchase Replenishment Advice

item_code char(20),

warehouse_code char(10),

vendor_code char(20),

cost decimal(12,2),

purch_unit char(2),

sales_usg_1 integer,

sales_usg_2 integer,

sales_usg_3 integer,

sales_usg_4 integer,

sales_usg_5 integer,

sales_usg_6 integer,

sales_usg_7 integer,

sales_usg_8 integer,

sales_usg_9 integer,

sales_usg_10 integer,

sales_usg_11 integer,

sales_usg_12 integer,

sales_usg_tot integer,

average integer,

available integer,

on_order integer,

total integer,

months_on_hand decimal(12,1),

on_order_month_seq smallint,

on_order_month char(12),

on_order_month_qty integer