Mapping Answer Keys to your ERP System

  • Created

What are answer keys?

Answer keys are the unique field identifiers that Graphite uses in the database. These don't change even when the label changes, for example when the label is translated into local language.

The answer keys are used to map Graphite data into your systems as appropriate. 

 

mceclip0.png   In some instances, there may not be a 1:1 match, and you will need to look at multiple answer keys in order to correctly map to your system.

 

Sample Tax Field Mapping

The following samples show how you might take 2 fields from Graphite in order to map to 1 field in your system.

Sample US tax fields:

Graphite answer key How it is used Possible values
Tax_US_Classification This is used to determine the correct classification as indicated by the W9. The saved value of “individual” represents both Individual and Single Member LLC.

individual
c-corp
s-corp
partnership
trust
llc
other

Tax_US_Classification_LLC This question is only asked when Tax_US_Classification = llc

c-corp
s-corp
partnership

Tax_US_Employer_Id_Number Represents EIN XX-XXXXXXX
Tax_US_Social_Security_Number Represents SSN.
Only available when EIN = null.
XXX-XX-XXXX

 

Sample corresponding logic to set US tax classifications:

  • When Tax_US_Classification = “individual” AND Tax_US_Social_Security_Number has a value, set as “Individual/Sole Proprieter”
  • When Tax_US_Classification = “individual” AND Tax_US_Employer_Id_Number has a value, set as “single member”
  • When Tax_US_Classification = “llc” AND Tax_US_Classifcation_LLC = “c-corp” , set as “LLC C-Corp" 

 

Sample Non-US tax fields:

Graphite answer key How it is used Possible values

Entity_Country

This is the Country of Registration of the supplier

2-digit country codes

Tax_****_Classification

*** Represents the name of the country

c
Individual

*c is company

Integration_Tax_ID

To simplify tax details globally, Graphite puts the primary tax ID in this field. It does not include the tax type. This field should only be used if the corresponding system does not require specific mapping based on country or tax type. Varies based on input

Tax_****_VAT_Number

*** Represents the name of the country

Varies based on country requirements

All other tax fields are available here: Standard Tax Fields by Country > 

 

Sample corresponding logic to set Organization Type in Oracle:


CORPORATION

  • When Tax_US_Classification = “c-corp” OR Tax_US_Classification = “s-corp” OR Tax_US_Classifcation_LLC = “c-corp” OR Tax_US_Classifcation_LLC = “s-corp”

FOREIGN CORPORATION

  • When “Entity_Country “ ≠ US AND when Tax_***_Classification = “c” set as “Foreign Corporation”
    OR When “Entity_Country” ≠ US

INDIVIDUAL

  • When Tax_US_Classification = “individual” AND Tax_US_Social_Security_Number has a value, set as “Individual” in MDG.

FOREIGN INDIVIDUAL

  • When “Entity_Country “ ≠ US AND when Tax_***_Classification = “individual” set as “Foreign Individual”
  • OR all Foreign is Foreign Corporation

PARTNERSHIP

  • When Tax_US_Classification = “partnership” OR Tax_US_Classifcation_LLC = “partnership” set as “Partnership”

OTHER

  • When Tax_US_Classification = “trust” OR Tax_US_Classification = “other”

Was this article helpful?

0 out of 0 found this helpful