Field Lineage
Where each canonical field comes from, per mapping rule — open a record's trace for its values.
Loading…
Loading…
120 field lineage
| Key | Name | Details |
|---|---|---|
| MAP-AST-ERP-ASSET v1 · display_name | Asset.display_name | ← asset_nameDirect · 1 record · MAP-AST-ERP-ASSET v1 |
| MAP-AST-MES-MACHINE v2 · asset_type | Asset.asset_type | ← (constant)Constant · 1 record · MAP-AST-MES-MACHINE v2 |
| MAP-AST-MES-MACHINE v2 · display_name | Asset.display_name | ← machine_nameDirect · 1 record · MAP-AST-MES-MACHINE v2 |
| MAP-CASE-SUP v1 · display_key | Support Case.display_key | ← case_noDirect · 6 records · MAP-CASE-SUP v1 |
| MAP-CASE-SUP v1 · status | Support Case.status | ← statusDirect · 6 records · MAP-CASE-SUP v1 |
| MAP-DEV-IOT v1 · device_status | Device.device_status | ← statusDirect · 2 records · MAP-DEV-IOT v1 |
| MAP-DEV-IOT v1 · device_type | Device.device_type | ← device_type_codeDirect · 2 records · MAP-DEV-IOT v1 |
| MAP-DEV-IOT v1 · display_name | Device.display_name | ← nameDirect · 2 records · MAP-DEV-IOT v1 |
| MAP-DOC-DOCS v1 · classification | Document.classification | ← classification_codeDirect · 24 records · MAP-DOC-DOCS v1 |
| MAP-DOC-DOCS v1 · current_version_label | Document.current_version_label | ← current_version_noDirect · 24 records · MAP-DOC-DOCS v1 |
| MAP-DOC-DOCS v1 · display_name | Document.display_name | ← titleDirect · 24 records · MAP-DOC-DOCS v1 |
| MAP-DOC-DOCS v1 · document_title | Document.document_title | ← titleDirect · 24 records · MAP-DOC-DOCS v1 |
| MAP-DOC-DOCS v1 · document_type | Document.document_type | ← doc_type_codeDirect · 24 records · MAP-DOC-DOCS v1 |
| MAP-DOC-HR v1 · classification | Document.classification | ← classificationDirect · 5 records · MAP-DOC-HR v1 |
| MAP-DOC-HR v1 · current_version_label | Document.current_version_label | ← version_noDirect · 5 records · MAP-DOC-HR v1 |
| MAP-DOC-HR v1 · display_name | Document.display_name | ← titleDirect · 5 records · MAP-DOC-HR v1 |
| MAP-DOC-HR v1 · document_title | Document.document_title | ← titleDirect · 5 records · MAP-DOC-HR v1 |
| MAP-DOC-HR v1 · document_type | Document.document_type | ← document_typeDirect · 5 records · MAP-DOC-HR v1 |
| MAP-DORD-ECOM v1 · display_key | Digital Order.display_key | ← order_noDirect · 5 records · MAP-DORD-ECOM v1 |
| MAP-DORD-ECOM v1 · status | Digital Order.status | ← statusDirect · 5 records · MAP-DORD-ECOM v1 |
| MAP-EVT-HR-TERM v1 · employment_id | Employee Terminated.employment_id | ← employment_idDirect · 2 records · MAP-EVT-HR-TERM v1 |
| MAP-EVT-HR-TERM v1 · reason_code | Employee Terminated.reason_code | ← reason_codeDirect · 2 records · MAP-EVT-HR-TERM v1 |
| MAP-EVT-HR-TERM v1 · subject_id | Employee Terminated.subject_id | ← employee -> ENTITY Worker, employment.employee_id, employment_event.employment_idDerived · 2 records · MAP-EVT-HR-TERM v1 |
| MAP-EVT-POS-SALE v1 · from_status | Retail Sale Completed.from_status | ← from_statusDirect · 3 records · MAP-EVT-POS-SALE v1 |
| MAP-EVT-POS-SALE v1 · subject_id | Retail Sale Completed.subject_id | ← sale -> OBJECT RetailTransaction, sale_status_history.sale_idDerived · 3 records · MAP-EVT-POS-SALE v1 |
| MAP-INV-ERP-CREDITNOTE v1.0 · amount | Invoice.amount | ← amountDirect · 1 record · MAP-INV-ERP-CREDITNOTE v1.0 |
| MAP-INV-ERP-CREDITNOTE v1.0 · counterparty_entity_id | Invoice.counterparty_entity_id | ← customer_idDirect · 1 record · MAP-INV-ERP-CREDITNOTE v1.0 |
| MAP-INV-ERP-CREDITNOTE v1.0 · currency_code | Invoice.currency_code | ← currency_codeDirect · 1 record · MAP-INV-ERP-CREDITNOTE v1.0 |
| MAP-INV-ERP-CREDITNOTE v1.0 · display_key | Invoice.display_key | ← credit_note_noDirect · 1 record · MAP-INV-ERP-CREDITNOTE v1.0 |
| MAP-INV-ERP-CREDITNOTE v1.0 · document_kind | Invoice.document_kind | ← (constant)Constant · 1 record · MAP-INV-ERP-CREDITNOTE v1.0 |
| MAP-INV-ERP-CREDITNOTE v1.0 · posting_date | Invoice.posting_date | ← credit_dateDirect · 1 record · MAP-INV-ERP-CREDITNOTE v1.0 |
| MAP-INV-ERP-CREDITNOTE v1.0 · status | Invoice.status | ← status_codeDirect · 1 record · MAP-INV-ERP-CREDITNOTE v1.0 |
| MAP-INV-ERP-CUSTOMER v1 · amount | Invoice.amount | ← total_amountDirect · 1 record · MAP-INV-ERP-CUSTOMER v1 |
| MAP-INV-ERP-CUSTOMER v1 · counterparty_entity_id | Invoice.counterparty_entity_id | ← customer_idDirect · 1 record · MAP-INV-ERP-CUSTOMER v1 |
| MAP-INV-ERP-CUSTOMER v1 · currency_code | Invoice.currency_code | ← currency_codeDirect · 1 record · MAP-INV-ERP-CUSTOMER v1 |
| MAP-INV-ERP-CUSTOMER v1 · display_key | Invoice.display_key | ← invoice_noDirect · 1 record · MAP-INV-ERP-CUSTOMER v1 |
| MAP-INV-ERP-CUSTOMER v1 · document_kind | Invoice.document_kind | ← (constant)Constant · 1 record · MAP-INV-ERP-CUSTOMER v1 |
| MAP-INV-ERP-CUSTOMER v1 · posting_date | Invoice.posting_date | ← posting_dateDirect · 1 record · MAP-INV-ERP-CUSTOMER v1 |
| MAP-INV-ERP-CUSTOMER v1 · status | Invoice.status | ← status_codeDirect · 1 record · MAP-INV-ERP-CUSTOMER v1 |
| MAP-INV-ERP-SUPPLIER v1 · amount | Invoice.amount | ← total_amountDirect · 12 records · MAP-INV-ERP-SUPPLIER v1 |
| MAP-INV-ERP-SUPPLIER v1 · counterparty_entity_id | Invoice.counterparty_entity_id | ← supplier_idDirect · 12 records · MAP-INV-ERP-SUPPLIER v1 |
| MAP-INV-ERP-SUPPLIER v1 · currency_code | Invoice.currency_code | ← currency_codeDirect · 12 records · MAP-INV-ERP-SUPPLIER v1 |
| MAP-INV-ERP-SUPPLIER v1 · display_key | Invoice.display_key | ← internal_invoice_noDirect · 12 records · MAP-INV-ERP-SUPPLIER v1 |
| MAP-INV-ERP-SUPPLIER v1 · document_kind | Invoice.document_kind | ← (constant)Constant · 12 records · MAP-INV-ERP-SUPPLIER v1 |
| MAP-INV-ERP-SUPPLIER v1 · posting_date | Invoice.posting_date | ← posting_dateDirect · 12 records · MAP-INV-ERP-SUPPLIER v1 |
| MAP-INV-ERP-SUPPLIER v1 · status | Invoice.status | ← status_codeDirect · 12 records · MAP-INV-ERP-SUPPLIER v1 |
| MAP-INVPOS-ERP-AP v1 · open_amount | Invoice.open_amount | ← open_amountAggregate · 7 records · MAP-INVPOS-ERP-AP v1 |
| MAP-INVPOS-ERP-AP v1 · position_code | Invoice.position_code | ← open_amountAggregate · 7 records · MAP-INVPOS-ERP-AP v1 |
| MAP-INVPOS-ERP-AR v1 · open_amount | Invoice.open_amount | ← open_amountAggregate · 2 records · MAP-INVPOS-ERP-AR v1 |
| MAP-INVPOS-ERP-AR v1 · position_code | Invoice.position_code | ← open_amountAggregate · 2 records · MAP-INVPOS-ERP-AR v1 |
| MAP-LOC-ERP-ADDRESS v1 · address_text | Location.address_text | ← address_line_1Direct · 1 record · MAP-LOC-ERP-ADDRESS v1 |
| MAP-LOC-ERP-ADDRESS v1 · city | Location.city | ← cityDirect · 1 record · MAP-LOC-ERP-ADDRESS v1 |
| MAP-LOC-ERP-ADDRESS v1 · country_code | Location.country_code | ← country_codeDirect · 1 record · MAP-LOC-ERP-ADDRESS v1 |
| MAP-LOC-ERP-ADDRESS v1 · state_code | Location.state_code | ← state_codeDirect · 1 record · MAP-LOC-ERP-ADDRESS v1 |
| MAP-LOC-ERP-WAREHOUSE v1 · display_name | Location.display_name | ← warehouse_nameDirect · 2 records · MAP-LOC-ERP-WAREHOUSE v1 |
| MAP-LOC-ERP-WAREHOUSE v1 · location_type | Location.location_type | ← (constant)Constant · 2 records · MAP-LOC-ERP-WAREHOUSE v1 |
| MAP-LOC-POS v1 · city | Location.city | ← cityDirect · 2 records · MAP-LOC-POS v1 |
| MAP-LOC-POS v1 · country_code | Location.country_code | ← country_codeDirect · 3 records · MAP-LOC-POS v1 |
| MAP-LOC-POS v1 · display_name | Location.display_name | ← store_nameDirect · 3 records · MAP-LOC-POS v1 |
| MAP-LOC-POS v1 · location_type | Location.location_type | ← (constant)Constant · 3 records · MAP-LOC-POS v1 |
| MAP-LOC-POS v1 · state_code | Location.state_code | ← state_codeDirect · 2 records · MAP-LOC-POS v1 |
| MAP-OBS-IOT-MEAS v1 · quality_code | Telemetry Measurement.quality_code | ← quality_codeDirect · 4 records · MAP-OBS-IOT-MEAS v1 |
| MAP-OBS-IOT-MEAS v1 · subject_entity_id | Telemetry Measurement.subject_entity_id | ← device -> ENTITY Device, measurement.sensor_channel_id, sensor_channel.device_idDerived · 4 records · MAP-OBS-IOT-MEAS v1 |
| MAP-OBS-IOT-MEAS v1 · unit_code | Telemetry Measurement.unit_code | ← measurement.sensor_channel_id, sensor_channel.unit_id, unit.unit_codeDerived · 4 records · MAP-OBS-IOT-MEAS v1 |
| MAP-OPP-CRM v1 · display_key | Opportunity.display_key | ← opportunity_noDirect · 6 records · MAP-OPP-CRM v1 |
| MAP-OPP-CRM v1 · status | Opportunity.status | ← statusDirect · 6 records · MAP-OPP-CRM v1 |
| MAP-ORG-CRM-ACCOUNT v1 · display_name | Organization.display_name | ← account_nameDirect · 5 records · MAP-ORG-CRM-ACCOUNT v1 |
| MAP-ORG-CRM-ACCOUNT v1 · trading_name | Organization.trading_name | ← account_nameDirect · 5 records · MAP-ORG-CRM-ACCOUNT v1 |
| MAP-ORG-ERP-CUSTOMER v1 · display_name | Organization.display_name | ← customer_nameDirect · 3 records · MAP-ORG-ERP-CUSTOMER v1 |
| MAP-ORG-ERP-CUSTOMER v1 · legal_name | Organization.legal_name | ← customer_name, legal_nameDirect · Fallback · 6 records · MAP-ORG-ERP-CUSTOMER v1 |
| MAP-ORG-ERP-CUSTOMER v1 · trading_name | Organization.trading_name | ← customer_nameDirect · 3 records · MAP-ORG-ERP-CUSTOMER v1 |
| MAP-ORG-ERP-SUPPLIER v1 · display_name | Organization.display_name | ← supplier_nameDirect · 2 records · MAP-ORG-ERP-SUPPLIER v1 |
| MAP-ORG-ERP-SUPPLIER v1 · legal_name | Organization.legal_name | ← legal_nameDirect · 2 records · MAP-ORG-ERP-SUPPLIER v1 |
| MAP-ORG-ERP-SUPPLIER v1 · trading_name | Organization.trading_name | ← supplier_nameDirect · 2 records · MAP-ORG-ERP-SUPPLIER v1 |
| MAP-PAY-ERP-RECEIPT v1 · amount | Payment.amount | ← amountDirect · 2 records · MAP-PAY-ERP-RECEIPT v1 |
| MAP-PAY-ERP-RECEIPT v1 · counterparty_entity_id | Payment.counterparty_entity_id | ← customer_idDirect · 2 records · MAP-PAY-ERP-RECEIPT v1 |
| MAP-PAY-ERP-RECEIPT v1 · currency_code | Payment.currency_code | ← currency_codeDirect · 2 records · MAP-PAY-ERP-RECEIPT v1 |
| MAP-PAY-ERP-RECEIPT v1 · display_key | Payment.display_key | ← receipt_noDirect · 2 records · MAP-PAY-ERP-RECEIPT v1 |
| MAP-PAY-ERP-RECEIPT v1 · payment_date | Payment.payment_date | ← receipt_dateDirect · 2 records · MAP-PAY-ERP-RECEIPT v1 |
| MAP-PAY-ERP-RECEIPT v1 · payment_kind | Payment.payment_kind | ← (constant)Constant · 2 records · MAP-PAY-ERP-RECEIPT v1 |
| MAP-PAY-ERP-RECEIPT v1 · status | Payment.status | ← status_codeDirect · 2 records · MAP-PAY-ERP-RECEIPT v1 |
| MAP-PAY-ERP-SUPPLIER v1 · amount | Payment.amount | ← amountDirect · 6 records · MAP-PAY-ERP-SUPPLIER v1 |
| MAP-PAY-ERP-SUPPLIER v1 · counterparty_entity_id | Payment.counterparty_entity_id | ← supplier_idDirect · 6 records · MAP-PAY-ERP-SUPPLIER v1 |
| MAP-PAY-ERP-SUPPLIER v1 · currency_code | Payment.currency_code | ← currency_codeDirect · 6 records · MAP-PAY-ERP-SUPPLIER v1 |
| MAP-PAY-ERP-SUPPLIER v1 · display_key | Payment.display_key | ← payment_noDirect · 6 records · MAP-PAY-ERP-SUPPLIER v1 |
| MAP-PAY-ERP-SUPPLIER v1 · payment_date | Payment.payment_date | ← payment_dateDirect · 6 records · MAP-PAY-ERP-SUPPLIER v1 |
| MAP-PAY-ERP-SUPPLIER v1 · payment_kind | Payment.payment_kind | ← (constant)Constant · 6 records · MAP-PAY-ERP-SUPPLIER v1 |
| MAP-PAY-ERP-SUPPLIER v1 · status | Payment.status | ← status_codeDirect · 6 records · MAP-PAY-ERP-SUPPLIER v1 |
| MAP-PAYRUN-HR v1 · display_key | Payroll Run.display_key | ← payroll_run_noDirect · 1 record · MAP-PAYRUN-HR v1 |
| MAP-PAYRUN-HR v1 · period_code | Payroll Run.period_code | ← period_codeDirect · 1 record · MAP-PAYRUN-HR v1 |
| MAP-PAYRUN-HR v1 · period_end | Payroll Run.period_end | ← period_endDirect · 1 record · MAP-PAYRUN-HR v1 |
| MAP-PAYRUN-HR v1 · period_start | Payroll Run.period_start | ← period_startDirect · 1 record · MAP-PAYRUN-HR v1 |
| MAP-PAYRUN-HR v1 · status | Payroll Run.status | ← statusDirect · 1 record · MAP-PAYRUN-HR v1 |
| MAP-PAYRUN-HR v1 · total_gross | Payroll Run.total_gross | ← total_grossDirect · 1 record · MAP-PAYRUN-HR v1 |
| MAP-PAYRUN-HR v1 · total_net | Payroll Run.total_net | ← total_netDirect · 1 record · MAP-PAYRUN-HR v1 |
| MAP-PER-HR-PERSON v1 · display_name | Person.display_name | ← legal_first_name, preferred_nameDirect · Fallback · 10 records · MAP-PER-HR-PERSON v1 |
| MAP-PER-HR-PERSON v1 · legal_first_name | Person.legal_first_name | ← legal_first_nameDirect · 10 records · MAP-PER-HR-PERSON v1 |
| MAP-PER-HR-PERSON v1 · legal_last_name | Person.legal_last_name | ← legal_last_nameDirect · 10 records · MAP-PER-HR-PERSON v1 |
| MAP-PER-HR-PERSON v1 · preferred_name | Person.preferred_name | ← preferred_nameDirect · 1 record · MAP-PER-HR-PERSON v1 |
| MAP-PEX-MES v1 · display_key | Production Execution.display_key | ← mes_work_order_noDirect · 3 records · MAP-PEX-MES v1 |
| MAP-PEX-MES v1 · status | Production Execution.status | ← statusDirect · 3 records · MAP-PEX-MES v1 |
| MAP-PO-ERP v1 · display_key | Purchase Order.display_key | ← purchase_order_noDirect · 10 records · MAP-PO-ERP v1 |
| MAP-PO-ERP v1 · status | Purchase Order.status | ← status_codeDirect · 10 records · MAP-PO-ERP v1 |
| MAP-PRD-ERP-BRAND v1 · brand_name | Product.brand_name | ← brand_nameDirect · 3 records · MAP-PRD-ERP-BRAND v1 |
| MAP-PRD-ERP-ITEM v1 · display_name | Product.display_name | ← item_nameDirect · 6 records · MAP-PRD-ERP-ITEM v1 |
| MAP-PRD-ERP-ITEM v1 · product_name | Product.product_name | ← item_nameDirect · 6 records · MAP-PRD-ERP-ITEM v1 |
| MAP-PRD-ERP-ITEM v1 · product_type | Product.product_type | ← item_type_codeDirect · 6 records · MAP-PRD-ERP-ITEM v1 |
| MAP-PRO-ERP v1 · display_key | Production Order.display_key | ← production_order_noDirect · 4 records · MAP-PRO-ERP v1 |
| MAP-PRO-ERP v1 · status | Production Order.status | ← status_codeDirect · 4 records · MAP-PRO-ERP v1 |
| MAP-RTX-POS v1 · display_key | Retail Transaction.display_key | ← receipt_noDirect · 4 records · MAP-RTX-POS v1 |
| MAP-RTX-POS v1 · status | Retail Transaction.status | ← statusDirect · 4 records · MAP-RTX-POS v1 |
| MAP-SHIP-LOG v1 · display_key | Shipment.display_key | ← shipment_noDirect · 9 records · MAP-SHIP-LOG v1 |
| MAP-SHIP-LOG v1 · status | Shipment.status | ← statusDirect · 9 records · MAP-SHIP-LOG v1 |
| MAP-SO-ERP v1 · display_key | Sales Order.display_key | ← sales_order_noDirect · 10 records · MAP-SO-ERP v1 |
| MAP-SO-ERP v1 · status | Sales Order.status | ← status_codeDirect · 10 records · MAP-SO-ERP v1 |
| MAP-WCL-SUP v1 · display_key | Warranty Claim.display_key | ← warranty_claim_noDirect · 5 records · MAP-WCL-SUP v1 |
| MAP-WCL-SUP v1 · status | Warranty Claim.status | ← statusDirect · 5 records · MAP-WCL-SUP v1 |
| MAP-WRK-HR-EMP v1 · display_name | Worker.display_name | ← employee_noDirect · 10 records · MAP-WRK-HR-EMP v1 |
| MAP-WRK-HR-EMP v1 · person_entity_id | Worker.person_entity_id | ← person_idDirect · 10 records · MAP-WRK-HR-EMP v1 |
| MAP-WRK-HR-EMP v1 · worker_status | Worker.worker_status | ← current_statusDirect · 10 records · MAP-WRK-HR-EMP v1 |