SF_RPL_OUT_EC

(SQL Table)
Index Back

Outbound Repl Hdr Staging Tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 DESCR_BU Character(30) VARCHAR2(30) NOT NULL Business Unit Description
7 ADDRESS1_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 1
8 ADDRESS2_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 2
9 ADDRESS3_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 3
10 ADDRESS4_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 4
11 CITY_BU Character(30) VARCHAR2(30) NOT NULL Business Unit City
12 STATE_BU Character(6) VARCHAR2(6) NOT NULL Business Unit State
13 POSTAL_BU Character(12) VARCHAR2(12) NOT NULL Business Unit Postal Code
14 COUNTRY_BU Character(3) VARCHAR2(3) NOT NULL Business Unit Country
15 STD_ID_NUM_VNDR Character(20) VARCHAR2(20) NOT NULL Vendor ID Number
16 NAME1_VNDR Character(40) VARCHAR2(40) NOT NULL Vendor Name
17 ADDRESS1_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 1
18 ADDRESS2_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 2
19 ADDRESS3_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 3
20 ADDRESS4_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 4
21 CITY_VNDR Character(30) VARCHAR2(30) NOT NULL Vendor City
22 STATE_VNDR Character(6) VARCHAR2(6) NOT NULL Vendor State
23 POSTAL_VNDR Character(12) VARCHAR2(12) NOT NULL Vendor Postal Code
24 COUNTRY_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Country
25 DTTM_DISP DateTime(26) TIMESTAMP Date Time Dispatched