DP_BUITEMINV_VW

(SQL View)
 Index Back

PL view of INV bu_items_inv

PL view of INV bu_items_inv table. used to maintain mirror copy (PL_BU_ITEMS) table

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , %subrec(MASTER_ITEM_SBR, A) , A.DT_TIMESTAMP FROM PS_BU_ITEMS_INV A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 ITEM_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
4 ITEM_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
5 ITEM_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
6 ITEM_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
7 ITEM_FIELD_C30_E Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
8 ITEM_FIELD_C30_F Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
9 ITEM_FIELD_C30_G Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
10 ITEM_FIELD_C30_H Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
11 ITEM_FIELD_C30_I Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
12 ITEM_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
13 ITEM_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
14 ITEM_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
15 ITEM_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
16 ITEM_FIELD_C1_E Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
17 ITEM_FIELD_C1_F Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
18 ITEM_FIELD_C1_G Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
19 ITEM_FIELD_C1_H Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
20 ITEM_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
21 ITEM_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
22 ITEM_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
23 ITEM_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
24 ITEM_FIELD_C10_E Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
25 ITEM_FIELD_C10_F Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
26 ITEM_FIELD_C10_G Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
27 ITEM_FIELD_C10_H Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
28 ITEM_FIELD_C10_I Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
29 ITEM_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2
30 ITEM_FIELD_C2_B Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2
31 ITEM_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
32 ITEM_FIELD_C4_B Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
33 ITEM_FIELD_C4_C Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
34 ITEM_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User-defined item field - Character 6
35 ITEM_FIELD_C6_B Character(6) VARCHAR2(6) NOT NULL User-defined item field - Character 6
36 ITEM_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
37 ITEM_FIELD_C8_B Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
38 ITEM_FIELD_C8_C Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
39 ITEM_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
40 ITEM_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
41 ITEM_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
42 ITEM_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
43 ITEM_FIELD_N12_E Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
44 ITEM_FIELD_N12_F Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
45 ITEM_FIELD_N12_G Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
46 ITEM_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
47 ITEM_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
48 ITEM_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
49 ITEM_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
50 ITEM_FIELD_N15_E Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
51 ITEM_FIELD_N15_F Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
52 ITEM_FIELD_N15_G Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
53 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp