SPBIDFILL_TEO3

(SQL Table)
Index Back

CCU Temp Table

CCU Temp Table for Bid Fill

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 BID_ID Number(10,0) DECIMAL(10) NOT NULL Bid Id
4 LINE_ROW Number(5,0) INTEGER NOT NULL Line Row
5 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
8 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
9 SPF_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate
10 SPF_BID_LINE_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL field used to store the total bid amount for deliverable based spro reqs
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 SPF_RATE_VNDR Signed Number(16,4) DECIMAL(14,4) NOT NULL Field for the Vendor rate
13 SPF_RATE_FILL Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate
14 SPF_LN_FILL_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line Filled total
15 CURRENCY_CD_VNDR Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
16 SPF_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Base Rate field for sPro Requisitions
17 SPF_RATE_FILL_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate in Base currency
18 SPF_LN_FIL_TOT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line Filled total in Base currency
19 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
20 START_DATE Date(10) DATE Start Date for Gen Standing PO
21 END_DATE Date(10) DATE End Date
22 DURATION Number(5,0) INTEGER NOT NULL Recurrence Duration
23 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
24 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
25 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
26 SRVC_PROVIDER_ID Character(15) VARCHAR2(15) NOT NULL Service Provider
27 PROVIDER_CONTACT Character(15) VARCHAR2(15) NOT NULL PROVIDER CONTACT
28 SP_MSP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL MSP percent
29 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
30 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
31 RATE_EFFDT Date(10) DATE Rate Effective Date
32 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
33 LINKEDWORDER Character(15) VARCHAR2(15) NOT NULL Linked Work Order
34 MS_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate charged by either the Vendor Managed Service (VMS) Supplier or the Managed Service Provider (MSP) organization
35 MS_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate charged by either the Vendor Managed Service (VMS) Supplier or the Managed Service Provider (MSP) organization
36 MS_RATE_VNDR Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate charged by either the Vendor Managed Service (VMS) Supplier or the Managed Service Provider (MSP) organization
37 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time

Default Value: %DateTime

38 ROW_MODIFY_DATE DateTime(26) TIMESTAMP Modified Date Time

Default Value: %DateTime

39 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
40 ROW_MODIFY_USER Character(30) VARCHAR2(30) NOT NULL Modified User
41 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code