5d.398. Account Balance (OCI360_ACCOUNTDETAILS)

#: 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 BALANCE$ID,
       BALANCE$CREATEDON,
       BALANCE$PURCHASEDRESOURCES$NAME,
       BALANCE$PURCHASEDRESOURCES$UNIT,
       BALANCE$PURCHASEDRESOURCES$VALUE,
       BALANCE$PURCHASEDRESOURCES$DERIVED,
       BALANCE$PURCHASEDRESOURCES$CREATEDON,
       BALANCE$PURCHASEDRESOURCES$MODIFIEDON
FROM   OCI360_ACCOUNTDETAILS t1
WHERE  BALANCE$ID is not null;


3 rows selected.