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(20), # 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
------------------------------------------------------------------------
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(200) 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
----------------------------------------------------------