CM_CST_NSSHP_VW

(SQL View)
 Index Back

CM Cost Non-stock Ship

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 , B.BUSINESS_UNIT_OM , A.CM_BOOK , A.TRANSACTION_GROUP , B.COST_ELEMENT , B.CURRENCY_CD , B.CURRENCY_CD , 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.APPL_JRNL_ID , %DatePart(A.DT_TIMESTAMP) , %subrec(pc_cf1_N_SBR,C) FROM PS_CM_CST_NSSHIPB A , PS_CM_CST_NSSHIP B , PS_ORD_SCHEDULE C , 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 B.BUSINESS_UNIT_OM = C.BUSINESS_UNIT AND B.ORDER_NO = C.ORDER_NO AND B.ORDER_INT_LINE_NO = C.ORDER_INT_LINE_NO AND B.SCHED_LINE_NBR = C.SCHED_LINE_NBR AND %Join(COMMON_KEYS, CM_CST_NSSHIPB A, BUS_UNIT_TBL_IN G) AND A.POSTED_FLAG = 'N' AND A.TRANSACTION_GROUP = '032' 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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
16 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
17 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
18 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
19 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
20 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended Cost
21 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
22 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
23 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least
24 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
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
27 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

28 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

29 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

30 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

31 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

32 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

33 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC