Locale: Difference between revisions

From Chorke Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
__NOTOC__
__NOTOC__
==Types==
==Types==
{|
| valign="top" |
===Data===
<source lang="sql">
<source lang="sql">
SELECT
SELECT
     type_code,
     data_type_code,
     type_name,
     data_type_name,
     entered,
     entered,
     enterer,
     enterer,
Line 12: Line 15:
     T00M00X00
     T00M00X00
</source>
</source>
| valign="top" |
===Error===
<source lang="sql">
SELECT
    error_type_code,
    error_type_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M01X00
</source>
|}


==Objects==
==Objects==
Line 21: Line 39:
     table_code,
     table_code,
     table_name,
     table_name,
     table_type,
     data_type_code,




Line 30: Line 48:
     amender
     amender
FROM
FROM
     T00M01X00
     T00M02X00
</source>
</source>


Line 39: Line 57:
     form_code,
     form_code,
     form_name,
     form_name,
     form_type,
     data_type_code,
     apps_type,
     apps_type,
     base_flag,
     base_flag,
Line 48: Line 66:
     amender
     amender
FROM
FROM
     T00M02X00
     T00M03X00
</source>
</source>


Line 57: Line 75:
     report_code,
     report_code,
     report_name,
     report_name,
     report_type,
     data_type_code,




Line 66: Line 84:
     amender
     amender
FROM
FROM
     T00M03X00
     T00M04X00
</source>
</source>


Line 75: Line 93:
     error_code,
     error_code,
     error_name,
     error_name,
     error_type,
     error_type_code,




Line 84: Line 102:
     amender
     amender
FROM
FROM
     T00M03X00
     T00M05X00
</source>
</source>
|}
|}
Line 103: Line 121:
     amender
     amender
FROM
FROM
     T00M04X00
     T00M06X00
</source>
</source>


Line 119: Line 137:
     amender
     amender
FROM
FROM
     T00M05X00
     T00M07X00
</source>
</source>


Line 135: Line 153:
     amender
     amender
FROM
FROM
     T00M06X00
     T00M08X00
</source>
</source>
|}
|}
Line 154: Line 172:
     amender
     amender
FROM
FROM
     T00M07X00
     T00M09X00
</source>
</source>


Line 170: Line 188:
     amender
     amender
FROM
FROM
     T00M08X00
     T00M10X00
</source>
</source>
|}
|}
Line 192: Line 210:
     amender
     amender
FROM
FROM
     T00M09X00
     T00M10X00
</source>
</source>


Line 211: Line 229:
     amender
     amender
FROM
FROM
     T00M10X00
     T00M11X00
</source>
</source>


Line 230: Line 248:
     amender
     amender
FROM
FROM
     T00M11X00
     T00M12X00
</source>
</source>


Line 249: Line 267:
     amender
     amender
FROM
FROM
     T00M12X00
     T00M13X00
</source>
</source>
|}
|}

Revision as of 19:56, 14 September 2019

Types

Data

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

Error

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

Objects

Tables

SELECT
    table_code,
    table_name,
    data_type_code,



    entered,
    enterer,
    amended,
    amender
FROM
    T00M02X00

Forms

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

Reports

SELECT
    report_code,
    report_name,
    data_type_code,



    entered,
    enterer,
    amended,
    amender
FROM
    T00M04X00

Errors

SELECT
    error_code,
    error_name,
    error_type_code,



    entered,
    enterer,
    amended,
    amender
FROM
    T00M05X00

Labels

Fields

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

Forms

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

Reports

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

Localizations

Languages

SELECT
    lingo_code,
    iso_alpha2_code,
    iso_alpha3_code,
    lingo_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M09X00

Countries

SELECT
    state_code,
    iso_alpha2_code,
    iso_alpha3_code,
    state_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M10X00

Translations

Tables

SELECT
    translated_code,
    table_code,
    field_code,
    field_value,
    iso_alpha2_lingo,
    iso_alpha2_state,
    translated_value,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M10X00

Forms

SELECT
    translated_code,
    form_code,
    label_code,

    iso_alpha2_lingo,
    iso_alpha2_state,
    translated_value,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M11X00

Reports

SELECT
    translated_code,
    report_code,
    label_code,

    iso_alpha2_lingo,
    iso_alpha2_state,
    translated_value,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M12X00

Reports

SELECT
    translated_code,
    error_code,


    iso_alpha2_lingo,
    iso_alpha2_state,
    translated_value,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M13X00
Retrieved from "https://cdn.chorke.org/weke/index.php?title=Locale&oldid=1806"