F31B12AddUpdateRecord

F31B12 File Server

Minor Business Rule

Object Name: N31B1270

Parent DLL: CWIM

Location: Client/Server

Language: NER

Data Structure

D31B1270A - F31B12 File Server

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szWorkAreaCode	WAID	char	OPT	NONE
The identification for a Work Area within the Winery.
szWorkAreaName	WANA	char	OPT	NONE
A name that identifies a work Area.
szCostCenter	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 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.
szWineryID	WID	char	OPT	NONE
The identification for a Winery on a transaction.
cProcessMode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
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.
cWorkAreaStatus	WAST	char	OPT	NONE
A code that indicates whether the Work Area is active or inactive. Values are: A Work Area is active. I Work Area is inactive.
szWorkAreaCatCode01	WAC1	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A1. Use these codes to identify Work Area categories.
szWorkAreaCatCode02	WAC2	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A2. Use these codes to identify Work Area categories.
szWorkAreaCatCode03	WAC3	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A3. Use these codes to identify Work Area categories.
szWorkAreaCatCode04	WAC4	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A4. Use these codes to identify Work Area categories.
szWorkAreaCatCode05	WAC5	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A5. Use these codes to identify Work Area categories.
szWorkAreaCapacity01	WACP1	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity02	WACP2	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity03	WACP3	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity04	WACP4	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity05	WACP5	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity06	WACP6	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity07	WACP7	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity08	WACP8	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity09	WACP9	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity10	WACP10	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szUserId	USER	char	OPT	NONE
The code that identifies a user profile.
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.
szWorkStationId	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.
jdDateUpdated	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
mnTimeLastUpdated	UPMT	MATH_NUMERIC	OPT	NONE
The time that specifies when the program executed the last update to this record.

Related Functions

None

Related Tables

None

F31B12DeleteRecord

F31B12 File Server

Minor Business Rule

Object Name: N31B1270

Parent DLL: CWIM

Location: Client/Server

Language: NER

Data Structure

D31B1270A - F31B12 File Server

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szWorkAreaCode	WAID	char	OPT	NONE
The identification for a Work Area within the Winery.
szWorkAreaName	WANA	char	OPT	NONE
A name that identifies a work Area.
szCostCenter	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 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.
szWineryID	WID	char	OPT	NONE
The identification for a Winery on a transaction.
cProcessMode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
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.
cWorkAreaStatus	WAST	char	OPT	NONE
A code that indicates whether the Work Area is active or inactive. Values are: A Work Area is active. I Work Area is inactive.
szWorkAreaCatCode01	WAC1	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A1. Use these codes to identify Work Area categories.
szWorkAreaCatCode02	WAC2	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A2. Use these codes to identify Work Area categories.
szWorkAreaCatCode03	WAC3	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A3. Use these codes to identify Work Area categories.
szWorkAreaCatCode04	WAC4	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A4. Use these codes to identify Work Area categories.
szWorkAreaCatCode05	WAC5	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A5. Use these codes to identify Work Area categories.
szWorkAreaCapacity01	WACP1	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity02	WACP2	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity03	WACP3	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity04	WACP4	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity05	WACP5	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity06	WACP6	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity07	WACP7	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity08	WACP8	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity09	WACP9	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity10	WACP10	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szUserId	USER	char	OPT	NONE
The code that identifies a user profile.
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.
szWorkStationId	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.
jdDateUpdated	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
mnTimeLastUpdated	UPMT	MATH_NUMERIC	OPT	NONE
The time that specifies when the program executed the last update to this record.

Related Functions

None

Related Tables

None

F31B12RetrieveRecord

F31B12 File Server

Minor Business Rule

Object Name: N31B1270

Parent DLL: CWIM

Location: Client/Server

Language: NER

Data Structure

D31B1270A - F31B12 File Server

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szWorkAreaCode	WAID	char	OPT	NONE
The identification for a Work Area within the Winery.
szWorkAreaName	WANA	char	OPT	NONE
A name that identifies a work Area.
szCostCenter	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 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.
szWineryID	WID	char	OPT	NONE
The identification for a Winery on a transaction.
cProcessMode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
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.
cWorkAreaStatus	WAST	char	OPT	NONE
A code that indicates whether the Work Area is active or inactive. Values are: A Work Area is active. I Work Area is inactive.
szWorkAreaCatCode01	WAC1	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A1. Use these codes to identify Work Area categories.
szWorkAreaCatCode02	WAC2	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A2. Use these codes to identify Work Area categories.
szWorkAreaCatCode03	WAC3	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A3. Use these codes to identify Work Area categories.
szWorkAreaCatCode04	WAC4	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A4. Use these codes to identify Work Area categories.
szWorkAreaCatCode05	WAC5	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A5. Use these codes to identify Work Area categories.
szWorkAreaCapacity01	WACP1	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity02	WACP2	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity03	WACP3	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity04	WACP4	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity05	WACP5	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity06	WACP6	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity07	WACP7	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity08	WACP8	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity09	WACP9	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity10	WACP10	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szUserId	USER	char	OPT	NONE
The code that identifies a user profile.
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.
szWorkStationId	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.
jdDateUpdated	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
mnTimeLastUpdated	UPMT	MATH_NUMERIC	OPT	NONE
The time that specifies when the program executed the last update to this record.

Related Functions

None

Related Tables

None

F31B12ValidateWorkArea

F31B12 File Server

Minor Business Rule

Object Name: N31B1270

Parent DLL: CWIM

Location: Client/Server

Language: NER

Data Structure

D31B1270A - F31B12 File Server

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szWorkAreaCode	WAID	char	OPT	NONE
The identification for a Work Area within the Winery.
szWorkAreaName	WANA	char	OPT	NONE
A name that identifies a work Area.
szCostCenter	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 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.
szWineryID	WID	char	OPT	NONE
The identification for a Winery on a transaction.
cProcessMode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
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.
cWorkAreaStatus	WAST	char	OPT	NONE
A code that indicates whether the Work Area is active or inactive. Values are: A Work Area is active. I Work Area is inactive.
szWorkAreaCatCode01	WAC1	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A1. Use these codes to identify Work Area categories.
szWorkAreaCatCode02	WAC2	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A2. Use these codes to identify Work Area categories.
szWorkAreaCatCode03	WAC3	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A3. Use these codes to identify Work Area categories.
szWorkAreaCatCode04	WAC4	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A4. Use these codes to identify Work Area categories.
szWorkAreaCatCode05	WAC5	char	OPT	NONE
A set of user definable category codes (1 - 5) that are pre-defined in UDC 31B/A5. Use these codes to identify Work Area categories.
szWorkAreaCapacity01	WACP1	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity02	WACP2	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity03	WACP3	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity04	WACP4	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity05	WACP5	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity06	WACP6	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity07	WACP7	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity08	WACP8	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity09	WACP9	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szWorkAreaCapacity10	WACP10	char	OPT	NONE
User Defined Capacity values (1-10) that are used to identify various capacity details for a Work Area.
szUserId	USER	char	OPT	NONE
The code that identifies a user profile.
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.
szWorkStationId	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.
jdDateUpdated	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
mnTimeLastUpdated	UPMT	MATH_NUMERIC	OPT	NONE
The time that specifies when the program executed the last update to this record.

Related Functions

None

Related Tables

None