Locale: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 3: | Line 3: | ||
SELECT | SELECT | ||
table_code, | table_code, | ||
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 | ||
T00M05X00 | |||
</source> | </source> | ||
Line 50: | Line 78: | ||
amender | amender | ||
FROM | FROM | ||
T00M06X00 | |||
</source> | </source> | ||
Line 68: | Line 96: | ||
amender | amender | ||
FROM | FROM | ||
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