VRBT_EWN_CTX

(SQL Table)
Index Back

Supplier Rebate Context rec-EW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name
2 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category
3 SEQ_NBR_EOEN Number(15,0) DECIMAL(15) NOT NULL EOEN Sequence Nbr
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID
6 REBATE_MGR Character(30) VARCHAR2(30) NOT NULL Rebate Manager
7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
9 VENDOR_NAME Character(30) VARCHAR2(30) NOT NULL Supplier Name
10 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
12 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
13 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
14 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
15 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
16 BUSINESS_UNIT_RTV Character(5) VARCHAR2(5) NOT NULL RTV Business Unit
17 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
18 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
19 DESCR Character(30) VARCHAR2(30) NOT NULL Description