FISCAL Technologies

Transaction field mappings by finance system

Updated

FISCAL is designed to be compatible with all accounting systems. While the field mappings provided below reflect our extensive experience, as accounting systems are often subject to organisation-specific customisations, these mappings may require adjustment to align with your particular implementation. 

We welcome any additional or alternative field mappings you can provide for the accounting systems listed or for any systems not currently documented.

Our mapping documentation is continuously evolving. Should you identify any missing or incorrect field mappings within your accounting system, we encourage you to contact us so that we can update our documentation accordingly.

Finance Systems

Cedar e-Financials:

FISCAL Field (* = mandatory) Table Field
Unique ID* sub_ledger_trans slt_ref
Invoice Number* sub_ledger_trans slt_their_ref
Invoice Amount* sub_ledger_trans slt_gross_amount
Invoice Amount Currency sub_ledger_trans slt_unit
Base Amount* sub_ledger_trans slt_gross_amount
 Base Amount Currency    
Description sub_ledger_trans slt_description
PO Number sub_ledger_trans slm_order_no
 Invoice / Payment Status    
Invoice Date* sub_ledger_trans slt_date
Received Date sub_ledger_trans slt_received_date
Entered Date* sub_ledger_trans slt_entry_date
Due Date    
Paid Date sub_ledger_trans slt_date_paid
Payment Cleared Date    
Payment Type sub_ledger_trans slt_trans_type
Supplier Name* sub_ledger_trans na_name
Supplier Ref* sub_ledger_trans slt_supplier
Site Ref    
User ID sub_ledger_trans slt_user
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date    

Infor M3:

FISCAL Field (* = mandatory) Table Field
Unique ID* FPLEDG ePVONO
Invoice Number* FPLEDG EPSINO
Invoice Amount* FPLEDG EPCUAM
Invoice Amount Currency FPLEDG EPCUCD
Base Amount* FPLEDG EPCUAM
 Base Amount Currency    
Description FPLEDG EPTDSC
PO Number    
 Invoice / Payment Status    
Invoice Date* FPLEDG EPIVDT
Received Date    
Entered Date* FPLEDG EPRGDT
Due Date    
Paid Date    
Payment Cleared Date    
Payment Type FPLEDG EPPTYP
Supplier Name* CIDADR SASUNM
Supplier Ref* FPLEDG EPSUNO
Site Ref    
User ID FPLEDG EPCHID
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date    

Integra:

FISCAL Field (* = mandatory) Table Field
Unique ID* PRLREGHED REF
Invoice Number* PRLREGHED SUPP_OWN_REF
Invoice Amount* PRLREGHED TOT_VALUE
Invoice Amount Currency    
Base Amount*    
 Base Amount Currency    
Description PRLREGHED NARRATIVE
PO Number PRLREGHED PO_NUMBER
 Invoice / Payment Status    
Invoice Date* PRLREGHED DOC_DATE
Received Date PRLREGHED RECEIVED_DATE
Entered Date* PRLREGHED DATE_REG
Due Date    
Paid Date PRLREGHED CLEARED_DATE
Payment Cleared Date    
Payment Type    
Supplier Name* PRLLEDSUP_1 SUPP_NAME
Supplier Ref* PRLREGHED SUPPLIER
Site Ref    
User ID PRLREGHED WHO_SETUP
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date    

JD Edwards:

FISCAL Field (* = mandatory) Table Field
Unique ID* F0411 RPDOC
Invoice Number* F0411 RPVINV
Invoice Amount* F0411 RPAG
Invoice Amount Currency F0411 RPCRCD
Base Amount* F0411 RPACR
 Base Amount Currency    
Description F0411 RPRMK
PO Number F0411 RPPO
 Invoice / Payment Status    
Invoice Date* F0411 RPFIVJ
Received Date    
Entered Date* F0411 RPDICJ
Due Date    
Paid Date    
Payment Cleared Date    
Payment Type F0411 RPPYIN
Supplier Name* F0101 ABALPH
Supplier Ref* F0411 RPAN8
Site Ref    
User ID F0411 RPTORG
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date    

