F4211ClearWorkFile

Sales Order Entry Master Business Function

Master Business Function

Object Name: B4200310

Parent DLL: CSALES

Location: Client/Server

Language: C

Data Structure

D4200310I - F4211 Clear Work File

Special Input Expected
JOBJob NumberWas retrieved from Begin Document
CTIDComputer IDRetrieved from GetAuditIno (B9800100) in application
LNIDLine Number FromIf a line number is specified, will clear the detail work file
from that line through the end of the lines in the table. If no line number is specified, the entire
table will be cleared.
LNIDLine Number ThruThe line number to stop clearing the detail work file. If this is
blank will deleted the entire work file. To delete just one line set both the from and thru line
numbers to the same number
EV01ClearHeaderFileIndicates whether the header file (F42UI01) should be cleared
'1' - Header WF
'2' - Header Cache
EV02ClearDetailFileIndicates whether the detail file (F42UI11) should be cleared
'1' - Detail WF
'2' - Detail Cache
PIDProgram ID

VERSCM Version

Special Output Returned
MATH02WK Related Order Process

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnJobNo	JOBS	MATH_NUMERIC	NONE	NONE
The job number (work station ID) which executed the particular job.
szComputerID	CTID	char	REQ	NONE
The Computer ID where the order is being processed. This parameter together with Job Number comprises the unique composite keys used to clear the F42UI01 and F42UI11 caches. ^
mnFromLineNo	LNID	MATH_NUMERIC	NONE	NONE
Special Input Expected LNIDab ab Line Number From Significant Data Values If a line number is specified, will clear the detail work file from that line through the end of the lines in the table. If no line number is specified, the entire table will be cleared.ab ^
mnThruLineNo	LNID	MATH_NUMERIC	NONE	NONE
Special Input Expected LNIDab ab Line Number Thru Significant Data Values The line number to stop clearing the detail work file. If this is blank will deleted the entire work file. To delete just one line set both the from and thru line numbers to the same numberab ^
cClearHeaderWF	EV01	char	NONE	NONE
Special Input Expected EV01ab ab ClearHeaderFile Significant Data Values Indicates whether the header file (F42UI01) should be cleared '1' - Header WF '2' - Header Cacheab ^
cClearDetailWF	EV02	char	NONE	NONE
Special Input Expected EV02ab ab ClearDetailFile Significant Data Values Indicates whether the detail file (F42UI11) should be cleared '1' - Detail WF '2' - Detail Cacheab ^
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.
mnWKRelatedOrderProcess	MATH02	MATH_NUMERIC	NONE	NONE
Special Output Returned MATH02ab WK Related Order Processab ^
szCMVersion	VERS	char	NONE	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.
cGenericChar1_EV01	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cGenericChar2_EV02	EV02	char	OPT	NONE
An option that specifies the type of processing for an event.
szGenericString1_DL01	DL01	char	OPT	NONE
A user defined name or remark.
mnSODRelatedJobNumber	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnProcessID	PEID	MATH_NUMERIC	OPT	NONE
A code that identifies the Inter-Process Communication ID.
mnTransactionID	TCID	MATH_NUMERIC	OPT	NONE

Related Functions

B0000021 Format Subledger
B0000027 CurrencyConvForAndDom
B0000033 Get Exchange Rate
B0000128 Retrieve Company Currency Code
B0000130 Retrieve Company From Business Unit
B0100002 A/B - Get Parent Address
B0100024 Convert Transaction Amt to Customer Ccy & Upd F0301
B3201150 F4801 Update WO Status During SO Change Mode
B3800080 Agreement Cache For Sales Order
B4000150 Get Branch Constants
B4000260 Line Type - Activity Rules
B4000310 Location Information
B4000360 Check Location Master
B4000370 Get Default Branch
B4000450 Convert Short Item To Long Item
B4000520 Get Item UoM Conversion Factor
B4000530 Get Distribution Constants
B4000590 Verify Line Type
B4000610 Get Lot Master By Lot Number
B4000670 Get Item Units Of Measure
B4000790 Verify Date2 After Date1
B4000800 Edit Document Type Not Blank
B4000870 Standard Pricing Adjustments
B4000880 Verify And Get Address Book for OP
B4000950 Return the Item Stocking Type
B4000960 Verify Override Next Status Code
B4001100 Write Hold Code
B4002000 Compute Unit Or Extended Amount
B4002020 Purge Held Order Records
B4002060 Preference Get Values For Sales Order
B4002300 Preference Allocations
B4100205 Get Item Master Price Info
B4100210 Check Item Branch
B4101220 Calculate Availability
B4200030 F4201 Get Order No. From Next Number
B4200050 F42004 Verify Commission Code
B4200070 Get Sales Base Price
B4200080 Convert Domestic And Foreign Amount
B4200090 Verify Tax Explanation Code
B4200100 Get Sold To Billing Instructions
B4200110 Verify Xchg Rate Against Tolerance
B4200120 F4008 Verify Tax Area
B4200130 Verify Customer PO Number Is Unique
B4200140 Get Ship To Billing Instructions
B4200150 Verify Sales Order Before Update
B4200160 Get Freight Rate Code From F4020
B4200210 Get F4211 Detail Information
B4200230 F4074 Maintain Price History
B4200270 Check Item Restrictions
B4200280 Calculate Commitment Date
B4200290 Margin Check Processing
B4200311 Sales Order Entry Master Business Function
B4200340 Verify And Get Sales Header
B4200370 Commit Sales Order To Inventory
B4200420 Credit Check Processing
B4200450 Advanced Sales Order Detail Line Split
B4200490 Relieve SO Blanket Order Qty
B4200690 Copy SO Info To Work Files
B4200710 CalculateTransferCost
B4200760 Add Order to Subsystem Queue
B4200780 F42UI130 Get/Update Commitment Work File
B4200830 Retrieve Interbranch Order Types
B4200850 Preference Calculate Commitments
B4201210 Serial Number Processing Edits
B4201270 F49211 Maintain Sales Detail Table
B4201280 F42UI12 Get Sales Order Detail Info
B4301250 F4311Z Update Related Order Info
B4500050 F4072 Calculate Price Adjustments
B4500090 F4074 Price Adjustment Ledger Server
B4500200 F4573 Get Next Free Good
B4600130 Cache, Warehouse Components
B4700070 EDI - Convert EDI Text To Generic Text
B7600720 Retrieve Cache Information from Sales Header - Brazil - 42B
B7600730 Retrieve Cache Information from Sales Detail - Brazil - 42B
B7600750 Write Cache Information Sales Detail - Brazil - 42B
B7600790 Write Cache to Sales Detail File - Brazil - 42B
B9800100 Get Audit Information
B9800420 Get Data Dictionary Definition
B9900410 Get Environment Value
N3200700 Write Configurator Files at End Doc
N3201130 Duplicate Configurator Information
N3800040 F38012 Agreement Transaction Server
N3800050 F38010 Agreement Search
N4002510 Verify Original Blanket Order Before Update
N4200870 Increment Sales Detail Line Number
N4201010 Determine If Blanket SO Exists
N4301750 Add Matching F4006 Record
N4600030 Warehouse Management Request Transactions
N4600320 F40203 Validate AWM Override Status
N4700130 EDI Update Inbound Detail As Processed
N4900010 F4215 Add Shipment Detail
N4900180 Process Order Line
N7000320 B4200310 - Plug & Play - 42B
R42997 Inventory Commitment
X0005 Get User Defined Codes
X0903 Fiscal Date Edits +
X0909 Validate Subledger
X4101 Validate and Retrieve Item Master
XF41021 Update F41021 Locations
XF4105 Item Cost I/O
XT4311Z1 Purchase Order Entry

Related Tables

F4201 Sales Order Header File
F4211 Sales Order Detail File
F42UI01 SO Header Cache File (MBF)
F42UI11 SO Detail Cache File (MBF)
F42UI130 Commitment Work File
F4573 Free Goods Reference File

F4211FSBeginDoc

Sales Order Entry Master Business Function

Master Business Function

Object Name: B4200310

Parent DLL: CSALES

Location: Client/Server

Language: C

Functional Description

Purpose
This business function will provide sales order header level editing and defaulting process that
includes:
• Field level edits for correct information
• Field level defaults from Data Dictionary
'b7'b7'b7'b7'b7'b7'b7'b7'b7'b7'b7A record will be written to the
Sales Header Work File (F42UI01) if no errors are found.  If a record already exists in the work file,
the record will be retrieved and updated with the changes.

Setup Notes and Prerequisites
• Prior to calling this function, you must first retrieve your computer ID using GetAuditInfo
(B9800100).  This will then be passed in as a parameter.
• You must define work fields in your application to hold all the output parameters of this function.
Some of which will be passed to subsequent edit object modules (i.e., Edit Line, End Doc).
'b7'b7'b7'b7'b7'b7'b7'b7'b7'b7'b7This function will not actually
write or update to the Sales Order Header file, you must call F4211FSEndDoc manually for that to happen.

Special Logic
• If errors are detected, the business function will not write to the header work file and
F4211EndDocument should not be called.
• If only warnings are detected, this business function will still write to the header work file.  The
calling application should decide whether F4211EndDocument should be called.
• Use Source of Data (EV06 in parameter) to copy data from the following files:
'b7'b7'b7'b7'b7'b7'b7'b7'b7'b7'b7

'  ' = Input Parameters.  You can call this function by passing to it all of the Sales Order
Header fields that you would like to edit.  Please see the 2.1 parameter section for the list of
fields to be passed into this function.
'1' = F4201 and F4211
'2' = F4201/F42019 and F2199
'3' = F4001Z and F4011Z
'4' = F47011 and F47012
'5' = F42UI01 and F42UI11 (work files)
'6' = F42UI01 and F42UI11 (cache)
'7' = F42UI12
NOTE:  Any data passed into the data structure will have a higher precedence than the data
copied from one of the files listed above.

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnCMJobNumber	JOBS	MATH_NUMERIC	REQ	NONE
The Job Number parameter is used by the program as a unique key field to read and write records from the F42UI01 and F42UI11 caches. When this parameter is passed with a zero the program will generate the next available Job Number. The unique Job Number generated will ensure that the program will only process the records entered for the current job. ^
cCMDocAction	ACTI	char	REQ	NONE
This parameter determines the kind of processing that will be performed on the order. Action can be and Add, Change or Delete. If a blank was passed, Add action will be the default. ^
cCMProcessEdits	EV01	char	REQ	NONE
This parameter determines the kind of edits that the order will go through. Depending on the value passed in, an order can go through a full edit, a partial edit and a price only edit. Full edit will commit the orders as well as retrieve the Preferences defined. Partial edit does not do commitments whereas Price only will retrieve the Unit Price for each item ordered. ^
szCMComputerID	CTID	char	REQ	NONE
The Computer ID where the order is being processed. This parameter together with Job Number comprises the unique composite keys used to clear the F42UI01 and F42UI11 caches. ^
cCMErrorConditions	ERRC	char	NONE	NONE
Special Output Returned ERRCab ab CM-Error Conditions Significant Data Values ' ' = No Errors '1' = Warnings '2' = Errors ^
cCMUpdateWriteToWF	EV02	char	REQ	NONE
This parameter determines where to store the information. Significant Data Values '1' = Write and/or update records to the work file. '2' = Write and/or update records to the cache ^
szCMProgramID	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.
szCMVersion	VERS	char	NONE	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.
szOrderCo	KCOO	char	REQ	NONE
A number that, along with Order Number and Order Type, uniquely identifies a Sales Order document. When this parameter is blank, the program will default the company to which the Cost Center belongs to. ^
mnOrderNo	DOCO	MATH_NUMERIC	REQ	NONE
The Order Number along with Order Company and Order Type uniquely identfies a Sales Order document. When a zero is passed to this parameter the program will retrieve the next available number from the Next Number system. ^
szOrderType	DCTO	char	REQ	NONE
Identifies the type of document being processed. If no value was passed then the program will default the type defined in the Processing Option. ^
szBusinessUnit	MCU	char	REQ	NONE
The Cost Center where the items are going to be shipped from. If a blank was passed to this parameter the program will retrieve the default from the Processing Option. ^
szOriginalOrderCo	OKCO	char	NONE	NONE
A number that is used in conjunction with the values in the ODOC and ODCT fields to identify a transaction.
szOriginalOrderNo	OORN	char	NONE	NONE
The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, and so on Matching document numbers are also used to identify related documents in the Accounts Receivable and Accounts Payable systems. The document number (DOC) is always the original document number. The matching document number (DOCM) is the check, adjustment, or credit to be applied against the original document.
szOriginalOrderType	OCTO	char	NONE	NONE
This code defines the order type. It is verified in user defined codes (40/OT). Reserved document types have been defined for voucher entry, invoice entry, receipts entry, and time sheet entry. Because the offsetting entries for document types are created automatically during the post program, they will not be self-balancing on original entry. The reserved document types are: PR Purchase Requisition Orders PQ Purchase Quote PO Purchase Order PD Purchase Order - Direct Ship PB Purchase Order - Blanket SQ Sales Quote SO Sales Order SD Sales Order - Direct Ship SB Sales Order - Blanket
mnAddressNumber	AN8	MATH_NUMERIC	REQ	NONE
The address number of the Sold To customer. If this parameter is zero, it will be defaulted based on the Customer Billing Instructions set up for the Ship To address. ^
mnShipToNo	SHAN	MATH_NUMERIC	REQ	NONE
The address number of the Ship To customer. If no value was passed, it will be defaulted based on the Customer Billing Instructions of the Sold To Customer. Sold To and Ship To address numbers may not be both zeros when passed to the program. ^
jdRequestedDate	DRQJ	JDEDATE	NONE	NONE
The date that an item is scheduled to arrive or that an action is scheduled for completion.
jdOrderDate	TRDJ	JDEDATE	NONE	NONE
Special Input Expected TRDJab ab Order Dateab ab ab Special Output Returned DELETE THIS SECTION IF IT DOES NOT APPLY. Significant Data Values Default to System Date. ^
jdPromisedDate	PDDJ	JDEDATE	NONE	NONE
The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate Available to Promise information. This value can be automatically calculated during sales order entry. This date represents the day that the item can be shipped from the warehouse.
jdCancelDate	CNDJ	JDEDATE	NONE	NONE
The date that the order should be canceled if the goods have not been sent to the customer or the goods have not been received from the supplier. This is a memo-only field and does not cause the system to perform any type of automatic processing. If a line on a sales order in canceled in Sales Order Entry, this field will be updated with the date the line has been canceled.
szReference	VR01	char	NONE	NONE
ab Special Input Expected VR01ab ab Reference Special Output Returned VR01ab ab Reference Significant Data Values See Business Function Attachment. ^
szDeliveryInstructions1	DEL1	char	NONE	NONE
One of two fields that you use to enter delivery instructions.
szDeliveryInstructions2	DEL2	char	NONE	NONE
The second of two fields that you use to enter delivery instructions.
szPrintMesg	INMG	char	NONE	NONE
A user defined code that you assign to each print message. Examples of text used in messages are engineering specifications, hours of operation during holiday periods, and special delivery instructions.
szPaymentTerm	PTC	char	NONE	NONE
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date. Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions form. Examples of payment terms include: Blank Net 15 001 1/10 net 30 002 2/10 net 30 003 Due on the 10th day of every month 006 Due upon receipt This code prints on customer invoices.
cPaymentInstrument	RYIN	char	NONE	NONE
The user defined code (00/PY) that specifies how payments are made by the customer. For example: C Check D Draft T Electronic funds transfer
szAdjustmentSchedule	ASN	char	NONE	NONE
A user defined code (40/AS) that identifies a price and adjustment schedule. A price and adjustment schedule contains one or more adjustment types for which a customer or an item might be eligible. The system applies the adjustments in the sequence that you specify in the schedule. You link customers to a price and adjustment schedule through the customer billing instructions. When you enter a sales order, the system copies the schedule attached to the sold to address into the order header. You can override this schedule at the detail line level. For Agreement Management, this is the Agreement Penalty Schedule. The information in the Agreement Penalty Schedule provides the system with the criteria for an agreement to have penalty conditions.
mnTradeDiscount	TRDC	MATH_NUMERIC	NONE	NONE
Percentage by which the system reduces the price of each item. This is the only discount that will be applied. You can override it if you enter a price. Enter the percentage as a whole number (that is, 5 for 5%).
szTaxExplanationCode	EXR1	char	NONE	NONE
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The system uses the tax explanation code in conjunction with the tax rate area and tax rules to determine how the tax is calculated. Each transaction pay item can be defined with a different tax explanation code.
szTaxArea	TXA1	char	NONE	NONE
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax and G/L distribution amounts when you create an invoice or voucher.
szCertificate	TXCT	char	NONE	NONE
The number that tax authorities issue to tax-exempt individuals and companies to identify their tax-exempt status.
cAssociatedText	ATXT	char	NONE	NONE
This is a one byte flag that is used to determine whether or not a specific line item on a sales or purchase order has additional extended text associated with it.
szHoldOrdersCode	HOLD	char	NONE	NONE
A user defined code (42/HC) that identifies why an order is on hold.
cPricePickListYN	PLST	char	NONE	NONE
An option that indicates whether price information appears on the customer's pick list, purchase order, or sales order. Valid values are: On Price information appears Off Price information does not appear
mnInvoiceCopies	INVC	MATH_NUMERIC	NONE	NONE
The number of invoice copies required by the customer. The system prints the number of invoices specified in this field. The system always prints at least one invoice.
mnBuyerNumber	ANBY	MATH_NUMERIC	NONE	NONE
The address book number that identifies who is responsible for setting up and maintaining the correct stocking levels for each inventory item.
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.
szRouteCode	ROUT	char	NONE	NONE
The route field is a user defined code (system 42, type RT) that represents the delivery route on which the customer resides. This field is one of several factors used by the freight summary facility to calculate potential freight charges for an order. For picking, use the route code with the stop and zone codes to group all of the items that are to be loaded onto a delivery vehicle for a specific route. You set up a default for each of these fields on the Customer Billing Instruction form.
szStopCode	STOP	char	NONE	NONE
The stop code is a user defined code (system 42, type SP) that represents the stop on a delivery route. This field is one of several factors used by the freight summary facility to calculate potential freight charges for an order. For picking, you can use the stop code with the route and zone codes to group all items that are to be loaded onto a delivery vehicle for a specific route. You set up the default for each of these fields on the Customer Billing Instructions form.
szZoneNumber	ZON	char	NONE	NONE
The zone field is a user defined code (system 40, type ZN) that represents the delivery area in which the customer resides. This field is one of several factors used by freight summary facility to calculate potential freight charges for an order. For picking you can use the zone code with the route and stop codes to group all item that are to be loaded onto a delivery vehicle for a specific route. You set up the default for each of these fields on the Customer Billing Instructions form.
szFreightHandlingCode	FRTH	char	NONE	NONE
A user defined code (42/FR) designating the method by which supplier shipments are delivered. For example, the supplier could deliver to your dock, or you could pick up the shipment at the supplier's dock. You can also use these codes to indicate who has responsibility for freight charges. For example, you can have a code indicating that the customer legally takes possession of goods as soon as they leave the supplier warehouse and is responsible for transportation charges to the destination.
cApplyFreightYN	AFT	char	NONE	NONE
An option that specifies whether the system performs freight calculations during processing. Valid values are: On The system performs freight calculations during processing. Off The system does not perform freight calculations during processing.
mnCommissionCode1	CMC1	MATH_NUMERIC	NONE	NONE
The first of two eight-character codes used to designate the salespeople who should receive credit for a sale to the customer. This code is first created in either the Address Book or through the Related Salespersons program.
mnCommissionRate1	CMR1	MATH_NUMERIC	NONE	NONE
The first of two percentages to be applied to either the gross sales amount or the gross margin for an order or order line in computing your commission liability. This percent can default from Billing Instructions or be entered directly to the order.
mnCommissionCode2	CMC2	MATH_NUMERIC	NONE	NONE
The second of two eight-character codes used to designate the salespeople who should receive credit for a sale to the customer. This code is first created in either the Address Book or through the Related Salespersons program.
mnCommissionRate2	CMR2	MATH_NUMERIC	NONE	NONE
The second of two commission percentages to be applied to either the gross sales amount or the gross margin for an order or order line in computing your commission liability. This percent can come in from the Billing Instructions or be entered in the sales order.
szWeightDisplayUOM	WUMD	char	NONE	NONE
A user defined code (00/UM) that identifies which unit of measure the system should use to display the weight of individual order lines and the order as a whole for this customer when you use the order summary form.
szVolumeDisplayUOM	VUMD	char	NONE	NONE
A user defined code (00/UM) that identifies the unit of measure that the system uses to display volume for this branch/plant. The system inputs a value in this field from Branch/Plant Constants - Page 2 (P410012). You can override this default value.
szAuthorizationNo	AUTN	char	NONE	NONE
This field lets you record the authorization number provided by the credit card company or bank which issued the card.
szCreditBankAcctNo	CACT	char	NONE	NONE
The first of three fields available to record credit card transactions. This field allows you to record the customer's account number with the credit card company or bank.
jdCreditBankExpiredDate	CEXP	JDEDATE	NONE	NONE
This field is to record the account number and expiration date of credit cards used by your customers who make purchases from you. It is for information purposes only.
cMode	CRRM	char	NONE	NONE
An option that specifies whether the system displays amounts in the domestic or foreign currency. On The system displays amounts in the foreign currency of the transaction. Off The system displays amounts in the domestic currency of the transaction.
szCurrencyCode	CRCD	char	NONE	NONE
A code that identifies the currency of a transaction.
mnExchangeRate	CRR	MATH_NUMERIC	NONE	NONE
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount. The number in this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
szOrderedBy	ORBY	char	NONE	NONE
SALES ORDER SYSTEM: An optional entry field, intended for the name of the customer placing the order.
szOrderTakenBy	TKBY	char	NONE	NONE
SALES ORDER SYSTEM: An optional entry field, intended for the name of the individual taking the customer's order. If you do not enter a user ID in this field, the system uses the ID of the person who is signed on.
szUserReservedCode	URCD	char	NONE	NONE
This is a 2 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
jdUserReservedDate	URDT	JDEDATE	NONE	NONE
This is a 6 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
mnUserReservedAmnt	URAT	MATH_NUMERIC	NONE	NONE
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
mnUserReservedNo	URAB	MATH_NUMERIC	NONE	NONE
This is a 8 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
szUserReservedRef	URRF	char	NONE	NONE
A 15-position reference that is reserved for the user. J.D. Edwards does not currently use this field and does not plan to use it in the future.
jdDateUpdated	UPMJ	JDEDATE	NONE	NONE
The date that specifies the last update to the file record.
szUserID	USER	char	NONE	NONE
The code that identifies a user profile.
szWKBaseCurrency	CRDC	char	NONE	NONE
A code that identifies the domestic (base) currency of the company on a transaction.
cWKAdvancedPricingYN	ADVP	char	NONE	NONE
Indicates how the system determines the price of items within your system. If your system includes the advanced pricing module, you may use this feature. Y The system will use advanced pricing. N The system will NOT use advanced pricing.
szWKCreditMesg	CM	char	NONE	NONE
A value in the user defined code table 00/CM that indicates the credit status of a customer or supplier. Examples are: 1 Over credit limit 2 Requires purchase order 3 Not on contract maintenance agreement The credit message displays on inquiry and transaction entry forms in the Accounts Payable, Sales Order Management, and Procurement systems. The system displays the temporary credit message in the Accounts Receivable system.
szWKTempCreditMesg	TSTA	char	NONE	NONE
A user defined code that identifies a temporary credit status. Generally, you assign the code when an account becomes past due. The system automatically updates the temporary credit message based on the notification instructions that you set up for the policy that you assign to the customer. The system can automatically reset the temporary credit message back to the credit message if you activate the option in the policy. You can also manually enter and update the temporary credit message on the customer record. If you leave this field blank, the system assigns the value of the Credit Message field when you run Credit Analysis Refresh (R03B525). The system displays the temporary credit message on the transaction entry forms in the Accounts Receivable and Sales Order Management systems.
cWKInvalidSalesOrderNo	EV03	char	NONE	NONE
Special Output Returned EV03ab ab WK_Invalid Sales Order Number Significant Data Values Please refer to business function attachments for processing detail ^
cWKSourceOfData	EV06	char	REQ	NONE
This parameter will determine where to retrieve the source of data. Significant Data Values ' ' = Input Parameters '1' = F4201 and F4211 '2' = F4201/F42019 and F42119 '3' = F4001Z and F4011Z '4' = F47011 and F47012 '5' = F42UI01 and F42UI11 ^
cWKProcMode	EV07	char	NONE	NONE
ab Special Input Expected EV07ab ab WK-Processing Mode Significant Data Values ' ' = Regular Order '1' = Blanket/Duplicate Order ^
mnWKSuppressProcess	MATH01	MATH_NUMERIC	NONE	NONE
ab Special Input Expected *MATH01ab WK- Suppress Process* Special Output Returned *MATH01ab WK- Suppress Process* Significant Data Values *Specify the processes to be suppressed by passing in the number assigned to the option. In order to* specify a combination, add the number assigned to the option together and send in the result. Options: 0 = Default (0) 1 = Writing Records When Warnings (1) 2 = Retrieve Processing Options (2) 4 = Product Allocation Window (3) 8 = Advanced Pricing Server (4) 16 = Inv. Commitments Was850Called (5) 32 = Inv. Commitments ChangesMadeToQty 64 = ^
mnSODDocNo	EDOC	MATH_NUMERIC	NONE	NONE
The document number that is assigned by the transmitter in an EDI transaction. In a non EDI environment, this would be consistent with the order number assigned at order entry time (DOCO).
szSODDocType	EDCT	char	NONE	NONE
The document type that is assigned by the transmitter in an EDI transaction. In a non EDI environment, this would be consistent with the order type (DCTO) assigned at order entry time, an invoice document type, a voucher document type, and so on.
szSODOrderCo	EKCO	char	NONE	NONE
Company - Key (EDI - Document Key Co)
mnTriangulationRateFrom	TRR1	MATH_NUMERIC	OPT	NONE
The triangulation currency rate used to convert the From currency code to the Triangulation currency code.
mnTriangulationRateTo	TRR2	MATH_NUMERIC	OPT	NONE
The triangulation currency rate that used to convert from the Triangulation currency code to the To currency code.
cCurrencyConversionMethod	CRCM	char	OPT	NONE
A value that specifies which method to use when converting from one currency to another. Valid values are: Y Multiplier method. The system multiplies the foreign amount by the multiplier exchange rate to calculate the domestic amount. Z Divisor method. The system divides the foreign amount by the divisor exchange rate to calculate the domestic amount.
cRetrieveOrderNo	EV02	char	OPT	NONE
An option that specifies the type of processing for an event.
szPricingGroup	PRGP	char	OPT	NONE
A user defined code (system 40/type PC) identifying the pricing group associated with this customer or supplier: o For sales orders, you assign a pricing group to a customer through the Customer Billing Instructions. Groups typically contain customers with common pricing characteristics, such as retailers, wholesalers, and so forth. o For purchase orders, you assign a pricing group to a supplier through the Supplier Billing Instructions.
cCommitInvInED	EV05	char	OPT	NONE
A flag that indicates whether automatic spell check is turned on.
cSpotRateAllowed	CSR	char	OPT	NONE
An option that indicates whether a spot rate is applicable for a particular currency relationship. Spot rates are exchange rates entered at the time of transaction entry.
cGenericChar2_EV02	EV02	char	OPT	NONE
An option that specifies the type of processing for an event.
szGenericString1_DL01	DL01	char	OPT	NONE
A user defined name or remark.
szGenericString2_DL02	DL02	char	OPT	NONE
Additional text that further describes or clarifies a field in the system.
mnGenericMathNumeric1_MATH01	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnGenericMathNumeric2_MATH02	MATH02	MATH_NUMERIC	OPT	NONE
- - - Good Performance High Value.
szLongAddressNumberShipto	ALKY	char	OPT	NONE
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.
szLongAddressNumber	ALKY	char	OPT	NONE
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.
mnProcessID	PEID	MATH_NUMERIC	OPT	NONE
A code that identifies the Inter-Process Communication ID.
mnTransactionID	TCID	MATH_NUMERIC	OPT	NONE

