Good morning everyone! I got a real head scratcher...
# generalr
Ricardo
11/27/2019, 3:48 PMGood morning everyone! I got a real head scratcher for you guys that I bet someone has the answer to. I've been asked to provide to a developer a listing of all fields (standard and custom) and their data types. Only for certain tables mind you. Like the "customer" "Sales Order" and "Item Fulfillment" tables. Any idea of how to do this? is there a way to do this in a saved search?
a
al3xicon
11/27/2019, 3:49 PMif you go to a given record in NS, e,g. a sample sales order or customer, and add "&XML=T" at the end of your doc, it will spit out an XML document including all fields available for that record type
al3xicon
11/27/2019, 3:50 PM(and their values for that particular record)
al3xicon
11/27/2019, 3:51 PMthat doesn't give you their data types though - for that you could get your list of custom fields easily enough from Customization -> Lists, Records and Fields -> Entity Fields / Transaction Body Fields (etc) and click the "Export to CSV" button
al3xicon
11/27/2019, 3:51 PMthat won't get you standard fields for each record type
al3xicon
11/27/2019, 3:52 PMfor standard fields you could use the SuiteScript records browser: https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2019_2/script/record/customer.html
al3xicon
11/27/2019, 3:53 PMif you had Strongpoint installed you could export a list of all Customizations
al3xicon
11/27/2019, 3:57 PMThere is probably a more efficient / savvy way using a Web Services call or series of nested loops, but I don't know it and it would likely take a while to set up unless you've already got a prepped SuiteTalk app
a
aaz
11/27/2019, 4:00 PM@Ricardo there is record broswer for that
aaz
11/27/2019, 4:00 PMbut it list native/standard fields
aaz
11/27/2019, 4:01 PMr
Ricardo
11/27/2019, 4:28 PMwow. thanks all. Yeah, I was aware of the schema browser, and I forgot to mention that. I was just trying to figure out a way to pull all the info nicely and not have 2 lists... Thanks though guys! Confirmed I was already on the right track.
a
aaz
11/28/2019, 5:58 AMGood Luck
5 Views