TRFT_GETBO_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.BUSINESS_UNIT_IN , KV.PRODUCT_ID , KV.INV_ITEM_ID , KV.INV_ITEM_GROUP , KV.SHIP_TO_CUST_ID , KV.SHIP_PRIORITY_ID , KV.ORDER_GRP , KV.SOURCE_CD , KV.CUSTOMER_GROUP , KV.PRODUCT_GROUP , KV.REGION_CD , KV.SOLD_TO_CUST_ID , TB.SEQ_NBR , TB.DATE_BEGIN , TB.DATE_END , TB.EFF_STATUS , TB.RULE_CD , TB.RULE_TYPE FROM PS_TRFT_BO_BREAK TB , 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 TB.SETID = KV.SETID AND TB.TRFT_SET_ID = KV.TRFT_SET_ID AND TB.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 = '2' |
| # | 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 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 20 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 21 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 22 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
| 23 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 24 | SHIP_PRIORITY_ID | Character(6) | VARCHAR2(6) NOT NULL | Shipping Priority Code |
| 25 | ORDER_GRP | Character(6) | VARCHAR2(6) NOT NULL | Order Group |
| 26 | SOURCE_CD | Character(6) | VARCHAR2(6) NOT NULL | Source Code |
| 27 | CUSTOMER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Customer Group |
| 28 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |
| 29 | 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. |
| 30 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 31 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 32 | DATE_BEGIN | Date(10) | DATE | Start Date |
| 33 | DATE_END | Date(10) | DATE | End Date |
| 34 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 35 | RULE_CD | Character(5) | VARCHAR2(5) NOT NULL | Rule Code |
| 36 | RULE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Rule Type
B=Line Backorder Rule L=Line Reservation - Backorder O=Order Reservation Rule R=Line Reservation Rule |