Answer

Duplicated NoteID value

Forum|Forum|2 years ago
December 12, 2022
2 replies
137 views

+1

ygagnaire12
Semi-Pro I

I have recently noticed that two records dealing with two differents PaymentMethodID in our PaymentMethod table have the save NoteID value.

I'm new in the Acumatica's world but it seems to me that a given NoteID value should be unique in its tenant.

I have decided to change the NoteID value of one of my conflicting records but to do so, I have to check before for potential uses of this value in other tables. Am I exhaustive if I search for the value to be changed in all tables having a NoteID column or can NoteID values be also used in columns having an other name ?

Best answer by Django

Based on the table structure for that table, the NoteID column doesn’t have to have a unique value in that column. The database should generate a unique value when it inserts a new record but if you import a value into that field then the database will happily accept it.

There are many cases where a NoteID value is used as a foreign key value in another table. Typically you see this called RefNoteID or ParentNoteID.

As for the NoteID within the PaymentMethod table, it doesn’t look like it is used elsewhere - the paymentmethod.cs file doesn’t appear to have any foreign key references listed.

D

+7

Django
Captain II
Answer
Forum|Forum|2 years ago
December 12, 2022

Based on the table structure for that table, the NoteID column doesn’t have to have a unique value in that column. The database should generate a unique value when it inserts a new record but if you import a value into that field then the database will happily accept it.

There are many cases where a NoteID value is used as a foreign key value in another table. Typically you see this called RefNoteID or ParentNoteID.

As for the NoteID within the PaymentMethod table, it doesn’t look like it is used elsewhere - the paymentmethod.cs file doesn’t appear to have any foreign key references listed.