Projects:Translation Management/Development/Language Creation
Language Creation and Definition Documentation
This page is for the iteration covering language creation and definition as part of the Translation Management project. You will find information and design decisions regarding this user story here.
WAD
Language Table Schema
Name
| Primary Key
| Type
| Length
| Required
| Default Value
| Constraint
|
AD_LANGUAGE_ID
| *
| VARCHAR
| 32
| true
|
| UNIQUE
|
AD_CLIENT_ID
|
| VARCHAR
| 32
| true
| 0 = System
| FOREIGNKEY - AD_CLIENT
|
AD_ORG_ID
|
| VARCHAR
| 32
| true
| 0 = *
| FOREIGNKEY - AD_ORG
|
ISACTIVE
|
| CHAR
| 1
| true
| N
| ISACTIVE IN ('Y', 'N')
|
CREATED
|
| TIMESTAMP
| 7
| true
| SYSDATE
|
|
CREATEDBY
|
| VARCHAR
| 32
| true
|
| FOREIGNKEY - AD_USER
|
UPDATED
|
| TIMESTAMP
| 7
| true
| SYSDATE
|
|
UPDATEDBY
|
| VARCHAR
| 32
| true
|
| FOREIGNKEY - AD_USER
|
NAME
|
| VARCHAR
| 15
| true
| ISOCODE_TRANSLATIONVERSION
| UNIQUE
|
AD_LANGUAGE
|
| VARCHAR
| 32
| true
|
| FOREIGNKEY - AD_ISO_LANGUAGE_COUNTRY
|
ISOCODE
|
| VARCHAR
| 5
| true
|
|
|
TRANSLATIONVERSION
|
| VARCHAR
| 10
| false
|
|
|
ISBASELANGUAGE
|
| CHAR
| 1
| true
| N
| ISACTIVE IN ('Y', 'N')
|
ISSYSTEMLANGUAGE
|
| CHAR
| 1
| true
| N
| ISACTIVE IN ('Y', 'N')
|
ISMULTILANGUAGESUPPORT
|
| CHAR
| 1
| true
| N
| ISACTIVE IN ('Y', 'N')
|
STATUS
|
| VARCHAR
| 30
| false
|
|
|
STATISTICS
|
| VARCHAR
| 100
| false
|
|
|
TRANSLATEDBY
|
| VARCHAR
| 255
| false
|
|
|
ISO Country Table Schema
Name
| Primary Key
| Type
| Length
| Required
| Default Value
| Constraint
|
AD_COUNTRY_ID
| *
| VARCHAR
| 32
| true
|
| UNIQUE
|
AD_CLIENT_ID
|
| VARCHAR
| 32
| true
| 0 = System
| FOREIGNKEY - AD_CLIENT
|
AD_ORG_ID
|
| VARCHAR
| 32
| true
| 0 = *
| FOREIGNKEY - AD_ORG
|
ISACTIVE
|
| CHAR
| 1
| true
| N
| ISACTIVE IN ('Y', 'N')
|
CREATED
|
| TIMESTAMP
| 7
| true
| SYSDATE
|
|
CREATEDBY
|
| VARCHAR
| 32
| true
|
| FOREIGNKEY - AD_USER
|
UPDATED
|
| TIMESTAMP
| 7
| true
| SYSDATE
|
|
UPDATEDBY
|
| VARCHAR
| 32
| true
|
| FOREIGNKEY - AD_USER
|
NAME
|
| VARCHAR
| 100
| true
|
|
|
ISO2LETTERCODE
|
| VARCHAR
| 2
| true
|
| UNIQUE
|
ISO Language Table Schema
Name
| Primary Key
| Type
| Length
| Required
| Default Value
| Constraint
|
AD_LANGUAGE_ID
| *
| VARCHAR
| 32
| true
|
| UNIQUE
|
AD_CLIENT_ID
|
| VARCHAR
| 32
| true
| 0 = System
| FOREIGNKEY - AD_CLIENT
|
AD_ORG_ID
|
| VARCHAR
| 32
| true
| 0 = *
| FOREIGNKEY - AD_ORG
|
ISACTIVE
|
| CHAR
| 1
| true
| N
| ISACTIVE IN ('Y', 'N')
|
CREATED
|
| TIMESTAMP
| 7
| true
| SYSDATE
|
|
CREATEDBY
|
| VARCHAR
| 32
| true
|
| FOREIGNKEY - AD_USER
|
UPDATED
|
| TIMESTAMP
| 7
| true
| SYSDATE
|
|
UPDATEDBY
|
| VARCHAR
| 32
| true
|
| FOREIGNKEY - AD_USER
|
NAME
|
| VARCHAR
| 100
| true
|
|
|
ISO2LETTERCODE
|
| VARCHAR
| 2
| true
|
| UNIQUE
|
ISO Language Country Table Schema
Name
| Primary Key
| Type
| Length
| Required
| Default Value
| Constraint
|
AD_LANGUAGE_COUNTRY_ID
| *
| VARCHAR
| 32
| true
|
| UNIQUE
|
AD_CLIENT_ID
|
| VARCHAR
| 32
| true
| 0 = System
| FOREIGNKEY - AD_CLIENT
|
AD_ORG_ID
|
| VARCHAR
| 32
| true
| 0 = *
| FOREIGNKEY - AD_ORG
|
ISACTIVE
|
| CHAR
| 1
| true
| N
| ISACTIVE IN ('Y', 'N')
|
CREATED
|
| TIMESTAMP
| 7
| true
| SYSDATE
|
|
CREATEDBY
|
| VARCHAR
| 32
| true
|
| FOREIGNKEY - AD_USER
|
UPDATED
|
| TIMESTAMP
| 7
| true
| SYSDATE
|
|
UPDATEDBY
|
| VARCHAR
| 32
| true
|
| FOREIGNKEY - AD_USER
|
NAME
|
| VARCHAR
| 200
| true
|
|
|
ISOCODE
|
| VARCHAR
| 5
| true
|
| UNIQUE
|
AD_ISO_COUNTRY_ID
|
| VARCHAR
| 32
| true
|
| FOREIGNKEY - AD_ISO_COUNTRY
|
AD_ISO_LANGUAGE_ID
|
| VARCHAR
| 32
| true
|
| FOREIGNKEY - AD_ISO_LANGUAGE
|
Code
Callouts
The following artifacts have been created in the package org.openbravo.erpCommon.ad_callouts.
- SL_Language_Name.java
- SL_Language_Name_Data.xsql
- SL_ISO_Language_Name
- SL_ISO_Language_Name_Data.xsql