{
    "keyColumn": "st_id",
    "detailHeaderColumnPrefix": "Subscriptions: ",
    "detailHeaderColumns": [
        "st_id"
    ],
    "orderBy": {
        "st_id": "ASC"
    },
    "listColumns": [
        "smb_account_id",
        "plan_id",
        "st_subscription_amount",
        "st_created_on",
        "st_start_date",
        "st_expiry_date"
    ],
    "showColumns": [
        "smb_account_id",
        "plan_id",
        "st_subscription_amount",
        "st_created_on",
        "st_start_date",
        "st_expiry_date"
    ],
    "detailColumns": [
        "smb_account_id",
        "plan_id",
        "st_subscription_amount",
        "st_created_on",
        "st_start_date",
        "st_expiry_date"
    ],
    "columns": {
        "st_id": {
            "name": "ID",
            "sortable": "true",
            "editoptions": {
                "type": "hidden"
            }
        },
        "smb_account_id": {
            "name": "Business Account",
            "sortable": "true",
            "searchable": "true",
            "editoptions": {
                "type": "textbox",
                "label": "Account",
                "class": "textbox",
                "validations": [
                    "required"
                ]
            },
            "external": "true",
            "externalOptions": {
                "externalTable": "tbl_smb_account",
                "externalColumn": "smb_acc_id",
                "externalShowColumn": "smb_name"
            },
			 "popupoptions": {
                "type": "popup",
                "customaction": "Cmshelper::getSmbPopupUrlFromSubs"
            }
        },
        "plan_id": {
            "name": "Plan",
            "sortable": "true",
            "external": "true",
            "externalOptions": {
                "externalTable": "tbl_plans",
                "externalColumn": "plan_id",
                "externalShowColumn": "plan_name"
            }
        },
        "st_subscription_amount": {
            "name": "Amount ($)",
            "sortable": "true",
           "decimalPoint" : "2"
        },
        "st_created_on": {
            "name": "Purchased On",
            "sortable": "true",
            "dbFormat": "datetime",
            "displayFormat": "m/d/Y"
        },
        "st_start_date": {
            "name": "Start Date",
            "sortable": "true",
            "dbFormat": "datetime",
            "displayFormat": "m/d/Y"
        },
        "st_expiry_date": {
            "name": "End Date",
            "sortable": "true",
            "dbFormat": "datetime",
            "displayFormat": "m/d/Y"
        }
    },
    "opertations": [
        "view"
    ],
	"report": {
        "reportTitle": "Subscriptions",
        "columns": [
	        "smb_account_id",
    		"plan_id",
	        "st_subscription_amount",
	        "st_created_on",
	        "st_start_date",
    	    "st_expiry_date"
        ],
        "dateColumn": "st_created_on"
    }
}