AUC_EXT_LINE_VW

(SQL View)
 Index Back

Event Lines view


SELECT BUSINESS_UNIT , AUC_ID , AUC_ROUND , AUC_VERSION , LINE_NBR , REQUIRED_FLAG , AUC_LINE_TYPE , AUC_GROUP_ID , ITM_SETID , BUSINESS_UNIT_AM , INV_ITEM_ID , CATEGORY_ID , UNIT_OF_MEASURE , MFG_ID , MFG_ITM_ID , SERIAL_ID , CURRENCY_CD , DESCR254_MIXED , PRICE_RESERVE , PRICE_CLOSE , QTY_AUC_MIN , QTY_AUC_MAX , QTY_AUC , AUC_PRICE , AUC_EXT_PRICE , AUC_ITEM_LENGTH , AUC_ITEM_WIDTH , AUC_ITEM_WEIGHT , AUC_ITEM_VOLUME , AUC_ITEM_SIZE , AUC_ITEM_COLOR , AUC_ITEM_HEIGHT , AUC_WEIGHT_UOM , AUC_VOLUME_UOM , AUC_DIMENSION_UOM , WEIGHTING , AUC_LINE_STATUS , AUC_QTY_AWARDED , AUC_QTY_POSTED , AUC_USER_PRC_BRK , AUC_BIDDER_PRC_BRK , AUC_DSP_START_PRC , PREV_LINE_NBR , PHYSICAL_NATURE , VAT_SVC_PERFRM_FLG , AUC_ALT_UOM , AUC_BID_GRP_ONLY , AUC_BID_QTY_RULE , BID_GROUP_SRC , AUC_AMT_ONLY_REQ , AUC_ALLOW_GRP , ' ' , ' ' FROM PS_AUC_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes

Y/N Table Edit

7 AUC_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Event Line Type
G=Group Line
L=Line Item

Default Value: L

8 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
9 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
10 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE26

12 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: %EDIT_UOM

14 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER

15 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

Prompt Table: ITEM_MFG_ID_VW

16 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

18 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
19 PRICE_RESERVE Number(16,5) DECIMAL(15,5) NOT NULL Reserve Price
20 PRICE_CLOSE Number(16,5) DECIMAL(15,5) NOT NULL Close Price
21 QTY_AUC_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Event Quantity
22 QTY_AUC_MAX Number(16,4) DECIMAL(15,4) NOT NULL Quantity Max
23 QTY_AUC Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity
24 AUC_PRICE Number(17,5) DECIMAL(16,5) NOT NULL Event Start price
25 AUC_EXT_PRICE Number(18,5) DECIMAL(17,5) NOT NULL Auction Extended Price
26 AUC_ITEM_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Length
27 AUC_ITEM_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Width
28 AUC_ITEM_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Weight
29 AUC_ITEM_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Volume
30 AUC_ITEM_SIZE Character(5) VARCHAR2(5) NOT NULL Item Size
31 AUC_ITEM_COLOR Character(15) VARCHAR2(15) NOT NULL Sourcing Item Color
32 AUC_ITEM_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Height
33 AUC_WEIGHT_UOM Character(3) VARCHAR2(3) NOT NULL Weight UOM

Prompt Table: UNITS_TBL

34 AUC_VOLUME_UOM Character(3) VARCHAR2(3) NOT NULL Volume UOM

Prompt Table: UNITS_TBL

35 AUC_DIMENSION_UOM Character(3) VARCHAR2(3) NOT NULL Dimension UOM

Prompt Table: UNITS_TBL

36 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals
37 AUC_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Event Line Status
C=Closed
O=Open

Default Value: O

38 AUC_QTY_AWARDED Number(16,4) DECIMAL(15,4) NOT NULL Event Line Quantity Awarded

Default Value: 0

39 AUC_QTY_POSTED Number(16,4) DECIMAL(15,4) NOT NULL Event Line Quantity Posted

Default Value: 0

40 AUC_USER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL User Defined Price Breaks

Y/N Table Edit

Default Value: N

41 AUC_BIDDER_PRC_BRK Character(1) VARCHAR2(1) NOT NULL Bidder defined price breaks

Y/N Table Edit

Default Value: N

42 AUC_DSP_START_PRC Character(1) VARCHAR2(1) NOT NULL Display Start Price

Y/N Table Edit

43 PREV_LINE_NBR Number(5,0) INTEGER NOT NULL Previous Line Number
44 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
45 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
46 AUC_ALT_UOM Character(1) VARCHAR2(1) NOT NULL Alternate Units of Measure
A=Any UOM
I=Only existing item/uom's
N=Not Allowed
47 AUC_BID_GRP_ONLY Character(1) VARCHAR2(1) NOT NULL Item Biddable Only if Grouped

Y/N Table Edit

Default Value: N

48 AUC_BID_QTY_RULE Character(2) VARCHAR2(2) NOT NULL Bid Quantity Rule
MQ=Bid Up to Maximum Quantity
NA=Quantity Not Applicable
RQ=Requested Quantity Required
XQ=Allow Extra Quantity to be Bid
49 BID_GROUP_SRC Character(1) VARCHAR2(1) NOT NULL Bid Group Source
B=Bidder Defined
U=User Defined
50 AUC_AMT_ONLY_REQ Character(1) VARCHAR2(1) NOT NULL Amount Only Requistion reference - sourcing line originating from requisition.

Y/N Table Edit

Default Value: N

51 AUC_ALLOW_GRP Character(1) VARCHAR2(1) NOT NULL Allow Groups

Y/N Table Edit

Default Value: N

52 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
53 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description