SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: ECM1
Table Description: Parameters for Various Types of Electronic Communication
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| Code |
Code |
nVarChar |
8 |
OECM |
|
|
|
| LineNum |
Row Number |
Int |
11 |
- |
|
|
|
| StrIndex |
String Index |
Int |
6 |
- |
|
|
|
| BPLId |
Branch ID |
Int |
11 |
OBPL |
-1 |
|
|
| ParamType |
Parameter Type |
nVarChar |
2 |
- |
TX |
TX |
General Text |
| |
|
|
|
|
|
TT |
Title |
| |
|
|
|
|
|
EM |
E-Mail |
| |
|
|
|
|
|
UR |
URI Address |
| |
|
|
|
|
|
SA |
Server Address |
| |
|
|
|
|
|
PT |
Path |
| |
|
|
|
|
|
FN |
File Name |
| |
|
|
|
|
|
LG |
Logic Value - Yes/No |
| |
|
|
|
|
|
NI |
Number - Integer |
| |
|
|
|
|
|
NR |
Number - Real |
| |
|
|
|
|
|
PW |
Password |
| |
|
|
|
|
|
OT |
Other |
| |
|
|
|
|
|
MP |
Mapping |
| |
|
|
|
|
|
GT |
Generation Type |
| |
|
|
|
|
|
CT |
Certificate |
| |
|
|
|
|
|
UQ |
User Queries Category |
| |
|
|
|
|
|
CB |
Combo Box |
| |
|
|
|
|
|
SP |
Separator |
| |
|
|
|
|
|
EF |
External Function |
| |
|
|
|
|
|
IU |
B1i Server URL |
| |
|
|
|
|
|
NM |
Money |
| |
|
|
|
|
|
LT |
Long General Text |
| ParamVisib |
Parameter is Visible |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ParamName |
Parameter Name |
nVarChar |
100 |
- |
|
|
|
| ParamValue |
Parameter Value |
Text |
16 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| UpdateDate |
Update Date |
Date |
8 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
6 |
- |
|
|
|
| ParamPrms |
Parameter Parameters |
nVarChar |
254 |
- |
|
|
|
| UIorder |
UI Order |
Int |
6 |
- |
|
|
|
| Type |
UI Type |
Int |
6 |
- |
|
|
|
| Key |
Unique |
Field |
| PRIMARY |
Yes |
Code |
| |
|
BPLId |
| |
|
LineNum |
| PARAM_NAME |
Yes |
Code |
| |
|
BPLId |
| |
|
ParamName |