Recently started a new analyst role a few weeks ago... I don't have a crazy amount of experience.

The company I was hired with uses NetSuite, and I am doing my best to learn all I can. But something seems incredibly wrong to me... why would 1 table out of a few hundred, have over 380 fields... when making saved searches t's a painstaking process... let alone if you don't know the fields, the purpose etc... can someone give me some insight because as of right now, I feel like a crazy person.

like
Posting as :
works at
You are currently posting as works at

doesn’t that depend on the client/company? i’ve seen tables with way more attributes.

what type of data is stored in this table? more context would help.

For me and where I come from if you can take 10 fields out of a table and store that in a different table well then that's a plus.

That's a great question, I don't know... there are so many fields and from what I have found, very little to no documentation on where the fields come from or what they even are, the field names are not ideal either...

I'm concerned about duplicate data, data not flowing properly, again I don't have a whole lot of experience... but I see hundreds of custbody_%...%

I have seen probably close to 50-60 address fields. In the transaction table alone has 13 different address fields, that's not even considering state fields or country.

sounds like a fun project to investigate and document.

I’m assuming this dataset cannot be modified to eliminate columns if cells contain data, but i’d find out if any are empty to see if they can be quickly eliminated by an admin. i’d then go through and label remaining ones with what they are and if they’re necessary or not. since they have weird titles, that may work in your favor as it’ll be easier to marry them to business processes to determine what is/is not used.

aside from that, simply figuring out what everything is and what attributes you need moving forward will speed things up tremendously.

helpful

theres an option under home > set preferences > Show internal ID's... that will help you greatly and i recomend always looking at the source transaction/page on one monitor and having the saved search you are creating on the secondary monitor. Then its just a matter of trial and error.

Saved searches are database queries and sometimes you can break the search/not yeild the results you want by joining too many fields.

Good luck and use chat GPT to help :P

This pretty standard depending on the size of company. Moving forward use consistent naming conventions for your records it will pay off in the future

Related Posts

What should be the salary slab for 9.5 years experience working as a Test lead and having good knowledge in automation testing and E2E testing?

Anyone able to refer @ Kearney Dubai pls? ~10 yrs strat consulting experience in Western Europe.

like

Larsen & Toubro Infotech How is LTI in Bangalore? Do they have enough projects in Bangalore? I could see most of the requirements in Mumbai, Pune?Larsen & Toubro Infotech

like

How many hours a week do you ACTUALLY work?

like

Hello LTItes, i joined LTI a month back.
I attended a client interview last week and was selected for the same. Now they are asking to join within a day or two. I'm having my mom's surgery this week. How to safely refuse to join this client project for at least 10 days. I can't take leave for 10 days.
Can anyone please help me with this? I'm confused and scared.

Thanks

like

Has anyone dealt with Peachtree Residential before? They build homes primarily in Atlanta and Charlotte.

like

Interested in SAP, as I have done a few ITGC testing and application control testing over it. Looking for some basic training, any recommendations?

like

This job sure brings out the inner narcissist in me! Normally I am all about the clients and their needs, and have always been a bit of a caregiver..but when they are super happy and make referrals and such

likesmart

Need advice from the forum as I am confused between the two offers. Thank you in advance.

Currently working as Business Consultant + Project Manager w midsize tech consulting firm : 12 YOE + current TC 125k

Offers :
1. Local Bank >> Business Change management role (COO org) >> 152k Base + 30k bonus(to be paid in March 2023) + challenging work culture + 3 months NP

2. Global Bank >> BA + PM role (CTO org) >> 160k Base + 20k bonus( to be paid in Mar 2023) + Regular work culture + 2 months NP

like

I have a “commitment to an offer” at 150-170k from a BB. They said they can’t give me the offer until Feb/March until they ramp up their current hires and figure out their budget, but the HM said the best thing I can do is to get another offer to use as leverage.

I’m about to receive an offer from a different company at 100-115k. Would much rather work at the BB (better company/position). Is it even worth me bringing this offer to use as leverage, or is the salary discrepancy too much?

