Page Comparison

...

Field name

Description

Primary Information

Name

Enter a name for your FlowAP Template.

Lookup Criteria

Vendor Lookup Criteria

This field should contain an array of JSON objects that would be used as criteria for searching the Vendor for the FlowAP Document. You can enter a maximum of 8 15 criteria and a minimum of 1.

Expand

title	Default

Code Block

language	json

{


        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]",


            "nsfield": "vatregnumber",

"regexp": "[^a-zA-Z0-9]"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"GLN\"]",
"nsfield": "vatregnumber",
"regexp": "[^a-zA-Z0-9]"
},
{
"xpath":


            "regexp": "[^0-9]",
            "operator": "contains"
        },
        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/

cbc:EndpointID",

cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]",
            "nsfield": "custentity_sta_

flowap

einv_

endpointid

businessid"

},
{
"xpath": "//cac:PaymentMeans/cac:PayeeFinancialAccount/cbc:ID[../../cbc:PaymentChannelCode/text()=\"IBAN\"]",
"nsfield": "custrecord_2663_parent_vendor.custrecord_2663_entity_iban"
},
{
"xpath": "//cac:PaymentMeans/cac:PayeeFinancialAccount/cbc:ID[../../cbc:PaymentChannelCode/text()=\"BBAN\"]",
"nsfield": "custrecord_2663_parent_vendor.custrecord_2663_entity_bban"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyLegalEntity/cbc:RegistrationName",
"nsfield": "legalname"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name",
"nsfield": "entityid"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name",
"nsfield": "entityid"
}
]

Item Lookup Criteria

This field should contain an array of JSON objects that would be used as criteria for searching the Item for the FlowAP Document. You can enter a maximum of 5 criteria.

Expand

title	Default

[
{
"mappingfield": "vendorcode",
"nsfield": "vendorcode"
},
{
"mappingfield": "vendorcode",
"nsfield": "vendorname"
}
]

Mapping Templates

Transaction Mapping

Enter the mapping for the Transaction Header and Lines in a well-formed JSON object.

Expand

title	Default

{
"custentity_edoc_ws_id": {
"xpath" : ["/cac:OrderReference/cbc:CustomerReference"]
},
"vendorname": {
"xpath": ["/cac:AccountingSupplierParty/cac:Party/cac:PartyName"]
},
"vendorvat": {
"xpath":

,
            "regexp": "[^0-9]",
            "operator": "contains"
        },
        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"ISO6523\"]",
            "nsfield": "vatregnumber",
            "regexp": "[^0-9]",
            "operator": "contains"
        },
        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"ISO6523\"]",
            "nsfield": "custentity_sta_einv_businessid",
            "regexp": "[^0-9]",
            "operator": "contains"
        },
        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID",
            "nsfield": "vatregnumber",
            "regexp": "[^0-9]",
            "operator": "contains"
        },
        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID",
            "nsfield": "custentity_sta_einv_businessid",
            "regexp": "[^0-9]",
            "operator": "contains"
        },
        {
            "legacy": true,
            "xpath": "//cac:OrderReference/cbc:CustomerReference",
            "nsfield": "custentity_sta_flowap_endpointid",
            "regexp": "[^0-9]",
            "operator": "contains"
        },
        {
            "xpath": "//cac:OrderReference/cbc:CustomerReference",
            "nsfield": "custentity_sta_flowap_endpointid",
            "regexp": "[^0-9]",
            "operator": "contains"
        },
        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/cbc:EndpointID",
            "nsfield": "custentity_sta_flowap_endpointid",
            "operator": "contains"
        },
        {
            "xpath": "//cac:PaymentMeans/cac:PayeeFinancialAccount/cbc:ID[../../cbc:PaymentChannelCode/text()=\"IBAN\"]",
            "nsfield": "custrecord_2663_parent_vendor.custrecord_2663_entity_iban"
        },
        {
            "xpath": "//cac:PaymentMeans/cac:PayeeFinancialAccount/cbc:ID[../../cbc:PaymentChannelCode/text()=\"BBAN\"]",
            "nsfield": "custrecord_2663_parent_vendor.custrecord_2663_entity_bban"
        },
        {
            "xpath": "//cac:PaymentMeans/cac:PayeeFinancialAccount/cbc:ID",
            "nsfield": "custrecord_2663_parent_vendor.custrecord_2663_customer_code"
        },
        {
            "xpath": "//cac:PaymentMeans/cac:PayeeFinancialAccount/cbc:ID",
            "nsfield": "accountnumber"
        },
        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyLegalEntity/cbc:RegistrationName",
            "nsfield": "legalname"
        },
        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name",
            "nsfield": "entityid"
        }
]

Item Lookup Criteria

This field should contain an array of JSON objects that would be used as criteria for searching the Item for the FlowAP Document. You can enter a maximum of 5 criteria and a minimum of 1.

Expand

