Document Type in which table

vasilis6669

Hi,

I am looking at the CRONUS UK Ltd_$Sales Header SQL table. Which is the reference table for Document Type column?

Can someone explain the Document Type numbering. what is 1,2 etc.

Regards,
Vasilis

Albertvh

Hi,

0 = Quote
1 = Order
2 = Invoice
3 = Credit Memo
4 = Blanket Order
5 = Return Order

Hope this helps


Albert

garak

vasilis6669 wrote:

Hi,

I am looking at the CRONUS UK Ltd_$Sales Header SQL table. Which is the reference table for Document Type column?

Can someone explain the Document Type numbering. what is 1,2 etc.

Regards,
Vasilis

The Field "Document Type" has no table relation. It's a normal integer (Option) field.
In NAV the value is set as Option and NAV stores the options (0 = Quote, 1 = Order, 2 = Invoice, 3 = Credit Memo, 4 = Blanket Order, 5 = Return Order)

Regards

vasilis6669

ok thanks

Administrator

[The use of [SOLVED] is no longer supported. Please use the Topic Attribute to put a green checkmark next to the Topic Title]