Tracelink University

Table of contents

The Grocery Products Purchase Order enables a customer to request delivery of consumer packaged goods (CPG) from a supplier within grocery and wholesale supply chains. This industry-specific message supports grocery trade practices, including promotional pricing, trade allowances, and distribution requirements, making it more suitable than a generic purchase order for CPG transactions.

Canonical Element Type Definition Description X12 mapping IDoc mapping X12 mapping
canonicalGroceryProductsPurchaseOrder – Object type/root element. – – –
  canonicalControlFileHeader – Canonical control file header to store data for control segments of IDocs and TL XML transactions, and EDI envelopes for X12 and EDIFACT. – – –
  canonicalGroceryProductsPurchaseOrderHeader – Purchase order business partner lists G50 E1EDK01 BEG
    processingFunctionTypeCode string

Purpose of purchase order. Tells receiving system function of purchase.

Valid values:

  • CREATE - Create new customer PO in supplier's system

  • CHANGE - Change existing customer PO in supplier's system

  • CONFIRM - Purchase Order confirmation/acknowledgment from supplier's system

  • CANCEL - Cancel purchase order

  • CORRECTION - Correction to purchase order

G5001

  • N (ORIGINAL) or

  • F (CANCEL) or

  • R (CHANGE) or

  • C (CONFIRM)

E1EDK01/ACTION =

  • 000 (NONE)

  • 001 (REVERSE)

  • 002 (CHANGE)

  • 003 (CHANGESTOITEMS)

  • 004 (CHANGESTOHEADERANDITEMS)

BEG01

  • 00 (ORIGINAL) or

  • 01 (CANCEL) or

  • 02 (CREATE)

  • 04 (CHANGE) or

  • 06 (CONFIRM) or

  • CO (CORRECTION)
    freightTerms string Freight terms. – – –
    transactionReferenceIdentifierList array Transaction reference identifier list for purchase order number. G50 E1EDk02 BEG
      b2bTransactionIdentifierType string

Referenced document type.

Valid value:

  • GROCERYPRODUCTSPURCHASEORDER (required)

  • RELEASE

  • CONTRACT

 b2bTransactionIdentifierType = GROCERYPRODUCTSPURCHASEORDER required If b2bTransactionIdentifierType = PURCHASEORDER. QUALF = 001 BEG03 maps to PURCHASEORDER BEG04 maps to RELEASE BEG06 maps to CONTRACT
      b2bTransactionIdentifierValue string Reference order identifier value. G5003 BELNR –
      lineItemNumber string Line item number in customer purchase order. Line item level only. – – –
      transactionDate date Transaction date in canonical date format YYYY-MM-DD. G5002 DATUM + UZEIT (if present) BEG05 maps to PURCHASEORDER transactionDate
      epochTransactionDate date Transaction date in epoch date format YYYY-MM-DD. – – –
    transactionReferenceInformation array Reference information for identifiers that are not related to transaction documents. This group would map to X12 segments REF and N9 and EDIFACT RFF. N9 E1EDk02 REF
      transactionReferenceType string

Transaction reference type for X12 segments REF and N9 and EDIFACT RFF for general reference data that is not a transaction document identifier.

Valid values include:

  • INTERNALVENDORNUMBER

  • VENDORNUMBER

  • DEPARTMENT

  • CONTRACT

  • SALESORDER

  • DEAORDER

N901 =

  • VR (VENDORNUMBER) or

  • IA (INTERNALVENDORNUMBER) or

  • AN (ASSOCIATEDPURCHASEORDER) or

  • DP (DEPARTMENT) or

  • VR (VENDORNUMBER) or

  • CO (CUSTOMERORDER) or

  • CR (CUSTOMERREFERENCENUMBER)

 QUALF

REF01 =

  • DM (DOCUMENT) or

  • D1 (DEACSOSORDER) or

  • DH (DEAIDENTIFIER) or

  • P2 (DEAPREVIOUSIDENTIFIER) or

  • QD (DEAREPLACEMENTIDENTIFIER) or

  • DEA (DEACERTIFICATE) or

  • VR (VENDORNUMBER) or

  • IA (INTERNALVENDORNUMBER)
      transactionReferenceIdentifier string Transaction reference identifier value. N902 BELNR REF02
      description string Identifier or description defined by qualifier code in transactionReferenceIdentifier (REF02). N903 – REF03
      transactionReferenceDate string Transaction reference date and time/ if time available/ in date format YYYY-MM-DD or YYYY-MM-DDTHH:MM:SS.nnnZ if time available. – DATUM + UZEIT (if present) –
      epochTransactionReferenceDate integer Transaction reference date and time in EPOCH date time format. – – –
    purchaseOrderDates array Reference dates at header level. G62 E1EDK03 DTM
      dateType string

Referenced dates at purchase order. header.

Valid values include:

  • CANCELAFTER

  • DELIVERYREQUESTED

  • PROMOTIONSTART

  • PURCHASEORDER

G6201 IDDAT DTM01
      dateValue date Datetime defined by referenced date type. G6202 DATUM + UZEIT (if present) DTM02 + DTM03 (if present)
      timeZone string Time zone for referenced dates. – – –
    companyLocationContactInformation array Contact information for party business or location. G61 – –
      contactType string

Contact code identifying type of contact.

Valid values include:

  • BUYER

  • ORDERCONTACT

  • SUPPLIER

G6101 – PER01
      contactName string Contact name. G6102 – PER02
      contactTitle string Title of contact. – – –
      contactPhone string Contact phone number. G6104 or G6105 based on communications qualifier in G6103 – PER04
      contactEmail string Contact email address. G6104 or G6105 based on communications qualifier in G6103 – PER06
    partnerBusinessInformation array Business party types, identifiers and address information. N1 – –
      partnerEntityType string

Partner entity type defines the partner type in the group.

Valid values include:

  • VENDOR

  • CUSTOMER

  • INVOICINGPARTY

  • CARRIER

  • PAYER

N101 – –
      businessName string Business name for manufacturing party. N102 – –
      additionalBusinessName string Additional business name or overflow of business name. N201 – –
      mpcCompanyLocationIdentifierList array List of identifiers and identifier types for the business party. N1 – –
        companyIdentifierType string

Company identifier type for business partner.

Valid values include:

  • GLN

  • DUNS

  • DUNS4

  • COMPANYID

  • COMPANYSITEID

N103 – –
        companyIdentifierValue string Company identifier value for business partner. N104 – –
        alternateCompanyLocationIdentifierValue string Company location UUID for partner. – – –
        companyLocationPartnerName string Company location partner name. – – –
        agencyCode string Responsible agency code for identifier types. – – –
      address – Manufacturing business party address information. N3/N4 – –
        address1 string Main street address. N301 – –
        address2 string Supplemental street address. N302 – –
        city string City N401 – –
        state string State or region code. N402 – –
        postalCode string Postal code N403 – –
        country string Country code N404 – –
        telephone string Telephone number – – –
        fax string Fax number – – –
        url string Website URL – – –
        buildingNumber string Building number – – –
        plantNumber string Plant number – – –
    billToBusinessInformation – End customer business party types, identifiers and address information. N1 – –
      partnerEntityType string Partner entity type defimes the partner type in the group. Valid values include BILLTO. N101 = BT – –
      businessName string Business name for end customer party. N102 – –
      additionalBusinessName string Additional business name or overflow of business name. N201 – –
      mpcCompanyLocationIdentifierList array List of identifiers and identifier types for the business party. N1 – –
        companyIdentifierType string

Company identifier type for business partner.

Valid values include:

  • GLN

  • DUNS

  • DUNS4

  • COMPANYID

  • COMPANYSITEID

N103 – –
        companyIdentifierValue string Manufacturing business partner name. N104 – –
        alternateCompanyLocationIdentifierValue string Company location UUID for partner. – – –
      address – Manufacturing business party address information. N3/N4 – –
        address1 string Main street address. N301 – –
        address2 string Supplemental street address. N302 – –
        city string City N401 – –
        district string District N402 – –
        state string State or region code N403 – –
        postalCode string Postal code N404 – –
        country string Country code – – –
        telephone string Telephone number – – –
        fax string Fax number – – –
        url string Website URL – – –
        buildingNumber string Building number – – –
        plantNumber string Plant number – – –
    shipToLocationInformation – Ship to location party types, identifiers and address information. N1 E1EDKA1 PARVW = WE N101 = ST
      partnerEntityType string Partner entity type defines the partner type in the group. Valid values include SHIPTO. N101 = ST – –
      businessName string Business name for ship to party location. N102 NAME1 N102 where N101=ST
      additionalBusinessName string Additional business name or overflow of business name. N201 NAME2 –
      mpcCompanyLocationIdentifierList array List of identifiers and identifier types for the business party. N1 – –
        companyIdentifierType string

Company identifier type for business partner.

Valid values include:

  • GLN

  • DUNS

  • DUNS4

  • COMPANYID

  • COMPANYSITEID

N103 –

N103 where N101=ST

N103 = Canonical enumeration

  • 1 - DUNS

  • 9 - DUNS4

  • 11 - DEA

  • 21 - HIN

  • 91 - COMPANYID

  • 92 - COMPANYSITEID

  • UL - GLN
        companyIdentifierValue string Manufacturing business partner name. N104 PARTN N104
        alternateCompanyLocationIdentifierValue string Company location UUID for partner. – LIFNR –
      address – Manufacturing business party address information. N3/N4 – –
        address1 string Main street address. N301 STREET N301
        address2 string Supplemental street address. N302 – N302
        city string City N401 CITY1 N401
        district string District N402 – –
        state string State or region code N403 – N402
        postalCode string Postal code N404 POST_CODE1 N403
        country string Country code – COUNTRY N404
        telephone string Telephone number – TELF1 –
        fax string Fax number – – –
        url string Website URL – – –
        buildingNumber string Building number – – –
        plantNumber string Plant number – – –
    termsOfPayment array Terms of payment looping group. G23 – –
      termsOfPaymentKey string Terms of payment. – – –
      termsOfPaymentTypeCode –

Code identifying type of payment terms.

Valid values include:

  • BASIC

  • DEFERRED

  • ENDOFMONTH

  • FIXEDDATE

  • PROXIMO

G2301 Conditions:

If G2301 = 04, either G2313 or G2314 is required

If G2301 equals "11"), G2304 is required

If G2301 does NOT equal 05, (G2305 or G2310) and (G2306 or G2307) required

 –

ITD01 = Canonical Enum

  • 01 - BASIC

  • 02 - ENDOFMONTH

  • 03 - FIXEDDATE

  • 04 - DEFERRED

  • 05 - DISCOUNTNOTAPPLICABLE

  • 06 - MIXED

  • 07 - EXTENDED

  • 13 - SELLER

  • 14 - PREVIOUSLYAGREED

  • 15 - PROXIMO
      termsOfPaymentDateBasis string

Code identifying the beginning of the terms period.

Valid values:

  • DELIVERYDATE

  • EFFECTIVEDATE

  • INVOICEDATE

  • INVOICERECEIPTDATE

  • PURCHASEORDERDATE

  • SHIPDATE

G2302 –

ITD02 = Canonical Enum

  • 1 - SHIPDATE

  • 2 - DELIVERYDATE

  • 3 - INVOICEDATE

  • 5 - INVOICERECEIPTDATE

  • 7 - EFFECTIVEDATE

  • 09 - PURCHASEORDERDATE
      numberOfDays string Terms of payment: number of days. G2309 – ITD07
      termsOfPaymentPercent string Terms of payment: discount percentage. G2305 – ITD03
      invoicePayablePercent string Percentage of invoice payable. G2314 – ITD11
      paymentDueDate string Due date for payment. G2308 – ITD06 - store in canonical in date format [YYYY-MM-DD]
      paymentDeferredToDate string Date deferred payment or percent of invoice payable is due. – – ITD09 - store in canonical in date format [YYYY-MM-DD]
      paymentDeferredDueAmount number Deferred amount due for payment. – – ITD10
      description string Terms of payment description. G2315 – ITD12
      discountDueDate string Discount due date. G2306 – ITD04 - store in canonical in date format [YYYY-MM-DD]
      discountDueNumberOfDays number Discount due number of days. G2307 – ITD05
      dayOfMonth string Day of month. – – ITD13
    creditsAndCharges array Credits and charges on PO including invoice total, discounts, allowances, promotions, services, and others. G72 – SAC
      creditChargeKeyType string Key identifies credit or charges as discounts or additional charges. – –

SAC01 = Canonical Enum

  • A - ALLOWANCE

  • C - CHARGE

  • N - NONE
      creditChargeType string Code representing type of credit or charge. – – SAC02
      creditChargeAmount string Total amount for the payment. G7208 – SAC05
      itemQuantity string Allowance or charge quantity. G7206 – –
      unitOfMeasure string Unit of measure for the allowance or charge item quantity. G7207 – –
      qualifyingAmount string Amount qualifying for cash discount, allowance, promotion, service or charge. – – –
      unitPriceAmount string Allowance or charge rate per unit. G7205 – –
      creditChargeCurrencyCode string Currency code for credit or charge. – – –
      creditChargePercentRate string Percentage rate for cash discount, allowance, promotion, service or charge. G7209 – SAC07
      percentRateBasisTypeCode string Code indicating basis that allowance or charge percent is calculated. – –

SAC06 = Canonical Enum

  • 0 - GROSS

  • 1 - ITEMLIST

  • 2 - ITEMNET

  • 3 - DISCOUNTGROSS

  • 4 - DISCOUNTNET

  • 5 - BASEUNITPRICE

  • 6 - BASEPRICE

  • 7 - BASEPRICELESSDISCOUNT

  • 8 - NETMONTHLYPASTDUE

  • 9 - LATEPAYMENT

  • B - ITEMTOTAL

  • C- ITEMUNIT

  • D - TOTAL
      creditChargeHandlingCode –

Method of handling for discount or charge.

Valid values include:

  • ADVANCE

  • CANCELALLOWANCE

  • COLLECT

  • CREDITCUSTOMER

  • GROSSINVOICED

  • INFORMATION

  • PREPAID

  • RESELLERALLOWANCE

  • VENDORPAID

– –

SAC12 = Canonical Enum

  • 01 - BILLBACK

  • 02 - OFFINVOICE

  • 04 - CREDITCUSTOMER

  • 05 - VENDORPAID

  • 06 - CUSTOMERPAID

  • 07 - OPTIONAL

  • 08 - GROSSINVOICED

  • 09 - VENDORALLOWANCE

  • 10 - RESELLERALLOWANCE

  • 11 - VENDORDENIED

  • 12 - CANCELALLOWANCE

  • 15 - INFORMATION

  • 18 - TAXNONPAYABLE

  • 25 - ADVANCE

  • CA - CALCULATE

  • CC - COLLECT

  • PP - PREPAID
      description string Description of credit or charge. – – –
      allowanceOrChargeCode string Allowance or charge code identifying the type of allowance or charge. G7201 – –
      creditChargeIdentifier string Identifier number for allowance or charge. G7203 – –
      basisAmountForPercent number Base amount to be used in the percentage calculation of the allowance, charge, or tax. G7210 – –
      creditChargeDescriptions array Credits, charges, allowances, discounts descriptions. Multiple descriptions are possible. G73 – –
        description string Descriptions of credits or charges. G7301 – –
    transportationInformation array Transportation information for purchase order. G66 – –
      companyIdentifierType string Company identifier type for business partner. – – –
      routingSequenceCode string Sequence code for routing. – – –
      transportMethod string

Transportation method.

Valid values include:

  • TRUCK

  • RAIL

  • SEA

  • AIR

  • LTL

  • AIREXPRESS

 G6602 –

TD504 = Canonical Enum

  • A - AIR

  • AE - AIREXPRESS

  • H - CUSTOMERPICKUP

  • D - GROUND

  • M - TRUCK

  • R - RAIL

  • S - SEA

  • SR - SUPPLIERTRUCK

  • K - SUPPLIERTRUCK

  • X - MULTIMODAL
      shipmentChargePaymentMethodType string

Method of payment for delivery.

Valid values include:

  • COLLECT

  • BUYER

  • BUYERSELLERDEFINED

  • PREPAIDONLY

  • SELLER

G6601 – –
      unitLoadOptionCode string Code identifying loading or unloading options for a shipment. G6604 – –
      routingDescription string Free form routing description. G6605 – –
      fobTransferLocation string

Code specifying the type of location at which the risk of loss for the shipment transfers.

Valid values:

  • CITY

  • PLANT

  • SHIPPINGDESTINATION

  • SHIPPINGORIGIN

G6606 – –
      fobPointName – Name of FOBtransfer location point. G6607 – –
    freeTextNote array Free text, instructions, notes, descriptions and other free text elements. NTE segment E1EDKT1 & E1EDKT2 X12
      textReferenceCode string Text reference or subject code. NTE01 /E1EDKT1 / TDID When REF01 = "ZZ" , store X12 qualifier from REF02
      textFunctionCode string Text function code. – /E1EDKT1 / TDOBJECT REF02 = "ZZ"
      language string Language of free text. – /E1EDKT1 / TSSPRAS_ISO –
      textFormatCode string Format code for free text. – E1EDKT2 / TDFORMAT –
      freeFormText string Free text array. NTE02 E1EDKT2 / TDLINE When REF01 = "ZZ" , store value from REF03
    customFields array Name value pairs for mapping pass through elements that will not be processed in TL system at different level. – – –
      name string Name of mapped field. – – –
      value string Value in named field. – – –
  canonicalGroceryProductsPurchaseOrderItemDetails array Purchase order product details array. G68 – –
    lineItemNumber string Line item number for ordered product. – E1EDP01 / POSEX PO101
    processingFunctionTypeCode string

Purpose of purchase order, item level. Element may appear at header or item level or both. Tells receiving system function of purchase.

Valid values:

  • CREATE - Create new customer PO in supplier's system

  • CHANGE - Change existing customer PO in supplier's system

  • CONFIRM - Purchase Order confirmation/acknowledgment from supplier's system

  • CANCEL - Cancel purchase order

–

E1EDP01 / ACTION =

  • 001 (ITEMADDED)

  • 002 (ITEMCHANGED)

  • 003 (CANCEL)

  • 004 (ITEMNOTCHANGED)

  • 005 (ITEMLOCKED)

  • 091 (RECEIPT)

  • 093 (RETURN)

  • 094 (CONSIGNMENT)

  • 095 (DAMAGEDINTRANSIT)

  • 096 (CORRECTION)

 –
    isAcknowledgmentRequired boolean

Purchase order acknowledgment required at line item level flag.

Valid values:

  • True - PO Acknowledgment required for item

  • False - (Default) No acknowledgment required for item

 – – –
    itemCategory string Item category. Populated in standard Idoc. – E1EDP01 / PSTYP –
    netPrice number Net price for item. – E1EDP01 / NETWR –
    plantIdentifier string Plant identifier. – E1EDP01 / WERKS –
    productCodesIdentifiers(1) – Instance 1 product code identifiers mapping to UPC case code. G68 – –
      productCodeType string

Code to identifying UPC case code.

Valid value

UNUPC - UN/UPC case code (2-5-5)

 productCodeType = UNUPC – –
      productCodeValue string Product code identifier value. G6804 If productCodeType = UNUPC – –
    productCodesIdentifiers(2) array Instance 2 product code identifiers for all other product types except UPC case code. G68 segment E1EDP19 Product code qualifier followed by identifiers are represented in pairs from PO106 & PO107 through PO124 & PO125.. If qualifier is present, then identifier is required.
      productCodeType string