title	Default

Code Block

language	json

[
        {
            "mappingfield": "vendorcode",
            "nsfield": "vendorcode"
        },
        {
            "mappingfield": "vendorcode",
            "nsfield": "vendorname"
        },
        {
            "mappingfield": "vendorcode",
            "nsfield": "itemid"
        }
]

Mapping Templates

Transaction Mapping

Enter the mapping for the Transaction Header and Lines in a well-formed JSON object.

Expand

title	Default

Code Block

language	json

{
   "custentity_edoc_ws_id": {
      "xpath" : ["/cac:OrderReference/cbc:CustomerReference"]
   },
   "vendorname": {
      "xpath": ["/cac:AccountingSupplierParty/cac:Party/cac:PartyName"]
   },
   "vendorvat": {
      "xpath": ["/cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]"]
   },
   "subsidiaryendpointid": {
      "xpath": ["/cac:AccountingCustomerParty/cac:Party/cac:PartyName"]
   },
   "subsidiaryvat": {
      "xpath": ["/cac:AccountingCustomerParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]"]
   },
   "billcountry": {
      "xpath": ["/cac:AccountingSupplierParty/cac:Party/cac:

PartyIdentification

PostalAddress/

cbc:ID[@schemeID=\"VAT\"]"]
},
"subsidiaryendpointid": {
"xpath":

cac:Country/cbc:IdentificationCode"]
   },
   "poreferencenumber" : {
      "xpath" : ["/cac:

AccountingCustomerParty

OrderReference/

cac:Party/cac:PartyName"]
},
"subsidiaryvat": {
"xpath": ["/cac:AccountingCustomerParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]"]
},
"billcountry": {
"xpath": ["/cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cac:Country/cbc:IdentificationCode"]
},
"poreferencenumber" : {
"xpath" : ["/cac:OrderReference/cbc:SalesOrderID"]
},
"referencenumber" : {
"xpath" : ["/cbc:ID"]
},
"trandate": {
"xpath" :

cbc:SalesOrderID"]
   },
   "referencenumber" : {
      "xpath" : ["/cbc:ID"]
   },
   "trandate": {
      "xpath" : ["/cbc:IssueDate"]
   },
   "duedate": {
      "xpath" : ["/cac:PaymentMeans/cbc:PaymentDueDate"]
   },
   "custbody_sta_appr_xmlmemo": {
      "xpath" : ["/cbc:Note"]
   },
   "custbody_sta_nord_trandate": {
      "xpath" : ["/cbc:IssueDate"]

},

"duedate


   "custbody_sta_origpostingdate":

{

 {
      "xpath" : ["

/cac:PaymentMeans

/cbc:

PaymentDueDate

IssueDate"]

},


   "custbody_

sta

2663_

appr

reference_

xmlmemo

num":

{

 {
      "xpath" : ["/cac:PaymentMeans/cbc:

Note

PaymentID"]

},

"custbody_sta_nord_trandate


   "currency":

{

 {
      "xpath" : ["/cbc:

IssueDate

DocumentCurrencyCode"]

},

"custbody_sta_origpostingdate


   "createdfrom":

{

 {
      "xpath" : ["/cac:OrderReference/cbc:

IssueDate

SalesOrderID"]

},

"custbody_2663_reference_num": {


   "taxpercent_total" : {
      "xpath" : ["/cac:TaxTotal/cac:TaxSubtotal/cac:

PaymentMeans

TaxCategory/cbc:

PaymentID"]
},
"currency": {

Percent"]
   },
   "taxamount_total" : {
      "xpath" : ["/cac:TaxTotal/cbc:

DocumentCurrencyCode

TaxAmount"]

},

"createdfrom


   "taxexclusiveamount":

{

 {
      "xpath" : ["/cac:

OrderReference

LegalMonetaryTotal/cbc:

SalesOrderID

TaxExclusiveAmount"]

},

"taxpercent_total


   "custbody_sta_eflow_ourref":

{

 {
      "xpath": ["/cac:

TaxTotal

AccountingSupplierParty/cac:

TaxSubtotal

Party/cac:

TaxCategory

Contact/cbc:

Percent

Name"]

},

"taxexclusiveamount


   "custbody_sta_eflow_yourref":

{

 {
      "xpath": ["

: ["

/cac:AccountingCustomerParty/cac:Party/cac:

LegalMonetaryTotal

Contact/cbc:

TaxExclusiveAmount

ElectronicMail"]

},


   "item" :

{

 {
      "listpath" : "/cac:InvoiceLine",


      "fields" :

[
{

 [
         {
            "firstmemo_value":

{

 {
               "xpath" : ["./cac:Item/cbc:Name"]

},


            },
            "vendorcode":

{

 {
               "xpath" : ["./cac:Item/cac:SellersItemIdentification/cbc:ID"]

},


            },
            "quantity":

{

 {
               "xpath" : ["./cbc:InvoicedQuantity"]

,

,
               "defaultvalue":

1
},

 1
            },
            "rate":

{

 {
               "xpath" : ["./cac:Price/cbc:PriceAmount"

]
},

]
            },
            "amount":

{

 {
               "xpath" : ["./cbc:LineExtensionAmount"]

},


            },
            "description":

{

 {
               "xpath" : ["./cac:Item/cbc:Description"]

},


            },
            "tax1amt":

{

 {
               "xpath" : ["./cac:TaxTotal/cbc:TaxAmount"]

},


            },
            "itemname":

{

 {
               "xpath" : ["./cac:Item/cbc

:Name"]
},

:Name"]
            },
            "taxpercent":

{

 {
               "xpath" : ["./cac:Item/cac:ClassifiedTaxCategory/cbc:Percent", "/cac:TaxTotal/cac:TaxSubtotal/cac:TaxCategory/cbc:Percent"

]
}
}
]
},

]
            }
         }
      ]
   },
   "firstmemo":

{

 {
      "xpath" : ["$item[0].firstmemo_value"]

},


   "entitybankdetails" :

{

 {
      "listpath" : "/cac:PaymentMeans"

,

,
      "fields" :

[
{

  [
         {
            "paymentduedate":

{

 {
               "xpath" : ["./cbc:PaymentDueDate"

]
},

]
            },
            "paymentid":

{

 {
               "xpath" : ["./cbc:PaymentID"]

},


            },
            "paymentchannelcode":

{

 {
               "xpath" : ["./cbc:PaymentChannelCode"]

},


            },
            "payeefinancialaccount":

{

 {
               "xpath" : ["./cac:PayeeFinancialAccount/cbc:ID"]

},


            },
            "financialinstitutionid":

{

 {
               "xpath" : [ "./cac:PayeeFinancialAccount/cac:FinancialInstitutionBranch/cac:FinancialInstitution/cbc:

ID"]
}
}
]
},

ID"]
            }
         }
      ]
   },
   "rounding":

{

 {
      "xpath" : ["/cac:LegalMonetaryTotal/cbc:PayableRoundingAmount"]

},


   "payableamount

": {
"

": {
      "xpath" : ["/cac:LegalMonetaryTotal/cbc:PayableAmount"]

},


   "allowancecharge" :

{

 {
      "listpath" : "/cac:AllowanceCharge",


      "fields" :

[
{

 [
         {
            "chargeindicator":

{

 {
               "xpath" : ["./cbc:ChargeIndicator"]

},
"allowanceamount": {
"xpath" :


            },
            "allowanceamount": {
               "xpath" : ["./cbc:Amount"]

}
}
]
}

Vendor Mapping

Enter the mapping for the Vendor in a well-formed JSON object

{

Expand

title	Default

title	Default - Vendor

Code Block

language	json

{
        "companyname" :

{

 {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name"]

},
"currency" : {
"xpath" :


        },
        "currency" : {
            "xpath" : ["//cbc:DocumentCurrencyCode"]

},


        },
        "vatregnumber" :

{

 {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]"]

},


        },
        "terms" :

{

 {
            "xpath" : ["//cac:PaymentTerms/cbc:Note"]

},


        },
        "taxidnum" :

{

 {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"GLN\"]"]

},


        },
        "custentity_sta_einv_businessid" :

{

 {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"GLN\"]"]

},


        },
        "custentity_sta_flowap_endpointid"

: {

 : {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cbc:EndpointID"]

},


        },
        "country" :

{

 {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cac:Country/cbc:IdentificationCode"]

},


        },
        "addr1" :

{

 {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:StreetName"]

},


        },
        "addr2" :

{

 {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:AdditionalStreetName"]

},


        },
        "city" :

{

 {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:CityName"]

},


        },
        "zip" :

{

 {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:PostalZone"]

},


        },
        "custentity_sta_einv_networkid" :

{

 {
            "xpath" : ["//cac:OrderReference/cbc:CustomerReference"]

}
}
VENDOR CONTACT MAPPING
{
"entityid" : {
"xpath" :

}
}

Expand

title	Default - Vendor Contact

Code Block

language	json

{
        "entityid" : {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:Contact/cbc:Name"]

},
"phone" : {
"xpath" :


        },
        "phone" : {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:Contact/cbc:Telephone"]

},


        },
        "email" :

{

 {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:Contact/cbc:ElectronicMail"]

}

}
}

Back to Top

Version	Old Version 10	New Version 11
Changes made by	Lou Dizon	Krizia Ilaga (Unlicensed)
Saved on	Apr 03, 2024	Apr 05, 2024

Versions Compared

Key

Primary Information

Lookup Criteria

Vendor Lookup Criteria

Item Lookup Criteria

Mapping Templates

Transaction Mapping

Item Lookup Criteria

Mapping Templates

Transaction Mapping

Vendor Mapping