A.3 Table: m_quote_details, Package: m_api_qd - Intergraph Smart Materials - Version 2020 (10.0) - Customization & Programming - Hexagon

Intergraph Smart Materials Classic API Configuration (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
2020 (10.0)

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

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.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