PORTVLNDIS_TEO3 (SQL Table)	Index Back
CCU TEO temp table CCU temporary table for RTV_LN_DISTRIB

PORTVLNDIS_TEO3

(SQL Table)

CCU TEO temp table

CCU temporary table for RTV_LN_DISTRIB

# 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 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID

4 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line

5 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number

6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

7 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

8 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

9 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

10 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

11 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

12 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit

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

14 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

15 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

16 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence

17 INSPECTION_SW Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=Not Inspected
Y=Inspected

18 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

19 LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

20 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount

21 MERCH_AMT_PO_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt PO Base

22 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

23 MERCHANDISE_AMT_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Merchandise Amount

24 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount

25 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number

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

27 PRICE_PO_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Price Base

28 QTY_AM_RETRN_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Std Returned Qty

29 QTY_AM_RETRN_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Vendor Returned Qty

30 QTY_AM_SHIP_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Returned Base

31 QTY_AM_SHIP_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Supplier Shipped Qty

32 QTY_RECV_INTFC Number(16,4) DECIMAL(15,4) NOT NULL Qty Interfaced - Supp UOM

33 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

34 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

35 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

36 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

37 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence

38 REQUEST_DATE Date(10) DATE Requested

39 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.

40 RTV_DIST_STATUS Character(1) VARCHAR2(1) NOT NULL RTV Distribution Status
C=Closed
O=Open
S=Shipped
X=Cancelled

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

42 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

43 SHIP_DATE Date(10) DATE Item Shipping Date

44 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

45 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.

46 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

47 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW

48 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_BUGL_VW

49 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_BUGL_VW

50 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASSCF_BUGL_VW

51 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW

52 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_BUGL_VW

53 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

54 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

55 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

56 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_BUGL_VW

57 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW

58 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW

59 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDIT_BU_PC

60 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: %EDIT_PROJECT

61 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

62 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

63 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

64 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

65 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

66 USER_DIST_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1

67 CUSTOM_C100_D1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1

68 CUSTOM_C100_D2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2

69 CUSTOM_C100_D3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3

70 CUSTOM_C100_D4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4

71 CUSTOM_DATE_D Date(10) DATE Custom Date

72 CUSTOM_C1_D Character(1) VARCHAR2(1) NOT NULL Custom Character 2

73 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code

#	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	RTV_ID	Character(10)	VARCHAR2(10) NOT NULL	Return To Vendor ID
4	RTV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Return To Vendor Line
5	RTV_DISTRIB_NUM	Number(5,0)	INTEGER NOT NULL	RTV Distribution Number
6	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
7	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
8	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
9	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
10	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
11	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
12	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
15	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
16	DISTRIB_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Sequence
17	INSPECTION_SW	Character(1)	VARCHAR2(1) NOT NULL	Inspection Required N=Not Inspected Y=Inspected
18	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
19	LOT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lot ID
20	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
21	MERCH_AMT_PO_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt PO Base
22	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
23	MERCHANDISE_AMT_PO	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	PO Merchandise Amount
24	MISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
25	PO_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	PO Distribution Line Number
26	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
27	PRICE_PO_BSE	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Price Base
28	QTY_AM_RETRN_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Std Returned Qty
29	QTY_AM_RETRN_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Vendor Returned Qty
30	QTY_AM_SHIP_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Returned Base
31	QTY_AM_SHIP_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Supplier Shipped Qty
32	QTY_RECV_INTFC	Number(16,4)	DECIMAL(15,4) NOT NULL	Qty Interfaced - Supp UOM
33	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
34	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
35	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
36	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
37	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
38	REQUEST_DATE	Date(10)	DATE	Requested
39	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.
40	RTV_DIST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	RTV Distribution Status C=Closed O=Open S=Shipped X=Cancelled
41	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
42	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
43	SHIP_DATE	Date(10)	DATE	Item Shipping Date
44	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
45	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
46	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
47	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
48	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
49	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
50	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
51	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
52	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
53	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
54	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
55	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
56	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
57	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
58	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
59	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
60	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
61	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
62	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
63	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
64	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
65	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
66	USER_DIST_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
67	CUSTOM_C100_D1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
68	CUSTOM_C100_D2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
69	CUSTOM_C100_D3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
70	CUSTOM_C100_D4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
71	CUSTOM_DATE_D	Date(10)	DATE	Custom Date
72	CUSTOM_C1_D	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
73	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code