Zack
10/16/2018, 4:27 PM[
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"
})
]