Commonly used drill strings

This topic describes commonly used drill strings. You can use the examples to help you build your drill strings.

Note the following items:

  • Your drill strings are based on your Lawson Applications version. Therefore, depending upon your Applications version, you might have to adapt the following example drill string syntax to create correct drill strings.
  • If you are using either LOGAN or DSSO as your authentication provider, you do not need to specify a product line (_PDL) within the drill string. Lawson Application Link (LAL) will automatically provide the product line for these authentication methods.

This table shows the commonly used drill strings:

Drill string Example
Activity 
"Drill.jsp?_TYP=DT&_PDL=" + <Replace
With Product Line> + "&_SYS=AC&_KNB=11x&11x="
+ <Replace With ACTIVITY Field Name>
Vendor (AP) 
"Drill.jsp?_TYP=DT&_PDL="
+ <Replace With Product Line> + "&_SYS=AP&_KNB=AVI&K=08&08="
+ <Replace With VENDORGROUP Field Name> + "&AVI="
+ <Replace With VENDORNUMBER Field Name>
Invoice (AP) 
"Drill.jsp?_TYP=DT&_PDL=" + <Replace
With Product Line> + "&_SYS=AP&_KNB=50&K=01&K=03&01="
+ <Replace With COMPANY Field Name> + "&03=" + <Replace
With VENDORNUMBER Field Name> + "&50=" <Replace With INVOICE
Field Name>
Customer (AR) 
"Drill.jsp?_TYP=DT&_PDL="
+ <Replace With Product Line> + "&_SYS=AR&_KNB=M3&K=01&01="
+ <Replace With COMPANY Field Name> + "&M3=" + <Replace
With CUSTOMERNUMER Field Name>
Journal Entry (GL) 
"Drill.jsp?_TYP=DT&_PDL=" + <Replace
With Product Line> + "&_SYS=GL&_KNB=01&K=GI&K=06&K=GP&K=GK&K=GIS&01="
+ <Replace COMPANY Field Name> + "&06=" + <Replace With
FISCALYEAR Field Name> + "&GP=" + <Replace With PERIOD Field
Name> +  "&GS=" + <Replace With SYSTEM Field Name> + "&GK="
+ <Replace With JETYPE Field Name> + "&GIS=" + <Replace
With CONTROLGROUP Field Name>
Company (GL) 
"Drill.jsp?_TYP=DT&_PDL="
+ <Replace With Product Line> + "&_SYS=IF&_KNB=01&01="
+ <Replace With COMPANY Field Name>
Accounting Unit (GL) 
"Drill.jsp?_TYP=DT&_PDL="
+ <Replace With Product Line> + "&_SYS=IF&_KNB=02&01="
+ <Replace With COMPANY Field Name> +  "&02=" + <Replace
With ACCTUNIT Field Name>
Process Level (HR) 
"Drill.jsp?_TYP=DT&_PDL=" + <Replace
With Product Line> + "&_SYS=HR&_KNB=H03&K=01&01="
+  <Replace With COMPANY Field Name> + "&H03=" + <Replace
With PROCESSLEVEL Field Name>
Employee (HR) 
"Drill.jsp?_TYP=DT&_PDL=" + <Replace
With Product Line> + "&_SYS=HR&_KNB=H07&K=01&01="
+  <Replace With Company Field Name> + "&H07=" + <Replace
With EMPLOYEENUMBER Field Name>
Item 
"Drill.jsp?_TYP=DT&_PDL=" + <Replace
With Product Line> + "&_SYS=IC&_KNB=DI&K=DG&DG="
+  <Replace With ITEMGROUP Field Name> + "&DI=" + <Replace
With ITEM Field Name>
Report Writer Drill Syntax 
"Form.jsp?_TKN=RW80.1&_HK= + **INSERT DRILL
FIELD HERE**
Lawson Standard Report Drill Syntax 
"Drill.jsp? + **INSERT DRILL FIELD HERE**