| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | SLANGUAGE | Source language | char | 1 | 0 | LANG | (N' ') | No | * | SLANGUAGE | Allow NULL? |
| 2 | TLANGUAGE | Target language | char | 1 | 0 | LANG | (N' ') | No | * | TLANGUAGE | Allow NULL? |
| 3 | SHASH | Hash key of text in Proposal Pool, source language | nvarchar | 20 | 0 | CHAR | (N' ') | No | | TRMSHASH | Allow NULL? |
| 4 | STABID | ID of source lang. text table of Proposal Pool | char | 1 | 0 | NUMC | (N'0') | No | | TRMSTABID | Allow NULL? |
| 5 | SHASHCNFL | Hash conflict counter for Proposal Pool, source language | nvarchar | 3 | 0 | NUMC | (N'000') | No | | TRMSHASHCF | Allow NULL? |
| 6 | APPLIC | Application ID in Proposal Pool | nvarchar | 2 | 0 | CHAR | (N' ') | No | | TRMAPPLIC | Allow NULL? |
| 7 | NR | Numeric, 3-digit; Proposal Pool | nvarchar | 3 | 0 | NUMC | (N'000') | No | | TRMNUM3 | Allow NULL? |
| 8 | THASH | Hash key of text in Proposal Pool, target language | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | TRMTHASH | Allow NULL? |
| 9 | TTABID | ID of target language text table of Proposal Pool | char | 1 | 0 | NUMC | (N'0') | Yes | | TRMTTABID | Allow NULL? |
| 10 | THASHCNFL | Hash conflict counter for Proposal Pool, target language | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | TRMTHASHCF | Allow NULL? |
| 11 | ABBEXC | Flag: A = abbreviation, E = exception, B = both | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMABBEXC | Allow NULL? |
| 12 | SSTRLEN | Length of source lang. text string in Proposal Pool | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | TRMSSTRLEN | Allow NULL? |
| 13 | TSTRLEN | Length of text string in target language in Proposal Pool | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | TRMTSTRLEN | Allow NULL? |
| 14 | TRMSTATUS | Status of translation pair / translator | char | 1 | 0 | NUMC | (N'0') | Yes | | TRMSTATUS | Allow NULL? |
| 15 | DEVC | Application ID in Proposal Pool | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TRMAPPLIC | Allow NULL? |
| 16 | USAGECNT | Numeric, 3-digit; Proposal Pool | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | TRMNUM3 | Allow NULL? |
| 17 | APPLCNT | Application usage counter in Proposal Pool | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TRMAPPLCNT | Allow NULL? |
| 18 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UNAME | Allow NULL? |
| 19 | IDATE | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATUM | Allow NULL? |
| 20 | TRCONFLICT | ID: Translation conflict exists | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMCNFLICT | Allow NULL? |
| 21 | SYSSTDD | Translation pair valid system-wide | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMSYSSTDD | Allow NULL? |
| 22 | APPLSTDD | Translation pair valid application-wide | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMAPPLSTD | Allow NULL? |
| 23 | ABBR | Abbreviation ID: A = abbreviation, F = full text, B = both | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMABBR | Allow NULL? |
| 24 | ABBRFULLID | Numeric, 2-digit; Proposal Pool | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TRMNUM2 | Allow NULL? |
| 25 | ABBR_OK | Flag: Abbreviation assignment was confirmed, Proposal Pool | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMABBR_OK | Allow NULL? |
| 26 | STDD_OK | Flag: Hierarchy assignment was confirmed, Proposal Pool | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMSTDD_OK | Allow NULL? |
| 27 | AV_FLAG | Worklist flag for Proposal Pool | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMAVFLAG | Allow NULL? |
| 28 | FLAG1 | Flag 1 for Proposal Pool | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMFLAG1 | Allow NULL? |
| 29 | FLAG2 | Flag 2 for Proposal Pool | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMFLAG2 | Allow NULL? |
| 30 | FLAG3 | Flag 3 for Proposal Pool | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMFLAG3 | Allow NULL? |
| 31 | FLAG4 | Flag 4 for Proposal Pool | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMFLAG4 | Allow NULL? |
| 32 | FLAG5 | Flag 5 for Proposal Pool | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMFLAG5 | Allow NULL? |
| 33 | TRANSFERED | Flag: Translation transferred to Proposal Pool | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMTRANSF | Allow NULL? |