szSoldToBSC	BSC	char	OPT	NONE
A value that groups customers with similar buying habits.
szShipToBSC	BSC	char	OPT	NONE
A value that groups customers with similar buying habits.
mnRMANumber	DOC1	MATH_NUMERIC	OPT	NONE
The document number associated with a given document type.
szRMADocType	DCT4	char	OPT	NONE
User-defined codes that identify the type of document.
jdDatePriceEffectiveDate	PEFJ	JDEDATE	OPT	NONE
The system uses the Price Effective Date to determine the base price and all advanced price adjustments. The value loaded in this date is stored in the System Constants File (F4009).
szSOEMBFInternalFlags	SOEF	char	OPT	NONE
This field is broken down into 30 different flags which are passed in and out of the sales order entry MBF - F4211 Begin Doc, F4211 Pre Processor, F4211 Edit Line, and F4211 End Doc.
szOPBusinessObjective	OPBO	char	OPT	NONE
A value that specifies a default business objective to send outbound to order promising before an order has been promised. A business objective is a grouping of business rules that fulfill a sales order. For sales order detail lines, this value specifies the business objective that is selected by order promising after an order has been promised.
cOPPartialOrderShipmentAllowed	OPPL	char	OPT	NONE
An option in order promising that specifies whether all line items must be shipped to the customer on the same date. Valid values are: Y The line items may be delivered on different dates, depending on availability. N The delivery date to the customer will be the date of the latest line items' availabilty.
cOPPartialLineShipmentAllowed	OPLL	char	OPT	NONE
An option that specifies whether to allow partial shipments in order promising. This option works with the Allow Backorders option. Valid values are: Y Split the sales order line item in order promising, deliver part of the requested inventory one day, and deliver the rest on another day. N Order promising cannot split the sales order line item.
cOPBackorderAllowed	OPBA	char	OPT	NONE
An option that specifies, in order promising, whether a line item can be shipped later than the requested date, based on future availability. This option works with the Partial Line Shipments option. Valid values are: Y If the Partial Line Shipments value is Y, the quantity that is available on the requested date is shipped. The remaining quantity is shipped on the available date. If the Partial Line Shipments value is N, the entire quantity is shipped on the date that it becomes available. N The available quantitity on the requested date is shipped.
cOPMultiSourcingAllowed	OPMS	char	OPT	NONE
An option that specifies whether multisourcing is allowed in order promising. Valid values for the sales order header are: Y Allow order promising to source different detail lines from different branch/plants. N All line items are sourced from the same branch/plant. Valid values for the sales order detail are: Y Allow order promising to source the inventory for this line item from more than one branch/plant. N This line item can be sourced from only one branch/plant.
cOPSubstituteAllowed	OPSS	char	OPT	NONE
An option that specifies whether to allow substitution for sales order line items in order promising. Valid values are: Y The product can be substituted if it is unavailable. N The product cannot be substituted.
mnAddressNumberDeliveredTo	DVAN	MATH_NUMERIC	OPT	NONE
The address number of the person who receives the goods ordered. The delivered to address might differ from the ship to address when ordered goods are processed through a distribution center (which is the delivered to address) before reaching their final destination (the ship to address).
mnAddressNumberInvoicedTo	ITAN	MATH_NUMERIC	OPT	NONE
The address book number of the person who receives the invoice.
mnAddressNumberPaidBy	PBAN	MATH_NUMERIC	OPT	NONE
The address book number of the person who pays the amount on the invoice.
mnAddressNumberForwardedTo	FTAN	MATH_NUMERIC	OPT	NONE
The address book number of the person to whom invoice statements are sent.
cAddressNumberForTax	AUFT	char	OPT	NONE
An option that indicates which address number the system uses for tax purposes. Valid values are: 1 The system uses the ship to address number. 2 The system uses the deliver to address number.
cAddressNumberForTransport	AUFI	char	OPT	NONE
An option that indicates which address number the system uses for transportation and intrastat purposes. The system uses the address number as the ship to address for transportation. Valid values are: 1 The system uses the ship to address number. 2 The system uses the deliver to address number.
mnRequestedDeliveryTime	DRQT	MATH_NUMERIC	OPT	NONE
The time requested for delivery. 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.
nSourceOfOrder	SOOR	integer	OPT	NONE
A code that identifies the origination source of the order.
mnPromisedPickTime	PDTT	MATH_NUMERIC	OPT	NONE
The time when the order is scheduled to be picked. Enter the time in the 24-hour format and include a leading zero if necessary. For example, enter 6:00 a.m. by typing 060000 and enter 7:00 p.m. by typing 190000.
szModeOfTransport	MOT	char	OPT	NONE
A user defined code (00/TM) that describes the nature of the carrier being used to transport goods to the customer. For example, by rail, by road, and so on.
szReasonCode	RCD	char	OPT	NONE
A user defined code (42/RC) that explains the purpose for a transaction. For example, you can indicate the reason that you are returning items.
mnPartnerAddressNumber	PRAN8	MATH_NUMERIC	OPT	NONE
The address number (F0101) of the partner associated with the lead.
mnPartnerContactLineNumID	PRCIDLN	MATH_NUMERIC	OPT	NONE
The line number identifier from the Who's Who (F0111) representative of Contacts for a Partner.
mnOpportunityId	OPPID	MATH_NUMERIC	OPT	NONE
A unique identifier related to the Opportunity.
szSoldToAttention	SDATTN	char	OPT	NONE
Attention field for billing specifications.
mnShipToCusContactLineNumID	SHCCIDLN	MATH_NUMERIC	OPT	NONE
Ship To Customer contact line number.
szShipToAttention	SPATTN	char	OPT	NONE
Attention field for shipping specifications.
cOrderTypeIndicator	OTIND	char	OPT	NONE
This field differentiates order types.
mnCustomerContactLineNumID	CCIDLN	MATH_NUMERIC	OPT	NONE

szSoldToContactAlphaName	ALPH	char	OPT	NONE
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.
szShipToContactAlphaName	ALPH	char	OPT	NONE
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.
idSourceOfDataContext	GENLNG	ID	OPT	NONE
General purpose ID variable.
szLongAddressNumberDeliveredTo	ALKY	char	OPT	NONE
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.
szLongAddressNumberInvoicedTo	ALKY	char	OPT	NONE
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.
szLongAddressNumberPaidBy	ALKY	char	OPT	NONE
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.
szLongAddressNumberForwardedTo	ALKY	char	OPT	NONE
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.

• If Processing Mode (EV07-parm) is set to '1', this function is running in copy mode.  That means the
header work file has already been populated with values from the original order header before this
function is called.  Therefore, this function will NOT attempt to default values into any column in the
table (F42UI01) which doesn't have a corresponding column in the parameter list.  However, the columns
which are represented in the parameter list will still be updated to the header work file.
• Parameter fields are denoted by -parm and Header Work File fields by -hwf.
• Suppress Processes (MATH01) - Specify the processes to be suppressed by passing in the number
assigned to the option.  In order to specify a combination, add the number assigned to the option together
and send in the result.  For example, to suppress the retrieval of Processing Options (2) and the
Production Allocation Warning (4), simply take 2+4 = 6 and pass 6 into this field.

'b7'b7'b7'b7'b7'b7'b7'b7'b7'b7'b7Options:
0 = Default
1 = Writing Records When Warnings

2 = Retrieve Processing Options for P4210

4 = Product Allocation Window
8 = Advanced Pricing Server
16 = Inventory Commitments - WasB4200850Called
32 = Inventory Commitments - ChangesMadeToQty
64 =

Note:

