TRFT_GETTPT_VW(SQL View) |
Index Back |
|---|---|
TRFT get transport view |
| SELECT rs.setid , kv.trft_set_id , rs.trft_rule_cd , kv.trft_feature_cd , rs.seq_num , rs.trft_priority , tr.trft_src_sort , s.trft_key_cd , 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.carrier_id , kv.carrier_id_exp , kv.commodity_cd , kv.country , tr.cust_group_flag , kv.customer_group , bt.effdt , bt.eff_status , kv.freight_terms , kv.freight_terms_exp , kv.harmonized_cd , kv.inv_item_id , kv.inv_item_group , kv.location , kv.product_group , tr.product_group_flag , kv.product_id , kv.region_cd , tr.region_flag , kv.route_cd , kv.ship_from_bu , kv.ship_to_cust_id , kv.ship_type_id , kv.ship_type_id_exp , kv.state , s.stop_flag , bt.trnspt_lead_days , bt.trnspt_lead_hours , bt.trnspt_lead_min , bt.unit_of_measure , kv.vendor_id , kv.vndr_frt_group , tr.vndr_frt_grp_flag , kv.vndr_loc , kv.x_vendor_id , kv.x_vndr_loc FROM ps_trft_tr_lead bt , PS_TRFT_SET s , ps_trft_rule_seq rs , PS_TRFT_SET_keyval kv , ps_trft_rule tr WHERE tr.setid = rs.setid AND tr.trft_rule_cd = rs.trft_rule_cd AND tr.trft_feature_cd = rs.trft_feature_cd AND rs.setid = kv.setid AND rs.trft_key_cd = kv.trft_key_cd AND rs.trft_feature_cd = kv.trft_feature_cd AND bt.setid = kv.setid AND bt.trft_set_id = kv.trft_set_id AND bt.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 = '1' AND bt.eff_status = 'A' AND (bt.trnspt_lead_days > 0 OR bt.trnspt_lead_hours > 0 OR bt.trnspt_lead_min > 0) |
| # | 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 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 6 | 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 |
| 7 | TRFT_SRC_SORT | Character(1) | VARCHAR2(1) NOT NULL |
Alternate Source/Transportation Sort Order
1=Arbitration Plan Sequence 2=Quantity Available Descending 3=Quantity Available Ascending 4=Shortest Lead Time, Plan Seq 5=Longest Lead Time, Plan Seq |
| 8 | TRFT_KEY_CD | Character(50) | VARCHAR2(50) NOT NULL | Select Key Fields |
| 9 | TRFT_KEY_VALUE1 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 1 |
| 10 | TRFT_KEY_VALUE2 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 2 |
| 11 | TRFT_KEY_VALUE3 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 3 |
| 12 | TRFT_KEY_VALUE4 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 4 |
| 13 | TRFT_KEY_VALUE5 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 5 |
| 14 | TRFT_KEY_VALUE6 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 6 |
| 15 | TRFT_KEY_VALUE7 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 7 |
| 16 | TRFT_KEY_VALUE8 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 8 |
| 17 | TRFT_KEY_VALUE9 | Character(50) | VARCHAR2(50) NOT NULL | Freight Key value 9 |
| 18 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 19 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 20 | CARRIER_ID_EXP | Character(10) | VARCHAR2(10) NOT NULL | Export Carrier ID |
| 21 | COMMODITY_CD | Character(10) | VARCHAR2(10) NOT NULL | Commodity Code |
| 22 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 23 | CUST_GROUP_FLAG | Character(2) | VARCHAR2(2) NOT NULL | Customer Group |
| 24 | CUSTOMER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Customer Group |
| 25 | EFFDT | Date(10) | DATE | Effective Date |
| 26 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 27 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL | Freight Terms Code |
| 28 | FREIGHT_TERMS_EXP | Character(10) | VARCHAR2(10) NOT NULL | Export Freight Terms Code |
| 29 | HARMONIZED_CD | Character(14) | VARCHAR2(14) NOT NULL | Harmonized Code |
| 30 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 31 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
| 32 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 33 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |
| 34 | PRODUCT_GROUP_FLAG | Character(2) | VARCHAR2(2) NOT NULL | Product Group |
| 35 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 36 | 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. |
| 37 | REGION_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Region Flag |
| 38 | ROUTE_CD | Character(6) | VARCHAR2(6) NOT NULL | A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles. |
| 39 | SHIP_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |
| 40 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 41 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 42 | SHIP_TYPE_ID_EXP | Character(10) | VARCHAR2(10) NOT NULL | Export Shipping Method |
| 43 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 44 | STOP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Stop Search Here |
| 45 | TRNSPT_LEAD_DAYS | Number(3,0) | SMALLINT NOT NULL | Transportation Lead Tm (days) |
| 46 | TRNSPT_LEAD_HOURS | Number(2,0) | SMALLINT NOT NULL | Transportation Lead Tm (Hours) |
| 47 | TRNSPT_LEAD_MIN | Number(2,0) | SMALLINT NOT NULL | Transportation Lead Tm (Min) |
| 48 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 49 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 50 | VNDR_FRT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Supplier Freight Group |
| 51 | VNDR_FRT_GRP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Supp Frt Group Flag |
| 52 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 53 | X_VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Third Party Supplier |
| 54 | X_VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Third Party Supplier Location |