{ "fields": { "phoneNumber": { "notStorable": true, "required": true, "tooltip": true, "tooltipText": "Enter 10 Digit Number without Dashes, Periods or Spaces." }, "name": { "audited": false, "readOnly": false, "tooltip": true, "tooltipText": "Preferably the Company Name" }, "btn": { "type": "varchar", "required": true, "trim": true, "tooltipText": "", "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "maxLength": 12, "isPersonalData": false }, "orderdate": { "notNull": false, "type": "date", "required": true, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true, "default": null }, "datesubmittedtovendor": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "currentprovider": { "type": "text", "required": false, "rows": 4, "lengthOfCut": 400, "tooltipText": "Current Internet or Telecom Provider?", "seeMoreDisabled": false, "readOnly": false, "tooltip": true, "isCustom": true }, "ipaddresses": { "type": "enum", "required": false, "tooltipText": "# of IPs Ordered", "options": [ "", "1", "5", "13", "29", "61", "125" ], "default": "", "isSorted": false, "audited": false, "readOnly": false, "tooltip": true, "isCustom": true }, "staticordynamic": { "type": "enum", "required": false, "options": [ "", "Static", "Dynamic" ], "default": "Dynamic", "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "orderstatus": { "type": "enum", "required": true, "options": [ "Pending", "Hold", "Completed", "Submitted", "Resubmitted", "Dispute", "Duplicate", "Dead", "Expired", "Scheduled", "TTU", "Contract", "Debt", "Deposit", "ONR", "PENDING T&C", "New Order", "Cancelled - Fixable", "Cancelled - Dead", "Rejected - Internal", "Rejected - ATT", "Rejected", "Cancelled", "Pending Additional Documentation", "Pending Construction" ], "default": "New Order", "isSorted": true, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "comppaiddate": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "chargebackdate": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "product": { "type": "enum", "required": true, "options": [ "", "ABF", "ABF/UPGRADE", "ADIVB", "AFL RENEW", "BLC", "CENTREX", "EAMIS", "EAMIS/IPFLEX", "ETHERNET ONLY", "FBB", "FBB/WINBACK", "IP FLEX", "MACD", "MEASURED RATE", "METRO E 20 & 50 MG", "NEW LINE", "NEW LINE/MIFI", "NEW LINE/NEW UVERSE", "NEW LINE/TABLET", "NEW STANDALONE", "NEW UVERSE", "PHONE SYSTEM", "POINT TO POINT", "RENEWAL ONLY", "SPEED UPGRADE", "STATIC IPS", "TOLL FREE", "UVERSE VOICE/NEW UVERSE", "UVERSE VOICE/UPGRADE", "VOICEMAIL", "VOICEMAIL/CALLWAITING", "WINBACK", "WINBACK/ABF", "WINBACK/EAMIS", "WINBACK/UPGRADE", "WINBACK/MIFI", "WINBACK/MIGRATION", "WINBACK/NEW ABF", "WINBACK/NEW DSL", "WINBACK/NEW UVERSE", "WINBACK/NEW UVERSE/DIRECTV", "WINBACK/SPEED UPGRADE", "WINBACK/TABLET", "WINBACK/USB STICK", "FBB/ADI2", "ABF/UVERSE VOICE", "Stand Alone Pricing", "Double or Triple Play Pricing" ], "default": "", "isSorted": true, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "duedate": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "customerName": { "type": "varchar", "required": true, "trim": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "notes": { "type": "text", "required": false, "rows": 10, "lengthOfCut": 800, "seeMoreDisabled": false, "readOnly": false, "tooltip": false, "isCustom": true }, "spiffpaid": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "internetmigration": { "type": "enum", "required": false, "options": [ "", "1.5M", "3.0M", "6.0M", "10M", "12M", "18M", "20M", "24M", "25M", "75M", "100M", "150M", "175M" ], "default": "", "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "mobility": { "type": "enum", "required": false, "options": [ "", "2GB", "4GB", "6GB", "8GB", "10GB", "20GB", "UNLIMITED" ], "default": "", "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "vendornotes": { "type": "text", "required": false, "rows": 10, "lengthOfCut": 800, "seeMoreDisabled": false, "readOnly": false, "tooltip": false, "isCustom": true }, "speedsold": { "type": "enum", "required": false, "default": "", "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "options": [ "", "?" ], "isCustom": true }, "uversedsl": { "type": "enum", "required": false, "options": [ "", "?" ], "default": "", "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "cclines": { "type": "enum", "required": false, "isSorted": false, "audited": false, "readOnly": false, "tooltip": true, "isCustom": true, "options": [ "", "10", "23", "46", "0" ], "tooltipText": "Enter only 10, 23 or 46" }, "mrc": { "type": "currency", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "smartid": { "type": "varchar", "required": false, "trim": true, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "requestid": { "type": "varchar", "required": false, "trim": true, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "contractid": { "type": "varchar", "required": false, "trim": true, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "ordernumber": { "type": "text", "required": false, "rows": 6, "lengthOfCut": 400, "seeMoreDisabled": false, "readOnly": false, "tooltip": false, "isCustom": true }, "rds": { "type": "varchar", "required": false, "trim": true, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "fbbacctnum": { "type": "varchar", "required": false, "trim": true, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "romeid": { "type": "varchar", "required": false, "trim": true, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "duedatetime": { "notNull": false, "type": "datetime", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "salesrep": { "type": "varchar", "required": true, "trim": true, "audited": true, "readOnly": false, "tooltip": true, "isCustom": true, "tooltipText": "Enter the Sales Rep Name\nIf you do not spell this name correctly you may miss out on receiving your commission. You have been warned. " }, "newvoicepotline": { "type": "int", "required": true, "disableFormatting": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "default": null, "min": 0, "max": 99, "isPersonalData": false }, "phonesystem": { "type": "enum", "required": false, "options": [ "", "YES", "NO" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "orderstatusdt": { "notNull": false, "type": "datetime", "required": false, "default": null, "audited": false, "readOnly": true, "tooltip": false, "isCustom": true, "after": "", "tooltipText": "" }, "bannum": { "type": "varchar", "required": false, "trim": true, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "cancelleddate": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "bonotes": { "type": "text", "required": false, "rows": 10, "lengthOfCut": 800, "seeMoreDisabled": false, "readOnly": false, "tooltip": false, "isCustom": true }, "accountParent": { "type": "link" }, "fixedby": { "type": "varchar", "required": false, "trim": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "website": { "required": false, "audited": false, "readOnly": false, "tooltip": false, "maxLength": null, "isPersonalData": false }, "custid": { "type": "int", "required": false, "disableFormatting": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "voicemigrationtovoip": { "type": "int", "required": true, "disableFormatting": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "min": 0, "max": 99, "isPersonalData": false }, "shippingAddress": { "skipOrmDefs": true, "tooltip": false }, "assignedUser": { "required": false, "audited": true, "readOnly": false, "tooltip": false }, "taxid": { "type": "varchar", "required": false, "trim": true, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "urlgensow": { "type": "url", "required": false, "readOnly": true, "audited": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "billingAddressStreet": { "required": true, "seeMoreDisabled": false, "readOnly": false, "tooltip": false }, "billingAddressState": { "required": true, "trim": false, "audited": false, "readOnly": false, "tooltip": false }, "billingAddressCity": { "required": true, "trim": false, "audited": false, "readOnly": false, "tooltip": false }, "billingAddressPostalCode": { "required": true, "trim": false, "audited": false, "readOnly": false, "tooltip": false }, "package": { "type": "enum", "required": false, "options": [ "", "AFL", "AFL Plus", "Other" ], "isSorted": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn1": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": true, "isCustom": true, "tooltipText": "WTN1 can not be same as BTN #" }, "wtn2": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn3": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn4": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn5": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "tpvnum": { "type": "varchar", "required": false, "trim": true, "maxLength": 20, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "hunting": { "type": "text", "required": false, "rows": 4, "lengthOfCut": 400, "seeMoreDisabled": false, "readOnly": false, "tooltip": false, "isCustom": true }, "voicemail": { "type": "text", "required": false, "rows": 4, "lengthOfCut": 400, "seeMoreDisabled": false, "readOnly": false, "tooltip": false, "isCustom": true }, "additionalfeatures": { "type": "text", "required": false, "rows": 4, "lengthOfCut": 400, "seeMoreDisabled": false, "readOnly": false, "tooltip": false, "isCustom": true }, "promo": { "type": "enum", "required": false, "options": [ "", "TEST1", "TEST2" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "longdistance": { "type": "enum", "required": false, "options": [ "", "Unlimited", "BOT" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "internet": { "type": "enum", "required": true, "options": [ "", "Internet Basic", "Internet 12-100", "ABF", "GPON", "Existing", "New", "No" ], "isSorted": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "tollfree": { "type": "enum", "required": false, "options": [ "", "Yes", "No" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "features": { "type": "enum", "required": false, "options": [ "", "Yes", "No" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "boltonapps": { "type": "enum", "required": false, "options": [ "", "Yes", "No" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "voice": { "type": "enum", "required": false, "options": [ "", "VoIP", "POTS", "Existing", "New", "No" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "video": { "type": "enum", "required": false, "options": [ "", "Uverse TV", "DirecTV", "New", "Existing", "No" ], "isSorted": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "voicemail0": { "type": "enum", "required": false, "options": [ "", "Yes", "No" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "mobility0": { "type": "enum", "required": false, "options": [ "", "Yes", "No" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "tollfree0": { "type": "varchar", "required": false, "trim": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "term": { "type": "enum", "required": false, "options": [ "", "24 Mo", "36 Mo" ], "isSorted": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "crspd": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "contractexpdt": { "notNull": false, "type": "date", "required": false, "tooltipText": "Enter the Date of the Customers Expiration for their current contract if any", "audited": false, "readOnly": false, "tooltip": true, "isCustom": true }, "bssa": { "layoutListDisabled": true, "type": "attachmentMultiple", "required": false, "sourceList": [], "tooltip": false, "isCustom": true }, "wtn6": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn7": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn8": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn9": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn10": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn11": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn12": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn13": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn14": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn15": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn16": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn17": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn18": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn19": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wtn20": { "type": "varchar", "required": false, "trim": true, "maxLength": 40, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "client": { "type": "enum", "required": true, "options": [ "AT&T", "COMCAST", "" ], "isSorted": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "default": "", "isPersonalData": false }, "ordernumberi": { "type": "text", "required": false, "rows": 6, "lengthOfCut": 400, "seeMoreDisabled": false, "readOnly": false, "tooltip": false, "isCustom": true }, "orderstatusv": { "type": "enum", "required": false, "options": [ "", "N/A", "Add more options" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "orderstatusi": { "type": "enum", "required": false, "options": [ "", "N/A", "Add more options", "Rescheduled", "Scheduled", "Cancelled - Dead", "Completed" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "comppaiddatei": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "datesubmittedtoc3": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "ccbl": { "type": "int", "required": false, "disableFormatting": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "ccffl": { "type": "int", "required": false, "disableFormatting": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "ccml": { "type": "int", "required": false, "disableFormatting": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "positiontitle": { "type": "enum", "required": true, "options": [ "Owner", "Decision Maker", "Purchaser", "Developer", "Manager", "Administrator", "Engineer", "" ], "isSorted": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "ccinternet": { "type": "enum", "required": false, "options": [ "", "Starter", "Deluxe 25", "Deluxe 50", "Deluxe 75", "Deluxe 100+", "Deluxe 150", "Deluxe 300", "Biz 500", "Biz 1G" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "default": "", "isPersonalData": false }, "ccwifipro": { "type": "enum", "required": false, "options": [ "", "1 Access Point", "2 Access Point", "No" ], "isSorted": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "ccbcvoice": { "type": "multiEnum", "required": false, "options": [ "", "VoiceEdge Select", "Mobility Line", "Full Featured", "Voice Mail", "Basic Line", "Toll Free" ], "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "ccbcvideo": { "type": "enum", "required": false, "options": [ "Public - Basic", "Public - Select", "Public - Variety", "Public - Standard", "Public - Prefered", "N/A", "Private - Basic", "Private - Select", "Private - Variety", "Private - Standard", "Private - Prefered", "" ], "isSorted": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false, "default": "" }, "ccbcvideoadd": { "type": "multiEnum", "required": false, "options": [ "", "HD Box", "Sports Pack", "Music Pack", "Canaies Selecto" ], "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "isPersonalData": false }, "ccmlmrc": { "type": "currency", "required": false, "isPersonalData": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "ccfflmrc": { "type": "currency", "required": false, "isPersonalData": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "ccblmrc": { "type": "currency", "required": false, "isPersonalData": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "ccimrc": { "type": "currency", "required": false, "isPersonalData": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "min": 1 }, "ccvmrc": { "type": "currency", "required": false, "isPersonalData": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "discountvideo": { "type": "currency", "required": false, "isPersonalData": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "discountvoice": { "type": "currency", "required": false, "isPersonalData": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "discountinternet": { "type": "currency", "required": false, "isPersonalData": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "tcc": { "type": "currency", "required": false, "isPersonalData": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "tcrc": { "type": "currency", "required": false, "isPersonalData": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "commission": { "type": "currency", "required": false, "readOnly": true, "isPersonalData": false, "audited": false, "tooltip": false, "isCustom": true }, "phonesystemcommission": { "type": "currency", "required": false, "isPersonalData": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true } }, "collection": { "sortBy": "modifiedAt", "asc": false, "textFilterFields": [ "name", "btn", "notes", "bonotes", "customerName", "ordernumberi", "bannum" ] }, "links": { "accountParent": { "type": "belongsTo", "foreign": "fixedby", "entity": "Account", "audited": false, "isCustom": true }, "bssa": { "type": "hasChildren", "entity": "Attachment", "foreign": "parent", "layoutRelationshipsDisabled": true, "relationName": "attachments" } } }