(2) Processing Options for P4210 are retrieved depending on the version that is passed in, using the
API AllocatePOVersionData in Begin Doc. But, the retrieving of processing options could be skipped
(depending on the usability of Sales Order Entry's (P4210) Processing Options

Technical Specification

2.1Data Structure

NameData Dictionary Item
mnCMJobNumberJOBS
cCMDocAction              ACTI
cCMProcessEdits           EV01
szCMComputerID       CTID
cCMErrorConditions        ERRC
cCMUpdateWriteToWF        EV02
szCMProgramIDPID
szCMVersionVERS
szOrderCoKCOO
mnOrderNo                DOCO
szOrderType            DCTO
szBusinessUnitMCU
szOriginalOrderCoOKCO
szOriginalOrderNoOORN
szOriginalOrderTypeOCTO
mnAddressNumber         AN8
mnShipToNo              SHAN
jdRequestedDate         DRQJ
jdOrderDate             TRDJ
jdPromisedDate          PODJ
jdCancelDate            CNDJ
szReferenceszVR01
szDeliveryInstructions1DEL1
szDeliveryInstructions2DEL2
szPrintMesgINMG
szPaymentTermPTC
cPaymentInstrument        RYIN
szAdjustmentScheduleASN
mnTradeDiscount          TRDC
szTaxExplanationCodeEXR1
szTaxAreaTXA1
szCertificateTXCT
cAssociatedText          ATXT
szHoldOrdersCode       HOLD
cPricePickListYN          PLST
mnInvoiceCopies           INVC
mnBuyerNumber             ANBY
mnCarrier                 CARS
szRouteCode            ROUT
szStopCodeSTOP
szZoneNumberZON
szFreightHandlingCodeFRTH
cApplyFreightYN           AFT
mnCommissionCode1         CMC1
mnCommissionRate1         CMR1
mnCommissionCode2         CMC2
mnCommissionRate2         CMR2
szWeightDisplayUOMWUMD
szVolumeDisplayUOMVUMD
szAuthorizationNoAUTN
szCreditBankAcctNoCACT
jdCreditBankExpiredDate  CEXP
cMode                     CRRM
szCurrencyCode        CRCD
mnExchangeRate            CRR
szOrderedBy           ORBY
szOrderTakenBy        TKBY
szUserReservedCode     URCD
jdUserReservedDate       URDT
mnUserReservedAmnt        URAT
mnUserReservedNo          URAB
szUserReservedRefURRE
jdDateUpdated             UPMJ
szUserIDUSER
szWKBaseCurrencyCRDC
cWKAdvancedPricingYN      ADVP
szWKCreditMesgCM
szWKTempCreditMesgTSTA
cWKInvalidSalesOrderNo   EV03
cWKSourceOfData          EV06
cWKProcMode               EV07
mnWKSuppressProcess       MATH01
mnSODDocNo                EDOC
szSODDocTypeEDCT
szSODOrderCoEKCO
mnTriangulationRateFrom   TRR1
mnTriangulationRateTo     TRR2
cCurrencyConversionMethod CRCM
cRetrieveOrderNo          EV02
szPricingGroupPRGP
cGenericChar1             EV05
cSpotRateAllowed         CSR

2.2Related Tables
Table Table Description
F42UI01Sales Order Header

2.3Related Business Functions

Source NameFunction Name
B0000033.CGet Exchange Rate
B4000150.CGet Branch Constants
B4000370.CGet Default Branch
B4000530.CRetrieve Distribution Constants
B4000790.CVerify Date 2 After Date 1
B4000880.C Verify And Get F0101 For OP
B4200050.CF42004 Verify Commission Code
B4200080.CConvert Domestic And Foreign Amt
B4200090.CVerify Tax Explanation Code
B4200100.CGet Sold To Billing Instructions
B4200110.CVerifyXchgRateAgainstTolerance
B4200120.CF4008Verify Tax Area
B4200130.CVerify Customer PO Number is Unique
B4200140.CGet Ship To Billing Instructions
B4200280.CCalculate Commitment Date
B4200340.CVerifyAndGetSalesHeader
B4200690.CCopy SO Info To Work Files
COCURR.CGet Company Currency
RETCOBU.CRetrieve Company From Business Unit

2.4Processing

1.If ACTN-parm is not passed in, default in 'A', for Add mode.

2.If the Ship To-parm and the Sold To-parm are blank, set error "0003" and stop processing.

3.If the Process Edits-parm is blank, default it to '1'. Assign the Edit Level internal variable
field a value based on the Process Edits-parm.

If Process Edits-parm == '1', Edit Level = 1.
If Process Edits-parm == '2', Edit Level = 3.
If Process Edits-parm == '3', Edit Level = 2.

4.If in Change or Delete mode or in Add mode and a Source of Data is provided, fetch the
appropriate record (Call Copy SO Info To Work Files, B4200690) and use the fetched data unless corresponding
data is passed in the input parameter.

Parameter

CTIDComputer ID=>CTID-parm
JOBSJob Number=>JOBS-parm
LNIXLast Line No Usednot used
EV02Source of Data=>'5'
EV03Mode=>'1'
KCOOOrder Company=>SOD KCOO-parm
DCTOOrder Type=>SOD DCTO-parm
DOCOOrder Number=>SOD DOCO-parm
LNIDOrder Line Number not used
NXTRNext Statusnot used
EV04Return Pointer=>'1'
GENLNGHeader Pointer<=temp variable

5.If del mode, write header record to the work file with the 'D' in the action code and skip the
reminder of this function.

6.If Sold To Number (AN8 - parm) is not zero,
Validate against F0101 (Verify And Get F0101 For OP) and store the return parameters as follow:

           Parm if blank    Temp WorkField

TXCTTaxCertificateNumber=>TXCT
CMCredit Message=>CM
AN81Related Address 1=>See step 6
AN82Related Address 2=>See step 6
AN83Related Address 3=>See step 6
AN84Related Address 4=>See step 6
AN85Related Address 5=>See step 6
AN86Related Address 6=>See step 6
MCUBusiness Unitnot used
LNGPLanguage Preferencenot used

If valid address number in F0101, validate against F0301 (Get Sold To Billing Instructions) and store
the return parameters as follow:

           Parm if blank    Default to hwf     Temp WorkField

TSTATemporary Credit Msg=>TSTA
BADT Billing Address Type=>See step 3
EXR1Tax Explanation Code=>EXR1
PORQCustomer PO Required=>See step 18

TRARPayment Terms=>PTC

RYINPayment Instrument=>RYIN
CRCDCurrency Code=>CRCD
ASNAdjustment Schedule=>ASN
CPGPCustomer Pricing Group=>PRGP
INVCInvoice Copies=>INVC
HOLDHold Code=>HOLD
INMGPrint Message=>INMG
PLSTPrice Pick List=>PLST
BACKBackorder Allowed=>BACK
PRIOPriority Code=>PRIO
TRDCTrade Discount=>TRDC
MAXOMaximum Order=>MAXO
MINOMinimum Order=>MINO
AN8RRelated Address=>See step 6

3.If AN8's Billng Address Type BADT is not equal to 'B' or 'X' set error message 1020 and return
to calling application. If invalid number, set error number 0037 and return to calling application.

4.If Ship To Number (SHAN - parm) is not zero,
Validate against F0101 (Verify And Get F0101 For OP) and store the return parameters as
follow:

           Parm if blan'1a'1a

Data Structure

D4200310H - F4211 Begin Doc

Special Input Expected
Common BeginDoc Parameters:
JOBSCM-Job NumberThe job number unique to the application.
ACTICM-Document ActionDocument Action (Add, Chg, Del)
If no Action Passed in, Add is defaulted
EV01CM-Process Edits0 = No Edits
1 = Full Edits
2 = Partial Edits
If blank, default to 1 in program.
CTIDCM-Computer IDThe calling application should retrieve this from
GetAuditInformation (B9800100).
EV02CM-Update or Write
to Work File'1' = Write and/or update records to the work file.
'2' = Write and/or update records to the cache
CRYRCM-Currency ControlRetrieved from the system values.
PIDCM-Program IDProgram ID (Currently not used)
VERSCM-VersionVersion (Currently not used)

Sales Order Header Fields to be Edited:
KCOOOrder Company
DOCOOrder NumberSee Business Function Attachment.
DCTOOrder TypeIf not blank, UDC Edits.
If blank, default from processing option (DCT-parm).
MCUBusiness UnitSee Business Function Attachment.
OKCOOriginal Order CompanyUsed for Copy/Blanket function.  No edits.
OORNOriginal Order NumberUsed for Copy/Blanket function.  No edits.
OCTOOriginal Order TypeUsed for Copy/Blanket function.  No edits.
AN8Address NumberSee Business Function Attachment.
Is required only if the ship to address (SHAN) is equal to zero.
SHANShip To NumberSee Business Function Attachment.
Is required only if the sold to address (AN8) is equal to zero.
DRQJRequested DateDefault to Transaction Date. Cannot be less than Transaction Date
- Verify Date 2 After Date 1.
TRDJOrder DateDefault to System Date.
PDDJPromised DateDefault to Requested Date. Cannot be less than system date -
Verify Date 2 After Date 1.
CNDJCanceled DateDate edits.
VR01ReferenceSee Business Function Attachment.
DEL1Delivery InstructionsIf blank, default from Ship To Master F0301- Get Ship To Billing
Instructions.
DEL2Delivery InstructionsIf blank, default from Ship To Master F0301- Get Ship To Billing
Instructions.
INMGPrint MessageIf not blank, UDC edits (40/PM). Default from Sold To Master
F0301- Get Sold To Billing Instructions.
PTCPayment TermIf blank and in add mode, default from A5TRAR in F0301 (sold to).
If not blank, DD edits.
RYINPayment InstrumentIf blank and in add mode, default from A5RYIN in F0301 (sold to).
If not blank, validate against UDC.
ASNAdjustment ScheduleIf doing advanced pricing (Get Distribution Constants' ADVP =
'Y'), default from Sold To Master F0301 - Get Sold To Billing Instructions, UDC 40/AS.
TRDCTrade DiscountIf not zero, DD edits.  If zero, default from Sold To Master
F0301- Get Sold To Billing Instructions.
EXR1Tax Explanation Code If blank, load from F0301 for sold to.  If not blank, validate
against UDC. The leftmost character must not be 'B' or 'U'. Error 0748.  Also, the second character must
not be a 'T' for tax only. Error 3424.  Use Verify Tax Explanation Code (B4200090.C).
TXA1Tax Rate / AreaIf blank and in add mode, load A5TXA1 from F0301 (ship to).  If
not blank, validate against F4008 (error 0272).  BF = F4008 Verify Tax Area B4200120.C. If tax area is
specified but the tax explanation code is blank, default tax explanation code from A5EXR1 in F0301
(ship to). If tax area is not blank, the tax explanation code must be non blank as well (error 0748). If
tax explanation code is not blank, the tax area must be non blank as well (error 0886).
TXCTCertificateIf blank and in add mode, default from ABTXCT in F0101 (sold to).
ATXTAssociated TextNo edits.
HOLDHold Orders CodeIf blank, default from Sold To Master F0301- Get Sold To Billing
Instructions; else, UDC edits (42/HC).
PLSTPrice Pick List (Y/N)Default from Sold To Master F0301- Get Sold To Billing
Instructions.
INVCInvoice CopiesDefault from Sold To Master F0301- Get Sold To Billing
Instructions.
ANBYBuyer NumberDD edits.
CARSCarrier NumberIf not blank, DD edits.  If blank, default from Ship To Master
F0301- Get Ship To Billing Instructions.
ROUTRout CodeIf not blank, UDC edit.  If blank, default from Ship To Master
F0301- Get Ship To Billing Instructions, UDC 42/RT.
STOPStop CodeIf not blank, UDC edits.  If blank, default from Ship To Master
F0301- Get Ship To Billing Instructions, UDC 42/SP.
ZONZone NumberIf not blank, UDC edit.  If blank, default from Ship To Master
F0301- Get Ship To Billing Instructions, UDC 40/ZN.
FRTHFreight Handling CodeIf not blank, UDC edits.  If blank, default from Ship To Master
F0301- Get Ship To Billing Instructions.
AFTApply Freight (Y/N)If not blank, DD edits.  If blank, default from Ship To Master
F0301- Get Ship To Billing Instructions.
CMC1Commission Code 1If blank, default from Ship To Master F0301. Get Ship To Billing
Instructions. If not blank, validate against F42004 (F42004VerifyCommissionCode)
CMR1Commission Rate 1If zero, default from Ship To Master F0301- Get Ship To Billing
Instructions.
CMC2Commission Code 2If blank, default from Ship To Master F0301. Get Ship To Billing
Instructions. If not blank, validate against F42004 (F42004VerifyCommissionCode)
CMR2Commission Rate 2If zero, default from Ship To Master F0301- Get Ship To Billing
Instructions.
WUMDWeight Display U/MIf blank and in add mode, load A5WUMD from F0301 (ship to).  If
not blank, validate against UDC.
VUMDVolume Display U/MIf blank and in add mode, load A5VUMD from F0301 (ship to).  If
not blank, validate against UDC.
AUTNAuthorization NumberDD edits.
CACTCredit/Bank Account No.DD Edits.
CEXPExpired Date Credit/BankDD Edits.
CRRMMode (F)Force currency mode (CRRM - wf and parm)  to 'D' if base currency
and customer currency are identical. If blank, use default value in DD If not blank, edit against DD
CRCDCurrency CodeIf blank and currency is on, default from A5CRCD in F0301 (sold
to). If not blank and currency is on, validate against DD edits.  (edit trigger =
IsColumnInCurrencyTable)
CRRExchange RateIgnore if currency is off (CRYR - parm == 'N') If zero, retrieve
exchange rate from C0030 if base and customer currency are different.  If identical, move zero to
currency rate.  Use GetExchangeRate (C0030) If not zero and tolerance limit (TFCT-parm) is not zero,
validate against tolerance limits in proc option.  Issue warning 0681 if exceeds limits.  The tolerance
limits are compared against the changes in the exchange rate expressed in percentages.   BF = Verify Xchg
Rate Against Tolerance B4200110.C
ORBYOrdered ByNo edits.
TKBYOrder Taken ByDefault to User ID (from GetAuditInfo).
URCDUser Reserved CodeNo edits.
URDTUser Reserved DateNo edits.
URATUser Reserved AmountNo edits.
URABUser Reserved NumberNo edits.
URRFUser Reserved ReferenceNo edits.
UPMJDate UpdatedNo edits.
USERUser IDNo edits.

Processing Options and Work Fields:
ADVPWK-Advanced PricingSee Business Function Attachment.
EV06WK-Source of Data' ' = Input Parameters
'1' = F4201 and F4211
'2' = F4201/F42019 and F42119
'3' = F4001Z and F4011Z
'4' = F47011 and F47012
'5' = F42UI01 and F42UI11
EV07WK-Processing Mode' ' = Regular Order
'1' = Blanket/Duplicate Order
MATH01WK- Suppress ProcessSpecify the processes to be suppressed by passing in the number
assigned to the option.  In order to specify a combination, add the number assigned to the option
together and send in the result. Options:
0 = Default (0)
1 = Writing Records When Warnings (1)
2 = Retrieve Processing Options (2)
4 = Product Allocation Window (3)
8 = Advanced Pricing Server (4)
16 = Inv. Commitments Was850Called (5)
32 = Inv. Commitments ChangesMadeToQty
64 =
EDOCSOD Document NoSource of Data DOCO - key
EDCTSOD Document TypeSource of Data DCTO - key
EKCOSOD Key CompanySource of Data KCOO - key
DCTPO-Default Order TypeDeleted 1/7/96
TFCTPO-Tolerance LimitDeleted 1/7/96
CP01WK-Price Effective
Based On DateDeleted 1/7/96
UMB1WK-Sales Price
Retrieval UoMDeleted 1/7/96
EV04WK-Skip Processing
OptionsDeleted 6/4/96
EV05WK-WriteRecordIfWarningDeleted 6/4/96

Special Output Returned
Common BeginDoc Parameters:
JOBSCM-Job NumberThe job number unique to the application.
ERRCCM-Error Conditions' ' = No Errors
'1' = Warnings
'2' = Errors
Sales Order Header Fields to be Edited:
KCOOOrder Company
DOCOOrder NumberSee Business Function Attachment.
DCTOOrder TypeIf not blank, UDC Edits.  If blank, default from processing
option (DCT-parm).
MCUBusiness UnitSee Business Function Attachment.
OKCOOriginal Order CompanyUsed for Copy/Blanket function.  No edits.
OORNOriginal Order NumberUsed for Copy/Blanket function.  No edits.
OCTOOriginal Order TypeUsed for Copy/Blanket function.  No edits.
AN8Address NumberSee Business Function Attachment.
Is required only if the ship to address (SHAN) is equal to zero.
SHANShip To NumberSee Business Function Attachment.
Is required only if the sold to address (AN8) is equal to zero.
DRQJRequested DateDefault to Transaction Date. Cannot be less than Transaction Date
- Verify Date 2 After Date 1.
TRDJOrder DateDefault to System Date.
PDDJPromised DateDefault to Requested Date. Cannot be less than system date -
Verify Date 2 After Date 1.
CNDJCanceled DateDate edits.
VR01ReferenceSee Business Function Attachment.
DEL1Delivery InstructionsIf blank, default from Ship To Master F0301- Get Ship To Billing
Instructions.
DEL2Delivery InstructionsIf blank, default from Ship To Master F0301- Get Ship To Billing
Instructions.
INMGPrint MessageIf not blank, UDC edits (40/PM). Default from Sold To Master
F0301- Get Sold To Billing Instructions.
PTCPa

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnCMJobNumber JOBS MATH_NUMERIC REQ NONE

The Job Number parameter is used by the program as a unique key field to read and write records from
the F42UI01 and F42UI11 caches.  When this parameter is passed with a zero the program will generate
the next available Job Number. The unique Job Number generated will ensure that the program will only
process the records entered for the current job.
^

cCMDocAction ACTI char REQ NONE

This parameter determines the kind of processing that will be performed on the order. Action can be
and Add, Change or Delete. If a blank was passed, Add action will be the default.

^

cCMProcessEdits EV01 char REQ NONE

This parameter determines the kind of edits that the order will go through. Depending on the value
passed in, an order can go through a full edit, a partial edit and a price only edit. Full edit will
commit the orders as well as retrieve the Preferences defined. Partial edit does not do commitments
whereas Price only will retrieve the Unit Price for each item ordered.

^

szCMComputerID CTID char REQ NONE

The Computer ID where the order is being processed. This parameter together with Job Number comprises
the unique composite keys used to clear the F42UI01 and F42UI11 caches.
^

cCMErrorConditions ERRC char NONE NONE

Special Output Returned
ERRCab ab CM-Error Conditions

Significant Data Values
' ' = No Errors
'1' = Warnings
'2' = Errors

^

cCMUpdateWriteToWF EV02 char REQ NONE

This parameter determines where to store the information.

Significant Data Values
'1' = Write and/or update records to the work file.
'2' = Write and/or update records to the cache
^

szCMProgramID 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.

szCMVersion VERS char NONE 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.

szOrderCo KCOO char REQ NONE

A number that, along with Order Number and Order Type, uniquely identifies a Sales Order document.
When this parameter is blank, the program will default the company to which the Cost Center belongs to.
^

mnOrderNo DOCO MATH_NUMERIC REQ NONE

The Order Number along with Order Company and Order Type uniquely identfies a Sales Order document.
When a zero is passed to this parameter the program will retrieve the next available number from the
Next Number system.
^

szOrderType DCTO char REQ NONE

Identifies the type of document being processed. If no value was passed then the program will default
the type defined in the Processing Option.
^

szBusinessUnit MCU char REQ NONE

The Cost Center where the items are going to be shipped from. If a blank was passed to this parameter
the program will retrieve the default from the Processing Option.
^

szOriginalOrderCo OKCO char NONE NONE

A number that is used in conjunction with the values in the ODOC and ODCT fields to identify a transaction.

szOriginalOrderNo OORN char NONE NONE

The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, and so on Matching document
numbers are also used to identify related documents in the Accounts Receivable and Accounts Payable systems. The document number
(DOC) is always the original document number. The matching document number (DOCM) is the check, adjustment, or credit to be applied
against the original document.

szOriginalOrderType OCTO char NONE NONE

This code defines the order type. It is verified in user defined codes (40/OT). Reserved document types have been defined for voucher
entry, invoice entry, receipts entry, and time sheet entry.  Because the offsetting entries for document types are created automatically during the
post program, they will not be self-balancing on original entry. The reserved document types are:    PR Purchase Requisition Orders    PQ
Purchase Quote    PO Purchase Order    PD Purchase Order - Direct Ship    PB Purchase Order - Blanket    SQ Sales Quote    SO Sales Order
SD Sales Order - Direct Ship    SB Sales Order - Blanket

mnAddressNumber AN8 MATH_NUMERIC REQ NONE

The address number of the Sold To customer. If this parameter is zero, it will be defaulted based on
the Customer Billing Instructions set up for the Ship To address.
^

mnShipToNo SHAN MATH_NUMERIC REQ NONE

The address number of the Ship To customer. If no value was passed, it will be defaulted based on the
Customer Billing Instructions of the Sold To Customer. Sold To and Ship To address numbers may not be
both zeros when passed to the program.
^

jdRequestedDate DRQJ JDEDATE NONE NONE

The date that an item is scheduled to arrive or that an action is scheduled for completion.

jdOrderDate TRDJ JDEDATE NONE NONE

Special Input Expected
TRDJab ab Order Dateab ab ab

Special Output Returned
DELETE THIS SECTION IF IT DOES NOT APPLY.

Significant Data Values
Default to System Date.

^

jdPromisedDate PDDJ JDEDATE NONE NONE

The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate
Available to Promise information. This value can be automatically calculated during sales order entry. This date represents the day that the item
can be shipped from the warehouse.

jdCancelDate CNDJ JDEDATE NONE NONE

The date that the order should be canceled if the goods have not been sent to the customer or the goods have not been received from the
supplier. This is a memo-only field and does not cause the system to perform any type of automatic processing. If a line on a sales order in
canceled in Sales Order Entry, this field will be updated with the date the line has been canceled.

szReference VR01 char NONE NONE

ab
Special Input Expected
VR01ab ab Reference

Special Output Returned
VR01ab ab Reference

Significant Data Values
See Business Function Attachment.

^

szDeliveryInstructions1 DEL1 char NONE NONE

One of two fields that you use to enter delivery instructions.

szDeliveryInstructions2 DEL2 char NONE NONE

The second of two fields that you use to enter delivery instructions.

szPrintMesg INMG char NONE NONE

A user defined code that you assign to each print message. Examples of text used in messages are engineering specifications, hours of
operation during holiday periods, and special delivery instructions.

szPaymentTerm PTC char NONE NONE

A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions
form. Examples of payment terms include: Blank Net 15 001      1/10 net 30 002      2/10 net 30 003      Due on the 10th day of every month 006
Due upon receipt This code prints on customer invoices.

cPaymentInstrument RYIN char NONE NONE

The user defined code (00/PY) that specifies how payments are made by the customer. For example: C Check   D Draft   T Electronic funds
transfer

szAdjustmentSchedule ASN char NONE NONE

A user defined code (40/AS) that identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
adjustment types for which a customer or an item might be eligible. The system applies the adjustments in the sequence that you specify in the
schedule. You link customers to a price and adjustment schedule through the customer billing instructions. When you enter a sales order, the
system copies the schedule attached to the sold to address into the order header. You can override this schedule at the detail line level. For
Agreement Management, this is the Agreement Penalty Schedule. The information in the Agreement Penalty Schedule provides the system
with the criteria for an agreement to have penalty conditions.

mnTradeDiscount TRDC MATH_NUMERIC NONE NONE

Percentage by which the system reduces the price of each item. This is the only discount that will be applied. You can override it if you
enter a price. Enter the percentage as a whole number (that is, 5 for 5%).

szTaxExplanationCode EXR1 char NONE NONE

A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
system uses the tax explanation code in conjunction with the tax rate area and tax rules to determine how the tax is calculated. Each
transaction pay item can be defined with a different tax explanation code.

szTaxArea TXA1 char NONE NONE

A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax
and G/L distribution amounts when you create an invoice or voucher.

szCertificate TXCT char NONE NONE

The number that tax authorities issue to tax-exempt individuals and companies to identify their tax-exempt status.

cAssociatedText ATXT char NONE NONE

This is a one byte flag that is used to determine whether or not a specific line item on a sales or purchase order has additional extended
text associated with it.

szHoldOrdersCode HOLD char NONE NONE

A user defined code (42/HC) that identifies why an order is on hold.

cPricePickListYN PLST char NONE NONE

An option that indicates whether price information appears on the customer's pick list, purchase order, or sales order. Valid values
are: On Price information appears Off Price information does not appear

mnInvoiceCopies INVC MATH_NUMERIC NONE NONE

The number of invoice copies required by the customer. The system prints the number of invoices specified in this field. The system
always prints at least one invoice.

mnBuyerNumber ANBY MATH_NUMERIC NONE NONE

The address book number that identifies who is responsible for setting up and maintaining the correct stocking levels for each inventory
item.

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.

szRouteCode ROUT char NONE NONE

The route field is a user defined code (system 42, type RT) that represents the delivery route on which the customer resides. This field is
one of several factors used by the freight summary facility to calculate potential freight charges for an order. For picking, use the route code with
the stop and zone codes to group all of the items that are to be loaded onto a delivery vehicle for a specific route. You set up a default for
each of these fields on the Customer Billing Instruction form.

szStopCode STOP char NONE NONE

The stop code is a user defined code (system 42, type SP) that represents the stop on a delivery route. This field is one of several factors
used by the freight summary facility to calculate potential freight charges for an order. For picking, you can use the stop code with the route and
zone codes to group all items that are to be loaded onto a delivery vehicle for a specific route. You set up the default for each of these fields
on the Customer Billing Instructions form.

szZoneNumber ZON char NONE NONE

The zone field is a user defined code (system 40, type ZN) that represents the delivery area in which the customer resides. This field is one
of several factors used by freight summary facility to calculate potential freight charges for an order. For picking you can use the zone code
with the route and stop codes to group all item that are to be loaded onto a delivery vehicle for a specific route. You set up the default for each
of these fields on the Customer Billing Instructions form.

szFreightHandlingCode FRTH char NONE NONE

A user defined code (42/FR) designating the method by which supplier shipments are delivered. For example, the supplier could deliver to
your dock, or you could pick up the shipment at the supplier's dock. You can also use these codes to indicate who has responsibility for
freight charges. For example, you can have a code indicating that the customer legally takes possession of goods as soon as they leave the
supplier warehouse and is responsible for transportation charges to the destination.

cApplyFreightYN AFT char NONE NONE

An option that specifies whether the system performs freight calculations during processing.  Valid values are: On The system performs
freight calculations during processing. Off The system does not perform freight calculations during processing.

mnCommissionCode1 CMC1 MATH_NUMERIC NONE NONE

The first of two eight-character codes used to designate the salespeople who should receive credit for a sale to the customer.  This code is
first created in either the Address Book or through the Related Salespersons program.

mnCommissionRate1 CMR1 MATH_NUMERIC NONE NONE

The first of two percentages to be applied to either the gross sales amount or the gross margin for an order or order line in computing your
commission liability.  This percent can default from Billing Instructions or be entered directly to the order.

mnCommissionCode2 CMC2 MATH_NUMERIC NONE NONE

The second of two eight-character codes used to designate the salespeople who should receive credit for a sale to the customer.  This
code is first created in either the Address Book or through the Related Salespersons program.

mnCommissionRate2 CMR2 MATH_NUMERIC NONE NONE

The second of two commission percentages to be applied to either the gross sales amount or the gross margin for an order or order line in
computing your commission liability. This percent can come in from the Billing Instructions or be entered in the sales order.

szWeightDisplayUOM WUMD char NONE NONE

A user defined code (00/UM) that identifies which unit of measure the system should use to display the weight of individual order lines and
the order as a whole for this customer when you use the order summary form.

szVolumeDisplayUOM VUMD char NONE NONE

A user defined code (00/UM) that identifies the unit of measure that the system uses to display volume for this branch/plant. The system
inputs a value in this field from Branch/Plant Constants - Page 2 (P410012). You can override this default value.

szAuthorizationNo AUTN char NONE NONE

This field lets you record the authorization number provided by the credit card company or bank which issued the card.

szCreditBankAcctNo CACT char NONE NONE

The first of three fields available to record credit card transactions. This field allows you to record the customer's account number with the
credit card company or bank.

jdCreditBankExpiredDate CEXP JDEDATE NONE NONE

This field is to record the account number and expiration date of credit cards used by your customers who make purchases from you.  It is
for information purposes only.

cMode CRRM char NONE NONE

An option that specifies whether the system displays amounts in the domestic or foreign currency. On The system displays amounts in the
foreign currency of the transaction. Off The system displays amounts in the domestic currency of the transaction.

szCurrencyCode CRCD char NONE NONE

A code that identifies the currency of a transaction.

mnExchangeRate CRR MATH_NUMERIC NONE NONE

A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount. The number in this field
can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.

szOrderedBy ORBY char NONE NONE

SALES ORDER SYSTEM:  An optional entry field, intended for the name of the customer placing the order.

szOrderTakenBy TKBY char NONE NONE

SALES ORDER SYSTEM:  An optional entry field, intended for the name of the individual taking the customer's order. If you do not enter a
user ID in this field, the system uses the ID of the person who is signed on.

szUserReservedCode URCD char NONE NONE

This is a 2 position code that is reserved for the user.  JDE does not currently use this field and will not utilize this field in the future.

jdUserReservedDate URDT JDEDATE NONE NONE

This is a 6 position code that is reserved for the user.  JDE does not currently use this field and will not utilize this field in the future.

mnUserReservedAmnt URAT MATH_NUMERIC NONE NONE

This is a 15 position code that is reserved for the user.  JDE does not currently use this field and will not utilize this field in the future.

mnUserReservedNo URAB MATH_NUMERIC NONE NONE

This is a 8 position code that is reserved for the user.  JDE does not currently use this field and will not utilize this field in the future.

szUserReservedRef URRF char NONE NONE

A 15-position reference that is reserved for the user.  J.D. Edwards does not currently use this field and does not plan to use it in the future.

jdDateUpdated UPMJ JDEDATE NONE NONE

The date that specifies the last update to the file record.

szUserID USER char NONE NONE

The code that identifies a user profile.

szWKBaseCurrency CRDC char NONE NONE

A code that identifies the domestic (base) currency of the company on a transaction.

cWKAdvancedPricingYN ADVP char NONE NONE

Indicates how the system determines the price of items within your system.  If your system includes the advanced pricing module, you may
use this feature.    Y The system will use advanced pricing.    N The system will NOT use advanced pricing.

szWKCreditMesg CM char NONE NONE

A value in the user defined code table 00/CM that indicates the credit status of a customer or supplier. Examples are: 1 Over credit
limit 2 Requires purchase order 3 Not on contract maintenance agreement The credit message displays on inquiry and transaction entry forms in the
Accounts Payable, Sales Order Management, and Procurement systems. The system displays the temporary credit message in the Accounts
Receivable system.

szWKTempCreditMesg TSTA char NONE NONE

A user defined code that identifies a temporary credit status. Generally, you assign the code when an account becomes past due. The
system automatically updates the temporary credit message based on the notification instructions that you set up for the policy that you assign to
the customer. The system can automatically reset the temporary credit message back to the credit message if you activate the option in
the policy. You can also manually enter and update the temporary credit message on the customer record. If you leave this field blank, the
system assigns the value of the Credit Message field when you run Credit Analysis Refresh (R03B525). The system displays the temporary
credit message on the transaction entry forms in the Accounts Receivable and Sales Order Management systems.

cWKInvalidSalesOrderNo EV03 char NONE NONE

Special Output Returned
EV03ab ab WK_Invalid Sales Order Number

Significant Data Values
Please refer to business function attachments for processing detail

^

cWKSourceOfData EV06 char REQ NONE

This parameter will determine where to retrieve the source of data.

Significant Data Values
' ' = Input Parameters
'1' = F4201 and F4211
'2' = F4201/F42019 and F42119
'3' = F4001Z and F4011Z
'4' = F47011 and F47012
'5' = F42UI01 and F42UI11

^

cWKProcMode EV07 char NONE NONE

ab
Special Input Expected
EV07ab ab WK-Processing Mode

Significant Data Values
' ' = Regular Order
'1' = Blanket/Duplicate Order
^

mnWKSuppressProcess MATH01 MATH_NUMERIC NONE NONE

ab
Special Input Expected
MATH01ab WK- Suppress Process

Special Output Returned
MATH01ab WK- Suppress Process

Significant Data Values
Specify the processes to be suppressed by passing in the number assigned to the option.  In order to
specify a combination, add the number assigned to the option together and send in the result. Options:
0 = Default (0)
1 = Writing Records When Warnings (1)
2 = Retrieve Processing Options (2)
4 = Product Allocation Window (3)
8 = Advanced Pricing Server (4)
16 = Inv. Commitments Was850Called (5)
32 = Inv. Commitments ChangesMadeToQty
64 =

^

mnSODDocNo EDOC MATH_NUMERIC NONE NONE

The document number that is assigned by the transmitter in an EDI transaction. In a non EDI environment, this would be consistent with the
order number assigned at order entry time (DOCO).

szSODDocType EDCT char NONE NONE

The document type that is assigned by the transmitter in an EDI transaction. In a non EDI environment, this would be consistent with the order
type (DCTO) assigned at order entry time, an invoice document type, a voucher document type, and so on.

szSODOrderCo EKCO char NONE NONE

Company - Key (EDI - Document Key Co)

mnTriangulationRateFrom TRR1 MATH_NUMERIC OPT NONE

The triangulation currency rate used to convert the From currency code to the Triangulation currency code.

mnTriangulationRateTo TRR2 MATH_NUMERIC OPT NONE

The triangulation currency rate that used to convert from the Triangulation currency code to the To currency code.

cCurrencyConversionMethod CRCM char OPT NONE

A value that specifies which method to use when converting from one currency to another. Valid values are: Y Multiplier method. The
system multiplies the foreign amount by the multiplier exchange rate to calculate the domestic amount. Z Divisor method. The system divides the
foreign amount by the divisor exchange rate to calculate the domestic amount.

cRetrieveOrderNo EV02 char OPT NONE

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

szPricingGroup PRGP char OPT NONE

A user defined code (system 40/type PC) identifying the pricing group associated with this customer or supplier:     o For sales orders, you
assign a pricing group to a customer through the Customer Billing Instructions. Groups typically contain customers with common pricing
characteristics, such as retailers, wholesalers, and so forth.     o For purchase orders, you assign a pricing group to a supplier through the Supplier
Billing Instructions.

cCommitInvInED EV05 char OPT NONE

A flag that indicates whether automatic spell check is turned on.

cSpotRateAllowed CSR char OPT NONE

An option that indicates whether a spot rate is applicable for a particular currency relationship. Spot rates are exchange rates entered at the
time of transaction entry.

cGenericChar2_EV02 EV02 char OPT NONE

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

szGenericString1_DL01 DL01 char OPT NONE

A user defined name or remark.

szGenericString2_DL02 DL02 char OPT NONE

Additional text that further describes or clarifies a field in the system.

mnGenericMathNumeric1_MATH01 MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnGenericMathNumeric2_MATH02 MATH02 MATH_NUMERIC OPT NONE

- - - Good Performance High Value.

szLongAddressNumberShipto ALKY char OPT NONE

A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the
address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede
it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book
number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from
other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.

szLongAddressNumber ALKY char OPT NONE

A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the
address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede
it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book
number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from
other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.

mnProcessID PEID MATH_NUMERIC OPT NONE

A code that identifies the Inter-Process Communication ID.

mnTransactionID TCID MATH_NUMERIC OPT NONE

szSoldToBSC BSC char OPT NONE

A value that groups customers with similar buying habits.

szShipToBSC BSC char OPT NONE

A value that groups customers with similar buying habits.

mnRMANumber DOC1 MATH_NUMERIC OPT NONE

The document number associated with a given document type.

szRMADocType DCT4 char OPT NONE

User-defined codes that identify the type of document.

jdDatePriceEffectiveDate PEFJ JDEDATE OPT NONE

The system uses the Price Effective Date to determine the base price and all advanced price adjustments.  The value loaded in this date
is stored in the System Constants File (F4009).

szSOEMBFInternalFlags SOEF char OPT NONE

This field is broken down into 30 different flags which are passed in and out of the sales order entry MBF - F4211 Begin Doc, F4211 Pre
Processor, F4211 Edit Line, and F4211 End Doc.

szOPBusinessObjective OPBO char OPT NONE

A value that specifies a default business objective to send outbound to order promising before an order has been promised. A business
objective is a grouping of business rules that fulfill a sales order. For sales order detail lines, this value specifies the business objective that is
selected by order promising after an order has been promised.

cOPPartialOrderShipmentAllowed OPPL char OPT NONE

An option in order promising that specifies whether all line items must be shipped to the customer on the same date. Valid values are: Y The
line items may be delivered on different dates, depending on availability. N The delivery date to the customer will be the date of the latest
line items' availabilty.

cOPPartialLineShipmentAllowed OPLL char OPT NONE

An option that specifies whether to allow partial shipments in order promising. This option works with the Allow Backorders option. Valid
values are: Y Split the sales order line item in order promising, deliver part of the requested inventory one day, and deliver the rest on another
day. N Order promising cannot split the sales order line item.

cOPBackorderAllowed OPBA char OPT NONE

An option that specifies, in order promising, whether a line item can be shipped later than the requested date, based on future availability.
This option works with the Partial Line Shipments option. Valid values are: Y If the Partial Line Shipments value is Y, the quantity that is
available on the requested date is shipped. The remaining quantity is shipped on the available date. If the Partial Line Shipments value is N, the
entire quantity is shipped on the date that it becomes available. N The available quantitity on the requested date is shipped.

cOPMultiSourcingAllowed OPMS char OPT NONE

An option that specifies whether multisourcing is allowed in order promising. Valid values for the sales order header are: Y Allow order
promising to source different detail lines from different branch/plants. N All line items are sourced from the same branch/plant. Valid values for the
sales order detail are: Y Allow order promising to source the inventory for this line item from more than one branch/plant. N This line item can be
sourced from only one branch/plant.

cOPSubstituteAllowed OPSS char OPT NONE

An option that specifies whether to allow substitution for sales order line items in order promising. Valid values are: Y The product can be
substituted if it is unavailable. N The product cannot be substituted.

mnAddressNumberDeliveredTo DVAN MATH_NUMERIC OPT NONE

The address number of the person who receives the goods ordered. The delivered to address might differ from the ship to address when
ordered goods are processed through a distribution center (which is the delivered to address) before reaching their final destination (the ship
to address).

mnAddressNumberInvoicedTo ITAN MATH_NUMERIC OPT NONE

The address book number of the person who receives the invoice.

mnAddressNumberPaidBy PBAN MATH_NUMERIC OPT NONE

The address book number of the person who pays the amount on the invoice.

mnAddressNumberForwardedTo FTAN MATH_NUMERIC OPT NONE

The address book number of the person to whom invoice statements are sent.

cAddressNumberForTax AUFT char OPT NONE

An option that indicates which address number the system uses for tax purposes. Valid values are: 1 The system uses the ship to address
number. 2 The system uses the deliver to address number.

cAddressNumberForTransport AUFI char OPT NONE

An option that indicates which address number the system uses for transportation and intrastat purposes. The system uses the address
number as the ship to address for transportation. Valid values are: 1 The system uses the ship to address number. 2 The system uses the deliver
to address number.

mnRequestedDeliveryTime DRQT MATH_NUMERIC OPT NONE

The time requested for delivery. 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.

nSourceOfOrder SOOR integer OPT NONE

A code that identifies the origination source of the order.

mnPromisedPickTime PDTT MATH_NUMERIC OPT NONE

The time when the order is scheduled to be picked. Enter the time in the 24-hour format and include a leading zero if necessary. For
example, enter 6:00 a.m. by typing 060000 and enter 7:00 p.m. by typing 190000.

szModeOfTransport MOT char OPT NONE

A user defined code (00/TM) that describes the nature of the carrier being used to transport goods to the customer. For example, by rail, by
road, and so on.

szReasonCode RCD char OPT NONE

A user defined code (42/RC) that explains the purpose for a transaction. For example, you can indicate the reason that you are returning
items.

mnPartnerAddressNumber PRAN8 MATH_NUMERIC OPT NONE

The address number (F0101) of the partner associated with the lead.

mnPartnerContactLineNumID PRCIDLN MATH_NUMERIC OPT NONE

The line number identifier from the Who's Who (F0111) representative of Contacts for a Partner.

mnOpportunityId OPPID MATH_NUMERIC OPT NONE

A unique identifier related to the Opportunity.

szSoldToAttention SDATTN char OPT NONE

Attention field for billing specifications.

mnShipToCusContactLineNumID SHCCIDLN MATH_NUMERIC OPT NONE

Ship To Customer contact line number.

szShipToAttention SPATTN char OPT NONE

Attention field for shipping specifications.

cOrderTypeIndicator OTIND char OPT NONE

This field differentiates order types.

mnCustomerContactLineNumID CCIDLN MATH_NUMERIC OPT NONE

szSoldToContactAlphaName ALPH char OPT NONE

The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.

szShipToContactAlphaName ALPH char OPT NONE

The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.

idSourceOfDataContext GENLNG ID OPT NONE

General purpose ID variable.

szLongAddressNumberDeliveredTo ALKY char OPT NONE

A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the
address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede
it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book
number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from
other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.

szLongAddressNumberInvoicedTo ALKY char OPT NONE

A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the
address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede
it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book
number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from
other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.

szLongAddressNumberPaidBy ALKY char OPT NONE

A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the
address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede
it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book
number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from
other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.

szLongAddressNumberForwardedTo ALKY char OPT NONE

A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the
address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede
it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book
number to the field. For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from
other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.

Related Functions

B0000021 Format Subledger

B0000027 CurrencyConvForAndDom

B0000033 Get Exchange Rate

B0000128 Retrieve Company Currency Code

B0000130 Retrieve Company From Business Unit

B0100002 A/B - Get Parent Address

B0100024 Convert Transaction Amt to Customer Ccy & Upd F0301

B3201150 F4801 Update WO Status During SO Change Mode

B3800080 Agreement Cache For Sales Order

B4000150 Get Branch Constants

B4000260 Line Type - Activity Rules

B4000310 Location Information

B4000360 Check Location Master

B4000370 Get Default Branch

B4000450 Convert Short Item To Long Item

B4000520 Get Item UoM Conversion Factor

B4000530 Get Distribution Constants

B4000590 Verify Line Type

B4000610 Get Lot Master By Lot Number

B4000670 Get Item Units Of Measure

B4000790 Verify Date2 After Date1

B4000800 Edit Document Type Not Blank

B4000870 Standard Pricing Adjustments

B4000880 Verify And Get Address Book for OP

B4000950 Return the Item Stocking Type

B4000960 Verify Override Next Status Code

B4001100 Write Hold Code

B4002000 Compute Unit Or Extended Amount

B4002020 Purge Held Order Records

B4002060 Preference Get Values For Sales Order

B4002300 Preference Allocations

B4100205 Get Item Master Price Info

B4100210 Check Item Branch

B4101220 Calculate Availability

B4200030 F4201 Get Order No. From Next Number

B4200050 F42004 Verify Commission Code

B4200070 Get Sales Base Price

B4200080 Convert Domestic And Foreign Amount

B4200090 Verify Tax Explanation Code

B4200100 Get Sold To Billing Instructions

B4200110 Verify Xchg Rate Against Tolerance

B4200120 F4008 Verify Tax Area

B4200130 Verify Customer PO Number Is Unique

B4200140 Get Ship To Billing Instructions

B4200150 Verify Sales Order Before Update

B4200160 Get Freight Rate Code From F4020

B4200210 Get F4211 Detail Information

B4200230 F4074 Maintain Price History

B4200270 Check Item Restrictions

B4200280 Calculate Commitment Date

B4200290 Margin Check Processing

B4200311 Sales Order Entry Master Business Function

B4200340 Verify And Get Sales Header

B4200370 Commit Sales Order To Inventory

B4200420 Credit Check Processing

B4200450 Advanced Sales Order Detail Line Split

B4200490 Relieve SO Blanket Order Qty

B4200690 Copy SO Info To Work Files

B4200710 CalculateTransferCost

B4200760 Add Order to Subsystem Queue

B4200780 F42UI130 Get/Update Commitment Work File

B4200830 Retrieve Interbranch Order Types

B4200850 Preference Calculate Commitments

B4201210 Serial Number Processing Edits

B4201270 F49211 Maintain Sales Detail Table

B4201280 F42UI12 Get Sales Order Detail Info

B4301250 F4311Z Update Related Order Info

B4500050 F4072 Calculate Price Adjustments

B4500090 F4074 Price Adjustment Ledger Server

B4500200 F4573 Get Next Free Good

B4600130 Cache, Warehouse Components

B4700070 EDI - Convert EDI Text To Generic Text

B7600720 Retrieve Cache Information from Sales Header - Brazil - 42B

B7600730 Retrieve Cache Information from Sales Detail - Brazil - 42B

B7600750 Write Cache Information Sales Detail - Brazil - 42B

B7600790 Write Cache to Sales Detail File - Brazil - 42B

B9800100 Get Audit Information

B9800420 Get Data Dictionary Definition

B9900410 Get Environment Value

N3200700 Write Configurator Files at End Doc

N3201130 Duplicate Configurator Information

N3800040 F38012 Agreement Transaction Server

N3800050 F38010 Agreement Search

N4002510 Verify Original Blanket Order Before Update

N4200870 Increment Sales Detail Line Number

N4201010 Determine If Blanket SO Exists

N4301750 Add Matching F4006 Record

N4600030 Warehouse Management Request Transactions

N4600320 F40203 Validate AWM Override Status

N4700130 EDI Update Inbound Detail As Processed

N4900010 F4215 Add Shipment Detail

N4900180 Process Order Line

N7000320 B4200310 - Plug & Play - 42B

R42997 Inventory Commitment

X0005 Get User Defined Codes

X0903 Fiscal Date Edits +

X0909 Validate Subledger

X4101 Validate and Retrieve Item Master

XF41021 Update F41021 Locations

XF4105 Item Cost I/O

XT4311Z1 Purchase Order Entry

Related Tables

F4201 Sales Order Header File

F4211 Sales Order Detail File

F42UI01 SO Header Cache File (MBF)

F42UI11 SO Detail Cache File (MBF)

F42UI130 Commitment Work File

F4573 Free Goods Reference File

F4211FSEditLine
F4211FSEditLine

Sales Order Entry Master Business Function

Master Business Function

Object Name: B4200310

Parent DLL: CSALES

Location: Client/Server

Language: C

Data Structure

D4200310F - F4211 FS Edit Line

Special Input Expected
Common Edit Line Parameters:
CTIDCM-Computer IDThe calling application should retrieve this from
GetLocalComputerID (B9800100).
JOBSCM-Job NumberThe job number unique to the application.
LINXCM-Line NumberUnique line number of the F42UI11 work file.  If zero, edit line
will assign a line number.  (See 1.3 Special Logic).
ACTICM-Line ActionLine Action (Add, Bypass, Chg, Del, Purge) If not passed in, Add
is defaulted
EV01CM-Process Edits0 = No Edits
1 = Full Edits
2 = Partial Edits (Store & Forward)
3 = Partial Edits (Sales Order Batch Price/Cost)
Update If blank, default to 1 in program.
EV03CM-Update or Write to Work File
'1' = Write and/or update records to the work file.
'2' = Write and/or update records to the cache
EV04CM-Record Written to Work File
Set to '1' after a record has been written to the work file.
This will save on B calls to the work file.
'  ' = No records written
'1' = Sales Order record exist in work file.
'2' = Purchase Order record written.
'3' = Sales Order and Purchase Order written.
'4' = Work Order record written.
'5' = Sales Order and Work Order written.
'6' = Purchase Order and Work Order written.
'7' = Sale, Purchase, and Work Orders written.
'8' = Line is cancelled.
CRYRCM-Currency ControlRetrieved from system values.
PIDProgram ID
VERSVersion ID

Fields needed to process the detail level information:

KCOOOrder Key CompanyIf blank, assign using the Header Branch (EMCU).
Retrieve Company from Business Unit (RETCOBU.C)
DOCOOrder NumberNo edits.  Edits already performed in BeginDoc.
DCTOOrder TypeNo edits.  Edits already performed in BeginDoc.
LNIDLine NumberMust be unique per sales order.
** If using source of data == '5', use this field to pass in the
LNID key field value.
MCUBranch/PlantIf not blank, validate against F006 and F41001.
Use Get Branch Constants (B4000150.C)
SHANShip To AddressIf different from header, validate against F0301 using
GetShipToBillingInstructions (B4200140.C)
DRQJRequested DateIf zero, default from header requested date (SHDRQJ).
PDDJPromised DateIf zero, default from Requested Date (DRQJ).
CNDJCancel DateIf not zero, must be a valid date.  No default if zero.
RSDJPromised Delivery DateIf zero, default from Promised Ship (PDDJ).
UITMItem NumberRequired Input field.
LOCNLocationSee 2.4 Processing.
LOTNLot NumberSee 2.4 Processing.
DSC1Description 1No Edits.
DSC2Description 2No Edits.
LNTYLine TypeSee 2.4 Processing.
LTTRLast StatusSee 2.4 Processing.
NXTRNext StatusSee 2.4 Processing.
UORGQuantity OrderedSee 2.4 Processing.
SOQSQuantity ShippedSee 2.4 Processing.
SOBKQuantity BackorderedSee 2.4 Processing.
SOCNQuantity CanceledSee 2.4 Processing.
UPRCUnit PriceSee 2.4 Processing.
AEXPExtended PriceSee 2.4 Processing.
UNCSUnit CostSee 2.4 Processing.
ECSTExtended CostSee 2.4 Processing.
INMGPrint MessageIf not blank, validate against UDC.
PTCPayment TermsIf not blank, must be a valid payment terms in F0014.
Use Validate Payment Term against F0014 (ISCOLPT.C).
Default from header.
RYINPayment InstrumentDefault from header.  If not blank, UDC edits.
ASNAdjustment ScheduleOnly edit if doing advanced pricing (ADVP='Y') in System
Constants.  UDC edit.
PRGRItem Price GroupUDC edit.
CADCCash DiscountDD Edits.
TAX1Sales TaxableDD Edits.
EXR1Tax Explanation CodeIf blank, load from F0301 for sold to.
If not blank, validate against UDC.
The leftmost character must not be 'B' or 'U'.
Error 0748.  BF= Verify Tax Explanation Code B4200090.C. The
second character must not be a 'T' for tax only. Error 3424.
BF= Verify Tax Explanation Code B4200090.C
TXA1Tax AreaIf blank and in add mode, load A5TXA1 from F0301 (ship to).
If not blank, validate against F4008 (error 0272).
BF = F4008 Verify Tax Area B4200120.C.
If tax area is specified but the tax explanation code is blank,
default tax explanation code from A5EXR1 in F0301 (ship to). If tax area is not blank, the tax
explanation code must be non blank as well (error 0748). If tax explanation code is not blank, the tax area
must be non blank as well (error 0886).
ATXTAssociated TextNo Edits.
CARSCarrier NumberDefault from header, else must be valid address number in F0101.
DD Edit trigger.
ROUTRoute CodeDefault from header, UDC edit if not blank.
STOPStop CodeDefault from header, UDC edit if not blank.
ZONZone NumberDefault from header, UDC edit if not blank.
AFTApply Freight (Y/N)Edit against DD.  Do not load the default value in DD because it
should default in from the Line Type constants (F40205).
FRATRate Code - Freight/Misc.DD Edits.
SHCMShipping Commodity ClassUDC Edits.  Default from Item Branch (F4102).
SHCNShipping Condition CodeUDC Edits.  Default from Item Branch (F4102).
UOMTransaction U of MeasureSee 2.4 Processing.
UOM4Pricing Unit of MeasureSee 2.4 Processing.
ITWTItem WeightSee 2.4 Processing.
WTUMWeight Unit of MeasureUDC Edits.
ITVLItem VolumeSee 2.4 Processing.
VLUMVolume Unit of MeasureUDC Edits.
GLCG/L ClassEdit against DD except do not load the default value from DD.
Default from Item Branch (F4102) or Line type.  See 2.4 processing.
SLSMSalesperson 01If blank and in add mode, load from header.  If not blank,
validate against F42004VerifyCommissionCode (B4200050.C).
SLCMSalesperson Commission 01If blank and in add mode, load A5CMR1 from F0301 (ship to).  If
not blank, validate against DD.
SLM2Salesperson 02If blank and in add mode, load from header.  If not blank,
validate against F42004VerifyCommissionCode (B4200050.C).
SLC2Salesperson Commission 02If blank and in add mode, load A5CMR1 from F0301 (ship to).  If
not blank, validate against DD.
ACOMApply CommissionsDD Edits.
RCDReason CodeDD Edits.
SBLSubledgerIf non blank or subledger type is non blank, call X0909 to
validate the subledger information.
SBLTSubledger TypeUDC Edits.
FUPForeign Unit PriceSee 2.4 Processing.
FEAForeign Extended PriceSee 2.4 Processing.
FUCForeign Unit CostSee 2.4 Processing.
FECForeign Extended CostSee 2.4 Processing.
VENDSupplier NumberIf not zero, must be a valid address number.  (Use DD trigger)
If zero, default from item branch.  (See 2.4 processing)
RLITRelated Item Number (Kit)No edits and update to work file.
KTLNKit Master Line NumberNo edits and update to work file.
CPNTComponent Line NumberNo edits and update to work file.
RKITRelated Kit ComponentNo edits and update to work file.
KTPNumber of Cpnt per ParentNo edits and update to work file.
PROVOverride PriceSee 2.4 processing.
CSTOOverride CostSee 2.4 processing.
URCDUser Reserved CodeNo Edits.
URDTUser Reserved DateNo Edits.
URATUser Reserved AmountNo edits.
URABUser Reserved NumberNo Edits.
URRFUser Reserved ReferenceNo Edits.
PRP5Landed Cost RuleDD edit and default.
PRIOPriority ProcessingSee 2.4 processing.

Processing Options and Work Fields:
OTOTWK-Order TotalDomestic Order Total
FAPWK-Foreign Order TotalForeign Order Total
TOTCWK-Total CostDomestic Total Cost (Only used in ADD mode)
FCSTWK-Foreign Total CostForeign Total Cost (Only used in ADD mode)
EV07WK-Check Availability'1' - check availability of item.
' ' - Bypass availability checking.
LNIXWK-Last Line Number AssignedLast line number assigned to the work file.  Always incremented
by 1.
PMTHWK-Method of Price CalculationSee 2.4 processing.
EV05WK-Processing Mode' ' = Regular Order
'1' = Copy Order
EV06WK-Source of Data' ' = Input Parameters
'1' = F4201 and F4211
'2' = F4201/F42019 and F42119
'3' = F4001Z and F4011Z
'4' = F47011 and F47012
'5' = F42UI01 and F42UI11
MATH01WK-Suppress ProcessingSpecify the processes to be suppressed by passing in the number
assigned to the option.
In order to specify a combination, add the number assigned to the
option together and send in the result.
Options:
0 = Default
1 = Writing Records When Warnings
2 = Retrieve Processing Options
4 = Production Allocation Warning
8 = Advanced Pricing Server
16 = Inv. Commitments - Was850Called
32 = Inv. Commitments - ChangesMadeToQty
64 =
EDLNSOD/EDI Line NumberSource of Data LNID - key
AREVPrice Adjustment Revision Level
ALPHWK Sales Order Flags
EDOCSOD Document NumberSource of Data DOCO - key
EDCTSOD Document TypeSource of Data DCTO - key
EKCOSOD Key CompanySource of Data KCOO - key
TMCUTransfer Order To Branch
DETDDomestic Detached Adjustment
DETFForeign Detached Adjustment
DOCTransfer Order Entry Purchase Order No
DCTTransfer Order Entry Purchase Order Type
CRRDTransfer Order Entry Purchase Order Exchange Rate
CRCETransfer Order Entry Purchase Order Currency Code
UKIDDRP Key ID
AN8Sold  To CustomerRequired when Process Edits = 2
EMCUF4201 Branch PlantRequired when Process Edits = 2
CRCDSold To Currency CodeRequired when Process Edits = 2
EV08Consolidation Flag' ' - No consolidation

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnCMJobNo JOBS MATH_NUMERIC REQ NONE

The Job Number parameter is used by the program as a unique key field to read and write records from
the F42UI01 and F42UI11 caches.  When this parameter is passed with a zero the program will generate
the next available Job Number. The unique Job Number generated will ensure that the program will only
process the records entered for the current job.

^

cCMLineAction ACTN char REQ NONE

This parameter determines the kind of processing that will be performed on the order. Action can be
and Add, Change or Delete. If a blank was passed, Add action will be the default.
^

cCMProcessEdits EV01 char REQ NONE

This parameter determines the kind of edits that the order will go through. Depending on the value
passed in, an order can go through a full edit, a partial edit and a price only edit. Full edit will
commit the orders as well as retrieve the Preferences defined. Partial edit does not do commitments
whereas Price only will retrieve the Unit Price for each item ordered.

^

cCMWriteToWFFlag EV03 char REQ NONE

This parameter determines where to store the information.

Significant Data Values
'1' = Write and/or update records to the work file.
'2' = Write and/or update records to the cache
^

cCMRecdWrittenToWF EV04 char NONE NONE

Special Input Expected
EV04ab CM-Record Written to Work File

Special Output Returned
EV04ab CM-Record Written to Work File

Significant Data Values
Set to '1' after a record has been written to the work file.
This will save on B calls to the work file.
' ' = No records written
'1' = Sales Order record exist in work file.
'2' = Purchase Order record written.
'3' = Sales Order and Purchase Order written.
'4' = Work Order record written.
'5' = Sales Order and Work Order written.
'6' = Purchase Order and Work Order written.
'7' = Sale, Purchase, and Work Orders written.
'8' = Line is cancelled. ab

^

szCMComputerID CTID char REQ NONE

The Computer ID where the order is being processed. This parameter together with Job Number comprises
the unique composite keys used to read and write to the F42UI01 and F42UI11 caches.
^

cCMErrorConditions 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).

szOrderCo KCOO char REQ NONE

A number that, along with Order Number and Order Type, uniquely identifies a Sales Order document.
When this parameter is blank, the program will default the company to which the Cost Center belongs to.

^

mnOrderNo DOCO MATH_NUMERIC REQ NONE

The Order Number along with Order Company and Order Type uniquely identfies a Sales Order document.
When a zero is passed to this parameter the program will retrieve the next available number from the
Next Number system.
^

szOrderType DCTO char REQ NONE

Identifies the type of document being processed. If no value was passed then the program will default
the type defined in the Processing Option.
^

mnLineNo LNID MATH_NUMERIC REQ NONE

The Line Number of the order being processed. The Line Number together with Order Company, Order
Number and Order Type make up the composite key that uniquely identifies a Sales Order Detail line.
^

szBusinessUnit 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.

mnShipToNo SHAN MATH_NUMERIC NONE 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.

jdRequestedDate DRQJ JDEDATE NONE NONE

The date that an item is scheduled to arrive or that an action is scheduled for completion.

jdPromisedDate PDDJ JDEDATE NONE NONE

The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate
Available to Promise information. This value can be automatically calculated during sales order entry. This date represents the day that the item
can be shipped from the warehouse.

jdCancelDate CNDJ JDEDATE NONE NONE

