AR_SOLD_TO_VW2(SQL View) |
Index Back |
---|---|
Item Sold To |
SELECT DISTINCT A.BUSINESS_UNIT , A.SOLD_TO_CUST_ID , B.NAME1 FROM PS_ITEM A , PS_CUSTOMER B WHERE A.SOLD_TO_CUST_ID = B.CUST_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |