D4305210 - Retrieve Purchase Order Details
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| mnOrderNumber | DOCO | MATH_NUMERIC | OPT | NONE | 
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, 
  | ||||
| szOrderType | DCTO | char | OPT | NONE | 
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has 
  | ||||
| szOrderCompany | KCOO | char | OPT | NONE | 
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a 
  | ||||
| szOrderSuffix | SFXO | char | OPT | NONE | 
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies 
  | ||||
| mnLineNumber | LNID | MATH_NUMERIC | OPT | NONE | 
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns 
  | ||||
| szBusinessUnit | MCU | char | OPT | NONE | 
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit 
  | ||||
| szLocation | LOCN | char | OPT | NONE | 
The storage location from which goods will be moved.  | ||||
| szLot | LOTN | char | OPT | NONE | 
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.  | ||||
| mnSupplierNumber | AN8 | MATH_NUMERIC | OPT | NONE | 
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or 
  | ||||
| mnShipToNumber | SHAN | MATH_NUMERIC | OPT | NONE | 
The address number of the location to which you want to ship this order. The address book provides default values for customer address, 
  | ||||
| mnShortItemNumber | ITM | MATH_NUMERIC | OPT | NONE | 
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item 
  | ||||
| sz2ndItemNumber | LITM | char | OPT | NONE | 
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to 
  | ||||
| sz3rdItemNumber | AITM | char | OPT | NONE | 
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item 
  | ||||
| szRelatedKitItemNumber | RLIT | char | OPT | NONE | 
If an individual item of inventory is sold as a component of a kit or assembly (single level bill-of-materials), the item number of that kit is the 
  | ||||
| szDescriptionLine1 | DSC1 | char | OPT | NONE | 
Brief information about an item; a remark or an explanation.  | ||||
| szDescriptionLine2 | DSC2 | char | OPT | NONE | 
A second, 30-character description, remark, or explanation.  | ||||
| szLineType | LNTY | char | OPT | NONE | 
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as 
  | ||||
| szStatusCodeLast | LTTR | char | OPT | NONE | 
A code (system 40/type AT) specifying the last step in the processing cycle that this order line has successfully completed.  | ||||
| szStatusCodeNext | NXTR | char | OPT | NONE | 
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type.  | ||||
| jdRequestedDate | DRQJ | JDEDATE | OPT | NONE | 
The date that an item is scheduled to arrive or that an action is scheduled for completion.  | ||||
| jdTransactionDate | TRDJ | JDEDATE | OPT | NONE | 
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing.  | ||||
| jdSchedulePickDate | PDDJ | JDEDATE | OPT | NONE | 
The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate 
  | ||||
| jdPromisedShipmentDate | PPDJ | JDEDATE | OPT | NONE | 
The promised shipment date for a sales order. This date represents the day that the item can be shipped from the warehouse.  | ||||
| jdCancelDate | CNDJ | JDEDATE | OPT | NONE | 
The date that the order should be canceled if the goods have not been sent to the customer or the goods have not been received from the 
  | ||||
| jdPriceEffectiveDate | PEFJ | JDEDATE | OPT | NONE | 
The system uses the Price Effective Date to determine the base price and all advanced price adjustments.  The value loaded in this date 
  | ||||
| szTransactionUnitOfMeasure | UOM | char | OPT | NONE | 
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).  | ||||
| szPrimaryUnitOfMeasure | UOM1 | char | OPT | NONE | 
A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA 
  | ||||
| szSecondaryUnitOfMeasure | UOM2 | char | OPT | NONE | 
A user defined code (00/UM) that indicates an alternate unit of measure for the item.  | ||||
| szPurchasingUnitOfMeasure | UOM3 | char | OPT | NONE | 
A code (table 00/UM) that identifies the unit of measure in which you usually purchase the item.  | ||||
| mnUnitsPrimaryQtyOrder | PQOR | MATH_NUMERIC | OPT | NONE | 
The quantity ordered by the customer expressed in the primary stocking unit of measure.  | ||||
| mnTransactionQty | UORG | MATH_NUMERIC | OPT | NONE | 
The quantity of units affected by this transaction.  | ||||
| mnPOExchangeRate | CRR | MATH_NUMERIC | OPT | NONE | 
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount. 
The number in this field 
  | ||||
| szCurrencyCodeFrom | CRCD | char | OPT | NONE | 
A code that identifies the currency of a transaction.  | ||||
| mnPurchasingUnitPrice | PRRC | MATH_NUMERIC | OPT | NONE | 
The unit cost of one item, as purchased from the supplier, excluding freight,taxes, discounts, and other factors that might modify the actual 
  | ||||
