TRFT_SRC_TYPE0=All Sources
1=Inventory Business Unit
2=Distribution Network
3=New Requisition
4=New Purchase Order
5=Existing Requisition
6=Existing Purchase Order
7=Existing Interunit Transfer
8=Existing Production Order
9=New Production Order
PRC_SRCTYPE_VW(SQL View) |
Index Back |
|---|---|
Source TypeSource Type |
| SELECT %Substring(A.FIELDVALUE, 1 , 1) , A.XLATLONGNAME FROM PSXLATITEM A WHERE FIELDNAME = 'TRFT_SRC_TYPE' AND %EffdtCheck(PSXLATITEM, A, %CurrentDateIn) AND a.eff_status='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRFT_SRC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Alternate Source Type
0=All Sources 1=Inventory Business Unit 2=Distribution Network 3=New Requisition 4=New Purchase Order 5=Existing Requisition 6=Existing Purchase Order 7=Existing Interunit Transfer 8=Existing Production Order 9=New Production Order |
| 2 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |