Attachment 9 - Response to Vendor Question #14.docx
DOCX document 26 KB Posted
- Attached to
- EPROCUREMENT SOLUTION State and local contract opportunity
- Solicitation number
- 5400020744
- Issued by
- South Carolina
About this file
This is a Response to Vendor Question #14 document for eProcurement Solicitation 5400020744 in South Carolina, detailing the data structure and fields used in the state's Supplier Relationship Management (SRM) system and its integration with the ECC system. The document specifies the vendor columns required for the eProcurement system, including purchase organization vendor number, tax exempt status, business name, FEIN/SSN, form of business, industry type, contact information, and supply product classifications. The primary focus is the ZMM_SRM_CONTRACT_ITEM_DETAIL data structure, which contains comprehensive contract and item-level information fields necessary for solicitation management and contract administration.
The data structure encompasses 88 distinct fields organized across contract-level, vendor-level, and item-level information, including contract identifiers, transaction types, posting and creation dates, purchase group details with lead buyer information, contract values (target and released), validity periods, parent RFX and bid references, vendor and address data, item descriptions and types, agency codes, material information, delivery timelines, quantities, pricing details (gross and net prices), and version control indicators. The document indicates that SRM contains a substantial volume of additional data fields, with the note that more time would be needed to extract the complete set of fields being utilized in the SRM and ECC integration elements, suggesting this response addresses only the primary contract and item detail structure relevant to the vendor inquiry.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Attachment L.2 - Service Provider Security Assessment Questionna.docx | DOCX document | |
| Solicitation.pdf | ||
| Attachment 8 - Response to Vendor Questions Amend 2.docx | DOCX document | |
| Attachment 3 - Requirements Traceability Matrix.xlsx | XLSX spreadsheet | |
| Attachment 6 - Local Spend.xlsx | XLSX spreadsheet | |
| Amendment #2.pdf | ||
| Award Extension Notice.pdf | ||
| Amendment #1.pdf | ||
| Attachment E - Service Level Agreement.pdf | ||
| Attachment 1 - Higher Education ERP Systems.xlsx | XLSX spreadsheet | |
| Attachment 7 - Purchase Orders (2019).xlsx | XLSX spreadsheet | |
| Attachment 4 Amend 1 - Cost Proposal Workbook.xlsx | XLSX spreadsheet | |
| Award Final Extension Notice.docx | DOCX document | |
| Attachment K - Representations.pdf | ||
| Attachment 5 - Current Active Contracts.xlsm | XLSM spreadsheet | |
| Attachment 2 - Data Flow.pptx | PPTX presentation |
Show all 16
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
eProcurement Solicitation – 5400020744 Attachment 9 – Response to Vendor Question #14
Here are the headings for Vendor Columns:
Purchase Org
Vendor Number
Tax Exempt Status
Business Name
FEIN/SSN
Form Of Business
Industry Type
Contact User Name
Address
City
Country
Region
Postal Code
Requestor First name
Requestor Last name
Requestor Phone#
Requestor User Name
Supply Product(NIGP)
Remit To/Order From
***SRM has a tremendous amount and more time would be needed to pull all the data fields being used in SRM and the ECC integration elements.
Here are the fields for the Contracts- structure from ZMM_SRM_CONTRACT_ITEM_DETAIL
| Field |
| Data Type |
| Length |
| Decimal |
| Desc |
| CONTRACT_NUMBER |
| CHAR |
| 10 |
| 0 |
| CONTRACT_GUID |
| CHAR |
| 32 |
| 0 |
| TRANSACTION_TYPE |
| CHAR |
| 4 |
| 0 |
| TRANSACTION_TYPE_DESC |
| CHAR |
| 20 |
| 0 |
| POSTING_DATE |
| DATS |
| 8 |
| 0 |
| DESCRIPTION |
| CHAR |
| 40 |
| 0 |
| PURCH_GRP_ORG_ID |
| CHAR |
| 14 |
| 0 |
| PURCH_GRP |
| CHAR |
| 3 |
| 0 |
| PURCH_GRP_NAME |
| CHAR |
| 40 |
| 0 |
| PURCH_GRP_LEAD_BUYER_FIRST |
| CHAR |
| 40 |
| 0 |
| PURCH_GRP_LEAD_BUYER_LAST |
| CHAR |
| 40 |
| 0 |
| PURCH_GRP_LEAD_BUYER_EMAIL |
| CHAR |
| 80 |
| 0 |
| CREATED_DATE |
| DATS |
| 8 |
| 0 |
| CREATED_TIME |
| TIMS |
| 6 |
| 0 |
| CREATED_BY |
| CHAR |
| 12 |
| 0 |
| CHANGE_DATE |
| DATS |
| 8 |
| 0 |
| CHANGE_TIME |
| TIMS |
| 6 |
| 0 |
| CHANGE_DATETIME |
| DEC |
| 15 |
| 0 |
| UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
| CHANGE_USER |
| CHAR |
| 12 |
| 0 |
| OBJECT_TYPE |
| CHAR |
| 10 |
| 0 |
| STATUS |
| CHAR |
| 30 |
| 0 |
| TARGET_VALUE |
| DEC |
| 15 |
| 2 |
| RELEASED_VALUE |
| DEC |
| 15 |
| 2 |
| VALIDITY_START |
| DATS |
| 8 |
| 0 |
| VALIDITY_END |
| DATS |
| 8 |
| 0 |
| VERSION |
| CHAR |
| 8 |
| 0 |
| PARENT_RFX |
| CHAR |
| 10 |
| 0 |
| PARENT_RFX_GUID |
| CHAR |
| 32 |
| 0 |
| PARENT_RFX_TRANS_TYPE |
| CHAR |
| 4 |
| 0 |
| PARENT_RFX_TRANS_TYPE_DESC |
| CHAR |
| 20 |
| 0 |
| PARENT_RFX_CREATED_DATE |
| DATS |
| 8 |
| 0 |
| PARENT_RFX_CREATED_TIME |
| TIMS |
| 6 |
| 0 |
| PARENT_RFX_OBJECT_TYPE |
| CHAR |
| 10 |
| 0 |
| PARENT_BID |
| CHAR |
| 10 |
| 0 |
| PARENT_BID_CREATED_DATE |
| DATS |
| 8 |
| 0 |
| PARENT_BID_CREATED_TIME |
| TIMS |
| 6 |
| 0 |
| VENDOR_NUMBER |
| CHAR |
| 10 |
| 0 |
| VENDOR_GUID |
| CHAR |
| 32 |
| 0 |
| ADDRESS_NUMBER |
| CHAR |
| 10 |
| 0 |
| NAME_1 |
| CHAR |
| 40 |
| 0 |
| NAME_2 |
| CHAR |
| 40 |
| 0 |
| CITY |
| CHAR |
| 40 |
| 0 |
| REGION |
| CHAR |
| 3 |
| 0 |
| POSTAL_CODE |
| CHAR |
| 10 |
| 0 |
| COUNTRY |
| CHAR |
| 3 |
| 0 |
| ITEM_NUMBER |
| CHAR |
| 10 |
| 0 |
| ITEM_GUID |
| CHAR |
| 32 |
| 0 |
| ITEM_DELETE_IND |
| CHAR |
| 1 |
| 0 |
| ITEM_RELEASED |
| CHAR |
| 1 |
| 0 |
| 'X' Active, ' ' Inactive, 'C' Being Checked |
| ITEM_DESCRIPTION |
| CHAR |
| 40 |
| 0 |
| ITEM_TYPE |
| CHAR |
| 4 |
| 0 |
| ITEM_TYPE_TEXT |
| CHAR |
| 60 |
| 0 |
| ITEM_AGENCY_CODE |
| CHAR |
| 4 |
| 0 |
| ITEM_AGENCY_SHR_NAME |
| CHAR |
| 30 |
| 0 |
| ITEM_AGENCY_MED_NAME |
| CHAR |
| 50 |
| 0 |
| ITEM_AGENCY_LNG_NAME |
| CHAR |
| 100 |
| 0 |
| ITEM_PLANT |
| CHAR |
| 4 |
| 0 |
| ITEM_PLANT_BUSINESS_PARTNER_NO |
| CHAR |
| 10 |
| 0 |
| ITEM_PLANT_PARTNER_GUID |
| CHAR |
| 32 |
| 0 |
| ITEM_PLANT_NAME |
| CHAR |
| 50 |
| 0 |
| ITEM_STORAGE_LOCATION |
| CHAR |
| 4 |
| 0 |
| ITEM_STORAGE_LOCATION_NAME |
| CHAR |
| 20 |
| 0 |
| ITEM_MATERIAL_GROUP |
| CHAR |
| 20 |
| 0 |
| ITEM_MATERIAL_GROUP_DESC |
| CHAR |
| 60 |
| 0 |
| ITEM_MATERIAL_NUMBER |
| CHAR |
| 54 |
| 0 |
| ITEM_MATERIAL_NUMBER_DESC |
| CHAR |
| 40 |
| 0 |
| ITEM_PARTNER_PRODUCT |
| CHAR |
| 40 |
| 0 |
| ITEM_DELIVERY_TIME_IN_DAYS |
| NUMC |
| 3 |
| 0 |
| ITEM_QUANTITY |
| DEC |
| 13 |
| 3 |
| ITEM_PO_UNIT |
| CHAR |
| 3 |
| 0 |
| ITEM_PO_UNIT_TEXT |
| CHAR |
| 30 |
| 0 |
| ITEM_GROSS_PRICE |
| DEC |
| 13 |
| 2 |
| ITEM_CURRENCY |
| CHAR |
| 5 |
| 0 |
| ITEM_NET_PRICE |
| DEC |
| 13 |
| 2 |
| ITEM_PRICE_UNIT |
| DEC |
| 5 |
| 0 |
| ITEM_ORIGINAL_PRICE |
| CHAR |
| 1 |
| 0 |
| ITEM_NET_VALUE |
| DEC |
| 15 |
| 2 |
| ITEM_RELEASED_VALUE |
| DEC |
| 15 |
| 2 |
| ITEM_RELEASED_QUANTITY |
| DEC |
| 13 |
| 3 |
| ITEM_TAX_CODE |
| CHAR |
| 2 |
| 0 |
| ITEM_CREATED_DATE |
| DATS |
| 8 |
| 0 |
| ITEM_CREATED_TIME |
| TIMS |
| 6 |
| 0 |
| ITEM_CREATED_BY |
| CHAR |
| 12 |
| 0 |
| ITEM_MODIFIED_DATE |
| DATS |
| 8 |
| 0 |
| ITEM_MODIFIED_TIME |
| TIMS |
| 6 |
| 0 |
| ITEM_MODIFIED_BY |
| CHAR |
| 12 |
| 0 |
| ITEM_VERSION_TYPE |
| CHAR |
| 1 |
| 0 |
| ' ' Active, 'C' Change Version, 'H' Historical |
File details come from the government source that posted it. Updated .