Line Item Status 1

[bradth]

Does anyone know what all of the line item status numbers mean? What I'm talking about is when I run a query on SQL Query analyzer:

SELECT * FROM POP10110 WHERE POLNESTA <> '0'

The column POLNESTA gives me numbers 1-8 I believe and I'm trying to figure out when your in GP, what each number relates to.

Ex: 1 = Quote/Estimate, 2 = Open, etc.

Anyone have any idea where I can find this info b/c I need to find out which number is equal to a "Closed" Purchase Order (PO).

Thanks.

 

[Borvik]

Ok here is a break-down for you.

1 - New
2 - Released
3 - Change Order
4 - Received
5 - Closed
6 - Cancelled

 

[bradth]

Great, that completely solves my problem. Thanks.

Brad

 

[minerva9]

FYI...

You sometimes can get the meaning of a field's value by going to Tools>Resource Descriptions>Tables, search on your product and series (and I usually view by Table Physical Name for ease of reference). Double-click on the table you want to get to Table Descriptions and there you'll find all the table's fields and their properties. Select the field you want more info on and click on "Field Info" to get to Additional Field Information. In your case the info you want is under Static Values.