支付平臺(tái)數(shù)據(jù)庫(kù)設(shè)計(jì)文檔 -

-.z.--.--考試資料內(nèi)部資料內(nèi)部資料注意保密電子商務(wù)平臺(tái)一期數(shù)據(jù)庫(kù)設(shè)計(jì)文檔版本號(hào)：1.00二○一〇年十月工程情況工程編號(hào)工程名稱工程經(jīng)理需求分析工程師系統(tǒng)設(shè)計(jì)工程師修改記錄版本號(hào)發(fā)布日期作者評(píng)審人變更的章節(jié)目錄TOC\o"1-3"\h\z1前言81.1命名標(biāo)準(zhǔn)81.2說(shuō)明81.3術(shù)語(yǔ)清單81.4數(shù)據(jù)庫(kù)表清單92根底平臺(tái)核心數(shù)據(jù)庫(kù)表構(gòu)造(zmc)102.1賬戶10客戶子賬戶表SubAccount10子賬戶凍結(jié)/注銷流水SubAccount_Oper10客戶子賬戶資金變動(dòng)流水表SubAccountSeq11客戶子賬戶資金凍結(jié)流水表SubAccountFreezeSeq122.2交易13充值交易流水RechargeBILL13提現(xiàn)交易流水WithDrawBILL14支付交易流水PayBILL15批量代收付交易信息表〔BatchInfo〕19撤銷交易流水UndoPayBILL20退款交易流水RefundBill21匯款交易流水WaitingRechargeBILL22內(nèi)部調(diào)賬交易流水AdjustBiLL23外部系統(tǒng)交易通知SHOP_NOTIFY242.3會(huì)計(jì)帳務(wù)24科目日記賬表(SUBJECT_DAY)24試算平衡表〔Balance_Check〕24科目類型表(SUBJECTTYPE)25憑證類型表(PZTYPE)25憑證科目對(duì)應(yīng)表(PZSUBJECT)25科目明細(xì)表(SUBJECT)26憑證明細(xì)表(PZ)262.4系統(tǒng)參數(shù)27序列272.5渠道27渠道清算指令〔Channel_Settle_Cmd〕27渠道參數(shù)〔Channel_Parm〕27渠道返回碼對(duì)照表〔Channel_RtnCode〕28渠道交易流水對(duì)照表(BILLNo_SN)28批量交易渠道批次表(Channel_Batch)29系統(tǒng)日志(Channel_Sys_Log)30渠道對(duì)帳表(Channel_Check)31渠道對(duì)帳不平明細(xì)表(Channel_CheckDetail)31同城超時(shí)等待表(TC_OVERTIME_WAIT)33同城批量撤銷表(TC_BATCHCANCEL)34同城費(fèi)項(xiàng)代碼對(duì)應(yīng)表(CHANNEL_FEECODE_CHG)34同城對(duì)帳指令表(TC_CHECK_CMD)34同城對(duì)賬表(TC_CHECK)35同城對(duì)賬明細(xì)表(TC_CHECK_DETAIL)35明細(xì)下載回應(yīng)表(CHECK_DOWN)36明細(xì)下載回應(yīng)清單(CHECK_DOWN_DETAIL)36交易查詢查復(fù)表(Trans_Query)373系統(tǒng)管理數(shù)據(jù)庫(kù)表構(gòu)造383.1系統(tǒng)維護(hù)38效勞監(jiān)控主表〔MONITORAPPGROUP〕38效勞監(jiān)控明細(xì)表〔MONITORAPPDETAIL〕38系統(tǒng)日志(Sys_Log)39平臺(tái)功能描述表〔PlatForm_Fun〕40管理平臺(tái)操作日志(Operate_Log)40通知公告欄(Public_Bulletin)40效勞產(chǎn)品管理(Service_Product)41黑白名單表(BW_List)413.2權(quán)限41登陸用戶根本信息表(LOGIN_INFO)41角色信息表〔ROLE_INFO〕42登陸用戶角色表〔LOGIN_ROLE〕43角色權(quán)限表〔ROLE_PRIVILEGE〕43權(quán)限信息表〔PRIVILEGE〕43權(quán)限資源表〔PRIVILEGE_RESOURCE〕443.3權(quán)限組44權(quán)限組信息〔LIMITGROUP〕44權(quán)限分組表〔LIMIT_GROUP_PRIVILEGE〕453.4賬戶45快付通結(jié)算賬戶余額表(BankAccount_Balance)45子賬戶類型表(SUBACCOUNT_TYPE)46子賬戶互轉(zhuǎn)控制表(SUBACCOUNT_TRANSCTRL)46客戶已驗(yàn)證銀行賬戶表CustBankCard〔管理平臺(tái)〕46客戶子賬戶與銀行賬戶綁定表(SubAccountBindCard)47賬戶與銀行帳戶綁定流水表kftbindact_bill〔管理平臺(tái)〕47賬戶驗(yàn)證流水AccountVerifyBILL〔管理平臺(tái)〕47代付業(yè)務(wù)綁定的收款賬戶(PAY_BINDBANKACOUNT)483.5客戶信息49客戶信息表(CUST_INFO)49登錄證書表〔LOGIN_CERTIFICATE〕50客戶證件掃描件表〔CustCert_Scan〕50商戶信息管理(管理員維護(hù))〔Merchant_Info〕51客戶級(jí)別管理〔CUST_LEVEL〕51客戶開通業(yè)務(wù)列表(Cust_ServiceList)52商戶開通業(yè)務(wù)列表〔Merchant_SERVICE_List〕52客戶訂閱通知表(Cust_AlarmType)52客戶投訴建議(CUST_SERVICE)52登記注冊(cè)類型〔Register_Type〕53行業(yè)分類〔Industry_Type〕533.6協(xié)議53協(xié)議范本(PROTOCOL_TE*T)53協(xié)議類型表(PROTOCOL_TYPE)54客戶銀行代收協(xié)議〔CKB_Protocol〕54快付通商戶與平臺(tái)外客戶三方代收協(xié)議〔NotKft_PROTOCOL〕〔走無(wú)協(xié)議代扣渠道〕54快付通商戶與平臺(tái)內(nèi)客戶三方代收協(xié)議〔Kft_PROTOCOL〕55商戶代理關(guān)系表(Merchant_Pro*yRelation)56客戶計(jì)費(fèi)信息表(Cust_Fee_Rule)56企業(yè)代收付協(xié)議(PROTOCOL_PARTYPAYEE)56匯款充值協(xié)議(PROTOCOL_REMIT)57卡通協(xié)議〔PROTOCOL_KFTCARD〕573.7業(yè)務(wù)參數(shù)58費(fèi)用代碼表(Fee_Code)58銀行類型表(BANK_TYPE_INFO)58城市代碼表(City_Code)58行名行號(hào)表(Bank_Code)59銀行開通業(yè)務(wù)表(Bank_Service)〔門戶展示給客戶用〕593.8系統(tǒng)參數(shù)59結(jié)算帳號(hào)配置表59運(yùn)行參數(shù)(RunParm)60系統(tǒng)參數(shù)〔SYSPARM〕61定時(shí)方案定義表〔TASKDEFINE〕61定時(shí)方案執(zhí)行表〔TASKLIST〕62后臺(tái)定時(shí)效勞表〔TimerAppServer〕62客戶通知消息〔Cust_AlarmMessage〕633.9手續(xù)費(fèi)管理64商戶效勞種類表〔收費(fèi)標(biāo)準(zhǔn)接口〕(Cust_Service_Type)64提現(xiàn)計(jì)費(fèi)規(guī)則〔DrawMoney_Rule〕64計(jì)費(fèi)方法〔FEE_METHOD〕64計(jì)費(fèi)方法明細(xì)〔FEE_METHOD_DETAIL〕65定期手續(xù)費(fèi)表(Regular_ServiceFee)66客戶支付交易計(jì)分規(guī)則表〔Cust_PointCalcRule〕663.10限額管理67客戶使用額度控制表(Cust_UseAmountCtl)67交易額度〔DEAL_AMOUNTCTRL〕67大額資金代付交易額度〔BigAmount_DFLimit〕68監(jiān)控額度配置表〔Watch_Limit〕68黑名單配置(B_Watch)68白名單配置(W_Watch)693.11支付管理69渠道類型(Channel_Type)69渠道管理〔PAY_CHANNEL〕69渠道賬戶對(duì)照表〔Channel_Bank_Account〕70賬戶驗(yàn)證渠道表(Account_CheckRoute)70協(xié)議簽訂渠道表(Protocol_SignRoute)70支付路由表〔PAY_ROUTE〕71調(diào)撥指令表(FlitCommand)713.12報(bào)表72分渠道交易統(tǒng)計(jì)報(bào)表(PAY_CHANNEL_DEALREPORT)72商戶交易統(tǒng)計(jì)報(bào)表(CUST_DEALREPORT)72結(jié)算戶支出報(bào)表〔BALANCEACT_PAYOUT_REPORT〕73從快付通結(jié)算戶入監(jiān)管戶報(bào)表〔MONITERACT_PAYIN_REPORT〕73監(jiān)管戶出賬報(bào)表(MONITERACT_PAYOUT_REPORT)73基金交易日?qǐng)?bào)表〔FUND_DAY_REPORT〕74當(dāng)日大額提現(xiàn)交易監(jiān)控(Day_BigAmount_Watch)74累計(jì)提現(xiàn)交易監(jiān)控(Total_Amount_Watch)75信用卡交易監(jiān)控(Credit_Amount_Watch)75對(duì)公轉(zhuǎn)對(duì)私交易監(jiān)控(Trans_Amount_Watch)75兩客戶互轉(zhuǎn)監(jiān)控(Trade_Amount_Watch)753.13門戶網(wǎng)站業(yè)務(wù)表76收款請(qǐng)求交易表〔Web_RequestMoney〕76門戶個(gè)人登錄信息表(USER_LOGIN_INFO)76門戶用戶操作日志(USER_OPERATE_Log)77密碼問(wèn)題(PWD_QUESTION)774基金業(yè)務(wù)數(shù)據(jù)庫(kù)表構(gòu)造78批量指令表〔batch_inst〕78開戶信息表〔openAccount_info〕79充提交易對(duì)帳〔deposit_withdraw_check〕80批次對(duì)照表〔Batch_File_Map〕80申購(gòu)類交易信息表〔buyFund_Info〕81撤銷交易表〔abolish〕83贖回類交易表〔redeem_info〕83對(duì)賬結(jié)果表〔Check_Account〕854.2基金根底數(shù)據(jù)85基金信息表〔fund_info〕85基金公司〔InstCorp_info〕86基金平臺(tái)各連接節(jié)點(diǎn)開通業(yè)務(wù)表〔Fund_Limit〕86客戶已開通基金公司賬戶表〔Cust_Inst_Map〕86基金代銷對(duì)照表(inst_agent_map)86基金業(yè)務(wù)平臺(tái)系統(tǒng)參數(shù)表〔Fund_Sys_Parm〕875系統(tǒng)根底參數(shù)885.1地區(qū)代碼885.2銀行種類代碼885.3渠道編碼885.4子帳戶類型895.5卡類型定義905.6渠道自定義交易類型90-.z.前言命名標(biāo)準(zhǔn)1〕數(shù)據(jù)庫(kù)表名命名標(biāo)準(zhǔn)2〕所有數(shù)據(jù)庫(kù)表的名字用有意義的英文或英文縮寫來(lái)表示，如:系統(tǒng)參數(shù)表的名字為SYSPARM.3〕字段命名標(biāo)準(zhǔn)4〕所有字段的名字用有意義的英文或英文縮寫來(lái)表示，如:字段〞用戶代碼〞的名字為USERCODE.說(shuō)明1〕所有金額的單位為"元〞2〕所有的日期格式為YYYYMMDD(月份或天不夠2位的前面補(bǔ)零)，所有的時(shí)間格式為HHMMSS，所有年月字段為YYYYMM(月份不夠2位的前面補(bǔ)零).3〕幣種字段目前全部固定為RMB4〕關(guān)鍵字用"PK〞表示5〕對(duì)于表中標(biāo)明為自動(dòng)產(chǎn)生的字段，表示該字段不需要人工錄入，而是在追加時(shí)自動(dòng)產(chǎn)生該字段的值術(shù)語(yǔ)清單名稱字段說(shuō)明支付類型Pay_Type與支付相關(guān)0001網(wǎng)銀支付1001實(shí)時(shí)代收2001實(shí)時(shí)代付1002批量代收2002批量代付交易類型Tran_Type8310帳戶驗(yàn)證〔打款驗(yàn)證，報(bào)文驗(yàn)證〕卡通協(xié)議簽訂8301充值〔網(wǎng)銀充值、卡通充值〕1301即時(shí)到帳支付〔網(wǎng)銀支付、卡通支付、平臺(tái)帳戶支付〕1302擔(dān)保交易支付〔網(wǎng)銀支付、卡通支付、平臺(tái)帳戶支付〕1303擔(dān)保交易支付確認(rèn)〔收款人確認(rèn)、付款人確認(rèn)〕8022擔(dān)保交易退款申請(qǐng)8023擔(dān)保交易退款確認(rèn)1001實(shí)時(shí)代扣2001批量代扣1002實(shí)時(shí)代付2003批量代付8304實(shí)時(shí)提現(xiàn)8303普通提現(xiàn)8021直接退款交易類型代碼做如下細(xì)化：網(wǎng)銀充值：(充值)卡通充值：〔實(shí)時(shí)協(xié)議代扣+有支付協(xié)議〕實(shí)時(shí)提現(xiàn)：〔實(shí)時(shí)代付〕批提現(xiàn)：〔批量代付〕協(xié)議實(shí)時(shí)代扣〔有支付協(xié)議〕協(xié)議實(shí)時(shí)代扣〔無(wú)支付協(xié)議〕實(shí)時(shí)代付協(xié)議批量代扣〔有支付協(xié)議〕協(xié)議批量代扣〔無(wú)支付協(xié)議〕批量代付網(wǎng)銀支付卡通支付〔卡通充值+平臺(tái)內(nèi)支付〕數(shù)據(jù)庫(kù)表清單數(shù)據(jù)庫(kù)表構(gòu)造分為四個(gè)局部，第一局部為根底平臺(tái)數(shù)據(jù)庫(kù)表構(gòu)造，第二局部為門戶網(wǎng)站數(shù)據(jù)庫(kù)表構(gòu)造，第三局部為基金平臺(tái)數(shù)據(jù)庫(kù)表構(gòu)造。第四局部為體彩平臺(tái)數(shù)據(jù)庫(kù)構(gòu)造。根底平臺(tái)核心數(shù)據(jù)庫(kù)表構(gòu)造(zmc)賬戶客戶子賬戶表SubAccount字段名類型是否為空是否主鍵中文說(shuō)明IDNUMBER(12)NPK子賬戶ID序列Cust_IdVARCHAR2(20)N客戶編號(hào)平安控制值Subaccount_typeVarchar2(4)N子賬戶號(hào)類型平安控制值Cust_NameVARCHAR2(100)N用戶名AmountNUMBER(15,2)N總金額平安控制值Cash_AmountNUMBER(15,2)N可提現(xiàn)平安控制值Uncash_AmountNUMBER(15,2)N不可提現(xiàn)平安控制值Freeze_Cash_AmountNUMBER(15,2)N可提現(xiàn)凍結(jié)金額平安控制值Freeze_UnCash_AmountNUMBER(15,2)N不可提現(xiàn)凍結(jié)金額平安控制值BankCardNoVarchar2〔32〕Y綁定的銀行卡號(hào)默認(rèn)提現(xiàn)帳號(hào)PropertyChar(1)N賬戶性質(zhì)1-個(gè)人2-企業(yè)StateVARCHAR2(2)N狀態(tài)00-生效凍結(jié)注銷Create_TimeDATEN創(chuàng)立時(shí)間CardBindTimeDATEY銀行卡綁定時(shí)間Ji*i_BaseNUMBER(15,0)N計(jì)息積數(shù)LastTerm_Ji*i_DateVARCHAR2(8)N上期計(jì)息的時(shí)間LastUpdate_TimeDATEN最新修改時(shí)間LastTerm_AmountNUMBER(15,2)N上期總金額計(jì)息使用Check_ValueVarchar2(32)N校驗(yàn)碼對(duì)平安控制值MD5后Base64編碼總金額＝可用金額＋不可用金額可用金額＝可提現(xiàn)金額＋不可提現(xiàn)金額不可用金額＝可提現(xiàn)凍結(jié)金額＋不可提現(xiàn)凍結(jié)金額子賬戶凍結(jié)/注銷流水SubAccount_Oper字段名類型是否為空是否主鍵中文說(shuō)明IDNumber(12)NPK流水號(hào)Cust_IdVARCHAR2(20)N客戶號(hào)Cust_NameVARCHAR2(100)N用戶名SubAccountTypeVarchar2(4)N子賬戶類型OperTypeCHAR(1)N操作類型1凍結(jié)2注銷3解凍Create_TimeDateN操作時(shí)間OperatorVarchar2〔20〕Y操作員管理平臺(tái)的操作員RemarkVarchar2(100)Y附言客戶子賬戶資金變動(dòng)流水表SubAccountSeq字段名類型是否為空是否主鍵中文說(shuō)明SNVARCHAR2(20)NPK流水號(hào)YYYYMMDD+帳務(wù)流水〔每天1〕SubAccount_IDVarchar2(12)N子賬戶IDCust_IdVARCHAR2(20)N客戶編號(hào)冗余SubAccount_TypeVarchar2(4)N子賬戶號(hào)類型冗余Cust_NameVARCHAR2(100)N用戶名SeqFlagChar(1)N帳務(wù)變動(dòng)方向0-來(lái)帳1-往帳Change_TypeChar(2)N類型01充值02支付03提現(xiàn)04內(nèi)部調(diào)賬05結(jié)息06利息稅07原交易退款08原交易撤銷PreAmountNUMBER(15,2)N變動(dòng)前總金額AmountNUMBER(15,2)N變動(dòng)后總金額Cash_AmountNUMBER(15,2)N可提現(xiàn)發(fā)生額Uncash_AmountNUMBER(15,2)N不可提現(xiàn)發(fā)生額Freeze_Cash_AmountNUMBER(15,2)N可提現(xiàn)凍結(jié)發(fā)生額Freeze_UnCash_AmountNUMBER(15,2)N不可提現(xiàn)凍結(jié)發(fā)生額REFSNVARCHAR2(16)Y關(guān)聯(lián)流水IDChange_Type對(duì)應(yīng)不同的表，充值流水支付流水提現(xiàn)流水REFBATCHIDVARCHAR2(16)Y批次號(hào)OrderIDVARCHAR2(32)Y訂單號(hào)冗余Create_TimeDATEN創(chuàng)立時(shí)間NoteVARCHAR2(100)Y備注WORKDATEVARCHAR2(8)N會(huì)計(jì)日期與會(huì)計(jì)憑證進(jìn)展核算的日期客戶子賬戶資金凍結(jié)流水表SubAccountFreezeSeq字段名類型是否為空是否主鍵中文說(shuō)明SNVARCHAR2(20)NPK流水號(hào)YYYYMMDD+帳務(wù)流水〔每天1〕Cust_IdVARCHAR2(20)N客戶編號(hào)冗余SubAccount_TypeVarchar2(4)N子賬戶號(hào)類型冗余Cust_NameVARCHAR2(100)N用戶名Freeze_Cash_AmountNUMBER(15,2)N可提現(xiàn)凍結(jié)發(fā)生額Freeze_UnCash_AmountNUMBER(15,2)N不可提現(xiàn)凍結(jié)發(fā)生額Change_TypeChar(2)N類型02支付03提現(xiàn)OrgSnVARCHAR2(20)Y原交易流號(hào)冗余Org_BatchidVARCHAR2(20)Y原批次號(hào)Create_TimeDATEN創(chuàng)立時(shí)間StateVarchar(2)N狀態(tài)00凍結(jié)01解凍NoteVARCHAR2(100)Y備注WORKDATEVARCHAR2(8)N會(huì)計(jì)日期與會(huì)計(jì)憑證進(jìn)展核算的日期交易充值交易流水RechargeBILL字段名類型是否為空是否主鍵中文說(shuō)明SNVARCHAR2(20)NPK交易流水YYYYMMDD+交易流水〔每天1〕Cust_IdVARCHAR2(20)N客戶編號(hào)SubAccount_typeVarchar2(4)N子賬戶號(hào)類型Cust_NameVARCHAR2(100)N用戶名RechargeTypeCHAR(1)N充值類型1匯款、2網(wǎng)銀、3賬戶驗(yàn)證Bank_TypeVARCHAR2(7)Y行別Bank_CodeVARCHAR2(12)Y行號(hào)支付系統(tǒng)行號(hào)Bank_NameVARCHAR2(128)Y開戶行行名BankAddrNoVARCHAR2(4)Y開戶行地區(qū)代碼BankCardNoVARCHAR2(32)Y賬號(hào)BankCardNameVARCHAR2(100)N戶名AmountNUMBER(15,2)Y金額NoteVARCHAR2(100)Y備注Bank_ResultCodeVARCHAR2(10)Y銀行返回碼Bank_ResultNoteVARCHAR2(100)Y銀行備注ResultCodeVARCHAR2(4)Y返回碼給客戶展現(xiàn)ResultNoteVARCHAR2(100)Y返回說(shuō)明給客戶展現(xiàn)Create_TimeDATEN創(chuàng)立時(shí)間Bank_TimeDATEY銀行回執(zhí)更新時(shí)間StateVARCHAR2(2)Y狀態(tài)00待充值01充值中02成功03失敗Channel_IdVARCHAR2(10)Y渠道編號(hào)MonitorBatchIdVARCHAR2(20)Y監(jiān)管批次Check_StateVARCHAR2(2)N對(duì)賬狀態(tài)00未對(duì)賬01對(duì)帳中02已對(duì)賬成功03對(duì)帳失敗WORKDATEVARCHAR2(8)N結(jié)算會(huì)計(jì)日期SettleDateVarchar2(8)Y結(jié)算日期外部系統(tǒng)提供，供外部系統(tǒng)對(duì)賬用CheckDateVarchar2(8)Y渠道結(jié)算日起與渠道對(duì)賬時(shí)使用充值不收手續(xù)費(fèi)。提現(xiàn)交易流水WithDrawBILL字段名類型是否為空是否主鍵中文說(shuō)明SNVARCHAR2(20)NPK交易流水YYYYMMDD+交易流水〔每天1〕Cust_IdVARCHAR2(20)N客戶編號(hào)SubAccount_typeVarchar2(4)N子賬戶號(hào)類型Bank_TypeVARCHAR2(7)N行別Bank_CodeVARCHAR2(12)Y行號(hào)支付系統(tǒng)行號(hào)Bank_NameVARCHAR2(128)Y開戶行行名BankAddrNoVARCHAR2(4)Y開戶行地區(qū)代碼BankCardNoVARCHAR2(32)N銀行卡號(hào)BankCardNameVARCHAR2(100)N戶名FreezeSNVARCHAR2(20)Y帳務(wù)凍結(jié)變動(dòng)流水AmountNUMBER(15,2)N金額WithDrawTypeCHAR(1)提現(xiàn)類型1-實(shí)時(shí)提現(xiàn)2-非實(shí)時(shí)提現(xiàn)Create_TimeDATEN創(chuàng)立時(shí)間WORKDATEVARCHAR2(8)Y會(huì)計(jì)日期StateVARCHAR2(2)N狀態(tài)00提現(xiàn)申請(qǐng)登記〔基金監(jiān)管時(shí)用〕01登記成功02登記失敗〔基金監(jiān)管時(shí)用〕03支付中〔已生成提現(xiàn)流水〕04提現(xiàn)成功05提現(xiàn)失敗Channel_IdVARCHAR2(10)Y渠道編號(hào)MonitorBatchIdVARCHAR2(20)Y監(jiān)管批次FeeNUMBER(15,2)Y手續(xù)費(fèi)事前收的手續(xù)費(fèi)Fee_Cust_IdVARCHAR2(20)Y付手續(xù)費(fèi)方Fee_StateVARCHAR2(2)N手續(xù)費(fèi)狀態(tài)00事前未統(tǒng)計(jì)01事前已統(tǒng)計(jì)Bank_ResultCodeVARCHAR2(10)Y銀行返回碼Bank_ResultNoteVARCHAR2(100)Y銀行備注Net_NoVarchar2(10)Y支付場(chǎng)次統(tǒng)計(jì)時(shí)回填Pay_StateVarchar2(2)N支付狀態(tài)登記成功時(shí)必須填寫。00未向渠道發(fā)起01已生成支付報(bào)表待人工查看02向渠道發(fā)起03支付完成SettleDateVarchar2(8)Y結(jié)算日期外部系統(tǒng)提供，供外部系統(tǒng)對(duì)賬用CheckDateVarchar2(8)Y渠道結(jié)算日起與渠道對(duì)賬時(shí)使用支付交易流水PayBILL字段名類型是否為空是否主鍵中文說(shuō)明SNVARCHAR2(20)NPK交易流水YYYYMMDD+交易流水〔每天1〕SrcCust_IdVARCHAR2(20)N發(fā)起方客戶編號(hào)業(yè)務(wù)發(fā)起者SubAccount_typeVarchar2(4)N子賬戶類型Payer_IfKftCustCHAR(1)N付款方是否平臺(tái)客戶PayerCust_IdVARCHAR2(20)Y付款方客戶編號(hào)付款方PayerCust_NameVARCHAR2(100)Y付款方戶名PayerBank_TypeVARCHAR2(7)Y付款方開戶行行別PayerBank_CodeVARCHAR2(12)Y行號(hào)支付系統(tǒng)行號(hào)PayerBankNameVARCHAR2(128)Y付款方開戶行行名PayerBankAddrNoVARCHAR2(4)Y付款方開戶行地區(qū)代碼PayerBankCardNoVARCHAR2(32)Y付款方帳號(hào)PayerBankCardNameVARCHAR2(100)Y付款方帳號(hào)戶名Tran_TypeVARCHAR2(4)N交易類型8310帳戶驗(yàn)證〔打款驗(yàn)證，報(bào)文驗(yàn)證〕卡通協(xié)議簽訂8301充值〔網(wǎng)銀充值、卡通充值〕1301即時(shí)到帳支付〔網(wǎng)銀支付、卡通支付、平臺(tái)帳戶支付〕1302擔(dān)保交易支付〔網(wǎng)銀支付、卡通支付、平臺(tái)帳戶支付〕1303擔(dān)保交易支付確認(rèn)〔收款人確認(rèn)、付款人確認(rèn)〕8022擔(dān)保交易退款申請(qǐng)8023擔(dān)保交易退款確認(rèn)1001實(shí)時(shí)代扣2001批量代扣1002實(shí)時(shí)代付2003批量代付8304實(shí)時(shí)提現(xiàn)8303普通提現(xiàn)8021直接退款FeeTypeVARCHAR2(10)Y費(fèi)用類型代碼代收付的費(fèi)用代碼Channel_PayFlagCHAR(1)N是否渠道金額支付Y/NChannel_AmountNUMBER(15,2)Y渠道應(yīng)扣金額Channel_FeeNUMBER(15,2)Y渠道手續(xù)費(fèi)從銀聯(lián)渠道扣款100元只入賬99，1元是手續(xù)費(fèi)Channel_Actual_AmountNUMBER(15,2)Y渠道實(shí)扣金額Cash_AmountNUMBER(15,2)N可提現(xiàn)金額Uncash_AmountNUMBER(15,2)N不可提現(xiàn)金額FreezeSNVARCHAR2(20)Y帳務(wù)凍結(jié)變動(dòng)流水FeeFreezeSNVARCHAR2(20)Y實(shí)時(shí)手續(xù)費(fèi)帳務(wù)凍結(jié)變動(dòng)流水OrderIDVARCHAR2(32)Y訂單號(hào)轉(zhuǎn)帳交易無(wú)；打款賬戶驗(yàn)證時(shí)為賬戶驗(yàn)證流水的IDOrderNoteVARCHAR2(500)Y訂單說(shuō)明轉(zhuǎn)帳交易無(wú)Payee_IfKftCustCHAR(1)N收款方是否是平臺(tái)客戶PayeeAccountTypeCHAR(1)N收款方賬戶類型0平臺(tái)內(nèi)虛戶1平臺(tái)內(nèi)實(shí)戶2平臺(tái)外實(shí)戶PayeeCust_IdVARCHAR2(20)Y收款方客戶號(hào)平臺(tái)內(nèi)客戶才有PayeeCust_NameVARCHAR2(100)N收款方平臺(tái)戶名PayeeBank_TypeVARCHAR2(7)Y收款方開戶行行別平臺(tái)外與平臺(tái)內(nèi)實(shí)戶交易才有PayeeBank_CodeVARCHAR2(12)Y行號(hào)支付系統(tǒng)行號(hào)PayeeBankNameVARCHAR2(128)Y收款方開戶行行名PayeeBankAddrNoVARCHAR2(4)Y收款方開戶行地區(qū)代碼PayeeBankCardNoVARCHAR2(32)Y收款方帳號(hào)平臺(tái)外與平臺(tái)內(nèi)實(shí)戶交易才有PayeeBankCardNameVARCHAR2(100)Y收款方帳號(hào)戶名Create_TimeDATEN創(chuàng)立時(shí)間E*pire_TimeDATEN未支付失效時(shí)間ResultCodeVARCHAR2(4)Y返回碼ResultNoteVARCHAR2(100)Y快付通說(shuō)明Guarantee_StateVARCHAR2(2)Y擔(dān)保交易狀態(tài)擔(dān)保中待收款方確認(rèn)待付款方確認(rèn)03擔(dān)保成功04退款已申請(qǐng)。待收款人確認(rèn)。StateVARCHAR2(2)N交易狀態(tài)10未支付(訂單保存未支付)00待支付〔已調(diào)用渠道接口〕01支付中〔已調(diào)用渠道〕02支付成功03支付失敗Net_NoVarchar2(10)Y支付場(chǎng)次統(tǒng)計(jì)時(shí)回填Pay_StateVarchar2(2)Y支付狀態(tài)待支付與待退款時(shí)必須填寫。00未向渠道發(fā)起01已生成支付報(bào)表待人工查看02向渠道發(fā)起03支付完成BatchIDVARCHAR2(16)YUK批次號(hào)系統(tǒng)自動(dòng)生成的SrcBatchIDVARCHAR2(16)N發(fā)起方批次號(hào)批量業(yè)務(wù)才有DetailIDVARCHAR2(8)Y批量業(yè)務(wù)明細(xì)序號(hào)批量業(yè)務(wù)才有Balance_StateChar(1)N記帳戶變動(dòng)狀態(tài)0未登記帳戶變動(dòng)1已登記帳戶變動(dòng)Channel_IdVARCHAR2(10)Y渠道編號(hào)Bank_ResultCodeVARCHAR2(10)Y銀行返回碼Bank_ResultNoteVARCHAR2(100)Y銀行備注Bank_TimeDATEY銀行回執(zhí)更新時(shí)間WORKDATEVARCHAR2(8)Y會(huì)計(jì)日期登記帳戶變動(dòng)的日期FeeNUMBER(15,2)Y手續(xù)費(fèi)事前收的手續(xù)費(fèi)Fee_Cust_IdVARCHAR2(20)Y付手續(xù)費(fèi)方Fee_StateVARCHAR2(2)N手續(xù)費(fèi)狀態(tài)00事前未統(tǒng)計(jì)/01事前已統(tǒng)計(jì)10事后未計(jì)算/11事后已計(jì)算Undo_StateVARCHAR2(2)N撤銷狀態(tài)00未撤銷01申請(qǐng)撤銷02已被撤銷Check_StateVARCHAR2(2)N對(duì)賬狀態(tài)00未對(duì)賬01對(duì)帳中02已對(duì)賬成功03對(duì)帳失敗SettleDateVarchar2(8)Y結(jié)算日期外部系統(tǒng)提供，供外部系統(tǒng)對(duì)賬用CheckDateVarchar2(8)Y渠道結(jié)算日起與渠道對(duì)賬時(shí)使用PgUrlVARCHAR2(200)YBgUrlVARCHAR2(200)YtranAmountNUMBER(15,2)Y交易金額支付交易成功的時(shí)候，必須檢查Undo_State，如果是01，則必須進(jìn)展相應(yīng)的修改。批量代收付交易信息表〔BatchInfo〕字段名類型是否為空是否主鍵中文說(shuō)明BatchIDVARCHAR2(16)NPK內(nèi)部批次號(hào)SrcBatchIDVARCHAR2(16)NUK發(fā)起方批次號(hào)SrcCust_IDVARCHAR2(20)NUK發(fā)起方客戶號(hào)Tran_TypeVARCHAR2(4)N交易類型2001批量代扣2003批量代付Cust_IDVARCHAR2(20)N收/付款方客戶號(hào)Cust_NameVARCHAR2(100)N收/付款方客戶名SubAccount_typeVarchar2(4)N收/付款方子賬戶類型FeeTypeVARCHAR2(10)N費(fèi)用代碼Shop_TimeDateN商戶時(shí)間戳TotalNumNUMBER(8)N總筆數(shù)TotalAmountNUMBER(15,2)N總金額SucessNumNUMBER(8)Y成功總筆數(shù)SucessAmountNUMBER(15,2)Y成功總金額FailNumNUMBER(8)Y失敗總筆數(shù)FailAmountNUMBER(15,2)Y失敗總金額Create_TimeDateY接收時(shí)間StateVARCHAR2(2)N狀態(tài)01-待審核02-審核通過(guò)〔人工、自動(dòng)〕03-審核不通過(guò)04-處理中05-業(yè)務(wù)已處理Net_NoVarchar2(10)Y支付場(chǎng)次Pay_StateVarchar2(2)N支付狀態(tài)00未向渠道發(fā)起01已生成支付報(bào)表待人工查看02向渠道發(fā)起03支付完成LAST_UPDATE_TIMEDateY回執(zhí)更新時(shí)間FreezeSNVARCHAR2(20)Y帳務(wù)凍結(jié)變動(dòng)流水FreezeCash_AmountNUMBER(15,2)Y可用的凍結(jié)可提現(xiàn)金額FreezeUncash_AmountNUMBER(15,2)Y可用的凍結(jié)不可提現(xiàn)金額撤銷交易流水UndoPayBILL對(duì)方商戶號(hào)。支付交易類型字段名類型是否為空是否主鍵中文說(shuō)明SNVARCHAR2(20)NPK交易流水YYYYMMDD+交易流水〔每天1〕ORG_Tran_TypeVARCHAR2(4)N交易類型OrgPayerCust_IdVARCHAR2(20)N客戶編號(hào)OrgSubAccount_typeVarchar2(4)N子賬戶號(hào)類型OrgPaySNVarchar2(20)N原支付流水查找原交易后后臺(tái)填寫PayerBank_TypeVARCHAR2(7)Y付款方開戶行行別PayerBank_CodeVARCHAR2(12)Y行號(hào)支付系統(tǒng)行號(hào)PayerBankNameVARCHAR2(128)Y付款方開戶行行名PayerBankAddrNoVARCHAR2(4)Y付款方開戶行地區(qū)代碼PayerBankCardNoVARCHAR2(32)Y付款方帳號(hào)PayerBankCardNameVARCHAR2(100)Y付款方帳號(hào)戶名Channel_AmountNUMBER(15,2)Y原交易金額不能與可提現(xiàn)金額、不可提現(xiàn)金額共存OrgCash_AmountNUMBER(15,2)Y可提現(xiàn)金額OrgUncash_AmountNUMBER(15,2)Y不可提現(xiàn)金額OrgOrderIDVARCHAR2(32)N原訂單號(hào)OrgPayeeCust_IdVARCHAR2(20)N原對(duì)方客戶號(hào)OrgPayeeCust_NameVARCHAR2(100)N原對(duì)方戶名StateVARCHAR2(2)N狀態(tài)00原交易不確定，正撤銷01撤銷成功02撤銷失敗Create_TimeDATEN創(chuàng)立時(shí)間WORKDATEVARCHAR2(8)N會(huì)計(jì)結(jié)算日期NoteVARCHAR2(100)Y備注feeNUMBER(15,2)Y手續(xù)費(fèi)Fee_Cust_IdVARCHAR2(20)Y付手續(xù)費(fèi)方Fee_StateVARCHAR2(2)N手續(xù)費(fèi)狀態(tài)00事前未統(tǒng)計(jì)/01事前已統(tǒng)計(jì)10事后未計(jì)算/11事后已計(jì)算退款交易流水RefundBill字段名類型是否為空是否主鍵中文說(shuō)明SNVARCHAR2(20)NPK退款流水RefundSNVARCHAR2(20)Y外部系統(tǒng)生成PaySNVARCHAR2(20)N原支付流水ORG_Tran_TypeVARCHAR2(4)N交易類型網(wǎng)銀支付需手工處理。Refund_TypeVARCHAR2(4)N退款類型1直接退款2擔(dān)保支付退款OrgSrcCust_IdVarchar2(20)N原發(fā)起客戶號(hào)OrderIdVarhar2(32)N訂單號(hào)OrderNoteVARCHAR2(500)O訂單說(shuō)明OrgPayeeCust_IdVarchar2(20)N原收款方客戶號(hào)OrgPayerCust_IdVarchar2(20)Y原付款方客戶號(hào)直接退款可為空；擔(dān)保支付退款必須是客戶發(fā)起，此處不能為空PayerBank_TypeVARCHAR2(7)Y付款方開戶行行別PayerBank_CodeVARCHAR2(12)Y行號(hào)支付系統(tǒng)行號(hào)PayerBankNameVARCHAR2(128)Y付款方開戶行行名PayerBankAddrNoVARCHAR2(4)Y付款方開戶行地區(qū)代碼PayerBankCardNoVARCHAR2(32)Y付款方帳號(hào)PayerBankCardNameVARCHAR2(100)Y付款方帳號(hào)戶名Channel_AmountNUMBER(15,2)Y渠道金額與可提現(xiàn)、不可提現(xiàn)金額不能共存。Cash_AmountNUMBER(15,2)Y可提現(xiàn)金額優(yōu)先退Uncash_AmountNUMBER(15,2)Y不可提現(xiàn)金額StateChar(2)N狀態(tài)00-退款申請(qǐng)01-退款拒絕02-退款處理中03-退款成功04-退款失敗OrgPayerRemarkVarchar2(100)Y原付款方退款理由OrgPayeeRemarkVarchar2(100)Y收款方退款說(shuō)明ProRemrakVarchar2(100)Y退款說(shuō)明Create_TimeDATEN創(chuàng)立時(shí)間WORKDATEVARCHAR2(8)N會(huì)計(jì)結(jié)算日期feeNUMBER(15,2)Y手續(xù)費(fèi)Fee_Cust_IdVARCHAR2(20)Y付手續(xù)費(fèi)方Fee_StateVARCHAR2(2)N手續(xù)費(fèi)狀態(tài)00事前未統(tǒng)計(jì)/01事前已統(tǒng)計(jì)10事后未計(jì)算/11事后已計(jì)算匯款交易流水WaitingRechargeBILL字段名類型是否為空是否主鍵中文說(shuō)明SNVarchar2(20)NPK流水BankSNVARCHAR2(20)N銀行流水Bank_TypeVARCHAR2(7)N行別BankCardNoVARCHAR2(32)N銀行卡號(hào)BankCardNameVARCHAR2(100)N戶名Cust_IdVARCHAR2(20)Y客戶編號(hào)AmountNUMBER(15,2)N匯款金額StateVARCHAR2(2)N狀態(tài)00未指派/10已指派20-待退款21-已登記退款30-已退款Create_TimeDATEN創(chuàng)立時(shí)間Assign_TimeDATEY指派時(shí)間Apply_Refund_TimeDATEY申請(qǐng)退款時(shí)間Refund_TimeDATEY退款時(shí)間Refund_NoteVARCHAR2(100)Y退款原因Refund_OperatorVARCHAR2(20)Y操作員ID執(zhí)行退款操作的操作員內(nèi)部調(diào)賬交易流水AdjustBiLL字段名類型是否為空是否主鍵說(shuō)明SNVARCHAR2(20)NPK管理平臺(tái)流水Cust_IDVARCHAR2(20)N客戶號(hào)SubAccount_typeVarchar2(4)N子賬戶號(hào)類型Cust_NameVARCHAR2(100)N用戶名Amount_TypeChar(1)N資金屬性1－可提現(xiàn)2－不可提現(xiàn)3－可提凍結(jié)4-不可提凍結(jié)AmountNumber(15,2)N金額〔正，負(fù)〕Adjust_TypeChar(1)N調(diào)賬類型1：基金公司贖回充值2：其他Create_TimeDateN操作時(shí)間Oper_UserVARCHAR2(20)N操作人Check_UserVARCHAR2(20)Y審核人Check_TimeDateY審核時(shí)間StateVARCHAR2(2)N狀態(tài)：01－待審核02－審核通過(guò)03－審核不通過(guò)NoteVARCHAR2(100)Y附言外部系統(tǒng)交易通知SHOP_NOTIFY段名類型是否為空是否主鍵中文說(shuō)明cmdIDNumber(12)NPK流水號(hào)Command_CodeVARCHAR2(8)N命令代碼(交易類型)根據(jù)此確定查詢的表1010Cust_IdVARCHAR2(20)N客戶號(hào)Cust_NameVARCHAR2(100)N用戶名ComPara1VARCHAR2(200)Y通訊參數(shù)1ComPara2VARCHAR2(200)Y通訊參數(shù)2GROUPNOVARCHAR2(20)Y組號(hào)SNVARCHAR2(20)N交易流水根據(jù)此確定查詢的數(shù)據(jù)Data_PARA1Number(12)Y數(shù)據(jù)參數(shù)1Data_PARA2VARCHAR2(100)Y數(shù)據(jù)參數(shù)2Create_TimeDATEN創(chuàng)立時(shí)間StateVARCHAR2(2)N狀態(tài)00未發(fā)送01已調(diào)用發(fā)送進(jìn)程02調(diào)用失敗03發(fā)送失敗04發(fā)送成功，接收超時(shí)〔接收失敗〕05發(fā)送成功,接收成功NoteVARCHAR2(100)Y備注失敗原因會(huì)計(jì)帳務(wù)科目日記賬表(SUBJECT_DAY)字段名類型是否為空是否主鍵中文說(shuō)明WORKDATEVARCHAR2(8)NPK會(huì)計(jì)日期SUBJECTCODEVARCHAR2(9)NPK科目代碼AMOUNT_JNUMBER(15,2)N昨日余額〔借〕AMOUNT_DNUMBER(15,2)N昨日余額〔貸〕NETAMOUNT_JNUMBER(15,2)N本日發(fā)生額〔借〕NETAMOUNT_DNUMBER(15,2)N本日發(fā)生額〔貸〕ZYVARCHAR2(60)Y摘要〔關(guān)聯(lián)商戶〕試算平衡表〔Balance_Check〕字段名類型是否為空是否主鍵中文說(shuō)明WORKDATEVARCHAR2(8)NPK會(huì)計(jì)日期SUBJECTCODEVARCHAR2(9)NPK科目代碼Subject_AmountNUMBER(15,2)N科目資金發(fā)生額科目的貸方金額減去借方金額SubAccountSeq_AmountNUMBER(15,2)N子賬戶變動(dòng)流水發(fā)生額Balance_StateChar(2)N比較結(jié)果未比較平衡不平衡科目類型表(SUBJECTTYPE)字段名類型是否為空是否主鍵中文說(shuō)明SUBJECTCODEVARCHAR2(9)NPK科目代碼SUBJECTNAMEVARCHAR2(60)N科目名稱憑證類型表(PZTYPE)字段名類型是否為空是否主鍵中文說(shuō)明PZCODEVARCHAR2(9)NPK憑證類型代碼PZNAMEVARCHAR2(60)N憑證類型名稱REFTABLEVARCHAR2(60)Y關(guān)聯(lián)表內(nèi)部使用，記住關(guān)聯(lián)哪個(gè)表REFFIELDVARCHAR2(60)Y關(guān)聯(lián)字段內(nèi)部使用，記住關(guān)聯(lián)字段憑證科目對(duì)應(yīng)表(PZSUBJECT)字段名類型是否為空是否主鍵中文說(shuō)明PZCODEVARCHAR2(9)NPK憑證代碼同pztype.pzcodeSUBJECTCODE_JVARCHAR2(9)N記借方的科目不是借方科目。SUBJECTCODE_DVARCHAR2(9)N記貸方的科目不是貸方科目。貸方科目記貸，或者借方科目記借NOTEVARCHAR2(60)Y備注如果兩個(gè)科目，一增一減，都是虛戶資金科目。分別記借方貸方。有沒有操作*個(gè)憑證，是兩個(gè)借方科目都增加的？沒有。或者說(shuō)，沒有兩個(gè)借方科目的借都增加的，兩個(gè)借方科目可以一增一減。或者借方科目增，貸方科目增?？颇棵骷?xì)表(SUBJECT)字段名類型是否為空是否主鍵中文說(shuō)明SNVARCHAR2(16)NPKID主鍵YYYYMMDD+科目流水〔每天1〕WORKDATEVARCHAR2(8)N結(jié)算日期SUBJECTCODEVARCHAR2(9)N科目代碼NETAMOUNT_JNUMBER(15,2)N發(fā)生額〔借〕NETAMOUNT_DNUMBER(15,2)N發(fā)生額〔貸〕PZIDVARCHAR2(16)N憑證ID關(guān)聯(lián)憑證ZYVARCHAR2(60)Y摘要Create_TimeDATEN創(chuàng)立時(shí)間憑證明細(xì)表(PZ)字段名類型是否為空是否主鍵中文說(shuō)明SNVARCHAR2(20)NPKID主鍵YYYYMMDD+憑證流水〔每天1〕WORKDATEVARCHAR2(8)N結(jié)算日期PZCODEVARCHAR2(9)N憑證代碼AMOUNTNUMBER(15,2)N發(fā)生額REFIDVARCHAR2(20)Y業(yè)務(wù)ID關(guān)聯(lián)交易流水ZYVARCHAR2(60)Y摘要Create_TimeDATEN創(chuàng)立時(shí)間每種具體的業(yè)務(wù)，只操作憑證表，并設(shè)置業(yè)務(wù)關(guān)聯(lián)。然后自動(dòng)登記2個(gè)科目，2個(gè)金額到科目明細(xì)表。日終，匯總科目明細(xì)表到到科目日記賬表。銀行存款快付通虛擬戶監(jiān)管資金系統(tǒng)參數(shù)序列CODENAMEVALUE說(shuō)明子賬戶凍結(jié)注銷1客戶賬戶流水1每日從1開場(chǎng)交易流水1充值/提現(xiàn)/支付/撤銷/賬戶驗(yàn)證/內(nèi)部調(diào)賬流水憑證流水1科目流水8位年月日＋12位流水＝20位業(yè)務(wù)流水。渠道是否需要定義渠道批次。也就是批量業(yè)務(wù)一個(gè)商戶批次，分成幾個(gè)渠道批次發(fā)送。渠道清算指令〔Channel_Settle_Cmd〕字段名類型是否為空是否主鍵中文說(shuō)明Net_NoVarchar2(10)NPK支付場(chǎng)次TypeCodeCHAR(2)NPK清算類型代碼批量代扣批量代付ChannelIdVARCHAR2(16)NPK渠道IDWorkDateVarchar2(8)N所屬日期InputTimeDATEN寫入時(shí)間StateCHAR(2)N狀態(tài)待處理處理中處理成功處理失敗RemarkVARCHAR(100)Y處理描述DealTimeDATEN處理時(shí)間由管理平臺(tái)向該表寫入清算指令，渠道輪訓(xùn)該指令表渠道參數(shù)〔Channel_Parm〕字段名類型是否為空是否主鍵中文說(shuō)明ChannelIdVARCHAR2(16)NPK渠道IDCodeVARCHAR2(6)NPK系統(tǒng)參數(shù)代碼ParnameVARCHAR2(100)N系統(tǒng)參數(shù)名稱ParvalueVARCHAR2(100)N系統(tǒng)參數(shù)值IfmodifyCHAR(1)Y是否可修改〔YN〕UsercodeVARCHAR2(20)Y更新人代碼UpdatetimeDATEY更新日期時(shí)間(自動(dòng)產(chǎn)生，當(dāng)前系統(tǒng)日期時(shí)間)RemarkVARCHAR(60)Y參數(shù)描述渠道返回碼對(duì)照表〔Channel_RtnCode〕字段名類型是否為空是否主鍵中文說(shuō)明Channe