CalculateNewQuantities

Shipment Confirmation

Major Business Rule

Object Name: N4200790

Parent DLL: CSALES

Location: Client/Server

Language: NER

Functional Description

Purpose

This business function will provide the shipment confirmation edit line with the functionality to
calculate and verify the ship, cancel, and backorder quantities.

Setup Notes and Prerequisites

Special Logic

Technical Specification




2.3Related Business Functions





Source NameFunction Name


B4200200.CF4201 Get Hold Code, Order Totals and Information


2.4Processing 


1.If the Entered Quantity Shipped (SOQS-parm) is >= 0


//


// If not confirming the entire quantity and the backorder and cancel quantities have not been 

changed


//


If the Ship Quantity Difference-wf is > 0 and the Entered Backorder Quantity (SOBK-parm) = Original 

Backorder Quantity (SOBK-parm) and the Entered Cancel Quantity (SOCN-parm) = Original Cancel Quantity 

(SOCN-parm)


//


// If processing option set to auto BO or cancel remaining quantity not shipped


//


If Automatic BO or Cancel (EV07-parm) = '1'


Call business function F4201 Get Hold Code, Order Totals and Information (B4200200.C) and save the 

following value:


SH Backorders Allowed Flag-wf 


If the Backorder Allowed Flags are = 'Y' in the F4101, F4102, F4201 and F4211


//


// If backorder and partial ship are both allowed, backorder the difference.                If 

backorder is allowed but not partial ship, backorder the entire qty.


//


If the Partial Ship Allowed Flag (APTS-parm) = 'Y'


set the Quantity Backordered-dwf = Ship Quantity Difference-wf + Original Backorder Quantity 

(SOBK-parm)


else


set the Quantity Backordered-dwf = Original Ship Quantity (SOQS-parm)


set the Quantity Shipped-dwf = 0


endif


//


// If backorder is not allowed and partial ship is allowed, cancel the remaining qty.  If backorder 

and partial ship are both not allowed, cancel the entire quantity to be shipped.


//


else


If Partial Ship Flag (APTS-parm) = 'Y'


set Quantity Canceled-dwf = Entered Quantity Cancel (SOCN-parm) + Ship Quantity Difference-wf


else


set Quantity Canceled-dwf = Original Ship Quantity (SOQS-parm)


set Quantity Shipped-dwf = 0


endif


endif


set Ship Quantity Difference-wf = 0


endif


else


//


// If overshipping and the backorder and cancel quantities have not been changed, add additional 

qty to the order quantity.


//


If the Ship Quantity Difference-wf < 0


and the Entered Backorder Quantity (SOBK-parm) = Original Backorder Quantity (SOBK-parm)


and the Entered Cancel Quantity (SOCN-parm) = Original Cancel Quantity (SOCN-parm)


set Quantity Ordered-dwf = Quantity Ordered (UORG-parm) - Ship Quantity Difference-wf


endif


set Ship Quantity Difference-wf = 0


endif


else


//


// Credit orders.


// If overshipping and processing option not set to allow this, issue error.


//


If the Entered Quantity Shipped (SOQS-parm) < Original Quantity Shipped (SOQS-parm) and Prevent 

Overshipping (EV06-parm) = '1'


set error message '2717' and exit this edit


endif


//


// If partial confirming a line, subtract the remaining qty from the ordered qty.


//


If Ship Quantity Difference-wf >= 0


or Entered Quantity Backordered (SOBK-parm) is not = Original Quantity Backordered (SOBK-parm)


or Entered Quantity Cancel (SOCN-parm) is not = Original Quantity Cancel (SOCN-parm)


//


// If overshipping, add the additional qty to the order quantity.


//


If Ship Quantity Difference-wf > 0


and Entered Quantity Backordered (SOBK-parm) = Original Quantity Backordered (SOBK-parm)


and Entered Quantity Cancel (SOCN-parm) = Original Quantity Cancel (SOCN-parm)


set Quantity Ordered-dwf = Entered Quantity Ordered (UORG-parm) - Ship Quantity Difference-wf 


endif


set Ship Quantity Difference-wf = 0


endif


endif





2.Verify that the quantities balance.  Set Balance Quantity-wf = Entered Quantity Shipped 

(SOQS-parm) + Entered Quantity Backordered (SOBK-parm) + Entered Quantity Canceled (SOCN-parm).  If Balance 

Quantity-wf is not = Quantity Ordered (UORG-parm), set error message 0505.

Data Structure

