INV_TMS_SHP2_VW(SQL View) |
Index Back |
---|---|
TMS Ship To Prompt View |
SELECT DISTINCT BUSINESS_UNIT , SHIP_TO_CUST_ID FROM PS_IN_DEMAND WHERE SHIP_TO_CUST_ID <> ' ' AND ROUTE_CD = ' ' AND IN_FULFILL_STATE BETWEEN '30' AND '50' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
2 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |