历史库数据模型chenan.pdfVIP

模版

报告人隶属于购物组人鹏

模块名B2C对账

表名B2C_TASK

改动描述：修改B2C对账定时任务为初始化状态

--Add/modifycolumns

altertableB2C_BATCH_PAYMENT_COLLATEaddinacc_type

VARCHAR2(3CHAR);

altertableB2C_BATCH_PAYMENT_COLLATEaddintegral_flag

CHAR(1CHAR);

altertableB2C_BATCH_PAYMENT_COLLATEaddscoreVARCHAR2(18

CHAR);

altertableB2C_BATCH_PAYMENT_COLLATEadd

total_refund_scoreVARCHAR2(18CHAR);

altertableB2C_BATCH_PAYMENT_COLLATEadd

score_deduction_amtVARCHAR2(18CHAR);

altertableB2C_BATCH_PAYMENT_COLLATEadd

TOTAL_SCORE_DEDUCTION_AMTVARCHAR2(18CHAR);

altertableB2C_BATCH_PAYMENT_COLLATEaddshare_cash

VARCHAR2(18CHAR);

altertableB2C_BATCH_PAYMENT_COLLATEaddtotal_share_cash

VARCHAR2(18CHAR);

--Addcommentstothecolumns

commentoncolumnB2C_BATCH_PAYMENT_COLLATE.inacc_type

is担保类型，1担保，0非担保;

commentoncolumnB2C_BATCH_PAYMENT_COLLATE.integral_flag

is是否积分支付标志,1是，0否;

commentoncolumnB2C_BATCH_PAYMENT_COLLATE.score

is兑换积分值;

commentoncolumn

B2C_BATCH_PAYMENT_COLLATE.total_refund_score

is累计退货积分值;

commentoncolumn

B2C_BATCH_PAYMENT_COLLATE.score_deduction_amt

is积分等值金额;

commentoncolumn

B2C_BATCH_PAYMENT_COLLATE.TOTAL_SCORE_DEDUCTION_AMT

is累计退货积分等值金额;

commentoncolumnB2C_BATCH_PAYMENT_COLLATE.share_cash

is积分等值金额中银行支付给商户的金额;

commentoncolumn

B2C_BATCH_PAYMENT_COLLATE.total_share_cash