AR_BASE_GROUPS1(SQL View) |
Index Back |
|---|---|
AR Tiles GroupsGroups/buckets for AR Tiles |
| SELECT DISPLAY_ORDER ,AR_TPERIOD_NAME ,DAYS_FROM3 ,DAYS_TO3 ,'AR' FROM PS_AR_BASE_GROUP WHERE TILE_ID IN ('AR_PYMNT','AR_DISP') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DISPLAY_ORDER | Number(3,0) | SMALLINT NOT NULL | Display order for ordering items in a list - web style |
| 2 | AR_TPERIOD_NAME | Character(10) | VARCHAR2(10) NOT NULL | Period Name |
| 3 | FROM_RANGE | Signed Number(15,3) | DECIMAL(13,3) NOT NULL | From number |
| 4 | TO_RANGE | Signed Number(15,3) | DECIMAL(13,3) NOT NULL | To number |
| 5 | PRODUCT_OE | Character(6) | VARCHAR2(6) NOT NULL | Product |