The date that the order should be canceled if the goods have not been sent to the customer or the goods have not been received from the
supplier. This is a memo-only field and does not cause the system to perform any type of automatic processing. If a line on a sales order in
canceled in Sales Order Entry, this field will be updated with the date the line has been canceled.

jdPromisedDlvryDate RSDJ JDEDATE NONE NONE

The date an item will be delivered to the customer.

szItemNo UITM char OPT NONE

The long number that was assigned to an item being processed.
^

szLocation LOCN char OPT NONE

The storage location from which goods will be moved.

szLotNo LOTN char OPT NONE

A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.

szDescription1 DSC1 char NONE NONE

Brief information about an item; a remark or an explanation.

szDescription2 DSC2 char NONE NONE

A second, 30-character description, remark, or explanation.

szLineType LNTY char NONE NONE

A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
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

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.

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.

mnQtyOrdered UORG MATH_NUMERIC NONE NONE

The quantity of units affected by this transaction.

mnQtyShipped 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.

mnQtyBackordered 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.

mnQtyCanceled 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.

mnUnitPrice 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).

mnExtendedPrice AEXP MATH_NUMERIC NONE NONE

The number of units multiplied by the unit price.

mnUnitCost UNCS MATH_NUMERIC NONE NONE

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

mnExtendedCost ECST MATH_NUMERIC NONE NONE

For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
number of units.

szPrintMesg INMG char NONE NONE

A user defined code that you assign to each print message. Examples of text used in messages are engineering specifications, hours of
operation during holiday periods, and special delivery instructions.

cPaymentInstrument RYIN char NONE NONE

The user defined code (00/PY) that specifies how payments are made by the customer. For example: C Check   D Draft   T Electronic funds
transfer

szAdjustmentSchedule ASN char NONE NONE

A user defined code (40/AS) that identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
adjustment types for which a customer or an item might be eligible. The system applies the adjustments in the sequence that you specify in the
schedule. You link customers to a price and adjustment schedule through the customer billing instructions. When you enter a sales order, the
system copies the schedule attached to the sold to address into the order header. You can override this schedule at the detail line level. For
Agreement Management, this is the Agreement Penalty Schedule. The information in the Agreement Penalty Schedule provides the system
with the criteria for an agreement to have penalty conditions.

cSalesTaxableYN TAX1 char NONE NONE

A code that indicates whether the item is subject to sales tax when you sell it. The system calculates tax on the item only if the customer is
also taxable.

cAssociatedText ATXT char NONE NONE

This is a one byte flag that is used to determine whether or not a specific line item on a sales or purchase order has additional extended
text associated with it.

szTransactionUOM 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).

szPricingUOM UOM4 char NONE NONE

A user defined code (00/UM) that indicates the unit of measure in which you usually price the item.

mnItemWeight ITWT MATH_NUMERIC NONE NONE

The weight of one unit of an item, expressed in the primary unit of measure.

szWeightUOM 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

mnForeignUnitPrice FUP MATH_NUMERIC NONE NONE

The foreign price per unit.

mnForeignExtPrice FEA MATH_NUMERIC NONE NONE

The product of the foreign price times the number of units.

mnForeignUnitCost FUC MATH_NUMERIC NONE NONE

Amount - Foreign Unit Cost

mnForeignExtCost FEC MATH_NUMERIC NONE NONE

The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units.

szPricingCategoryLevel CLVL char NONE NONE

A pricing category or price rule can contain a variety of levels. Within each price rule, each level is defined by its effective date range and
allowed quantity, and whether it is based on the item's cost, price, or an amount specified as an override.

mnDiscountFactor DSPR MATH_NUMERIC NONE NONE

The factor that the system applies to the unit price of an inventory item to determine the net price. The system retrieves this value from the
inventory pricing rules if you have assigned a rule to this item. The pricing rule setup determines if the system multiplies the unit price by this
value or adds to or deducts from the unit price.

mnCMLineNo XLIN MATH_NUMERIC NONE NONE

Line number.

szCMProgramID JPID char NONE NONE

The RPG program name defined in the Software Versions Repository Master file. The numbering system is illustrated below. T SS XXX
where T = Specific member ID number      where SS = System number (e.g., 01 = Address Book)      where XXX = Member type (e.g., P =
Program, R = Report, etc.) For further details on the numbering system, refer to the Technical Foundation Guide.

szCMVersion VERS char NONE 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.

mnSupplierNo VEND MATH_NUMERIC NONE NONE

The address book number of the preferred provider of this item.

szRelatedKitItemNo RLIT char NONE NONE

If an individual item of inventory is sold as a component of a kit or assembly (single level bill-of-materials), the item number of that kit is the
'related'item number.

mnKitMasterLineNo KTLN MATH_NUMERIC NONE NONE

This line number indicates the relative sequence in which a component is added to a kit or single level bill of materials. For example, the
system automatically assigns a whole number to the kit master line, for example, 1.0000. Each component line is assigned a consecutive
subset of that line number, for example, the first component has line 1.010, and the second component has 1.020.

mnComponentLineNo CPNT MATH_NUMERIC NONE NONE

A number that indicates the sequence of the components on a bill of material. It initially indicates the relative sequence in which a
component was added to a kit or single level bill of material. You can modify this number to change the sequence in which the components appear on
the bill of material. Skip To fields allow you to enter a component line number that you want to begin the display of information.

mnRelatedKitComponent RKIT MATH_NUMERIC NONE NONE

In the Sales Order Processing System, when a kit component is defined in the Bill of Materials Master (F3002) as a second level or higher
item, it will be grouped and stored in the Sales Order Detail File (F4211) under a related kit component. This relationship is maintained so that
the system can perform kit balancing on the kit throughout the order processing cycle. For example, if a kit has the following structure in the
Bill of Materials:        Level 0 - A        Level 1 - B, C, D        Level 2 - B1, B2, D1, D2, D3                 Level 3 - B11, B12   Components B1, B2, B11, and
B12 will be grouped under Related Item B.

mnNoOfCpntPerParent KTP MATH_NUMERIC NONE NONE

The total number of the current component needed per unit of the parent kit.

cOverridePrice PROV char NONE NONE

A value established by the sales order entry program whenever a unit or extended price is entered into an order line item, overriding the
price calculated by the program.

cOverrideCost CSTO char NONE NONE

A code that specifies whether the change order is a terms only change. For those organizations that elect to view subcontracts on a
detailed line item basis, terms only changes are in most cases those that have a non-dollar effect, such as a schedule change. For those
organizations that elect to view their contracts on a summary job cost coding basis, all changes are automatically classified for processing purposes
as terms only changes. In this case the base contract is automatically incremented for each change order and the individual change order
amount is carried for informational purposes only. All change orders created in processing mode 3 (account method -incremental), are terms
only changes. Most inquiry screens and reports exclude terms only items.

szUserID USER char NONE NONE

The code that identifies a user profile.

jdDateUpdated UPMJ JDEDATE NONE NONE

The date that specifies the last update to the file record.

mnWKOrderTotal OTOT MATH_NUMERIC NONE NONE

The total value of all lines on the order that have not been shipped and billed to the customer.

mnWKForeignOrderTotal FAP MATH_NUMERIC NONE NONE

The unpaid foreign amount of a transaction.

mnWKTotalCost TOTC MATH_NUMERIC NONE NONE

mnWKForeignTotalCost FCST MATH_NUMERIC NONE NONE

cWKProcessingType EV05 char NONE NONE

Special Input Expected
EV05ab WK-Processing Mode

Significant Data Values
' ' = Regular Order
'1' = Copy Orderab

^

cWKSourceOfData EV06 char OPT NONE

This parameter will determine where to retrieve the source of data.

Significant Data Values
' ' = Input Parameters
'1' = F4201 and F4211
'2' = F4201/F42019 and F42119
'3' = F4001Z and F4011Z
'4' = F47011 and F47012
'5' = F42UI01 and F42UI11
ab

^

cWKCheckAvailability EV07 char NONE NONE

Special Input Expected
EV07ab WK-Check Availability

Significant Data Values
'1' - check availability of item.
' ' - Bypass availability checking.
^

mnLastLineNoAssigned LNIX MATH_NUMERIC NONE NONE

cStockingType STKT char NONE NONE

A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking
types are hard-coded and you should not change them:    0   Phantom item    B Bulk floor stock    C Configured item    E Emergency/corrective
maintenance    F Feature    K Kit parent item    N Nonstock The first character of Description 2 in the user defined code table indicates if the item
is purchased (P) or manufactured (M).

szOriginalOrderKeyCo OKCO char NONE NONE

A number that is used in conjunction with the values in the ODOC and ODCT fields to identify a transaction.

szOriginalOrderNo OORN char NONE NONE

The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, and so on Matching document
numbers are also used to identify related documents in the Accounts Receivable and Accounts Payable systems. The document number
(DOC) is always the original document number. The matching document number (DOCM) is the check, adjustment, or credit to be applied
against the original document.

szOriginalOrderType OCTO char NONE NONE

This code defines the order type. It is verified in user defined codes (40/OT). Reserved document types have been defined for voucher
entry, invoice entry, receipts entry, and time sheet entry.  Because the offsetting entries for document types are created automatically during the
post program, they will not be self-balancing on original entry. The reserved document types are:    PR Purchase Requisition Orders    PQ
Purchase Quote    PO Purchase Order    PD Purchase Order - Direct Ship    PB Purchase Order - Blanket    SQ Sales Quote    SO Sales Order
SD Sales Order - Direct Ship    SB Sales Order - Blanket

mnOriginalOrderLineNo OGNO MATH_NUMERIC NONE NONE

A number identifying which line on the original order that the current line matches.

cParentItmMethdOfPriceCalcn PMTH char NONE NONE

A code that determines how the system calculates the price for kit items or configured items. Valid values are: Blank Use for items that are
neither kit items nor configured items. 1 The system accumulates the base prices of components with the configured price adjustments, and
then discounts the total. 2 The system accumulates the base price of the parent item with the configured price adjustments, and then discounts
the total. 3 The system accumulates the configured price adjustments, and then discounts the total. 4 The system accumulates the individually
discounted price of the components with the configured price adjustments. Note: Configured price adjustments are only included in the
calculation for a configured item. Also, the system only discounts costs if you are using the Advanced Pricing system. The following is an example of
how the system uses the various methods: Parent Item: 125 Component A: 50 Component B: 100 Configured Cost Adjustment 1: 15 Configured
Cost Adjustment 2: 10 Advanced Price Discount: 10% Methods: 1: 50 + 100 = 150 + 15 + 10 = 175 - 17.50 = 157.5 2: 125 + 15 + 10 = 150 - 15 = 135 3:
15 + 10 + 25 - 2.5 = 22.5 4: (50 - 5) + (100 - 10) = 135 + 15 + 10 = 160

szLandedCost PRP5 char NONE NONE

A user defined code (41/P5) that indicates the landed cost rule for an item. The landed cost rule determines purchasing costs that exceed
the actual price of an item, such as broker fees or commissions. You set up landed cost rules on the Landed Cost Revisions form.

mnWKSuppressProcess MATH01 MATH_NUMERIC NONE NONE

Special Input Expected
MATH01ab WK-Suppress Processing

Special Output Returned
MATH01ab WK-Suppress Processing

Significant Data Values
Specify the processes to be suppressed by passing in the number assigned to the option.
In order to specify a combination, add the number assigned to the option together and send in the
result.
Options:
0 = Default
1 = Writing Records When Warnings
2 = Retrieve Processing Options
4 = Production Allocation Warning
8 = Advanced Pricing Server
16 = Inv. Commitments - Was850Called
32 = Inv. Commitments - ChangesMadeToQty
64 =

^

mnShortItemNo 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

mnWKRelatedOrderProcess MATH02 MATH_NUMERIC NONE NONE

- - - Good Performance High Value.

mnSODLineNo EDLN MATH_NUMERIC NONE NONE

This is the line number you assign when originating an EDI transaction. This number can represent an order line number (applicable for any
order type), an invoice pay item, a journal entry line number, and so on.

mnPriceAdjRevLevel AREV MATH_NUMERIC NONE NONE

This field maintains the current revision level of Advanced Pricing adjustments awarded within a sales order. Adjustments associated with
a revision level below the current level are considered obsolete.

szSalesOrderFlags ALPH char NONE NONE

Special Input Expected
ALPHab WK Sales Order Flags

Special Output Returned
ALPHab WK Sales Order Flags

^

mnSODDocNo EDOC MATH_NUMERIC NONE NONE

The document number that is assigned by the transmitter in an EDI transaction. In a non EDI environment, this would be consistent with the
order number assigned at order entry time (DOCO).

szSODDocType EDCT char NONE NONE

The document type that is assigned by the transmitter in an EDI transaction. In a non EDI environment, this would be consistent with the order
type (DCTO) assigned at order entry time, an invoice document type, a voucher document type, and so on.

szSODOrderCo EKCO char NONE NONE

Company - Key (EDI - Document Key Co)

szTransferOrderToBranch TMCU char NONE NONE

mnDomesticDetachedAdj DETD MATH_NUMERIC NONE NONE

The total sum of Detached Adjustments which relate to a Sales Order Detail line. This amount is expressed in the domestic currency.

mnForeignDetachedAdj DETF MATH_NUMERIC NONE NONE

The total sum of Detached Adjustments which relate to a Sales Order Detail line. This amount is expressed in the foreign currency.

mnSODWFLineNo DOC MATH_NUMERIC NONE 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.

szGeneric2CharString DCT char NONE 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

mnTOEPOExchangeRate CRRD MATH_NUMERIC NONE NONE

A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in
this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.

szTOEPOCurrencyCode CRCE char NONE NONE

mnDRPKeyId UKID MATH_NUMERIC NONE NONE

Special Input Expected
UKIDab DRP Key ID
^

mnSoldToCust AN8 MATH_NUMERIC NONE NONE

Special Input Expected
AN8ab Sold  To Customer

Significant Data Values
Required when Process Edits = 2
^

szF4201BranchPlant EMCU char NONE NONE

A business unit is an accounting entity required for management reporting. It can be a profit center, department, warehouse location, job,
project, work center, branch/plant, and so forth. This business unit is from the business unit entered on the header of a sales/purchase order for
reporting purposes. This data is always right justified on entry (for example, CO123 would appear as _______CO123).  A security mechanism
has been provided to inhibit users from entering or locating business units outside the scope of their authority.

szSoldToCurrencyCode CRCD char NONE NONE

A code that identifies the currency of a transaction.

cConsolidationFlag EV08 char NONE NONE

Special Input Expected
EV08ab Consolidation Flag

Significant Data Values
' ' - No consolidation
'1' - Consolidate by CTID, AN8, F4201 MCU, CRCD
'2' - Consolidate by CTID, AN8, F4201 MCU, CRCD, SHAN
^

jdPriceEffectiveDate PEFJ JDEDATE NONE NONE

The system uses the Price Effective Date to determine the base price and all advanced price adjustments.  The value loaded in this date
is stored in the System Constants File (F4009).

mnWOWFLineNo LNIX MATH_NUMERIC NONE NONE

mnLineNoIncrement LINN 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 a system-assigned number.

mnParentWFLineNo SLNE MATH_NUMERIC NONE NONE

cStatusInWarehouse SWMS char NONE NONE

This flag can contain the following values:    blank Sales Order line which has not entered warehousing.    I Sales Order line inside the
warehousing system.  These lines cannot be modified.    O Sales Order line which entered and exited the warehousing system.

cBypassCommitments EV09 char NONE NONE

Special Input Expected
EV09ab Bypass Commitments

Significant Data Values
If set to '1', no commitment processing is done.
^

szProductSource PSR char OPT NONE

A value that identifies the location that supplies the item to fulfill the agreement. The value must match the Source Type code, as follows:     o
If the source type is AB, the transaction source must be an address book number in the Address Book Master table (F0101).     o If the
source type is CC, the transaction source must be a business unit in the Business Unit Master table (F0006).     o If the source type *A, the
transaction source must be *ANY.

szProductSourceType PSRY char OPT NONE

A code that specifies the type of source entered in the Transaction Source field, as follows:     o If the transaction source is an address book
number in the Address Book Master table (F0101), the source type must be AB.     o If the transaction source is a business unit in the Business
Unit Master table (F0006), the source type must be CC.     o If the transaction source is *ANY, the source type must be *A.

mnSequenceNumber SEQ MATH_NUMERIC OPT NONE

A number that specifies the sequence of information.

szAgreementNumber 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.

mnAgreementSupplement 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.

mnAgreementsFound AFND MATH_NUMERIC OPT NONE

szModeOfTransport MOT char OPT NONE

A user defined code (00/TM) that describes the nature of the carrier being used to transport goods to the customer. For example, by rail, by
road, and so on.

szDutyStatus DTYS char OPT NONE

A user defined code (system 40, type DS) identifying the duty status of an order line. You should only specify this value for duty reporting.
The system supplies a default value based on the End Use preference. You can override this value at order entry.

szLineofBusiness LOB char OPT NONE

A user defined code (system 40, type LB) identifying a customer's line of business.

jdPromisedShip LOAD JDEDATE OPT NONE

The date that the product from an order line is loaded onto a vehicle for delivery.

szEndUse EUSE char OPT NONE

User defined code (system 40, type EU) identifying the end use of an order line and used for duty reporting only. The system supplies a
default value based on the End Use preference. You may override this value at order entry.

szPriceCode1 UPC1 char OPT NONE

User defined code (system 40, type P1) you can use to control pricing adjustments. You can associate this code with a preference
profile. When you specify a price code 1 in the preference, it fills or overrides this field in the sales order detail.

szPriceCode2 UPC2 char OPT NONE

User defined code (system 40, type P2) you can use to control pricing adjustments. You can associate this code with a preference
profile. When you specify a price code 2, the system fills this field in the sales order detail.

szPriceCode3 UPC3 char OPT NONE

User defined code (system 40, type P3) you can use to control pricing adjustments. You can associate this code with a preference
profile. Price code 3 is not visible on the sales order, but the system includes it in the detail file.

szItemFlashMessage IFLA char OPT NONE

User defined code system 40, type FL, which is used to flash a warning message about a particular item.

szCompanyKeyRelated RKCO char OPT NONE

The key company that is associated with the document number of the related order.

szRelatedPoSoNumber RORN char OPT NONE

A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
informational purposes only.

szRelatedOrderType RCTO char OPT NONE

A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase
order might be document type OP and might have been created to fill a related work order with document type WO.

mnRelatedPoSoLineNo RLLN MATH_NUMERIC OPT NONE

A number of the detail line on the related order for which the current order was created. For example, on a purchase order created to fill
open sales orders, this is the line number of the sales order on which the item you are ordering appears.

cGenericChar3 EV02 char OPT NONE

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

mnProfitMargin PRMG MATH_NUMERIC OPT NONE

This value indicates the profit margin percentage for the order detail line. This is calculated by ((Price - Cost) / Price) * 100.

mnQuantityAvailable QAVAL MATH_NUMERIC OPT NONE

A number that indicates the quantity that is available. For example, the available quantity might consist of the on-hand quantity minus
commitments, reservations, and backorders. Availability is user defined. You can set up availability in the Branch/Plant Constants program (P41001).

cRequestScheduleFlag SO13 char OPT NONE

This flag is used by select Euro conversion programs to designate processed records.

cOrderProcessType EV05 char OPT NONE

A flag that indicates whether automatic spell check is turned on.

cGenericChar2 EV10 char OPT NONE

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

mnSODRelatedJobNumber MATH10 MATH_NUMERIC OPT NONE

Event point for Math Numeric.

szGenericString DL01 char OPT NONE

A user defined name or remark.

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.

szGenericString2_DL02 DL02 char OPT NONE

Additional text that further describes or clarifies a field in the system.

mnGenericMathNumeric1_MATH01 MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnGenericMathNumeric2_MATH02 MATH02 MATH_NUMERIC OPT NONE

- - - Good Performance High Value.

mnItemVolume_ITVL ITVL MATH_NUMERIC OPT NONE

The cubic units occupied by one inventory item. The definition of the unit itself (cubic feet, yards, meters, and so on) is defined in the volume
unit of measure.

szVolumeUOM_VLUM VLUM char OPT NONE

The unit of measure for the cubic space occupied by an inventory item. Typical volume unit of measures are:    ML Milliliter    OZ Fluid Ounce
PT Pint    LT Liter    CF Cubic Foot    CM Cubic Meter    CY Cubic Yard

szRevenueBusinessUnit EMCU char OPT NONE

A business unit is an accounting entity required for management reporting. It can be a profit center, department, warehouse location, job,
project, work center, branch/plant, and so forth. This business unit is from the business unit entered on the header of a sales/purchase order for
reporting purposes. This data is always right justified on entry (for example, CO123 would appear as _______CO123).  A security mechanism
has been provided to inhibit users from entering or locating business units outside the scope of their authority.

szCustomerPO_VR01 VR01 char OPT NONE

An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier
number, or job number.

szReference2Vendor_VR02 VR02 char OPT NONE

A field available to record reference numbers, such as the supplier's bid document number, quote document, sales order, work order, or
job number.

mnProcessID PEID MATH_NUMERIC OPT NONE

A code that identifies the Inter-Process Communication ID.

mnTransactionID TCID MATH_NUMERIC OPT NONE

cPaymentTermsOverride PMTO char OPT NONE

An option that indicates that the payment terms were manually entered or changed. Preferences do not override manually entered payment
terms.

cBasedonDate DTBS char OPT NONE

A code that determines how the system updated the Price Effective Date field in various Sales Order Management tables. You can enter
the code manually or the system can apply a preference. Valid values are: Blank No override or preference 0 Transaction or order
date 1 Requested date 2 Promised ship date 3 Original ship date 4 Actual ship date 5 System date 6 Invoice date 7 Preferred date O Override date

mnRequestedDeliveryTime DRQT MATH_NUMERIC OPT NONE

The time requested for delivery. 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.

szReleaseNumber RLNU char OPT NONE

A number that identifies the release for an individual customer.

mnPromisedPickTime PDTT MATH_NUMERIC OPT NONE

The time when the order is scheduled to be picked. Enter the time in the 24-hour format and include a leading zero if necessary. For
example, enter 6:00 a.m. by typing 060000 and enter 7:00 p.m. by typing 190000.

mnTimeOriginalPromised OPTT MATH_NUMERIC OPT NONE

The time that an order was originally promised to be delivered. Enter the time using the 24-hour time format (HHMMSS) and include a
leading zero if necessary. For example, to enter 6:00 a.m., type 060000. To enter 7:00 p.m., type 190000.

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.

mnScheduledShipmnentTime PMDT MATH_NUMERIC OPT NONE

The scheduled time of a 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.

mnTimeFuture2 PSTM MATH_NUMERIC OPT NONE

Future use.

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.

szBuyingSegmentCode BSC char OPT NONE

A value that groups customers with similar buying habits.

mnBatchQtyInBOM BQTY MATH_NUMERIC OPT NONE

The quantity of finished units that you expect this bill of material or routing to produce. You can specify varying quantities of components
based on the amount of finished goods produced. For example, 1 ounce of solvent is required per unit up to 100 units of finished product.
However, if 200 units of finished product is produced, 2 ounces of solvent are required per finished unit. In this example, you would set up batch
quantities for 100 and 200 units of finished product, specifying the proper amount of solvent per unit.

szSOEMBFInternalFlags SOEF char OPT NONE

This field is broken down into 30 different flags which are passed in and out of the sales order entry MBF - F4211 Begin Doc, F4211 Pre
Processor, F4211 Edit Line, and F4211 End Doc.

mnDualQuantity 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.

szDualUOM UOM2 char OPT NONE

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

mnMatrixControlLineNo MCLN MATH_NUMERIC OPT NONE

A number that the system uses to group line numbers on a purchase order or sales order for use in a matrix. Although the number is
generated automatically, you can override it.

szPromotionID PMTN char OPT NONE

An identification number that tracks revenue, costs, and expenses for each promotion.

mnProjectNumber PRJM MATH_NUMERIC OPT NONE

A number that identifies an EPM project in the system. The project must be set up in the Add/Revise Project program (P31P011).

mnOverrideForeignBasePrice OVFBPRC MATH_NUMERIC OPT NONE

The foreign base price that the system calculates when no base price exists in the Item Base Price File table (F4106). The system
calculates this value when all of the following conditions apply:   o  The base price for the item in the Item Base Price File table is zero.   o  The first
adjustment is an override adjustment.   o  The currency mode is foreign (F).

mnOverrideBasePrice OVBPRC MATH_NUMERIC OPT NONE

The foreign base price that the system calculates when no base price exists in the Item Base Price File table (F4106). The system
calculates this value when all of the following conditions apply:   o  The base price for the item in the Item Base Price File table is zero.   o  The first
adjustment is an override adjustment.   o  The currency mode is foreign (F).

mnListPrice LPRC MATH_NUMERIC OPT 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.

mnForeignListPrice FPRC MATH_NUMERIC OPT 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 stored in the customer's currency.

mnTotalQuantityFG MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

cCrossDockFlagYN XDCK char OPT NONE

A code that associates items or order lines with cross-dock processing. This code might indicate whether an item or an order line is eligible
for cross-docking, whether it was cross-docked, or whether it needs to be cross-docked. When it is assigned to an item or item-branch, this
code indicates that the item or the item in the branch/plant is eligible for cross-docking. When it is assigned to an order line, this code
indicates that the order line needs to be cross docked. Valid values are: 1 Yes, cross-docking is on 0 (blank) No, cross-docking is off

mnAddressNumberDeliveredTo DVAN MATH_NUMERIC OPT NONE

The address number of the person who receives the goods ordered. The delivered to address might differ from the ship to address when
ordered goods are processed through a distribution center (which is the delivered to address) before reaching their final destination (the ship
to address).

szListPriceUoM APUM char OPT NONE

The basic measurement abbreviation used to designate the quantity of an inventory item. Examples are:    BA bale     LB - pound    BG bag
MB - per thousand pieces    BU bundle     MF - per thousand feet    BX box MW - per thousand weight      CB - per hundred pieces    PC piece
CF - per hundred feet     PR - pair Although entry of cost and price per primary unit of measure is the accepted standard, the user may choose
to enter cost and price per any of the five basic units of measure available.  If that happens, that unit of measure is recorded separately so
that all subsequent costing and pricing algorithms will be performed properly.

mnDescTaskOrderNumber 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.

szDescTaskOrderType 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

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.

mnAmountPOCost ECST MATH_NUMERIC OPT NONE

For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
number of units.

mnTransferCost ECST MATH_NUMERIC OPT NONE

For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
number of units.

mnPromisedDeliveryTime RSDT MATH_NUMERIC OPT NONE

The promised time for a delivery. 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.

szShipToAttention SPATTN char OPT NONE

Attention field for shipping specifications.

mnShipToCusContactLineNumID SHCCIDLN MATH_NUMERIC OPT NONE

Ship To Customer contact line number.

szCatalogName CATNM char OPT NONE

This field contains the name of a Product Catalog.

szOPDetailErrorMsgId OWERROR char OPT NONE

A code that specifies an EnterpriseOne error.

szShipToContactAlphaName ALPH char OPT NONE

The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.

cReturnedFromOP EV01 char OPT NONE

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

szOrganizationTypeStructur OSTP char OPT NONE

A user defined code (01/TS) that identifies a type of organizational structure that has its own hierarchy in the Address Book system (for
example, e-mail). When you create a parent/child relationship for the Accounts Receivable system, the structure type must be blank.

mnUniqueKeyIDInternal_2 UKID MATH_NUMERIC OPT NONE

This field is a unique number used to identify a record in a file.

mnOpportunityId OPPID MATH_NUMERIC OPT NONE

A unique identifier related to the Opportunity.

mnPartnerAddressNumber PRAN8 MATH_NUMERIC OPT NONE

The address number (F0101) of the partner associated with the lead.

mnPartnerContactLineNumID PRCIDLN MATH_NUMERIC OPT NONE

The line number identifier from the Who's Who (F0111) representative of Contacts for a Partner.

Related Functions

B0000021 Format Subledger

B0000027 CurrencyConvForAndDom

B0000033 Get Exchange Rate

B0000128 Retrieve Company Currency Code

B0000130 Retrieve Company From Business Unit

B0100002 A/B - Get Parent Address

B0100024 Convert Transaction Amt to Customer Ccy & Upd F0301

B3201150 F4801 Update WO Status During SO Change Mode

B3800080 Agreement Cache For Sales Order

B4000150 Get Branch Constants

B4000260 Line Type - Activity Rules

B4000310 Location Information

B4000360 Check Location Master

B4000370 Get Default Branch

B4000450 Convert Short Item To Long Item

B4000520 Get Item UoM Conversion Factor

B4000530 Get Distribution Constants

B4000590 Verify Line Type

B4000610 Get Lot Master By Lot Number

B4000670 Get Item Units Of Measure

B4000790 Verify Date2 After Date1

B4000800 Edit Document Type Not Blank

B4000870 Standard Pricing Adjustments

B4000880 Verify And Get Address Book for OP

B4000950 Return the Item Stocking Type

B4000960 Verify Override Next Status Code

B4001100 Write Hold Code

B4002000 Compute Unit Or Extended Amount

B4002020 Purge Held Order Records

B4002060 Preference Get Values For Sales Order

B4002300 Preference Allocations

B4100205 Get Item Master Price Info

B4100210 Check Item Branch

B4101220 Calculate Availability

B4200030 F4201 Get Order No. From Next Number

B4200050 F42004 Verify Commission Code

B4200070 Get Sales Base Price

B4200080 Convert Domestic And Foreign Amount

B4200090 Verify Tax Explanation Code

B4200100 Get Sold To Billing Instructions

B4200110 Verify Xchg Rate Against Tolerance

B4200120 F4008 Verify Tax Area

B4200130 Verify Customer PO Number Is Unique

B4200140 Get Ship To Billing Instructions

B4200150 Verify Sales Order Before Update

B4200160 Get Freight Rate Code From F4020

B4200210 Get F4211 Detail Information

B4200230 F4074 Maintain Price History

B4200270 Check Item Restrictions

B4200280 Calculate Commitment Date

B4200290 Margin Check Processing

B4200311 Sales Order Entry Master Business Function

B4200340 Verify And Get Sales Header

B4200370 Commit Sales Order To Inventory

B4200420 Credit Check Processing

B4200450 Advanced Sales Order Detail Line Split

B4200490 Relieve SO Blanket Order Qty

B4200690 Copy SO Info To Work Files

B4200710 CalculateTransferCost

B4200760 Add Order to Subsystem Queue

B4200780 F42UI130 Get/Update Commitment Work File

B4200830 Retrieve Interbranch Order Types

B4200850 Preference Calculate Commitments

B4201210 Serial Number Processing Edits

B4201270 F49211 Maintain Sales Detail Table

B4201280 F42UI12 Get Sales Order Detail Info

B4301250 F4311Z Update Related Order Info

B4500050 F4072 Calculate Price Adjustments

B4500090 F4074 Price Adjustment Ledger Server

B4500200 F4573 Get Next Free Good

B4600130 Cache, Warehouse Components

B4700070 EDI - Convert EDI Text To Generic Text

B7600720 Retrieve Cache Information from Sales Header - Brazil - 42B

B7600730 Retrieve Cache Information from Sales Detail - Brazil - 42B

B7600750 Write Cache Information Sales Detail - Brazil - 42B

B7600790 Write Cache to Sales Detail File - Brazil - 42B

B9800100 Get Audit Information

B9800420 Get Data Dictionary Definition

B9900410 Get Environment Value

N3200700 Write Configurator Files at End Doc

N3201130 Duplicate Configurator Information

N3800040 F38012 Agreement Transaction Server

N3800050 F38010 Agreement Search

N4002510 Verify Original Blanket Order Before Update

N4200870 Increment Sales Detail Line Number

N4201010 Determine If Blanket SO Exists

N4301750 Add Matching F4006 Record

N4600030 Warehouse Management Request Transactions

N4600320 F40203 Validate AWM Override Status

N4700130 EDI Update Inbound Detail As Processed

N4900010 F4215 Add Shipment Detail

N4900180 Process Order Line

N7000320 B4200310 - Plug & Play - 42B

R42997 Inventory Commitment

X0005 Get User Defined Codes

X0903 Fiscal Date Edits +

X0909 Validate Subledger

X4101 Validate and Retrieve Item Master

XF41021 Update F41021 Locations

XF4105 Item Cost I/O

XT4311Z1 Purchase Order Entry

Related Tables

F4201 Sales Order Header File

F4211 Sales Order Detail File

F42UI01 SO Header Cache File (MBF)

F42UI11 SO Detail Cache File (MBF)

F42UI130 Commitment Work File

F4573 Free Goods Reference File

F4211FSEditLinePreProcess
F4211FSEditLinePreProcess

Sales Order Entry Master Business Function

Master Business Function

Object Name: B4200310

Parent DLL: CSALES

Location: Client/Server

Language: C

Functional Description

Purpose
This business function will perform data dictionary validations on any non-Null values passed into it
and if there are no errors it will load the values into an F42UI12 record and stored in the F42UI12
cache for retrieval in F4211FSEditLine.

Setup Notes and Prerequisites
None

Special Logic
None.

Technical Specification

2.1 Data Structure
NameData Dictionary Item

szComputerIDCTID
mnJobNo                       JOBS
mnWFLineNo                    LNIX
szKeyCo                    KCOO
mnOrderNo                     DOCO
szOrderType                DCTO
mnLineNo                      LNID
szOrderSuffix             DFXO
szOriginalKeyCo            OKCO
szOriginalOrderNo             OORN
szOriginalOrderType           OCTO
mnOriginalLineNo              OGNO
jdOriginalPromisedDate        OPDJ
jdPromisedPickDate            PPDJ
szReference2Vendor        VR02
szThruGrade                THGP
mnThruPotency                 THRP
szFromGrade                FRGD
mnFromPotency                 FRMP
szSalesReportingCode1      SRP1
szSalesReportingCode2      SRP2
szSalesReportingCode3      SRP3
szSalesReportingCode4     SRP4
szSalesReportingCode5      SRP5
szPurchasingReportCode1    PRP1
szPurchasingReportCode2    PRP2
szPurchasingReportCode3    PRP3
szPurchasingReportCode4    PRP4
szPurchasingReportCode5    PRP5
szPaymentTerms            PTC
cBasedonDate                  DTBS
mnDiscountTrade               TRDC
szPricingCategory          PRGR
mnDiscountCash              CADC
szCompanyKeyKCO
mnInvoiceNo                   DOC
szDocumentType             DCT
szPromationNoPRMO
mnDraftNo                    DFTN
szTaxArea                TXA1
szTaxExplanationCodeEXR1
cPriorityProcessing           PRIO
cBackordersAllowedYN          BACK
cSubstitutesAllowedYN         SBAL
szCommodityCode           CDCD
szNatureOfTransactionNTR
mnBuyerNumber                 ANBY
szConditionsOfTransportCOT
szRouteCode                ROUT
szStopCode                 STOP
szZoneNumber               ZON
cApplyFreightYN               AFT
szFreightHandlingCode      FRTH
cFreightCalculatedYN          FRTC
szShippingCommodityClassSHCM
szShippingConditionsCodeSHCN
szSerialNumberLotSERN
mnAmountUnitVolume            ITVL
szRepriceBasketPriceCatRPRC
szOrderRepriceCategoryORPR
szGlClassGLC
szLineStatusSTTS
mnSalespersonCommission1      SLCM
mnSalesperson1                SLSM
mnSalespersonCommission2     SLC2
mnSalesperson2                SLM2
cApplyCommissionYN            ACOM
szReasonCodeRCD
szUnitOfMeasureGrossWt     GWUM
szPurchasingCostCenterOMCU
szLedgerTypeLT
szSubledger                SBL
cSubledgerType                SBLT
szCodeLocationTaxStatLCOD
cWoOrderFreezeCode            UNCD
cCorrespondenceMethod         CRMD
szUserReservedCodeURCD
jdUserReservedDate            URDT
mnUserReservedAmount          URAT
mnUserReservedNumber          URAB
szUserReservedReferenceURRF
szVolumeUnitOfMeasure      VLUM
szRateCodeFrieghtMiscFRAT
jdDateInvoice                 IVD

2.2 Related Tables
Table Table Description

2.3 Related Business Functions
Source NameFunction Name
B4201280.CF42UI12 Get Sales Order Info from Cache

2.4 Processing

1.Do Data Dictionary validations on input parameters that are not Null.

2.If there are not any errors, load the F42UI12 cache record with the parameters and add it to the
F42UI12 cache. (See B4201280.h for the F42UI12 cache structure).

3. If the cache add failed, attempt to fetch the record from the cache and update       it with the
new information

Data Structure

D4200310J - F4211 FS Edit Line PreProcess

Parameter Name Data Item Data Type Req/Opt I/O/Both

szComputerID CTID char REQ NONE

The Computer ID where the order is being processed. This parameter together with Job Number comprises
the unique composite keys used to write or update the F42UI12 caches.
^

mnJobNo JOBS MATH_NUMERIC REQ NONE

The Job Number parameter is used by the program as a unique key field to update and write records
from the F42UI12 cache.  When this parameter is passed with a zero the program will generate the next
available Job Number. The unique Job Number generated will ensure that the program will only process the
records entered for the current job.
^

mnWFLineNo LNIX MATH_NUMERIC REQ NONE

The unique line number that will be used to write and update the record from the F42UI12 cache.
^

szKeyCo 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.

mnOrderNo 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

mnLineNo LNID MATH_NUMERIC NONE NONE

jdOriginalPromisedDate OPDJ JDEDATE NONE NONE

The original promised delivery date for a purchase order.

jdPromisedPickDate PPDJ JDEDATE NONE NONE

The promised shipment date for a sales order. This date represents the day that the item can be shipped from the warehouse.

szThruGrade THGD char NONE NONE

A user defined code (40/LG) that indicates the maximum grade that is acceptable for an item. The system displays a warning message if
you try to purchase or issue items with grades that exceed the maximum grade acceptable. The system does not allow you to sell items with
grades that exceed the maximum grade acceptable.

mnThruPotency THRP MATH_NUMERIC NONE NONE

A number that indicates the maximum potency or percentage of active ingredients that is acceptable for an item. The system displays a
warning message if you try to purchase or issue items that have a potency that exceeds the maximum potency acceptable. The system does
not allow you to sell items that have a potency that exceeds the maximum potency acceptable.

szFromGrade FRGD char NONE NONE

A user defined code (40/LG) that indicates the minimum grade that is acceptable for an item. The system displays a warning message if
you try to purchase or issue items with grades that do not meet the minimum grade acceptable. The system does not allow you to sell items
with grades that do not meet the minimum acceptable level.

mnFromPotency FRMP MATH_NUMERIC NONE NONE

A number that indicates the minimum potency or percentage of active ingredients acceptable for an item. The system displays a warning
message if you try to purchase or issue items that do not meet the minimum acceptable potency. The system does not allow you to sell items
that do not meet the minimum acceptable potency.

szSalesReportingCode1 SRP1 char NONE NONE

One of ten category codes for sales coding purposes. These codes can represent such classifications as color, material content, or use.

szSalesReportingCode2 SRP2 char NONE NONE

One of ten category codes for sales coding purposes. These codes can represent such classifications as color, material content, or
use. This field represents one of ten property type categories available for sales purposes.

szSalesReportingCode3 SRP3 char NONE NONE

One of ten category codes for sales coding purposes. These codes can represent such classifications as color, material content, or use.

szSalesReportingCode4 SRP4 char NONE NONE

One of ten category codes to be used for sales coding purposes. These codes can represent such classifications as color, material
content, or use.

szSalesReportingCode5 SRP5 char NONE NONE

One of ten category codes to be used for sales coding purposes.  These codes can represent such classifications as color, material
content, or use.

szPurchasingReportCode1 PRP1 char NONE NONE

A code (table 41/P1) that represents an item property type or classification,such as commodity type, planning family, or so forth. The
system uses this code to sort and process like items. This field is one of six classification categories available primarily for purchasing purposes.

szPurchasingReportCode2 PRP2 char NONE NONE

A code (table 41/P2) that represents an item property type or classification,such as commodity type, planning family, or so forth. The
system uses this code to sort and process like items. This field is one of six classification categories available primarily for purchasing purposes.

szPurchasingReportCode3 PRP3 char NONE NONE

A code (UDC table 41/P3) that represents an item property type or classification, such as commodity type, planning family, or so forth. The
system uses this code to sort and process like items. This field is one of six classification categories available primarily for purchasing
purposes.

szPurchasingReportCode4 PRP4 char NONE NONE

A user defined code (41/P4) that represents an item property type or classification, such as commodity type or planning family. The system
uses this code to sort and process like items. This field is one of six classification categories available primarily for purchasing purposes.

szPurchasingReportCode5 PRP5 char NONE NONE

A user defined code (41/P5) that indicates the landed cost rule for an item. The landed cost rule determines purchasing costs that exceed
the actual price of an item, such as broker fees or commissions. You set up landed cost rules on the Landed Cost Revisions form.

szPaymentTerms PTC char NONE NONE

A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions
form. Examples of payment terms include: Blank Net 15 001      1/10 net 30 002      2/10 net 30 003      Due on the 10th day of every month 006
Due upon receipt This code prints on customer invoices.

cBasedonDate DTBS char NONE NONE

A code that determines how the system updated the Price Effective Date field in various Sales Order Management tables. You can enter
the code manually or the system can apply a preference. Valid values are: Blank No override or preference 0 Transaction or order
date 1 Requested date 2 Promised ship date 3 Original ship date 4 Actual ship date 5 System date 6 Invoice date 7 Preferred date O Override date

mnDiscountTrade TRDC MATH_NUMERIC NONE NONE

Percentage by which the system reduces the price of each item. This is the only discount that will be applied. You can override it if you
enter a price. Enter the percentage as a whole number (that is, 5 for 5%).

szPricingCategory PRGR char NONE NONE

A user defined code (system 40/type PI) that identifies an inventory price group for an item. Inventory price groups have unique pricing
structures that direct the system to incorporate discounts or markups on items on sales and purchase orders. The discounts or markups are
based on the quantity, dollar amount, or weight of the item ordered. When you assign a price group to an item, the item takes on the same pricing
structure defined for the inventory price group. You must assign an inventory price group to the supplier or customer, as well as to the item, for
the system to interactively calculate discounts and markups on sales orders and purchase orders.

mnDiscountCash CADC MATH_NUMERIC NONE NONE

A discount which is passed forward from the manufacturer or mill to the customer based upon the payment terms of the supplier.  Enter 10
percent as 10.00.

szCompanyKey KCO char NONE 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.

mnInvoiceNo DOC MATH_NUMERIC NONE 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.

szDocumentType DCT char NONE 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

szTaxArea TXA1 char NONE NONE

A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax
and G/L distribution amounts when you create an invoice or voucher.

szTaxExplanationCode EXR1 char NONE NONE

A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
system uses the tax explanation code in conjunction with the tax rate area and tax rules to determine how the tax is calculated. Each
transaction pay item can be defined with a different tax explanation code.

cPriorityProcessing PRIO char NONE NONE

A code that tells the system to handle this customer's orders on a priority basis. Use this value to set up print pick slips so you can choose
to print them on a priority basis. This code is assigned from the Customer Billing Instructions. In addition, the backorder print report and
automatic batch release program can be sequenced by this code to release those orders with the highest priority first.

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.

cSubstitutesAllowedYN SBAL char NONE NONE

Code associated with each customer specifying whether that customer will accept substitute items.  Enter N to disallow or Y to allow
substitutions. The system will interpret a blank value as a Y.

szNatureOfTransaction NTR char NONE NONE

Defines whether the movement of goods is for sale, lease, and so on. For European Union VAT reporting, you can input the nature of
transaction codes using one of the user defined codes on the Sales Order Detail Revisions form or the Order Detail form (for Procurement). For
Procurement, use UDCs 41/P1 through 41/P5. For Sales, use UDC 40/S1 through 40/S5. The Intrastat Workfile Generation - Sales program
(R0018I1) and Intrastat Workfile Generation - Purchase program (R0018I2) update the information in the Intrastat Revision table (F0018T) if you
specify the UDC you are using (41/P1 through 41/P5 or 40/S1 through 40/S5) in the appropriate processing option on the generation program.
You can also enter the data directly in the Intrastat Workfile Revision program (P0018T). Note: To provide F1 help for the code you choose,
use UDC table 00/NT.

szRouteCode ROUT char NONE NONE

The route field is a user defined code (system 42, type RT) that represents the delivery route on which the customer resides. This field is
one of several factors used by the freight summary facility to calculate potential freight charges for an order. For picking, use the route code with
the stop and zone codes to group all of the items that are to be loaded onto a delivery vehicle for a specific route. You set up a default for
each of these fields on the Customer Billing Instruction form.

szStopCode STOP char NONE NONE

The stop code is a user defined code (system 42, type SP) that represents the stop on a delivery route. This field is one of several factors
used by the freight summary facility to calculate potential freight charges for an order. For picking, you can use the stop code with the route and
zone codes to group all items that are to be loaded onto a delivery vehicle for a specific route. You set up the default for each of these fields
on the Customer Billing Instructions form.

szZoneNumber ZON char NONE NONE

The zone field is a user defined code (system 40, type ZN) that represents the delivery area in which the customer resides. This field is one
of several factors used by freight summary facility to calculate potential freight charges for an order. For picking you can use the zone code
with the route and stop codes to group all item that are to be loaded onto a delivery vehicle for a specific route. You set up the default for each
of these fields on the Customer Billing Instructions form.

cApplyFreightYN AFT char NONE NONE

An option that specifies whether the system performs freight calculations during processing.  Valid values are: On The system performs
freight calculations during processing. Off The system does not perform freight calculations during processing.

szFreightHandlingCode FRTH char NONE NONE

A user defined code (42/FR) designating the method by which supplier shipments are delivered. For example, the supplier could deliver to
your dock, or you could pick up the shipment at the supplier's dock. You can also use these codes to indicate who has responsibility for
freight charges. For example, you can have a code indicating that the customer legally takes possession of goods as soon as they leave the
supplier warehouse and is responsible for transportation charges to the destination.

szShippingCommodityClass SHCM char NONE NONE

A user defined code (41/E) that represents an item property type or classification (for example, international shipment handling). The
system uses this code to sort and process similar items. This field is one of three classification categories available primarily for inventory and
shipping purposes.

szShippingConditionsCode SHCN char NONE NONE

A code (table 41/C) that represents an item property type or classification,such as special shipping conditions. The system uses this code
to sort and process like items. This field is one of three classification categories available primarily for inventory and shipping purposes.

szSerialNumberLot SERN char NONE NONE

A 30 character field to be used to additionally identify a specific lot of inventory; this may be the manufacturer's production run number or
some user assigned number.  The serial number may be added to this lot during the receiving process or at any time thereafter.  At present, this
field may be presented as smaller than 30 characters.

szRepriceBasketPriceCat RPRC char NONE NONE

You can assign items with common repricing characteristics to a reprice category on Item Branch/Plant Revisions. You can define different
categories based on location. Repricing is a technique that the system uses to:     o Accumulate items on order that belong to a common
repricing category during a batch program     o Compare the aggregate quantities of items on order to the appropriate quantity breaks in the
reprice category If the items qualify for an additional discount, that discount is reflected as a change in unit and extended price for each
qualifying item in the original order line.

szOrderRepriceCategory ORPR char NONE NONE

Items with common order repricing characteristics are assigned to an order reprice category on the Item Master Revisions screen.
Categories can be varied at the Location level (fold area). Order repricing is a technique in which items within an order that belong to the same
repricing category are accumulated during a batch program and their aggregate quantities are compared to the appropriate quantity "breaks" in
the reprice category. Typical quantity breaks in this situation might be the total weight or the total dollar value of the order as whole. If the
items qualify for additional discount, that discount is reflected as a flat dollar amount in a new discount line. This facility supplements the repricing
function and operates in the same batch program.

szGlClass GLC char NONE 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.

cApplyCommissionYN ACOM char NONE NONE

Used to indicate whether the sales value or gross margin earned in this order detail line should be included in the calculation of
commission for the salesperson(s) responsible for this order.

szReasonCode RCD char NONE NONE

A user defined code (42/RC) that explains the purpose for a transaction. For example, you can indicate the reason that you are returning
items.

szUnitOfMeasureGrossWt GWUM char NONE NONE

Gross weight unit of measure.

szSubledger SBL char NONE NONE

A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
address book number. If you enter a subledger, you must also specify the subledger type.

cSubledgerType SBLT char NONE NONE

A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded
or user defined. Valid values include: A Alphanumeric field, do not edit   N Numeric field, right justify and zero fill   C Alphanumeric field, right
justify and blank fill

szCodeLocationTaxStat LCOD char NONE NONE

A code (system 46/type LT) that indicates whether the location contains tax-paid inventory (in-bond vs. duty paid). If an item has an
assigned tax code, the system puts the item away only in locations with the same tax code. You assign tax codes to items through Item Profile
(P46010).

cWoOrderFreezeCode UNCD char NONE NONE

A code that indicates if the line on the order is frozen. MPS/MRP does not suggest changes to frozen orders.  Valid values are: Y Yes, freeze
the order. N No, do not freeze the order. This value is the default.

cCorrespondenceMethod 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.

szUserReservedCode URCD char NONE NONE

This is a 2 position code that is reserved for the user.  JDE does not currently use this field and will not utilize this field in the future.

jdUserReservedDate URDT JDEDATE NONE NONE

This is a 6 position code that is reserved for the user.  JDE does not currently use this field and will not utilize this field in the future.

mnUserReservedAmount URAT MATH_NUMERIC NONE NONE

This is a 15 position code that is reserved for the user.  JDE does not currently use this field and will not utilize this field in the future.

mnUserReservedNumber URAB MATH_NUMERIC NONE NONE

This is a 8 position code that is reserved for the user.  JDE does not currently use this field and will not utilize this field in the future.

szUserReservedReference URRF char NONE NONE

A 15-position reference that is reserved for the user.  J.D. Edwards does not currently use this field and does not plan to use it in the future.

szRateCodeFrieghtMisc FRAT char NONE NONE

The user defined code (system 41/type RT) for freight rate. This designates the amount that the customer is charged for postage, freight, or
other miscellaneous expenses for an order.

jdDateInvoice IVD JDEDATE OPT NONE

The date the invoice was printed. The system updates this date when you run the invoice print program in the Sales Order Management
system.

cUseWorkfile_WFOC WFOC char OPT NONE

This flag indicates whether a business function should use a memory cache or a work file to store, retrieve, or delete temporary records. A
work file is a table that stores temporary information. Valid values for this flag are:    blank Do not write to cache or work file    1       Use work file
2       Use cache

cGenericChar1_EV01 EV01 char OPT NONE

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

cGenericChar2_EV02 EV02 char OPT NONE

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

szGenericString1_DL01 DL01 char OPT NONE

A user defined name or remark.

szGenericSting2_DL02 DL02 char OPT NONE

Additional text that further describes or clarifies a field in the system.

mnGenericMathNumeric1_MATH01 MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnGenericMathNumeric2_MATH02 MATH02 MATH_NUMERIC OPT NONE

- - - Good Performance High Value.

cUseCacheOrWF_EV01 EV01 char OPT NONE

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

mnProcessID PEID MATH_NUMERIC OPT NONE

A code that identifies the Inter-Process Communication ID.

mnTransactionID TCID MATH_NUMERIC OPT NONE

cKitConfigWindowOpened FFU2 char OPT NONE

Future Use Flag.

mnShipmentNumber SHPN MATH_NUMERIC OPT NONE

A "next number" that uniquely identifies a shipment.

cCrossDockFlagYN XDCK char OPT NONE

A code that associates items or order lines with cross-dock processing. This code might indicate whether an item or an order line is eligible
for cross-docking, whether it was cross-docked, or whether it needs to be cross-docked. When it is assigned to an item or item-branch, this
code indicates that the item or the item in the branch/plant is eligible for cross-docking. When it is assigned to an order line, this code
indicates that the order line needs to be cross docked. Valid values are: 1 Yes, cross-docking is on 0 (blank) No, cross-docking is off

mnCrossDockingPriority XPTY MATH_NUMERIC OPT NONE

The priority that the cross-docking system follows when assigning supply quantity to the sales orders. This priority indicates the sequence
in which cross-docked sales orders are fulfilled for a given date. Sales order lines with a lower value receive a higher priority than lines with a
higher value. The system performs only numeric edits on this value. If you do not specify a priority, or if the same priority is given to more
than one order line, the orders will be fulfilled in the sequence of order number and order type.

mnCrossDockOrderNumber XORN MATH_NUMERIC OPT NONE

The number that identifies a cross dock supply order.

szCrossDockOrderType XCTO char OPT NONE

A code that identifies the type of order.

szCrossDockOrderCompany XKCO char OPT NONE

A code that identifies the company for a cross dock supply order.

szCrossDockOrderSuffix XSFX char OPT NONE

The code that indicates the suffix for a cross dock supply order.

mnCrossDockLineNumber XLLN MATH_NUMERIC OPT NONE

The number that identifies a line in a cross dock supply order.

szPullSignal PSIG char OPT NONE

Future use. A code that might represent a DON (Delivery Order Number), RAN (Release Accounting Number), or KANBAN number to
trigger replenishment of material. Some customers using pull-based manufacturing practices to signal line-side replenishment of material.

jdDateRelease RLDJ JDEDATE OPT NONE

A date that is received from a customer and used by the system in conjunction with the release time to identify a release.

mnTimeRelease RLTM MATH_NUMERIC OPT NONE

A time that is received from the customer. The system uses the release time with the release date to identify a release.

mnDemandUniqueKey DEID MATH_NUMERIC OPT NONE

A system-generated number that identifies a demand record.

mnBuyerNumber ANBY MATH_NUMERIC OPT NONE

The address book number that identifies who is responsible for setting up and maintaining the correct stocking levels for each inventory
item.

szSOEMBFInternalFlags SOEF char OPT NONE

This field is broken down into 30 different flags which are passed in and out of the sales order entry MBF - F4211 Begin Doc, F4211 Pre
Processor, F4211 Edit Line, and F4211 End Doc.

cOPPartialLineShipmentAllowed OPLL char OPT NONE

An option that specifies whether to allow partial shipments in order promising. This option works with the Allow Backorders option. Valid
values are: Y Split the sales order line item in order promising, deliver part of the requested inventory one day, and deliver the rest on another
day. N Order promising cannot split the sales order line item.

cOPBackorderAllowed OPBA char OPT NONE

An option that specifies, in order promising, whether a line item can be shipped later than the requested date, based on future availability.
This option works with the Partial Line Shipments option. Valid values are: Y If the Partial Line Shipments value is Y, the quantity that is
available on the requested date is shipped. The remaining quantity is shipped on the available date. If the Partial Line Shipments value is N, the
entire quantity is shipped on the date that it becomes available. N The available quantitity on the requested date is shipped.

cOPSubstituteAllowed OPSS char OPT NONE

An option that specifies whether to allow substitution for sales order line items in order promising. Valid values are: Y The product can be
substituted if it is unavailable. N The product cannot be substituted.

szOPMultiSourceGroup OPMG char OPT NONE

An option that specifies whether multisourcing is allowed for a line item in order promising. Valid values are: Y Allow order promising to
source the inventory for this line item from more than one branch/plant. N This line item can be sourced from only one branch/plant. Any other value
specifies that this line item is part of a sourcing group. All of the line items that belong to the same group are shipped from the same
branch/plant.

szOPShippingGroup OPSG char OPT NONE

An option that specifies whether a line item is part of a shipping group in order promising. All of the line items that belong to the same group
are shipped together on the same date.

cOPPromiseLineYN OPYN char OPT NONE

An option that specifies whether to include a line item with an order promising request.

cAPSFixSourceLocation FXSR char OPT NONE

Future use - APS A value that specifies the source location. In APS, the solver does not change the source location when this value is set to
Y.

cOPAllowMultiSource OPMS char OPT NONE

An option that specifies whether multisourcing is allowed in order promising. Valid values for the sales order header are: Y Allow order
promising to source different detail lines from different branch/plants. N All line items are sourced from the same branch/plant. Valid values for the
sales order detail are: Y Allow order promising to source the inventory for this line item from more than one branch/plant. N This line item can be
sourced from only one branch/plant.

cPaymentInstrument RYIN char OPT NONE

The user defined code (00/PY) that specifies how payments are made by the customer. For example: C Check   D Draft   T Electronic funds
transfer

Related Functions

B0000021 Format Subledger

B0000027 CurrencyConvForAndDom

B0000033 Get Exchange Rate

B0000128 Retrieve Company Currency Code

B0000130 Retrieve Company From Business Unit

B0100002 A/B - Get Parent Address

B0100024 Convert Transaction Amt to Customer Ccy & Upd F0301

B3201150 F4801 Update WO Status During SO Change Mode

B3800080 Agreement Cache For Sales Order

B4000150 Get Branch Constants

B4000260 Line Type - Activity Rules

B4000310 Location Information

B4000360 Check Location Master

B4000370 Get Default Branch

B4000450 Convert Short Item To Long Item

B4000520 Get Item UoM Conversion Factor

B4000530 Get Distribution Constants

B4000590 Verify Line Type

B4000610 Get Lot Master By Lot Number

B4000670 Get Item Units Of Measure

B4000790 Verify Date2 After Date1

B4000800 Edit Document Type Not Blank

B4000870 Standard Pricing Adjustments

B4000880 Verify And Get Address Book for OP

B4000950 Return the Item Stocking Type

B4000960 Verify Override Next Status Code

B4001100 Write Hold Code

B4002000 Compute Unit Or Extended Amount

B4002020 Purge Held Order Records

B4002060 Preference Get Values For Sales Order

B4002300 Preference Allocations

B4100205 Get Item Master Price Info

B4100210 Check Item Branch

B4101220 Calculate Availability

B4200030 F4201 Get Order No. From Next Number

B4200050 F42004 Verify Commission Code

B4200070 Get Sales Base Price

B4200080 Convert Domestic And Foreign Amount

B4200090 Verify Tax Explanation Code

B4200100 Get Sold To Billing Instructions

B4200110 Verify Xchg Rate Against Tolerance

B4200120 F4008 Verify Tax Area

B4200130 Verify Customer PO Number Is Unique

B4200140 Get Ship To Billing Instructions

B4200150 Verify Sales Order Before Update

B4200160 Get Freight Rate Code From F4020

B4200210 Get F4211 Detail Information

B4200230 F4074 Maintain Price History

B4200270 Check Item Restrictions

B4200280 Calculate Commitment Date

B4200290 Margin Check Processing

B4200311 Sales Order Entry Master Business Function

B4200340 Verify And Get Sales Header

B4200370 Commit Sales Order To Inventory

B4200420 Credit Check Processing

B4200450 Advanced Sales Order Detail Line Split

B4200490 Relieve SO Blanket Order Qty

B4200690 Copy SO Info To Work Files

B4200710 CalculateTransferCost

B4200760 Add Order to Subsystem Queue

B4200780 F42UI130 Get/Update Commitment Work File

B4200830 Retrieve Interbranch Order Types

B4200850 Preference Calculate Commitments

B4201210 Serial Number Processing Edits

B4201270 F49211 Maintain Sales Detail Table

B4201280 F42UI12 Get Sales Order Detail Info

B4301250 F4311Z Update Related Order Info

B4500050 F4072 Calculate Price Adjustments

B4500090 F4074 Price Adjustment Ledger Server

B4500200 F4573 Get Next Free Good

B4600130 Cache, Warehouse Components

B4700070 EDI - Convert EDI Text To Generic Text

B7600720 Retrieve Cache Information from Sales Header - Brazil - 42B

B7600730 Retrieve Cache Information from Sales Detail - Brazil - 42B

B7600750 Write Cache Information Sales Detail - Brazil - 42B

B7600790 Write Cache to Sales Detail File - Brazil - 42B

B9800100 Get Audit Information

B9800420 Get Data Dictionary Definition

B9900410 Get Environment Value

N3200700 Write Configurator Files at End Doc

N3201130 Duplicate Configurator Information

N3800040 F38012 Agreement Transaction Server

N3800050 F38010 Agreement Search

N4002510 Verify Original Blanket Order Before Update

N4200870 Increment Sales Detail Line Number

N4201010 Determine If Blanket SO Exists

N4301750 Add Matching F4006 Record

N4600030 Warehouse Management Request Transactions

N4600320 F40203 Validate AWM Override Status

N4700130 EDI Update Inbound Detail As Processed

N4900010 F4215 Add Shipment Detail

N4900180 Process Order Line

N7000320 B4200310 - Plug & Play - 42B

R42997 Inventory Commitment

X0005 Get User Defined Codes

X0903 Fiscal Date Edits +

X0909 Validate Subledger

X4101 Validate and Retrieve Item Master

XF41021 Update F41021 Locations

XF4105 Item Cost I/O

XT4311Z1 Purchase Order Entry

Related Tables

F4201 Sales Order Header File

F4211 Sales Order Detail File

F42UI01 SO Header Cache File (MBF)

F42UI11 SO Detail Cache File (MBF)

F42UI130 Commitment Work File

F4573 Free Goods Reference File

F4211FSEndDoc
F4211FSEndDoc

Sales Order Entry Master Business Function

Master Business Function

Object Name: B4200310

Parent DLL: CSALES

Location: Client/Server

Language: C

Functional Description

Purpose
Use this function to add, update, or delete records from the Sales Order Header and Detail tables
(F4201/F4211).  Prior to calling this function, you should have used the F4211BeginDocument and
F4211EditLine functions to edit the sales order transaction.  Therefore, the records in the work files (i.e.,
F42UI01 and F42UI11) should be valid before they are updated to the "live" tables.

Setup Notes and Prerequisites
• You must use this function in conjunction with the other SOE edit object modules.  Please refer to
the Edit Object document (Funsrv.doc) for more information about how and when to use this function.
• If entering a blanket or quote order, the order totals (OTOT and FAP) should be passed in with
zeros.
'b7'b7'b7'b7'b7'b7
Special Logic
None.

Technical Specification

2.1 Data Structure
NameData Dictionary Item
mnCMJobNo                  JOBS
mnSalesOrderNo             DOC
szCMComputerIDCTID
cCMErrorCondition          ERRC
szOrderTypeDCT
szKeyCompanyKCO
mnOrderTotal               OTOT
mnForeignOrderTotal        FAP
szBaseCurrencyCodeCRDC
szProgramIDJPID
szWorkstationIDJOBN
szCMProgramIDPID
szCMVersionVERS
mnTimeOfDay              TDAY
mnTotalCost  TOTC
mnForeignTotalCost    FCST
cSuppressRlvBlnktFlag      EV01
cWKSkipProcOptions   EV02
mnWKRelatedOrderProcess   EV03
cCMUseWorkFiles          EV04
mnEDIDocNo                EDOC
szEDIKeyCoEKCO
szEDIDocTypeEDCT
cCMProcessEdits            EV05
cGenericChar2EV10
mnGenericMathNumericMATH10

2.2Related Tables
Table Table Description
F42UI01Header Work File
F42UI11Detail Work File
F4201Sales Order Header
F4209Held Order Table
F4211Sales Order Detail

2.3Related Business Functions
Source NameFunction Name
B0100002A/B - Get Parent Address
B0100024Convert Trans To Cust Currency
B4000520GetItemUOMConversionFactor
B4001110Write Hold Code
B4200030F4201GetOrderNumberFromNextNumber
B4200260WriteSalesLedgerOrHistory
B4200290MarginCheckProcessing
B4200370CommitSalesOrderToInventory
B4200400Credit Check Processing
N4200870Increment Sales Order Line No.
B4201140ITLS Interface
B4201320Get ITLS Information
XT4311Z1Purchase Order Entry MBF
X4801Work Order Entry MBF
N4600030Warehouse Management Request Transactions
B4600130Cache, Warehouse Components
B4700070EDI Convert EDI Text To Generic Text
N4700130EDI Update Inbound Detail As Processed
N4900010F4215 Add Shipment Detail
N4900180Process Order Line
N7000320B4200310 - Plug & Play
B9800420Get Data Dictionary Definition
B9900410Get Environment Value

2.4Processing
This section describes detailed processing in structured English.  This includes any error messages
used.

1.Retrieve the Processing Options.
Other Quantity 1 or 2Warehouse Override Next Status
Use Preference ProcessR42520 Version
Order Margin CheckR42565 Version
Line Margin CheckR42997 Version
Minimum Order CheckDefault Line Increment
Maximum Order CheckCommitment Preference
Credit HoldTransfer Order Entry
P40400 VersionWarehouse Request Mode
P4310 VersionAuto Print or Commit
P4801 VersionAgreement Processing
Warehouse Pick VersionCopy Text Option

2. Call Get Environment Value (B9900410.C) to determine if the Transportation System is installed.
Data Item<="SY49"
Module Existence=>Work Field

3. Call Get Environment Value (B9900410.C) to determine if the Bulk System is installed.

Data Item<="SY41B"
Module Existence=>Work Field

Process Header Work File
// If processing a blanket or quote order, the order total should be set to zero.

If EV01-parm != ' ',
OTOT-parm = 0;
FAP-parm = 0;

1.Read records from header work File (F42UI01) by Computer ID (CTID) and Job Number (JOBS). If
the Job Number is not passed, orders were consolidated (done in Edit Line) and fetch record the by the
Computer ID only. Because there may be more than one record in F42UI01, all of the order processing
will be done in a loop that ends when there are no more records in F42UI01.

2.(Future) On a DEL, process "cancel" logic and skip to step 11.

3.If there is no Job No. and there is an Order Number (DOCO-hwf != 0), copy the Order Number-hwf
to the Order Number-parm. If there is no Job No. and no Order Number and the Action is "ADD", assign
next number to sales order. Use F4201GetOrderNumberFromNextNumber and assign 0 to a program work field,
Largest Line Number (math numeric 7).  If the order number is not zero, retrieve the largest line
number from F4211 using the DOCO-hwf, DCTO-hwf, and KCOO-hwf as the keys.

4.If hold code (SHHOLD) is not equal to blank or null, write the hold code record using Write
Hold Code (B4001110)

5.Retrieve the parent number of the sold to address using X01200.  Then assign the number to the
parent Number field (SHPA8).  A/B - Get Parent Address (B0100002.C)

Add the open order amount (A5APRC) to the Customer Master File (F0301) based on the sold to address.
If CRMM-hwf == 'D' pass APRC-hwf in the domestic taxable amount, otherwise pass APRC-hwf in the
foreign taxable amount.

Note:  B0100024.c should require you to send in a currency code.  Use the following logic to
determine which currency code to send:
If CRRM (wf) == 'D'
Send Base Currency (CRDC - parm) and send the APRC-hwf (which will be in domestic
currency);
else
Send Customer Currency (CRCD - wf) and send the APRC-hwf (which will be in
foreign currency);

6.If in duplication mode and the Processing Option to copy order level text is set, copy the
order level associated text.

7.(future) If in duplication mode, copy order address information (F4006).

8.Perform order margin check using MarginCheckProcessing (B4200290.C).  If Order is on Hold
return flag is set to 1, assign margin hold code to SHHOLD.

9.Perform min/max check.

10.Perform credit check using the Business Function CreditCheckProcessing (B4200400.C)

if the APRC-hwf is greater than 0.

Process and Update Detail Work File

11.Read records from detail work File (F42UI11).  If the Sales Order Number is passed, read only the
records that have a matching computer ID and job number. If the Job Number is not passed, use the Job
Number from the header record to retrieve the detail lines.

12.Assign header order number (DOCO-hwf) to detail line if the order number (DOCO-dwf) is zero and
the action is "ADD".

13.If the LINN-dwf == 0, do steps 13 - 16, Else do 17 - 20.

14.If line number (LNID-dwf) < Largest Line Number, verify that it is unique by calling
VerifyAndGetSalesDetail (B4200210.C) and passing '2' in Call Type and '1' in Suppress Error.

15.If the line number is  zero (LNID-dwf) or equal to the Largest Line Number or not unique

(see step 13),LNID-dwf = Largest Line Number + Processing Option for Line No. Increment.-parm;

16.If the line number (LNID-dwf) > largest line number,

Largest Line Number = LNID-dwf;

17.Last Line No. Array[Work file line no. (LNIX-dwf)] = Line number (LNID-dwf)Line No. Array[Work
file line no. (LNIX-dwf)] = Line number (LNID-dwf)

