alter table rfd_fms.worklog modify (content varchar2(400));
alter table rfd_fms.pixiu_codcheck add flag number(1) default 0 not null;
comment on column rfd_fms.pixiu_codcheck.flag is '标识, 0:妥投 1:全单';
CREATE TABLE RFD_FMS.PIXIU_UP_REPORT_BASEINFO
(
ID NUMBER NOT NULL,
FREIGHTINFOID NUMBER NOT NULL,
ACCOUNTMONTH DATE NOT NULL,
REPORTDATE DATE NOT NULL,
REPORTTYPE NUMBER DEFAULT 0,
TOTALAMOUNT NUMBER NULL,
PERIODBANKAMOUNT NUMBER NULL,
TOTALBANKAMOUNT NUMBER NULL,
TOTALDEBT NUMBER NULL,
PERIODSTARTTIME DATE NULL,
PERIODENDTIME DATE NULL,
ISDELETED NUMBER DEFAULT 0,
CREATETIME DATE NOT NULL,
UPDATETIME DATE NOT NULL
);
COMMENT ON TABLE RFD_FMS.PIXIU_UP_REPORT_BASEINFO IS '商家运费报表明细';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.ID IS 'ID';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.FREIGHTINFOID IS '商家账期基础信息表ID';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.ACCOUNTMONTH IS '商家运费账单记录表(账单月份)';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.REPORTDATE IS '出报表时间点';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.REPORTTYPE IS '报表类型 0:周报 1:月报';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.PERIODBANKAMOUNT IS '报表周期回款';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.TOTALAMOUNT IS '应收金额总计';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.TOTALBANKAMOUNT IS '回款总计';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.TOTALDEBT IS '欠款总计';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.PERIODSTARTTIME IS '周期开始时间';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.PERIODENDTIME IS '周期结束时间';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.ISDELETED IS '是否删除 0:否 1:是';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.CREATETIME IS '创建时间';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.UPDATETIME IS '更新时间';
CREATE SYNONYM RFD_FMS_READ.PIXIU_UP_REPORT_BASEINFO FOR RFD_FMS.PIXIU_UP_REPORT_BASEINFO;
CREATE SYNONYM RFD_FMS_PROG.PIXIU_UP_REPORT_BASEINFO FOR RFD_FMS.PIXIU_UP_REPORT_BASEINFO;
GRANT DELETE,
INSERT,
SELECT,
UPDATE
ON RFD_FMS.PIXIU_UP_REPORT_BASEINFO
TO RFD_FMS_PROG;
GRANT SELECT ON RFD_FMS.PIXIU_UP_REPORT_BASEINFO TO RFD_FMS_READ;
GRANT SELECT ON RFD_FMS.PIXIU_UP_REPORT_BASEINFO TO RFD_DEV_RL;
CREATE SEQUENCE RFD_FMS.PIXIU_UP_REPORT_BASEINFO_SEQ MINVALUE 1
MAXVALUE 9999999999999999999999999999
START WITH 1
INCREMENT BY 1
CACHE 20;
CREATE SYNONYM RFD_FMS_READ.PIXIU_UP_REPORT_BASEINFO_SEQ FOR RFD_FMS.PIXIU_UP_REPORT_BASEINFO_SEQ;
CREATE SYNONYM RFD_FMS_PROG.PIXIU_UP_REPORT_BASEINFO_SEQ FOR RFD_FMS.PIXIU_UP_REPORT_BASEINFO_SEQ;
GRANT SELECT ON RFD_FMS.PIXIU_UP_REPORT_BASEINFO_SEQ TO RFD_FMS_PROG;
GRANT SELECT ON RFD_FMS.PIXIU_UP_REPORT_BASEINFO_SEQ TO RFD_FMS_READ;
GRANT SELECT ON RFD_FMS.PIXIU_UP_REPORT_BASEINFO_SEQ TO RFD_DEV_RL;
ALTER TABLE RFD_FMS.PIXIU_UP_REPORT_BASEINFO ADD (
CONSTRAINT PK_PIXIU_UP_REPORT_BASEINFO
PRIMARY KEY (ID)
USING INDEX LOCAL
ENABLE VALIDATE);