Microsoft Dynamics AX

FISCAL Field (* = mandatory) Table Field
Unique ID*    
Invoice Number* vendTrans Invoice
Invoice Amount* vendTrans AmountCur
Invoice Amount Currency vendTrans CurrencyCode
Base Amount* vendTrans AmountCur
 Base Amount Currency    
Description vendTrans Txt
PO Number vendTrans TaxInvoicePurchId
 Invoice / Payment Status    
Invoice Date* vendTrans DocumentDate
Received Date    
Entered Date* vendTrans TransDate
Due Date    
Paid Date vendTrans LastSettleDate
Payment Cleared Date    
Payment Type    
Supplier Name* vendTable Name
Supplier Ref* vendTrans AccountNum
Site Ref    
User ID transLog CreatedBy
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date    

Microsoft Dynamics 365

FISCAL Field (* = mandatory) Table Field
Unique ID* vendTrans Voucher
Invoice Number* vendTrans Invoice
Invoice Amount* vendTrans AmountCur
Invoice Amount Currency vendTrans CurrencyCode
Base Amount* vendTrans ReportingCurrencyAmount
 Base Amount Currency    
Description vendTrans Txt
PO Number   PurchNum or PurchId
 Invoice / Payment Status   InvoiceStatus
Invoice Date* vendTrans DocumentDate
Received Date   InvoiceReceivedDate
Entered Date* vendTrans TransDate
Due Date vendTrans DueDate
Paid Date vendTrans LastSettleDate or ClosedDate
Payment Cleared Date    
Payment Type vendTable PaymMode
Supplier Name* vendTable Name
Supplier Ref* vendTrans AccountNum
Site Ref    
User ID SysDataBaseLog CreatedBy
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date    

Navision

FISCAL Field (* = mandatory) Table Field
Unique ID* Purch* Inv* Header / Purch* Cr* Memo Hdr_ No_
Invoice Number* Purch* Inv* Header / Purch* Cr* Memo Hdr_ Vendor Invoice No_
Invoice Amount* Purch* Inv* Line / Purch* Cr* Memo Line Amount Including VAT
Invoice Amount Currency Purch* Inv* Header / Purch* Cr* Memo Hdr_ Currency Code
Base Amount* Purch* Inv* Line / Purch* Cr* Memo Line (1) <br/> Purch* Inv* Header / Purch* Cr* Memo Hdr_(2) Calculated value: (1).Amount Including VAT / (2).Currency Factor
 Base Amount Currency    
Description Purch* Inv* Line / Purch* Cr* Memo Line  
PO Number    
 Invoice / Payment Status    
Invoice Date* Purch* Inv* Header / Purch* Cr* Memo Hdr_ Document Date
Received Date    
Entered Date* Purch* Inv* Header / Purch* Cr* Memo Hdr_ Posting Date
Due Date    
Paid Date    
Payment Cleared Date Purch* Inv* Header / Purch* Cr* Memo Hdr_ Payment Method Code
Payment Type Purch* Inv* Header / Purch* Cr* Memo Hdr_ Buy-from Vendor Name
Supplier Name* Purch* Inv* Header / Purch* Cr* Memo Hdr_ Buy-from Vendor No_
Supplier Ref*    
Site Ref Purch* Inv* Header / Purch* Cr* Memo Hdr_ User ID
User ID    
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date    

Oracle R12

FISCAL Field (* = mandatory) Table Field
Unique ID* AP_INVOICES_ALL invoice_id
Invoice Number* AP_INVOICES_ALL invoice_num
Invoice Amount* AP_INVOICES_ALL invoice_amount
Invoice Amount Currency AP_INVOICES_ALL invoice_currency_code
Base Amount* AP_INVOICES_ALL base_amount
 Base Amount Currency    
