BC_SOLD_VW(SQL View) |
Index Back |
---|---|
SOLD-to Customer viewview of active sold-to customers |
SELECT A.BO_ID , B.BO_NAME , A.SETID , A.CUST_ID FROM PS_BO B , PS_BC_FLAGS_VW A WHERE A.BO_ID = B.BO_ID AND A.SOLD_TO_FLG = 'Y' AND A.CUST_STATUS <> 'I' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
2 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
4 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |