• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

9.0 Table Schemas?

 7 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
JMED
Basic Member Send Private Message
Posts: 5
Basic Member
10/29/2014 1:46 PM

Hi Everyone!

I was wondering if anyone is aware of a location where I could find the table schemas for a handful of Lawson 9.0 tables? I was referencing the Data Dictionary under the TECH tab here, but was wondering if there was a SQL schema somewhere to ensure I am capturing the right columns, data types, and constraints properly. 

PS. I currently do not have direct access to the Lawson DB, so I'm relying heavily on the documentation and forums to gain an understanding.

Thanks! :-)

JMED

Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
10/29/2014 1:58 PM
I have some... but they are too big to email or upload. More details later.... I've got a minor emergency that I need to leave for now.
JMED
Basic Member Send Private Message
Posts: 5
Basic Member
10/29/2014 2:06 PM
Thank you so much for your response! Below are the tables I'm really looking for the most:
POVAGRMTHD
POVAGRMTLN
REQHEADER
REQLINE
PURCHORDER
POLINE
APINVOICE
MAINVDTL
APVENMAST
ICMANCODE
DEPTCODE
ITEMMAST

I started going through the tables by hand based on the Data Dictionary, but I'm not sure if thats the best approach. Thanks again in advance :-)
ACCESS GNOME
Basic Member Send Private Message
Posts: 8
Basic Member
10/29/2014 2:24 PM
If you're able to ask someone who has access to the Lawson DB, I highly recommend looking into a table named "PUBLIC_ALL_TAB_COLUMNS". You'll be able to enter key words into field "COLUMN_NAME" which will return all tables names (under field "TABLE_NAME") associated with your key words. I used this table a lot in the past to help me locate/identify tables of interest to create queries.
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
10/29/2014 3:40 PM
Send me your email in a Private Message, and I'll ship you what I have for these tables.
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
10/29/2014 4:18 PM

Heck, I'll just attach them here...   They don't look very good without the backgroud css and other directory structure stuff... but I think you'll get the point.

If I could, I might suggest getting someone there that does have the access to install SchemaSpy and required programs, and generate your own interactive html pages....  (Similar to under the ERDS section for LBI)

 Here's these 12 tables to get you started, though. 

 Having issues with the 'Attachment' feature... 

JMED
Basic Member Send Private Message
Posts: 5
Basic Member
10/29/2014 4:22 PM
Thanks! However, I'm not seeing the attachment :-( did you get my private message with my email?
John Henley
Send Private Message
Posts: 3351
11/4/2014 12:55 PM

uploading file.

Attachments
Thanks for using the LawsonGuru.com forums!
John