Fields exported by S/4HANA Cloud ES

The following data fields are exported by Kofax AP Agility and passed to the S/4HANA Cloud ES ERP via the connector. They are exported by OData Post Request in JSON format.

Header level

  • SupplierInvoice (Invoice ID)

  • CompanyCode (Business Unit ID)

  • FiscalYear

  • PostingDate

  • DocumentDate (Invoice date)

  • SupplierInvoiceIDByInvcgParty

  • InvoicingParty (Vendor ID)

  • DocumentHeaderText (Invalid Reason)

  • InvoiceGrossAmount (invoice amount)

  • ManualCashDiscount (discount amount)

  • PaymentTerms

  • UnplannedDeliveryCost (Freight)

  • DocumentCurrency (Currency)

  • DueCalculationBaseDate

  • CashDiscount1Percent

  • CashDiscount1Day

  • CashDiscount2Percent

  • CashDiscount2Days

  • NetPaymentDays

  • PaymentBlockingReason

  • AccountingDocumentType (Document Type: Credit or not)

  • BPBankAccountInternalID

  • SupplierInvoiceStatus

    • Planned for background verification (background invoice verification)

    • Deleted (background and online invoice verification)

    • Contains errors (background invoice verification)

  • SupplierInvoiceStatus (continued)

    • Correct (posted, not complete) (background invoice verification)

    • Posted (background and online invoice verification)

    • Parked (online invoice verification)

    • Parked complete (online invoice verification)

    • Held parked (online invoice verification)

    • Held entered (online invoice verification)

    • Parked released (online invoice verification

  • IndirectQuotedExchangeRate

  • DirectQuotedExchangeRate

  • StateCentralBankPaymentReason

  • SupplyingCountry

  • PaymentMethod

  • PaymentMethodSupplement

  • PaymentReference

  • InvoiceReference

  • InvoiceReferenceFiscalYear

  • FixedCashDiscount

  • UnplannedDeliveryCostTaxCode

  • UnplndDelivCostTaxJurisdiction

  • UnplndDeliveryCostTaxCountry

  • AssignementReference

  • SupplierPostingLineItemText

  • TaxIsCalculatedAutomatically

  • BusinessPlace

  • BusinessSectionCode

  • BusinessArea

  • SupplierInvoiceIsCreditMemo

  • PaytSlipWthRefSubscriber

  • PaytSlipWthRefCheckDigit

  • PaytSlipWthRefReference

  • TaxDeterminationDate

  • TaxReportingDate

  • InvoiceReceiptDate (Scan date)

  • DeliveryOfGoodsReportingCntry

  • SupplierVATRegistration (Vendor VATRegNo)

  • IsEUTriangularDeal

  • SuplrInvcDebitCrdtCodeDelivery

  • SuplrInvcDebitCrdtCodeReturns

  • SupplierInvoiceOrigin

  • ReverseDocument

  • ReverseDocumentFiscalYear

  • IsReversal

  • IsReversed

  • to_SuplrInvcItemPurOrdRef (PO lines)

  • to_SupplierInvoiceItemGLAcct (GL accounts)

  • to_SupplierInvoiceTax (Tax set)

  • to_SupplierInvoiceWhldgTax (Withholding Tax set)

Line-item level, PO lines

  • SupplierInvoice

  • Fiscalyear

  • SupplierInvoiceItem

  • PurchaseOrder

  • PurchaseOrderItem

  • Plant

  • ReferenceDocument

  • ReferenceDocumentItem

  • IsSubsequentDebitCredit

  • TaxCode

  • TaxJurisdiction

  • DocumentCurrenct

  • SupplierInvoiceItemAmount

  • PurchaseOrderQuantityUnit

  • QuantityInPurchaseOrderUnit

  • PurchaseOrderPriceUnit

  • QtyInPurchaseOrderPriceUnit

  • SuplrInvcDeliveryCostCndnType

  • SuplrInvcDeliveryCostCndnStep

  • SuplrInvcDeliveryCostCndnCount

  • SupplierInvoiceItemText

  • FreightSupplier

  • IsNotCashDiscountLiable

  • PurchasingDocumentItemCategory

  • ProductType

  • ServiceEntrySheet

  • ServiceEntrySheetItem

  • TaxCountry

  • to_SupplierInvoiceItmAcctAssgmt

Line-item level, GL lines

  • WorkItem

  • DebitCreditCode

  • TaxJurisdiction

  • SupplierInvoiceItemText

  • AssignmentReference

  • IsNotCashDiscountLiable

  • InternalOrder

  • PersonnelNumber

  • ProjectNetwork

  • CommitmentItem

  • FundsCenter

  • TaxBaseAmountInTransCrcy

  • Fund

  • GrantID

  • QuantityUnit

  • Quantity

  • NetworkActivity

  • PartnerBusinessArea

  • TaxCode

  • DocumentCurrency

  • SupplierInvoice

  • FiscalYear

  • SupplierInvoiceItem

  • CompanyCode

  • CostCenter

  • ControllingArea

  • BusinessArea

  • SupplierInvoiceItemAmount

  • ProfitCenter

  • GLAccount

  • SalesOrder

  • SalesOrderItem

  • CostObject

  • CostCtrActivityType

  • BusinessProcess

  • WBSElement

  • FunctionalArea

  • TaxCountry