# Data Mapping Gridware to ERP Next

## Mapping to Party Master DocType for Master Data 

##### **Organisation** 

<table cellpadding="0" cellspacing="0" class="t1" id="bkmrk-gridware-field-api-z" style="width: 100%; height: 579.719px;"><tbody><tr style="height: 46.5938px;"><td class="td1" style="width: 22.5958%; height: 46.5938px;" valign="top">**Gridware field**

</td><td class="td1" style="width: 16.2993%; height: 46.5938px;" valign="top">API

</td><td class="td1" style="width: 10.8175%; height: 46.5938px;" valign="top">**Ziel-Doctype**

</td><td class="td1" style="width: 19.4401%; height: 46.5938px;" valign="top">**Ziel-Feld in ERPNext**

</td><td class="td1" style="width: 30.7282%; height: 46.5938px;" valign="top">**Bemerkung**

</td></tr><tr style="height: 46.5938px;"><td class="td1" style="width: 22.5958%; height: 46.5938px;" valign="top">id (Organization ID)

</td><td class="td1" style="width: 16.2993%; height: 46.5938px;" valign="top">/services/organizations

</td><td class="td1" style="width: 10.8175%; height: 46.5938px;" valign="top">Master Party

</td><td class="td1" style="width: 19.4401%; height: 46.5938px;" valign="top">gridware\_organization\_id

</td><td class="td1" style="width: 30.7282%; height: 46.5938px;" valign="top">Eindeutige Org-ID

</td></tr><tr style="height: 46.5938px;"><td class="td1" style="width: 22.5958%; height: 46.5938px;" valign="top">id (Organization ID)

</td><td class="td1" style="width: 16.2993%; height: 46.5938px;" valign="top">/services/organizations

</td><td class="td1" style="width: 10.8175%; height: 46.5938px;" valign="top">Master Party

</td><td class="td1" style="width: 19.4401%; height: 46.5938px;" valign="top">gridware\_subject\_id

</td><td class="td1" style="width: 30.7282%; height: 46.5938px;" valign="top">Normalisierte Haupt-ID

</td></tr><tr style="height: 46.5938px;"><td class="td1" style="width: 22.5958%; height: 46.5938px;" valign="top">“ORGANIZATION" set by API URL

</td><td class="td1" style="width: 16.2993%; height: 46.5938px;" valign="top">/services/organizations

</td><td class="td1" style="width: 10.8175%; height: 46.5938px;" valign="top">Master Party

</td><td class="td1" style="width: 19.4401%; height: 46.5938px;" valign="top">gridware\_subject\_type

</td><td class="td1" style="width: 30.7282%; height: 46.5938px;" valign="top">Für einheitliche Importlogik

</td></tr><tr style="height: 46.5938px;"><td class="td1" style="width: 22.5958%; height: 46.5938px;" valign="top">name

</td><td class="td1" style="width: 16.2993%; height: 46.5938px;" valign="top">/services/organizations

</td><td class="td1" style="width: 10.8175%; height: 46.5938px;" valign="top">Master Party

</td><td class="td1" style="width: 19.4401%; height: 46.5938px;" valign="top">organization\_name

</td><td class="td1" style="width: 30.7282%; height: 46.5938px;" valign="top">Official Name

</td></tr><tr style="height: 46.5938px;"><td class="td1" style="width: 22.5958%; height: 46.5938px;" valign="top">name

</td><td class="td1" style="width: 16.2993%; height: 46.5938px;" valign="top">/services/organizations

</td><td class="td1" style="width: 10.8175%; height: 46.5938px;" valign="top">Master Party

</td><td class="td1" style="width: 19.4401%; height: 46.5938px;" valign="top">display\_name

</td><td class="td1" style="width: 30.7282%; height: 46.5938px;" valign="top">Display Name

</td></tr><tr style="height: 113.781px;"><td class="td1" style="width: 22.5958%; height: 113.781px;" valign="top">type

</td><td class="td1" style="width: 16.2993%; height: 113.781px;" valign="top">/services/organizations

</td><td class="td1" style="width: 10.8175%; height: 113.781px;" valign="top">Master Party

</td><td class="td1" style="width: 19.4401%; height: 113.781px;" valign="top">is\_customer / is\_supplier

