TimeLine-specific LL functions

tl_doctype_shortdesc / tl_beltyp_in_kurzworten

Returns the document shortcut, for example, OF for offer, OC for order confirmation, DN for delivery note, or IV for invoice.

The function will be called with the following parameters: Document Type, Language: tl_doctype_shortdesc ( DocumentType, Language)

tl_doctype_description / tl_beltyp_in_worten

Returns the document name, for example, offer for document type 1, order confirmation for document type 2, delivery note for document type 3 or invoice for document type 4.

The function will be called with the following parameters: Document Type, Language: tl_doctype_description( DocumentType, Language))

tl_calc_year(Date) / tl_calc_jahr(Date)

Returns the year number from the given date.

The function will be called with the following parameters: Date: tl_calc_year(Date)

tl_calc_cw(Date) / tl_calc_kw(Date)

Returns the week number from the given date .

The function will be called with the following parameters: Date: tl_calc_cw(Date)

tl_code39(String)

Removes special characters from a transferred text and adds bar code 39 encoding characters .

The function will be called with the following parameters: Text: tl_code39(Text)

tl_compute_full_path(String)

You can store a logo in custompath\images and just specify the partial path (\images\logo.png) and use the above function in LL report to get the full path and display the image. It has fallback from custompath to standardpath.

The function will be called with the following parameters: Text: tl_compute_full_path(Text)

tl_format_longtext(Number, String)

Format document text according to the document type.

The function will be called with the following parameters: Text: tl_format_longtext(DocumentType, Text)

tl_get_current_user(String)

Returns data about the current user, depending on the value

The function will be called with the following parameters: Value: tl_get_current_user(Value).

Value:

• login -> returns login name

• kuerzel -> returns mitarb.kuerzel (employee shortcut)

• name -> returns mitarb.name (employee name)

tl_get_dms_path(Number)

Returns the local dms path for a file.

he function will be called with the following parameters: "DMS Link": tl_get_dms_path(Dms Link)

tl_get_profile() / tl_get_mandant()

Returns the current profile.

tl_get_para(Number, Number)

Returns a value from the "para" table based on the passed group and ID

The function will be called with the following parameters: Group, ID: tl_get_para(Group, ID).

tl_get_sprache()

Returns the curent language number.

tl_get_zk_faelligkeit(String, String)

Returns discount text according to supplied field names from given table.

The function will be called with the following parameters: Table Name, Used Fields (separated by coma): tl_get_zk_faelligkeit(Table Name, Used Fields)

tl_user_salesagent(String, String) / tl_mitarb_vertr(String, String)

Return the employee data according to the ID and mode given.

The function will be called with the following parameters: EmployeeID, Mode: tl_user_salesagent(EmployeeID, Mode)

Mode:

• ABW_VERTR_LAGER -> returns mitarb.lager_nr (employee Deviant Standard-Warehouse, for sales agent)

• NAME -> returns mitarb.name (employee name)

• DIKTATZEICHEN -> returns mitarb.diktatz

• DURCHWAHL -> returns mitarb.durchwahl (employee direct dial)

• ABTEILUNG -> returns abteilg.bez (department description)

• EMAIL -> returns mitarb.email (employee email)

• ALL -> returns all information: mitarb.name, mitarb.diktatz, mitarb.durchwahl, abteilg.bez, mitarb.email

tl_sprachen_bez(Number, String)

Returns fremdspr from sprachen_begriffe or corresponding column value from sprachen.

The function will be called with the following parameters: Language number, Input: tl_sprachen_bez(Language , Input)

tl_translate(Number , String)

Translate a string according to the language number.

The function will be called with the following parameters: Language number, Input: tl_translate(Language , Input)