F44H301GetPlanMasterInfo

F44H301 Get Plan Master Information

Minor Business Rule

Object Name: N44H0001

Parent DLL: CAEC

Location: Client/Server

Language: NER

Data Structure

D44H0001 - F44H301 Get Plan Master Information

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cActionMode	ACTN	char	REQ	INPUT
A code that specifies the action that is performed. Valid values are: A Add C Change
cSuppressErrorMessage	SUPPS	char	OPT	INPUT
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function. 0 = allow runtime error message handling. 1 = suppress runtime error message handling.
cFoundFlagEV01	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
szErrorMessageId	DTAI	char	OPT	OUTPUT
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.
szCommunity	HBMCUS	char	REQ	INPUT
A value that specifies a community, project, or subdivision. A community is a distinct grouping of lots which can be grouped together through user-defined specifications, for example, product offering, geography, and so on. A subset of the builder's plans and options are typically included within a community.
szPhaseNumber	CPHASE	char	REQ	INPUT
A code that indicates the number of a specific phase within a community.
szPlan	HBPLAN	char	REQ	INPUT
A value that specifies a plan within a community. A plan represents an architectural design based on an arrangement, location and size of rooms in a house.
szElevation	HBELEV	char	OPT	NONE
A value that specifies the type of elevation used on a lot. When a unit is built on a lot, the lot is identified by plan, elevation, and swing. A plan represents an architectural design based on an arrangement, a location, and the size of rooms in a house. The same plan typically will have a varied facade or exterior look, or elevation.
szHomeBuilderArea	HBAREA	char	OPT	NONE
A component, typically a company division or geographic region, that is larger than a community. Large homebuilders might have many areas within their organizational structure. Smaller, regional builders might operate their entire organization using a single area.
mnAmountBasePrice	BSP	MATH_NUMERIC	OPT	OUTPUT
The base price of a house. The base price is enter in the Plan master file and will default into the Lot Proceed file.
mnAmountBasePricePrevious	BPP	MATH_NUMERIC	OPT	OUTPUT
Previous Base house price. This field should be manually entered when a change occurs to the Base house price field in the Plan Master file.
jdSalesPriceEffectiveDate	SPJ	JDEDATE	OPT	OUTPUT
Used in Option selection to determine if the current sales price is used or the previous sales price is used.
jdEXPIRATIONDATE	EXDE	JDEDATE	OPT	OUTPUT
The date on which the employee's professional license expires.
szTemplateJob	MCUTJ	char	OPT	OUTPUT
A code that indicates the job or business unit from which the account master records for a lot are copied.
szScheduleTemplate	SCHTMPT	char	OPT	OUTPUT
A code that specifies the schedule template for use by a third party scheduling system.
szDescription001	DL01	char	OPT	OUTPUT
A user defined name or remark.
szDescription01002	DL02	char	OPT	OUTPUT
Additional text that further describes or clarifies a field in the system.
szDescription01003	DL03	char	OPT	OUTPUT
Additional text that further describes or clarifies an element.
szPlanMasterProductType	PMPT	char	OPT	OUTPUT
A user defined category code (44H3/PT) used to classify plans by product type. Examples are Single Family Detached (SFD) or Multi Family Attached (MFA).
szPlanMasterProductGroup	PMPG	char	OPT	OUTPUT
A code used to classify plans by group. For example, you can group plans as single-story plans or two-story plans.
mnSquareFeet	SQFEET	MATH_NUMERIC	OPT	OUTPUT
A value that represents the square footage of the plan assigned to a community. This measurement can be used in the lot (job) to allow for calculations of costs and revenue per square feet in the Project Management system.
szDescriptionLine1	DSC1	char	OPT	OUTPUT
Brief information about an item; a remark or an explanation.
szDescriptionLine2	DSC2	char	OPT	OUTPUT
A second, 30-character description, remark, or explanation.
mnPlanMix	PLNMX	MATH_NUMERIC	OPT	OUTPUT
The number of individual units of the same plan that are projected to be built within a community.
mnPlanMixRelease	PLNMXRL	MATH_NUMERIC	OPT	OUTPUT
The number of individual units of a plan released in a community.
mnAmountEstimatedDiscount1	ESTDISC1	MATH_NUMERIC	OPT	OUTPUT
The estimated average discount or incentive for each sale.
mnAmountEstimatedDiscount2	ESTDISC2	MATH_NUMERIC	OPT	OUTPUT
The estimated average discount or incentive for each sale.
mnAmountEstimatedDiscount3	ESTDISC3	MATH_NUMERIC	OPT	OUTPUT
The estimated average discount or incentive for each sale.
mnPercentOptionMargin1	OPTMGN1	MATH_NUMERIC	OPT	OUTPUT
A value that is used to calculate profitability from options. Enter the percent of revenue assumed to be profit. Enter each percentage as a whole number, for example, enter 40% at 40.
mnPercentOptionMargin2	OPTMGN2	MATH_NUMERIC	OPT	OUTPUT
A value that is used to calculate profitability from options. Enter the percent of revenue assumed to be profit. Enter each percentage as a whole number, for example, enter 40% at 40.
mnPercentOptionMargin3	OPTMGN3	MATH_NUMERIC	OPT	OUTPUT
A value that is used to calculate profitability from options. Enter the percent of revenue assumed to be profit. Enter each percentage as a whole number, for example, enter 40% at 40.
mnPercentOptionMargin4	OPTMGN4	MATH_NUMERIC	OPT	OUTPUT
A value that is used to calculate profitability from options. Enter the percent of revenue assumed to be profit. Enter each percentage as a whole number, for example, enter 40% at 40.
mnPercentOptionMargin5	OPTMGN5	MATH_NUMERIC	OPT	OUTPUT
A value that is used to calculate profitability from options. Enter the percent of revenue assumed to be profit. Enter each percentage as a whole number, for example, enter 40% at 40.
mnAmountEstimatedOptionRev	ESTOPR1	MATH_NUMERIC	OPT	OUTPUT
The estimated revenue from the first category of option sales.
mnAmountEstimatedOptionRev_2	ESTOPR2	MATH_NUMERIC	OPT	OUTPUT
The estimated revenue from the second category of option sales.
mnAmountEstimatedOptionRev_3	ESTOPR3	MATH_NUMERIC	OPT	OUTPUT
The estimated revenue from the third category of option sales.
mnAmountEstimatedOptionRev_4	ESTOPR4	MATH_NUMERIC	OPT	OUTPUT
The estimated revenue from the fourth category of option sales.
mnAmountEstimatedOptionRev_5	ESTOPR5	MATH_NUMERIC	OPT	OUTPUT
The estimated revenue from the fifth category of option sales.
mnAmountEstimatedOptionInc	ESTOPIN	MATH_NUMERIC	OPT	OUTPUT
The estimated option incentive that is given to the buyer. This value is stored in the Lot Sales History table (F44H501H) and is used to calculate the net option price.
mnAmountEstimatedPlanCost	ESTPLANC	MATH_NUMERIC	OPT	OUTPUT
The estimated construction cost. This value is typically exclusive of all land and other allocated costs.
mnAverageOtherCost01	CSTAMT01	MATH_NUMERIC	OPT	OUTPUT
A value that indicates an average cost. You can manually enter a value in this field, or the system completes it based on the values in the Total Revenue (Other Cost) and Plan Mix fields if you enter a value in the corresponding Average Cost Percentage field on the Lot Override Percentages tab. For example, a value in Average Cost Percentage 01 updates Average Other Cost 01. You cannot enter a value in both the Average Other Cost field and the corresponding Ext Other Cost field, for example, Average Other Cost 02 and Ext Other Cost 02.
mnAverageOtherCost02	CSTAMT02	MATH_NUMERIC	OPT	OUTPUT
A value that indicates an average cost. You can manually enter a value in this field, or the system completes it based on the values in the Total Revenue (Other Cost) and Plan Mix fields if you enter a value in the corresponding Average Cost Percentage field on the Lot Override Percentages tab. For example, a value in Average Cost Percentage 01 updates Average Other Cost 01. You cannot enter a value in both the Average Other Cost field and the corresponding Ext Other Cost field, for example, Average Other Cost 02 and Ext Other Cost 02.
mnAverageOtherCost03	CSTAMT03	MATH_NUMERIC	OPT	OUTPUT
A value that indicates an average cost. You can manually enter a value in this field, or the system completes it based on the values in the Total Revenue (Other Cost) and Plan Mix fields if you enter a value in the corresponding Average Cost Percentage field on the Lot Override Percentages tab. For example, a value in Average Cost Percentage 01 updates Average Other Cost 01. You cannot enter a value in both the Average Other Cost field and the corresponding Ext Other Cost field, for example, Average Other Cost 02 and Ext Other Cost 02.
mnAverageOtherCost04	CSTAMT04	MATH_NUMERIC	OPT	OUTPUT
A value that indicates an average cost. You can manually enter a value in this field, or the system completes it based on the values in the Total Revenue (Other Cost) and Plan Mix fields if you enter a value in the corresponding Average Cost Percentage field on the Lot Override Percentages tab. For example, a value in Average Cost Percentage 01 updates Average Other Cost 01. You cannot enter a value in both the Average Other Cost field and the corresponding Ext Other Cost field, for example, Average Other Cost 02 and Ext Other Cost 02.
mnAverageOtherCost05	CSTAMT05	MATH_NUMERIC	OPT	OUTPUT
A value that indicates an average cost. You can manually enter a value in this field, or the system completes it based on the values in the Total Revenue (Other Cost) and Plan Mix fields if you enter a value in the corresponding Average Cost Percentage field on the Lot Override Percentages tab. For example, a value in Average Cost Percentage 01 updates Average Other Cost 01. You cannot enter a value in both the Average Other Cost and the corresponding Ext Other Cost field, for example, Average Other Cost 02 and Ext Other Cost 02.
mnAverageOtherCost06	CSTAMT06	MATH_NUMERIC	OPT	OUTPUT
A value that indicates an average cost. You can manually enter a value in this field, or the system completes it based on the values in the Total Revenue (Other Cost) and Plan Mix fields if you enter a value in the corresponding Average Cost Percentage field on the Lot Override Percentages tab. For example, a value in Average Cost Percentage 01 updates Average Other Cost 01. You cannot enter a value in both the Average Other Cost field and the corresponding Ext Other Cost field, for example, Average Other Cost 02 and Ext Other Cost 02.
mnAverageOtherCost07	CSTAMT07	MATH_NUMERIC	OPT	OUTPUT
A value that indicates an average cost. You can manually enter a value in this field, or the system completes it based on the values in the Total Revenue (Other Cost) and Plan Mix fields if you enter a value in the corresponding Average Cost Percentage field on the Lot Override Percentages tab. For example, a value in Average Cost Percentage 01 updates Average Other Cost 01. You cannot enter a value in both the Average Other Cost field and the corresponding Ext Other Cost field, for example, Average Other Cost 02 and Ext Other Cost 02.
mnAverageOtherCost08	CSTAMT08	MATH_NUMERIC	OPT	OUTPUT
A value that indicates an average cost. You can manually enter a value in this field, or the system completes it based on the values in the Total Revenue (Other Cost) and Plan Mix fields if you enter a value in the corresponding Average Cost Percentage field on the Lot Override Percentages tab. For example, a value in Average Cost Percentage 01 updates Average Other Cost 01. You cannot enter a value in both the Average Other Cost field and the corresponding Ext Other Cost field, for example, Average Other Cost 02 and Ext Other Cost 02.
mnAverageOtherCost09	CSTAMT09	MATH_NUMERIC	OPT	OUTPUT
A value that indicates an average cost. You can manually enter a value in this field, or the system completes it based on the values in the Total Revenue (Other Cost) and Plan Mix fields if you enter a value in the corresponding Average Cost Percentage field on the Lot Override Percentages tab. For example, a value in Average Cost Percentage 01 updates Average Other Cost 01. You cannot enter a value in both the Average Other Cost field and the corresponding Ext Other Cost field, for example, Average Other Cost 02 and Ext Other Cost 02.
mnAverageOtherCost10	CSTAMT10	MATH_NUMERIC	OPT	OUTPUT
A value that indicates an average cost. You can manually enter a value in this field, or the system completes it based on the values in the Total Revenue (Other Cost) and Plan Mix fields if you enter a value in the corresponding Average Cost Percentage field on the Lot Override Percentages tab. For example, a value in Average Cost Percentage 01 updates Average Other Cost 01. You cannot enter a value in both the Average Other Cost and the corresponding Ext Other Cost field, for example, Average Other Cost 02 and Ext Other Cost 02.
mnEstimatedWeeklySales	ESTWKSL	MATH_NUMERIC	OPT	OUTPUT
The estimated absorption rate per week.
szPlanCategory01	PLC01	char	OPT	OUTPUT
A user defined category code (44H3/01) that updates the Plan Master table (F44H301).
szPlanCategory02	PLC02	char	OPT	OUTPUT
A user defined category code (44H3/02) that updates the Plan Master table (F44H301).
szPlanCategory03	PLC03	char	OPT	OUTPUT
A user defined category code (44H3/03) that updates the Plan Master table (F44H301).
szPlanCategory04	PLC04	char	OPT	OUTPUT
A user defined category code (44H3/04) that updates the Plan Master table (F44H301).
szPlanCategory05	PLC05	char	OPT	OUTPUT
A user defined category code (44H3/05) that updates the Plan Master table (F44H301).
szPlanCategory06	PLC06	char	OPT	OUTPUT
A user defined category code (44H3/06) that updates the Plan Master table (F44H301).
szPlanCategory07	PLC07	char	OPT	OUTPUT
A user defined category code (44H3/07) that updates the Plan Master table (F44H301).
szPlanCategory08	PLC08	char	OPT	OUTPUT
A user defined category code (44H3/08) that updates the Plan Master table (F44H301).
szPlanCategory09	PLC09	char	OPT	OUTPUT
A user defined category code (44H3/09) that updates the Plan Master table (F44H301).
szPlanCategory10	PLC10	char	OPT	OUTPUT
A user defined category code (44H3/10) that updates the Plan Master table (F44H301).
szPlanCategory11	PLC11	char	OPT	OUTPUT
A user defined category code (44H3/11) that updates the Plan Master table (F44H301).
szPlanCategory12	PLC12	char	OPT	OUTPUT
A user defined category code (44H3/12) that updates the Plan Master table (F44H301).
szPlanCategory13	PLC13	char	OPT	OUTPUT
A user defined category code (44H/13) that updates the Plan Master table (F44H301).
szPlanCategory14	PLC14	char	OPT	OUTPUT
A user defined category code (44H3/14) that updates the Plan Master table (F44H301).
szPlanCategory15	PLC15	char	OPT	OUTPUT
A user defined category code (44H3/15) that updates the Plan Master table (F44H301).
jdUserDate1	USD1	JDEDATE	OPT	OUTPUT
User defined Julian Date 1.
jdUserDate2	USD2	JDEDATE	OPT	OUTPUT
User defined Julian Date 2.
jdUserDate3	USD3	JDEDATE	OPT	OUTPUT
A Julian date.
jdUserDate4	USD4	JDEDATE	OPT	OUTPUT
A Julian date.
jdUserDate5	USD5	JDEDATE	OPT	OUTPUT

szCreatedByUser	CRTU	char	OPT	OUTPUT
The address book number of the user who created this record.
jdDateCreated	CRTJ	JDEDATE	OPT	OUTPUT
A code that indicates the date on which the record was created.
mnTimeCreated	CRTT	MATH_NUMERIC	OPT	OUTPUT
A code that specifies the time when the record was created.
szOriginalWorkStationId	WRKSTNID	char	OPT	OUTPUT
The identification number of the workstation on which the expense report was entered.
szUpdatedByUser	UPMB	char	OPT	OUTPUT
The User I.D. of the individual who replaced or changed one or more values in this record. Captured by the subject program automatically.
jdDateUpdated	UPMJ	JDEDATE	OPT	OUTPUT
The date that specifies the last update to the file record.
mnTimeLastUpdated	UPMT	MATH_NUMERIC	OPT	OUTPUT
The time that specifies when the program executed the last update to this record.
szWorkStationId	JOBN	char	OPT	OUTPUT
The code that identifies the work station ID that executed a particular job.
szProgramId	PID	char	OPT	OUTPUT
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.
szOriginalProgramId	HBOPID	char	OPT	OUTPUT

Related Functions

None

Related Tables

None