Ion Property Mapping

Ion to NetSuite

Ion Label	Netsuite Target
Available Quantity	Netsuite-Item-availableQuantity
Cost	Netsuite-Item-cost
MPN	Netsuite-Item-mpn
Part Number	Netsuite-Item-itemId
Part Type	Netsuite-Item-itemType
Revision	Netsuite-Item-revision
	Netsuite-PO Line-amount
Expected Receipt Date	Netsuite-PO Line-expectedReceiptDate
Item Part Name	Netsuite-PO Line-itemPartName
Item Part Number	Netsuite-PO Line-itemPartNumber
Item Revision	Netsuite-PO Line-itemRevision
Item Type	Netsuite-PO Line-itemType
PO Number	Netsuite-PO Line-poNumber
	Netsuite-PO Line-promiseDate
Quantity	Netsuite-PO Line-quantity
Status	Netsuite-PO Line-status
Class	Netsuite-Purchase Order-classValue
Cost	Netsuite-Purchase Order-cost
Created By	Netsuite-Purchase Order-createdBy
Number	Netsuite-Purchase Order-departmentValue
Number	Netsuite-Purchase Order-externalReference
Number	Netsuite-Purchase Order-poNumber
Shipping Address	Netsuite-Purchase Order-shippingAddress
Status	Netsuite-Purchase Order-status
PO Line Payloads	Netsuite-Purchase Order-__subEntityPayload__poLines
PO Line Payload
Vendor Name	Netsuite-Purchase Order-vendorName
Item Number	Netsuite-Receipt Line-itemNumber
PO External ID	Netsuite-Receipt Line-poExternalId
Quantity	Netsuite-Receipt Line-quantity
Rate	Netsuite-Receipt Line-rate
Receipt Number	Netsuite-Receipt Line-receiptNumber
Created From External ID	Netsuite-Receipt-createdFromExternalId
Estimated Arrival Date	Netsuite-Receipt-estimatedArrivalDate
Receipt Number	Netsuite-Receipt-receiptNumber
Receipt Line Payloads	Netsuite-Receipt-__subEntityPayload__receiptLines
Receipt Line Payload
To Location Name	Netsuite-Receipt-toLocationName
Vendor Name	Netsuite-Receipt-vendorName

Ion to Quickbooks

Ion Label	Quickbooks Target
Description	QuickBooks-Item-description
Ion Expense Account Token	QuickBooks-Item-expenseAccountRef
Name	QuickBooks-Item-name
Amount	QuickBooks-PO Line-amount
Description	QuickBooks-PO Line-description
Item Ref ID	QuickBooks-PO Line-itemRefId
Line Number	QuickBooks-PO Line-lineNum
PO Number	QuickBooks-PO Line-poNumber
Quantity	QuickBooks-PO Line-quantity
Unit Price	QuickBooks-PO Line-unitPrice
AP Account Ref Token	QuickBooks-Purchase Order-apAccountRef
Number	QuickBooks-Purchase Order-poNumber
Status	QuickBooks-Purchase Order-status
PO Line Payloads	QuickBooks-Purchase Order-__subEntityPayload__poLines
PO Line Payload
Vendor ID	QuickBooks-Purchase Order-vendorId
Email	QuickBooks-Vendor-namedEntity-email
Name	QuickBooks-Vendor-namedEntity-displayName

Ion aBOMs

Ion Label	Violet Property
Build Requirement ID
Created By
Etag
Part Inventory
Part Number	Part Number
Quantity
Updated By

Ion Issue

Ion Label	Violet Property
Assignee	Assignee
Assignee Email
Assignee Name
Cause Condition	Cause Condition
Created By
Disposition	Disposition
Expected Condition	Expected Condition
Issue ID	Issue ID
Issue Disposition Type	Disposition Type
Must Close By Run Step
Referenced Part Numbers	Part Number
Part Number
Run Step
Status	Status
Title

Ion Material Requirements

Ion Label	Violet Property
Created By	Creator
Description
Etag
ID	MRP ID
Plan Line IDs
Completed Quantity
Created By	Creator
Due Date	Due Date
Etag
ID
Lead Time	Lead Time
Part Number	Part Number
Part Revision	Revision
Percent Complete
Plan Number	MRP ID
Quantity Needed	Qty
Serial Number	Serial Number
Updated By
Labels
Percent Complete
Plan Result Line IDs
Created By	Creator
End Time	End Date
Etag
Forecasted End Time
Forecasted Start Time	Start Date
ID
Is Latest
Lead Time	Lead Time
Part Inventory ID
Part Number	Part Number
Part Revision	Revision
Percent Complete
Plan ID	MRP ID
PO Line ID
Quantity	Qty
Run ID
Status	Status
Updated By
Status	Status
Updated By

Ion Parts

