Locale: Difference between revisions

From Chorke Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
__NOTOC__
==Types==
==Types==
<source lang="sql">
<source lang="sql">
Line 12: Line 13:
</source>
</source>


==Objects==
{|
{|
| valign="top" |
| valign="top" |
==Tables==
===Tables===
<source lang="sql">
<source lang="sql">
SELECT
SELECT
Line 29: Line 31:


| valign="top" |
| valign="top" |
==Forms==
===Forms===
<source lang="sql">
<source lang="sql">
SELECT
SELECT
Line 44: Line 46:


| valign="top" |
| valign="top" |
==Reports==
===Reports===
<source lang="sql">
<source lang="sql">
SELECT
SELECT
Line 59: Line 61:
|}
|}


==Labels==
{|
{|
| valign="top" |
| valign="top" |
==Tables Fields==
===Fields===
<source lang="sql">
<source lang="sql">
SELECT
SELECT
Line 77: Line 80:


| valign="top" |
| valign="top" |
==Forms Labels==
===Forms===
<source lang="sql">
<source lang="sql">
SELECT
SELECT
Line 93: Line 96:


| valign="top" |
| valign="top" |
==Reports Labels==
===Reports===
<source lang="sql">
<source lang="sql">
SELECT
SELECT
Line 109: Line 112:
|}
|}


==Localizations==
{|
{|
| valign="top" |
| valign="top" |
==Languages==
===Languages===
<source lang="sql">
<source lang="sql">
SELECT
SELECT
Line 127: Line 131:


| valign="top" |
| valign="top" |
==Countries==
===Countries===
<source lang="sql">
<source lang="sql">
SELECT
SELECT
Line 171: Line 175:
     form_code,
     form_code,
     label_code,
     label_code,
     iso_alpha2_lingo,
     iso_alpha2_lingo,
     iso_alpha2_state,
     iso_alpha2_state,
Line 189: Line 194:
     report_code,
     report_code,
     label_code,
     label_code,
     iso_alpha2_lingo,
     iso_alpha2_lingo,
     iso_alpha2_state,
     iso_alpha2_state,

Revision as of 10:29, 12 September 2019

Types

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

Objects

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

Labels

Fields

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

Forms

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

Reports

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

Localizations

Languages

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

Countries

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

Translations

Tables

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

Forms

SELECT
    translated_code,
    form_code,
    label_code,

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

Reports

SELECT
    translated_code,
    report_code,
    label_code,

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