Description AP_INVOICES_ALL description
PO Number AP_INVOICES_ALL PO_HEADER_ID
 Invoice / Payment Status    
Invoice Date* AP_INVOICES_ALL invoice_date
Received Date AP_INVOICES_ALL INVOICE_RECEIVED_DATE
Entered Date* AP_INVOICES_ALL creation_date
Due Date AP_INVOICES_ALL TERMS_DATE
Paid Date AP_INVOICES_ALL Paymentdate
Payment Cleared Date    
Payment Type AP_INVOICES_ALL payment_method_code
Supplier Name* AP_SUPPLIERS vendor_name
Supplier Ref*    
Site Ref AP_INVOICES_ALL vendor_id
User ID AP_INVOICES_ALL CREATED_BY
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date    

Oracle Fusion

FISCAL Field (* = mandatory) Table Field
Unique ID* AP_INVOICES_ALL invoice_id
Invoice Number* AP_INVOICES_ALL invoice_num
Invoice Amount* AP_INVOICES_ALL invoice_amount
Invoice Amount Currency AP_INVOICES_ALL invoice_currency_code
Base Amount* AP_INVOICES_ALL base_amount
 Base Amount Currency    
Description AP_INVOICES_ALL description
PO Number AP_INVOICES_ALL PO_HEADER_ID
 Invoice / Payment Status    
Invoice Date* AP_INVOICES_ALL invoice_date
Received Date AP_INVOICES_ALL INVOICE_RECEIVED_DATE
Entered Date* AP_INVOICES_ALL creation_date
Due Date AP_INVOICE_PAYMENT_SCHEDULES_ALL DUE_DATE
Paid Date AP_INVOICES_ALL Paymentdate
 VAT Amount Paid AP_INVOICES_ALL TOTAL_TAX_AMOUNT
Payment Cleared Date    
Payment Type AP_INVOICES_ALL payment_method_code
Supplier Name* POZ_SUPPLIERS_V vendor_name
Supplier Ref* POZ_SUPPLIERS_V SEGMENT1
Site Ref AP_SUPPLIER_SITES_ALL VENDOR_SITE_CODE
 SupplierType POZ_SUPPLIERS_V VENDOR_TYPE_LOOKUP_CODE
User ID AP_INVOICES_ALL CREATED_BY
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date AP_INVOICES_ALL LAST_UPDATE_DATE

PS Financials

FISCAL Field (* = mandatory) Table Field
Unique ID* D_DETAILS DOCNUM
Invoice Number* D_DETAILS OriginalDescription
Invoice Amount* D_DETAILS VALUE
Invoice Amount Currency    
Base Amount* D_DETAILS VALUE
 Base Amount Currency    
Description D_DETAILS Description
PO Number MP_DOCUMENT SOURCEREF
 Invoice / Payment Status    
Invoice Date* D_DETAILS DOCDATE
Received Date D_DETAILS INPUTDATE
Entered Date* D_DETAILS INPUTDATE
Due Date M_PAYLIST MEDIADATE
Paid Date M_PAYLIST DOCDATE
Payment Cleared Date    
Payment Type    
Supplier Name* M_ACCOUNT Title
Supplier Ref* D_DETAILS Account
Site Ref    
User ID MP_DOCUMENT or MP_DOCEVENT USERID
Scanned Image D_ATTACHMENTS FILE_PATH
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date    

SAP

FISCAL Field (* = mandatory) Table Field
Unique ID* BSIK/BSAK BELNR & GJAHR & BUKRS** 
Invoice Number* BSIK/BSAK XBLNR
Invoice Amount* BSIK/BSAK WRBTR
Invoice Amount Currency BKPF WAERS
Base Amount* BSIK/BSAK DMBTR
 Base Amount Currency    
Description BSIK/BSAK SGTXT
PO Number BSIK/BSAK EBELN
 Invoice / Payment Status    
