BUSINESS_UNITSOLD_TO_CUST_IDOM_AVFLDAY_SRCH(SQL View) |
Index Back |
|---|
| SELECT B.BUSINESS_UNIT , C.CUST_ID FROM PS_BUS_UNIT_TBL_OM B , PS_CUSTOMER C , PS_SET_CNTRL_REC S WHERE S.RECNAME = 'CUSTOMER' AND S.SETCNTRLVALUE = B.BUSINESS_UNIT AND C.SOLD_TO_FLG = 'Y' AND C.CUST_STATUS = 'A' |
| # | 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 |