F48090GetWOSuppData

F48090 Get WO Supplemental Data Type

Minor Business Rule

Object Name: B4800060

Parent DLL: CMFG

Location: Client/Server

Language: C

Functional Description

Purpose
Retrieve the Supplemental Data Type information from the Work Order Supplemental Data Types File
(F48090) using theWork Order Database (WODB) and Type Data (TYWO) key.

Setup Notes and Prerequisites

Special Logic

Technical Specification



1. Retrieve the Supplemental Data Type information from the Work Order Supplemental Data Types File 

(F48090) using the input Work Order Database (WODB) and Type Data (TYWO) as key for the record 

selection.


2. Issue error message 0002 if record not found and Suppress Error Messages != '1'

Data Structure

D4800060 - F48090 Get WO Supplemental Data Type

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cWorkOrderDataBase	WODB	char	NONE	NONE
The code representing what Work Order Data Base is to be used.
szTypeData	TYWO	char	NONE	NONE
A user defined code (00/WT) that indicates the type of data being entered within the supplemental database. The code is often an abbreviation for the data that it represents. For example, EC might represent Engineering Change.
cDisplayFormat	DSPF	char	NONE	NONE
A code that determines the display mode for Supplemental Data. Valid codes are: C Automatically takes you to the Data Entry program where you can enter code-specific information. The code values you enter can be edited against values in the User Defined Codes file (F0005). O Automatically takes you to the Related Order Entry program, bypassing code-specific information. If you use an O, narrative text will not be tied to specific codes.
szDescription	DL01	char	NONE	NONE
A user defined name or remark.
szSystemCode	SY	char	NONE	NONE
A user defined code (98/SY) that identifies a system. Valid values include: 01 Address Book 03B Accounts Receivable 04 Accounts Payable 09 General Accounting 11 Multicurrency
szUserDefinedCodes	RT	char	NONE	NONE
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type.
szUserDefinedQuantityTitle	GDC0	char	NONE	NONE
The title of a supplemental data column that relates to quantities. For example, if you want to track quantity to be scrapped, a column heading might be Scrapped.
szUserDefinedCodeTitle	GDC1	char	NONE	NONE
A description of a supplemental data column that relates to a user defined code. For example, if the supplemental data type relates to the educational degrees of employees (BA, MBA, Ph.D, and so on), the description could be Degree. This column contains user defined codes.
szUserDefinedAmountTitle	GDC2	char	NONE	NONE
The title of a supplemental data column that relates to an amount. For example, if the data type relates to bid submittals, the heading could be Bid Amounts. This column contains statistical or measurable information.
szRemark1ColumnTitle	GDC3	char	NONE	NONE
The title of a supplemental data column.
szDateColumnTitle	GDC5	char	NONE	NONE
The title of a supplemental data column that relates to a date. For example, a possible column heading for the date field linked to a data type for education might be Graduation.
szDate_2_ColumnTitle	GDC6	char	NONE	NONE
The title of a supplemental data column that relates to a date. For example,if you set up a record type for professional licenses, a possible column title for the date field might be Expires.
szOrderColumnTitle	GDC8	char	NONE	NONE
The title of a supplemental data field that relates to a document number. For example, if your company handles accounts receivables, a possible column heading might be Invoices. This column contains document numbers.
szTypeColumnTitle	GDC9	char	NONE	NONE
This field holds the row heading which will be used to describe the type field.
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.
jdDateUpdated	UPMJ	JDEDATE	NONE	NONE
The date that specifies the last update to the file record.
mnTimeOfDay	TDAY	MATH_NUMERIC	NONE	NONE
The computer clock in hours:minutes:seconds.
szWorkStationID	JOBN	char	NONE	NONE
The code that identifies the work station ID that executed a particular job.
cSuppressErrorMessages	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	NONE	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

Related Functions

None

Related Tables

F48090 WO Supplemental Data Types