• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

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 Send Private Message
Posts: 10
Basic Member
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 Send Private Message
Posts: 76
Veteran Member
5/24/2010 1:07 PM
You should be able to find what you need on the MMDIST table.

Brad
BobC
New Member Send Private Message
Posts: 2
New Member
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 Send Private Message
Posts: 10
Basic Member
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 Send Private Message
Posts: 6
Basic Member
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...!!