FEATURE_CDFFS_FUNCTION_CD010=Purchase
020=Production
030=Transfer Demand
035=Transfer Supply
070=Stock Request
090=Sales Order
100=Requisition
110=WO Inventory
115=WO Non-Inventory
FFS_FTR_FUNC(SQL Table) |
Index Back |
|---|---|
Feature Functions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FEATURE_CD |
Character(10) | VARCHAR2(10) NOT NULL | Feature Code |
| 2 | FFS_FUNCTION_CD |
Character(10) | VARCHAR2(10) NOT NULL | Function Code |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | SORT_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Sort Sequence Number |
| 6 | PEG_ORDER_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Used by Pegging Maintenance/Inquiry
010=Purchase 020=Production 030=Transfer Demand 035=Transfer Supply 070=Stock Request 090=Sales Order 100=Requisition 110=WO Inventory 115=WO Non-Inventory |
| 7 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |