Hard-Coded UDC Values

The following list includes the UDC tables used by the JD Edwards EnterpriseOne Operational Sourcing system that are hard-coded. You do not need to set up these UDC tables, but you should verify that they exist:

• 43Q/AA

  This UDC table contains valid award actions for bids. Values include:

  • A: Award Bid

  • D: Disallow Bid

  • N: No Action Taken

  • R: Reject Bid

• 43Q/AC

  This UDC table contains values that indicate whether a currency is the currency that is specified for an event or a currency that is specified in a bid. Values include:

  • B: Bid currency

  • E: Event currency

• 43Q/AI

  This UDC table contains values that specify whether the system adds an item to the JD Edwards EnterpriseOne Inventory Management tables. Values include:

  • 0: Do not add.

  • 1: Add item to system tables.

• 43Q/AT

  This UDC table contains values that specify whether the system creates a blanket order or a purchase order when an award is posted. Values include:

  • B: Blanket purchase order

  • P: Purchase order

• 43Q/BH

  This UDC table contains values that specify how the system sorts bids when you are viewing bid history by line. Values include:

  • 01: Bid number

  • 02: Bidder number

  • 03: Bidder name

  • 04: Bid status

  • 05: Bid score

  • 06: Award status

• 43Q/BS

  This UDC table contains valid bid statuses. Values include:

  • D: Disqualified

  • P: Posted

  • S: Saved

  • W: Disallowed

  • X: Canceled

• 43Q/BT

  This UDC table contains bid question types. Values include:

  • D: Date

  • L: List

  • M: Monetary

  • N: Numeric

  • P: Price

  • T: Text

  • Y: Yes/No

• 43Q/CC

  This UDC table contains valid commodity levels that the system uses when attaching bid questions to an event. Values include:

  • AL: All levels

  • NL: None

  • SL: Single level

• 43Q/ED

  This UDC table contains valid event dates. Values include:

  • 01: Preview start date

  • 02: Start date

  • 03: End date

• 43Q/EF

  This UDC table contains valid event formats. Values include:

  • BY: RFx

  • RF: Request for information

• 43Q/ES

  This UDC table contains valid event statuses. Values include:

  • A: Awarded

  • F: RFI reviewed

  • I: Pending RFI review

  • N: Not awarded

  • O: Open

  • P: Posted

  • Q: Paused

  • T: Pending award

  • X: Canceled

• 43Q/IB

  This UDC table contains valid search types for bidders in the Invite Bidders program (P43Q30). Values include:

  • B: Bidder

  • S: Supplier

• 43Q/IS

  This UDC table contains valid invitation statuses. Values include:

  • A: Invite accepted

  • D: Invite declined

  • O: Registered

  • P: Response incomplete

  • S: Bid submitted

• 43Q/LS

  This UDC table contains valid statuses for event lines. Values include:

  • C: Closed

  • O: Open

  • X: Canceled

• 43Q/LT

  This UDC table contains valid types of event lines. Values include:

  • IF: Item on the fly

  • SR: Special request (service)

  • ST: Stocked item

  • SV: Service item

• 43Q/PB

  This UDC table contains valid values for whether price break information exists. Values include:

  • 0: No price breaks exist.

  • 1: User or buyer defined price breaks.

• 43Q/PC

  This UDC table contains valid values for whether price component information exists. Values include:

  • 0: No price components exist.

  • 1: Price components exist.

• 43Q/QS

  This UDC table contains valid statuses for bid questions. Values include:

  • A: Active

  • I: Inactive

• 43Q/S1

  This UDC table contains valid methods by which to sort bidders when you are analyzing header information for events. Values include:

  • 01: Bidder name

  • 02: Total event score

  • 03: Header score

  • 04: Total bid amount

• 43Q/S2

  This UDC table contains valid methods by which to sort bidders when you are analyzing line information for events. Values include:

  • 01: Bidder name

  • 02: Total event score

  • 03: Line score

  • 04: Line amount

  • 05: Award quantity

• 43Q/S3

  This UDC table contains valid methods by which to sort bidders when you are analyzing RFI bids. Values include:

  • 01: Bidder name

  • 02: Header score

• 43Q/SB

  This UDC table contains valid methods by which to sort bidders in the Invite Bidders program (P43Q30). Values include:

  • ALPH: Alpha name

  • AN8: Address number

  • AT1: Search type

• 43Q/SO

  This UDC table contains valid methods by which to sort bid questions. Values include:

  • BIDCODE: Bid question code

  • DESC: Description

• 43Q/TM

  This UDC table contains valid measures of time that you use to specify default durations for events in the Sourcing Constants program (P43Q90). Values include:

  • D: Days

  • H: Hours

  • M: Minutes

• 43Q/WB

  This UDC table contains valid methods by which to sort events in the Event Workbench program. Values include:

  • EVFT: Event format

  • EVNU: Event number

  • EVST: Event status

  • EVTN: Event name

  • MCU: Branch plant

• 43Q/WS

  This UDC table contains valid methods by which to sort events in the Bidder Workbench program. Values include:

  • SBDHP: Bid history

  • TM: Event end date

  • FT: Event type

  • NU: Event number

  • ST: Event status

  • SX: Event start date

  • TN: Event name

  • ST: Bidder status

• 43Q/YN

  This UDC table contains valid responses to yes/no questions. Values are:

  • N: No

  • Y: Yes