Locale: Difference between revisions

From Chorke Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 3: Line 3:
SELECT
SELECT
     table_code,
     table_code,
     table_nome,
     table_name,
     entered,
     entered,
     enterer,
     enterer,
Line 25: Line 25:
FROM
FROM
     T00M01X00
     T00M01X00
</source>
==Forms==
<source lang="sql">
SELECT
    forms_code,
    forms_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M03X00
</source>
==Labels==
<source lang="sql">
SELECT
    label_code,
    forms_code,
    label_name,
    label_value,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M04X00
</source>
</source>


Line 37: Line 65:
     amender
     amender
FROM
FROM
     T00M02X00
     T00M05X00
</source>
</source>


Line 50: Line 78:
     amender
     amender
FROM
FROM
     T00M03X00
     T00M06X00
</source>
</source>


Line 68: Line 96:
     amender
     amender
FROM
FROM
     T00M04X00
     T00M07X00
</source>
</source>

Revision as of 20:03, 11 September 2019

Tables

SELECT
    table_code,
    table_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M00X00

Fields

SELECT
    field_code,
    table_code,
    field_sqno,
    field_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M01X00

Forms

SELECT
    forms_code,
    forms_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M03X00

Labels

SELECT
    label_code,
    forms_code,
    label_name,
    label_value,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M04X00

Languages

SELECT
    iso_alpha2_lingo_code,
    iso_alpha2_lingo_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M05X00

Countries

SELECT
    iso_alpha2_state_code,
    iso_alpha2_state_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M06X00

Translations

SELECT
    translated_code,
    translated_table_code,
    translated_field_code,
    translated_field_value,
    iso_alpha2_lingo_code,
    iso_alpha2_state_code,
    translated,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M07X00