Locale: Difference between revisions

From Chorke Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
==Types==
<source lang="sql">
SELECT
    type_code,
    type_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M00X00
</source>
==Tables==
==Tables==
<source lang="sql">
<source lang="sql">
Line 4: Line 17:
     table_code,
     table_code,
     table_name,
     table_name,
    table_type,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M01X00
</source>
==Forms==
<source lang="sql">
SELECT
    form_code,
    form_name,
    form_type,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M02X00
</source>
==Reports==
<source lang="sql">
SELECT
    report_code,
    report_name,
    report_type,
     entered,
     entered,
     enterer,
     enterer,
Line 9: Line 51:
     amender
     amender
FROM
FROM
     T00M00X00
     T00M03X00
</source>
</source>


Line 24: Line 66:
     amender
     amender
FROM
FROM
     T00M01X00
     T00M04X00
</source>
</source>


==Forms==
==Labels==
<source lang="sql">
<source lang="sql">
SELECT
SELECT
     forms_code,
     label_code,
     forms_name,
     form_code,
    label_name,
    label_value,
     entered,
     entered,
     enterer,
     enterer,
Line 37: Line 81:
     amender
     amender
FROM
FROM
     T00M03X00
     T00M05X00
</source>
</source>


==Labels==
<source lang="sql">
<source lang="sql">
SELECT
SELECT
     label_code,
     label_code,
     forms_code,
     report_code,
     label_name,
     label_name,
     label_value,
     label_value,
Line 52: Line 95:
     amender
     amender
FROM
FROM
     T00M04X00
     T00M06X00
</source>
</source>


Line 58: Line 101:
<source lang="sql">
<source lang="sql">
SELECT
SELECT
    lingo_code,
     iso_alpha2_lingo_code,
     iso_alpha2_lingo_code,
     iso_alpha2_lingo_name,
     iso_alpha3_lingo_code,
    lingo_name,
     entered,
     entered,
     enterer,
     enterer,
Line 65: Line 110:
     amender
     amender
FROM
FROM
     T00M05X00
     T00M07X00
</source>
</source>


Line 71: Line 116:
<source lang="sql">
<source lang="sql">
SELECT
SELECT
    state_code,
     iso_alpha2_state_code,
     iso_alpha2_state_code,
     iso_alpha2_state_name,
     iso_alpha3_state_code,
    state_name,
     entered,
     entered,
     enterer,
     enterer,
Line 78: Line 125:
     amender
     amender
FROM
FROM
     T00M06X00
     T00M08X00
</source>
</source>


Line 96: Line 143:
     amender
     amender
FROM
FROM
     T00M07X00
     T00M09X00
</source>
</source>


Line 112: Line 159:
     amender
     amender
FROM
FROM
     T00M08X00
     T00M10X00
</source>
</source>

Revision as of 09:56, 12 September 2019

Types

SELECT
    type_code,
    type_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M00X00

Tables

SELECT
    table_code,
    table_name,
    table_type,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M01X00

Forms

SELECT
    form_code,
    form_name,
    form_type,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M02X00

Reports

SELECT
    report_code,
    report_name,
    report_type,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M03X00

Fields

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

Labels

SELECT
    label_code,
    form_code,
    label_name,
    label_value,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M05X00
SELECT
    label_code,
    report_code,
    label_name,
    label_value,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M06X00

Languages

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

Countries

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

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
    T00M09X00
SELECT
    translated_code,
    translated_forms_code,
    translated_label_code,
    iso_alpha2_lingo_code,
    iso_alpha2_state_code,
    translated,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M10X00