OMEC_ORD_ADDR(SQL Table) |
Index Back |
|---|---|
Order AddressesThis table holds the over-ride address associated with a Quotation or Sales Order. If a user elects to enter a "one-time" address on the header, line, or schedule, the address will be stored in this record. This is also used by standalone version of Purchasing. Date Initials Issue Description 031501 dms SP2 (DI-EDWONG-14) Add Source_cd |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_OM |
| 4 | 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
Prompt Table: ORD_HEADER |
| 5 | ORDER_INT_LINE_NO |
Number(5,0) | INTEGER NOT NULL |
Order Line
Prompt Table: ORD_LINE |
| 6 | SCHED_LINE_NBR |
Number(6,0) | INTEGER NOT NULL |
Schedule Line Number
Prompt Table: ORD_SCHEDULE |
| 7 | CUST_ADDR_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Customer Address Type
H=Ship To Customer S=Sold To Customer |
| 8 | SOURCE_CD | Character(6) | VARCHAR2(6) NOT NULL | Source Code |
| 9 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 10 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 11 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 12 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 13 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 14 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 15 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 16 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 17 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
| 18 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 19 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 20 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 21 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 22 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
| 23 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 24 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 25 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 26 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Int'l Prefix |
| 27 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 28 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone Extension |
| 29 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
| 30 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 31 | CUST_NAME | Character(40) | VARCHAR2(40) NOT NULL | Name |
| 32 | CNTCT_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Contact Name1 |
| 33 | 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. |
| 34 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 35 | DATETIME_ADDED | DateTime(26) | TIMESTAMP | DateTime Added |
| 36 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 37 | 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 |
| 38 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | In process flag |