18.The LINN-dwf was != 0. If the Line No. (LNID-dwf) is less than the largest line number, find the
largest line number between the Line No. (LNID-dwf) and the next line increment. If that line number is
larger than the line number stored in the Line No. Array[Work file line no. (LNIX-dwf)], then copy
the found line number into the array, else Last Line No. Array[Work file line no. (LNIX-dwf)] = Line No.
Array[same index].

19.Line No. (LNID-dwf) = Last Line No. Array[Work file line no.(LNIX-dwf)] + Line No. Increment
(LINN-dwf).

20.Last Line No. Array[Work file line no.(LNIX-dwf)] = Line No. (LNID-parm)

21.If Kit or Configurator Component Line, update KTLN-dwf with the Parent's LNID.
KTLN = Line No. Array[KTLN]

22.If the Largest Line Number is less than the Line No. (LNID-parm), Largest Line Number = LNID-dwf.

23.If CHG, DEL, or PURGE mode and SO08-dwf != '3'
Last Line No. Array[Work file line no.(LNIX-dwf)] = Line No. (LNID-parm)
Line No. Array[Work file line no.(LNIX-dwf)] = Line No. (LNID-parm)

24.If in CHG mode and freight was calculated before, put an "X" in the Freight Calculated Field.
(i.e., If ACTI == CHG && FRTC-F4211 == 'Y', FRTC-dwf = 'X';)

25.(Obsolete) If in CHG or DEL mode and Inventory Interface (IVI-dwf) =="Y" and item is not a kit
(STKT-dwf != "K" and "C"), must decommit inventory from the Item Location Table (F41021).

e.g. If UOM-F4211 != UOM1-F4211,
Convert quantities (SOQS-F4211 and SOBK-F4211) to primary UOM using
GetItemUOMConversionFactor (B4000520.C).
BranchPlant<=MCU-F4211
FromUnitOfMeasure<=UOM-F4211
ToUnitOfMeasure<=UOM1-F4211
QuantityToConvertNot used
InventoryInterfaceFlag<=IVI-dwf
ShortItemNumber<=ITM-dwf
ConversionFactorFrom_to_Tonot used
ConversionFactorFrom_to_Primary=>ConversionFactor (WF)
ConversionFactorTo_to_Primarynot used
UnitOfMeasureToPrimary<=UOM1-dwf
QuantityConvertedToPrimaryNot used
ConvertToSecondarynot used
UnitOfMeasureToSecondarynot used
QuantityCOnvertedToSecondarynot used
ConvertToPurchasingnot used
UnitOfMeasureToPurchasingnot used
QuantityConvertedToPurchasingnot used
ConvertToPricingnot used
UnitOfMeasureToPricingnot used
QuantityConvertedToPricingnot used
ConvertToShippingnot used
UnitOfMeasureToShippingnot used
QuantityConvertedToShippingnot used
ConvertToWeightnot used
UnitOfMeasureToWeightnot used
QuantityConvertedToWeightnot used
ConvertToVolumenot used
UnitOfMeasureToVolumenot used
QuantityConvertedToVolumenot used
UOMByBranch<=BUMC-parm
PotencyMode<=COMM-dwf
LotNumber<=LOTN-F4211
PotencyControl<=IBOT1Y
StandardPotency<=IBSTDP
ErrorMessageIDnot used
SuppressMessageFlag<=1

else
Conversion Factor (WF) = 1;

Call CommitSalesOrderToInventory (B4200370.C)

Item Number<=ITM-dwf
Branch/Plant<=MCU-F4211
Location<=LOCN-F4211
Lot <=LOTN-F4211
Shipping Quantity<=SOQS-F4211
Backorder Quantity<=SOBK-F4211
TransToPrimConvFactor<=Conversion Factor (WF)
Commitment Flag<=COMM-F4211
Other Quantity 1 or 2<=OTQY-F4211
Future Commitment<='1' if SONE-parm != 0
Reverse Commitment<='1'
Program ID<=PID-parm
Suppress Error Message<='1'
Error MessageNot used

SONE-dwf = 0;

26.On a DEL or PURGE, process "Cancel Line Logic" for detail line and skip to step 30.

'15'1a'1a'08(

Data Structure

D4200310G - F4211 FS End Doc

Special Input Expected
Common Parameters:
JOBSCM-Job NumberThe job number unique to the application. If consolidated orders in
EditLine, do not pass in.
CTIDCM-Computer IDComputer ID
CRYRCM-Currency ControlRetrieved from system values.
PIDCM-Program IDCurrently Not Used
VERSCM-VersionCurrently Not Used.

Processing Options and Work Fields:
OTOTOrder TotalDomestic Order Total
FAPForeign Order TotalForeign Order Total (if applicable)
CRDCBase Currency Code
JPIDProgram IDNo edits.  Assign to F4201 and F4211.
JOBNWorkStation IDNo edits.  Assign to F4201 and F4211.  (GetAuditInfo)
TDAYTime of EnteredNo edits.  Assign to F4201 and F4211.
TOTCTotal CostUsed in Order Margin Checking.
FCSTForeign Total Cost(Future Use)
EV02WK-SkipProcOptions'1' Yes
' '- Retrieve Proc Options
EV03WK - Related Order Process
EV04CM Use Work Files'1' - Use work filed
'2' - Use cache
EDOCEDI Document Number
EKCOEDI Key Company
EDCTEDI Document Type

Special Output Returned
Common Parameters:
ERRCCM-Error Condition' ' = No Errors
'1' = Warnings
'2' = Errors

Processing Options and Work Fields:
DOCOrder NumberSales Order Number
DCTOrder TypeSales Order Type
KCOKey CompanyOrder Key Company
EV01Order On Hold Flag1 - if order is placed on hold
EV03WK - Related Order Process

Obsoleted Fields As of 12/1/97:
FILECM-Header Work FileDeleted 8/20/95.
FNAMCM-Detail Work FileDeleted 8/20/95.
STKTStocking TypeDeleted 8/20/95
WRTHWrite Ledger Record (Y/N)Deleted 8/20/95
IVIInventory InterfaceDeleted 8/20/95
DATE01Commitment DateDeleted 1/7/96
EV02Duplication ModeDeleted 1/7/96
EV01PO-Quote OrderDeleted 1/7/96
HCODPO-Margin Hold CodeDeleted 1/7/96
BUMCUom Conv by BranchDeleted 1/7/96
LND2Line Number IncrementDeleted 1/7/96

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnCMJobNo JOBS MATH_NUMERIC NONE NONE

The job number (work station ID) which executed the particular job.

mnSalesOrderNo DOC MATH_NUMERIC NONE 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.

szCMComputerID CTID char REQ NONE

The Computer ID where the order is being processed. This parameter together with Job Number comprises
the unique composite keys used to read and write to the F42UI01 and F42UI11 caches.
^

cCMErrorCondition ERRC char NONE NONE

Special Output Returned
ERRCab CM-Error Condition

Significant Data Values
' ' = No Errors
'1' = Warnings
'2' = Errors
^

szOrderType DCT char NONE 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

szKeyCompany KCO char NONE 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.

mnOrderTotal OTOT MATH_NUMERIC NONE NONE

The total value of all lines on the order that have not been shipped and billed to the customer.

mnForeignOrderTotal FAP MATH_NUMERIC NONE NONE

The unpaid foreign amount of a transaction.

szBaseCurrencyCode CRDC char NONE NONE

A code that identifies the domestic (base) currency of the company on a transaction.

szProgramID JPID char NONE NONE

The RPG program name defined in the Software Versions Repository Master file. The numbering system is illustrated below. T SS XXX
where T = Specific member ID number      where SS = System number (e.g., 01 = Address Book)      where XXX = Member type (e.g., P =
Program, R = Report, etc.) For further details on the numbering system, refer to the Technical Foundation Guide.

szWorkstationID JOBN char NONE NONE

The code that identifies the work station ID that executed a particular job.

szCMProgramID 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.

szCMVersion VERS char NONE 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.

mnTimeOfDay TDAY MATH_NUMERIC NONE NONE

The computer clock in hours:minutes:seconds.

mnTotalCost TOTC MATH_NUMERIC NONE NONE

mnForeignTotalCost FCST MATH_NUMERIC NONE NONE

cSuppressRlvBlnktFlag EV02 char NONE NONE

Special Input Expected
EV02ab WK-SkipProcOptions

Significant Data Values
'1' Yes
' '- Retrieve Proc Optionsab

^

cWKSkipProcOptions EV03 char NONE NONE

Special Input Expected
EV03ab WK - Related Order Processab ab ab ab

Special Output Returned
EV03ab WK - Related Order Processab ab ab ab

^

mnWKRelatedOrderProcess MATH02 MATH_NUMERIC NONE NONE

- - - Good Performance High Value.

cCMUseWorkFiles EV04 char REQ NONE

This parameter determines where to store the information.

Significant Data Values
'1' = Write and/or update records to the work file.
'2' = Write and/or update records to the cache

^

mnEDIDocNo EDOC MATH_NUMERIC NONE NONE

The document number that is assigned by the transmitter in an EDI transaction. In a non EDI environment, this would be consistent with the
order number assigned at order entry time (DOCO).

szEDIKeyCo EKCO char NONE NONE

Company - Key (EDI - Document Key Co)

szEDIDocType EDCT char NONE NONE

The document type that is assigned by the transmitter in an EDI transaction. In a non EDI environment, this would be consistent with the order
type (DCTO) assigned at order entry time, an invoice document type, a voucher document type, and so on.

cCMProcessEdits EV05 char OPT NONE

A flag that indicates whether automatic spell check is turned on.

cGenericChar2 EV10 char OPT NONE

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

mnSODRelatedJobNumber MATH10 MATH_NUMERIC OPT NONE

Event point for Math Numeric.

cGenericChar1_EV01 EV01 char OPT NONE

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

mnGenericMathNumeric2_MATH02 MATH02 MATH_NUMERIC OPT NONE

- - - Good Performance High Value.

szGenericString1_DL01 DL01 char OPT NONE

A user defined name or remark.

szGenericString2_DL02 DL02 char OPT NONE

Additional text that further describes or clarifies a field in the system.

mnProcessID PEID MATH_NUMERIC OPT NONE

A code that identifies the Inter-Process Communication ID.

mnTransactionID TCID MATH_NUMERIC OPT NONE

szSOEMBFInternalFlags SOEF char OPT NONE

This field is broken down into 30 different flags which are passed in and out of the sales order entry MBF - F4211 Begin Doc, F4211 Pre
Processor, F4211 Edit Line, and F4211 End Doc.

mnRelatedOrderSetIdentifier ROSID MATH_NUMERIC OPT NONE

A number that identifies a set of reference order numbers (for example, Sales Order, Purchase Order, Transfer Order, Direct Ship Order,
Work Order, and so on) that are related and linked together. In Related Order Cross-Reference Table (F4080), different records with the same
value in this field identify the group of related orders.

mnDescTaskOrderNumber 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.

szDescTaskOrderType 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

Related Functions

B0000021 Format Subledger

B0000027 CurrencyConvForAndDom

B0000033 Get Exchange Rate

B0000128 Retrieve Company Currency Code

B0000130 Retrieve Company From Business Unit

B0100002 A/B - Get Parent Address

B0100024 Convert Transaction Amt to Customer Ccy & Upd F0301

B3201150 F4801 Update WO Status During SO Change Mode

B3800080 Agreement Cache For Sales Order

B4000150 Get Branch Constants

B4000260 Line Type - Activity Rules

B4000310 Location Information

B4000360 Check Location Master

B4000370 Get Default Branch

B4000450 Convert Short Item To Long Item

B4000520 Get Item UoM Conversion Factor

B4000530 Get Distribution Constants

B4000590 Verify Line Type

B4000610 Get Lot Master By Lot Number

B4000670 Get Item Units Of Measure

B4000790 Verify Date2 After Date1

B4000800 Edit Document Type Not Blank

B4000870 Standard Pricing Adjustments

B4000880 Verify And Get Address Book for OP

B4000950 Return the Item Stocking Type

B4000960 Verify Override Next Status Code

B4001100 Write Hold Code

B4002000 Compute Unit Or Extended Amount

B4002020 Purge Held Order Records

B4002060 Preference Get Values For Sales Order

B4002300 Preference Allocations

B4100205 Get Item Master Price Info

B4100210 Check Item Branch

B4101220 Calculate Availability

B4200030 F4201 Get Order No. From Next Number

B4200050 F42004 Verify Commission Code

B4200070 Get Sales Base Price

B4200080 Convert Domestic And Foreign Amount

B4200090 Verify Tax Explanation Code

B4200100 Get Sold To Billing Instructions

B4200110 Verify Xchg Rate Against Tolerance

B4200120 F4008 Verify Tax Area

B4200130 Verify Customer PO Number Is Unique

B4200140 Get Ship To Billing Instructions

B4200150 Verify Sales Order Before Update

B4200160 Get Freight Rate Code From F4020

B4200210 Get F4211 Detail Information

B4200230 F4074 Maintain Price History

B4200270 Check Item Restrictions

B4200280 Calculate Commitment Date

B4200290 Margin Check Processing

B4200311 Sales Order Entry Master Business Function

B4200340 Verify And Get Sales Header

B4200370 Commit Sales Order To Inventory

B4200420 Credit Check Processing

B4200450 Advanced Sales Order Detail Line Split

B4200490 Relieve SO Blanket Order Qty

B4200690 Copy SO Info To Work Files

B4200710 CalculateTransferCost

B4200760 Add Order to Subsystem Queue

B4200780 F42UI130 Get/Update Commitment Work File

B4200830 Retrieve Interbranch Order Types

B4200850 Preference Calculate Commitments

B4201210 Serial Number Processing Edits

B4201270 F49211 Maintain Sales Detail Table

B4201280 F42UI12 Get Sales Order Detail Info

B4301250 F4311Z Update Related Order Info

B4500050 F4072 Calculate Price Adjustments

B4500090 F4074 Price Adjustment Ledger Server

B4500200 F4573 Get Next Free Good

B4600130 Cache, Warehouse Components

B4700070 EDI - Convert EDI Text To Generic Text

B7600720 Retrieve Cache Information from Sales Header - Brazil - 42B

B7600730 Retrieve Cache Information from Sales Detail - Brazil - 42B

B7600750 Write Cache Information Sales Detail - Brazil - 42B

B7600790 Write Cache to Sales Detail File - Brazil - 42B

B9800100 Get Audit Information

B9800420 Get Data Dictionary Definition

B9900410 Get Environment Value

N3200700 Write Configurator Files at End Doc

N3201130 Duplicate Configurator Information

N3800040 F38012 Agreement Transaction Server

N3800050 F38010 Agreement Search

N4002510 Verify Original Blanket Order Before Update

N4200870 Increment Sales Detail Line Number

N4201010 Determine If Blanket SO Exists

N4301750 Add Matching F4006 Record

N4600030 Warehouse Management Request Transactions

N4600320 F40203 Validate AWM Override Status

N4700130 EDI Update Inbound Detail As Processed

N4900010 F4215 Add Shipment Detail

N4900180 Process Order Line

N7000320 B4200310 - Plug & Play - 42B

R42997 Inventory Commitment

X0005 Get User Defined Codes

X0903 Fiscal Date Edits +

X0909 Validate Subledger

X4101 Validate and Retrieve Item Master

XF41021 Update F41021 Locations

XF4105 Item Cost I/O

XT4311Z1 Purchase Order Entry

Related Tables

F4201 Sales Order Header File

F4211 Sales Order Detail File

F42UI01 SO Header Cache File (MBF)

F42UI11 SO Detail Cache File (MBF)

F42UI130 Commitment Work File

F4573 Free Goods Reference File

in">if the APRC-hwf is greater than 0.

Process and Update Detail Work File

11.Read records from detail work File (F42UI11).  If the Sales Order Number is passed, read only the
records that have a matching computer ID and job number. If the Job Number is not passed, use the Job
Number from the header record to retrieve the detail lines.

12.Assign header order number (DOCO-hwf) to detail line if the order number (DOCO-dwf) is zero and
the action is "ADD".

13.If the LINN-dwf == 0, do steps 13 - 16, Else do 17 - 20.

14.If line number (LNID-dwf) < Largest Line Number, verify that it is unique by calling
VerifyAndGetSalesDetail (B4200210.C) and passing '2' in Call Type and '1' in Suppress Error.

15.If the line number is  zero (LNID-dwf) or equal to the Largest Line Number or not unique

(see step 13),LNID-dwf = Largest Line Number + Processing Option for Line No. Increment.-parm;

16.If the line number (LNID-dwf) > largest line number,

Largest Line Number = LNID-dwf;

17.Last Line No. Array[Work file line no. (LNIX-dwf)] = Line number (LNID-dwf)Line No. Array[Work
file line no. (LNIX-dwf)] = Line number (LNID-dwf)

18.The LINN-dwf was != 0. If the Line No. (LNID-dwf) is less than the largest line number, find the
largest line number between the Line No. (LNID-dwf) and the next line increment. If that line number is
larger than the line number stored in the Line No. Array[Work file line no. (LNIX-dwf)], then copy
the found line number into the array, else Last Line No. Array[Work file line no. (LNIX-dwf)] = Line No.
Array[same index].

19.Line No. (LNID-dwf) = Last Line No. Array[Work file line no.(LNIX-dwf)] + Line No. Increment
(LINN-dwf).

20.Last Line No. Array[Work file line no.(LNIX-dwf)] = Line No. (LNID-parm)

21.If Kit or Configurator Component Line, update KTLN-dwf with the Parent's LNID.
KTLN = Line No. Array[KTLN]

22.If the Largest Line Number is less than the Line No. (LNID-parm), Largest Line Number = LNID-dwf.

23.If CHG, DEL, or PURGE mode and SO08-dwf != '3'
Last Line No. Array[Work file line no.(LNIX-dwf)] = Line No. (LNID-parm)
Line No. Array[Work file line no.(LNIX-dwf)] = Line No. (LNID-parm)

24.If in CHG mode and freight was calculated before, put an "X" in the Freight Calculated Field.
(i.e., If ACTI == CHG && FRTC-F4211 == 'Y', FRTC-dwf = 'X';)

25.(Obsolete) If in CHG or DEL mode and Inventory Interface (IVI-dwf) =="Y" and item is not a kit
(STKT-dwf != "K" and "C"), must decommit inventory from the Item Location Table (F41021).

e.g. If UOM-F4211 != UOM1-F4211,
Convert quantities (SOQS-F4211 and SOBK-F4211) to primary UOM using
GetItemUOMConversionFactor (B4000520.C).
BranchPlant<=MCU-F4211
FromUnitOfMeasure<=UOM-F4211
ToUnitOfMeasure<=UOM1-F4211
QuantityToConvertNot used
InventoryInterfaceFlag

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnCMJobNo	JOBS	MATH_NUMERIC	NONE	NONE
The job number (work station ID) which executed the particular job.
mnSalesOrderNo	DOC	MATH_NUMERIC	NONE	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.
szCMComputerID	CTID	char	REQ	NONE
The Computer ID where the order is being processed. This parameter together with Job Number comprises the unique composite keys used to read and write to the F42UI01 and F42UI11 caches. ^
cCMErrorCondition	ERRC	char	NONE	NONE
Special Output Returned ERRCab CM-Error Condition Significant Data Values ' ' = No Errors '1' = Warnings '2' = Errors ^
szOrderType	DCT	char	NONE	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
szKeyCompany	KCO	char	NONE	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.
mnOrderTotal	OTOT	MATH_NUMERIC	NONE	NONE
The total value of all lines on the order that have not been shipped and billed to the customer.
mnForeignOrderTotal	FAP	MATH_NUMERIC	NONE	NONE
The unpaid foreign amount of a transaction.
szBaseCurrencyCode	CRDC	char	NONE	NONE
A code that identifies the domestic (base) currency of the company on a transaction.
szProgramID	JPID	char	NONE	NONE
The RPG program name defined in the Software Versions Repository Master file. The numbering system is illustrated below. T SS XXX where T = Specific member ID number where SS = System number (e.g., 01 = Address Book) where XXX = Member type (e.g., P = Program, R = Report, etc.) For further details on the numbering system, refer to the Technical Foundation Guide.
szWorkstationID	JOBN	char	NONE	NONE
The code that identifies the work station ID that executed a particular job.
szCMProgramID	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.
szCMVersion	VERS	char	NONE	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.
mnTimeOfDay	TDAY	MATH_NUMERIC	NONE	NONE
The computer clock in hours:minutes:seconds.
mnTotalCost	TOTC	MATH_NUMERIC	NONE	NONE

mnForeignTotalCost	FCST	MATH_NUMERIC	NONE	NONE

cSuppressRlvBlnktFlag	EV02	char	NONE	NONE
Special Input Expected EV02ab WK-SkipProcOptions Significant Data Values '1' Yes ' '- Retrieve Proc Optionsab ^
cWKSkipProcOptions	EV03	char	NONE	NONE
Special Input Expected EV03ab WK - Related Order Processab ab ab ab Special Output Returned EV03ab WK - Related Order Processab ab ab ab ^
mnWKRelatedOrderProcess	MATH02	MATH_NUMERIC	NONE	NONE
- - - Good Performance High Value.
cCMUseWorkFiles	EV04	char	REQ	NONE
This parameter determines where to store the information. Significant Data Values '1' = Write and/or update records to the work file. '2' = Write and/or update records to the cache ^
mnEDIDocNo	EDOC	MATH_NUMERIC	NONE	NONE
The document number that is assigned by the transmitter in an EDI transaction. In a non EDI environment, this would be consistent with the order number assigned at order entry time (DOCO).
szEDIKeyCo	EKCO	char	NONE	NONE
Company - Key (EDI - Document Key Co)
szEDIDocType	EDCT	char	NONE	NONE
The document type that is assigned by the transmitter in an EDI transaction. In a non EDI environment, this would be consistent with the order type (DCTO) assigned at order entry time, an invoice document type, a voucher document type, and so on.
cCMProcessEdits	EV05	char	OPT	NONE
A flag that indicates whether automatic spell check is turned on.
cGenericChar2	EV10	char	OPT	NONE
An option that specifies the type of processing for an event.
mnSODRelatedJobNumber	MATH10	MATH_NUMERIC	OPT	NONE
Event point for Math Numeric.
cGenericChar1_EV01	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnGenericMathNumeric2_MATH02	MATH02	MATH_NUMERIC	OPT	NONE
- - - Good Performance High Value.
szGenericString1_DL01	DL01	char	OPT	NONE
A user defined name or remark.
szGenericString2_DL02	DL02	char	OPT	NONE
Additional text that further describes or clarifies a field in the system.
mnProcessID	PEID	MATH_NUMERIC	OPT	NONE
A code that identifies the Inter-Process Communication ID.
mnTransactionID	TCID	MATH_NUMERIC	OPT	NONE

szSOEMBFInternalFlags	SOEF	char	OPT	NONE
This field is broken down into 30 different flags which are passed in and out of the sales order entry MBF - F4211 Begin Doc, F4211 Pre Processor, F4211 Edit Line, and F4211 End Doc.
mnRelatedOrderSetIdentifier	ROSID	MATH_NUMERIC	OPT	NONE
A number that identifies a set of reference order numbers (for example, Sales Order, Purchase Order, Transfer Order, Direct Ship Order, Work Order, and so on) that are related and linked together. In Related Order Cross-Reference Table (F4080), different records with the same value in this field identify the group of related orders.
mnDescTaskOrderNumber	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.
szDescTaskOrderType	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