2 CREATE SEQUENCE netsuite_balance_id_seq
8 ALTER TABLE netsuite_balance_id_seq
10 GRANT ALL ON TABLE netsuite_balance_id_seq TO admin;
11 GRANT ALL ON TABLE netsuite_balance_id_seq TO xtrole;
14 CREATE TABLE netsuite_balance
16 id integer NOT NULL DEFAULT nextval(('netsuite_balance_id_seq'::text)::regclass),
19 beginning numeric(14,2),
21 hkd_beginning numeric(14,2),
22 hkd_ending numeric(14,2),
24 CONSTRAINT netsuite_balance_id_pkey PRIMARY KEY (id )
30 GRANT ALL ON TABLE netsuite_balance TO admin;
31 GRANT ALL ON TABLE netsuite_balance TO xtrole;
33 ALTER TABLE netsuite_balance ADD COLUMN base_beginning numeric(14,2);
34 ALTER TABLE netsuite_balance ADD COLUMN base_ending numeric(14,2);
35 ALTER TABLE netsuite_balance ADD COLUMN base_close numeric(14,2);