Bid tabulation
These tables show the field mapping information of the fields that you can use to build your bid tabulation IDM template.
Business Class: SourcingEvent
List: BidTabulationHeaderIDMList
| XML field | Description | FSM field |
|---|---|---|
| SourcingCompany | Sourcing Company | Company |
| SourcingCompanyName | Sourcing Company Name | Company.Name |
| Event | Event | SourcingEvent |
| Version | Version | LastVersionNumber |
| Name | Name | Name |
| Reference | Reference | EventReference |
| Description | Description | Description |
| OpenDate | Open Date | OpenDate |
| CloseDate | Close Date | CloseDate |
| CurrencyCode | Event Currency | CurrencyCode |
| Buyer | Buyer | Buyer |
| NumberOfResponses | Number Of Responses | NumberOfResponses |
| NumberOfNoBidResponses | Number Of No Bid Responses | NumberOfSubmittedNoBidResponses |
| NumberOfSupplierNotifications | Number Of Supplier Notifications | NumberOfSupplierNotifications |
Business Class: SourcingEventResponse
List: BidTabulationSupplierIDMList
| XML field | Description | FSM field |
|---|---|---|
| SupplierName | Supplier Name | DerivedSupplierName |
| BidAmount | Bid Amount | TotalBidAmount |
| SupplierAddressLine1 | Supplier Address Line 1 | NotifiedSupplier.Supplier.MailingAddress.DeliveryAddress.AddressLine1 |
| SupplierAddressLine2 | Supplier Address Line 2 | NotifiedSupplier.Supplier.MailingAddress.DeliveryAddress.AddressLine2 |
| SupplierAddressLine3 | Supplier Address Line 3 | NotifiedSupplier.Supplier.MailingAddress.DeliveryAddress.AddressLine3 |
| SupplierAddressLine4 | Supplier Address Line 4 | NotifiedSupplier.Supplier.MailingAddress.DeliveryAddress.AddressLine4 |
| SupplierAddressCity | Supplier Address City | NotifiedSupplier.Supplier.MailingAddress.Municipality |
| SupplierAddressState | Supplier Address State | NotifiedSupplier.Supplier.MailingAddress.StateProvince |
| SupplierAddressZipCode | Supplier Address Zip Code | NotifiedSupplier.Supplier.MailingAddress.PostalCode |
| SupplierAddressCountry | Supplier Address Country | NotifiedSupplier.Supplier.MailingAddress.Country |
| Supplier | Supplier | NotifiedSupplier.Supplier |
| Contract | Contract | NotifiedSupplier.SupplierSourceId.MainContact.FirstAndLastName |
| TotalAwardAmount | Total Award Amount | SupplierTotalAwarded |
Business Class: SourcingEventLine
List: SourcingEventLinesIDMList
| XML field | Description | FSM field |
|---|---|---|
| Item | ItemNumber | ItemNumber |
| Description | Description | ItemDescription |
| Has Second Description | HasSecondDescription | HasSecondDescription |
| Description 2 | Description2 | ItemDescription2 |
| Has Third Description | HasThirdDescription | HasThirdDescription |
| Long Item Description | LongItemDescription | ItemDescription3 |
| Unit Of Measure | UOM | UOM.UnitOfMeasure |
| Total Quantity | TotalQuantity | Quantity |
| Unit Price | UnitPrice | PerUnitEstimate |
| Extended Amount | ExtendedAmount | DerivedExtendedEstimate |
| Is Line Cancelled | IsLineCancelled | IsLineCancelled |
Business Class: SourcingEventLineSource
List: BidTabulationLineSourceIDMList
| XML field | Description | FSM field |
|---|---|---|
| Line Source | LineSource | SourcingEventLineSource |
| Origin | Origin | OriginCode |
| Document Numeric | DocumentNumeric | SourceDocumentNumeric |
| Line | Line | LineNumber |
Business Class: SourcingEventLineResponse
List: BidTabulationResponseIDMList
| XML field | Description | FSM field |
|---|---|---|
| Supplier Name | SupplierName | SupplierNameDerived |
| Quantity | Quantity | Quantity |
| Unit Price | UnitPrice | ResponseAmount.UnitPrice |
| Amount | ExtendedAmount | ExtendedPrice |
| Award Reason | AwardReason | DerivedIDMAwardReason |
| Non Award Reason | NonAwardReason | DerivedIDMNonAwardReason |
| Award Date | AwardDate | AwardDate |
| Contract | Contract | OutPutTypeCm |
| PO | PO | OutPutTypePO |
| Effective Date | EffectiveDate | ContractRel.EffectiveDate |
| Expiration Date | ExpirationDate | ContractRel.ExpirationDate |
| Description | Description | ContractRel.Description |
Business Class: SourcingEventContract
List: BidTabulationContractIDMList
| XML field | Description | FSM field |
|---|---|---|
| Contact | Contact | Contact |
| Name | Name | DerivedName |
| Contact Type | Contact Type | ContactType |