NetSuite Property Mapping

NetSuite to Ion

Netsuite Label	Ion Target
Amount	Ion-PO Line-cost
Expected Receipt Date	Ion-PO Line-estimatedArrivalDate
Item Name	Ion-PO Line-part
Item Revision	Ion-PO Line-revision
Item Type	Ion-PO Line-partType
Internal ID	Ion-PO Line-netsuitePOLineId
PO Number	Ion-PO Line-purchaseOrder
Promise Date	Ion-PO Line-needDate
Quantity	Ion-PO Line-quantity
Status	Ion-PO Line-status
Cost	Ion-Purchase Order-estimatedTotalCost
Created By	Ion-Purchase Order-createdBy
Number	Ion-Purchase Order-poNumber
Shipping Address	Ion-Purchase Order-shipToLocation
Status	Ion-Purchase Order-status
Vendor Name	Ion-Purchase Order-supplier
Address	Ion-Supplier-address
Contact Name	Ion-Supplier-contactName
Email	Ion-Supplier-email
Name	Ion-Supplier-name
Phone Number	Ion-Supplier-phoneNumber

NetSuite Bills

Netsuite Label	Violet Property
Amount	Amount
Billing Address
Bill Number	Bill Number
Created By	Creator
Email
Name
Currency
Date Issued	Issued Date
Days Open
Days Overdue
Due Date	Due Date
Last Modified By
Email
Last Modified By Name
Account	Account
Amount	Amount
Bill Number	Bill Number
Part Number	Part Number
Extracted Quantity	Qty
Description	Memo
Description	Memo
Next Approver	Assignee
Email
Name
Payment Terms
Ship Date	Ship Date
Shipping Address
Status	Status
Vendor Email
Vendor Name	Vendor

NetSuite Items

Netsuite Label	Violet Property
Available Quantity	Available Qty
Average Cost	Average Cost
Cost	Amount
External ID	External ID
Internal ID	Internal ID
Item ID	Part Number
Item Type
Last Purchase Price	Last Purchase Price
MPN	MPN
Name	Name
Subitem Of	Parent
Revision	Revision

NetSuite PO Lines

Netsuite Label	Violet Property
Amount	Amount
Item Description
Expected Receipt Date	Expected Receipt Date
Internal ID
Is Billable?	Billable Status
Item Name	Part Number
Item Revision	Revision
Item Type
Line Number
PO Number	PO Number
Promise Date	Promise Date
Qty	Qty
Qty Available	Available Qty
Qty Billed	Qty Billed
Qty On Hand	Qty On Hand
Qty Received	Qty Received
Quantity Waiting On	Qty Waiting On
Rate	Cost
Received Status	Received Status
Status	Status
Type

NetSuite Purchase Orders

Netsuite Label	Violet Property
Billing Address
Cost	Amount
Created By	Creator
Email
Name
Currency
Days Open
Days Overdue
Due Date	Due Date
External ID
External Reference	Mapped PO Number
Internal ID
Items	Part Number
Item
Last Modified By
Email
Last Modified By Name
Next Approver	Assignee
Email
Name
Payment Terms
PO Number	PO Number
Ship Date
Shipping Address
Status	Status
Vendor Email
Vendor Name	Vendor

NetSuite Receipts

Netsuite Label	Violet Property
Amount	Amount
Created By	Creator
Created From External ID
Created From Internal ID
Created From
Currency	Unit
Estimated Arrival Date	Estimated Arrival Date
External ID
Internal ID
Items
Item
Last Modified By
Amount	Amount
Is Billable
Is Closed
Item Description
Item Internal ID
Item Name/Number	Part Number
Item Type	Entity Type
Line Sequence Number
PO External ID
PO Internal ID
Quantity	Qty
Quantity Billed	Qty Billed
Quantity Rejected
Quantity Shipped/Received	Qty Received
Rate	Unit Price
Receipt Number	Receipt Number
Transaction Internal ID
Type
PO Number	PO Number
Receipt Number	Receipt Number
To Location ID
To Location	Location
Vendor	Vendor