Data Mapping Gridware to ERP Next
Mapping to Party Master DocType for Master Data
Organisation
|
Gridware field |
API |
Ziel-Doctype |
Ziel-Feld in ERPNext |
Bemerkung |
|
id (Organization ID) |
/services/organizations |
Master Party |
gridware_organization_id |
Eindeutige Org-ID |
|
id (Organization ID) |
/services/organizations |
Master Party |
gridware_subject_id |
Normalisierte Haupt-ID |
|
“ORGANIZATION" set by API URL |
/services/organizations |
Master Party |
gridware_subject_type |
Für einheitliche Importlogik |
|
name |
/services/organizations |
Master Party |
organization_name |
Official Name |
|
name |
/services/organizations |
Master Party |
display_name |
Display Name |
|
type |
/services/organizations |
Master Party |
is_customer / is_supplier |
CUSTOMER → is_customer = 1, is_supplier = 0 SUPPLIER → is_customer = 0, is_supplier = 1 BOTH → is_customer = 1, is_supplier = 1 |
|
customerNumber |
/services/organizations |
Master Party |
gridware_customer_number |
Falls vorhanden |
|
supplierNumber |
/services/organizations |
Master Party |
gridware_supplier_number |
Falls vorhanden |
|
API Payload |
/services/organizations |
Master Party |
raw_payload |
Für Debugging/Sync |
|
Import Datetime |
/services/organizations |
Master Party |
last_imported_at |
Systemseitig setzen |
Person:
|
Gridware Feld |
API |
Ziel-Doctype |
Ziel-Feld in ERPNext |
Bemerkung |
|
ID (Person ID) |
/services/persons/export |
Master Party |
gridware_person_id |
Eindeutige Personen-ID |
|
ID (Person ID) |
/services/persons/export |
Master Party |
gridware_subject_id |
Normalisierte Haupt-ID |
|
"PERSON" set by API URL |
/services/persons/export |
Master Party |
gridware_subject_type |
Für einheitliche Importlogik |
|
Firstname |
/services/persons/export |
Master Party |
first_name |
Vorname |
|
Lastname |
/services/persons/export |
Master Party |
last_name |
Nachname |
|
Firstname + Lastname |
/services/persons/export |
Master Party |
display_name |
Zusammengesetzter Anzeigename |
|
Account.email |
/services/persons/export |
Master Party |
|
Haupt-E-Mail |
|
API Payload komplett |
/services/persons/export |
Master Party |
raw_payload |
Für Debugging/Sync |
|
Import-Zeitpunkt |
/services/persons/export |
Master Party |
last_imported_at |
Systemseitig setzen |
Adress for Organisation or Person
|
Gridware Feld |
API |
Ziel-Doctype |
Ziel-Feld in ERPNext |
Bemerkung |
|
ID (Address) |
/services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId} |
Master Party Address |
external_address_id |
Externe Address-ID |
|
Address Type |
services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId} |
Master Party Address |
address_type |
Postal / Billing / Invoice |
|
Street |
services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId} |
Master Party Address |
street |
Straße |
|
Streetno |
services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId} |
Master Party Address |
street_no |
Hausnummer |
|
zipCode |
services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId} |
Master Party Address |
zip_code |
PLZ |
|
City |
/services/addresses/for-organization/{organizationId}/{services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId}} |
Master Party Address |
city |
Ort |
|
Country |
services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId} |
Master Party Address |
country |
Map on ERPNext Country |
|
Telephone |
services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId} |
Master Party Address |
telephone |
Telefon |
|
|
services/addresses/for-organization/{organizationId}/{addressType} OR /services/addresses/for-person/{personId} |
Master Party Address |
|
Falls auf Address-Level vorhanden |
|
Primary Flag |
? |
Master Party Address |
is_primary |
Falls Gridware so etwas liefert |
|
erzeugter ERPNext Address Datensatz |
Link |
Master Party Address |
erpnext_address |
Optional nachgelagert |
Payment Methode:
|
Gridware Feld |
API adress |
Ziel-Doctype |
Ziel-Feld in ERPNext |
Bemerkung |
|
ID (Payment Method) |
/services/payment-methods |
Master Party Payment Method |
external_payment_id |
Haupt-ID |
|
Type |
/services/payment-methods |
Master Party Payment Method |
payment_type |
z. B. SEPA / Direct Debit |
Then:
|
Gridware Feld |
API adress |
Ziel-Doctype |
Ziel-Feld in ERPNext |
Bemerkung |
|
Iban |
/services/payment-methods/ID |
Master Party Payment Method |
iban |
Wichtig für Bankkonto |
|
BankName |
/services/payment-methods/ID |
Master Party Payment Method |
bank_name |
Falls Detail-Endpoint das liefert |
|
MandateID |
/services/payment-methods/ID |
Master Party Payment Method |
mandate_id |
Wichtig für SEPA Mandate |
|
CreatedAt |
/services/payment-methods/ID |
Master Party Payment Method |
created_at |
|
|
erzeugtes ERPNext Bank Account |
LINK |
Master Party Payment Method |
erpnext_bank_account |
Optional nachgelagert |
|
erzeugtes ERPNext SEPA Mandate |
LINK |
Master Party Payment Method |
erpnext_sepa_mandate |
Optional nachgelagert |
No comments to display
No comments to display