MOC_NOSAL_DD_VW

(SQL View)
 Index Back

Data Distribution view

Mobile Order Capture Data Distribution view, for not syncing Orders and Quotes originating from Sales Leads or Opportunities.

SELECT DISTINCT B.CAPTURE_ID , A.OPRID , B.BUSINESS_UNIT , B.BULK_ORDER_FLAG , B.ROW_ADDED_OPRID , B.ROW_LASTMANT_OPRID , B.CAPTURE_DATE , B.ROW_LASTMANT_DTTM , B.SYNCID , B.SYNCDTTM FROM PS_OPR_DEF_TBL_RB A , PS_RO_HEADER B WHERE A.BUSINESS_UNIT_RO = B.BUSINESS_UNIT AND B.CAPTURE_ID NOT IN ( SELECT C.CAPTURE_ID FROM PS_RO_ASSOCIATION C WHERE (C.LEAD_ID <> ' ' ) OR (C.OPPORTUNITY_ID <> ' '))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 BULK_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Flag used to determinate if an order is the master order when using bulk ordering.
5 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
6 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
7 CAPTURE_DATE Date(10) DATE Order capture date used for orders and quotes
8 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
9 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
10 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time