5d.397. Account Details (OCI360_ACCOUNTDETAILS)

#	ID	P	STATUS	P	SOFTLIMIT	BILLINGTYPE	HARDLIMITALL	HARDLIMITNEW	CANONICALLINK	ENTITLEMENTID	CLOUDBUC	OVERAGES	SUBSCRIPTIONTYPE	SUBSCRIPTIONCATE
1	165377233882	N	ACTIVE	N	0	METERED	0	0	http://10.51.8.10:80/metering/api/v1/cloudbucks/cacct-9ccd1cb666124b95874676cfdd997c36/632514472	632514472		false	PRODUCTION	SRVC_ENTITLEMENT
2	165377635722	Y	ACTIVE	Y	0	COMMITMENT	0	0	http://10.51.8.10:80/metering/api/v1/cloudbucks/cacct-9ccd1cb666124b95874676cfdd997c36/7732965	7732965	CLOUDCM	true	PRODUCTION	CLOUD_CREDIT
#: click on a column heading to sort on it
 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 ID                                                                                           VARCHAR2(16)
 PAYG                                                                                         VARCHAR2(1)
 STATUS                                                                                       VARCHAR2(8)
 PROMOTION                                                                                    VARCHAR2(1)
 SOFTLIMIT                                                                                    NUMBER
 BILLINGTYPE                                                                                  VARCHAR2(16)
 SERVICETYPE                                                                                  VARCHAR2(4)
 HARDLIMITALL                                                                                 NUMBER
 HARDLIMITNEW                                                                                 NUMBER
 CANONICALLINK                                                                                VARCHAR2(128)
 ENTITLEMENTID                                                                                VARCHAR2(16)
 CLOUDBUCKSTYPE                                                                               VARCHAR2(8)
 OVERAGESALLOWED                                                                              VARCHAR2(8)
 SUBSCRIPTIONTYPE                                                                             VARCHAR2(16)
 SUBSCRIPTIONCATEGORY                                                                         VARCHAR2(16)
 BALANCE$ID                                                                                   VARCHAR2(16)
 BALANCE$CREATEDON                                                                            VARCHAR2(32)
 BALANCE$PURCHASEDRESOURCES$NAME                                                              VARCHAR2(32)
 BALANCE$PURCHASEDRESOURCES$UNIT                                                              VARCHAR2(4)
 BALANCE$PURCHASEDRESOURCES$VALUE                                                             NUMBER
 BALANCE$PURCHASEDRESOURCES$DERIVED                                                           VARCHAR2(1)
 BALANCE$PURCHASEDRESOURCES$CREATEDON                                                         VARCHAR2(32)
 BALANCE$PURCHASEDRESOURCES$MODIFIEDON                                                        VARCHAR2(32)
 PURCHASE$ID                                                                                  VARCHAR2(16)
 PURCHASE$CREATEDON                                                                           VARCHAR2(32)
 PURCHASE$SOFTLIMIT                                                                           NUMBER
 PURCHASE$HARDLIMITALL                                                                        NUMBER
 PURCHASE$HARDLIMITNEW                                                                        NUMBER
 PURCHASE$OVERAGESALLOWED                                                                     VARCHAR2(8)
 PURCHASE$PURCHASEDRESOURCES$NAME                                                             VARCHAR2(64)
 PURCHASE$PURCHASEDRESOURCES$UNIT                                                             VARCHAR2(4)
 PURCHASE$PURCHASEDRESOURCES$VALUE                                                            NUMBER
 PURCHASE$PURCHASEDRESOURCES$DERIVED                                                          VARCHAR2(1)
 PURCHASE$PURCHASEDRESOURCES$ENDDATE                                                          VARCHAR2(32)
 PURCHASE$PURCHASEDRESOURCES$CREATEDON                                                        VARCHAR2(32)
 PURCHASE$PURCHASEDRESOURCES$STARTDATE                                                        VARCHAR2(32)
 PURCHASE$PURCHASEDRESOURCES$DISPLAYNAME                                                      VARCHAR2(64)
 PURCHASE$PURCHASEDRESOURCES$SERVICENAME                                                      VARCHAR2(4)
 RUNNINGBALANCE$ID                                                                            VARCHAR2(16)
 RUNNINGBALANCE$CREATEDON                                                                     VARCHAR2(32)
 RUNNINGBALANCE$PURCHASEDRESOURCES$NAME                                                       VARCHAR2(32)
 RUNNINGBALANCE$PURCHASEDRESOURCES$UNIT                                                       VARCHAR2(4)
 RUNNINGBALANCE$PURCHASEDRESOURCES$VALUE                                                      NUMBER
 RUNNINGBALANCE$PURCHASEDRESOURCES$DERIVED                                                    VARCHAR2(1)
 RUNNINGBALANCE$PURCHASEDRESOURCES$CREATEDON                                                  VARCHAR2(32)
 RUNNINGBALANCE$PURCHASEDRESOURCES$MODIFIEDON                                                 VARCHAR2(32)


SELECT distinct
       ID,
       PAYG,
       STATUS,
       PROMOTION,
       SOFTLIMIT,
       BILLINGTYPE,
       HARDLIMITALL,
       HARDLIMITNEW,
       CANONICALLINK,
       ENTITLEMENTID,
       CLOUDBUCKSTYPE,
       OVERAGESALLOWED,
       SUBSCRIPTIONTYPE,
       SUBSCRIPTIONCATEGORY
FROM   OCI360_ACCOUNTDETAILS t1;


2 rows selected.