| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | Code | Code | nvarchar | 8 | 0 | OECM | | | Allow NULL? |
| 2 | LineNum | Row Number | int | 11 | 0 | | | | Allow NULL? |
| 3 | StrIndex | String Index | int | 6 | 0 | | | | Allow NULL? |
| 4 | BPLId | Branch ID | int | 11 | 0 | OBPL | -1 | | Allow NULL? |
| 5 | ParamType | Parameter Type | nvarchar | 2 | 0 | | TX | CB=Combo Box, CT=Certificate, EF=External Function, EM=E-Mail, FN=File Name, GT=Generation Type, LG=Logic Value - Yes/No, MP=Mapping, NI=Number - Integer, NR=Number - Real, OT=Other, PT=Path, PW=Password, SA=Server Address, SP=Separator, TT=Title, TX=General Text, UQ=User Queries Category, UR=URI Address | Allow NULL? |
| 6 | ParamVisib | Parameter is Visible | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 7 | ParamName | Parameter Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 8 | ParamValue | Parameter Value | text | 16 | 0 | | | | |
| 9 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 10 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 11 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 12 | UpdateDate | Update Date | date | 8 | 0 | | | | |
| 13 | LogInstanc | Log Instance | int | 6 | 0 | | | | Allow NULL? |
| 14 | ParamPrms | Parameter Parameters | nvarchar | 254 | 0 | | | | Allow NULL? |
| 15 | UIorder | UI Order | int | 6 | 0 | | | | Allow NULL? |
| 16 | Type | UI Type | int | 6 | 0 | | | | Allow NULL? |