N3101220

F3108 Write Summarized WO X-Ref

Minor Business Rule

Object Name: N3101220

Parent DLL: CMFGBASE

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose
This NER will be used to insert or delete a record from F3108 based on the primary unique of the file.

1.2Setup Notes and Prerequisites

1.3Special Logic

2.Technical Specifications

2.2Related Tables
Table Table Description
F3108Summarized WO Cross Reference

2.3Related Business Functions
Source NameFunction Name

2.4Processing

If mode = "1" then insert record to F3108 Table, if mode = "2" then delete record in F3108 Table.

Data Structure

D3101220 - F3108 WO Xref Update

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnSummarizedWONumber	JDOC	MATH_NUMERIC	NONE	NONE
The document number assigned as a batch work order number when you summarize manufacturing work order journal entries. The number indicates the work order into which the journal entries were summarized. The system writes this number to the DOCO field in the General Ledger (F0911).
mnDocumentOrderInvoiceE	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.
mnBatchNumber	ICU	MATH_NUMERIC	NONE	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.
jdDateBatchJulian	DICJ	JDEDATE	NONE	NONE
The date of the batch. If you leave this field blank, the system date is used.
jdDateForGLandVoucherJULIA	DGJ	JDEDATE	NONE	NONE
A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you assign to the company record. The system compares the date that you enter on the transaction to the fiscal date pattern assigned to the company to retrieve the appropriate fiscal period number, as well as to perform date validations.
szUserId	USER	char	NONE	NONE
The code that identifies a user profile.
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.
szWorkStationId	JOBN	char	NONE	NONE
The code that identifies the work station ID that executed a particular job.
jdDateUpdated	UPMJ	JDEDATE	NONE	NONE
The date that specifies the last update to the file record.
mnTDAY	TDAY	MATH_NUMERIC	NONE	NONE
The computer clock in hours:minutes:seconds.
cMode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None