INV_FUL_HDR_VW (SQL View)	Index Back
Update Fulfillment Requests BCT_DTL view used to maintain fulfillment request transactions.

INV_FUL_HDR_VW

(SQL View)

Update Fulfillment Requests

BCT_DTL view used to maintain fulfillment request transactions.

SELECT BUSINESS_UNIT , EIP_CTL_ID , SEQ_NBR , TRANSACTION_CODE , LAST_DTTIME , BCT_DET_STATUS , EIP_TRANS_SRC_SEQ , SELECT_UNFULFILLED , SELECT_RELEASABLE , SELECT_RELEASED , SELECT_CONFIRMED , PASS_THROUGH_LEVEL , DEMAND_SOURCE , SOURCE_BUS_UNIT , AUTO_PICK_SEL , AUTO_RELEASE_OPT , AUTO_SHIP_SEL , SHIP_ID , SHIP_ID_FLG , CARRIER_ID , CARRIER_ID_FLG , SHIP_TYPE_ID , SHIP_TYPE_ID_FLG , SHIP_DATE , SHIP_DATE_FLG , SHIP_TIME , SHIP_TIME_FLG , STORAGE_AREA , STOR_LEVEL_1 , STOR_LEVEL_2 , STOR_LEVEL_3 , STOR_LEVEL_4 , BILL_OF_LADING , BILL_OF_LADING_FLG , PRO_NUMBER , PRO_NUMBER_FLG , TRACKING_NBR , TRACKING_NBR_FLG , FREIGHT_AMT , FREIGHT_AMT_FLG , FREIGHT_TERMS , FREIGHT_TERMS_FLG , FREIGHT_CALC_FLAG , LEAD_DAYS , USE_LEAD_DAYS , SHORT_SHIP_OPT , SHIP_CNTR_ID , COMPLETE_FLG , IN_DFR_DPL_OVRD , IN_CREATE_DMD_FLG , DELIVERY_ID , IN_FRT_P_BILFRT , IN_FRT_P_CMPFRT , IN_FRT_P_MANFRT , IN_BEST_WAY_BTN , IN_FRT_OPTION , FRT_TYPE_CODE , DEL_VALIDATE_OPT , RESEND_FRT_RQST , RESEND_FRT_RECV , AMOUNT_ACTION FROM %Table(BCT_DTL)

# 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 LAST_DTTIME DateTime(26) TIMESTAMP NOT NULL Last Date Time
Default Value: %Datetime

6 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
0=Open
1=Error
2=Complete
3=Cancel
Default Value: 0

7 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence

8 SELECT_UNFULFILLED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state.
Y/N Table Edit
Default Value: N

9 SELECT_RELEASABLE Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in a releasable state.
Y/N Table Edit
Default Value: N

10 SELECT_RELEASED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in an Released state.
Y/N Table Edit
Default Value: N

11 SELECT_CONFIRMED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in a confirmed state.
Y/N Table Edit
Default Value: N

12 PASS_THROUGH_LEVEL Character(2) VARCHAR2(2) NOT NULL Provides the ability to pass good transactions through the system while holding up transactions that need additional review. When processing, the Pass-through Level must be less than or equal to Processing Level and Commit Level. If the process recieves a Pass-through Level greater than the specified Commit Level or Processing Level, the Commit Group and/or Processing Group will be expanded to include all data at the Pass-through Level.
10=Request
20=Order
30=Line

13 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

14 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
Prompt Table: SP_BUIN_NONVW

15 AUTO_PICK_SEL Character(1) VARCHAR2(1) NOT NULL The field is used to select the auto pick options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"
Default Value: 0

16 AUTO_RELEASE_OPT Character(2) VARCHAR2(2) NOT NULL Auto Release Option
00=No Auto-Processing
10=Use Auto-Processing Default
20=Advance to Reserved
30=Advance to Releasable
40=Advance to Released
50=Advance to Confirmed
60=Advance to Shipped
70=Advance to Depleted
Default Value: 00

17 AUTO_SHIP_SEL Character(1) VARCHAR2(1) NOT NULL Used to capture the auto ship options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"
Default Value: 0

