Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
szComputerID | CTID | char | NONE | NONE |
|
mnJobnumberA | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. |
mnLineNumberXREF | LNIX | MATH_NUMERIC | NONE | NONE |
|
szPriceAdjustmentType | AST | char | NONE | NONE |
A user defined code (system 40, type TY) that identifies an adjustment definition. You define adjustments on Price Adjustment Names.
For
Agreement Penalty Schedules Add a definition for each of the four types of penalties:
Minimum quantity
Maximum quantity
Under
commitment
Over commitment |
mnPriceAdjustmentKeyID | ATID | MATH_NUMERIC | NONE | NONE |
The unique key I.D. for each adjustment level. |
szUnitOfMeasurePricing | UOM4 | char | NONE | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. |
mnQuantityMinimum | MNQ | MATH_NUMERIC | NONE | NONE |
A value that specifies how an adjustment or preference will be applied to a price. This value can be a quantity, weight, or amount,
depending on how you have defined the level-break type in the Price Adjustment Detail table (F4072).
|
cLevelBreakType | LBT | char | NONE | NONE |
A user defined code that indicates how level breaks occur in the Price Adjustment Detail table (F4072). The system supports the following
four types of level breaks:
Quantity
The system determines the correct adjustment based on the quantity ordered in the sales order. You can
set up different adjustment breaks for different units of measure.
Weight
The system uses the weight assigned to the sales order detail line
item to determine the proper adjustment level break.
Amount
The system uses the extended amount of the sales order detail line to determine
the proper adjustment level break. When Currency Conversion is turned on, all amount-level breaks are stored and displayed based on the
floating decimals of the currency code.
None
The system uses advanced preference features to determine the proper adjustment level break.
Use this option only if you are using advanced preferences.
|
cAdjustmentControlCode | ACNT | char | NONE | NONE |
A code that specifies additional processing features related to an adjustment. Valid values are:
1
Do not print the adjustment on the invoice
or the purchase order print document. The system adds the adjustment amount to the unit price.
2
Print the adjustment on the invoice or the
purchase order print document. The system adds the adjustment amount to the unit price.
3
Update the Sales Order Detail File table (F4211) with
adjustment detail line information. The system will not include this type of adjustment when it calculates the current net price. Use this code for
order-level adjustments only.
4
Create an accrual adjustment. The system updates the Price Adjustment Ledger File table (F4074) and
posts the adjustment to the general ledger during the Sales Update process.
5
Create a rebate adjustment. The system updates the Rebate
Transaction Summary table (F4078) with the quantity, weight, and amount of the order detail line.
6
Print the adjustment on the invoice. The
system adds the adjustment to the order total, but does not include it in the unit price. The system will post separate G/L and A/R entries for this
adjustment during Sales Update.
7
Create a supplier proof of sale rebate adjustment. The system updates the Rebate Transaction Summary
table with the quantity, weight, and amount of the order detail line and posts the adjustment to the general ledger during Sales Update.
8
Create
a rounding adjustment, based on the rounding rules set up in the Price Adjustment Detail Revisions program (P4072). The system adds the
adjustment amount to the unit price.
|
mnAmtListPricePerUnit | LPRC | MATH_NUMERIC | NONE | NONE |
The list price in the unit of measure of the base price retrieved from the Base Price File (F4106). This is the price the customer would pay if
there were no price adjustments applied during Sales Order Entry. This price is stated in domestic currency. |
mnUnitsQuanBackorHeld | SOBK | MATH_NUMERIC | NONE | NONE |
The number of units backordered in Sales Order Management or in Work Order Processing, using either the entered or the primary unit of
measure defined for this item. |
mnUnitsQuantityShipped | SOQS | MATH_NUMERIC | NONE | NONE |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
item.
In the Manufacturing system and Work Order Time Entry, this field can indicate completed or scrapped quantities. The quantity type is
determined by the type code entered. |
mnUnitsQuantityCanceled | SOCN | MATH_NUMERIC | NONE | NONE |
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for
this item.
In manufacturing, this can also be the number of units scrapped to date. |
mnUnitsTransactionQty | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction.
|
cOrderLevelAdjustmentYN | OLVL | char | NONE | NONE |
A code that specifies the level at which the system calculates price adjustments. Valid values are:
1
Line level - The system calculates the
adjustment based on information in the sales order detail line.
2
Basket level - The system calculates the adjustment based on information
accumulated from all sales order detail lines that you have identified as a basket pricing group. You define the basket reprice group on the
Additional Information tab on the Item Branch Information form in the Item branch program (P41026). If you are defining a basket or order level
adjustment, leave the Item Group and Order Detail Group fields blank.
3
Order level - The system calculates the adjustment based on
information accumulated from all the sales order detail lines you have identified as an order pricing group. You define the order reprice group on the
Additional Information tab on the Item Branch Information form in the Item branch program. If you are defining a basket or order level
adjustment, leave the Item Group and Order Detail Group fields blank.
4
Volume incentive level - The system calculates the adjustment based on the
accumulated value of multiple sales orders. The accumulated value is based on how you define the adjustment in the Price Adjustment
Type program (P4071).
If you are working with the Agreement Management system, for Agreement Penalty Schedules, enter 1 to calculate the
penalty at the sales order detail-line level.
|
mnAmtPricePerUnit2 | UPRC | MATH_NUMERIC | NONE | NONE |
The list or base price to be charged for one unit of this item. In sales order entry, all prices must be set up in the Item Base Price File table
(F4106). |
mnRelatedPrice | RPRI | MATH_NUMERIC | NONE | NONE |
The price of a related item in a pricing or discount policy. For example, with a policy of "Buy one, get one free," the free item is the related
item. Enter this price in the unit of measure of the related item quantity. |
mnIdentifierShortItem | 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
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:
o Item Number (short) - An eight-digit, computer-assigned item number
o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number
o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number |
szTemporaryItemFlashMessag | TFLA | char | NONE | NONE |
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are:
blank Use the item-specific
unit of measure
1 Bypass the item-specific unit of measure and use the standard unit of measure |
szUnitOfMeasureAsInput | 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).
|
mnAmountUnitWeight | ITWT | MATH_NUMERIC | NONE | NONE |
The weight of one unit of an item, expressed in the primary unit of measure.
|
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
KG Kilogram
CW Hundredweight
TN Ton |
szCostCenter | 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
might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department.
Business unit security might prevent you from viewing information about business units
for which you have no authority.
|
cCommittedHS | COMM | char | NONE | NONE |
A value that indicates whether you specified from which Location and Lot a particular item was to come. If you specified a storage area, the
program assigns a Hard (H) commit, and subsequent programs will not determine which Location and Lot to use to satisfy the order line. If
you did not specify a storage area, the program assigns a Soft (S) commit and attempts to determine which Location and Lot records can best
satisfy the order line quantity.
Valid codes are:
S Soft Committed,
H Hard Committed
C Hard Committed by Commitment Program
K Kit
Master Line (No Commitment)
N Work Order (No Commitment) |
mnQtyNetDownPrice | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction.
|
cCurrencyMode | CRMD | char | NONE | NONE |
A code that indicates how documents are sent to a customer or supplier. It is part of the Accounts Payable Batch Upload process, and can
be used as a criterion when you write reports.
|
cNetDownQtyOrPrice | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event.
|
mnLastXREFNumber | LNIX | MATH_NUMERIC | NONE | NONE |
|
mnLineNoIncrement | 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
this number,but in some cases you can override it. |
szGlClass | 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
the value that you enter to the AAI item RC (for Accounts Receivable) or PC (for Accounts Payable) to locate the trade account. For
example, if you enter TRAD, the system searches for the AAI item RCTRAD (for receivables) or PCTRAD (for payables).
You can assign up to four
alphanumeric characters to represent the G/L offset or you can assign the three-character currency code (if you enter transactions in a
multicurrency environment). You must, however, set up the corresponding AAI item for the system to use; otherwise, the system ignores the G/L
offset and uses the account that is set up for PC or RC for the company specified.
If you set up a default value in the G/L Offset field of the
customer or supplier record, the system uses the value during transaction entry unless you override it.
Note: Do not use code 9999. It is reserved for
the post program and indicates that offsets should not be created.
|
szFreeGoodCatalogName | CATLG | char | OPT | NONE |
A group of items from which customers can choose when they qualify for a free good.
|
cItemSelected | EV02 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
mnDocumentOrderInvoiceE | 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,
and so on. |
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
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.)
The following document types are defined by J.D. Edwards and
should not be changed:
P
Accounts Payable documents
R
Accounts Receivable documents
T
Payroll documents
I
Inventory documents
O
Purchase Order Processing documents
J
General Accounting/Joint Interest Billing documents
S
Sales Order Processing documents
|
szCompanyKeyOrderNo | 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
sales order, and so on).
If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order
type, the order company lets you locate the desired document.
If you use the regular Next Numbers facility, the order company is not used to
assign a next number. In this case, you probably would not use the order company to locate the document. |
mnOriginalLineNumber | OGNO | MATH_NUMERIC | OPT | NONE |
A number identifying which line on the original order that the current line matches. |
cSubledgerInformation | SBIF | char | OPT | NONE |
A user defined code (system 40, type SI) that identifies the type of information that you want the system to use to update the Subledger field
in the General Ledger file (F0911) when you use this adjustment type to price a sales order. |
mnLastFGLnidAssigned | 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
this number,but in some cases you can override it. |
cProcessingMode | MODE | char | OPT | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. |
cSalesOrderStatus08 | SO08 | char | OPT | NONE |
A value of 1 in this field indicates to the system that this sales detail line was created during price adjustment processing to record an
upcharge or a discount. A value of 2 indicates that this detail line was created after invoicing as an adjustment line that should not have additional
processing performed on it.
During Sales Price Recalculation (P42950), these price adjustment lines will automatically be cancelled by the
system. The recalculation program will create new price adjustment lines, if necessary, to reflect the new unit price. All cancelled price
adjustment lines will have a Last Status of '987'.
Please note that free good lines created during price adjustment processing won't have a 1 in this
field. This is because the price recalculation module will not automatically cancel any free good lines. |