</td><td class="td1" style="width: 30.7282%; height: 113.781px;" valign="top">CUSTOMER → is\_customer = 1, is\_supplier = 0

SUPPLIER → is\_customer = 0, is\_supplier = 1

BOTH → is\_customer = 1, is\_supplier = 1

</td></tr><tr style="height: 46.5938px;"><td class="td1" style="width: 22.5958%; height: 46.5938px;" valign="top">customerNumber

</td><td class="td1" style="width: 16.2993%; height: 46.5938px;" valign="top">/services/organizations

</td><td class="td1" style="width: 10.8175%; height: 46.5938px;" valign="top">Master Party

</td><td class="td1" style="width: 19.4401%; height: 46.5938px;" valign="top">gridware\_customer\_number

</td><td class="td1" style="width: 30.7282%; height: 46.5938px;" valign="top">Falls vorhanden

</td></tr><tr style="height: 46.5938px;"><td class="td1" style="width: 22.5958%; height: 46.5938px;" valign="top">supplierNumber

</td><td class="td1" style="width: 16.2993%; height: 46.5938px;" valign="top">/services/organizations

</td><td class="td1" style="width: 10.8175%; height: 46.5938px;" valign="top">Master Party

</td><td class="td1" style="width: 19.4401%; height: 46.5938px;" valign="top">gridware\_supplier\_number

</td><td class="td1" style="width: 30.7282%; height: 46.5938px;" valign="top">Falls vorhanden

</td></tr><tr style="height: 46.5938px;"><td class="td1" style="width: 22.5958%; height: 46.5938px;" valign="top">API Payload

</td><td class="td1" style="width: 16.2993%; height: 46.5938px;" valign="top">/services/organizations

</td><td class="td1" style="width: 10.8175%; height: 46.5938px;" valign="top">Master Party

</td><td class="td1" style="width: 19.4401%; height: 46.5938px;" valign="top">raw\_payload

</td><td class="td1" style="width: 30.7282%; height: 46.5938px;" valign="top">Für Debugging/Sync

</td></tr><tr style="height: 46.5938px;"><td class="td1" style="width: 22.5958%; height: 46.5938px;" valign="top">Import Datetime

</td><td class="td1" style="width: 16.2993%; height: 46.5938px;" valign="top">/services/organizations

</td><td class="td1" style="width: 10.8175%; height: 46.5938px;" valign="top">Master Party

</td><td class="td1" style="width: 19.4401%; height: 46.5938px;" valign="top">last\_imported\_at

</td><td class="td1" style="width: 30.7282%; height: 46.5938px;" valign="top">Systemseitig setzen

</td></tr></tbody></table>

##### **Person**:

<table cellpadding="0" cellspacing="0" class="t1" id="bkmrk-gridware-feld-api-zi"><tbody><tr><td class="td1" valign="top">**Gridware Feld**

</td><td class="td1" valign="top">API

</td><td class="td1" valign="top">**Ziel-Doctype**

</td><td class="td1" valign="top">**Ziel-Feld in ERPNext**

</td><td class="td1" valign="top">**Bemerkung**

</td></tr><tr><td class="td1" valign="top">ID (Person ID)

</td><td class="td1" valign="top">/services/persons/export

</td><td class="td1" valign="top">Master Party

</td><td class="td1" valign="top">gridware\_person\_id

</td><td class="td1" valign="top">Eindeutige Personen-ID

</td></tr><tr><td class="td1" valign="top">ID (Person ID)

</td><td class="td1" valign="top">/services/persons/export

</td><td class="td1" valign="top">Master Party

</td><td class="td1" valign="top">gridware\_subject\_id

</td><td class="td1" valign="top">Normalisierte Haupt-ID

</td></tr><tr><td class="td1" valign="top">"PERSON" set by API URL

</td><td class="td1" valign="top">/services/persons/export

</td><td class="td1" valign="top">Master Party

</td><td class="td1" valign="top">gridware\_subject\_type

</td><td class="td1" valign="top">Für einheitliche Importlogik

</td></tr><tr><td class="td1" valign="top">Firstname

</td><td class="td1" valign="top">/services/persons/export

</td><td class="td1" valign="top">Master Party

</td><td class="td1" valign="top">first\_name

</td><td class="td1" valign="top">Vorname

