RO_LINE_ATTR_VW

(SQL View)
 Index Back

Order Line Attributes

View of Order Line Attributes by Line Number.

SELECT L.CAPTURE_ID , L.UID20 , %subrec(RB_ATTR_SBR,A) , L.LINE_NBR , %subrec(RB_ATTRCHG_SBR,A) FROM %Table(RO_LINE) L , %Table(RO_LINE_ATTR) A WHERE L.CAPTURE_ID=A.CAPTURE_ID AND L.UID20=A.UID20

# 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 MARKET Character(3) VARCHAR2(3) NOT NULL Market
4 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties
5 ATTR_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Attribute Item ID
6 ATTRIBUTE_VALUE Character(254) VARCHAR2(254) NOT NULL Attribute value
7 ATTR_DATE Date(10) DATE Attribute Capture Date
8 ATTR_NUMBER Signed Number(30,6) DECIMAL(28,6) NOT NULL Attribute Number
9 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
10 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
11 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
12 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
13 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.
14 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
15 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.
16 ATTRCHG_SCOPE Character(4) VARCHAR2(4) NOT NULL Attribute change scope. Used for making changes to configurable attributes
ALL=Change All
NONE=No Changes
SOME=Change Specified Values
17 ATTRCHG_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Attribute Item ID Attribute value used in attribute enhancement
18 ATTRCHG_DATE Date(10) DATE Attribute Capture Date Attribute value used in attribute enhancement
19 ATTRCHG_NUMBER Signed Number(30,6) DECIMAL(28,6) NOT NULL Attribute Number Attribute value used in attribute enhancement
20 ATTRCHG_VALUE Character(254) VARCHAR2(254) NOT NULL Attribute value used in attribute enhancement