Update Suppliers - Intergraph Smart Materials - Version 10.1 - Customization & Programming - Hexagon

Intergraph Smart Materials Classic API Configuration (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
10.1

To update supplier data, use the UPD_SUP procedure.

The arguments of UPD_SUP are listed below.

Argument Name

Type

In/Out

P_US_ID

NUMBER, m_user_securities.us_id

IN

P_SUP_ID

NUMBER, m_suppliers.sup_id

IN

P_COL_ARR

RECORD

IN

P_RESULT

VARCHAR2

OUT

P_COMMIT_IND

VARCHAR2, default ‘Y’

IN

The procedure calls check routines for all columns to be updated prior to performing the actual update of table m_suppliers. When all checks succeed, the procedure updates a record in m_suppliers.

The following table shows the values that can be updated with the UPD_SUP procedure.

Column Name

Mandatory

Description

SUP_CODE

Yes

Supplier Name (VARCHAR2(20), m_suppliers_sup_code)

COMPANY_CODE

Yes

Company ID (NUMBER(12,0), m_suppliers.company_id)

CT_CODE

Yes

Company Type ID (NUMBER(12,0), m_suppliers.ct_id)

CURRENCY

Yes

Currency ID (NUMBER(12,0), m_suppliers.currency_id)

PO_SALES_LIMIT

Yes

PO Sales Limit (NUMBER(15,4), m_suppliers.po_sales_limit)

EDI_IND

Yes

Use EDI (VARCHAR2(1), m_suppliers.edi_ind)

APPROVED_IND

Yes

Approved (VARCHAR2(1), m_suppliers.approved_ind)

SECRECY_AGREEMENT_IND

Yes

Secrecy Agreement (VARCHAR2(1), m_suppliers.secrecy_agreement_ind)

VRT_CODE

No

Vendor Rating Type (NUMBER(12,0), m_vr_types.vrt_id)

VR_CODE

No

Vendor Rating (NUMBER(12,0), m_suppliers.vr_id)

DTM_CODE

No

Data Transfer Medium ID (NUMBER(12,0), m_suppliers.dtm_id)

CY_CODE

No

Country ID (NUMBER(12,0), m_suppliers.cy_id)

SUPPLIER_ACCOUNT_CODE

No

Budget Code (VARCHAR2(10), m_suppliers.supplier_account_code)

TAX_ID

No

Tax Id (VARCHAR2(40), m_suppliers.tax_id)

COMMERCIAL_REGISTRATION

No

Commercial Registration (VARCHAR2(15), m_suppliers.commercial_registration)

NEAREST_PORT_OF_EXIT

No

Port of Exit (VARCHAR2(30), m_suppliers.nearest_port_of_exit)

APPROVED_DATE

No

Approved Date (DATE, m_suppliers.approved_date)

BID_TARGET

No

Medium Value (VARCHAR2(80), m_suppliers.bid_target)

RFQ_EMAIL_IND

Yes

RFQ Email (VARCHAR2(1), m_suppliers.rfq_email_ind)

ALLOWED_IND

Yes

Allowed for (VARCHAR2(1), m_suppliers.allowed_ind)

PROJECT_SUP

No

Project (VARCHAR2(10), m_suppliers.project_id)