Invoice Date* BSIK/BSAK BLDAT
Received Date BKPF REINDAT
Entered Date* BSIK/BSAK CPUDT
Due Date    
Paid Date BSIK/BSAK AUGDT
Payment Cleared Date    
Payment Type BSIK/BSAK ZLSCH
Supplier Name* LFA1 NAME1
Supplier Ref* BSIK/BSAK LIFNR
Site Ref    
User ID BKPF USNAM
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date

BKPF

BSAK

AEDAT***

AUGDT***
  • BSIK - for open transactions
  • BSAK - for closed transactions
  • ** This is a composite key, we recommend you separate each element with a hyphen
  • *** The transaction change date does not update when a record is paid, so a rule based on Changed On and Clearing Date is required to ensure the Modified date is correct

SAGE 500/1000

FISCAL Field (* = mandatory) Table Field
Unique ID*    
Invoice Number* scheme.plitemextm or scheme.plitemm payment_reference or item
Invoice Amount*   currency_amount
Invoice Amount Currency scheme.plitemm currency
Base Amount*    
 Base Amount Currency    
Description    
PO Number   reference
 Invoice / Payment Status    
Invoice Date*   dated
Received Date   userdate
Entered Date*   userdate
Due Date    
Paid Date scheme.plxrefm allocated_date
Payment Cleared Date    
Payment Type scheme.plitemcm or scheme.plsuppm Derived value: use scheme.plitemcm.payment_type or if blank use scheme.plsuppm.pay_type (see below)
Supplier Name* scheme.plsuppm Name
Supplier Ref* scheme.plitemm supplier
Site Ref    
User ID   username
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date    

Payment Type:

  • Value = ‘B' return 'BACS'
  • Value = 'C' return 'CHEQUE'
  • Value = 'T' return 'TRANSFER'
  • Value = 'M' return 'MANUAL'
  • Value = 'P' return 'PMGO'

Unit4

FISCAL Field (* = mandatory) Table Field
Unique ID* asutrans/ asuhist (current / historic) combination of voucher_no and sequence_no
Invoice Number* asutrans/ asuhist ext_inv_ref
Invoice Amount* asutrans/ asuhist Amount
Invoice Amount Currency asutrans/ asuhist currency
Base Amount* asutrans/ asuhist Amount
 Base Amount Currency    
Description asutrans/ asuhist description
PO Number asutrans/ asuhist order_id
 Invoice / Payment Status    
Invoice Date* asutrans/ asuhist voucher_date
Received Date asutrans/ asuhist arrival_date
Entered Date* asutrans/ asuhist trans_date
Due Date asutrans/ asuhist due_date
Paid Date asutrans/ asuhist payment_date
Payment Cleared Date    
Payment Type asutrans/ asuhist pay_method
Supplier Name* asutrans/ asuhist apar_name
Supplier Ref* asutrans/ asuhist apar_id
Site Ref    
User ID asutrans/ asuhist user_id
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date    

Yardi

FISCAL Field (* = mandatory) Table Field
Unique ID*    
Invoice Number* trans uref
Invoice Amount* trans stotalamount
Invoice Amount Currency trans Derived value from field trancurrency (see below)
Base Amount* trans stotalamount
 Base Amount Currency    
Description trans Snotes
PO Number mm2po Pocode
 Invoice / Payment Status    
Invoice Date* trans sdateoccurred
Received Date    
Entered Date* trans sdatecreated
Due Date    
Paid Date trans sdateoccurred
Payment Cleared Date    
Payment Type trans Derived Value from field BACH (see below)
Supplier Name*    
Supplier Ref* vendor ucode
Site Ref    
User ID pmuser Uname
Scanned Image    
 Org Group Ref    
 Org Group Name    
 ERP ID    
Modified Date    

Invoice Currency examples:

  • trancurrency = 1 return 'AUD'
  • trancurrency = 2 return 'NZD'
  • trancurrency = 3 return 'EUR'
  • trancurrency = 4 return 'USD'

Payment Type examples:

  • BACH = -1 return 'EFT'
  • Otherwise return 'Check'