AUC_COPY_TMP (SQL Table)	Index Back
Sourcing copy temporary Table 30/12/2015 CHAN 21902228 Added field AUC_BID_GRP_ONLY to copy from the Event.

AUC_COPY_TMP

(SQL Table)

Sourcing copy temporary Table

30/12/2015 CHAN 21902228 Added field AUC_BID_GRP_ONLY to copy from the Event.

# 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 AMT_OPEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Open Amount

7 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

8 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

10 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description

11 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

12 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

13 INCLUDE_INV_ITEM Character(1) VARCHAR2(1) NOT NULL Include Inventory Items

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

15 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

16 LEAD_TIME Number(3,0) SMALLINT NOT NULL Lead Time Days

17 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

18 PRICE_REQ Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative

19 PRICE_AUC Number(17,5) DECIMAL(16,5) NOT NULL Event Price

20 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity

21 QTY_AUC Number(16,4) DECIMAL(15,4) NOT NULL Event Quantity

22 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

23 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

24 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes
Y/N Table Edit

25 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

26 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID

27 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

28 SHIP_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Ship From Location
Prompt Table: LOCATION_TBL

29 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

30 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID

31 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier

32 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

33 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
N=Optional
X=Do Not
Y=Required

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

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

36 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

37 CNTRCT_TYPE Character(2) VARCHAR2(2) NOT NULL Contract Type
AP=Recurring Voucher
GN=General Contract
MS=Master Contract
PO=Purchase Order

38 SETID Character(5) VARCHAR2(5) NOT NULL SetID

39 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

40 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled

41 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban

42 PO_DT Date(10) DATE Date

43 AUC_TMPLTE_ID Character(10) VARCHAR2(10) NOT NULL Template ID

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_ITEM_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Length

46 AUC_ITEM_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Width

47 AUC_ITEM_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Weight

48 AUC_ITEM_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Volume

49 AUC_ITEM_SIZE Character(5) VARCHAR2(5) NOT NULL Item Size

50 AUC_ITEM_COLOR Character(15) VARCHAR2(15) NOT NULL Sourcing Item Color

51 AUC_ITEM_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Height

52 AUC_WEIGHT_UOM Character(3) VARCHAR2(3) NOT NULL Weight UOM

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

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

55 EXPL_LVL_ENG Number(3,0) SMALLINT NOT NULL Level Code

56 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

57 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label

58 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

59 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity

60 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order

61 CALC_RESOURCE_PCT Number(16,7) DECIMAL(15,7) NOT NULL Calculated Resource Factor pct

62 EN_SUBS_EXIST Character(1) VARCHAR2(1) NOT NULL KPN 08/23/02: Added label PL_SUBS_EXIST
N=No
Y=Yes

63 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

64 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family

65 BOM_USAGE Character(2) VARCHAR2(2) NOT NULL BOM Usage
1=By Effectivity Date
2=By Revision

66 BOM_COMPONENT_DISP Character(50) VARCHAR2(50) NOT NULL Component ID

67 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services

68 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

69 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes

70 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

71 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code

72 START_DT Date(10) DATE Start Date

73 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning

74 SORTCODE Character(254) VARCHAR2(254) NOT NULL BOM Sort Code

75 QTY_ADJUSTED Number(16,4) DECIMAL(15,4) NOT NULL Adjust Quantity

76 LIQUIDATE_METHOD Character(1) VARCHAR2(1) NOT NULL Liquidate by
A=Amount
Q=Quantity

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

78 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID

79 AUC_BID_GRP_ONLY Character(1) VARCHAR2(1) NOT NULL Item Biddable Only if Grouped

80 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code

81 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

82 ATTACH_DESCR Character(100) VARCHAR2(100) NOT NULL A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.

83 COMMENTS Long Character CLOB Comments

