D4207070 - Retrieve Purchase Order Information
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnOrderNumber | DOCO | MATH_NUMERIC | REQ | 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 | REQ | 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 | REQ | 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 | REQ | 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
|
None |
None |