IN_DEL_FRTRL_VW

(SQL View)
 Index Back

Delivery freight rule

The freight rules found for calculating freight for a delivery. This record is a child of the delivery record IN_DELIVERY.

SELECT d.business_unit , d.demand_source , d.source_bus_unit , d.order_no , d.delivery_id , d.seq_num , d.trft_set_id , d.freight_app , %subrec(in_dttime_sbr, d) , 'N' , 'N' FROM PS_IN_DEL_FRT_RULE d

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
4 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
5 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

Default Value: 0

7 TRFT_SET_ID Character(10) VARCHAR2(10) NOT NULL Rule Cd
8 FREIGHT_APP Character(2) VARCHAR2(2) NOT NULL Identifier with regards to which product calculated freight for a delivery
IN=Inventory
OM=Order Management

Default Value: IN

9 DTTIME_ADDED DateTime(26) TIMESTAMP Date Time Added
10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
11 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
12 NEW_RECORD Character(1) VARCHAR2(1) NOT NULL New Record Flag

Default Value: N

13 SQL_ACTION Character(1) VARCHAR2(1) NOT NULL SQL Action to Take
D=Delete
I=Insert
N=No Action
U=Update

Default Value: N