CM_CST_IBURC_VW(SQL View) |
Index Back |
|---|---|
Costed IBU Receipt 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. PSG 3/26/98 - added transfer_cost 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. 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_A , B.CM_SEQ_NBR_A , B.COST_ELEMENT , B.CM_SEQ_COST , C.STORAGE_AREA , C.SOURCE_BUS_UNIT , B.QTY_BASE , B.CM_UNIT_COST , B.UNIT_MEASURE_STD , A.DISTRIB_TYPE , A.BUDGET_DT , B.POSTED_FLAG , B.PROCESS_INSTANCE , C.CM_BU_SOURCE_GL , C.OWNERSHIP_BU , C.IU_OWNERSHIP , C.DESTIN_BU , 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.CONSIGNED_FLAG , A.FROM_PRDN_ID , A.TO_PRDN_ID , %subrec(CM_TRANS_IN_SBR, A) , A.SHIP_ID FROM PS_TRANSACTION_INV A , PS_CM_RECEIPT_COST B , PS_CM_INTRANSIT C , PS_BUS_UNIT_TBL_IN G WHERE %Join(COMMON_KEYS, TRANSACTION_INV A, CM_RECEIPT_COST B) AND %Join(COMMON_KEYS, CM_RECEIPT_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 = '022' 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
Prompt Table: MST_ITM_PRPT_VW |
| 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 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 12 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 13 | CE_EXTENDED_COST | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Extended Cost |
| 14 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 15 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table: CM_DISTR_TYPE |
| 16 | BUDGET_DT | Date(10) | DATE | Budget Date |
| 17 | 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 |
| 18 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 19 | BUS_UNIT_GL_IBU | Character(5) | VARCHAR2(5) NOT NULL | GL BU for other BU for IBU xfr |
| 20 | OWNERSHIP_BU | Character(5) | VARCHAR2(5) NOT NULL | Business Unit Owning Inventory |
| 21 | IU_OWNERSHIP | Character(1) | VARCHAR2(1) NOT NULL |
Ownership Unit
D=Destination S=Source |
| 22 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |
| 23 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 24 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 25 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 26 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 27 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 28 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 29 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 30 | SOURCE_GL_BU | Character(5) | VARCHAR2(5) NOT NULL | Source GL Business Unit |
| 31 | DESTIN_GL_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination GL Business Unit |
| 32 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
| 33 | FROM_PRDN_ID | Character(10) | VARCHAR2(10) NOT NULL | From Production ID |
| 34 | TO_PRDN_ID | Character(10) | VARCHAR2(10) NOT NULL | To Production ID |
| 35 | CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL | Container ID |
| 36 | COUNTING_EVENT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Counting Event ID |
| 37 | DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line No |
| 38 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 39 | FROM_PRDN_AREA | Character(10) | VARCHAR2(10) NOT NULL | From Production Area |
| 40 | FROM_PRDN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
From Production Type
PR=Production RW=Rework SV=Service TD=Teardown |
| 41 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 42 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 43 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 44 | 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 |
| 45 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 46 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 47 | 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 |
| 48 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 49 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 50 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 51 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 52 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 53 | STAGED_DATE | Date(10) | DATE | Staged Date |
| 54 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
| 55 | STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 56 | STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 57 | STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 58 | STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
| 59 | TO_PRDN_AREA | Character(10) | VARCHAR2(10) NOT NULL | To Production Area |
| 60 | TO_PRDN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
To Production Type
PR=Production RW=Rework SV=Service TD=Teardown |
| 61 | TO_STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 62 | TO_STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 63 | TO_STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 64 | TO_STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 65 | TO_STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
| 66 | TRANSACTION_SOURCE | Character(2) | VARCHAR2(2) NOT NULL | Transaction Source |
| 67 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 68 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |