›> ›> EXTOL/JDE - Inbound EDI 810 Detail - F47042 - Fields to Use

EXTOL/JDE - Inbound EDI 810 Detail - F47042 - Fields to Use

5th January 2014

The inbound EDI 810 (Invoice) can be translated into the JD Edwards F47041/F47042/F47044 (ASN) tables. We also use F4714 (Header Notes) and F4715 (Detail Notes).

Users will run EDI Inbound Invoice/Match to P.O. Edit/Create (R470412) from the Invoice with Receipt Match menu to match invoices.

Previous review of Inbound EDI 810 Header - F47041 Fields

The following F47042 fields must contain data before you can effectively use the EDI Inbound Invoice/Match to P.O. Edit/Create (R470412) for invoices with Receipt Match:

Mandatory Fields:

  • EDI Document Number (EDOC)
  • EDI Document Type (EDCT)
  • EDI Order Type (DCTO)
  • EDI Document Key Company (EKCO)
  • EDI Transaction Set (EDST)
  • EDI Line Number (EDLN)
  • Order Number (DOCO)
  • Order Key Company (KCOO)
  • Send/Receive Flag = R (EDER)
  • Address Number (AN8)
  • Line Type (LNID)
  • Business Unit (MCU)
  • Customer Item Number (CITM)
  • Second Item Number (LITM)
  • Pay Status (PST)
  • Quantity Open (UOPN)
  • Open Amount (AAP)

Additional Fields:

  • Document Type - Voucher Only (DCTV)
  • Record Sequence (EDSQ)
  • Record Type (EDTY)
  • Invoice Number (VINV)
  • Company (CO)
  • Transaction Originator (TORG)
  • Batch Number (EDBT)
  • Processed (Y/N) (EDSP)
  • EDI Transmission Date (EDDT)
  • Reference 1 (Purchase Order Number) (VR01)
  • Reference 2 (VR02)
  • Trading Partner ID (PNID)
  • Unit of Measurement (UOM)
  • Unit Price (UPRC)
  • Currency Code (CRCD)
  • Allowance or Charge Indicator (ACIN)
  • Description (DSC1)
  • Order Suffix (SFXO)
  • Time of Day (TDAY)
  • User Id (USER)
  • Program Id (PID)
  • Work Station Id (JOBN)
  • Date Updated (UPMJ)

Reference Fields

  • User Reserved Number (URAB)
  • User Reserved Amount (URAT)
  • User Reserved Code (URCD)
  • User Reserved Date (URDT)
  • User Reserved Reference (URRF)

F47042 Notes Specific for EXTOL mapping: Contact for more details

Mandatory Fields: Fields JDEdwards has identified as fields that should be populated to process inbound invoice.

Additional Fields: Fields that should be populated to assist the invoice in processing. Ie, VR01 (PO Number) and PNID (EDI Trading Partner)

Reference Fields: Fields in JDEdwards table that can be used to store additional data.


By: on