CM_CST_SHPAJ_VW

(SQL View)
 Index Back

Costed Shipping Adjustment Vw

PSG CN# CM750-10.0 10/30/97 this selects transactions created by Depletion when the qyt shipped is less than the qty picked. PSG CN# CM750-10.0 10/30/97 added account and cf16_sn_sbr. 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. CN# CM750-10.0 PSG 11/21/97: add projects fields. KDN CM800-7.1: Added ALTACCT field. 07/21/99 ebn CN#CM800-9.0 Changed view for LIFO/FIFO Enhancement to use CM_RECEIPT_COST instead of COST_INV. 08/05/99 ebn CN#CM800-1.0 Added budget_dt for commitment control. 05/05/00 tw CN#R-ANURUD-TC534 Removed chartfields.

SELECT b.business_unit , b.inv_item_id , b.cm_book , b.dt_timestamp , b.seq_nbr , b.cm_dt_timestamp_a , b.cm_seq_nbr_a , b.cost_element , b.cm_seq_cost , a.storage_area , a.stor_level_1 , a.stor_level_2 , a.stor_level_3 , a.stor_level_4 , a.staged_date , a.container_id , a.adjust_type , %DecMult(b.qty_base,-1) , %Round(b.cm_unit_cost,4) , b.unit_measure_std , a.business_unit_pc , a.activity_id , a.resource_type , a.resource_category , a.resource_sub_cat , a.analysis_type , a.distrib_type , a.inv_lot_id , a.serial_id , a.receiver_id , a.recv_ln_nbr , a.budget_dt , b.posted_flag , b.process_instance FROM PS_TRANSACTION_INV a , ps_cm_receipt_cost b WHERE %Join(common_keys, transaction_inv a, cm_receipt_cost b) AND b.posted_flag = 'N' AND b.transaction_group = '052' AND b.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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
4 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
7 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
8 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
9 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
10 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
11 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
12 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
13 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
14 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
15 STAGED_DATE Date(10) DATE Staged Date
16 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
17 ADJUST_TYPE Character(1) VARCHAR2(1) NOT NULL Adjustment Type
0=CM Only
A=VMI Return
D=Decrease
I=Increase
M=Misc Issue
R=Misc Return
S=Scrap
V=Scrap RTV
18 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
19 TOTAL_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Total Cost
20 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
21 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
22 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
23 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
24 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
25 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
26 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
27 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
28 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
29 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
30 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
31 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
32 BUDGET_DT Date(10) DATE Budget Date
33 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
34 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance