IN_FW_BCT_1_VW

(SQL View)
 Index Back

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_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 , FREIGHT_AMT , FREIGHT_AMT_FLG , FREIGHT_CALC_FLAG , FREIGHT_TERMS , FREIGHT_TERMS_FLG , TRACKING_NBR , TRACKING_NBR_FLG , LEAD_DAYS , USE_LEAD_DAYS , 'N' , 0 , '10' , COMPLETE_FLG , SHORT_SHIP_OPT , SHIP_CNTR_ID , IN_DFR_DPL_OVRD , AUTO_RELEASE_OPT , RLS_RUN_CNTL_ID , ' ' , MG_UNPLAN_OUTPUT , ' ' , ' ' , ' ' , ' ' , 'N' , ' ' , DELIVERY_ID , IN_FRT_OPTION , IN_BEST_WAY_BTN , IN_FRT_P_CMPFRT , IN_FRT_P_BILFRT , FRT_TYPE_CODE , DEL_VALIDATE_OPT , AMOUNT_ACTION 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

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.

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
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"
16 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"
17 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID

Prompt Table: SHIP_HDR_INV_VW

18 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

19 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: SHIP_PRMPT9_VW

20 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

21 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
22 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

23 SHIP_DATE Date(10) DATE Item Shipping Date
24 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

25 SHIP_TIME Time(15) TIMESTAMP Ship Time
26 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

27 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
28 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
29 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
30 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
31 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
32 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.

Prompt Table: SHIP_PRMPT11_VW

33 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

34 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
35 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

36 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
37 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

38 FREIGHT_CALC_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Calculate Flag
39 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
40 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

41 TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Tracking Number
42 TRACKING_NBR_FLG Character(1) VARCHAR2(1) NOT NULL Clear Tracking Number
43 LEAD_DAYS Number(4,0) SMALLINT NOT NULL Lead Days for Calendar
44 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

45 AUTO_SCHEDULE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates to automatically create a run control and schedule processing.
46 COMMIT_COUNT Number(10,0) DECIMAL(10) NOT NULL Count based on Commit Level used to determine the size of a unit of work to commit to the database. A value of zero indicates include all updates in the same unit of work and do one commit at the end of each Processing Group. This count can be used to help tune at a site that is running into issues with large runs causing blocking and deadlocks on the base tables updated by the process.
47 COMMIT_LEVEL Character(2) VARCHAR2(2) NOT NULL Identifies the level for the Commit Count. When Commit Count is not zero, Commit Level must be less than or equal to Processing Level.
10=Request
20=Order
30=Line
40=Item
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
49 SHORT_SHIP_OPT Character(2) VARCHAR2(2) NOT NULL Short Shipment Option
01=Scrap the Undershipment
02=Return to Location Picked From
50 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
51 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
52 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
53 RLS_RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
54 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
55 MG_UNPLAN_OUTPUT Character(1) VARCHAR2(1) NOT NULL 01/19/99 nas (CN#800-6.0) Created new field.
56 IN_KIT_REEXPLODE Character(1) VARCHAR2(1) NOT NULL Flag indicating whether the Kit Re-Explode program should be initiated

Y/N Table Edit

Default Value: N

57 IN_KIT_EXPL_DATE Character(1) VARCHAR2(1) NOT NULL Kit Effective Date to be used by the Kit Re-Explode program
1=Schedule Date
2=Order Date
3=Ship Early Date
4=Today's Date
58 IN_KIT_EXEC_MODE Character(1) VARCHAR2(1) NOT NULL Execution Mode for the Kit Re-Explode program
1=Report and Re-Explode
2=Report Only
59 IN_BOL_OPTION Character(1) VARCHAR2(1) NOT NULL Bill Of Lading Option
0=Do nothing
1=Create BOL
2=Both
60 IN_PACK_LIST_PRINT Character(1) VARCHAR2(1) NOT NULL Print Packing List
61 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
62 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
63 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
64 IN_BEST_WAY_BTN Character(2) VARCHAR2(2) NOT NULL Best Way Freight Option
10=Least Cost
20=By Commit Date
65 IN_FRT_P_CMPFRT Character(1) VARCHAR2(1) NOT NULL Freight Complete
66 IN_FRT_P_BILFRT Character(1) VARCHAR2(1) NOT NULL Commit Billable Freight
67 FRT_TYPE_CODE Character(10) VARCHAR2(10) NOT NULL Freight Type Code
68 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
69 AMOUNT_ACTION Character(1) VARCHAR2(1) NOT NULL 10/29/08 EGS: Created
1=Override
2=Increment