Code to qualify product identifier type:

  • VENDOR

  • GTIN14

  • CUSTOMER

  • MANUFACTURER

  • PURCHASERITEM

G6805 G6807

E1EDP19 / QUALF =

  • 001 (CUSTOMER) or

  • 002 (VENDOR) or

  • 003 (GTIN14) or

  • 004 (MANUFACTURER)

PO106 = Canonical Code:

  • VN - SUPPLIER

  • VC - VENDOR

  • UK - GTIN14

  • PI - CUSTOMER

  • N4 - US_NDC542

  • FV - CA_DIN

  • UP - UPC MF or

  • MG - MANUFACTURER

  • N1 - US_NDC442

  • N2 - US_NDC532

  • N3 - US_NDC541

  • SK - SKU

  • BP or IN - BUYER
      productCodeValue string Product code identifier value. G6806 G6808 E1EDP19 / IDTNR PO107
    productItemInformation array Product item code information. Only using a subset of all available attributes. – – –
      productLanguageCode string Language for product description. – – –
      productName string Name of product. G6901 E1EDP19 / KTEXT PID05, where PID = "F"
      genericName string Generic name for product. – –  
      productDescription string Description of the product defined by the current product identifier. – – PID05 where PID01 = "F"
      longDescription string Long description for product. – – –
    itemQuantity(1) array Instance 1 item Quantity mapping to G68 for order quantity. G68 – –
      quantityType string

Type of quantity recorded.

Valid values include ITEM.

quantityType = ITEM – quantity Types used in Purchase order: ITEM
      quantityValue number Quantity of product at PO line item. G6801 – PO102
      unitOfMeasure string Unit of measure for quantity value. G6802 – PO103store X12 qualifier in canonical.See note
    itemQuantity(2) array Instance 2 itemQuantity mapping to PO4 (850) and G70 (875) for number of inner containers or eaches if no inner containers. G70 – PO4
      quantityType string

Type of quantity recorded.

Valid value PACKAGED.

quantityType = PACKAGED – quantity Types used in Purchase order: PACKAGED
      quantityValue number Quantity of product at PO line item. G7001 – PO401
      unitOfMeasure string Unit of measure for quantity value. – – PO403store X12 qualifier in canonical.
    itemQuantity(3) array Instance 3 itemQuantity mapping to PO4 (850) and G70 (875) for number of eaches per inner container G70 – –
      quantityType string

Type of quantity recorded.

Valid values include:

INNERCONTAINERS.

If second instance of itemQuantity exists with innercontainers, map to the same instance of X12 PO4 or G70 created by itemQuantity PACKAGED.

 quantityType = INNERCONTAINERS – quantity Types used in Purchase order: INNERCONTAINERS
      quantityValue number Quantity of product at PO line item. G7010 – PO414
      unitOfMeasure string Unit of measure for quantity value. – – –
    orderPricing array Purchase order price amounts. G76 – –
      pricingType string

Pricing type for invoice item.

Valid pricing types include:

  • UNIT

  • GROSS

  • NET

  • RETAIL

pricingType = UNIT – Pricing Types used in Purchase order: UNIT
      pricingAmount number Pricing amount for pricing type. G6803 where pricingType = UNIT – PO104
      currencyCode string Currency for pricing amount. – – –
    transactionReferenceIdentifiers array Transaction references for purchase orders and PO change, and PO confirmations at line item detail level. – – –
      transactionReferenceIdentifierType string

Referenced document type.

Valid values:

  • PURCHASEORDER

  • SUPPLIERORDER

  • RELEASE

  • INTERNALVENDORNUMBER - Internal Vendor Number

  • DEPARTMENT - Department Number

 – – –
      transactionReferenceIdentifierValue string Reference order identifier value. – – –
      transactionLineItemNumber string Line item number in customer purchase order. Line item level only. – – –
      transactionDate date Date order created. – – –
      transactionTime date Time order created. – – –
    shipToLocationInformation – Ship to location party types, identifiers and address information – E1EDPA1 –
      partnerEntityType string

Partner entity type defimes the partner type in the group.

Valid values include SHIPTO.

