CS_AUC_LINE_VW

(SQL View)
 Index Back

RFX Line Mapping

Bind Mapping view for RFX

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

# 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
7 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes

Y/N Table Edit

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

Default Value: L

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

Prompt Table: SP_BU_AM_NONVW

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

Prompt Table: %EDITTABLE26

13 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
14 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

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

Prompt Table: MANUFACTURER

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

Prompt Table: ITEM_MFG_ID_VW

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

Prompt Table: CURRENCY_CD_TBL

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

Prompt Table: UNITS_TBL

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

Prompt Table: UNITS_TBL

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

Prompt Table: UNITS_TBL

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

Default Value: O

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

Default Value: 0

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

Default Value: 0

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

44 PREV_LINE_NBR Number(5,0) INTEGER NOT NULL Previous Line Number
45 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
46 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
47 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
48 AUC_BID_GRP_ONLY Character(1) VARCHAR2(1) NOT NULL Item Biddable Only if Grouped

Y/N Table Edit

Default Value: N

49 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
50 BID_GROUP_SRC Character(1) VARCHAR2(1) NOT NULL Bid Group Source
B=Bidder Defined
U=User Defined
51 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

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

Y/N Table Edit

Default Value: N