BCT_D_PO_RCV_VW

(SQL View)
 Index Back

BCTP Detail PO ASN Receipts

Bar-code transaction detail view for PO ASN Reciept of total shipment. (0101).

SELECT BUSINESS_UNIT , EIP_CTL_ID , SEQ_NBR , TRANSACTION_CODE , LAST_DTTIME , BCT_DET_STATUS , INV_LOT_ID , INV_ITEM_ID , SERIAL_ID , STORAGE_AREA , STOR_LEVEL_1 , STOR_LEVEL_2 , STOR_LEVEL_3 , STOR_LEVEL_4 , CONTAINER_ID , UNIT_OF_MEASURE , RECEIVER_ID , QTY , SCHED_LINE_NBR , DEVICE_DTTIME , SHIPTO_SETID , SHIPTO_ID , VENDOR_ID , SHIPMENT_NO , CARRIER_ID , BILL_OF_LADING , BUSINESS_UNIT_PO , PO_ID , LINE_NBR , END_TRANS_FLG , BUSINESS_UNIT_IN , VENDOR_LOT_ID , TAG_NUMBER , SF_KANBAN_ID , VNDR_LOC , PACKSLIP_NO FROM PS_BCT_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: SHIPTO_TBL.BUSINESS_UNIT_RECV

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 LAST_DTTIME DateTime(26) TIMESTAMP Last Date Time
6 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
0=Open
1=Error
2=Complete
3=Cancel
7 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE9

9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
10 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: %EDITTABLE15

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

Prompt Table: %EDITTABLE11

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

Prompt Table: %EDITTABLE12

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

Prompt Table: %EDITTABLE13

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

Prompt Table: %EDITTABLE14

15 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
16 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: %EDITTABLE10

17 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
18 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
19 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

Prompt Table: %EDITTABLE2

20 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time
21 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: %EDITTABLE3

22 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: %EDITTABLE4

23 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: %EDITTABLE5

24 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
25 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: %EDITTABLE8

26 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
27 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

Prompt Table: %EDIT_BU_PO

28 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Prompt Table: %EDITTABLE6

29 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Prompt Table: %EDITTABLE7

30 END_TRANS_FLG Character(1) VARCHAR2(1) NOT NULL End of Transaction Flag

Y/N Table Edit

31 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: %EDIT_BU_IN

32 VENDOR_LOT_ID Character(15) VARCHAR2(15) NOT NULL Vendor Lot
33 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
34 SF_KANBAN_ID Character(15) VARCHAR2(15) NOT NULL Kanban ID

Prompt Table: BCT_RPL_KRCV_VW

35 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
36 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number