</td></tr><tr><td class="td1" valign="top">Lastname

</td><td class="td1" valign="top">/services/persons/export

</td><td class="td1" valign="top">Master Party

</td><td class="td1" valign="top">last\_name

</td><td class="td1" valign="top">Nachname

</td></tr><tr><td class="td1" valign="top">Firstname + Lastname

</td><td class="td1" valign="top">/services/persons/export

</td><td class="td1" valign="top">Master Party

</td><td class="td1" valign="top">display\_name

</td><td class="td1" valign="top">Zusammengesetzter Anzeigename

</td></tr><tr><td class="td1" valign="top">Account.email

</td><td class="td1" valign="top">/services/persons/export

</td><td class="td1" valign="top">Master Party

</td><td class="td1" valign="top">email

</td><td class="td1" valign="top">Haupt-E-Mail

</td></tr><tr><td class="td1" valign="top">API Payload komplett

</td><td class="td1" valign="top">/services/persons/export

</td><td class="td1" valign="top">Master Party

</td><td class="td1" valign="top">raw\_payload

</td><td class="td1" valign="top">Für Debugging/Sync

</td></tr><tr><td class="td1" valign="top">Import-Zeitpunkt

</td><td class="td1" valign="top">/services/persons/export

</td><td class="td1" valign="top">Master Party

</td><td class="td1" valign="top">last\_imported\_at

</td><td class="td1" valign="top">Systemseitig setzen

</td></tr></tbody></table>

#####  **Adress for Organisation or Person** 

<table cellpadding="0" cellspacing="0" class="t1" id="bkmrk-gridware-feld-api-zi-1"><tbody><tr><td class="td1" valign="top">**Gridware Feld**

</td><td class="td1" valign="top">API

</td><td class="td1" valign="top">**Ziel-Doctype**

</td><td class="td1" valign="top">**Ziel-Feld in ERPNext**

</td><td class="td1" valign="top">**Bemerkung**

</td></tr><tr><td class="td1" valign="top">ID (Address)

</td><td class="td1" valign="top">/services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId}

</td><td class="td1" valign="top">Master Party Address

</td><td class="td1" valign="top">external\_address\_id

</td><td class="td1" valign="top">Externe Address-ID

</td></tr><tr><td class="td1" valign="top">Address Type

</td><td class="td1" valign="top">services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId}

</td><td class="td1" valign="top">Master Party Address

</td><td class="td1" valign="top">address\_type

</td><td class="td1" valign="top">Postal / Billing / Invoice

</td></tr><tr><td class="td1" valign="top">Street

</td><td class="td1" valign="top">services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId}

</td><td class="td1" valign="top">Master Party Address

</td><td class="td1" valign="top">street

</td><td class="td1" valign="top">Straße

</td></tr><tr><td class="td1" valign="top">Streetno

</td><td class="td1" valign="top">services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId}

</td><td class="td1" valign="top">Master Party Address

</td><td class="td1" valign="top">street\_no

</td><td class="td1" valign="top">Hausnummer

</td></tr><tr><td class="td1" valign="top">zipCode

</td><td class="td1" valign="top">services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId}

</td><td class="td1" valign="top">Master Party Address

</td><td class="td1" valign="top">zip\_code

</td><td class="td1" valign="top">PLZ

</td></tr><tr><td class="td1" valign="top">City

</td><td class="td1" valign="top">/services/addresses/for-organization/{organizationId}/{services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId}}

</td><td class="td1" valign="top">Master Party Address

</td><td class="td1" valign="top">city

</td><td class="td1" valign="top">Ort

</td></tr><tr><td class="td1" valign="top">Country

</td><td class="td1" valign="top">services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId}

</td><td class="td1" valign="top">Master Party Address

</td><td class="td1" valign="top">country

</td><td class="td1" valign="top">Map on ERPNext Country

</td></tr><tr><td class="td1" valign="top">Telephone

</td><td class="td1" valign="top">services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId}

</td><td class="td1" valign="top">Master Party Address

</td><td class="td1" valign="top">telephone

</td><td class="td1" valign="top">Telefon

</td></tr><tr><td class="td1" valign="top">Email

</td><td class="td1" valign="top">services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId}

