biuan SAP® BUSINESS ONE SDK
API AEC2
AEC2 - Electronic Transactions Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal IDInt
11
PRIMARYYes
CodeCodeVarChar
1OECM
Electronic Communication Types or Protocols
ActTypeAction TypeVarChar
S) Setup
R) Report
D) Document A/R
P) Document A/P
F) Draft
O) Other
K) Skip
C) Contingency
B) BP Check
1
ActDescAction DescriptionnVarChar
100
ActStatusAction StatusVarChar
N) New
P) Pending
E) Error
O) OK
S) Sent
R) Document Error
W) Waiting
A) Authorized
I) In Process
J) Rejected
D) Denied
C) Canceled
B) Aborted
Q) Queued
1
N
ActEnvAction Environment TypeInt
11OBNI
Brazil Numeric Indexer
-1
ActMessageAction MessagenVarChar
127
ActDataAction DataText
16
ObjectIDObject IDnVarChar
50
ReportIDReport IDnVarChar
50
BPLIdBranch IDInt
11OBPL
Business Place
-1
SrcObjTypeSource Object TypenVarChar
20
SrcObjAbsSource Object Internal IDInt
11
PeriodTypeReport Period TypeVarChar
Y) Year
Q) Quarter
M) Month
P) Period
1
PeriodNumReport Period NumberInt
11
YearReport YearInt
6
DateFromReport - Date FromDate
8
DateToReport - Date ToDate
8
SubmitsReport - Number of SubmissionsInt
6
DocBtchDocument BatchnVarChar
50
DocBtchLnDocument Batch LineInt
6
AssignedIDAssigned IDnVarChar
50
SendDateSend DateDate
8
ReceivDateReceived DateDate
8
UserSignUser SignatureInt
6OUSR
Users
CreateDateCreation DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
LogInstancLog InstanceInt
6
ActData2Action Data 2Text
16
IsRemovedIs RemovedVarChar
Y) Yes
N) No
1
N
CancelCancelationVarChar
Y) Yes
N) No
1
N
CreateTSCreatn Time - Incl. SecsInt
11
UpdateTSUpdate Full TimeInt
11
SendTSSend Time - Incl. SecsInt
11

Table relationship map

SELECT statement

SELECT AEC2.AbsEntry AS 'Internal ID', AEC2.Code AS 'Code', AEC2.ActType AS 'Action Type', AEC2.ActDesc AS 'Action Description', AEC2.ActStatus AS 'Action Status', AEC2.ActEnv AS 'Action Environment Type', AEC2.ActMessage AS 'Action Message', AEC2.ActData AS 'Action Data', AEC2.ObjectID AS 'Object ID', AEC2.ReportID AS 'Report ID', AEC2.BPLId AS 'Branch ID', AEC2.SrcObjType AS 'Source Object Type', AEC2.SrcObjAbs AS 'Source Object Internal ID', AEC2.PeriodType AS 'Report Period Type', AEC2.PeriodNum AS 'Report Period Number', AEC2.Year AS 'Report Year', AEC2.DateFrom AS 'Report - Date From', AEC2.DateTo AS 'Report - Date To', AEC2.Submits AS 'Report - Number of Submissions', AEC2.DocBtch AS 'Document Batch', AEC2.DocBtchLn AS 'Document Batch Line', AEC2.AssignedID AS 'Assigned ID', AEC2.SendDate AS 'Send Date', AEC2.ReceivDate AS 'Received Date', AEC2.UserSign AS 'User Signature', AEC2.CreateDate AS 'Creation Date', AEC2.UserSign2 AS 'Updating User', AEC2.UpdateDate AS 'Update Date', AEC2.LogInstanc AS 'Log Instance', AEC2.ActData2 AS 'Action Data 2', AEC2.IsRemoved AS 'Is Removed', AEC2.Cancel AS 'Cancelation', AEC2.CreateTS AS 'Creatn Time - Incl. Secs', AEC2.UpdateTS AS 'Update Full Time', AEC2.SendTS AS 'Send Time - Incl. Secs' FROM AEC2 AS AEC2

Related information


Brazil Numeric Indexer OBNI SQL Table

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