3 -- used to determine if fifo adjustment is needed on the itemsite.
6 create table invfifopos (
7 invfifopos_itemsite_id integer NOT NULL UNIQUE,
9 -- how much did the last run adjust it by.
10 invfifopos_lastadjustment numeric(18, 6) NOT NULL,
13 -- what was the last id that was run.
14 invfifopos_last_invdetail_id INT DEFAULT 0,
17 CONSTRAINT invfifopos_itemsite_id_fk FOREIGN KEY ( invfifopos_itemsite_id) REFERENCES itemsite (itemsite_id)
22 alter table invfifopos alter column invfifopos_lastadjustment type numeric(24,2);
25 GRANT ALL ON TABLE invfifo TO admin;
26 GRANT ALL ON TABLE invfifo TO xtrole;
29 CREATE INDEX invfifopos_itemsite_id_indx
32 (invfifopos_itemsite_id);
35 CREATE INDEX invfifopos_last_invdetail_id_indx
38 (invfifopos_last_invdetail_id);
41 CREATE INDEX invfifopos_lastadjustment_indx
44 (invfifopos_lastadjustment);
47 CREATE OR REPLACE FUNCTION invfifopos_update(integer, integer, numeric)
52 i_itemsite_id ALIAS FOR $1;
53 i_invdetail_id ALIAS FOR $2;
54 i_lastadjustment ALIAS FOR $3;
60 invfifopos_last_invdetail_id
66 invfifopos_itemsite_id = i_itemsite_id;
73 invfifopos_last_invdetail_id = i_invdetail_id,
74 invfifopos_lastadjustment = i_lastadjustment
76 invfifopos_itemsite_id = i_itemsite_id;
84 ( invfifopos_itemsite_id , invfifopos_lastadjustment , invfifopos_last_invdetail_id )
86 (i_itemsite_id, i_lastadjustment, i_invdetail_id);
93 LANGUAGE plpgsql VOLATILE
96 ALTER FUNCTION invfifopos_update(integer, integer, numeric)