``` [ search.createColumn({name: "tr...
# suitescript
z
Copy code
[
    		      search.createColumn({name: "tranid", label: "Document Number"}),
    		      search.createColumn({
    		         name: "formulatext",
    		         formula: "{createdfrom.type}",
    		         label: "Formula (Text)"
    		      }),
    		      search.createColumn({
    		         name: "formulatext",
    		         formula: "CASE WHEN {createdfrom.type} = 'Sales Order' THEN '07-Sales Order' ELSE NULL END",
    		         label: "Created From Type"
    		      }),
    		      search.createColumn({name: "trandate", label: "Date"}),
    		      search.createColumn({
    		         name: "formulatext",
    		         formula: "'CREATE'",
    		         label: "Formula (Text)"
    		      }),
    		      search.createColumn({name: "shipdate", label: "Ship Date"}),
    		      search.createColumn({name: "createdfrom", label: "Created From"}),
    		      search.createColumn({
    		         name: "formulatext",
    		         formula: "CASE WHEN {shipmethod} = 'UPS Ground' THEN 'UPS_GND' ELSE NULL END",
    		         label: "Ship Via"
    		      }),
    		      search.createColumn({name: "shipaddress", label: "Shipping Address"}),
    		      search.createColumn({name: "shipaddressee", label: "Shipping Addressee"}),
    		      search.createColumn({name: "shipcarrier", label: "Shipping Carrier"}),
    		      search.createColumn({
    		         name: "formulatext",
    		         formula: " CASE WHEN {shipmethod} = 'UPS Ground' THEN CONCAT( 'UPS_GND-' , {name} ) ELSE NULL END ",
    		         label: "Route"
    		      }),
    		      search.createColumn({name: "shippingattention", label: "Shipping Attention"}),
    		      search.createColumn({name: "entity", label: "Name"}),
    		      search.createColumn({name: "paymentmethod", label: "Payment Method"}),
    		      search.createColumn({
    		         name: "altname",
    		         join: "customerMain",
    		         label: "Name"
    		      }),
    		      search.createColumn({
    		         name: "formulatext",
    		         formula: "CASE WHEN {location} = 'Jasper, IN' THEN 'JSP' ELSE CASE WHEN {location} = 'Urbandale' THEN 'URB' ELSE NULL END END",
    		         label: "Order Hdr - Custom Field 1"
    		      }),
    		      search.createColumn({
    		         name: "formulatext",
    		         formula: "{shipcarrier}",
    		         label: "Order Hdr - Custom Field 4"
    		      }),
    		      search.createColumn({
    		         name: "formulatext",
    		         formula: "'???'",
    		         label: "Order Hdr - Custom Field 3"
    		      }),
    		      search.createColumn({name: "custbody_cseg_division", label: "Dvision"}),
    		      search.createColumn({name: "otherrefnum", label: "PO/Check Number"}),
    		      search.createColumn({name: "shipcountrycode", label: "Shipping Country Code"}),
    		      search.createColumn({
    		         name: "formulatext",
    		         formula: "'0'",
    		         label: "Priority"
    		      }),
    		      search.createColumn({name: "shipaddress", label: "Shipping Address"}),
    		      search.createColumn({name: "shipcity", label: "Shipping City"}),
    		      search.createColumn({name: "shipstate", label: "Shipping State/Province"}),
    		      search.createColumn({name: "shipzip", label: "Shipping Zip"}),
    		      search.createColumn({name: "shipcountrycode", label: "Shipping Country Code"}),
    		      search.createColumn({name: "shipphone", label: "Shipping Phone"}),
    		      search.createColumn({
    		         name: "formulatext",
    		         formula: "'???'",
    		         label: "Order Hdr - Custom Field 2"
    		      })
    		   ]