TRFT_GETFRTP_VW(SQL View) |
Index Back |
|---|---|
Freight Get Freight view |
| SELECT o.business_unit , o.po_id , o.ship_id_est , rs.setid , kv.trft_set_id , rs.trft_rule_cd , s.trft_feature_cd , rs.seq_num , 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 , bf.break_qty_high , bf.break_qty_low , kv.business_unit_in , kv.carrier_id , kv.carrier_id_exp , kv.category_cd , kv.commodity_cd , bf.currency_cd , kv.customer_group , bf.date_begin , bf.date_end , bf.eff_status , bf.freight_charge , kv.freight_terms , kv.freight_terms_exp , bf.frt_break_id , bf.frt_chrg_method , bf.trft_adjst_type , bf.freight_pct , kv.harmonized_cd , kv.inv_item_id , kv.inv_item_group , kv.location , kv.product_group , kv.product_id , kv.region_cd , kv.route_cd , kv.ship_from_bu , kv.shipto_id , kv.ship_to_cust_id , kv.ship_type_id , kv.ship_type_id_exp , ' ' , s.stop_flag , bf.unit_of_measure , kv.vendor_id , kv.vndr_frt_group , kv.vndr_loc , kv.x_vendor_id , kv.x_vndr_loc FROM PS_TRFT_FRT_BREAK bf , ps_trft_set s , ps_trft_rule_seq rs , ps_trft_set_keyval kv , ps_po_frt_set o WHERE kv.trft_set_id = o.trft_set_id AND rs.setid = kv.setid AND rs.trft_key_cd = kv.trft_key_cd AND rs.trft_feature_cd = kv.trft_feature_cd AND bf.setid = kv.setid AND bf.trft_set_id = kv.trft_set_id AND bf.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' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | SHIP_ID_EST |
Character(10) | VARCHAR2(10) NOT NULL | Estimated Ship ID |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | TRFT_SET_ID | Character(10) | VARCHAR2(10) NOT NULL | Rule Cd |
| 6 | TRFT_RULE_CD | Character(10) | VARCHAR2(10) NOT NULL | Arbitration Rule Code. |
| 7 | TRFT_FEATURE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Feature Code
1=Freight & Transportation Lead 2=Backorder Rule Defaulting 3=Supply Sources |
| 8 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 9 | TRFT_KEY_CD | Character(50) | VARCHAR2(50) NOT NULL | Select Key Fields |
| 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 | BREAK_QTY_HIGH | Number(15,4) | DECIMAL(14,4) NOT NULL | Upper Quantity/Amount |
| 20 | BREAK_QTY_LOW | Number(15,4) | DECIMAL(14,4) NOT NULL | Low Quantity/Amount |
| 21 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 22 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 23 | CARRIER_ID_EXP | Character(10) | VARCHAR2(10) NOT NULL | Export Carrier ID |
| 24 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL | Category Code |
| 25 | COMMODITY_CD | Character(10) | VARCHAR2(10) NOT NULL | Commodity Code |
| 26 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 27 | CUSTOMER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Customer Group |
| 28 | DATE_BEGIN | Date(10) | DATE | Start Date |
| 29 | DATE_END | Date(10) | DATE | End Date |
| 30 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 31 | FREIGHT_CHARGE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 32 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL | Freight Terms Code |
| 33 | FREIGHT_TERMS_EXP | Character(10) | VARCHAR2(10) NOT NULL | Export Freight Terms Code |
| 34 | FRT_BREAK_ID | Number(10,0) | DECIMAL(10) NOT NULL | Frt Break ID |
| 35 | FRT_CHRG_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
Freight Charge Method
01=Order Value 02=Weight 03=Volume 04=Order Quantity |
| 36 | TRFT_ADJST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Freight Adjustment Type
1=Amount 2=Percent |
| 37 | FREIGHT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Freight Percent |
| 38 | HARMONIZED_CD | Character(14) | VARCHAR2(14) NOT NULL | Harmonized Code |
| 39 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 40 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
| 41 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 42 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |
| 43 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 44 | 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. |
| 45 | 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. |
| 46 | SHIP_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |
| 47 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 48 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 49 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 50 | SHIP_TYPE_ID_EXP | Character(10) | VARCHAR2(10) NOT NULL | Export Shipping Method |
| 51 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 52 | STOP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Stop Search Here |
| 53 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 54 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 55 | VNDR_FRT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Supplier Freight Group |
| 56 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 57 | X_VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Third Party Supplier |
| 58 | X_VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Third Party Supplier Location |