Locale: Difference between revisions
Jump to navigation
Jump to search
(→Fields) |
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 | ||
T00M03X00 | |||
</source> | </source> | ||
Line 24: | Line 66: | ||
amender | amender | ||
FROM | FROM | ||
T00M04X00 | |||
</source> | </source> | ||
== | ==Labels== | ||
<source lang="sql"> | <source lang="sql"> | ||
SELECT | SELECT | ||
label_code, | |||
form_code, | |||
label_name, | |||
label_value, | |||
entered, | entered, | ||
enterer, | enterer, | ||
Line 37: | Line 81: | ||
amender | amender | ||
FROM | FROM | ||
T00M05X00 | |||
</source> | </source> | ||
<source lang="sql"> | <source lang="sql"> | ||
SELECT | SELECT | ||
label_code, | label_code, | ||
report_code, | |||
label_name, | label_name, | ||
label_value, | label_value, | ||
Line 52: | Line 95: | ||
amender | amender | ||
FROM | FROM | ||
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_alpha3_lingo_code, | |||
lingo_name, | |||
entered, | entered, | ||
enterer, | enterer, | ||
Line 65: | Line 110: | ||
amender | amender | ||
FROM | FROM | ||
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_alpha3_state_code, | |||
state_name, | |||
entered, | entered, | ||
enterer, | enterer, | ||
Line 78: | Line 125: | ||
amender | amender | ||
FROM | FROM | ||
T00M08X00 | |||
</source> | </source> | ||
Line 96: | Line 143: | ||
amender | amender | ||
FROM | FROM | ||
T00M09X00 | |||
</source> | </source> | ||
Line 112: | Line 159: | ||
amender | amender | ||
FROM | FROM | ||
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