Who's On?

	Membership:
	Latest: Isabella Harris
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5245

	People Online:
	Visitors: 433
	Members: 0
	Total: 433

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Location of GL Distribution fields for PO20.1 form

4 Replies

0 Subscribed to this topic

43 Subscribed to this forum

Sort:

Author

Messages

mikekask

Basic Member

Posts: 10

5/24/2010 1:03 PM

Hi,
I am trying to access the PO20.1 form GL distribution fields (for GL posting) with an SQL query and I haven't been able to find out where these fields are located. I looked at the POLINE table definition and didn't see anything. Does anyone know where these fields are?

These are the fields at the bottom of the PO20.1 form for the tab that says "Line Detail". I am particularly looking for the fields under the "Account" label which are Accounting Unit, Account, and Sub Account and also the Company field which is next to these fields on my version of the PO20.1 form

Thanks.
Mike

Brad Schauer

Veteran Member

Posts: 76

5/24/2010 1:07 PM

You should be able to find what you need on the MMDIST table.

Brad

BobC

New Member

Posts: 2

5/24/2010 3:02 PM

You should also consider using the Portal Hotkey" Display Field Information" (Ctrl+Shift+O) which gives the table and field name of a given field's data. Very helpful. More info in the KB:
Displaying Required Fields in Portal
Article ID:557081

mikekask

Basic Member

Posts: 10

5/24/2010 5:14 PM

Thanks. The fields on MMDIST were exactly what I was looking for. I will also check out the Portal Hotkey method once I find out how to get on the Portal.

MIke

DennisM

Basic Member

Posts: 6

6/1/2010 3:45 PM

Bob C has the right approach if you're attempting to identify the Lawson table and field name for an SQL extraction...!!