– – –
      businessName string Business name for ship to party location. – NAME1 –
      additionalBusinessName string Additional business name or overflow of business name. – NAME2 –
      mpcCompanyLocationIdentifierList array List of identifiers and identifier types for the business party. – – –
        companyIdentifierType string Company identifier type for business partner. – – –
        companyIdentifierValue string Company location identifier for business partner. – PARTN –
        alternateCompanyLocationIdentifierValue string Company location UUID for partner. – LIFNR –
      address – Bill to business party address information. – – –
        address1 string Main street address. – STREET –
        address2 string Supplemental street address. – – –
        city string City – CITY1 –
        district string District – – –
        state string State or region code. – – –
        postalCode string Postal code – POST_CODE1 –
        country string Country code – COUNTRY –
        telephone string Telephone number – TELF1 –
        fax string Fax number – – –
        url string Website URL – – –
        buildingNumber string Building number – – –
        plantNumber string Plant number – – –
    termsOfPayment array Terms of payment looping group. – – –
      termsOfPaymentKey string Terms of payment. – – –
      paymentTypeCode –

Code identifying type of payment terms.

Valid values:

  • BASIC

  • DEFERRED

  • DISCOUNTNOTAPPLICABLE

  • ENDOFMONTH

  • EXTENDED

  • FIXEDDATE

  • MIXED

  • PREVIOUSLYAGREED

  • PROXIMO

  • SELLER

– – –
      termsOfPaymentDateType string

Code identifying the beginning of the terms period.

Valid values:

  • DELIVERYDATE

  • EFFECTIVEDATE

  • INVOICEDATE

  • INVOICERECEIPTDATE

  • PURCHASEORDERDATE

  • SHIPDATE

– – –
      numberOfDays string Terms of payment: number of days. – – –
      termsOfPaymentPercent string Terms of payment: percentage. – – –
      invoicePayablePercent string Percentage of invoice payable. – – –
      paymentDueDate date Due date for payment. – – –
      paymentDeferredToDate date Date deferred payment or percent of invoice payable is due. – – –
      paymentDeferredDueAmount number Deferred amount due for payment. – – –
      description string Terms of payment description. – – –
    creditsAndCharges array Credits and charges on PO including invoice total, discounts, allowances, promotions, services, and others. G68/G72 – –
      creditChargeKeyType string

Key identifies credit or charges as discounts or additional charges.

Valid values include:

  • ALLOWANCE

  • CHARGE

  • PROMOTION

– –

SAC01 = Canonical Enum

  • A - ALLOWANCE

  • C - CHARGE

  • N - NONE
      creditChargeType string Code representing type of credit or charge. – – SAC02
      creditChargeAmount string Total amount for the payment. G7208 – SAC05
      itemQuantity string Allowance or charge quantity. G7206 – –
      unitOfMeasure string Unit of measure for the allowance or charge item quantity. G7207 – –
      qualifyingAmount string Amount qualifying for cash discount, allowance, promotion, service or charge. – – –
      unitPriceAmount string Allowance or charge rate per unit. G7205 – –
      creditChargeCurrencyCode string Currency code for credit or charge. – – –
      creditChargePercentRate string Percentage rate for cash discount, allowance, promotion, service or charge. G7209 – SAC07
      percentRateBasisTypeCode string Code indicating basis that allowance or charge percent is calculated. – –

SAC06 = Canonical enumeration:

  • 0 - GROSS

  • 1 - ITEMLIST

  • 2 - ITEMNET

  • 3 - DISCOUNTGROSS

  • 4 - DISCOUNTNET

  • 5 - BASEUNITPRICE

  • 6 - BASEPRICE

  • 7 - BASEPRICELESSDISCOUNT

  • 8 - NETMONTHLYPASTDUE

  • 9 - LATEPAYMENT

  • B - ITEMTOTAL

  • C - ITEMUNIT

  • D - TOTAL
      creditChargeHandlingCode –

Method of handling for discount or charge.