D4200790D - Calculate New Quantities

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnOrderNumber	DOCO	MATH_NUMERIC	NONE	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	NONE	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
szOrderCompany	KCOO	char	NONE	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.
mnOriginalShipQuantity	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.
mnEnteredShipQuantity	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.
mnOriginalBackorderQuantity	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.
mnEnteredBackorderQuantity	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.
mnOriginalCancelQuantity	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.
cAutoBOCancel	EV07	char	NONE	NONE
An option that specifies the type of processing for an event.
cIMBackAllowed	BACK	char	NONE	NONE
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item Branch/Plant (P41026) programs, by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the Branch/Plant Constants program (P41001). Valid values are: On Allow backorders for this item. Off Do not allow backorders for this item, regardless of the backorders code that is assigned to the customer.
cIBBackAllowed	BACK	char	NONE	NONE
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item Branch/Plant (P41026) programs, by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the Branch/Plant Constants program (P41001). Valid values are: On Allow backorders for this item. Off Do not allow backorders for this item, regardless of the backorders code that is assigned to the customer.
cSDBackAllowed	BACK	char	NONE	NONE
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item Branch/Plant (P41026) programs, by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the Branch/Plant Constants program (P41001). Valid values are: On Allow backorders for this item. Off Do not allow backorders for this item, regardless of the backorders code that is assigned to the customer.
cPartialShipFlag	APTS	char	NONE	NONE
An option that indicates whether the customer accepts partial line shipments. Valid values are: On The customer accepts partial line shipments. No The customer does not accept partial shipments; the entire line must be shipped at one time.
cPreventOvership	EV06	char	NONE	NONE
An option that specifies the type of processing for an event.
mnEnteredCancelQuantity	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.
mnOrderQuantity	UORG	MATH_NUMERIC	NONE	NONE
The quantity of units affected by this transaction.
mnShipQuantityDifference	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.
cSHBackAllowed	BACK	char	OPT	NONE
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item Branch/Plant (P41026) programs, by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the Branch/Plant Constants program (P41001). Valid values are: On Allow backorders for this item. Off Do not allow backorders for this item, regardless of the backorders code that is assigned to the customer.
szCostCenter	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 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.
cConfiguredItemFlag	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnOriginalSecondaryQuantity	SQOR	MATH_NUMERIC	OPT	NONE
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens.
mnEnteredSecondaryQuantity	SQOR	MATH_NUMERIC	OPT	NONE
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens.
mnSecondaryShipQtyDifference	SQOR	MATH_NUMERIC	OPT	NONE
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens.
cDualPickingProcessOption	DPPO	char	OPT	NONE
An option that determines for a dual unit of measure item whether the system uses the primary or secondary unit of measure for the following processes: o Picking o Sales order availability checking o Committing inventory for sales o Splitting purchase order lines To use the primary unit of measure, do not choose this option. To use the secondary unit of measure, choose this option.
cDualUnitOfMeasureItem	DUAL	char	OPT	NONE
An option that indicates that the system must maintain inventory balances and record transactions for an item in a secondary unit of measure that does not have a fixed conversion to the primary unit of measure. Typically, you choose this option when the item is ordered or sold by a packaged quantity and priced by weight or volume. Note: For a dual unit of measure item, the system might require a tolerance check for inventory transactions (excluding inventory adjustments) between the primary unit of measure and the secondary unit of measure.
mnConvertedSecondaryQuantity	SOQS	MATH_NUMERIC	OPT	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.
mnConvFactorTranstoSecondary	CONV	MATH_NUMERIC	OPT	NONE
The factor that the system uses to convert one unit of measure to another unit of measure.
mnSecondaryOrderQuantity	UORG	MATH_NUMERIC	OPT	NONE
The quantity of units affected by this transaction.
mnDecimalsforRounding_SQOR	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnDecimalsforRounding_SOQS	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
cCIBackAllowed	BACK	char	OPT	NONE
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item Branch/Plant (P41026) programs, by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the Branch/Plant Constants program (P41001). Valid values are: On Allow backorders for this item. Off Do not allow backorders for this item, regardless of the backorders code that is assigned to the customer.
szErrorMessageID	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 special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
mnConvFactorSecondarytoTrans	CONV	MATH_NUMERIC	OPT	NONE
The factor that the system uses to convert one unit of measure to another unit of measure.

Related Functions

None

Related Tables

None

ComputeDualUOMConvFactors

Shipment Confirmation

Major Business Rule

Object Name: N4200790

Parent DLL: CSALES

Location: Client/Server

Language: NER

Data Structure

D4200790G - Compute Dual UOM Conversion Factors

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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).
szTransactionUOMPrimary	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 (each) or KG (kilogram).
szSecondaryUnitOfMeasure	UOM2	char	OPT	NONE
A user defined code (00/UM) that indicates an alternate unit of measure for the item.
szSecondaryUOMPrimary	UOM2	char	OPT	NONE
A user defined code (00/UM) that indicates an alternate unit of measure for the item.
mnInputConvFactorTranstoPrim	CONV	MATH_NUMERIC	OPT	NONE
The factor that the system uses to convert one unit of measure to another unit of measure.
mnConvFactorSecondarytoTrans	CONV	MATH_NUMERIC	OPT	NONE
The factor that the system uses to convert one unit of measure to another unit of measure.
mnConvFactorTranstoSecondary	CONV	MATH_NUMERIC	OPT	NONE
The factor that the system uses to convert one unit of measure to another unit of measure.
mnConvFactorSecndtoScndPrime	CONV	MATH_NUMERIC	OPT	NONE
The factor that the system uses to convert one unit of measure to another unit of measure.
mnSecondaryShipQuantity	SQOR	MATH_NUMERIC	OPT	NONE
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens.
szBranchPlant	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 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.
cItemMasterExists	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 containing this line type will be reflected in inventory. The system also edits the item that you enter to ensure that it is a valid item. Y is the default. A The system recognizes the number that you enter as a G/L account number. The system uses this code in purchasing only. B The system performs edits when using format 4 in purchase order entry. The system retrieves price data from the inventory tables, but does not update the quantity on the purchase order. This code is valid only when you have set the G/L Interface field to Y (yes). Budget checking is fully functional when you use this interface code. D The item in this line is an inventory item that will not affect availability or quantities. N The item is not an inventory item. To verify whether the item exists in the Item Master file, use Inventory Interface N in conjunction with the flag, Edit the Item Master for Non-Stock Items.
mnIdentifierShortItem	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 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
szStandardUOMConversion	TFLA	char	OPT	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
mnScndryPrimaryShipQuantity	SQOR	MATH_NUMERIC	OPT	NONE
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens.
mnScndryShipQuantityinTransUOM	SQOR	MATH_NUMERIC	OPT	NONE
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens.
cSuppressErrorMessage	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 runtime error message handling. 1 = suppress runtime error message handling.
szErrorMessageID	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 special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
cDualPickingProcessOption	DPPO	char	OPT	NONE
An option that determines for a dual unit of measure item whether the system uses the primary or secondary unit of measure for the following processes: o Picking o Sales order availability checking o Committing inventory for sales o Splitting purchase order lines To use the primary unit of measure, do not choose this option. To use the secondary unit of measure, choose this option.
mnDecimalsforRounding_SQOR	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnDecimalsforRounding_SOQS	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.

Related Functions

None

Related Tables

None

F42UI05DeleteCache

Shipment Confirmation

Major Business Rule

Object Name: N4200790

Parent DLL: CSALES

Location: Client/Server

Language: NER

Functional Description

Purpose

This function will clear  records from the cache.

Setup Notes and Prerequisites

None

Special Logic

If a specific line number is passed in to the Line Number From, and Line Number Thru, the function
will only clear the cache for those lines specified.  If no line number parameters are specified, the
function will clear the entire cache for the job number and computer id passed in.

Technical Specification

2.3 Related Business Functions

2.4 Processing

Clear the Ship Confirm by the Computer ID, Job Number, and line numbers specified.  If a From Line
Number is passed, but not a Thru Line Number, clear all records in the work file from that line number
on.  If a From and Thru Line Number are specified, clear those lines between the From and Thru Line
Numbers.

Clear the Inventory MBF Cache (XT4111Z1) if Inventory was relieved of On Hand^

Data Structure

D4200790C - F42UI05 Clear Work File

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnJobNumber	JOBS	MATH_NUMERIC	NONE	NONE
The job number (work station ID) which executed the particular job.
szComputerId	CTID	char	NONE	NONE

mnLineNumberFrom	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 this number,but in some cases you can override it.
mnLineNumberThru	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 this number,but in some cases you can override it.
cModeofCommitmentClear	MODE	char	OPT	NONE
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed.
szProgramId	PID	char	OPT	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.

Related Functions

None

Related Tables

None

F42UI05EditLine

Shipment Confirmation

Master Business Function

Object Name: N4200790

Parent DLL: CSALES

Location: Client/Server

Language: NER

Data Structure

D4200790A - F42UI05 Edit Line

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnWorkFileLineNumber	XLIN	MATH_NUMERIC	NONE	NONE
Special Input Expected For Future Use - Not Currently Used. ^
cProcessEdits	EV01	char	NONE	NONE
Special Input Expected Future - Not currently in Use ^
cErrorConditions	ERRC	char	NONE	NONE
Special Output Returned Indicates Data Edit status for record processed by Ship Confirm EditLine. Significant Data Values "" - Success 1 - Warning 2 - Error ^
cUpdateWrite	EV03	char	NONE	NONE
Special Input Expected Future - Not currently in Use. ^
cRecordWritten	EV04	char	NONE	NONE
Special Input Expected Pass this value to Edit Line. This parameter is needed by the Edit Line function to determine if record has already been written to the Ship Confirm Cache. Special Output Returned Return value should be kept track of by the calling application. Significant Data Values "" - Record not in Cache 1 - Record in Cache ^
mnOrderNumber	DOCO	MATH_NUMERIC	NONE	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	NONE	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
szOrderCompany	KCOO	char	NONE	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.
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 this number,but in some cases you can override it.
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 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.
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.
mnEnteredShipQuantity	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.
mnEnteredBackorderQuantity	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.
mnEnteredCancelQuantity	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.
szEnteredLineType	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 General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under which a line prints on reports, and it is included in calculations. Codes include the following: S Stock item J Job cost N Nonstock item F Freight T Text information M Miscellaneous charges and credits W Work order
szContainerID	CNID	char	NONE	NONE
A code on the container or that you assign to the container in which the items on this purchase order or order line were shipped to you. You can assign container information to an order during receipts entry.
mnCarrier	CARS	MATH_NUMERIC	NONE	NONE
The address number for the preferred carrier of the item. The customer or your organization might prefer a certain carrier due to route or special handling requirements.
mnUnitPrice	UPRC	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - Not currently in use. ^
mnUnitCost	UNCS	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - Not currently in use. ^
mnExtendedCost	ECST	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - Not currently in use. ^
mnExtendedPrice	AEXP	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - Not currently in use. ^
jdActualDeliveryDate	ADDJ	JDEDATE	NONE	NONE
Special Input Expected Future - Not currently in use. ^
szProgramID	PID	char	NONE	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
mnLastLineNumber	LNIX	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - Not currently in use. ^
cWriteIfWarning	EV08	char	NONE	NONE
Significant Data Values 1 - Write if warning ^
mnReferenceLinenumber	LNID	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - Not currently in use. ^
szDescription	DSC1	char	NONE	NONE
Brief information about an item; a remark or an explanation.
mnJobnumberA	JOBS	MATH_NUMERIC	NONE	NONE
The job number (work station ID) which executed the particular job.
szUserId	USER	char	NONE	NONE
The code that identifies a user profile.
szWorkStationId	JOBN	char	NONE	NONE
The code that identifies the work station ID that executed a particular job.
szVersion	VER	char	NONE	NONE
Special Input Expected Pass version name Ship Confirm Edit Line will use to retrieve Process Option Values from. ^
cActionCode	ACTION	char	NONE	NONE
Special Input Expected Action Code passed in by calling appliction to determine action to be taken on Ship Confirm Sale Order Line. Significant Data Values C - Normal Ship Confirm Line S - Multi-Location Ship Confirm Child Line D - Delete record from Ship Confirm Cache. Line will not be Ship Confirmed. A - Additional Line Item (FUTURE) ^
cModeProcessing	MODE	char	NONE	NONE
Special Input Expected Future - Not currently in use. ^
mnTRAN_ShipmentNumber	PTNR	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - (Transportation Parameter) Not currently in Use. ^
jdTRAN_DeliveryDate	DLDT	JDEDATE	NONE	NONE
Special Input Expected Future - (Transportation Parameter) Not currently in use. ^
cTRAN_InventoryAffectFlag	EV09	char	NONE	NONE
An option that specifies the type of processing for an event.
szTRAN_OverrideDocumentType	DCT	char	NONE	NONE
Special Input Expected Future - (Transportation Parameter) Not currently in Use. ^
mnTRAN_OverrideInventoryDocNum	DOC	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - (Transportation Parameter) Not currently in use. ^
szTRAN_OverrideNextStatus	NXTR	char	NONE	NONE
Special Input Expected Future - (Transportation Parameter) - Not currently in use. ^
cTRAN_OverrideLeaveShippable	EV10	char	NONE	NONE
Special Input Expected Future - (Transportation Parameter) Not Currently in Use. ^
mnBULK_AmbientQtyEntered	AMBR	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
szBULK_AmbientQtyEnteredUOM	BUM3	char	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
mnBULK_StandardQtyEntered	STOK	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
szBULK_StandardQtyEnteredUOM	BUM4	char	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
mnBULK_WeightQtyEntered	WGTR	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
mnBULK_Temperature	TEMP	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
cBULK_ProductTemperatureType	STPU	char	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
mnBULK_ProductDensity	DEND	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
mnBULK_DensityTemperature	DETP	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
cBULK_DensityTemperatureType	DTPU	char	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
mnBULK_TransactionTime	TDAY	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
szBULK_WeightQtyEnteredUOM	BUM5	char	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
cBULK_ProductDensityType	DNTP	char	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
mnBulk_VolumeCorrectionFactors	VCF	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - (Bulk Parameter) Not currently in use. ^
szOriginal_CompanyKeyOrderNo	KCOO	char	NONE	NONE
Special Input Expected Future - not currently in use. ^
szOriginal_OrderType2	ORTY	char	NONE	NONE
Special Input Expected Future - Not currently in use. ^
mnOriginal_OrderNumber	DOCO	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - Not currently in use. ^
mnOriginal_LineNumber_3	LNID	MATH_NUMERIC	NONE	NONE
Special Input Expected This parameter is used when calling Edit Line for a Multi Location Split chile Line. Edit line requires this value to access the parent split line record. ^
szMemoLotField1	LOT1	char	NONE	NONE
A higher classification or grouping of serial number or lot processed items,maintained within the Lot Master (F4108).
szMemoLotField2	LOT2	char	NONE	NONE
A higher classification or grouping of memo lot 1 maintained within the lot master (F4108).
szVendorLotNumber	RLOT	char	NONE	NONE
The supplier's lot number for the item.
mnXT4111LineNumber	XLIN	MATH_NUMERIC	NONE	NONE
Special Input Expected Pass a blank the first time the record is passed to Ship Confirm Edit Line. Special Output Returned The calling application (interactive applications) will keep track of the value returned from Edit Line. If hard committing the inventory, the return value will always be blank. Significant Data Values "" - Record has not been written to the Inventory MBF (XT4111) Cache. 1 - Record has been written to the Inventory MBF (XT4111Z1) Cache. ^
mnB4200310LineNumber	XLIN	MATH_NUMERIC	NONE	NONE
Special Input Expected Future - not currently in use. ^
szUnitOfMeasureAsInput	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).
mnMultiLocQtyShipVariance	CPQS	MATH_NUMERIC	OPT	NONE
The difference between the original Sales Order shipped amount and the new calculated Sales Order shipped quantity. This field maintains the 'net change'in an order line's shipped quantity during inventory processing.
mnMultiLocParentOrderQuantity	UOR2	MATH_NUMERIC	OPT	NONE
The number of units affected by this transaction.
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, including street, city, state, zip code, and country.
szLineType_2	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 General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under which a line prints on reports, and it is included in calculations. Codes include the following: S Stock item J Job cost N Nonstock item F Freight T Text information M Miscellaneous charges and credits W Work order
mnAddressNumber	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 location.
mnContractSupplementDistri	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 agreements that are tied to a master agreement. The system allows up to 999 different supplements per base agreement number.
szContractNumberDistributi	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 number (for example,an agreement type code, location, year, and so forth). An agreement might have multiple supplements to record addendum or changes, for example.
szTRAN_PrimaryVehicleId	PVEH	char	OPT	NONE
Represents either the primary vehicle identification number in a connected vehicle or the identification number for a single vehicle.
szTRAN_RegistrationLicenseNum	RLNO	char	OPT	NONE
Identifies the identification number that appears on the license, permit, or certificate.
mnTRAN_UnitCostOverride	UNCS	MATH_NUMERIC	OPT	NONE
The amount per unit, derived by dividing the total cost by the unit quantity.
szTRAN_DocumentCompany	KCO	char	OPT	NONE
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher, or journal entry. If you use the Next Numbers by Company/Fiscal Year feature, the Automatic Next Numbers program (X0010) uses the document company to retrieve the correct next number for that company. If two or more original documents have the same document number and document type, you can use the document company to locate the desired document.
jdTRAN_LoadConfirmDate	LDDT	JDEDATE	OPT	NONE
The date this order line is load confirmed.
mnTRAN_TimeLoad	LDTM	MATH_NUMERIC	OPT	NONE
The actual time that the vehicle was loaded.
szComputerID	CTID	char	OPT	NONE

mnUnitsSecondaryQtyOr	SQOR	MATH_NUMERIC	OPT	NONE
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens.
szUnitOfMeasureSecondary	UOM2	char	OPT	NONE
A user defined code (00/UM) that indicates an alternate unit of measure for the item.
mnMultiLocSecondaryQtyShipVar	SQOR	MATH_NUMERIC	OPT	NONE
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens.
mnMultiLocSecondaryOrderQty	UOR2	MATH_NUMERIC	OPT	NONE
The number of units affected by this transaction.
cCheckExpirationDate	EDCK	char	OPT	NONE
An option that determines whether the system ensures that a lot be shipped in ascending order in relation to other lots that have already been shipped. When you choose this option, the system enforces the ship ascending lot rule based on the expiration date to ensure that the lot being shipped has an expiration date that is greater than that of the lots that have been previously shipped.
cCheckSellByDate	SBCK	char	OPT	NONE
An option that indicates whether the system ensures that a lot being shipped to a customer is shipped in ascending order by the sell by date. If you choose this option, the system ensures that each lot that is being shipped has a sell by date that is greater than or equal to the date on which the last lot was shipped.
cCheckBestBeforeDate	BBCK	char	OPT	NONE
An option that specifies whether the system ensures that the lot that you are shipping to a customer has a value in the Best Before Date field that is greater than or equal to the value for the last lot that you shipped.
jdBasedOnDate	BODJ	JDEDATE	OPT	NONE
The date that the system uses in conjunction with the shelf life days to calculate the lot expiration date. You can enter this date during inventory completions. In addition to calculating the lot expiration date, the system uses the date that you enter in this field to calculate the following lot dates: o Sell By Date o Best Before Date o Lot Effectivity Date o User Lot Date 1 o User Lot Date 2 o User Lot Date 3 o User Lot Date 4 o User Lot Date 5
jdLotEffectivityDate	DLEJ	JDEDATE	OPT	NONE
The date on which a lot becomes available. The system uses this date for availability and commitment processing to indicate that the lot is available on or after the date that you specify. You must complete this field when inventory first becomes an on-hand quantity for the lot. If you leave this field blank, the system calculates the effective date of the lot by using the value for Effective Days in the Item Branch File table (F4102) or the current date if the value for Effective Days is zero.
cShipAscendingDateFlag	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
jdSellByDate	SBDJ	JDEDATE	OPT	NONE
The date by which a lot should be completely sold. The system uses this date as a "through" date for commitment processing. The system calculates the sell by date using the value in the Sell By Days field, which is contained in the Item Branch File table (F4102), when inventory becomes available on-hand.
jdBestBeforeDate	BBDJ	JDEDATE	OPT	NONE
The last date on which the products in a lot should be consumed. The system calculates the date by retrieving the value from the Best Before Days field in the Item Master program (P4101). You can also use this date as a "through" date for commitment processing. You can commit a lot by this date by using the Commitment Date Method field in the Item Branch program (P41026).
jdUserLotDate1	U1DJ	JDEDATE	OPT	NONE
A date that the system can use as a through date for commitment processing. The system stores this date in the Lot Master table (F4108). If you leave this field blank, the system can calculate the date by using the value for the User Lot Date 1 Default Days field, which is stored in the Item Branch File table (F4102).
jdUserLotDate2	U2DJ	JDEDATE	OPT	NONE
A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to the Lot Expiration Date, User Lot Date 2 is a through date for commitment processing. The User Lot Date 2 commitment option is available in the Commitment Date Method in the Item Branch table (F4102). The system uses the User Lot Date 2 Default Days from the Item Branch table (F4102) to calculate User Lot Date 2 when inventory first goes on hand.
jdUserLotDate3	U3DJ	JDEDATE	OPT	NONE
A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to Lot Expiration Date, User Lot Date 3 is a through date for commitment processing. The User Lot Date commitment option is available in the Commitment Date Method in the Item Branch table (F4102). The system uses the User Lot Date 3 Default Days from the Item Branch table (F4102) to calculate User Lot Date 3 when inventory first goes on hand.
jdUserLotDate4	U4DJ	JDEDATE	OPT	NONE
A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to Lot Expiration Date, User Lot Date 4 is a through date for commitment processing. The User Lot Date commitment option is available in the Commitment Date Method in the Item Branch table (F4102). The system uses the User Lot Date 4 Default Days from the Item Branch table (F4102) to calculate User Lot Date 4 when inventory first goes on hand.
jdUserLotDate5	U5DJ	JDEDATE	OPT	NONE
A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to Lot Expiration Date, User Lot Date 5 is a through date for commitment processing. The User Lot Date 5 commitment option is available in the Commitment Date Method in the Item Branch table (F4102). The system uses the User Lot Date 5 Default Days from the Item Branch table (F4102) to calculate User Lot Date 5 when inventory first goes on hand.
mnInvTransactionType	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
szPortOfEntryExit	POE	char	OPT	NONE
The port from which or to which the goods were shipped. For VAT reporting, certain countries require information about the port of exit or entry. This information is not available in the system at the present time. You specify the port of entry or exit when creating a purchase order by using the PO Receipts program (P4312), when creating a sales order by using the Sales Order Entry program (P4210), when confirming shipments by using the Shipment Confirmation program (P4205), or by using the Intrastat Revision program (P0018T). Set up valid values in UDC 40/PE.
mnActualShipmentTime	ADTM	MATH_NUMERIC	OPT	NONE
The actual time of shipment. Enter the time using the 24-hour time format (HHMMSS). For example, enter 6:00 a.m. as 060000, and enter 7:00 p.m. as 190000.
cUse_Next_Order_Status_Pre	UNOP	char	OPT	NONE

cCalledByTransportation	ONOF	char	OPT	NONE
Specifies an indicator setting. 0 represents an indicator off setting. 1 represents an indicator on setting.
jdDateLotExpiration	MMEJ	JDEDATE	OPT	NONE
The date on which a lot of items expires. The system automatically enters this date if you have specified the shelf life days for the item on Item Master Information or Item Branch/Plant Information. The system calculates the expiration date by adding the number of shelf life days to the date that you receive the item. You can commit inventory based on the lot expiration date for items. You choose how the system commits inventory for an item on Item Master Information or Item Branch/Plant Information.

Related Functions

None

Related Tables

None

KitProcessing

Shipment Confirmation

Minor Business Rule

Object Name: N4200790

Parent DLL: CSALES

Location: Client/Server

Language: NER

Data Structure

D4200790F - Kit Processing

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnJobnumber	JOBS	MATH_NUMERIC	NONE	NONE
The job number (work station ID) which executed the particular job.
mnDocumentOrderNumber	DOCO	MATH_NUMERIC	NONE	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	NONE	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	NONE	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.
mnLineNumberOfKitParent	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 this number,but in some cases you can override it.
cBackordersAllowedYN	BACK	char	NONE	NONE
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item Branch/Plant (P41026) programs, by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the Branch/Plant Constants program (P41001). Valid values are: On Allow backorders for this item. Off Do not allow backorders for this item, regardless of the backorders code that is assigned to the customer.
cPartialShipmntsAllow	APTS	char	NONE	NONE
An option that indicates whether the customer accepts partial line shipments. Valid values are: On The customer accepts partial line shipments. No The customer does not accept partial shipments; the entire line must be shipped at one time.
cCheckAvailabilityYN	CKAV	char	NONE	NONE
A code that specifies whether the system performs availability checking. You might want to turn on availability checking for certain items. For other items, if you assume that an adequate supply is available, leave availability checking turned off. For PeopleSoft World, valid values are: Y The system performs availability checking. N The system does not perform availability checking. For PeopleSoft EnterpriseOne, a check mark indicates that availability checking is turned on.
cPO_PreventNegativeOnHand	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cPO_ErrorOnHeldLocations	EV02	char	NONE	NONE
An option that specifies the type of processing for an event.
mnQuantityShippedParent	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.
mnQuantityBackorderedParent	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.
mnQuantityCanceledParent	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.
idShipConfirmCacheCursor	GENLNG	ID	NONE	NONE
General purpose ID variable.
cModeProcessing	MODE	char	NONE	NONE
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed.
szErrorMessageID	DTAI	char	NONE	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 special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
cSuppressErrorMessage	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnParentItemNumber	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
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 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.
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).
mnQuantityOrderedParent	UORG	MATH_NUMERIC	NONE	NONE
The quantity of units affected by this transaction.
szComputerID	CTID	char	NONE	NONE

cActionCode	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 Clear the screen NOTE: Depending on how your company has set up action code security, you may not be authorized to use all action codes.
szVersion	VERS	char	OPT	NONE
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
cUpdateWrite	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cRecordWritten	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cWriteifWarning	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cSDAllowBackorder	BACK	char	OPT	NONE
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item Branch/Plant (P41026) programs, by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the Branch/Plant Constants program (P41001). Valid values are: On Allow backorders for this item. Off Do not allow backorders for this item, regardless of the backorders code that is assigned to the customer.
cIBBackorderFlag	BACK	char	OPT	NONE
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item Branch/Plant (P41026) programs, by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the Branch/Plant Constants program (P41001). Valid values are: On Allow backorders for this item. Off Do not allow backorders for this item, regardless of the backorders code that is assigned to the customer.
cIMBackorderFlag	BACK	char	OPT	NONE
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item Branch/Plant (P41026) programs, by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the Branch/Plant Constants program (P41001). Valid values are: On Allow backorders for this item. Off Do not allow backorders for this item, regardless of the backorders code that is assigned to the customer.
jdActualDeliveryDate	ADDJ	JDEDATE	OPT	NONE
The date on which the shipment to the customer is confirmed as shipped. During shipment confirmation, the system updates the Sales Order Detail table (F4211) with this date.
cPO_OverrideRelieveOnHand	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnTran_ShipmentNumber	PTNR	MATH_NUMERIC	OPT	NONE
A number that identifies an entry in the Address Book system. The partner is the entity or company with whom you have a contract or agreement.
jdTran_DeliveryDate	DLDT	JDEDATE	OPT	NONE
The delivery date of a shipment.
cTran_InventoryAffectFlag	EV09	char	OPT	NONE
An option that specifies the type of processing for an event.
mnTran_OverrideInventoryDONUM	DOC	MATH_NUMERIC	OPT	NONE
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document number or let the system assign it using the Next Numbers program (P0002). Matching document numbers (DOCM) identify related documents in the Accounts Receivable and Accounts Payable systems. Examples of original and matching documents are: Accounts Payable o Original document - voucher o Matching document - payment Accounts Receivable o Original document - invoice o Matching document - receipt Note: In the Accounts Receivable system, the following transactions simultaneously generate original and matching documents: deductions, unapplied receipts, chargebacks, and drafts.
szTran_OverrideNextStatus	NXTR	char	OPT	NONE
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type.
cTran_OverrideLeaveShippable	EV10	char	OPT	NONE
An option that specifies the type of processing for an event.
szTrans_PrimaryVehicleId	PVEH	char	OPT	NONE
Represents either the primary vehicle identification number in a connected vehicle or the identification number for a single vehicle.
szTran_RegistrationLicenseNum	RLNO	char	OPT	NONE
Identifies the identification number that appears on the license, permit, or certificate.
mnTran_UnitCostOverride	UNCS	MATH_NUMERIC	OPT	NONE
The amount per unit, derived by dividing the total cost by the unit quantity.
szTran_DocumentCompany	KCO	char	OPT	NONE
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher, or journal entry. If you use the Next Numbers by Company/Fiscal Year feature, the Automatic Next Numbers program (X0010) uses the document company to retrieve the correct next number for that company. If two or more original documents have the same document number and document type, you can use the document company to locate the desired document.
jdTran_LoadConfirmDate	LDDT	JDEDATE	OPT	NONE
The date this order line is load confirmed.
mnjdTran_TimeLoad	LDTM	MATH_NUMERIC	OPT	NONE
The actual time that the vehicle was loaded.
szTran_OverrideDocumentType	DCT	char	OPT	NONE
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document types, such as, vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are: P Accounts payable documents R Accounts receivable documents T Time and Pay documents I Inventory documents O Purchase order documents S Sales order documents
mnCarrier	CARS	MATH_NUMERIC	OPT	NONE
The address number for the preferred carrier of the item. The customer or your organization might prefer a certain carrier due to route or special handling requirements.
mnActualShipmentTime	ADTM	MATH_NUMERIC	OPT	NONE
The actual time of shipment. Enter the time using the 24-hour time format (HHMMSS). For example, enter 6:00 a.m. as 060000, and enter 7:00 p.m. as 190000.
mnConvFactorTranToPrim	CONV	MATH_NUMERIC	OPT	NONE
The factor that the system uses to convert one unit of measure to another unit of measure.
mnKitQtyOrderPrimaryUoM	UORG	MATH_NUMERIC	OPT	NONE
The quantity of units affected by this transaction.
szLotGroup	LOTGRP	char	OPT	NONE
Lot Group is the name of a user defined list of allowed non-blank lot status codes. Entry of a Lot Group name in the Processing Option will allow this Application to process lots whose lot status code is defined within the specified Lot Group Name.

Related Functions

None

Related Tables

None

ShipConfirmEditDoc

Shipment Confirmation

Master Business Function

Object Name: N4200790

Parent DLL: CSALES

Location: Client/Server

Language: NER

Data Structure

D4200790H - Shipment Confirmation Edit Document

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnJobNumber	JOBS	MATH_NUMERIC	REQ	NONE
The job number (work station ID) which executed the particular job.
szComputerID	CTID	char	OPT	NONE

szProgramId	PID	char	OPT	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
szProgramType	MUTYPE	char	OPT	NONE
The type of system data object, such as the data dictionary or user defined codes.
szErrorMessageID	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 special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
cCalledByTransportation	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cReconcileCartonShipmentDetail	RCSD	char	OPT	NONE
A code that indicates whether the system reconciles carton detail information with shipment detail information. Blank The system does not reconcile carton detail information with shipment detail information. 1 The system does reconcile carton detail information with shipment detail information.
mnShipmentNumber	SHPN	MATH_NUMERIC	OPT	NONE
A "next number" that uniquely identifies a shipment.
mnLoadNumber	LDNM	MATH_NUMERIC	OPT	NONE
1
idWorkFlowErrorID_GENLNG	GENLNG	ID	OPT	NONE
General purpose ID variable.

Related Functions

None

Related Tables

None

ShipConfirmEndDoc

Shipment Confirmation

Master Business Function

Object Name: N4200790

Parent DLL: CSALES

Location: Client/Server

Language: NER

Data Structure

D4200790B - F42UI05 End Document

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnJobNumber	JOBS	MATH_NUMERIC	NONE	NONE
The job number (work station ID) which executed the particular job.
szComputerId	CTID	char	NONE	NONE

cErrorCondition	ERRC	char	NONE	NONE
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).
szBackorderNextStatus	NXTR	char	NONE	NONE
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type.
szUserId	USER	char	NONE	NONE
The code that identifies a user profile.
szR42565Version	VL17	char	OPT	NONE
The list of selection values associated with a selection item in the Dream Writer. This list is generated by the use of the 'VALUES' keyword in data selection set-up. Elements 1 and 2 of this array are also used to contain the upper and lower value for the keyword 'RANGE' utilized by the data selection processing in the Dream Writer.
cTRANSyncEndDoc	EV01	char	OPT	NONE
Special Input Expected Future - (Transportation) not currently in use. ^
mTRANJobsNumber	JOBS	MATH_NUMERIC	OPT	NONE
Special Input Expected Future - (Transporation) not currently in use. ^
szP4205Version	VER	char	OPT	NONE
Identifies a specific set of data selection and sequencing settings for the application. Versions may be named using any combination of alpha and numeric characters. Versions that begin with 'XJDE' or 'ZJDE' are set up by J.D. Edwards.
mnShipmentNumber	SHPN	MATH_NUMERIC	OPT	NONE
A "next number" that uniquely identifies a shipment.
idXAPIWorkflowErrorID	GENLNG	ID	OPT	NONE
General purpose ID variable.
szCartonNextStatus	CRSS	char	OPT	NONE
A user defined code (46/CS) that the system assigns to a carton. Each status code represents a different stage in the distribution cycle.
szP4210VersionCartonQtyBased	VERS	char	OPT	NONE
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
szP4210VersionItemQtyBasedInv	VERS	char	OPT	NONE
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
szP4210VersionItemQtyBasedChrg	VERS	char	OPT	NONE
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
cCreateSalesOrderCartonCharge	CSOC	char	OPT	NONE
An option that specifies whether the system creates a charge on the sales order for cartons. The charge is based on carton quantity (which is calculated from carton detail information) and the price setup for the item number that is assigned to the carton.

Related Functions

None

Related Tables

None

ValidateStatusCodes

Shipment Confirmation

Major Business Rule

Object Name: N4200790

Parent DLL: CSALES

Location: Client/Server

Language: NER

Functional Description

Purpose

This business function will provide the shipment confirmation edit line with the functionality to validate the status codes.

Technical Specification



2.3Related Business Functions





Source NameFunction Name


B4000260.CF40302 Verify Activity Rule Status Code


B4000960.COrders, Orders, Verify Override Next Status


2.4Processing 


1.Set Status Validated Flag-wf = '1'.





2.Call business function Verify Activity Rule Status Code(B4000260.C) and save the following values:


Activity Rules Next Status-wf 


Allowed Status1-wf


Allowed Status2-wf


Allowed Status3-wf


Allowed Status4-wf


Allowed Status5-wf


Write Ledger Flag-wf





3.If the Entered Shipped Quantity (SOQS-parm) is not 0 or the IVI-wf is = 'N'; 


If the Next Status For Confirmed Lines (EV01-parm) is not ' '


Validate the status code using Orders, Verify Override Next Status(B4000960.C). 


If the status code is invalid, set error message '0280' and set Status Validated Flag-wf = '0'.


endif


endif





4.If the Ship Quantity Difference-parm is 0 and the Next Status For B/O Lines (NXTR-parm) is not ' '


If the Entered Quantity Backordered (SOBK-parm) is not 0 or the Entered Quantity Canceled (SOCN-parm) is not 0


Validate the Next Status For B/O Lines (EV02-parm) using Orders, Verify Override Next Status(B4000960.C). If the 

status code is invalid, set error message '0280' and set Status Validated Flag-wf = '0'.


endif





5.If Status Validated Flag-wf = '1' 


If the Next Status for Confirmed Lines (EV01-parm) is not ' '


set Next Status for Split Line-wf = Next Status for Confirmed Lines (EV01-parm)


else


set Next Status for Split Line-wf = Activity Rules Next Status-wf


end


//


// Update the last and next status codes if there isn't any partial shipment or this is a non stock line.


//


If the Ship Quantity Difference-wf is 0 or the IVI-wf is = 'N'


set the Last Status-dwf = Next Status (NXTR-parm)


//


// If backorder or cancel and a BO status was specified in the PO, use it to update


//


If Entered Quantity Backordered (SOBK-parm) <> 0 or the Entered Quantity Canceled <> 0


If Next Status for B/O Lines (EV02-parm) <> blank


set Next Status-dwf = Next Status for B/O Lines (EV02-parm)


endif


Stop Processing


endif


//


// If a confirmed status was not specified in PO, use the default from the Order Activity Rules


//


If the Next Status for Confirmed Lines (EV01-parm) is not ' '


set the Next Status-dwf = Next Status for Confirmed Lines  (EV01-parm)


else


set the Next Status-dwf = Activity Rules Next Status-wf


endif


endif


endif

Data Structure

D4200790E - Validate Status Codes

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnOrderNumber	DOCO	MATH_NUMERIC	NONE	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	NONE	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
szOrderCompany	KCOO	char	NONE	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.
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 General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under which a line prints on reports, and it is included in calculations. Codes include the following: S Stock item J Job cost N Nonstock item F Freight T Text information M Miscellaneous charges and credits W Work order
szNextStatus	NXTR	char	NONE	NONE
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type.
mnEnteredShipQuantity	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.
mnOriginalShipQuantity	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.
mnEnteredBackorderQty	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.
mnEnteredCancelQuantity	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.
szConfirmedNextStatus	NXTR	char	NONE	NONE
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type.
szBOCanNextStatus	NXTR	char	NONE	NONE
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type.
szLastStatus	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.
cInventoryInterface	IVI	char	NONE	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 containing this line type will be reflected in inventory. The system also edits the item that you enter to ensure that it is a valid item. Y is the default. A The system recognizes the number that you enter as a G/L account number. The system uses this code in purchasing only. B The system performs edits when using format 4 in purchase order entry. The system retrieves price data from the inventory tables, but does not update the quantity on the purchase order. This code is valid only when you have set the G/L Interface field to Y (yes). Budget checking is fully functional when you use this interface code. D The item in this line is an inventory item that will not affect availability or quantities. N The item is not an inventory item. To verify whether the item exists in the Item Master file, use Inventory Interface N in conjunction with the flag, Edit the Item Master for Non-Stock Items.
mnShipQuantityDifference	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.
szNextStatusSplitLine	NXTR	char	NONE	NONE
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type.
cOverShipConditionFlag	PROM	char	OPT	NONE
The processing mode used to enter a contract. Values are: 1 Line Item. An individual commitment line item is maintained for the base contract and each change order. You enter progress payments, using the Progress Payments Entry screen, on a line item by line item basis for the base contract and each change order. 3 Account Method - Incremental. The system summarizes all line item amounts for the base contract and each change order by account. However, when you enter a change order, you enter the actual amount of the change order. The system adds that amount to the existing total of the correct amount. You must enter all change order amounts as incremental contract amounts. For example, if your base contract amount is 1000 and you add a change order for 143, you enter the change order amount as 143. This lets you enter progress payments against an account total for the base contract and each change order, not just individual items. The processing mode for a contract is specified in the processing options of the Contract Entry and Commitment Revisions screens when the contract is entered.
cFlagWriteLedgerRecrd	WRTH	char	OPT	NONE
A code that tells the system to write a record to the history table (F42199 for Sales Order Management and F43199 for Purchase Order Management). Valid codes are: Y Write a record for selected fields to the history table N Do not write a record to the history table
cStatusCodeValidation01	ERR	char	OPT	NONE
The Data Field Error Code field is simply a generic data field to pass an error condition flag. This field is one of the fields that make up the external parameter data structure of the Data Dictionary Server.

