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)

      • 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