RECV_LN_PRO

(SQL Table)
Index Back

Receipt Line Pro Numbers

3/05/07 - KMM - F-AHAYT-V0DS6 - 9.1 Misc Receiving - New Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
5 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
6 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
7 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
8 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
9 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
10 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
11 CUSTOM_DATE_B Date(10) DATE Custom Date
12 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
13 USER_SCHED_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
14 CUSTOM_C100_C1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
15 CUSTOM_C100_C2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
16 CUSTOM_C100_C3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
17 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1
18 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2
19 CUSTOM_C1_C Character(1) VARCHAR2(1) NOT NULL Custom Character 2