like

Any healthcare strategy practices hiring here? I have 2.5 YOE in healthcare valuation and am looking to move into strategy work!

like

Trying to decide between soylent or huel as a meal replacement 1x daily. Anyone have recs? Goal: shed ~5-10 lbs and keep it off over the next few months.

Hi, is there a buyout option in TCS? Is it possible to reduce notice period to 30 days ?

like

Hi fishes!

Need a referral for a role I wish to apply at Citi... Can someone please help me out?

TIA @Citibank

like

If you’re interested in BNY Mellon, send a DM with a specific role of interest

like

I just got an invite for my first chat for a SC role at BCG Platinion. What is the interview process like at Platinion, is it any different than what the core consulting practice?BCG Platinion

like

Hi 🐠

Looking into purchasing the Product Uplevel course from Product Alliance. I was wondering if anyone has taken the course and what their thoughts were. Thanks!

like

I'm a product manager at a small start-up with ~3 years professional experience. Been offered a VC internship, or a PM role at a post series B startup. I like the idea of VC, but the internship is at a non-prestige VC. Is it worth taking it anyway, or staying in product and switching to VC when I'm more senior?

like

Interviewing to crossover from plaintiff to defense work, wondering what a competitive salary offer would be from a firm in the V20-30 range, 5th year, antitrust practice. NY/DC scale. Thanks in advance

like

Hi 👋 I’m a Bank Manager with 12+ years of banking experience looking to transition in fintech sales. I don’t have software exp but banking sales and business development exp. I’m looking for midmarket or enterprise sales executive roles? Ive been applying with no call backs. Any referrals or suggestions please.

like

Additional Posts in Oracle Consultants

Does anyone have a Procurement exam dump they would be willing to share by chance?

likesmart

Anyone hiring in the TMS space? Also have O2C on prem experience.

like

Hi People, I am interested in a role at Oracle Canada. I have a couple of years of experience in that role. Can anyone please provide me with a referral?
Oracle

like

OCS 🐠 - I hear there's been a culture change, is OCS more than just "screwing in Oracle" and how's it going? Are experienced hire managers respected when coming from large competitors?

like
like

What is the maximum CTC I can expect from Oracle for 8 YOE for the position of Oracle EBS/Fusion Financials Technical Consultant?

Also please share any insights.

like

What exit opportunities are available for a financials implementation specialist with about a year and half of experience? I’ve decided that I no longer want to work in Oracle for a variety of reasons, but mostly the lack of good training options while still expecting me to get certifications are really driving me to find something else.

like

Has anyone passed the 2021 Oracle Receivables certification exam?

like

Anybody gone from Accenture to Oracle Consulting Services (OCS)? Wondering what the real differences are in delivery, expectations, career, etc.

like

Hi Folks,

Just wanted to know till when is work from home is continuing for Oracle?

I think they can ask whether to return to office but can't force to be back...

Share your thoughts :)

like

Have seen a lot of Accenture and Deloitte postings out there on LinkedIn for Oracle Financial and HCM. Any ACN or D consultants out there care their insights on their practices?

like

Anyone that might be able to provide a referral for a job posting? I have resume, and job In hand . Thanks everyone!

like

Can someone provide question bank with Answers for Oracle Order Management cloud order to cash 2022 implementation professional 1Z0-1077-22 exam

likefunny

Who is getting 18.c on November 5th?

Does anybody have any trusted site for exam dumps for the General ledger 2022 certification?

likesmart

Simultaneously leading a Logfire and an EBS WMS project. Pray for me.

like

Has anyone had any luck with in getting a specific answer on what licensing is required for specific “edge” features (e.g. shared HCM or supplier model for FIN. How far into either can you go?).

Hi All,

Since most of the organizations start working from office or calling their employee back.
I would like to know what options should be available or present in organizations for employees with medical problems like diabetes, heart disease etc.

like

Has anyone passed the Oracle GL 2021 exam yet ?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal