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 |
|---|---|---|
| Sourcing Company | SourcingCompany | Company |
| Sourcing Company Name | SourcingCompanyName | Company.Name |
| Event | Event | SourcingEvent |
| Version | Version | LastVersionNumber |
| Name | Name | Name |
| Reference | Reference | EventReference |
| Description | Description | Description |
| Open Date | OpenDate | OpenDate |
| Close Date | CloseDate | CloseDate |
| Currency Code | EventCurrency | CurrencyCode |
| Buyer | Buyer | Buyer |
| Number Of Responses | NumberOfResponses | NumberOfResponses |
| Number Of No Bid Responses | NumberOfNoBidResponses | NumberOfSubmittedNoBidResponses |
| Number Of Supplier Notifications | NumberOfSupplierNotifications | NumberOfSupplierNotifications |
Business Class: SourcingEventResponse
List: BidTabulationSupplierIDMList
| XML field | Description | FSM field |
|---|---|---|
| Supplier Name | SupplierName | DerivedSupplierName |
| Bid Amount | BidAmount | TotalBidAmount |
| Supplier Address Line 1 | SupplierAddressLine1 | NotifiedSupplier.Supplier.MailingAddress.DeliveryAddress.AddressLine1 |
| Supplier Address Line 2 | SupplierAddressLine2 | NotifiedSupplier.Supplier.MailingAddress.DeliveryAddress.AddressLine2 |
| Supplier Address Line 3 | SupplierAddressLine3 | NotifiedSupplier.Supplier.MailingAddress.DeliveryAddress.AddressLine3 |
| Supplier Address Line 4 | SupplierAddressLine4 | NotifiedSupplier.Supplier.MailingAddress.DeliveryAddress.AddressLine4 |
| Supplier Address City | SupplierAddressCity | NotifiedSupplier.Supplier.MailingAddress.Municipality |
| Supplier Address State | SupplierAddressState | NotifiedSupplier.Supplier.MailingAddress.StateProvince |
| Supplier Address Zip Code | SupplierAddressZipCode | NotifiedSupplier.Supplier.MailingAddress.PostalCode |
| Supplier Address Country | SupplierAddressCountry | NotifiedSupplier.Supplier.MailingAddress.Country |
| Supplier | Supplier | NotifiedSupplier.Supplier |
| Contract | Contract | NotifiedSupplier.SupplierSourceId.MainContact.FirstAndLastName |
| Total Award Amount | TotalAwardAmount | 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 |