RESP_INQA1_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT ,A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION ,B.LINE_NBR ,A.BUSINESS_UNIT %Concat '-' %Concat A.AUC_ID ,A.AUC_FORMAT ,A.AUC_TYPE ,A.AUC_NAME ,A.AUC_STATUS ,A.AUC_DTTM_PREVIEW ,A.AUC_DTTM_START ,A.AUC_DTTM_FINISH ,A.PYMNT_TERMS_CD ,B.REQUIRED_FLAG ,B.AUC_LINE_TYPE ,B.ITM_SETID ,B.BUSINESS_UNIT_AM ,B.INV_ITEM_ID ,B.CATEGORY_ID ,B.UNIT_OF_MEASURE ,B.MFG_ID ,B.MFG_ITM_ID ,B.SERIAL_ID ,B.CURRENCY_CD ,B.DESCR254_MIXED ,B.PRICE_RESERVE ,B.PRICE_CLOSE ,B.QTY_AUC_MIN ,B.QTY_AUC_MAX ,B.QTY_AUC ,B.AUC_PRICE ,B.AUC_EXT_PRICE ,B.AUC_ITEM_LENGTH ,B.AUC_ITEM_WIDTH ,B.AUC_ITEM_WEIGHT ,B.AUC_ITEM_VOLUME ,B.AUC_ITEM_SIZE ,B.AUC_ITEM_COLOR ,B.AUC_ITEM_HEIGHT ,B.AUC_WEIGHT_UOM ,B.AUC_VOLUME_UOM ,B.AUC_DIMENSION_UOM ,B.WEIGHTING ,B.AUC_LINE_STATUS ,B.AUC_QTY_AWARDED ,B.AUC_QTY_POSTED ,B.AUC_USER_PRC_BRK ,B.AUC_BIDDER_PRC_BRK ,B.PREV_LINE_NBR ,B.PHYSICAL_NATURE ,B.VAT_SVC_PERFRM_FLG FROM PS_AUC_HDR A , PS_AUC_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION

# 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 AUC_ID_BUS_UNIT Character(18) VARCHAR2(18) NOT NULL Bus Unit-Auction ID
7 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
8 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
9 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
10 AUC_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
A=Awarded
C=Collaborating Event
D=Collaborating Bid Analysis
E=Evaluating
F=RFI Reviewed
I=Pending RFI Review
N=Not Awarded
O=Open
P=Posted
Q=Paused
R=Pending Scheduled Review
S=Pending Post Approval
T=Pending Award
U=Pending Award Approval
W=Post to Third Party Failed
X=Cancelled
Z=Inactive Version
11 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
12 AUC_DTTM_START DateTime(26) TIMESTAMP NOT NULL Date Time Start
13 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish
14 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

Prompt Table: PYMT_TR_EFF_VW

15 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes
16 AUC_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL Event Line Type
G=Group Line
L=Line Item
17 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
18 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

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

Prompt Table: %EDITTABLE26

20 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
21 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: UNITS_TBL

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

Prompt Table: MANUFACTURER

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

Prompt Table: ITEM_MFG_ID_VW

24 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

26 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
27 PRICE_RESERVE Number(16,5) DECIMAL(15,5) NOT NULL Reserve Price
28 PRICE_CLOSE Number(16,5) DECIMAL(15,5) NOT NULL Close Price
29 QTY_AUC_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Event Quantity
30 QTY_AUC_MAX Number(16,4) DECIMAL(15,4) NOT NULL Quantity Max
31 QTY_AUC Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity
32 AUC_PRICE Number(17,5) DECIMAL(16,5) NOT NULL Event Start price
33 AUC_EXT_PRICE Number(18,5) DECIMAL(17,5) NOT NULL Auction Extended Price
34 AUC_ITEM_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Length
35 AUC_ITEM_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Width
36 AUC_ITEM_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Weight
37 AUC_ITEM_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Volume
38 AUC_ITEM_SIZE Character(5) VARCHAR2(5) NOT NULL Item Size
39 AUC_ITEM_COLOR Character(15) VARCHAR2(15) NOT NULL Sourcing Item Color
40 AUC_ITEM_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Height
41 AUC_WEIGHT_UOM Character(3) VARCHAR2(3) NOT NULL Weight UOM

Prompt Table: UNITS_TBL

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

Prompt Table: UNITS_TBL

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

Prompt Table: UNITS_TBL

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

Default Value: O

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

Default Value: 0

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

Default Value: 0

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

50 PREV_LINE_NBR Number(5,0) INTEGER NOT NULL Previous Line Number
51 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
52 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