INFV_BILLINGPOINTS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ATMID CHARACTER VARYING(7) 7
2 STARTDATE CHARACTER VARYING(11) 11
3 TELSTRAMOBILECONTRACTSTARTDATE CHARACTER VARYING(11) 11
4 ENDDATE CHARACTER VARYING(11) 11
5 MOBILEGLOBALROAMINGACTIVATED CHARACTER VARYING(1) 1
6 BROADBANDPLAN CHARACTER VARYING(100) 100
7 SERVICEDESCRIPTION CHARACTER VARYING(300) 300
8 INSTALLATIONADDRESS CHARACTER VARYING(200) 200
9 BILLINGPOINTCODE CHARACTER VARYING(200) 200
10 BILLINGPOINTTYPE CHARACTER VARYING(200) 200
11 EMPLOYEEID CHARACTER VARYING(200) 200
12 STATUS CHARACTER VARYING(15) 15
13 BILLINGPOINTNAME CHARACTER VARYING(200) 200
14 EXPECTEDMONTHLYCHARGE CHARACTER VARYING(200) 200
15 SERVICENOWNO CHARACTER VARYING(16) 16
16 SERVICEPROVIDER CHARACTER VARYING(200) 200
17 ASSOCIATEDADSLSERVICE CHARACTER VARYING(10) 10
18 ADSLPSTNLINE CHARACTER VARYING(1) 1
19 DATALINEBANDWIDTH CHARACTER VARYING(50) 50
20 MOBILESIMCARDNUMBER CHARACTER VARYING(20) 20
21 IMEI CHARACTER VARYING(15) 15
22 MOBILEIDDACTIVATED CHARACTER VARYING(1) 1
23 DISCONNECTDATE CHARACTER VARYING(11) 11
24 BILLINGPOINTID CHARACTER VARYING(13) 13
25 TELSTRAMOBILECONTRACTENDDATE CHARACTER VARYING(11) 11
26 DATA_DATE TIMESTAMP 8
27 LOAD_ID INTEGER 4
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8