TRFT_GETSRC_VW(SQL View) |
Index Back |
|---|
| SELECT RS.SETID , KV.TRFT_SET_ID , RS.TRFT_RULE_CD , RS.TRFT_FEATURE_CD , RS.TRFT_PRIORITY , RS.SEQ_NUM , S.TRFT_KEY_CD , S.STOP_FLAG , KS.FIELDNAME , KV.TRFT_KEY_VALUE1 , KV.TRFT_KEY_VALUE2 , KV.TRFT_KEY_VALUE3 , KV.TRFT_KEY_VALUE4 , KV.TRFT_KEY_VALUE5 , KV.TRFT_KEY_VALUE6 , KV.TRFT_KEY_VALUE7 , KV.TRFT_KEY_VALUE8 , KV.TRFT_KEY_VALUE9 , KV.PRODUCT_ID , KV.INV_ITEM_ID , KV.SHIP_TO_CUST_ID , KV.SHIP_PRIORITY_ID , KV.BUSINESS_UNIT_OM , KV.SOURCE_CD , KV.CUSTOMER_GROUP , KV.PRODUCT_GROUP , KV.REGION_CD , KV.SOLD_TO_CUST_ID , SB.PRIORITY_NBR , SB.DATE_BEGIN , SB.DATE_END , SB.EFF_STATUS , SB.TRFT_SRC_TYPE , SB.TRFT_DISPOSITION , SB.TRFT_SRC_VALUE FROM PS_TRFT_SRC_BREAK SB , PS_TRFT_SET S , PS_TRFT_RULE_SEQ RS , PS_TRFT_SET_KEYVAL KV , PS_TRFT_KEY_SET KS WHERE RS.SETID = KV.SETID AND RS.SETID = KS.SETID AND RS.TRFT_KEY_CD = KV.TRFT_KEY_CD AND RS.TRFT_KEY_CD = KS.TRFT_KEY_CD AND RS.TRFT_FEATURE_CD = KV.TRFT_FEATURE_CD AND RS.TRFT_FEATURE_CD = KS.TRFT_FEATURE_CD AND SB.SETID = KV.SETID AND SB.TRFT_SET_ID = KV.TRFT_SET_ID AND SB.TRFT_FEATURE_CD = KV.TRFT_FEATURE_CD AND S.SETID = KV.SETID AND S.TRFT_SET_ID = KV.TRFT_SET_ID AND S.TRFT_FEATURE_CD = KV.TRFT_FEATURE_CD AND S.TRFT_FEATURE_CD = '3' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | TRFT_SET_ID | Character(10) | VARCHAR2(10) NOT NULL | Rule Cd |
| 3 | TRFT_RULE_CD | Character(10) | VARCHAR2(10) NOT NULL | Arbitration Rule Code. |
| 4 | TRFT_FEATURE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Feature Code
1=Freight & Transportation Lead 2=Backorder Rule Defaulting 3=Supply Sources |
| 5 | TRFT_PRIORITY | Character(2) | VARCHAR2(2) NOT NULL |
Priority
01=Quantity Available Descending 02=Quantity Available Ascending 03=Top Priority Break First 04=Alphabetically 05=Shortest Lead Time, Alpha 06=Longest Lead Time, Alpha |
| 6 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 7 | TRFT_KEY_CD | Character(50) | VARCHAR2(50) NOT NULL | Select Key Fields |
| 8 | STOP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Stop Search Here |
| 9 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 10 | TRFT_KEY_VALUE1 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 1 |
| 11 | TRFT_KEY_VALUE2 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 2 |
| 12 | TRFT_KEY_VALUE3 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 3 |
| 13 | TRFT_KEY_VALUE4 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 4 |
| 14 | TRFT_KEY_VALUE5 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 5 |
| 15 | TRFT_KEY_VALUE6 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 6 |
| 16 | TRFT_KEY_VALUE7 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 7 |
| 17 | TRFT_KEY_VALUE8 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 8 |
| 18 | TRFT_KEY_VALUE9 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 9 |
| 19 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 20 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 21 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 22 | SHIP_PRIORITY_ID | Character(6) | VARCHAR2(6) NOT NULL | Shipping Priority Code |
| 23 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 24 | SOURCE_CD | Character(6) | VARCHAR2(6) NOT NULL | Source Code |
| 25 | CUSTOMER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Customer Group |
| 26 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |
| 27 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL | Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. |
| 28 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 29 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |
| 30 | DATE_BEGIN | Date(10) | DATE | Start Date |
| 31 | DATE_END | Date(10) | DATE | End Date |
| 32 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 33 | 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 |
| 34 | TRFT_DISPOSITION | Character(1) | VARCHAR2(1) NOT NULL |
Supply Source disposition
1=Direct Ship 2=Direct Receipt |
| 35 | TRFT_SRC_VALUE | Character(10) | VARCHAR2(10) NOT NULL | Source Value |