BCT_UPWY_INV_VW

(SQL View)
 Index Back

Update Inventory Putaway

BCT_DTL view used to maintain Inventory Putaway 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.PTWY_PLAN_ID , A.PTWYPLAN_LN_NBR , 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.RECEIVER_ID , A.RECV_LN_NBR , A.QTY , A.COMPLETE_FLG 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 PTWY_PLAN_ID Number(10,0) DECIMAL(10) NOT NULL Putaway Plan ID

Prompt Table: BCT_PWYP_INV_VW

9 PTWYPLAN_LN_NBR Number(10,0) DECIMAL(10) NOT NULL Putaway Line Number

Prompt Table: BCT_PWYL_INV_VW

10 STAGED_DATE Date(10) DATE Staged Date

Prompt Table: BCT_PWY_STAG_VW

11 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Prompt Table: BCT_PWY_LOT_VW

12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
13 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Prompt Table: BCT_PWY_SRL_VW

14 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: STOR_AREA_VW2

15 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

Prompt Table: STOR_LEV1_VW2

16 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

Prompt Table: STOR_LEV2_VW2

17 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

Prompt Table: STOR_LEV3_VW2

18 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

Prompt Table: STOR_LEV4_VW2

19 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

Prompt Table: BCT_PWY_CNTR_VW

20 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: INV_UOM_VW

21 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

Prompt Table: BCT_PWY_RVID_VW

22 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

Prompt Table: BCT_PWY_RVLN_VW

23 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
24 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