| mnExtendedPrice | AEXP | MATH_NUMERIC | OPT | NONE | 
The number of units multiplied by the unit price.  | ||||
| mnForeignPurchasingCost | FRRC | MATH_NUMERIC | OPT | NONE | 
The foreign unit cost for this item, as purchased directly from the supplier,excluding freight, taxes, discounts and other factors which might 
  | ||||
| mnForeignExtendedPrice | FEA | MATH_NUMERIC | OPT | NONE | 
The product of the foreign price times the number of units.  | ||||
| mnForeignUnitCost | FUC | MATH_NUMERIC | OPT | NONE | 
Amount - Foreign Unit Cost  | ||||
| mnForeignExtendedCost | FEC | MATH_NUMERIC | OPT | NONE | 
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units.  | ||||
| mnExtendedCost | ECST | MATH_NUMERIC | OPT | NONE | 
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the 
  | ||||
| cPriceOverrideCode | PROV | char | OPT | NONE | 
A value established by the sales order entry program whenever a unit or extended price is entered into an order line item, overriding the 
  | ||||
| cCostOverrideCode | CSTO | char | OPT | NONE | 
A code that specifies whether the change order is a terms only change. For those organizations that elect to view subcontracts on a 
  | ||||
| szTaxArea | TXA1 | char | OPT | NONE | 
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter 
  | ||||
| szTaxExplanationCode | EXR1 | char | OPT | NONE | 
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The 
  | ||||
| cTaxableYN | TX | char | OPT | NONE | 
A code that indicates whether the item is subject to sales tax when you purchase it. The system calculates tax on the item only if the supplier 
  | ||||
| szPaymentTermsCode | PTC | char | OPT | NONE | 
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date. 
  | ||||
| mnBuyerNumber | ANBY | MATH_NUMERIC | OPT | NONE | 
The address book number that identifies who is responsible for setting up and maintaining the correct stocking levels for each inventory 
  | ||||
| szReference1 | VR01 | char | OPT | NONE | 
An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier 
  | ||||
| szReference2Vendor | VR02 | char | OPT | NONE | 
A field available to record reference numbers, such as the supplier's bid document number, quote document, sales order, work order, or 
  | ||||
| szRelatedPoSoNumber | RORN | char | OPT | NONE | 
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for 
  | ||||
| szRelatedOrderType | RCTO | char | OPT | NONE | 
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase 
  | ||||
| szRelatedOrderCompany | RKCO | char | OPT | NONE | 
The key company that is associated with the document number of the related order.  | ||||
| mnRelatedPoSoLineNo | RLLN | MATH_NUMERIC | OPT | NONE | 
A number of the detail line on the related order for which the current order was created. For example, on a purchase order created to fill 
  | ||||
| szAgreementNumber | DMCT | char | OPT | NONE | 
A unique number your company assigns to identify a particular agreement. You might want to assign some significance to the agreement 
  | ||||
| mnAgreementSupplement | DMCS | MATH_NUMERIC | OPT | NONE | 
The supplement number records any changes or addendum to agreements that occur over time or by item. It can also indicate individual 
  | ||||
| cErrorCode | ERRC | char | OPT | NONE | 
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document 
  | ||||
| mnUnitsChangeOrderQty | UCHG | MATH_NUMERIC | OPT | NONE | 
The number of units that are on hold.  | ||||
| mnUnitsReceived | UREC | MATH_NUMERIC | OPT | NONE | 
The original quantity of the order line, plus or minus any changes to that quantity, less all quantities shipped, received and/or vouchered to 
  | ||||
| mnUnitsRelieved | URLV | MATH_NUMERIC | OPT | NONE | 
This field contains the units that have been relieved from the total number of committed units.  | ||||
| mnAmountChange | ACHG | MATH_NUMERIC | OPT | NONE | 
The value of the units on hold.  | ||||
| mnAmountOpen | AOPN | MATH_NUMERIC | OPT | NONE | 
The amount of the order, invoice, or voucher that is still unpaid or open.
When you enter a document (for example, an order, invoice, or 
  | ||||
| mnAmountReceived | AREC | MATH_NUMERIC | OPT | NONE | 
The value of the goods received to date against the original order line.  | ||||
| mnAmountReceivedForeign | FREC | MATH_NUMERIC | OPT | NONE | 
Amount - Received Foreign  | ||||
| mnForeignChangedAmount | FCHG | MATH_NUMERIC | OPT | NONE | 
The change amount of a detail line on an Order.  This is stated as the foreign change amount which is converted by the exchange rate 
  | ||||
| mnAmountForeignOpen | FAP | MATH_NUMERIC | OPT | NONE | 
The unpaid foreign amount of a transaction.  | ||||
| None | 
| None |