📚 SAP Business One SDK Help

Table Name: ECM2

Table Description: Electronic Transactions

Field Description Type Size Related Default Value Constraints
AbsEntry Internal ID Int 11 -      
Code Code nVarChar 8 OECM      
ParentID Parent ID Int 11 ECM2      
ActType Action Type Int 11 - 0 1 Setup
            2 Report
            3 A/R Document
            4 A/P Document
            5 A/R Draft Document
            6 A/P Draft Document
            7 Other
            8 Skip
            9 Contingency
            10 BP Check
            11 Incoming Payment
            12 Outgoing Payment
            13 Internal Reconciliation
            14 Transportation Document
            15 Inventory Transfer
            16 VAT Obligations
            17 VAT Declarations
            18 VAT Liabilities
            19 VAT Payments
            20 Delivery
            21 Return
            22 A/R Invoice
            23 A/R Credit Memo
            24 Goods Receipt PO
            25 Goods Return
            26 A/P Invoice
            27 A/P Credit Memo
            28 Draft Incoming Payment
            29 Draft Outgoing Payment
            30 Journal Entry
            31 E-Books Expense
            35 Company VAT Calendar
            36 Provisional VAT Returns
            37 Receipts for VAT Returns
            38 A/R Invoice
            39 A/R Credit Memo
            40 Delivery
            41 A/R Invoice Based on Delivery
            42 Series
            43 Invoices
            44 Goods Transfers
            45 Goods Issue
            46 Goods Receipt
            47 Pick List
            48 Draft Goods Issue
            49 Draft Goods Receipt
            50 Request CAEA
ActDesc Action Description nVarChar 100 -      
ActStatus Action Status VarChar 1 - N N New
            P Pending
            E Error
            T Temporary 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
            M Imported
            G Warning
            V Approved
            F Approving
            H Rejecting
            K Generated
            Y Ready to Process
            L Determined
            X Importing
            Z Response Updated
            i In Process to Intermediary
            s Sent to Intermediary
            v Approved by Intermediary
            g Not Integrated with Customer
            c Not Sent to Customer
            x Error Sending to Customer
            t Sent to Customer
            r Received by Customer
            j Rejected by Customer
            p Paid by Customer
            l Checking Integration Status
            o Not Approved
            e Reverse Charge
            u Continued
            f Further Objection
            a Cancelling
            n Continuing
            b Further Objection in Progress
            d Resending
            w Pending to CAEA
            k Queued
            z Updating Response
IsRemoved Is Removed VarChar 1 - N Y Yes
            N No
ActMessage Action Message nVarChar 254 -      
ActEnv Action Environment Type Int 11 OBNI -1    
BPLId Branch ID Int 11 OBPL -1    
Submits Report - Number of Submissions Int 6 -      
ObjectID Object ID nVarChar 50 -      
ReportID Report ID nVarChar 50 -      
SrcObjType Source Object Type nVarChar 20 -      
SrcObjAbs Source Object Internal ID Int 11 -      
Cancel Cancelation VarChar 1 - N Y Yes
            N No
AssignedID Assigned ID nVarChar 100 -      
DocBtch Document Batch nVarChar 50 -      
DocBtchLn Document Batch Line Int 6 -      
GenType Generation Type VarChar 1 - N N Not Relevant
            G Generate
            L Generate - Later
            F Generate - Offline
            S Send
            R Send - Later
TestMode Test Mode VarChar 1 - N N No
            Y Yes
PeriodType Report Period Type VarChar 1 -     Ignore
            Y Year
            Q Quarter
            M Month
            P Period
PeriodNum Report Period Number Int 11 -      
Year Report Year Int 6 -      
DateFrom Report - Date From Date 8 -      
DateTo Report - Date To Date 8 -      
UserSign User Signature Int 6 OUSR      
CreateDate Creation Date Date 8 -      
CreateTS Creation Time - Incl. Secs Int 11 -      
UserSign2 Updating User Int 6 OUSR      
UpdateDate Update Date Date 8 -      
UpdateTS Update Time - Incl. Secs Int 11 -      
LogInstanc Log Instance Int 6 -      
SchedJobID Scheduled Job ID Int 11 OBSJ      
GUID GUID nVarChar 100 -      
Authority Authority Code nVarChar 16 OPAC      
CancStatus Cancelation Status VarChar 1 - T T  
            N New Request
            S Request Sent
            A Approved
            R Rejected
            E Error
            C Canceled
            I In Process
            U Sent To Authorities
            W Canceled Without Approval
EDocType E-Doc Type Int 11 OUNCL      
EDocNum E-Doc Number nVarChar 100 -      
ProcTarget Processing Target/Source nVarChar 40 -      
Emergency Emergency VarChar 1 - N Y Yes
            N No
SttsReason Status Reason nVarChar 3 -   NON No Issues
            REF Incorrect references
            LEG Incorrect legal information
            REC Unknown receiver
            QUA Insufficient item quality
            DEL Issues with delivery
            PRI Incorrect prices
            QTY Incorrect quantity
            ITM Incorrect items
            PAY Incorrect payment terms
            UNR Not recognized
            FIN Incorrect financials
            PPD Partially Paid
            OTH Other
SttsDescr Status Description nVarChar 254 -      
Key Unique Field
PRIMARY Yes AbsEntry
ACTION Yes Code
    AbsEntry
DOCREF No SrcObjType
    SrcObjAbs
    Code
GUID Yes GUID