</td><td class="td1" valign="top">Master Party Address

</td><td class="td1" valign="top">email

</td><td class="td1" valign="top">Falls auf Address-Level vorhanden

</td></tr><tr><td class="td1" valign="top">Primary Flag

</td><td class="td1" valign="top">?

</td><td class="td1" valign="top">Master Party Address

</td><td class="td1" valign="top">is\_primary

</td><td class="td1" valign="top">Falls Gridware so etwas liefert

</td></tr><tr><td class="td1" valign="top">erzeugter ERPNext Address Datensatz

</td><td class="td1" valign="top">Link

</td><td class="td1" valign="top">Master Party Address

</td><td class="td1" valign="top">erpnext\_address

</td><td class="td1" valign="top">Optional nachgelagert

</td></tr></tbody></table>

##### **Payment Methode:**

<table cellpadding="0" cellspacing="0" class="t1" id="bkmrk-gridware-feld-api-ad"><tbody><tr><td class="td1" valign="top">**Gridware Feld**

</td><td class="td1" valign="top">API adress

</td><td class="td1" valign="top">**Ziel-Doctype**

</td><td class="td1" valign="top">**Ziel-Feld in ERPNext**

</td><td class="td1" valign="top">**Bemerkung**

</td></tr><tr><td class="td1" valign="top">ID (Payment Method)

</td><td class="td1" valign="top">**/services/payment-methods**

</td><td class="td1" valign="top">Master Party Payment Method

</td><td class="td1" valign="top">external\_payment\_id

</td><td class="td1" valign="top">Haupt-ID

</td></tr><tr><td class="td1" valign="top">Type

</td><td class="td1" valign="top">**/services/payment-methods**

</td><td class="td1" valign="top">Master Party Payment Method

</td><td class="td1" valign="top">payment\_type

</td><td class="td1" valign="top">z. B. SEPA / Direct Debit

</td></tr></tbody></table>

Then:

<table cellpadding="0" cellspacing="0" class="t1" id="bkmrk-gridware-feld-api-ad-1"><tbody><tr><td class="td1" valign="top">**Gridware Feld**

</td><td class="td1" valign="top">API adress

</td><td class="td1" valign="top">**Ziel-Doctype**

</td><td class="td1" valign="top">**Ziel-Feld in ERPNext**

</td><td class="td1" valign="top">**Bemerkung**

</td></tr><tr><td class="td1" valign="top">Iban

</td><td class="td1" valign="top">**/services/payment-methods/ID**

</td><td class="td1" valign="top">Master Party Payment Method

</td><td class="td1" valign="top">iban

</td><td class="td1" valign="top">Wichtig für Bankkonto

</td></tr><tr><td class="td1" valign="top">BankName

</td><td class="td1" valign="top">**/services/payment-methods/ID**

</td><td class="td1" valign="top">Master Party Payment Method

</td><td class="td1" valign="top">bank\_name

</td><td class="td1" valign="top">Falls Detail-Endpoint das liefert

</td></tr><tr><td class="td1" valign="top">MandateID

</td><td class="td1" valign="top">**/services/payment-methods/ID**

</td><td class="td1" valign="top">Master Party Payment Method

</td><td class="td1" valign="top">mandate\_id

</td><td class="td1" valign="top">Wichtig für SEPA Mandate

</td></tr><tr><td class="td1" valign="top">CreatedAt

</td><td class="td1" valign="top">**/services/payment-methods/ID**

</td><td class="td1" valign="top">Master Party Payment Method

</td><td class="td1" valign="top">created\_at

</td><td class="td1" valign="top"></td></tr><tr><td class="td1" valign="top">erzeugtes ERPNext Bank Account

</td><td class="td1" valign="top">LINK

</td><td class="td1" valign="top">Master Party Payment Method

</td><td class="td1" valign="top">erpnext\_bank\_account

</td><td class="td1" valign="top">Optional nachgelagert

</td></tr><tr><td class="td1" valign="top">erzeugtes ERPNext SEPA Mandate

</td><td class="td1" valign="top">LINK

</td><td class="td1" valign="top">Master Party Payment Method

</td><td class="td1" valign="top">erpnext\_sepa\_mandate

</td><td class="td1" valign="top">Optional nachgelagert

</td></tr></tbody></table>