Posted Approval Entry

    API Details

    Property Value
    Endpoint /tablesFinance/postedApprovalEntries
    Table name Posted Approval Entry
    Table id 456
    Table caption Posted Approval Entry
    Data per company True
    Group Finance

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    tableID Table ID Integer 4
    documentNo Document No. Code 20
    sequenceNo Sequence No. Integer 4
    approvalCode Approval Code Code 20
    senderID Sender ID Code 50 User
    salespersPurchCode Salespers./Purch. Code Code 20
    approverID Approver ID Code 50 User
    status Status Option 4 Created, Open, Canceled, Rejected, Approved,
    dateTimeSentForApproval Date-Time Sent for Approval DateTime 8
    lastDateTimeModified Last Date-Time Modified DateTime 8
    lastModifiedByID Last Modified By ID Code 50 User
    dueDate Due Date Date 4
    amount Amount Decimal 12
    amountLCY Amount (LCY) Decimal 12
    currencyCode Currency Code Code 10 Currency
    approvalType Approval Type Option 4 Workflow User Group, Sales Pers./Purchaser, Approver, Specific, Project, Order, Manual, System
    limitType Limit Type Option 4 Approval Limits, Credit Limits, Request Limits, No Limits
    availableCreditLimitLCY Available Credit Limit (LCY) Decimal 12
    postedRecordID Posted Record ID RecordID 448
    delegationDateFormula Delegation Date Formula DateFormula 32
    numberOfApprovedRequests Number of Approved Requests Integer 4
    numberOfRejectedRequests Number of Rejected Requests Integer 4
    iterationNo Iteration No. Integer 4
    entryNo Entry No. Integer 4 *
    checkAutoApprove Check Auto Approve Boolean 4
    approvedBy Approved By Code 50 User
    originalApproverCode Original Approver Code Code 50 User
    approvalLimit Amount Approval Limit Decimal 12
    approvalLevel Approval Level Integer 4
    unlimitedApproval Unlimited Approval Boolean 4
    sufficientLimit Sufficient Limit Boolean 4
    invoiceTypePurchase Invoice Type (Purchase) Option 4 , Maintenance, , Settlement, , , , , , , , , , , , , , , , Repurchase
    projectsoort Projectsoort Option 4 Project, Planmatig, Niet planmatig, Standard
    approvalReason Approval Reason Text 250
    companyName Company Name Text 80
    autoApprove Auto Approve When Procuration is OK. Boolean 4
    orderMatchApproval Order Match Approval Boolean 4
    randomVendorCheck Random Vendor Check Boolean 4
    maintOrderCommitment Maint. Order Commitment Decimal 12
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User
    lastModifiedDateTime Last Modified Date Time DateTime 8