How to use negative numbers in maintenance views

When you create a maintenance view for a dictionary table, by default numeric fields can not hold negative values. Learn how to circumvent this problem.

Zuhal Gunes

Published: 17 Feb 2005

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

When you create a maintenance view for a dictionary table, by default numeric fields can not hold negative values. To be able to use negative numbers in a numeric field, the letter 'V' must be added to the end of the default value of the field.

SearchERP

AI helps supply chain analytics make better predictions

IoT sensors carry more data than ever into SCM platforms, making analytics simultaneously more complicated and effective. Machine...

RPA basics: What it is, benefits, downsides, use cases

Robotic process automation may be able to help your business, but first you need to understand what it is and what it can and ...

Digital supply networks improve visibility and collaboration

Digital supply networks offer better visibility and collaboration than traditional supply chains. Find out what they are and ...

SearchOracle

Oracle OpenWorld 2019 coverage: Oracle seeks loftier cloud perch

This guide covers technology developments and other news from the Oracle OpenWorld 2019 conference, plus key trends for Oracle ...

Oracle applications development EVP on Fusion, SaaS and what's ahead

Steve Miranda discusses lessons learned from Oracle Fusion Applications, SaaS, best-of-breed apps vs. suites and Oracle's ...

The roots of Oracle's cloud evolution: A 20-year review

Oracle, like other prominent on-premises software vendors, has traced a long path into the cloud. These 10 events over the past ...

SearchDataManagement

PostgreSQL 12 boosts open source database performance

Widely used open source PostgreSQL database platform gets a major update providing users with new SQL query capabilities for JSON...

Data integration vs. ETL in the age of big data

Data integration provides a consistent view of business performance across multiple data sources, though it needs to keep up with...

5 steps to an improved data quality assurance plan

Consultant David Loshin offers tips on developing a data quality strategy that can help identify data errors before they cause ...

SearchAWS

Amplify improvements streamline AWS mobile app development

Once just an open source Java library, AWS Amplify is now a full-fledged AWS mobile app development platform. Learn how it works ...

AWS ups the ante to win SAP cloud ERP workloads

New AWS high-memory instances geared for SAP ERP implementations reflect an ongoing push by hyperscalers for these lucrative ...

A go-to AWS migration checklist for DevOps-ready enterprises

Follow this checklist to prepare for a cloud migration and optimize DevOps practices. The steps include advice on tools and ...

SearchBusinessAnalytics

Promethium tool taps natural language processing for analytics

The software, called Data Navigation System, was designed to enable non-technical users to make complex SQL requests using plain ...

Intelligence as a service is key to nonprofit's urban planning

Cobalt Community Research, a nonprofit organization based in Michigan, uses data collected and packaged by TruFactor for urban ...

GoodData BI customers now able to use data on Amazon Redshift

GoodData partners with Amazon Web Services to allow the vendor's users to store and manage their data in Amazon Redshift, a cloud...

SearchContentManagement

Digital asset management benefits the future of work

Digital asset management promises to transform digital work, making it easier to tag documents, analyze video and provide image ...

Box cloud content management adds PDF tools, boosts security

Box partners with Adobe in releasing a new set of PDF tools that can be used within Box's content management cloud to enable ...

AI optimizes content management workflows, personalizes CX

AI is poised to revolutionize content management workflows, bringing order to enterprise documents, greater insights into ...

SearchHRSoftware

Get smarter about HR data security

HR deals with mountains of sensitive employee data and must do a better job of protecting that information. Here's a look at how ...

Walmart, FedEx make case for VR training

The payback from virtual training may be improved retention and shorter training times. An hour-long training period can be ...

Do you know how to improve employee experience? Test yourself

Think you know what it takes to create a positive employee experience for your workers? Take this EX quiz to test your savvy and ...

Dig Deeper on SAP ABAP

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.