Ion Label	Violet Property
Attributes
Attribute
Etag
Key
Value
Available Qty	Available Qty
Available Qty (All Revisions)	Total Available Qty
Buyer	Buyer
Buyer Email
Buyer Name
Constructed QuickBooks Item Name
Cost	Cost
Date Released
Description
Etag
Id
Installed Qty	Installed Qty
ID	Inventory ID
Last Maintained Date	Last Maintained Date
Part Inventory ID	Inventory ID
Part Key
Part Number	Part Number
Part Required Procedures	Procedure ID
Part Revision	Revision
Part Sourcing Strategy	Sourcing Strategy
PO Line IDs
PO Line ID
PO Numbers	PO Number
PO Number
Qty	Qty
Qty Available	Available Qty
Related Run
Related Runs	Run ID
Serial Number	Serial Number
Service Due Date	Service Due Date
Status	Status
Tier	Tier
Item Type
Key
Kitted Qty	Kitted Qty
Latest MBOM etag
Latest MBOM Id
Latest MBOM Status
Latest MBOM Version
Manufacturing Engineer	Manufacturing Engineer
Manufacturing Engineer Email
Manufacturing Engineer Name
Material Etag
Material Key
Material Name Value
MBOM Items
MBOM Item
etag
ID
Part Number
Qty	Qty
Name	Name
On Order Qty	On Order Qty
Part Number	Part Number
Part Type	Entity Type
PO Numbers	PO Number
PO Number
Procedures
Procedure
Procedure ID
Required
Quality Engineer	Quality Engineer
Quality Engineer Email
Quality Engineer Name
Release Date Etag
Release Date Key
Release Date Value	Release Date
Reorder Max Qty	Reorder Max Qty
Reorder Min Qty	Reorder Min Qty
Required Procedure
Required Procedures	Procedure ID
Responsible Engineer	Responsible Engineer
Responsible Engineer Email
Responsible Engineer Name
Revision	Revision
Runs
Run
Run ID
Scrapped Qty	Scrapped Qty
Sourcing Strategy	Sourcing Strategy
Supplier Part Number	MPN
Test Engineer	Test Engineer
Test Engineer Email
Test Engineer Name
Inventory Tracking Type
Unavailable Qty	Unavailable Qty
Unit of Measure
WIP Qty	WIP Qty

Ion Part Revisions

Ion Label	Violet Property
Asset Account
Attributes
Attribute
Etag
Key
Value
Available Quantity	Available Qty
Buyer	Buyer
Buyer Email
Buyer Name
COGS Account
Cost
Date Released
Description	Description
Entity ID
Etag	Etag
File Attachments
File Attachment
Filename
ID
Id	Revision ID
Income Account
Installed Quantity	Installed Qty
Item Type
Key
Kitted Quantity	Kitted Qty
Latest MBOM etag
Latest MBOM Id
Latest MBOM Status
Latest MBOM Version
Manufacturing Engineer	Manufacturing Engineer
Manufacturing Engineer Email
Manufacturing Engineer Name
Material Name Etag	Material Name Etag
Material Name Key
Material Name Value	Material Name
MBOM Items
MBOM Item
etag
ID
Part Id
Qty	Qty
Name	Name
On Order Quantity	On Order Qty
Part Number	Part Number
Part Type	Entity Type
PO Numbers	PO Number
PO Number
Procedures
Procedure
Procedure ID
Required
Quality Engineer	Quality Engineer
Quality Engineer Email
Quality Engineer Name
Release Date Etag	Release Date Etag
Release Date Key
Release Date Value	Release Date
Responsible Engineer	Responsible Engineer
Responsible Engineer Email
Responsible Engineer Name
Revision	Revision
Runs
Run
Run ID
Scrapped Quantity	Scrapped Qty
Sourcing Strategy	Sourcing Strategy
Supplier Part Number	MPN
Test Engineer	Test Engineer
Test Engineer Email
Test Engineer Name
Inventory Tracking Type
Unavailable Quantity	Unavailable Qty
Unit of Measure
WIP Quantity	WIP Qty

Ion PO Lines

Ion Label	Violet Property
Cost
Currency
Description
DI-Project	DI-Project
DI-State	DI-State
Estimated Arrival Date	Estimated Arrival Date
Est. Total Cost	Amount
Etag
External Reference	Mapped PO Number
ID	PO Line ID
Label
Labels	Label
Line Number
Need Date	Need By Date
Paid
Part
Part Number	Part Number
Part Type	Entity Type
PO Line Key
Purchase Order	PO Number
Qty	Qty
Revision	Revision
Status	Status
Supplier Part Number	MPN
Tier	Pedigree

Ion Procedures

Ion Procedures
Ion Label	Violet Property
Created By	Creator
Family ID
ID	Procedure ID
Part Numbers	Part Number
Part Number
Revision	Revision
Created By	Creator
Family ID
ID
Part Numbers	Part Number
Part Number
Revision	Revision
Status	Status
Status	Status

Ion Purchase Orders

Ion Label	Violet Property
Bill To Location
Class
Created At	Created Date
Created By	Creator
Currency
Department
Estimated Arrival Date	Estimated Arrival Date
Est. Total Cost	Amount
Etag
External Reference	Mapped PO Number
ID
Label
Labels	Label
Line IDs
Line ID
Need Date	Need By Date
Part Number
Part Numbers	Part Number
PO Number	PO Number
Ship To Location
Status	Status
Supplier	Vendor
Supplier ID

Ion Receipts

Ion Label	Violet Property
Created By	Creator
Entity ID
Etag
ID	Receipt ID
Labels	Label
PO Number	PO Number
PO Numbers	PO Number
PO Number
Receipt Line IDs
Received At	Received Date
Received By
Ship To Location	Location
Supplier	Vendor
Updated By

Ion Receipt Lines

Ion Label	Violet Property
Amount	Amount
Created By	Creator
Estimated Arrival Date	Estimated Arrival Date
Etag
ID	Receipt Line ID
Part Description
Part Inventory ID	Inventory ID
Part Number	Part Number
PO Line	PO Line ID
PO Number	PO Number
Quantity	Qty
Rate	Unit Price
Receipt Number	Receipt ID
Updated By

Ion Runs

Ion Label	Violet Property
Assignee	Assignee
Assignee Email
Assignee Name
Calculated Lead Time	Calculated Lead Time
Due Date	Due Date
ID
Jira Issue Key
Label
Labels	Label
Part
Part Number	Part Number
Procedure ID	Procedure ID
Qty	Qty
Results Link
Scheduled End
Scheduled Start
Status	Status
Assignee	Assignee
Assignee Email
Assignee Name
ID
Lead Time	Lead Time
Location	Location
Scheduled End
Scheduled Start
Status	Status
Tier	Tier