To create a new supplier, enter all mandatory values.
The arguments of the INS_SUP procedure are listed below.
Argument Name |
Type |
In/Out |
---|---|---|
P_US_ID |
NUMBER, m_user_securities.us_id |
IN |
P_COL_ARR |
RECORD |
IN |
P_RESULT |
VARCHAR2 |
OUT |
P_SUP_ID |
NUMBER, m_suppliers.sup_id |
OUT |
P_COMMIT_IND |
VARCHAR2, default ‘Y’ |
IN |
The procedure inserts a record into m_suppliers.
The following table shows the values that can be transferred with P_COL_ARR in the INS_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) |