Field Mappings

Below you will find the necessary field mappings for importing master data, from Infor, into DocBits.

Auto Accoutning

ChartOfAccounts

				
					{
    "ID": "//DataArea/ChartOfAccounts/IDs/ID",
    "NominalAccount": "//DataArea/ChartOfAccounts/BaseChartOfAccounts/GLNominalAccount",
    "AccountType": "//DataArea/ChartOfAccounts/BaseChartOfAccounts/AccountType",
    "Description": "//DataArea/ChartOfAccounts/BaseChartOfAccounts/Description",
    "DebitCreditFlag": "//DataArea/ChartOfAccounts/DebitCreditFlag",
    "UnitCode": "//DataArea/ChartOfAccounts/MemoUnit/UnitCode",
    "ClassificationCode1": "//DataArea/ChartOfAccounts/Classification/Codes/Code[@sequence='1']",
    "ClassificationCode2": "//DataArea/ChartOfAccounts/Classification/Codes/Code[@sequence='2']",
    "ClassificationCode3": "//DataArea/ChartOfAccounts/Classification/Codes/Code[@sequence='3']",
    "ClassificationCode4": "//DataArea/ChartOfAccounts/Classification/Codes/Code[@sequence='4']",
    "FlexDimensions": "//DataArea/ChartOfAccounts/DimensionProfileSet/DimensionProfile/ID"
}

TotalFlexDimensions

				
					{
    "ID": "//DataArea/CodeDefinition/DisplayID",
    "Description": "//DataArea/CodeDefinition/Description",
    "DimensionID": "//DataArea/CodeDefinition/ReportingSlot",
    "Name": "//DataArea/CodeDefinition/Name"
}

FinalFlexDimensions

				
					{
    "ID": "//DataArea/CodeDefinition/ReportingSlot",
    "Name": "//DataArea/CodeDefinition/ListID"
}

Tax Code

Full

				
					{
    "ID": "//DataArea/LnTaxCode/DocumentID/ID",
    "TaxCodeIDFull": "//DataArea/LnTaxCode/TaxCode",
    "CountryCode": "//DataArea/LnTaxCode/CountryCode",
    "TaxCodeFull": "//DataArea/LnTaxCode/DisplayID",
    "Description": "//DataArea/LnTaxCode/Description",
    "TaxType": "//DataArea/LnTaxCode/TaxTypeCode",
    "TaxRateFull": "number(concat('0',//DataArea/LnTaxCode/SingularRatesGroup/SingularRate[1]/RateNumeric))*100"
}

Reduced

				
					{
    "ID": "//DataArea/LnTaxCode/DocumentID/ID",
    "TaxCodeIDReduced": "//DataArea/LnTaxCode/TaxCode",
    "CountryCode": "//DataArea/LnTaxCode/CountryCode",
    "TaxCodeReduced": "//DataArea/LnTaxCode/DisplayID",
    "Description": "//DataArea/LnTaxCode/Description",
    "TaxType": "//DataArea/LnTaxCode/TaxTypeCode",
    "TaxRateReduced": "number(concat('0',//DataArea/LnTaxCode/SingularRatesGroup/SingularRate[1]/RateNumeric))*100"
}

Free

				
					{
    "ID": "//DataArea/LnTaxCode/DocumentID/ID",
    "TaxCodeIDFree": "//DataArea/LnTaxCode/TaxCode",
    "CountryCode": "//DataArea/LnTaxCode/CountryCode",
    "TaxCodeFree": "//DataArea/LnTaxCode/DisplayID",
    "Description": "//DataArea/LnTaxCode/Description",
    "TaxType": "//DataArea/LnTaxCode/TaxTypeCode",
    "TaxRateFree": "number(concat('0',//DataArea/LnTaxCode/SingularRatesGroup/SingularRate[2]/RateNumeric))*100"
}