D4303150A - Get Requisition Prices DS
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cDetailActionCode | ACTI | char | OPT | NONE |
A code that indicates the activity you want to perform. Valid codes are:
A Add
C Change
I Inquire
D Delete
. End the program
Blank
| ||||
szDetailLineBranchPlant | 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
| ||||
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
| ||||
szPrimaryUnitOfMeasure | 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). | ||||
mnQuantityOrdered | PQOR | MATH_NUMERIC | OPT | NONE |
The quantity ordered by the customer expressed in the primary stocking unit of measure. | ||||
szTransactionUnitOfMeasure | TRUM | char | OPT | NONE |
The unit of measure you used when you entered this transaction into the system. | ||||
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. | ||||
szTransactionCurrencyCode | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szBaseCurrencyCode | CRDC | char | OPT | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
szPurchasingUnitOfMeasure | UOM3 | char | OPT | NONE |
A code (table 00/UM) that identifies the unit of measure in which you usually purchase the item. | ||||
mnExchangeRate | 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
| ||||
mnConvFactorTransToPurch | CONV | MATH_NUMERIC | OPT | NONE |
The factor that the system uses to convert one unit of measure to another unit of measure. | ||||
mnConvFactorPurchToPrim | CNV2 | MATH_NUMERIC | OPT | NONE |
The mathematical relationship showing the conversion between the primary and purchasing units of measure. | ||||
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
| ||||
cPurchasePriceLevel | PPLV | char | OPT | NONE |
A code that indicates where to retrieve the purchase price for an item when you enter a purchase order. Valid codes are:
1 Use the
| ||||
cCostLevel | CLEV | char | OPT | NONE |
A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a
| ||||
mnTriangulationRateFrom | TRR1 | MATH_NUMERIC | OPT | NONE |
The triangulation currency rate used to convert the From currency code to the Triangulation currency code. | ||||
mnTriangulationRateTo | TRR2 | MATH_NUMERIC | OPT | NONE |
The triangulation currency rate that used to convert from the Triangulation currency code to the To currency code. | ||||
cCurrencyConversionMethod | CRCM | char | OPT | NONE |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. 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
| ||||
mnUnitPrice | 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. | ||||
mnForeignPrice | 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. | ||||
cCurrencyMode | CRRM | char | OPT | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
cInventoryInterface | IVI | char | OPT | NONE |
A code that identifies the type of interface to the Inventory Management system. Valid values are:
Y The dollar or unit value of any activity
|
None |
None |