RECV_ADDR_EC

(SQL Table)
Index Back

ASN In Address View

# 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 ASN_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL ASR Key sequence number
3 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
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
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
8 CUST_ADDR_TYPE Character(1) VARCHAR2(1) NOT NULL Customer Address Type
H=Ship To Customer
S=Sold To Customer
9 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
10 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2
11 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
12 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
13 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
14 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
15 CITY Character(30) VARCHAR2(30) NOT NULL City
16 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
17 COUNTY Character(30) VARCHAR2(30) NOT NULL County
18 STATE Character(6) VARCHAR2(6) NOT NULL State
19 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal