This document describes the mapping of fields from NetSuite Sales Orders into a JSON representation of an 855 EDI document.
| NetSuite Field | EDI Field (JSON) | Description |
|---|
trandate | beginningSegmentForPurchaseOrderAcknowledgment[].date | Purchase order date from the Sales Order. |
| Current Date | beginningSegmentForPurchaseOrderAcknowledgment[].date1 | Date of generating the 855 acknowledgment. |
otherrefnum | beginningSegmentForPurchaseOrderAcknowledgment[].purchaseOrderNumber | Customer PO number from Sales Order. |
| (calculated) | beginningSegmentForPurchaseOrderAcknowledgment[].acknowledgmentTypeCode | Derived from status of line items. |
| NetSuite Field | EDI Field (JSON) | Description |
|---|
otherrefnum | referenceInformation[].referenceIdentification (PO) | Customer PO Number. |
tranid | referenceInformation[].referenceIdentification (Vendor) | NetSuite Sales Order Number. |
outboundConfig.vendorNumber | referenceInformation[].referenceIdentification (Vendor) | Internal vendor number from config. |
custbody_orderful_cust_order_num | referenceInformation[].referenceIdentification (Customer) | Additional customer order reference from custom field. |
| NetSuite Field | EDI Field (JSON) | Description |
|---|
| Customer billing address | N1_loop[].EntityIdentifier.Bill_To | Mapped using lib.netSuiteAddressToEDI. |
| Customer shipping address | N1_loop[].EntityIdentifier.Ship_To | Includes optional DC number and ID qualifier. |
| Sales order location address | N1_loop[].EntityIdentifier.Ship_From | Ship-from location on the sales order, includes location number. |
| NetSuite Field | EDI Field (JSON) | Description |
|---|
| Sales Order line items | PO1_loop[].baselineItemData[] | Quantity is calculated based on individual or grouped line items. |
itemId or upcCode | productServiceID | Used to match against product identifiers in the original 850. |
orderedQuantity | baselineItemData[].quantity | Quantity acknowledged for the item. |
acknowledegmentStatusCode | ACK_loop[].lineItemAcknowledgment[].lineItemStatusCode | Item-level acknowledgment status. |
shipDate | ACK_loop[].lineItemAcknowledgment[].date | Item-level ship date. If provided, formatted to yyyyMMdd. |
changeReason | N9_loop[].text[].textualData | Notes about reason for any change/rejection in acknowledgment. |
| NetSuite Field | EDI Field (JSON) | Description |
|---|
Kit Reference (via groupLineItemsByKit) | SLN_loop[] | Kit-based grouping if enabled. Items are grouped and mapped per SLN format. |
| Calculated from line item + SLN match | baselineItemData[].quantity | Quantity calculated using calculateKitQuantity. |
| NetSuite Field | EDI Field (JSON) | Description |
|---|
Fixed: USD | currency[].currencyCode | Currency used for acknowledgment. |
Fixed: Seller | currency[].entityIdentifierCode | Indicates seller perspective. |
