Functional Description
Purpose
This business function is used by the Manufacturing Journal Entries UBE (R31802A). It is called for each work order contained within the UBE data
selection. Its purpose is to peform all work order level processing by calling external functions to calculated Production Costs (Planned, Actual
Completed, and Scrapped) and to peform F0911 Edit Line processing for material issues, reported hours and quantities, and completed and scrapped units.
Setup Notes and Prerequisites
There are no special prerequisites or setup notes for this function
Technical Specifications
Retrieve the Work Order Company (B0000130)
Initialize the F3102 Variance Cache with existing F3102 table records (B3101630)
If Costing by Work Center (Mfg. Constants Flag)
Load the Work Center Cache (B3003870)
Recalculate the Work Order Restated Quantity
Retrieve the Project Number for the Work Order (F4801T)
If the Work Order is part of a Project
Retrieve the Poject Attributes(N31P0040)
Determine the Subledger and Subledger Type (B0000021)
Call the Material Issues Business Function (B3104180)
Call the Shop Floor Business Function (B3104190)
If the Item is a Process
Call the Co-By Processing Business Function (B3104200)
If the Item is Discrete
Call the Discrete Processing Business Function (B3104210)
Process Order Level Errors and Warnings (BLM0078) and (B0100011)
If Detail Journal Entries are requested and an Edit Line error occurred
Delete all F0911 cache records (B3103040, B0900049, and B3104300) Note: the cache will only contain records for current work order.
If Summarized Journal Entries are requested and an Edit Line error occured
Delete only F0911 cache records for the current work order (B3103040, B0900049, and B3104300) Note: cache will containe records for
all work orders processed up to this point in the processing.
If Detailed Journal Entries are requested and no Edit Line errors occured, and the report is run in Final Mode
Perform F0911 Edit Doc and F0911 End Doc processing (B0400049)
If in Final Mode and no errors have occured
Update the Work Order Status (B3100960)
Clear the Unaccounted Units (B3104260)
Update the Item Ledger (N3103080)
Update F3102 (B3101630)
D3104170 - Work Order Processing
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnWorkOrderNumber | 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,
| ||||
mnDocumentNumber | DOC | MATH_NUMERIC | OPT | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
szOrderType | DCTO | char | OPT | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
jdGLDate | DG | JDEDATE | OPT | NONE |
A date that identifies the financial period to which the transaction is to post. The company constants table for general accounting specifies
| ||||
szDocumentType | DCT | char | OPT | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
szScrapDocumentType | DCT | char | OPT | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
szShopFloorDocumentType | DCT | char | OPT | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
szWorkOrderStatusCode | SRST | char | OPT | NONE |
A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from
| ||||
cDefaultSubledgerFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cSummarizeWithinWO | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cSummarizeAcrossWO | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cFlexAccountingFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cChargeToCCFlage | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorMessageID | DTAI | char | OPT | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
mnJobNumberScrap | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
mnJobNumberComp | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
mnJobNumberHours | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
mnJobNumberIssues | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
szPrimaryUOM | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
cStockingType | STKT | char | OPT | 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
| ||||
mnAcctingCostQty | ACQ | MATH_NUMERIC | OPT | NONE |
An amount that the system uses in the Cost Rollup program to determine the allocation of setup costs. The system totals the setup costs
| ||||
szParentGLCategory | GLPT | char | OPT | NONE |
A user defined code (41/9) that identifies the G/L offset that system uses when it searches for the account to which it posts the transaction. If
| ||||
mnWorkOrderQty | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
szWorkOrderUOM | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
szWorkOrderBusinessUnit | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szWorkOrderSubsidiary | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
szWorkOrderBranch | MMCU | char | OPT | NONE |
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
| ||||
mnQuantityScrapped | SOCN | MATH_NUMERIC | OPT | 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
| ||||
mnUnaccParentUnits | CTS1 | MATH_NUMERIC | OPT | NONE |
The number of unaccounted direct labor hours associated with a specific operation for a work order. | ||||
mnParentItemNumber | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szCacheJobNumber | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
szLocation | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
mnBatchNumber | ICU | MATH_NUMERIC | OPT | NONE |
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
| ||||
szBatchType | ICUT | char | OPT | NONE |
A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction.
| ||||
cFinalMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cCurrencyConverYNAR | CRYR | char | OPT | NONE |
A code that specifies whether to use multi-currency accounting, and the method of multi-currency accounting to use:
Codes are:
N Do not
| ||||
szCompany | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szComputerID | CTID | char | OPT | NONE |
szUserId | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
cPrevBatchStatus | IST | char | OPT | NONE |
A user defined code (98/IC) that indicates the posting status of a batch. Valid values are:
Blank
Unposted batches that are pending
| ||||
jdDate | DTE | JDEDATE | OPT | NONE |
You can enter a date with or without slashes (/) or dashes (-) as separators.
If you leave a date entry field blank, the system supplies the
| ||||
mnTimeOfDay | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
jdBatchDate | DICJ | JDEDATE | OPT | NONE |
The date of the batch. If you leave this field blank, the system date is used. | ||||
szLanguagePreference | LNPOW | char | OPT | NONE |
The language that you want to use to print reports or documents, or to view information on the form. | ||||
mnQuantityCancScrap | SOCN | MATH_NUMERIC | OPT | 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
| ||||
mnQuantityShipped | SOQS | MATH_NUMERIC | OPT | NONE |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
| ||||
mnSummaryJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
mnConversionFactor | CONV | MATH_NUMERIC | OPT | NONE |
The factor that the system uses to convert one unit of measure to another unit of measure. | ||||
szParentCostMethod | LEDG | char | OPT | NONE |
A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards
| ||||
szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
cWriteUnitsToJE | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cOutsideOpHeaderStack | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cPotencyControl | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szParentSecondItemNumber | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szParentThirdItemNumber | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szStdUOMConversion | TFLA | char | OPT | NONE |
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are:
blank Use the item-specific
| ||||
szWorkOrderStatus | SRST | char | OPT | NONE |
A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from
| ||||
mnDecimals | NDEC | MATH_NUMERIC | OPT | NONE |
The number of digits to the right of the decimal point. | ||||
mnStandardPotency | STDP | MATH_NUMERIC | OPT | NONE |
The percentage of active ingredients normally found in an item. | ||||
szChargeToCC | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szCompDocumentType | DCT | char | OPT | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
cProcessOrDiscrete | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szParentExplanation | EXR | char | OPT | NONE |
A name or remark that describes the purpose for using an account or conveys any other information that the user wants about the
| ||||
cMfgOrPurchase | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cVarianceFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cDuplicateJEs | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
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). | ||||
cChargeToProject | CHPR | char | OPT | NONE |
A code that specifies whether the system charges the work order costs to the project account rather than to a finished goods account. Valid
| ||||
cCostByWC | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cWCAccrualJEs | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cSumWithinWORpt | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szItemDescription | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
cSumAcrossWORpt | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
idPPATPointer | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
cIssueGLClassCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. |
None |
None |