先进先出库龄计算Sql Over

ERP中库龄计算是常用报表，根据入出库表、当日结存表计算库龄。

一、入出库表

CREATE TABLE MM_InOutDetail

(

calday varchar2(8) not NULL,

create_time timestamp default current_timestamp,

comp_code varchar2(4) not NULL,

comp_name varchar2(30),

parent_org varchar2(30) not NULL,

material varchar2(20) not NULL,

material_name varchar2(60),

base_uom varchar2(4),

charg varchar2(30),

move_type varchar2(3),

QUANT_B float,

TPrice float

, currentqty float);

二、当日库存表

CREATE TABLE MM_CloseStock

(

calmonth varchar2(6) not NULL,

comp_code varchar2(4) not NULL,

comp_name varchar2(30),

parent_org varchar2(30) not NULL,

material varchar2(20) not NULL,

material_name varchar2(60),

base_uom varchar2(4),

charg varchar2(30),

bstaus varchar2(1),

QUANT_B float,

TPrice float,

constraint YY