Related Functions

None

Related Tables

None

span>

^

mnB4200310LineNumberXLINMATH_NUMERICNONENONE

Special Input Expected
Future - not currently in use.

^

szUnitOfMeasureAsInputUOMcharOPTNONE

A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).

mnMultiLocQtyShipVarianceCPQSMATH_NUMERICOPTNONE

The difference between the original Sales Order shipped amount and the new calculated Sales Order shipped quantity. This field
maintains the 'net change'in an order line's shipped quantity during inventory processing.

mnMultiLocParentOrderQuantityUOR2MATH_NUMERICOPTNONE

The number of units affected by this transaction.

mnAddressNumberShipToSHANMATH_NUMERICOPTNONE

The address number of the location to which you want to ship this order. The address book provides default values for customer address,
including street, city, state, zip code, and country.

szLineType_2LNTYcharOPTNONE

A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under
which a line prints on reports, and it is included in calculations. Codes include the following: S Stock item J Job cost N Nonstock item F Freight
T Text information M Miscellaneous charges and credits W Work order

mnAddressNumberAN8MATH_NUMERICOPTNONE

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

mnContractSupplementDistriDMCSMATH_NUMERICOPTNONE

The supplement number records any changes or addendum to agreements that occur over time or by item. It can also indicate individual
agreements that are tied to a master agreement. The system allows up to 999 different supplements per base agreement number.

szContractNumberDistributiDMCTcharOPTNONE

A unique number your company assigns to identify a particular agreement. You might want to assign some significance to the agreement
number (for example,an agreement type code, location, year, and so forth). An agreement might have multiple supplements to record
addendum or changes, for example.

szTRAN_PrimaryVehicleIdPVEHcharOPTNONE

Represents either the primary vehicle identification number in a connected vehicle or the identification number for a single vehicle.

szTRAN_RegistrationLicenseNumRLNOcharOPTNONE

Identifies the identification number that appears on the license, permit, or certificate.

mnTRAN_UnitCostOverrideUNCSMATH_NUMERICOPTNONE

The amount per unit, derived by dividing the total cost by the unit quantity.

szTRAN_DocumentCompanyKCOcharOPTNONE

A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
or journal entry. If you use the Next Numbers by Company/Fiscal Year feature, the Automatic Next Numbers program (X0010) uses the
document company to retrieve the correct next number for that company. If two or more original documents have the same document number and
document type, you can use the document company to locate the desired document.

jdTRAN_LoadConfirmDateLDDTJDEDATEOPTNONE

The date this order line is load confirmed.

mnTRAN_TimeLoadLDTMMATH_NUMERICOPTNONE

The actual time that the vehicle was loaded.

szComputerIDCTIDcharOPTNONE

mnUnitsSecondaryQtyOrSQORMATH_NUMERICOPTNONE

If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens.

szUnitOfMeasureSecondaryUOM2charOPTNONE

A user defined code (00/UM) that indicates an alternate unit of measure for the item.

mnMultiLocSecondaryQtyShipVarSQORMATH_NUMERICOPTNONE

If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens.

mnMultiLocSecondaryOrderQtyUOR2MATH_NUMERICOPTNONE

The number of units affected by this transaction.

cCheckExpirationDateEDCKcharOPTNONE

An option that determines whether the system ensures that a lot be shipped in ascending order in relation to other lots that have already
been shipped. When you choose this option, the system enforces the ship ascending lot rule based on the expiration date to ensure that the lot
being shipped has an expiration date that is greater than that of the lots that have been previously shipped.

cCheckSellByDateSBCKcharOPTNONE

An option that indicates whether the system ensures that a lot being shipped to a customer is shipped in ascending order by the sell by
date. If you choose this option, the system ensures that each lot that is being shipped has a sell by date that is greater than or equal to the date
on which the last lot was shipped.

cCheckBestBeforeDateBBCKcharOPTNONE

An option that specifies whether the system ensures that the lot that you are shipping to a customer has a value in the Best Before Date field
that is greater than or equal to the value for the last lot that you shipped.

jdBasedOnDateBODJJDEDATEOPTNONE

The date that the system uses in conjunction with the shelf life days to calculate the lot expiration date. You can enter this date during
inventory completions. In addition to calculating the lot expiration date, the system uses the date that you enter in this field to calculate the following
lot dates: o Sell By Date o Best Before Date o Lot Effectivity Date o User Lot Date 1 o User Lot Date 2 o User Lot Date 3 o User Lot Date
4 o User Lot Date 5

jdLotEffectivityDateDLEJJDEDATEOPTNONE

The date on which a lot becomes available. The system uses this date for availability and commitment processing to indicate that the lot is
available on or after the date that you specify. You must complete this field when inventory first becomes an on-hand quantity for the lot. If you
leave this field blank, the system calculates the effective date of the lot by using the value for Effective Days in the Item Branch File table
(F4102) or the current date if the value for Effective Days is zero.

cShipAscendingDateFlagEV01charOPTNONE

An option that specifies the type of processing for an event.

jdSellByDateSBDJJDEDATEOPTNONE

The date by which a lot should be completely sold. The system uses this date as a "through" date for commitment processing. The system
calculates the sell by date using the value in the Sell By Days field, which is contained in the Item Branch File table (F4102), when inventory
becomes available on-hand.

jdBestBeforeDateBBDJJDEDATEOPTNONE

The last date on which the products in a lot should be consumed. The system calculates the date by retrieving the value from the Best
Before Days field in the Item Master program (P4101). You can also use this date as a "through" date for commitment processing. You can
commit a lot by this date by using the Commitment Date Method field in the Item Branch program (P41026).

jdUserLotDate1U1DJJDEDATEOPTNONE

A date that the system can use as a through date for commitment processing. The system stores this date in the Lot Master table (F4108). If
you leave this field blank, the system can calculate the date by using the value for the User Lot Date 1 Default Days field, which is stored in
the Item Branch File table (F4102).

jdUserLotDate2U2DJJDEDATEOPTNONE

A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to the Lot Expiration
Date, User Lot Date 2 is a through date for commitment processing. The User