ItemLedgerDetailUpdateProcessing

Item Ledger Detail Update Processing

Minor Business Rule

Object Name: B3104260

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function is used by the Manufacturing Journal Entries UBE (R31802A). It is called by the Work Order Processing (B3104170) business
function. Its purpose is to update the Item Ledger (F4111) file.

Setup Notes and Prerequisites
There are no special prerequisites or setup notes for this function.

Technical Specifications
Open the Item Ledger (F4111) table
Set Selection on the Item Ledger table based on the Work Order Number, Order Type, and the Batch Number equal to zero
For each record selected
Update the Item Ledger information
Close the Item Ledger table.

Data Structure

D3104260 - Item Ledger Detail Update

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,
and so on.

szOrderType DCTO char OPT NONE

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents
O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents

jdGLDate DGL JDEDATE OPT NONE

A date that identifies the financial period to which the transaction is to be posted. The company constants specify the date range for each
financial period. You can have as many as 14 periods. Generally, period 14 is used for audit adjustments. The system validates this field for
PBCO (posted before cutoff), PYEB (prior year ending balance), PACO (post after cutoff), and WACO (post way after cutoff) messages.

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
assign a batch number or let the system assign it using the Next Numbers program.

cSuppressErrorMessage 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
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

szUserId USER char OPT NONE

The code that identifies a user profile.

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
current date.

mnTime TME0 MATH_NUMERIC OPT NONE

Everest Parent Data Item

szWorkStationId JOBN char OPT NONE

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

szProgramId PID char OPT NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

szDocumentCompany KCO char OPT NONE

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

Related Functions

None

Related Tables

None

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, and so on.
szOrderType	DCTO	char	OPT	NONE
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
jdGLDate	DGL	JDEDATE	OPT	NONE
A date that identifies the financial period to which the transaction is to be posted. The company constants specify the date range for each financial period. You can have as many as 14 periods. Generally, period 14 is used for audit adjustments. The system validates this field for PBCO (posted before cutoff), PYEB (prior year ending balance), PACO (post after cutoff), and WACO (post way after cutoff) messages.
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 assign a batch number or let the system assign it using the Next Numbers program.
cSuppressErrorMessage	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 special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
szUserId	USER	char	OPT	NONE
The code that identifies a user profile.
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 current date.
mnTime	TME0	MATH_NUMERIC	OPT	NONE
Everest Parent Data Item
szWorkStationId	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.
szProgramId	PID	char	OPT	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
szDocumentCompany	KCO	char	OPT	NONE
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher, or journal entry. If you use the Next Numbers by Company/Fiscal Year feature, the Automatic Next Numbers program (X0010) uses the document company to retrieve the correct next number for that company. If two or more original documents have the same document number and document type, you can use the document company to locate the desired document.