875 Grocery Products Purchase Order
EDI 875 to NetSuite Mapping Documentation
This document describes the mapping between EDI 875 (Grocery Products Purchase Order) fields and NetSuite as defined in the JSONata transformation. Below are the tables use
Helper Variables and Initialization
| EDI Source Property | NetSuite Target Property | Description |
|---|---|---|
message.transactionSets[0].N1_loop with entity identifiers "ST", "BS", "SD", "BY" | $shippingAddresses | Helper variable that looks up shipping addresses from N1_loop |
message.transactionSets[0].N1_loop with entity identifiers "BT", "BY" | $billingAddresses | Helper variable that looks up billing addresses from N1_loop |
Metadata Information
| EDI Source Property | NetSuite Target Property | Description |
|---|---|---|
id | metaData.orderfulId | OrderfulID for reference |
href | metaData.linkInOrderful | Link to the document in Orderful |
version | metaData.version | Document version |
type.name | metaData.type | Transaction type name |
stream | metaData.production | Boolean flag for production vs test |
businessNumber | metaData.referenceNumber | Business reference number |
validationStatus | metaData.validationStatus | Validation status of the document |
deliveryStatus | metaData.deliveryStatus | Delivery status of the document |
acknowledgmentStatus | metaData.acknowledgementStatus | Acknowledgment status |
createdAt | metaData.createdAt | Creation timestamp |
lastUpdatedAt | metaData.lastUpdatedAt | Last update timestamp |
sender.isaId | metaData.tradingPartnerId | Trading partner's ISA ID |
sender.name | metaData.tradingPartnerName | Trading partner's name |
receiver.isaId | metaData.companyTradingPartnerId | Company's trading partner ID |
$customer.id | metaData.customerConfig.customer_internal | Customer's internal ID |
$customer.prodIsaId | metaData.customerConfig.custentity_orderful_isa_id | Customer's production ISA ID |
$customer.testIsaId | metaData.customerConfig.custentity_orderful_isa_id_test | Customer's test ISA ID |
$customer.use850Date | metaData.customerConfig.custentity_orderful_use_850_date | Flag for using 850 date (T/F) |
$customer.id | metaData.customerConfig.custrecord_edi_enab_trans_customer | EDI enabled transaction customer ID |
Transaction Information
| EDI Source Property | NetSuite Target Property | Description |
|---|---|---|
message.transactionSets[0].purchaseOrderIdentification[0].orderStatusCode | transaction.purposeCode | PO purpose code |
message.transactionSets[0].purchaseOrderIdentification[0].date | transaction.date | PO date |
message.transactionSets[0].dateTime[0] with qualifier "10" | transaction.requestedShipDate | Requested ship date |
message.transactionSets[0].dateTime[0] with qualifier "38" | transaction.mustShipBy | Must ship by date |
message.transactionSets[0].dateTime[0] with qualifier "02" or "68" | transaction.latestDelivery | Latest delivery date |
message.transactionSets[0].noteSpecialInstruction | transaction.messageBlock | Special instructions formatted as "code: description" |
message.transactionSets[0].extendedReferenceInformation[0] with qualifier "PO" or fallback to purchaseOrderIdentification[0].purchaseOrderNumber | transaction.purchaseOrderNumber | Purchase order number |
message.transactionSets[0].extendedReferenceInformation[0] with qualifier "AN" | transaction.additionalPurchaseOrderNumbers | Additional PO numbers |
message.transactionSets[0].extendedReferenceInformation[0] with qualifier "OQ" | transaction.orderNumber | Order number |
message.transactionSets[0].extendedReferenceInformation[0] with qualifier "CO" | transaction.customerOrderNumber | Customer order number |
message.transactionSets[0].purchaseOrderIdentification[0].purchaseOrderTypeCode | transaction.orderTypeCode | Purchase order type code |
message.transactionSets[0].extendedReferenceInformation[0] with qualifier "ST" | transaction.storeNumber | Store number |
message.transactionSets[0].extendedReferenceInformation[0] with qualifier "19" | transaction.division | Division |
message.transactionSets[0].extendedReferenceInformation[0] with qualifier "IA" | transaction.vendorNumber | Vendor number |
message.transactionSets[0].extendedReferenceInformation[0] with qualifier "DP" | transaction.departmentNumber | Department number |
message.transactionSets[0].extendedReferenceInformation[0] with qualifier "DP" mapped through department lookup | transaction.department | Department ID |
message.transactionSets[0].extendedReferenceInformation[0] with qualifier "ZZ" | transaction.mutuallyDefined | Mutually defined reference |
message.transactionSets[0].extendedReferenceInformation[0] with qualifier "PD" | transaction.promoDealNumber | Promotion/deal number |
message.transactionSets[0].transportationInstructions[0].routing | transaction.ediRouting | EDI routing information |
Shipping Address
| EDI Source Property | NetSuite Target Property | Description |
|---|---|---|
$shippingAddresses.partyIdentification[0].name | transaction.shippingAddress.addressee | Ship-to address contact name |
$shippingAddresses.geographicLocation[0].countryCode | transaction.shippingAddress.country | Ship-to country code (first 2 chars) |
$shippingAddresses.partyLocation[0].addressInformation | transaction.shippingAddress.addr1 | Ship-to address line 1 |
$shippingAddresses.partyLocation[0].addressInformation1 | transaction.shippingAddress.addr2 | Ship-to address line 2 |
$shippingAddresses.geographicLocation[0].cityName | transaction.shippingAddress.city | Ship-to city |
$shippingAddresses.geographicLocation[0].stateOrProvinceCode | transaction.shippingAddress.state | Ship-to state |
$shippingAddresses.geographicLocation[0].postalCode | transaction.shippingAddress.zip | Ship-to postal code |
$shippingAddresses.partyIdentification[0].identificationCode | transaction.shippingAddress.ediId and transaction.shipToId | Ship-to identification code |
Billing Address
| EDI Source Property | NetSuite Target Property | Description |
|---|---|---|
$billingAddresses.partyIdentification[0].name | transaction.billingAddress.addressee | Bill-to address contact name |
$billingAddresses.geographicLocation[0].countryCode | transaction.billingAddress.country | Bill-to country code (first 2 chars) |
$billingAddresses.partyLocation[0].addressInformation | transaction.billingAddress.addr1 | Bill-to address line 1 |
$billingAddresses.partyLocation[0].addressInformation1 | transaction.billingAddress.addr2 | Bill-to address line 2 |
$billingAddresses.geographicLocation[0].cityName | transaction.billingAddress.city | Bill-to city |
$billingAddresses.geographicLocation[0].stateOrProvinceCode | transaction.billingAddress.state | Bill-to state |
$billingAddresses.geographicLocation[0].postalCode | transaction.billingAddress.zip | Bill-to postal code |
$billingAddresses.partyIdentification[0].identificationCode | transaction.billingAddress.ediId | Bill-to identification code |
Contacts
| EDI Source Property | NetSuite Target Property | Description |
|---|---|---|
message.transactionSets[0].contact with type "IC" | transaction.contacts.informational | Informational contact |
message.transactionSets[0].contact with type "ZZ" | transaction.contacts.mutuallyDefined | Mutually defined contact |
message.transactionSets[0].contact with type "CN" | transaction.contacts.general | General contact |
message.transactionSets[0].contact with type "EA" | transaction.contacts.ediCoordinator | EDI coordinator contact |
message.transactionSets[0].contact with type "OC" | transaction.contacts.orderContact | Order contact |
message.transactionSets[0].contact with type "RE" | transaction.contacts.receivingContact | Receiving contact |
message.transactionSets[0].contact with type "BD" | transaction.contacts.buyerName | Buyer name contact |
message.transactionSets[0].contact with type "SC" | transaction.contacts.scheduleContact | Schedule contact |
Discounts
| EDI Source Property | NetSuite Target Property | Description |
|---|---|---|
message.transactionSets[0].G72_loop.allowanceOrCharge[0].allowanceOrChargeCode | transaction.discounts.code | Allowance or charge code |
message.transactionSets[0].G72_loop.allowanceOrCharge[0].allowanceOrChargeMethodOfHandlingCode | transaction.discounts.processMethod | Method of handling code |
message.transactionSets[0].G72_loop.allowanceOrCharge[0].allowanceOrChargeTotalAmount | transaction.discounts.amount | Discount amount |
message.transactionSets[0].G72_loop.allowanceOrCharge[0].percentDecimalFormat | transaction.discounts.percentDecimal | Percent in decimal format (divided by 100 and rounded) |
Lookup from $authorizedDiscounts based on code | transaction.discounts.id | Discount ID from authorized discounts lookup |
Lookup from $authorizedDiscounts based on code | transaction.discounts.nsItemId | NetSuite item ID from authorized discounts lookup |
Additional Transaction Information
| EDI Source Property | NetSuite Target Property | Description |
|---|---|---|
sender.isaId | transaction.sendFromTradingPartnerId | Trading partner ID sending from |
receiver.isaId | transaction.sentToTradingPartnerId | Trading partner ID sending to |
$customer.id | transaction.entityNetSuiteId | NetSuite entity ID |
$customer.subsidiaryId | transaction.subsidiary | Subsidiary ID |
message.transactionSets[0].totalPurchaseOrder[0].amount | transaction.totalAmount | Total purchase order amount (defaults to 0 if null) |
Line Items
| EDI Source Property | NetSuite Target Property | Description |
|---|---|---|
message.transactionSets[0].G68_loop.lineItemDetail[0].quantity | transactionLines.orderedQuantity | Ordered quantity |
message.transactionSets[0].G68_loop.lineItemDetail[0].unitOrBasisForMeasurementCode | transactionLines.unitLabelEDI | Unit of measurement code |
message.transactionSets[0].G68_loop.lineItemDetail[0].itemListCost | transactionLines.orderedUnitPrice | Ordered unit price |
| UPC lookup from line item detail | transactionLines.item.universal.upc | UPC code |
| Qualifier "EN" from line item detail | transactionLines.item.universal.ean | EAN code |
| Qualifier "UK" from line item detail | transactionLines.item.universal.gtin | GTIN code |
| Qualifier "UA" from line item detail | transactionLines.item.universal.upcCaseCode | UPC case code |
| Qualifier "EO" from line item detail | transactionLines.item.universal.eanUCC8 | EAN/UCC-8 code |
| Qualifier "BP" from line item detail | transactionLines.item.buyer.buyerPartNumber | Buyer part number |
| Qualifier "IN" from line item detail | transactionLines.item.buyer.buyerItemNumber | Buyer item number |
| Qualifier "CB" from line item detail | transactionLines.item.buyer.buyerCatalogNumber | Buyer catalog number |
| Qualifier "SK" from line item detail | transactionLines.item.buyer.sku | SKU |
| Qualifier "IT" from line item detail | transactionLines.item.buyer.buyerStyleNumber | Buyer style number |
| Qualifier "VP" from line item detail | transactionLines.item.seller.vendorPartNumber | Vendor part number |
| Qualifier "VN" from line item detail | transactionLines.item.seller.vendorNumber | Vendor number |
| Qualifier "VA" from line item detail | transactionLines.item.seller.vendorStyleNumber | Vendor style number |
| Qualifier "VC" from line item detail | transactionLines.item.seller.vendorCatalogNumber | Vendor catalog number |
Lookup from $nsItem.id based on UPC | transactionLines.item.netsuiteItemId | NetSuite item ID |
message.transactionSets[0].G68_loop.lineItemDetail[0].priceBracketIdentifier | transactionLines.priceBracketID | Price bracket identifier |
message.transactionSets[0].G68_loop.lineItemDetail[0].priceListNumber | transactionLines.priceListNumber | Price list number |
message.transactionSets[0].G68_loop.lineItemDetail[0] | transactionLines.originalItemData | Original line item data |
$nsItem.class | transactionLines.class | Item class (converted to number) |
$nsItem.saleunit | transactionLines.nsUnitId | NetSuite unit ID |
Line Item Discounts
| EDI Source Property | NetSuite Target Property | Description |
|---|---|---|
message.transactionSets[0].G68_loop.G72_loop[0].allowanceOrCharge[0].allowanceOrChargeCode | transactionLines.discount.code | Line item discount code |
message.transactionSets[0].G68_loop.G72_loop[0].allowanceOrCharge[0].allowanceOrChargeMethodOfHandlingCode | transactionLines.discount.processMethod | Line item discount handling method |
message.transactionSets[0].G68_loop.G72_loop[0].allowanceOrCharge[0].allowanceOrChargeTotalAmount | transactionLines.discount.amount | Line item discount amount |
Lookup from $authorizedDiscounts based on code | transactionLines.discount.id | Line item discount ID |
Lookup from $authorizedDiscounts based on code | transactionLines.discount.nsItemId | Line item discount NetSuite item ID |
Updated about 17 hours ago