Locale: Difference between revisions

From Chorke Wiki
Jump to navigation Jump to search
No edit summary
Line 188: Line 188:
     amender
     amender
FROM
FROM
     M00TM10X00
     M00TM0AX00
</source>
</source>
|}
|}
Line 210: Line 210:
     amender
     amender
FROM
FROM
     M00TM11X00
     M00TM0BX00
</source>
</source>


Line 229: Line 229:
     amender
     amender
FROM
FROM
     M00TM12X00
     M00TM0CX00
</source>
</source>


Line 248: Line 248:
     amender
     amender
FROM
FROM
     M00TM13X00
     M00TM0DX00
</source>
</source>


Line 267: Line 267:
     amender
     amender
FROM
FROM
     M00TM14X00
     M00TM0EX00
</source>
</source>
|}
|}

Revision as of 02:57, 15 September 2019

Types

Data

SELECT
    data_type_code,
    data_type_name,
    entered,
    enterer,
    amended,
    amender
FROM
    M00TM00X00

Error

SELECT
    error_type_code,
    error_type_name,
    entered,
    enterer,
    amended,
    amender
FROM
    M00TM01X00

Objects

Tables

SELECT
    table_code,
    table_name,
    data_type_code,



    entered,
    enterer,
    amended,
    amender
FROM
    M00TM02X00

Forms

SELECT
    form_code,
    form_name,
    data_type_code,
    apps_type,
    base_flag,
    base_form,
    entered,
    enterer,
    amended,
    amender
FROM
    M00TM03X00

Reports

SELECT
    report_code,
    report_name,
    data_type_code,



    entered,
    enterer,
    amended,
    amender
FROM
    M00TM04X00

Errors

SELECT
    error_code,
    error_name,
    error_type_code,



    entered,
    enterer,
    amended,
    amender
FROM
    M00TM05X00

Labels

Fields

SELECT
    field_code,
    table_code,
    field_order,
    field_name,
    entered,
    enterer,
    amended,
    amender
FROM
    M00TM06X00

Forms

SELECT
    label_code,
    form_code,
    label_name,
    label_value,
    entered,
    enterer,
    amended,
    amender
FROM
    M00TM07X00

Reports

SELECT
    label_code,
    report_code,
    label_name,
    label_value,
    entered,
    enterer,
    amended,
    amender
FROM
    M00TM08X00

Localizations

Languages

SELECT
    lingo_code,
    iso_alpha2_lingo_code,
    iso_alpha3_lingo_code,
    lingo_name,
    entered,
    enterer,
    amended,
    amender
FROM
    M00TM09X00

Countries

SELECT
    state_code,
    iso_alpha2_state_code,
    iso_alpha3_state_code,
    state_name,
    entered,
    enterer,
    amended,
    amender
FROM
    M00TM0AX00

Translations

Tables

SELECT
    translated_code,
    table_code,
    field_code,
    field_value,
    iso_alpha2_lingo_code,
    iso_alpha2_state_code,
    translated_value,
    entered,
    enterer,
    amended,
    amender
FROM
    M00TM0BX00

Forms

SELECT
    translated_code,
    form_code,
    label_code,

    iso_alpha2_lingo_code,
    iso_alpha2_state_code,
    translated_value,
    entered,
    enterer,
    amended,
    amender
FROM
    M00TM0CX00

Reports

SELECT
    translated_code,
    report_code,
    label_code,

    iso_alpha2_lingo_code,
    iso_alpha2_state_code,
    translated_value,
    entered,
    enterer,
    amended,
    amender
FROM
    M00TM0DX00

Reports

SELECT
    translated_code,
    error_code,


    iso_alpha2_lingo_code,
    iso_alpha2_state_code,
    translated_value,
    entered,
    enterer,
    amended,
    amender
FROM
    M00TM0EX00