CM_CST_FRGHT_VW

(SQL View)
 Index Back

Costed Freight Charges

Cost record for OM non-stocked "shipments". Used by 'Mark for Billing' function. CN# CM750-10.0 PSG 11/10/97 - multiply PxQ in COBOL instead of the view to aviod error when there are too many decimals. 07/21/99 ebn CN#CM800-9.0 Incorporated table CM_NSSHIPB into view. 12/08 F-MLIZI-L7QX0: add DELIVERY_ID for 9.1 freight project

SELECT A.BUSINESS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.INV_ITEM_ID , A.SEQ_NBR , A.SHIP_ID , A.DELIVERY_ID , A.CHARGE_TYPE , A.BUSINESS_UNIT_OM , A.CM_BOOK , A.TRANSACTION_GROUP , B.COST_ELEMENT , A.POSTED_FLAG , B.DISTRIB_TYPE , B.QTY_BASE , A.DT_TIMESTAMP , B.UNIT_COST , B.UNIT_MEASURE_STD , A.PROCESS_INSTANCE , A.PROCESS_FLAG , G.BUSINESS_UNIT_GL , G.BASE_CURRENCY , G.BASE_CURRENCY , G.APPL_JRNL_ID , %DatePart(A.DT_TIMESTAMP) FROM PS_CM_CST_NSSHIPB A , PS_CM_CST_NSSHIP B , PS_BUS_UNIT_TBL_IN G WHERE A.ORDER_NO = B.ORDER_NO AND A.ORDER_INT_LINE_NO = B.ORDER_INT_LINE_NO AND A.SCHED_LINE_NBR = B.SCHED_LINE_NBR AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.SEQ_NBR = B.SEQ_NBR AND A.SHIP_ID = B.SHIP_ID AND A.DELIVERY_ID = B.DELIVERY_ID AND A.CHARGE_TYPE = B.CHARGE_TYPE AND A.BUSINESS_UNIT_OM = B.BUSINESS_UNIT_OM AND %Join(COMMON_KEYS, CM_CST_NSSHIP B, BUS_UNIT_TBL_IN G) AND A.POSTED_FLAG = 'N' AND A.TRANSACTION_GROUP = '501' AND A.CM_COST_MODE = 'L'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 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
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
7 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
8 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
9 CHARGE_TYPE Character(1) VARCHAR2(1) NOT NULL Shipping Charge Type
F=Freight
M=Misc Chrgs
N=Non-stock
10 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
11 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
12 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
13 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
14 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted
15 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
16 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
17 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
18 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended Cost
19 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
20 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
21 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least
22 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
24 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
25 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
26 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple