This document details how fields from NetSuite invoice records are mapped into the JSON representation of an 810 EDI document.
| NetSuite Field | EDI Field (JSON) | Description |
|---|
tranId | beginningSegmentForInvoice.invoiceNumber | NetSuite invoice number. |
poNumber | beginningSegmentForInvoice.purchaseOrderNumber | Purchase Order number from customer. |
tranDate | beginningSegmentForInvoice.date | Invoice date. |
dueDate | beginningSegmentForInvoice.date1 | Invoice due date. |
terms.name | termsOfSaleDeferredTermsOfSale.description | Term description. |
terms.discountPercent | termsOfSaleDeferredTermsOfSale.termsDiscountPercent | Discount percent, if any. |
terms.daysUntilExpiry | termsOfSaleDeferredTermsOfSale.termsDiscountDaysDue | Number of days discount is valid. |
terms.daysUntilNetDue | termsOfSaleDeferredTermsOfSale.termsNetDays | Days until net payment is due. |
total | totalMonetaryValueSummary.amount | Total invoice amount. |
subtotal | totalMonetaryValueSummary.amount1 | Subtotal before discounts. |
| (calculated) | totalMonetaryValueSummary.amount3 | Discount amount, if applicable. |
| NetSuite Field | EDI Field (JSON) | Description |
|---|
| Billing Address | N1_loop[].EntityIdentifier.Bill_To | Customer billing address. |
| Shipping Address | N1_loop[].EntityIdentifier.Ship_To | Customer shipping address. |
| Location Address | N1_loop[].EntityIdentifier.Ship_From | Warehouse or shipping location. |
| Payment Address | N1_loop[].EntityIdentifier.Remit_To | Address to send payment to. |
customerId | custrecord_ord_tran_entity | Internal ID of the customer. |
| NetSuite Field | EDI Field (JSON) | Description |
|---|
shipDate | dateTimeReference.date | Date items were shipped. |
| Fulfilled line items | ISS_loop.invoiceShipmentSummary.numberOfUnitsShipped | Total quantity shipped. |
| Carton weight | ISS_loop.invoiceShipmentSummary.weight | Combined weight of all shipped cartons. |
| Tracking number | carrierDetails.referenceIdentification | Tracking number per line item. |
| SCAC code | carrierDetails.standardCarrierAlphaCode | Carrier SCAC code. |
shipMethod | carrierDetails.routing | Shipping method used. |
billOfLading / proNumber | carrierDetails.referenceIdentification | BOL or Pro number (fallback). |
| NetSuite Field | EDI Field (JSON) | Description |
|---|
| Line items (invoiced) | IT1_loop[] | Individual invoiced items, with quantity, price, and product IDs. |
| Line items (discounts, SAC) | SAC_loop[] | Allowances, charges or discounts applicable to invoice lines. |
| NetSuite Field | EDI Field (JSON) | Description |
|---|
poNumber | referenceInformation[].referenceIdentification (PO) | Customer’s PO number. |
tranId | referenceInformation[].referenceIdentification (Vendor) | Vendor's order number (invoice ID). |
customerOrderNumber | referenceInformation[].referenceIdentification (Customer) | Additional customer order reference. |
outboundConfig.vendorNumber | referenceInformation[].referenceIdentification (Vendor) | Vendor number (if defined in config). |
