Where to see the string value shown in the form presented number in table

(0) Share

Report

Posted on by Hoang Ng

297

The General Journal, User see the string of the Document Type: Payment, Invoice, Credit Memo, etc

But in GL Entry, they are store as 0, 1, 2,3.

How I know exactly Number 0 presents for Invoice or Credit Memo

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report

RE: Where to see the string value shown in the form presented number in table

Hi,

In SQL table it shows like this only, you can start counting from 0 in BC. That is the index value of the option type

so now in your case its

0 = Blank

1= Payment

2 = Invoice

3=Credit Memo

4=Finance Charge Memo

5 = Reminder

6 = Refund

Was this reply helpful? Yes No
Hoang Ng 297 on at

Like (0)

Report

RE: Where to see the string value shown in the form presented number in table

Thanks Nitin

Is there any table that define this so it can be easier to join table together ?

There are many columns have the value list as same as Document Type, I would like to know about them.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report

RE: Where to see the string value shown in the form presented number in table

Hi,

you can still join with their index values as Bc will understand it automatically

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (0)

Report

RE: Where to see the string value shown in the form presented number in table

Hi,

In SQL Option fields of BC D365 shown in the numbers.

Pls use Case Statement in SQL and write Case 1 = Payment and so on.

https://erpconsultors.com/how-to-use-case-statement-in-d365-bc/

If not solve, pls send SQL Query i wll correct it.

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,071 Moderator on at

Like (0)

Report

RE: Where to see the string value shown in the form presented number in table

[quote user="Peter Ng"]
Thanks Nitin

Is there any table that define this so it can be easier to join table together ?

There are many columns have the value list as same as Document Type, I would like to know about them.
[/quote]
The option fields are a zero based index so the first option you see in the list will always have value 0 and the second one will have the integer value 1 and so on.

And in code you can use the option value if you use the syntax fieldname::OptionCaption.

And there is intellisense so AL will help you display the option capotions when you add the double colon.

Was this reply helpful? Yes No
Hoang Ng 297 on at

Like (1)

Report

RE: Where to see the string value shown in the form presented number in table

I created new SQL Table to contain the value list, later I will do Inner Join

Was this reply helpful? Yes No