IN_OFRT_STO_EC

(SQL Table)
Index Back

Outbound Freight Shipto

Outbound freight ship-to segment

# 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 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
4 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
5 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
6 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
8 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
9 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2
10 OVRRIDE_ADDR_FLG Character(1) VARCHAR2(1) NOT NULL Override Shipto/Address
11 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

13 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
14 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
15 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
16 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
17 CITY Character(30) VARCHAR2(30) NOT NULL City
18 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
19 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
20 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
21 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
22 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
23 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
24 COUNTY Character(30) VARCHAR2(30) NOT NULL County
25 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

26 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
27 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
28 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

29 CONTACT Character(15) VARCHAR2(15) NOT NULL Provider Contact
30 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
31 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
32 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
33 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
34 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
35 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values