18 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID

19 SHIP_ID_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Ship Id should be overridden with a blank value
Y/N Table Edit
Default Value: N

20 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
Prompt Table: CARRIER_VW

21 CARRIER_ID_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Carrier ID should be overridden with a blank value
Y/N Table Edit
Default Value: N

22 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
Prompt Table: SHIP_METHOD_VW

23 SHIP_TYPE_ID_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Ship Via should be overridden with a blank value
Y/N Table Edit
Default Value: N

24 SHIP_DATE Date(10) DATE Item Shipping Date

25 SHIP_DATE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Ship Date should be overridden with a blank value
Y/N Table Edit
Default Value: N

26 SHIP_TIME Time(15) TIMESTAMP Ship Time

27 SHIP_TIME_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Ship Time should be overridden with a blank value
Y/N Table Edit
Default Value: N

28 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
Prompt Table: STOR_AREA_VW2

29 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
Prompt Table: STOR_LEV1_VW2

30 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
Prompt Table: STOR_LEV2_VW2

31 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
Prompt Table: STOR_LEV3_VW2

32 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
Prompt Table: STOR_LEV4_VW2

33 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.

34 BILL_OF_LADING_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Bill of Lading should be overridden with a blank value
Y/N Table Edit
Default Value: N

35 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number

36 PRO_NUMBER_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Pro Number should be overridden with a blank value
Y/N Table Edit
Default Value: N

37 TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Tracking Number

38 TRACKING_NBR_FLG Character(1) VARCHAR2(1) NOT NULL Clear Tracking Number
Y/N Table Edit
Default Value: N

39 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount

40 FREIGHT_AMT_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Freight Amount should be overridden with a blank (zero) value
Y/N Table Edit
Default Value: N

41 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
Prompt Table: FREIGHT_TERMS

42 FREIGHT_TERMS_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Freight Terms should be overridden with a blank value
Y/N Table Edit
Default Value: N

43 FREIGHT_CALC_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Calculate Flag
Y/N Table Edit
Default Value: N

44 LEAD_DAYS Number(4,0) SMALLINT NOT NULL Lead Days for Calendar

45 USE_LEAD_DAYS Character(1) VARCHAR2(1) NOT NULL Use Lead Days
1=Use Fulfillment Lead Days
2=Override Fulfillment Lead Days
3=Ignore Lead Days
Default Value: 1

46 SHORT_SHIP_OPT Character(2) VARCHAR2(2) NOT NULL Short Shipment Option
01=Scrap the Undershipment
02=Return to Location Picked From
Default Value: 02

47 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID

48 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
Prompt Table: BCT_CGRP_INV_VW

49 IN_DFR_DPL_OVRD Character(1) VARCHAR2(1) NOT NULL used to override the defer depletions field on in_demand
1=Override to Yes
2=Override to No

50 IN_CREATE_DMD_FLG Character(1) VARCHAR2(1) NOT NULL Create Demand
Y/N Table Edit

51 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID

52 IN_FRT_P_BILFRT Character(1) VARCHAR2(1) NOT NULL Commit Billable Freight
Y/N Table Edit

53 IN_FRT_P_CMPFRT Character(1) VARCHAR2(1) NOT NULL Freight Complete
Y/N Table Edit

54 IN_FRT_P_MANFRT Character(1) VARCHAR2(1) NOT NULL External Manifest
Y/N Table Edit

55 IN_BEST_WAY_BTN Character(2) VARCHAR2(2) NOT NULL Best Way Freight Option
10=Least Cost
20=By Commit Date

56 IN_FRT_OPTION Character(2) VARCHAR2(2) NOT NULL Freight Options
10=Shop For Rates
20=Best Way
30=Use Specified Carrier
40=Carrier with Best Way

57 FRT_TYPE_CODE Character(10) VARCHAR2(10) NOT NULL Freight Type Code
Prompt Table: IN_FRT_DFLT

58 DEL_VALIDATE_OPT Character(2) VARCHAR2(2) NOT NULL Delivery validation option
10=Validate Only
20=Validate/Assign to New
30=Validate/Auto Assign Open
40=Validate/Auto Assign All
50=Reassign/Consolidate
60=Do Not Validate

59 RESEND_FRT_RQST Character(1) VARCHAR2(1) NOT NULL 02/02/09 EGS: Created

60 RESEND_FRT_RECV Character(1) VARCHAR2(1) NOT NULL 02/02/09 EGS: Created

61 AMOUNT_ACTION Character(1) VARCHAR2(1) NOT NULL 10/29/08 EGS: Created
1=Override
2=Increment

#	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	LAST_DTTIME	DateTime(26)	TIMESTAMP NOT NULL	Last Date Time Default Value: %Datetime
6	BCT_DET_STATUS	Character(1)	VARCHAR2(1) NOT NULL	BCTP Detail Status 0=Open 1=Error 2=Complete 3=Cancel Default Value: 0
7	EIP_TRANS_SRC_SEQ	Number(15,0)	DECIMAL(15) NOT NULL	Source Transaction Sequence
8	SELECT_UNFULFILLED	Character(1)	VARCHAR2(1) NOT NULL	Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state. Y/N Table Edit Default Value: N
9	SELECT_RELEASABLE	Character(1)	VARCHAR2(1) NOT NULL	Indicates requests fed to the Fulfillment Engine should include data in a releasable state. Y/N Table Edit Default Value: N
10	SELECT_RELEASED	Character(1)	VARCHAR2(1) NOT NULL	Indicates requests fed to the Fulfillment Engine should include data in an Released state. Y/N Table Edit Default Value: N
11	SELECT_CONFIRMED	Character(1)	VARCHAR2(1) NOT NULL	Indicates requests fed to the Fulfillment Engine should include data in a confirmed state. Y/N Table Edit Default Value: N
12	PASS_THROUGH_LEVEL	Character(2)	VARCHAR2(2) NOT NULL	Provides the ability to pass good transactions through the system while holding up transactions that need additional review. When processing, the Pass-through Level must be less than or equal to Processing Level and Commit Level. If the process recieves a Pass-through Level greater than the specified Commit Level or Processing Level, the Commit Group and/or Processing Group will be expanded to include all data at the Pass-through Level. 10=Request 20=Order 30=Line
13	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
14	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit Prompt Table: SP_BUIN_NONVW
15	AUTO_PICK_SEL	Character(1)	VARCHAR2(1) NOT NULL	The field is used to select the auto pick options for fulfillment. 0=Use Default Values 1=Override to "Yes" 2=Override to "No" Default Value: 0
16	AUTO_RELEASE_OPT	Character(2)	VARCHAR2(2) NOT NULL	Auto Release Option 00=No Auto-Processing 10=Use Auto-Processing Default 20=Advance to Reserved 30=Advance to Releasable 40=Advance to Released 50=Advance to Confirmed 60=Advance to Shipped 70=Advance to Depleted Default Value: 00
17	AUTO_SHIP_SEL	Character(1)	VARCHAR2(1) NOT NULL	Used to capture the auto ship options for fulfillment. 0=Use Default Values 1=Override to "Yes" 2=Override to "No" Default Value: 0
18	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID
19	SHIP_ID_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates Ship Id should be overridden with a blank value Y/N Table Edit Default Value: N
20	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID Prompt Table: CARRIER_VW
21	CARRIER_ID_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates Carrier ID should be overridden with a blank value Y/N Table Edit Default Value: N
22	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD_VW
23	SHIP_TYPE_ID_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates Ship Via should be overridden with a blank value Y/N Table Edit Default Value: N
24	SHIP_DATE	Date(10)	DATE	Item Shipping Date
25	SHIP_DATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates Ship Date should be overridden with a blank value Y/N Table Edit Default Value: N
26	SHIP_TIME	Time(15)	TIMESTAMP	Ship Time
27	SHIP_TIME_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates Ship Time should be overridden with a blank value Y/N Table Edit Default Value: N
28	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	Storage Area Prompt Table: STOR_AREA_VW2
29	STOR_LEVEL_1	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 1 Prompt Table: STOR_LEV1_VW2
30	STOR_LEVEL_2	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 2 Prompt Table: STOR_LEV2_VW2
31	STOR_LEVEL_3	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 3 Prompt Table: STOR_LEV3_VW2
32	STOR_LEVEL_4	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 4 Prompt Table: STOR_LEV4_VW2
33	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
34	BILL_OF_LADING_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates Bill of Lading should be overridden with a blank value Y/N Table Edit Default Value: N
35	PRO_NUMBER	Character(40)	VARCHAR2(40) NOT NULL	Pro Number
36	PRO_NUMBER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates Pro Number should be overridden with a blank value Y/N Table Edit Default Value: N
37	TRACKING_NBR	Character(30)	VARCHAR2(30) NOT NULL	Tracking Number
38	TRACKING_NBR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Clear Tracking Number Y/N Table Edit Default Value: N
39	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
40	FREIGHT_AMT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates Freight Amount should be overridden with a blank (zero) value Y/N Table Edit Default Value: N
41	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: FREIGHT_TERMS
42	FREIGHT_TERMS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates Freight Terms should be overridden with a blank value Y/N Table Edit Default Value: N
43	FREIGHT_CALC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Freight Calculate Flag Y/N Table Edit Default Value: N
44	LEAD_DAYS	Number(4,0)	SMALLINT NOT NULL	Lead Days for Calendar
45	USE_LEAD_DAYS	Character(1)	VARCHAR2(1) NOT NULL	Use Lead Days 1=Use Fulfillment Lead Days 2=Override Fulfillment Lead Days 3=Ignore Lead Days Default Value: 1
46	SHORT_SHIP_OPT	Character(2)	VARCHAR2(2) NOT NULL	Short Shipment Option 01=Scrap the Undershipment 02=Return to Location Picked From Default Value: 02
47	SHIP_CNTR_ID	Character(20)	VARCHAR2(20) NOT NULL	Shipping Container ID
48	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 Prompt Table: BCT_CGRP_INV_VW
49	IN_DFR_DPL_OVRD	Character(1)	VARCHAR2(1) NOT NULL	used to override the defer depletions field on in_demand 1=Override to Yes 2=Override to No
50	IN_CREATE_DMD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Create Demand Y/N Table Edit
51	DELIVERY_ID	Character(10)	VARCHAR2(10) NOT NULL	Delivery ID
52	IN_FRT_P_BILFRT	Character(1)	VARCHAR2(1) NOT NULL	Commit Billable Freight Y/N Table Edit
53	IN_FRT_P_CMPFRT	Character(1)	VARCHAR2(1) NOT NULL	Freight Complete Y/N Table Edit
54	IN_FRT_P_MANFRT	Character(1)	VARCHAR2(1) NOT NULL	External Manifest Y/N Table Edit
55	IN_BEST_WAY_BTN	Character(2)	VARCHAR2(2) NOT NULL	Best Way Freight Option 10=Least Cost 20=By Commit Date
56	IN_FRT_OPTION	Character(2)	VARCHAR2(2) NOT NULL	Freight Options 10=Shop For Rates 20=Best Way 30=Use Specified Carrier 40=Carrier with Best Way
57	FRT_TYPE_CODE	Character(10)	VARCHAR2(10) NOT NULL	Freight Type Code Prompt Table: IN_FRT_DFLT
58	DEL_VALIDATE_OPT	Character(2)	VARCHAR2(2) NOT NULL	Delivery validation option 10=Validate Only 20=Validate/Assign to New 30=Validate/Auto Assign Open 40=Validate/Auto Assign All 50=Reassign/Consolidate 60=Do Not Validate
59	RESEND_FRT_RQST	Character(1)	VARCHAR2(1) NOT NULL	02/02/09 EGS: Created
60	RESEND_FRT_RECV	Character(1)	VARCHAR2(1) NOT NULL	02/02/09 EGS: Created
61	AMOUNT_ACTION	Character(1)	VARCHAR2(1) NOT NULL	10/29/08 EGS: Created 1=Override 2=Increment