#	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	AMT_OPEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Open Amount
7	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
8	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
11	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
12	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
13	INCLUDE_INV_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Include Inventory Items
14	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
15	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
16	LEAD_TIME	Number(3,0)	SMALLINT NOT NULL	Lead Time Days
17	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
18	PRICE_REQ	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
19	PRICE_AUC	Number(17,5)	DECIMAL(16,5) NOT NULL	Event Price
20	QTY_REQ	Number(16,4)	DECIMAL(15,4) NOT NULL	Requisition Quantity
21	QTY_AUC	Number(16,4)	DECIMAL(15,4) NOT NULL	Event Quantity
22	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
23	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
24	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes Y/N Table Edit
25	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
26	SHIPTO_SETID	Character(5)	VARCHAR2(5) NOT NULL	ShipTo SetID
27	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
28	SHIP_FROM_LOC	Character(10)	VARCHAR2(10) NOT NULL	Ship From Location Prompt Table: LOCATION_TBL
29	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
30	BIDDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bidder ID
31	BIDDER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bidder Type B=Bidder C=Customer P=Public U=Uploaded V=Supplier
32	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
33	RECV_REQ	Character(1)	VARCHAR2(1) NOT NULL	Receiving Required N=Optional X=Do Not Y=Required
34	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
35	MFG_ITM_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Item ID
36	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
37	CNTRCT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Contract Type AP=Recurring Voucher GN=General Contract MS=Master Contract PO=Purchase Order
38	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
39	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
40	PO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PO Status A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled
41	PO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PO Type GEN=General KAN=Kanban
42	PO_DT	Date(10)	DATE	Date
43	AUC_TMPLTE_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID
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_ITEM_LENGTH	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item Length
46	AUC_ITEM_WIDTH	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item Width
47	AUC_ITEM_WEIGHT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item Weight
48	AUC_ITEM_VOLUME	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item Volume
49	AUC_ITEM_SIZE	Character(5)	VARCHAR2(5) NOT NULL	Item Size
50	AUC_ITEM_COLOR	Character(15)	VARCHAR2(15) NOT NULL	Sourcing Item Color
51	AUC_ITEM_HEIGHT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item Height
52	AUC_WEIGHT_UOM	Character(3)	VARCHAR2(3) NOT NULL	Weight UOM
53	AUC_VOLUME_UOM	Character(3)	VARCHAR2(3) NOT NULL	Volume UOM
54	AUC_DIMENSION_UOM	Character(3)	VARCHAR2(3) NOT NULL	Dimension UOM
55	EXPL_LVL_ENG	Number(3,0)	SMALLINT NOT NULL	Level Code
56	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id.
57	DATE_IN_EFFECT	Date(10)	DATE	01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label
58	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
59	QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Quantity
60	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order
61	CALC_RESOURCE_PCT	Number(16,7)	DECIMAL(15,7) NOT NULL	Calculated Resource Factor pct
62	EN_SUBS_EXIST	Character(1)	VARCHAR2(1) NOT NULL	KPN 08/23/02: Added label PL_SUBS_EXIST N=No Y=Yes
63	INV_ITEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Item Group
64	INV_PROD_FAM_CD	Character(10)	VARCHAR2(10) NOT NULL	Family
65	BOM_USAGE	Character(2)	VARCHAR2(2) NOT NULL	BOM Usage 1=By Effectivity Date 2=By Revision
66	BOM_COMPONENT_DISP	Character(50)	VARCHAR2(50) NOT NULL	Component ID
67	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
68	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
69	AMT_ONLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Amount Only N=No Y=Yes
70	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
71	PLANNER_CD	Character(12)	VARCHAR2(12) NOT NULL	Planner Code
72	START_DT	Date(10)	DATE	Start Date
73	SOURCE_CODE	Character(2)	VARCHAR2(2) NOT NULL	8/5/97 lee - inactivated source code 4 - service 1=Make 2=Buy 3=Expense 4=Service 5=Floor Stock 6=Planning
74	SORTCODE	Character(254)	VARCHAR2(254) NOT NULL	BOM Sort Code
75	QTY_ADJUSTED	Number(16,4)	DECIMAL(15,4) NOT NULL	Adjust Quantity
76	LIQUIDATE_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Liquidate by A=Amount Q=Quantity
77	AUC_LINE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Event Line Type G=Group Line L=Line Item
78	AUC_GROUP_ID	Character(18)	VARCHAR2(18) NOT NULL	GroupID
79	AUC_BID_GRP_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Item Biddable Only if Grouped
80	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code
81	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
82	ATTACH_DESCR	Character(100)	VARCHAR2(100) NOT NULL	A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.
83	COMMENTS	Long Character	CLOB	Comments