This function will return the information pertaining to the Amount, Quantity, Account and Item from
the purchase order detail table (f4311)
D4300240 - Get Release Purchase Order Detail Information
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
idPointerToF4311DS | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
mnLineNumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
jdTransactionDate | TRDJ | JDEDATE | NONE | NONE |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. | ||||
mnItemNumberShort | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
sz2ndItemNumber | LITM | char | NONE | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
sz3rdItemNumber | AITM | char | NONE | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
szLocation | LOCN | char | NONE | NONE |
The storage location from which goods will be moved. | ||||
szLot | LOTN | char | NONE | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
szDescription1 | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szDescription2 | DSC2 | char | NONE | NONE |
A second, 30-character description, remark, or explanation. | ||||
szLineType | LNTY | char | NONE | NONE |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
szNextStatusCode | NXTR | char | NONE | NONE |
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type. | ||||
szLastStatusCode | LTTR | char | NONE | NONE |
A code (system 40/type AT) specifying the last step in the processing cycle that this order line has successfully completed. | ||||
mnTransactionQuantity | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
mnQuantityOnHold | UCHG | MATH_NUMERIC | NONE | NONE |
The number of units that are on hold. | ||||
mnQuantityOpen | UOPN | MATH_NUMERIC | NONE | NONE |
The original quantity for the order detail line, plus or minus any changes to that quantity, minus all quantities shipped, received, and
| ||||
mnQuantityReceived | UREC | MATH_NUMERIC | NONE | 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
| ||||
mnExtendedPrice | AEXP | MATH_NUMERIC | NONE | NONE |
The number of units multiplied by the unit price. | ||||
mnAmountOnHold | ACHG | MATH_NUMERIC | NONE | NONE |
The value of the units on hold. | ||||
mnAmountOpen | AOPN | MATH_NUMERIC | NONE | 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 | NONE | NONE |
The value of the goods received to date against the original order line. | ||||
mnTaxCommitment | FTN1 | MATH_NUMERIC | NONE | NONE |
The total tax amount committed to the PA ledger. The system uses this amount to relieve taxes at the committed rate. | ||||
cPurchasingTaxable | TX | char | NONE | 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
| ||||
szTaxExplanationCode | EXR1 | char | NONE | 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
| ||||
szTaxRateArea | TXA1 | char | NONE | 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
| ||||
mnQuantityOrdered | PQOR | MATH_NUMERIC | NONE | NONE |
The quantity ordered by the customer expressed in the primary stocking unit of measure. | ||||
szAccountNumber | ANI | char | NONE | NONE |
A value that identifies an account in the general ledger. Use one of the following formats to enter account numbers:
o Standard account
| ||||
szAccountID | AID | char | NONE | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
cSubledgerType | SBLT | char | NONE | NONE |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
szSubledger | SBL | char | NONE | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
szCurrencyCode | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
mnForeignChangedAmount | FCHG | MATH_NUMERIC | NONE | 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
| ||||
mnForeignOpenAmount | FAP | MATH_NUMERIC | NONE | NONE |
The unpaid foreign amount of a transaction. | ||||
szUnitOfMeasureOne | UOM1 | char | NONE | 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
| ||||
szUnitOfMeasure | UOM | char | NONE | 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). | ||||
szUnitofMeasureTwo | UOM2 | char | NONE | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. | ||||
szUnitofMeasureThree | UOM3 | char | NONE | NONE |
A code (table 00/UM) that identifies the unit of measure in which you usually purchase the item. | ||||
mnCarrierNumber | ANCR | MATH_NUMERIC | NONE | NONE |
The address book number of the carrier, which is specified by the customer or by your organization. You might use this carrier because of
| ||||
mnSupplierNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szBranchPlant | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
mnUnitCost | PRRC | MATH_NUMERIC | NONE | NONE |
The unit cost of one item, as purchased from the supplier, excluding freight,taxes, discounts, and other factors that might modify the actual
| ||||
jdPromisedDate | PDDJ | JDEDATE | NONE | NONE |
The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate
| ||||
szWeightUnitOfMeasure | WTUM | char | NONE | NONE |
The unit of measure that indicates the weight of an individual item. Typical weight units of measure are:
GM Gram
OZ Ounce
LB Pound
| ||||
szVolumeUnitOfMeasure | VLUM | char | NONE | NONE |
The unit of measure for the cubic space occupied by an inventory item. Typical volume unit of measures are:
ML Milliliter
OZ Fluid Ounce
| ||||
szReportCode5Purchasing | PDP5 | char | NONE | NONE |
A reporting code that differentiates segments of inventory in ways meaningful to those personnel responsible for the buying function in an
| ||||
mnShipmentNumber | SHPN | MATH_NUMERIC | OPT | NONE |
A "next number" that uniquely identifies a shipment. | ||||
mnForeignUnitCost | 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
| ||||
mnAddressNumberShipTo | 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,
| ||||
mnAmountForeignExtPrice | FEA | MATH_NUMERIC | OPT | NONE |
The product of the foreign price times the number of units. | ||||
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
| ||||
cCalledForMultipleAccountsLine | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
idPointerToF4316DS | GENLNG | ID | OPT | NONE |
General purpose ID variable. |
None |
F4311 Purchase Order Detail File |