Valid values include:

  • ADVANCE

  • CANCELALLOWANCE

  • COLLECT

  • CREDITCUSTOMER

  • GROSSINVOICED

  • INFORMATION

  • PREPAID

  • RESELLERALLOWANCE

  • VENDORPAID

G7202 –

SAC12 = Canonical enumeration:

  • 01 - BILLBACK

  • 02 - OFFINVOICE

  • 04 - CREDITCUSTOMER

  • 05 - VENDORPAID

  • 06 - CUSTOMERPAID

  • 07 - OPTIONAL

  • 08 - GROSSINVOICED

  • 09 - VENDORALLOWANCE

  • 10 - RESELLERALLOWANCE

  • 11 - VENDORDENIED

  • 12 - CANCELALLOWANCE

  • 15 - INFORMATION

  • 18 - TAXNONPAYABLE

  • 25 - ADVANCE

  • CA - CALCULATE

  • CC - COLLECT

  • PP - PREPAID
      description string Description of credit or charge. – – –
      allowanceOrChargeCode string Allowance or charge code identifying the type of allowance or charge. G7201 – –
      creditChargeIdentifier string Identifier number for allowance or charge. G7203 – –
      basisAmountForPercent number Base amount to be used in the percentage calculation of the allowance, charge, or tax. G7210 – –
      creditChargeDescriptions array Credits, charges, allowances, discounts descriptions. Multiple descriptions are possible. G73 – –
        description string Descriptions of credits or charges. G7301 – –
    freeTextNote array Free text, instructions, notes, descriptions and other free text elements. – – –
      textReferenceCode string Text reference or subject code. – – –
      textFunctionCode string Text function code. – – –
      language string Language of free text. – – –
      textFormatCode string Format code for free text. – – –
      freeText string, array Free text array. – – –
    customFields array Name value pairs for mapping pass through elements that will not be processed in TL system at different level. – – –
      name string Name of mapped field. – – –
      value string Value in named field. – – –
  canonicalGroceryProductsPurchaseOrderSummary array Purchase order message summary for mapping values. G76 – CTT/AMT
    summaryType string

Type of summary.

Valid values include:

  • TOTALQUANTITY

  • TOTALWEIGHT

  • TOTALVOLUME

  • TOTALAMOUNT

Summary Types in Grocery PO:

  • TOTALQUANTITY

  • TOTALWEIGHT

  • TOTALVOLUME

  • TOTALAMOUNT

Logic: If summaryiType = TOTALQUANTITY, map to/from G7601

If summaryiType = TOTALWEIGHT, map to/from G7603

If summaryiType = TOTALVOLUME, map to/from G7605

If summaryiType = TOTALAMOUNT, map to/from G7608

 –

Summary Types in PO:

NUMBEROFITEMS

  • TOTALQUANTITY

  • TOTALWEIGHT

  • TOTALVOLUME

  • LINEITEMTOTAL

  • TOTALAMOUNT

Logic: If summaryiType = NUMBEROFITEMS, map to/from CTT01 If summaryiType = TOTALQUANTITY, map to/from CTT02

If summaryiType = TOTALWEIGHT, map to/from CTT03

If summaryiType = TOTALVOLUME, map to/from CTT05If

If summaryiType = TOTALAMOUNT, map to/from AMT02 - Set AMT01 to TT total transaction amount
    summaryValue string Value in summary.

  • G7601 for TOTALQUANTITY

  • G7603 for TOTALWEIGHT

  • G7605 for TOTALVOLUME

  • G7608 for TOTALAMOUNT

 –

CTT01 for NUMBEROFITEMS

CTT02 for TOTALQUANTITY

CTT03 for TOTALWEIGHT

CTT05 for TOTALVOLUME

AMT02 for LINEITEMTOTAL when AMT01 = 1

AMT02 for TOTALAMOUNT when AMT01 = TT
    summaryValueUnit string Unit of measure for summary value.

  • G7602 for TOTALQUANTITY

  • G7604 for TOTALWEIGHT

  • G7606 for TOTALVOLUME

 – CTT04 for TOTALWEIGHT

Table of contents