OMEC_ORD_ADDRVW

(SQL View)
Index Back

OM EC Ord Address View

This is straight view of ORD_ADDR. It is used for a Mass Change insert (OMEC), inserting order addresses (selecting from ORD_ADDR_EC - the EDI order address staging table). The reason this view exists is because Mass Change does not support sub-records - when a sub-record exists on a record, Mass change generates invalid SQL.

SELECT BUSINESS_UNIT ,ORDER_NO ,ORDER_INT_LINE_NO ,SCHED_LINE_NBR ,CUST_ADDR_TYPE ,COUNTRY ,ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,ADDRESS4 ,CITY ,NUM1 ,NUM2 ,HOUSE_TYPE ,ADDR_FIELD1 ,ADDR_FIELD2 ,ADDR_FIELD3 ,COUNTY ,STATE ,POSTAL ,GEO_CODE ,IN_CITY_LIMIT ,COUNTRY_CODE ,PHONE ,EXTENSION ,FAX ,EMAILID ,CUST_NAME ,CNTCT_NAME1 ,LASTUPDDTTM ,LAST_MAINT_OPRID ,DATETIME_ADDED FROM PS_ORD_ADDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 CUST_ADDR_TYPE Character(1) VARCHAR2(1) NOT NULL Customer Address Type
H=Ship To Customer
S=Sold To Customer
6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
11 CITY Character(30) VARCHAR2(30) NOT NULL City
12 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
13 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
14 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
15 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
16 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
17 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
18 COUNTY Character(30) VARCHAR2(30) NOT NULL County
19 STATE Character(6) VARCHAR2(6) NOT NULL State
20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
21 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
22 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
23 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
24 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
25 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
26 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
27 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
28 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
29 CNTCT_NAME1 Character(40) VARCHAR2(40) NOT NULL Contact Name1
30 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
31 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
32 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added