BCT_UTFR_INV_VW(SQL View) |
Index Back |
---|---|
Update Inventory TransfersBCT_DTL view used to maintain Inventory Transfer transactions. |
SELECT A.BUSINESS_UNIT , A.EIP_CTL_ID , A.SEQ_NBR , A.TRANSACTION_CODE , A.EIP_TRANS_SRC_SEQ , A.LAST_DTTIME , A.BCT_DET_STATUS , A.STAGED_DATE , A.INV_LOT_ID , A.INV_ITEM_ID , A.SERIAL_ID , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.CONTAINER_ID , A.UNIT_OF_MEASURE , A.TO_CONTAINER_ID , A.TO_STORAGE_AREA , A.TO_STOR_LEVEL_1 , A.TO_STOR_LEVEL_2 , A.TO_STOR_LEVEL_3 , A.TO_STOR_LEVEL_4 , A.QTY , A.COMPLETE_FLG , A.PRODUCTION_ID , A.SF_KANBAN_ID , A.END_TRANS_FLG , A.PICK_BATCH_ID , A.PICKLIST_LINE_NO , A.INCLUDE_ALLOC_FLG , A.INCLUDE_RELSD_FLG , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR FROM PS_BCT_DTL A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
2 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
3 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
4 | TRANSACTION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
5 | EIP_TRANS_SRC_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Source Transaction Sequence |
6 | LAST_DTTIME | DateTime(26) | TIMESTAMP NOT NULL | Last Date Time |
7 | BCT_DET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open 1=Error 2=Complete 3=Cancel |
8 | STAGED_DATE | Date(10) | DATE |
Staged Date
Prompt Table: BCT_STAG_INV_VW |
9 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Lot ID
Prompt Table: %EDITTABLE |
10 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: BU_ITM_INV_VW |
11 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL |
Serial ID
Prompt Table: BCT_SRAL_INV_VW |
12 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table: STOR_AREA_VW2 |
13 | STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table: STOR_LEV1_VW2 |
14 | STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table: STOR_LEV2_VW2 |
15 | STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table: STOR_LEV3_VW2 |
16 | STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table: STOR_LEV4_VW2 |
17 | CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Container ID
Prompt Table: CNTR_ID_INV |
18 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Default Value: MASTER_ITEM_TBL.UNIT_MEASURE_STD Prompt Table: %EDITTABLE2 |
19 | TO_CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Container ID
Prompt Table: CNTR_ID_INV |
20 | TO_STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table: BCT_ST_AREA_VW2 |
21 | TO_STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table: BCT_STORLV1_VW2 |
22 | TO_STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table: BCT_STORLV2_VW2 |
23 | TO_STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table: BCT_STORLV3_VW2 |
24 | TO_STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table: BCT_STORLV4_VW2 |
25 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
26 | COMPLETE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Complete Flag
0=Process Location 1=Pick Line Complete 2=Pick Batch Complete 3=Pick Line as Planned 4=Pick Batch as Planned 5=Process Location - Incomplete 6=Complete Pick - Zero Quantity 7=Complete Pick - Leave Alone 8=Complete Pick - Dft Ship Loc A=Use Defaults B=No Action |
27 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL |
Production ID
Prompt Table: INV_SIT_SRCH_VW |
28 | SF_KANBAN_ID | Character(15) | VARCHAR2(15) NOT NULL | Kanban ID |
29 | END_TRANS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Kanban Complete
Y/N Table Edit Default Value: Y |
30 | PICK_BATCH_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Pick Batch ID
Prompt Table: %EDITTABLE8 |
31 | PICKLIST_LINE_NO | Number(7,0) | INTEGER NOT NULL |
Pick List Sorting Line Number
Prompt Table: %EDITTABLE9 |
32 | INCLUDE_ALLOC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include Pre-Relsd Allocations
Y/N Table Edit |
33 | INCLUDE_RELSD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include Released Allocations
Y/N Table Edit |
34 | DEMAND_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order |
35 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Source Bus Unit
Prompt Table: DMD_BCTR_SRC_VW |
36 | 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
Prompt Table: DMD_BCTR_ORD_VW |
37 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL |
Order Line
Prompt Table: DMD_BCTR_ORL_VW |
38 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL |
Schedule Line Number
Prompt Table: DMD_BCTR_SCH_VW |