biuan SAP® BUSINESS ONE SDK
API AEC1
AEC1 - Parameters for Various Types of Electronic Communication Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodeVarChar
1OECM
Electronic Communication Types or Protocols
PRIMARYYes
LineNumRow NumberInt
11
StrIndexString IndexInt
6
BPLIdBranch IDInt
11OBPL
Business Place
-1
ParamTypeParameter TypenVarChar
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
2
TX
ParamVisibParameter is VisibleVarChar
Y) Yes
N) No
1
Y
ParamNameParameter NamenVarChar
100
ParamValueParameter ValueText
16
UserSignUser SignatureInt
6OUSR
Users
CreateDateCreation DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
LogInstancLog InstanceInt
6

Table relationship map

SELECT statement

SELECT AEC1.Code AS 'Code', AEC1.LineNum AS 'Row Number', AEC1.StrIndex AS 'String Index', AEC1.BPLId AS 'Branch ID', AEC1.ParamType AS 'Parameter Type', AEC1.ParamVisib AS 'Parameter is Visible', AEC1.ParamName AS 'Parameter Name', AEC1.ParamValue AS 'Parameter Value', AEC1.UserSign AS 'User Signature', AEC1.CreateDate AS 'Creation Date', AEC1.UserSign2 AS 'Updating User', AEC1.UpdateDate AS 'Update Date', AEC1.LogInstanc AS 'Log Instance' FROM AEC1 AS AEC1

Related information


Business Place OBPL SQL Table

Electronic Communication Types or Protocols OECM SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates