A.3 Table: m_quote_details, Package: m_api_qd - Intergraph Smart Materials - Version 10.3 - Customization & Programming

A.3.1 Procedure: upd_qd

Argument Name	Type	In/Out
P_US_ID	NUMBER(12)	IN
P_QD_ID	NUMBER(12)	IN
P_COL_ARR	RECORD	IN
COL_NAME	TABLE OF VARCHAR2(255)	IN
COL_VALUE	TABLE OF VARCHAR2(255)	IN
P_RESULT	VARCHAR2	OUT
P_COMMIT_IND	VARCHAR2	IN; DEFAULT ‘Y’
P_EXCEL_IND	VARCHAR2	IN; DEFAULT ‘N’

Argument p_excel_ind is not used outside Smart Materials. This argument can either be left out, or filled in with the default value. It is only implemented for use of the package from inside Smart Materials.

Column Name	Prompt on P.30.22	Allowable values
CATALOG_NUMBER	Catalog Number
CURRENCY_CODE	Currency	All units in the ‘currency’ unit group
CY_CODE	Ctry of Origin	All countries defined on A.10.34
DISCOUNT_AMOUNT	Discount Amount	0 – 999999999.9999
DISCOUNT_BASE	Discount Base	‘A’, ‘P’
DISCOUNT_PERCENT	Discount %	0 – 999.99
EXPORT_LICENSE_NUMBER	Export License Number
EXPORT_LICENSE_REQ_IND	Exp Lic Req	‘Y’, ‘N’; the default depends on the ZP_EXPLICR project default
FIRST_SHIP	First Ship	0 – 99
FREIGHT_VALUE	Delivery Place
FRT_CODE	Incoterm	All incoterms defined on P.10.34
INSTALL_PRICE	Install Price	0 – 999999999.9999
LAST_SHIP	Last Ship	0 – 99
LAST_SHIP_DATE	Last Ship Date	Any valid date
MANUFACTURER	Manufacturer
MODIFICATION_PRICE	Modification Price	0 – 999999999.9999
PACKING_DIMENSIONS	Packing Dimensions
PACKING_PRICE	Packing Price	0 – 999999999.9999
PACKING_VOLUME	Packing Volume	0 – 999999999.999
PERCENT_DOMESTIC_PROD	% Dom. Prod.	0 – 100
PRICE_BASE	Price Base	‘Q’, ‘W’
QD_UNIT_PRICE	Unit Price	0 – 999999999.9999
QD_UNIT_WEIGHT	Unit Weight	0 – 999999999999.999
QTY_CODE	Quantity Unit	All units in the ‘quantity’, ‘volume’, and ‘weight’ unit groups
QUOTED_QTY	Quoted Quantity	0 – 999999999999.999
REQ_DELV_DATE	Req Delivery Date	Any valid date
RESTOCKING_PERCENT	Restocking %	0 – 999.99
RESTOCKING_PRICE	Restocking Price	0 – 999999999.9999
SUPPLY_PRICE	Supply Price	0 – 999999999.9999
UNIT_PRICE_TYPE	Unit Price Type	NULL, ‘I’, ‘E’, ‘Q’, ‘R’
VOL_CODE	Volume Unit	All units in the ‘volume’ unit group
WEIGHT_CODE	Weight Unit	All units in the ‘weight’ unit group

IDENT_DEV: Passing this column to the procedure, the software checks whether the ZP_DEVATTR project default is set to a valid value. If so, the attribute determined by the project default is either attached to the quote detail (with the value passed to the procedure) or, if already assigned, its value is overridden by the value passed to the procedure.

A.3.2 Procedure: ins_qd

This procedure is to be used for inserting splits and alternates.

Argument Name	Type	In/Out
P_US_ID	NUMBER(12)	IN
P_QD_ID	NUMBER(12)	IN
P_COL_ARR	RECORD	IN
COL_NAME	TABLE OF VARCHAR2(255)	IN
COL_VALUE	TABLE OF VARCHAR2(255)	IN
P_RESULT	VARCHAR2	OUT
P_COMMIT_IND	VARCHAR2	IN; DEFAULT ‘Y’

P_QD_ID is the quote detail for which a split or alternate is to be inserted.

Column Name	Prompt in P.30.22	Allowable values
ALTERNATE_NUMBER	Alt	0 – 9; default 0
CATALOG_NUMBER	Catalog Number
CURRENCY_CODE	Currency	All units in the ‘currency’ unit group
CY_CODE	Ctry of Origin	All countries defined on A.10.34
DISCOUNT_AMOUNT	Discount Amount	0 – 999999999.9999; default 0
DISCOUNT_BASE	Discount Base	‘A’, ‘P’
DISCOUNT_PERCENT	Discount %	0 – 999.99; default 0
EXPORT_LICENSE_NUMBER	Export License Number
EXPORT_LICENSE_REQ_IND	Exp Lic Req	‘Y’, ‘N’; the default depends on the ZP_EXPLICR project default
FIRST_SHIP	First Ship	0 – 99; default 0
FREIGHT_VALUE	Delivery Place
FRT_CODE	Incoterm	All incoterms defined on P.10.34
INSTALL_PRICE	Install Price	0 – 999999999.9999; default 0
LAST_SHIP	Last Ship	0 – 99; default 0
LAST_SHIP_DATE	Last Ship Date	Any valid date
MANUFACTURER	Manufacturer
MODIFICATION_PRICE	Modification Price	0 – 999999999.9999; default 0
PACKING_DIMENSIONS	Packing Dimensions
PACKING_PRICE	Packing Price	0 – 999999999.9999; default 0
PACKING_VOLUME	Packing Volume	0 – 999999999.999; default 0
PERCENT_DOMESTIC_PROD	% Dom. Prod.	0 – 100; the default is 0 or 100, depending on the ZP_EXPLICR project default
PRICE_BASE	Price Base	‘Q’, ‘W’
QD_UNIT_PRICE	Unit Price	0 – 999999999.9999
QD_UNIT_WEIGHT	Unit Weight	0 – 999999999999.999
QTY_CODE	Quantity Unit	All units in the ‘quantity’, ‘volume’, and ‘weight’ unit groups
QUOTED_QTY	Quoted Quantity	0 – 999999999999.999
REQ_DELV_DATE	Req Delivery Date	Any valid date
RESTOCKING_PERCENT	Restocking %	0 – 999.99; default 0
RESTOCKING_PRICE	Restocking Price	0 – 999999999.9999; default 0
SPLIT_QD_SEQ	Split Seq	0 – 99999
SUPPLY_PRICE	Supply Price	0 – 999999999.9999; default 0
UNIT_PRICE_TYPE	Unit Price Type	NULL, ‘I’, ‘E’, ‘Q’, ‘R’
VOL_CODE	Volume Unit	All units in the ‘volume’ unit group
WEIGHT_CODE	Weight Unit	All units in the ‘weight’ unit group

A.3.3 Procedure: ins_detail_qd

This procedure is used to create a detail tag for a tagged item (functionality is provided in the procurement, expediting, traffic, and site screens through the ‘Split Tag’ button).

A detail tag can only be created for a quote detail if the following conditions are met:

The item rule of the item type of the ident on this quote detail is ‘TAB’, ‘TFM’, ‘TOM’, ‘TWM’, or ‘SWT’.
The tag number is unlike ‘---‘ and unlike ‘UNTAGGED’.
The quote detail is not a detail tag.
Alternates are not yet created.
Splits are not yet created.

To create a detail tag using this procedure, you must be connected to the project in which you want to create the split.

The p_qd_id parameter must be filled with the primary key of the quote detail that represents the master tag.

The p_new_qd_id and p_new_qd_id2 parameters contain the primary keys of the newly created quote details (detail tags).

Argument Name	Type	In/Out
P_US_ID	NUMBER(12)	IN
P_QD_ID	NUMBER(12)	IN
P_RESULT	VARCHAR2	OUT
P_COMMIT_IND	VARCHAR2	IN; DEFAULT ‘Y’
P_NEW_QD_ID	NUMBER(12)	OUT
P_NEW_QD_ID2	NUMBER(12)	OUT

A.3 Table: m_quote_details, Package: m_api_qd - Intergraph Smart Materials - Version 10.3 - Customization & Programming - Hexagon

Intergraph Smart Materials Classic API Configuration (10.3)