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(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
----------------------------------------------------------
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