hetonghao.txt

电信计费帐务系统话费查询营业厅触摸屏界面

SQL>  desc hrb_tb_subscr_phone
 Name                            Null?    Type
 ------------------------------- -------- ----
 CITY_CDE                        NOT NULL VARCHAR2(4)
 PHONE_NBR                       NOT NULL VARCHAR2(11)
 BUSINESS_TYPE                   NOT NULL VARCHAR2(5)
 BC_ID                           NOT NULL VARCHAR2(4)
 ACCT_NBR                        NOT NULL VARCHAR2(10)
 USER_CATG                       NOT NULL VARCHAR2(5)
 BILLING_TYPE                    NOT NULL VARCHAR2(5)
 BILLING_CNTR                    NOT NULL VARCHAR2(6)
 BUSINESS_NODE                            VARCHAR2(5)
 FRAME_GROUP_NBR                          NUMBER(6)
 FRAME_CATG                               VARCHAR2(5)
 INDIC_NBR                                VARCHAR2(11)
 IN_SVC_DATE                     NOT NULL DATE
 CUST_NBR                        NOT NULL NUMBER(10)
 ADDR_NBR                        NOT NULL NUMBER(10)
 LAST_ENGR_WO_NBR                NOT NULL VARCHAR2(18)
 SVC_STATUS                      NOT NULL VARCHAR2(6)
 OUT_SVC_DATE                             DATE
 OLD_PHONE_NBR                            VARCHAR2(11)
 OLD_ACCT_NBR                             VARCHAR2(10)
 RESETLE_DATE                             DATE
 WORK_LOCK                       NOT NULL VARCHAR2(1)
 TEMP_OFF_DATE                            DATE
 RENT_OFF_DATE                            DATE
 MAINT_TYPE                               VARCHAR2(5)
 CONTACT_NME                              VARCHAR2(20)
 CONTACT_PHONE_NBR                        VARCHAR2(20)
 NEF_PHONE_NBR                            VARCHAR2(11)
 LAST_WO_DATE                    NOT NULL DATE
 BALANCE                                  NUMBER(9,2)
 BAL_MON                                  NUMBER(2)
 DATESTAMP                       NOT NULL DATE
 USERSTAMP                       NOT NULL VARCHAR2(10)
 REMARK                                   VARCHAR2(60)
 NEW_PHONE_NBR                            VARCHAR2(11)
 CNB_PERIOD                               VARCHAR2(8)
 OLD_BUSINESS                             VARCHAR2(5)
 NEW_BUSINESS                             VARCHAR2(5)
 SAME_ADDR                                VARCHAR2(1)
 PHONE_LINE_CATG                          VARCHAR2(5)

SQL>