IN_DEL_FRTCH_VW (SQL View)	Index Back
Delivery freight rule charge The freight charge data associated with an internal freight rule. This is stored as a child record of IN_DELIVERY_ORD so that prorated freight for the rule can be displayed at the order level in a non-order restricted delivery.

IN_DEL_FRTCH_VW

(SQL View)

Delivery freight rule charge

The freight charge data associated with an internal freight rule. This is stored as a child record of IN_DELIVERY_ORD so that prorated freight for the rule can be displayed at the order level in a non-order restricted delivery.

SELECT d.business_unit , d.demand_source , d.source_bus_unit , d.order_no , d.delivery_id , d.charge_type , d.seq_num , d.freight_app , %subrec(in_del_frch_sbr, d) , %subrec(in_dttime_sbr, d) , 'N' , 'N' FROM PS_IN_DEL_FRT_CHRG d WHERE d.charge_type = 'F'

# 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 CHARGE_TYPE Character(1) VARCHAR2(1) NOT NULL Shipping Charge Type
F=Freight
M=Misc Chrgs
N=Non-stock
Default Value: F

7 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Default Value: 0

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 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

10 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

11 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID

12 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code

13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

15 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

16 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

17 FREIGHT_CHARGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge

18 FREIGHT_CURRNCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

19 FREIGHT_CHARGE_CNV Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge (base)

20 FREIGHT_CHARGE_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge (base)

21 FRT_CHRG_PRORATE Signed Number(17,4) DECIMAL(15,4) NOT NULL Prorated freight charge

22 FRT_CHRG_PRO_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Prorated freight charge

23 CURRENCY_CD_DEF Character(3) VARCHAR2(3) NOT NULL Currency Code

24 FRT_CURR_CD_BASE Character(3) VARCHAR2(3) NOT NULL Base Freight Currency Code

25 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

26 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code

27 FRT_BREAK_ID Number(10,0) DECIMAL(10) NOT NULL Frt Break ID

28 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity

29 HARMONIZED_CD Character(14) VARCHAR2(14) NOT NULL Harmonized Code

30 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

31 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

32 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

33 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

34 PRODUCT_GROUP Character(10) VARCHAR2(10) 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 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.

38 SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date

39 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

40 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

41 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method

42 STATE Character(6) VARCHAR2(6) NOT NULL State

43 TRFT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Arbitration Rule Code.

44 TRFT_SET_ID Character(10) VARCHAR2(10) NOT NULL Rule Cd

45 DTTIME_ADDED DateTime(26) TIMESTAMP Date Time Added

46 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.

47 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

48 NEW_RECORD Character(1) VARCHAR2(1) NOT NULL New Record Flag
Default Value: N

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

#	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	CHARGE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Shipping Charge Type F=Freight M=Misc Chrgs N=Non-stock Default Value: F
7	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 0
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	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
10	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
11	CARRIER_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Carrier ID
12	COMMODITY_CD	Character(10)	VARCHAR2(10) NOT NULL	Commodity Code
13	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
16	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
17	FREIGHT_CHARGE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge
18	FREIGHT_CURRNCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	FREIGHT_CHARGE_CNV	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge (base)
20	FREIGHT_CHARGE_BSE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge (base)
21	FRT_CHRG_PRORATE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Prorated freight charge
22	FRT_CHRG_PRO_BSE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Prorated freight charge
23	CURRENCY_CD_DEF	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
24	FRT_CURR_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Base Freight Currency Code
25	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
26	FREIGHT_TERMS_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Freight Terms Code
27	FRT_BREAK_ID	Number(10,0)	DECIMAL(10) NOT NULL	Frt Break ID
28	FRT_CHRG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Freight Charge Method 01=Order Value 02=Weight 03=Volume 04=Order Quantity
29	HARMONIZED_CD	Character(14)	VARCHAR2(14) NOT NULL	Harmonized Code
30	INV_ITEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Item Group
31	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
32	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID
33	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
34	PRODUCT_GROUP	Character(10)	VARCHAR2(10) 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	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.
38	SCHED_SHIP_DATE	Date(10)	DATE	Scheduled Ship Date
39	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
40	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
41	SHIP_TYPE_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Shipping Method
42	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
43	TRFT_RULE_CD	Character(10)	VARCHAR2(10) NOT NULL	Arbitration Rule Code.
44	TRFT_SET_ID	Character(10)	VARCHAR2(10) NOT NULL	Rule Cd
45	DTTIME_ADDED	DateTime(26)	TIMESTAMP	Date Time Added
46	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.
47	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
48	NEW_RECORD	Character(1)	VARCHAR2(1) NOT NULL	New Record Flag Default Value: N
49	SQL_ACTION	Character(1)	VARCHAR2(1) NOT NULL	SQL Action to Take D=Delete I=Insert N=No Action U=Update Default Value: N