RO_INT_NOTE

(SQL Table)
Index Back

Integration Table

Stores the SEQ_NUM corresponding to notes for all orders sent to FSCM.

# 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 UID20 Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.
3 UID20F Character(20) VARCHAR2(20) NOT NULL Foreign UID...................................................................
4 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
6 ACTIONNAME Character(30) VARCHAR2(30) NOT NULL Action Name