select * from payment; 付费记录表
TRANS_ID 8
TRANS_TYPE PRE
BATCH_NO 42
CUST_ID 1000020001003
ACCT_ID 4000020001004
SUB_ID 2000020001001
MSISDN 01101110000100
TELE_TYPE 21
CHANNEL_ID 0
AMOUNT 156.00
DISCOUNT_AMT
VAT
STAMP_DUTY
INTEREST
ENTRY_DATE 2009-9-4 2:00:07
RECEIPT_DATE 2009-9-4 2:00:06
RECON_DATE
STATEMENT_DATE
STATUS V
CRDR DR
POST_FLAG N
GLACODE 206110000
VAT_GLACODE
STAMP_DUTY_GLACODE
INT_GLACODE
GL_TRANS_ID 3003
POST_PERIOD
POST_DATE
REVERSE_PP
REVERSE_POST_DATE
REF_NO
BSNO 102
BUSI_TYPE 32001
DEPT_ID 0
OPER_ID 0
MOD_FLAG
MOD_DATE
MICROFICHE_NO
RECEIPT_NO C09090400000002
IS_REFUND
SUPER_OPER_ID
SRC_TRANS_ID
PRINT_DATE
PRINT_TIMES 0
REASON_CODE
REMARK
REMARK2
VERSION 0
select * from payment_detail; 付费明细记录表
TRANS_ID 8
SEQ 1
PAYMENT_METHOD 1001
AMOUNT 156.00
DISCOUNT_AMT 0.00
ASSIGN_AMT 156.00
CURRENCY_ID
CONV_RATE_ID
CONV_RATE
FORCUR_ID
FORCUR_AMT
FORCUR_DISAMT
TAX
INTEREST
BANK_CODE
ACCT_NO
ACCT_NAME
APPROVAL_CODE
IS_INSTALMENT
CHEQUE_DATE
ENTRY_DATE 2009-9-4 2:00:07
CRDR DR
POST_FLAG Y
GLACODE 206531000
TAX_GLACODE
INT_GLACODE
GL_TRANS_ID
POST_PERIOD
POST_DATE
REVERSE_PP
REVERSE_POST_DATE
DEBIT_DATE 2009-9-4 2:00:07
DEBIT_INFO1
DEBIT_INFO2
REF_NO
MICROFICHE_NO
REMARK
REMARK2
REMARK3
VERSION 1
select * from billing.receivables; AR应收表
INVOICE_ID 4035
RECEIVABLE_ID 0
TRANS_TYPE OCC
BATCH_NO 7614
CHANNEL_ID 0
CUST_ID 1000020009003
ACCT_ID 4000020008006
SUB_ID 2000020006007
MSISDN 01101110000122
TELE_TYPE 21
INVOICE_AMT 10.00
OPEN_AMT 0.00
TAX
INTEREST
DISCOUNT_AMT 50.00
AUTO_SETTLE 0
DISCOUNT_DATE 2009-9-8 9:27:39
INVOICE_DATE 2009-9-8 9:27:38
DUE_DATE 2009-9-9 9:27:38
CRDR DR
DDEBIT_FLAG
AR_FLAG 1
INVOICE_TYPE 4
DEPOSIT_TYPE_CODE
IS_CUSTOMER_BILL Y
ENTRY_DATE 2009-9-8 9:27:39
SETTLE_DATE 2009-9-10 21:37:00
POST_FLAG Y
GL_TRANS_ID 6001
GLACODE 206110000
TAX_GLACODE
INT_GLACODE
POST_PERIOD
POST_DATE
PRINT_TIMES 0
REASON_CODE
REF_NO
DEPT_ID 11001
OPER_ID 11001
BSNO 100007055
BUSI_TYPE CB040
STATUS N
REMARK
REMARK2
VERSION 13
BILL_CYCLE_ID
INVOICE_NO 2011
select * from receivables_detail; AR应收明细表
INVOICE_ID 29
SEQ 1
ACCT_ID 4000020001015
SUB_ID 2000020001013
TELE_TYPE 21
TRANS_TYPE OCC
PRODUCT_NAME Business Handling(New Subscriber)
ORDER_QTY 1
BACK_QTY 0
SALES_QTY 1
UNIT_PRICE 156.00
CHARGE 156.00
OTHER_CHARGE 0.00
DISCOUNT_AMT 0.00
GROSS_REVENUE 156.00
PAID_AMT 156.00
CRDR CR
TRANS_DATE 2009-9-4 2:22:48
SALES_DATE 2009-9-4 2:22:48
ENTRY_DATE 2009-9-4 2:23:01
FEE_ITEM_CODE
BILL_CYCLE_ID
TAX_INCLUSIVE N
POST_FLAG Y
GLACODE 201010000
DISCOUNT_GLACODE 201010000
REBATE_GLACODE
REBATE_AMT 0.00
RES_TYPE_ID
RES_MODEL_ID
RES_ID
RES_CODE
RES_AMOUNT 0
GL_TRANS_ID 4002
POST_PERIOD
POST_DATE
REF_NO
REMARK
VERSION 1
FEE_TYPE
PRODUCT_ID
SP_CP_ID
SERVICE_ID
PRM_FLAG
SERVICE_TYPE
SERVICE_CATEGORY
IS_PAID_BEFORE
select * from trans_detail; AR交易表
TRANS_ID 8
PAYMENT_SEQ 1
INVOICE_ID 1
INVOICE_SEQ 1
POST_FLAG Y
GL_TRANS_ID
GLACODE 201010000
POST_PERIOD
POST_DATE
ENTRY_DATE 2009-9-4 2:00:08
AMOUNT 156.00
DEPT_ID 0
OPER_ID 0
STATUS N
REMARK
VERSION 0
TRANS_ID 8
TRANS_TYPE PRE
BATCH_NO 42
CUST_ID 1000020001003
ACCT_ID 4000020001004
SUB_ID 2000020001001
MSISDN 01101110000100
TELE_TYPE 21
CHANNEL_ID 0
AMOUNT 156.00
DISCOUNT_AMT
VAT
STAMP_DUTY
INTEREST
ENTRY_DATE 2009-9-4 2:00:07
RECEIPT_DATE 2009-9-4 2:00:06
RECON_DATE
STATEMENT_DATE
STATUS V
CRDR DR
POST_FLAG N
GLACODE 206110000
VAT_GLACODE
STAMP_DUTY_GLACODE
INT_GLACODE
GL_TRANS_ID 3003
POST_PERIOD
POST_DATE
REVERSE_PP
REVERSE_POST_DATE
REF_NO
BSNO 102
BUSI_TYPE 32001
DEPT_ID 0
OPER_ID 0
MOD_FLAG
MOD_DATE
MICROFICHE_NO
RECEIPT_NO C09090400000002
IS_REFUND
SUPER_OPER_ID
SRC_TRANS_ID
PRINT_DATE
PRINT_TIMES 0
REASON_CODE
REMARK
REMARK2
VERSION 0
select * from payment_detail; 付费明细记录表
TRANS_ID 8
SEQ 1
PAYMENT_METHOD 1001
AMOUNT 156.00
DISCOUNT_AMT 0.00
ASSIGN_AMT 156.00
CURRENCY_ID
CONV_RATE_ID
CONV_RATE
FORCUR_ID
FORCUR_AMT
FORCUR_DISAMT
TAX
INTEREST
BANK_CODE
ACCT_NO
ACCT_NAME
APPROVAL_CODE
IS_INSTALMENT
CHEQUE_DATE
ENTRY_DATE 2009-9-4 2:00:07
CRDR DR
POST_FLAG Y
GLACODE 206531000
TAX_GLACODE
INT_GLACODE
GL_TRANS_ID
POST_PERIOD
POST_DATE
REVERSE_PP
REVERSE_POST_DATE
DEBIT_DATE 2009-9-4 2:00:07
DEBIT_INFO1
DEBIT_INFO2
REF_NO
MICROFICHE_NO
REMARK
REMARK2
REMARK3
VERSION 1
select * from billing.receivables; AR应收表
INVOICE_ID 4035
RECEIVABLE_ID 0
TRANS_TYPE OCC
BATCH_NO 7614
CHANNEL_ID 0
CUST_ID 1000020009003
ACCT_ID 4000020008006
SUB_ID 2000020006007
MSISDN 01101110000122
TELE_TYPE 21
INVOICE_AMT 10.00
OPEN_AMT 0.00
TAX
INTEREST
DISCOUNT_AMT 50.00
AUTO_SETTLE 0
DISCOUNT_DATE 2009-9-8 9:27:39
INVOICE_DATE 2009-9-8 9:27:38
DUE_DATE 2009-9-9 9:27:38
CRDR DR
DDEBIT_FLAG
AR_FLAG 1
INVOICE_TYPE 4
DEPOSIT_TYPE_CODE
IS_CUSTOMER_BILL Y
ENTRY_DATE 2009-9-8 9:27:39
SETTLE_DATE 2009-9-10 21:37:00
POST_FLAG Y
GL_TRANS_ID 6001
GLACODE 206110000
TAX_GLACODE
INT_GLACODE
POST_PERIOD
POST_DATE
PRINT_TIMES 0
REASON_CODE
REF_NO
DEPT_ID 11001
OPER_ID 11001
BSNO 100007055
BUSI_TYPE CB040
STATUS N
REMARK
REMARK2
VERSION 13
BILL_CYCLE_ID
INVOICE_NO 2011
select * from receivables_detail; AR应收明细表
INVOICE_ID 29
SEQ 1
ACCT_ID 4000020001015
SUB_ID 2000020001013
TELE_TYPE 21
TRANS_TYPE OCC
PRODUCT_NAME Business Handling(New Subscriber)
ORDER_QTY 1
BACK_QTY 0
SALES_QTY 1
UNIT_PRICE 156.00
CHARGE 156.00
OTHER_CHARGE 0.00
DISCOUNT_AMT 0.00
GROSS_REVENUE 156.00
PAID_AMT 156.00
CRDR CR
TRANS_DATE 2009-9-4 2:22:48
SALES_DATE 2009-9-4 2:22:48
ENTRY_DATE 2009-9-4 2:23:01
FEE_ITEM_CODE
BILL_CYCLE_ID
TAX_INCLUSIVE N
POST_FLAG Y
GLACODE 201010000
DISCOUNT_GLACODE 201010000
REBATE_GLACODE
REBATE_AMT 0.00
RES_TYPE_ID
RES_MODEL_ID
RES_ID
RES_CODE
RES_AMOUNT 0
GL_TRANS_ID 4002
POST_PERIOD
POST_DATE
REF_NO
REMARK
VERSION 1
FEE_TYPE
PRODUCT_ID
SP_CP_ID
SERVICE_ID
PRM_FLAG
SERVICE_TYPE
SERVICE_CATEGORY
IS_PAID_BEFORE
select * from trans_detail; AR交易表
TRANS_ID 8
PAYMENT_SEQ 1
INVOICE_ID 1
INVOICE_SEQ 1
POST_FLAG Y
GL_TRANS_ID
GLACODE 201010000
POST_PERIOD
POST_DATE
ENTRY_DATE 2009-9-4 2:00:08
AMOUNT 156.00
DEPT_ID 0
OPER_ID 0
STATUS N
REMARK
VERSION 0