CM_CST_IBUIS_VW(SQL View) |
Index Back |
---|---|
Costed Interunit Shipment ViewCN# 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. PSG 3/26/98 - added transfer_cost KDN CM800-7.1: Added ALTACCT field. 07/21/99 ebn CN#CM800-9.0 Changed view for LIFO/FIFO Enhancement to use CM_DEPLETE_COST instead of COST_INV. 08/05/99 ebn CN#CM800-1.0 Added budget_dt for commitment control. 03/08/01 tw CN#R-ORICHA-HA99V added Lot ID and Serial ID. 05/02 MXS B1068/RES100269/INC7726001 : acctglines not generated - CM 8.4 bundle |
SELECT B.BUSINESS_UNIT , B.INV_ITEM_ID , B.CM_BOOK , B.DT_TIMESTAMP , B.SEQ_NBR , B.CM_DT_TIMESTAMP , B.CM_SEQ_NBR , B.CM_DT_TIMESTAMP_A , B.CM_SEQ_NBR_A , B.COST_ELEMENT , B.CM_SEQ_COST , C.SOURCE_BUS_UNIT , C.DESTIN_BU , C.STORAGE_AREA , B.QTY_BASE , B.CM_UNIT_COST , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF16_AN_SBR,A) , %subrec(PC_CF1_N_SBR,A) , B.UNIT_MEASURE_STD , A.DISTRIB_TYPE , A.BUDGET_DT , B.CONSIGNED_FLAG , B.POSTED_FLAG , B.PROCESS_INSTANCE , C.CM_BU_DESTIN_GL , C.OWNERSHIP_BU , C.IU_OWNERSHIP , B.TRANSACTION_GROUP , G.BUSINESS_UNIT_GL , B.CURRENCY_CD , B.CURRENCY_CD , G.APPL_JRNL_ID , A.TRANSACTION_DATE , A.BUSINESS_UNIT , C.CM_BU_SOURCE_GL , C.CM_BU_DESTIN_GL , A.FROM_PRDN_ID , A.TO_PRDN_ID , %subrec(CM_TRANS_IN_SBR, A) , A.SHIP_ID FROM PS_TRANSACTION_INV A , PS_CM_DEPLETE_COST B , PS_CM_INTRANSIT C , PS_BUS_UNIT_TBL_IN G WHERE %Join(COMMON_KEYS, TRANSACTION_INV A, CM_DEPLETE_COST B) AND %Join(COMMON_KEYS, CM_DEPLETE_COST B, CM_INTRANSIT C) AND %Join(COMMON_KEYS, TRANSACTION_INV A, BUS_UNIT_TBL_IN G) AND B.POSTED_FLAG = 'N' AND B.TRANSACTION_GROUP = '031' 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 NOT NULL | Date Timestamp |
5 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
6 | CM_DT_TIMESTAMP | DateTime(26) | TIMESTAMP NOT NULL | Receipt dttm. |
7 | CM_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
8 | CM_DT_TIMESTAMP_A | DateTime(26) | TIMESTAMP NOT NULL | 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd. |
9 | CM_SEQ_NBR_A | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
10 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
11 | CM_SEQ_COST | Number(15,0) | DECIMAL(15) NOT NULL | Cost Sequence Number. Incremented each time the actual cost is updated. |
12 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
13 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |
14 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
15 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
16 | CE_EXTENDED_COST | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Extended Cost |
17 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
18 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
19 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPTID_BUGL_VW |
20 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW |
21 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_BUGL_VW |
22 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL_VW |
23 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASSCF_BUGL_VW |
24 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW |
25 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_BUGL_VW |
26 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
27 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
28 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
29 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL_VW |
30 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW |
31 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW |
32 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: %EDIT_BU_PC |
33 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: %EDIT_PROJECT |
34 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: %EDIT_ACTIVITY |
35 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
|
36 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
|
37 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
|
38 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
|
39 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
40 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table: CM_DISTR_TYPE |
41 | BUDGET_DT | Date(10) | DATE | Budget Date |
42 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
43 | 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 |
44 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
45 | BUS_UNIT_GL_IBU | Character(5) | VARCHAR2(5) NOT NULL | GL BU for other BU for IBU xfr |
46 | OWNERSHIP_BU | Character(5) | VARCHAR2(5) NOT NULL | Business Unit Owning Inventory |
47 | IU_OWNERSHIP | Character(1) | VARCHAR2(1) NOT NULL |
Ownership Unit
D=Destination S=Source |
48 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
49 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
50 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
51 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
52 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
53 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
54 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
55 | SOURCE_GL_BU | Character(5) | VARCHAR2(5) NOT NULL | Source GL Business Unit |
56 | DESTIN_GL_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination GL Business Unit |
57 | FROM_PRDN_ID | Character(10) | VARCHAR2(10) NOT NULL | From Production ID |
58 | TO_PRDN_ID | Character(10) | VARCHAR2(10) NOT NULL | To Production ID |
59 | CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL | Container ID |
60 | COUNTING_EVENT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Counting Event ID |
61 | DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line No |
62 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
63 | FROM_PRDN_AREA | Character(10) | VARCHAR2(10) NOT NULL | From Production Area |
64 | FROM_PRDN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
From Production Type
PR=Production RW=Rework SV=Service TD=Teardown |
65 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
66 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
67 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
68 | 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 |
69 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
70 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
71 | PRODUCTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
72 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
73 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
74 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
75 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
76 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
77 | STAGED_DATE | Date(10) | DATE | Staged Date |
78 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
79 | STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
80 | STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
81 | STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
82 | STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
83 | TO_PRDN_AREA | Character(10) | VARCHAR2(10) NOT NULL | To Production Area |
84 | TO_PRDN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
To Production Type
PR=Production RW=Rework SV=Service TD=Teardown |
85 | TO_STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
86 | TO_STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
87 | TO_STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
88 | TO_STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
89 | TO_STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
90 | TRANSACTION_SOURCE | Character(2) | VARCHAR2(2) NOT NULL | Transaction Source |
91 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
92 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |