D43E0011A - get eRequisition Detail Data Structure
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
idF43E11Pointer_GENLNG | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
mnReqNumber_DOCO | 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,
| ||||
szReqType_DCTO | 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
| ||||
szReqCompany_KCOO | 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
| ||||
mnReqLineNumber_LNID | 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
| ||||
szReqSuffix_SFXO | 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
| ||||
szCostCenter_MCU | 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
| ||||
mnSupplier_AN8 | 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
| ||||
mnShipTo_SHAN | 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,
| ||||
mnBuyerNumber_ANBY | 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
| ||||
jdTransactionDate_TRDJ | 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. | ||||
jdRequestedDate_DRQJ | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
mnShortItemNumber_ITM | 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
| ||||
szSecondItemNumber_LITM | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szThirdItemNumber_AITM | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
szSupplierItem_CITM | CITM | char | OPT | NONE |
The cross-reference item number that the system assigns to an item number. A cross-reference number allows you to use a supplier's item
| ||||
szUNSPSCCode_UNSPSC | UNSPSC | char | OPT | NONE |
An unmasked UNSPSC commodity code. | ||||
szDescriptionLine1_DSC1 | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
szDescriptionLine2_DSC2 | DSC2 | char | OPT | NONE |
A second, 30-character description, remark, or explanation. | ||||
cPriceOverrideCode_PROV | 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
| ||||
mnUnitPrice_PRRC | 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
| ||||
szSupplierCurrency_CRCD | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
mnExchangeRate_CRR | 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
| ||||
mnForeignUnitCost_FRRC | 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
| ||||
szTransactionUOM_UOM | 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). | ||||
szPrimaryUOM_UOM1 | 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
| ||||
mnQuantityOrdered_UORG | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
mnExtendedPrice_AEXP | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. | ||||
mnForeignExtPrice_FEA | FEA | MATH_NUMERIC | OPT | NONE |
The product of the foreign price times the number of units. | ||||
mnAmountOpen_AOPN | 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
| ||||
mnOpenQuantity_UOPN | UOPN | MATH_NUMERIC | OPT | NONE |
The original quantity for the order detail line, plus or minus any changes to that quantity, minus all quantities shipped, received, and
| ||||
cAccountsExist_MACT | MACT | char | OPT | NONE |
This code indicates whether the expense on the detail line has been distributed to multiple accounts. | ||||
szGlClass_GLC | GLC | char | OPT | NONE |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
| ||||
szCommodity_CMDCDE | CMDCDE | char | OPT | NONE |
User defined commodity code. | ||||
szReqDetailStatus_ERDS | ERDS | char | OPT | NONE |
The status of a detail line on a Requisition has the following valid values:
| ||||
szLineType_LNTY | 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
| ||||
cBuyerPostpone_ERBP | ERBP | char | OPT | NONE |
A flag used by the buyer to postpone the requisition line from generating into a purchase order. Once set, the buyer must remove the Buyer
| ||||
cCapitalFlag_ERCA | ERCA | char | OPT | NONE |
A flag on a requisition line which signifies that the system will create an asset master when the line is received. | ||||
cErrorOnLine_EREL | EREL | char | OPT | NONE |
A flag written if there is an error on a requisition line. This can occur if the user did not resolve an error before the system timed out. The line
| ||||
cRequisitionType_ERTYP | ERTYP | char | OPT | NONE |
The requisition type stores the source of the requisition and has the following valid values:
1 - Services
2 - Catalog (Item Master)
3 - Special
| ||||
cTimedOutFlag_ERTO | ERTO | char | OPT | NONE |
A flag on a requisition line that signifies the line was written to the table because the user's session timed out. The lines will be written at a
| ||||
cRequisitionPriority_ERPR | ERPR | char | OPT | NONE |
A priority flag that notifies a buyer that a requisition line should be expedited. | ||||
cDesktopAcknowledge_ERTA | ERTA | char | OPT | NONE |
A flag on a requisition line which signifies that the system will require the requester to acknowledge receipt of the purchased item. | ||||
mnRequestedBy_AREQ | AREQ | MATH_NUMERIC | OPT | NONE |
The address book number of the person entering the request. The system verifies this number against the Address Book. | ||||
szOriginator_TORG | TORG | char | OPT | NONE |
The person who originally entered the transaction. | ||||
szGenOrderCompany_GKCOO | GKCOO | char | OPT | NONE |
A number that, along with generated order number and generated order type, uniquely identifies a generated order. | ||||
mnGenOrderNumber_GDOCO | GDOCO | MATH_NUMERIC | OPT | NONE |
A number that identifies the generated order, e.g., the purchase order line that was created from a requisition line. | ||||
szGenOrderType_GDCTO | GDCTO | char | OPT | NONE |
A field that identifies the generated order type, e.g., the purchase order type that was created from a requisition line. | ||||
szGenOrderSuffix_GSFXO | GSFXO | char | OPT | NONE |
A code that identifies the order suffix on the generated order, e.g., the purchase order suffix that was generated from a requisition line. A
| ||||
mnGenLineNumber_GLNID | GLNID | MATH_NUMERIC | OPT | NONE |
A number that identifies the generated line number, e.g., the purchase order line number that was generated from a requisition line. | ||||
jdGenOrderDate_GORDJ | GORDJ | JDEDATE | OPT | NONE |
Date the requisition was generated into an order. | ||||
cErrorCode_ERRC | 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
| ||||
szErrorMessage_DTAI | DTAI | char | OPT | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
cSuppressErrorMessage_SUPPS | SUPPS | char | OPT | NONE |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
|
None |
None |