N44H0014_RetrieveExtendedData

N44H0014 - Retrieve Extended Data Values

Minor Business Rule

Object Name: N44H0014

Parent DLL: CAEC

Location: Client/Server

Language: NER

Data Structure

D44H0014 - N44H0014 - Retrieve Extended Data Values

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szDataType_SDTYP	SDTYP	char	REQ	INPUT
A code used to group data into logical groups. For example, homebuilder sales data groups can be created for loan tracking or for buyer. Valid values include: AR Area CO Community PH Phase LT Lot SL Sale OP Option PL Plan
szDataKey_SDKY	SDKY	char	REQ	INPUT
A code that is used to categorize data for an extended data type into logical groups. For example, the Sales data type (SL) might have extended data keys defined for loan tracking and buyer demographics. This information is stored in the Extended Homebuilder Data table (F44H0929).
mnLineNumber_SDLIN	SDLIN	MATH_NUMERIC	REQ	INPUT
The line number on a line item. This information is stored in the Extended Homebuilder Data table (F44H092).
cProgrammerMode_EV01	EV01	char	REQ	INPUT
An option that specifies the type of processing for an event.
szArea_HBAREA	HBAREA	char	OPT	INPUT
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.
szCommunity_HBMCUS	HBMCUS	char	OPT	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.
szPhase_CPHASE	CPHASE	char	OPT	INPUT
A code that indicates the number of a specific phase within a community.
szPlan_HBPLAN	HBPLAN	char	OPT	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.
szElev_HBELEV	HBELEV	char	OPT	INPUT
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.
szOptionNumber	OPTION	char	OPT	INPUT
A specific upgrade not included in the base house price and cost. In the General Accounting and Job Cost systems, this field corresponds to the subledger field, for example, Subledger Type X.
szLot_HBLOT	HBLOT	char	OPT	INPUT
The specific lot upon which the home will be constructed.
szSaleNumber_CSSEQ	CSSEQ	char	OPT	INPUT
A code that indicates the order in which a lot sells within a community.
szDescription_SDDSC	SDDSC	char	OPT	OUTPUT
The description associated with the supplemental data line SDLIN.
jdDate1_SDDT1	SDDT1	JDEDATE	OPT	OUTPUT
The date on a line item for extended homebuilder data. This information is stored in the Extended Homebuilder Data table (F44H092).
jdDate2_SDDT2	SDDT2	JDEDATE	OPT	OUTPUT
The date on a line item for extended homebuilder data. This information is stored in the Extended Homebuilder Data table (F44H092).
jdDate3_SDDT3	SDDT3	JDEDATE	OPT	OUTPUT
A date that is stored in the Extended Homebuilder Data table (F44H0929).
mnAmount1_SDAMT1	SDAMT1	MATH_NUMERIC	OPT	OUTPUT
A code that represents the amount on a line item. This information is stored in the Extended Homebuilder Data table (F44H092).
mnAmount2_SDAMT2	SDAMT2	MATH_NUMERIC	OPT	OUTPUT
A value that represents the amount on a line item. This information is stored in the Extended Homebuilder Data table (F44H092).
mnAmount3_SDAMT3	SDAMT3	MATH_NUMERIC	OPT	OUTPUT
An amount that is stored in the Extended Homebuilder Data table (F44H0929).
mnNumber1_SDNM1	SDNM1	MATH_NUMERIC	OPT	OUTPUT
A number on a line item. This information is stored in the Extended Homebuilder Data table (F44H092).
mnNumber2_SDNM2	SDNM2	MATH_NUMERIC	OPT	OUTPUT
A number on a line item. This information is stored in the Extended Homebuilder Data table (F44H092).
mnNumber3_SDNM3	SDNM3	MATH_NUMERIC	OPT	OUTPUT
A number that is stored in the Extended Homebuilder Data table (F44H0929).
szMemo1_SDMO1	SDMO1	char	OPT	OUTPUT
An informational field for a memo on a line item. This information is stored in the Extended Homebuilder Data table (F44H092).
szMemo2_SDMO2	SDMO2	char	OPT	OUTPUT
An informational field for a memo on a line item. This information is stored in the Extended Homebuilder Data table (F44H092).
szMemo3_SDMO3	SDMO3	char	OPT	OUTPUT
A memo that is stored in the Extended Homebuilder Data table (F44H0929).
mnAddressBook1_SDAB1	SDAB1	MATH_NUMERIC	OPT	OUTPUT
A code that specifies the address book number on a line item. This information is stored in the Extended Homebuilder Data table (F44H092).
mnAddressBook2_SDAB2	SDAB2	MATH_NUMERIC	OPT	OUTPUT
A code that indicates the address book number on a line item. This information is stored in the Extended Homebuilder Data table (F44H092).
mnAddressBook3_SDAB3	SDAB3	MATH_NUMERIC	OPT	OUTPUT
The address book number that is stored in the Extended Homebuilder Data (F44H0929) table.
szText_SDTXT	SDTXT	char	OPT	OUTPUT
An informational text field on a line item. This information is stored in the Extended Homebuilder Data table (F44H092).
szProductModel	PRODM	char	OPT	OUTPUT
A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax.
szProductFamily	PRODF	char	OPT	OUTPUT
A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax.
cErrorFlag_EV01	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
szErrorMessage_DTAI	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.
cTemplateLevel_EDTLVL	EDTLVL	char	OPT	OUTPUT
A code that specifies the template key that is used to create values in the Extended Homebuilder Data table (F44H0929). Valid values are: 1 Specific area and community 2 Specific area and wildcard community 3 Wildcard area and community
cExtendedDataUpdateFlag	EDUPDF	char	OPT	OUTPUT
A code that indicates whether data has been entered into an extended data line in the Extended Homebuilder Data table (F44H0929).

Related Functions

None

Related Tables

None