IN_FL_PFB_AET

(SQL Table)
Index Back

Picking Feedback State Record

Used in the fulfillment Picking Feedback AE as the default state record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SHIP_LINE_CNT_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Line Count Error Flag
3 ADDRESS_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Used to denote that the address override is not valid.
4 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
5 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
6 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
7 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 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
10 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
11 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
12 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
13 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
15 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
16 DEMAND_LINE_NEW Number(4,0) SMALLINT NOT NULL Demand Line No
17 ADHOC_REQ_FLG Character(1) VARCHAR2(1) NOT NULL Create Adhoc Requisitions
18 REPLENISH_ID Number(10,0) DECIMAL(10) NOT NULL Replenish ID
19 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
20 REPLENISH_LEAD Signed Number(16,2) DECIMAL(14,2) NOT NULL Replenish Lead (Days)
21 EXPECTED_DATE Date(10) DATE Expected By
22 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
23 PARTIAL_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Orders Can Ship
N=No
Y=Yes
24 DPI_ROW_COUNT Number(15,0) DECIMAL(15) NOT NULL Demand Phys Row Count
25 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
26 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
27 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
28 QTY_PICKED_ORIG Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
29 QTY_PICK_ACTUAL Signed Number(17,4) DECIMAL(15,4) NOT NULL Actual Qty Picked
30 QTY_ORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/21/04 EGS: Created
31 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
32 QTY_PICK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Pick Base
33 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y
34 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y
35 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control
36 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
37 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
38 QTY_PROMISED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Promised Base
39 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
40 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
41 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
42 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
43 QTY_PICK_OVRIDE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity when printing the pick play for non-soft reservation items.
44 QTY_PICK_OVR_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items.
45 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
46 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
47 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
48 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
49 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
50 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
51 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
52 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
53 STAGED_DATE Date(10) DATE Staged Date
54 UNIT_MEASURE_PICK Character(3) VARCHAR2(3) NOT NULL Phys Location Unit of Measure
55 CFG_COST_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Costing
56 CM_METHOD Character(2) VARCHAR2(2) NOT NULL 8/20/02 lee: added xlate 9 for retroactive perp average 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost
1=Actual Cost
6=Perpetual Weighted Average
7=Periodic Weighted Average
8=Value at Current Standard
9=Retroactive Perpetual Average
57 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
58 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
59 TRANSFER_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions
1=Transfer at Zero Cost
60 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
61 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %
62 DFLT_ACTUAL_COST Number(15,4) DECIMAL(14,4) NOT NULL Default Actual Cost
63 AVERAGE_COST Number(15,4) DECIMAL(14,4) NOT NULL Average Purchase Price
64 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
65 CURRENCY_CD_DEST Character(3) VARCHAR2(3) NOT NULL Currency Code Dest
66 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes
67 DFLT_IUNIT_PREFIX Character(1) VARCHAR2(1) NOT NULL Default InterUnit ID Prefix
68 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
69 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
70 IUNIT_ID_COUNTER Number(9,0) DECIMAL(9) NOT NULL InterUnit ID Counter
71 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
72 PROD_COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL Product Component ID
73 KIT_QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Kit Quantity Shipped
74 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold
75 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship
76 SHIP_DTTM DateTime(26) TIMESTAMP Ship Date/Time
77 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
78 SHIP_SERIAL_ERROR Character(1) VARCHAR2(1) NOT NULL Ship Serial Error Flag
79 COUNTER1 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
80 SHIPPING_ID Number(10,0) DECIMAL(10) NOT NULL Shipping ID
81 COUNTER9 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
82 SETID Character(5) VARCHAR2(5) NOT NULL SetID
83 DESTIN_GL_BU Character(5) VARCHAR2(5) NOT NULL Destination GL Business Unit
84 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
85 GRP_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Group stage table.
86 DTL_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Details stage table.
87 LLS_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Location / :pt / Serial stage table.
88 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
89 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
90 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
91 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
92 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
93 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
94 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
95 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
96 PICK_BATCH_FROM Number(10,0) DECIMAL(10) NOT NULL From Pick Batch ID
97 PICK_BATCH_TO Number(10,0) DECIMAL(10) NOT NULL To Pick Batch ID
98 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
99 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
100 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
101 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
102 PROCESS_INST_STG Number(10,0) DECIMAL(10) NOT NULL Stage Record Process Instance
103 AE_LONG_CHUNK1 Character(254) VARCHAR2(254) NOT NULL An internal work field required in order to process character string data within the Cash Position Wor
104 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
105 CANCEL_INDICATOR Number(1,0) SMALLINT NOT NULL Cancel Indicator for PO Lookup
106 TEMPORARY_FLG Character(1) VARCHAR2(1) NOT NULL Temporary
107 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge
108 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
109 TRANS_DTL_ERR_FLAG Character(1) VARCHAR2(1) NOT NULL Transaction Dtl Errors
110 CTNR_AE_COUNTER Number(10,0) DECIMAL(10) NOT NULL Auto Container AE Counter
111 PROCESS_MODE Character(2) VARCHAR2(2) NOT NULL Run Mode
JB=Job Mode
ON=Online Mode
PR=Process Mode
TR=Transaction Mode
112 WAVE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier used to group together one or more delivery route codes.
113 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
114 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
115 PACK_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Pack Qty Error Flag

Y/N Table Edit

Default Value: N

116 CONVERT_UOM_FLG Character(1) VARCHAR2(1) NOT NULL Convert Unit of Measure
117 KIT_PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Kit Processing Enables
118 KIT_CMPS_SPLIT_FLG Character(1) VARCHAR2(1) NOT NULL Kit Comps Split across Demand
119 KIT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Kit Processing Error Flag
120 ADHOC_PRESENT_FLAG Character(1) VARCHAR2(1) NOT NULL Adhocs Present
121 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
122 MULT_CLAUSES_FLAG Character(1) VARCHAR2(1) NOT NULL Multiple Select Clauses Flag

Default Value: N

123 GROUP_SCNT_FLAG Character(1) VARCHAR2(1) NOT NULL Group Ship Cntr Flag
124 DFLT_INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Default Lot ID
125 DFLT_SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Default Serial ID
126 DFLT_STAGED_DATE Date(10) DATE Default Staged Date
127 ADD_DTL_TRANS_FLAG Character(1) VARCHAR2(1) NOT NULL Add Detail Transaction Flag
128 GROUP_PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Group Processing Flag
129 ADDRESS_USE Character(1) VARCHAR2(1) NOT NULL Address Usage
B=Bill To
S=Ship To
130 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

131 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
132 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
133 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
134 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
135 CITY Character(30) VARCHAR2(30) NOT NULL City
136 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
137 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
138 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
139 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
140 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
141 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
142 COUNTY Character(30) VARCHAR2(30) NOT NULL County
143 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

144 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
145 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
146 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

147 SHIP_ID_EXIST_FLAG Character(1) VARCHAR2(1) NOT NULL Ship ID Exists
148 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
149 BUSINESS_UNIT_FROM Character(5) VARCHAR2(5) NOT NULL Business Unit From
150 TSE_JOBID Character(10) VARCHAR2(10) NOT NULL TSE Job Identifier
151 DTL_BUTTON Character(1) VARCHAR2(1) NOT NULL Detail Button
152 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
153 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
154 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID
155 TMS_EXT_REF_LN_NBR Number(7,0) INTEGER NOT NULL TMS Line Number
156 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
157 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
158 GROUP_COUNT Number(10,0) DECIMAL(10) NOT NULL Selected Count
159 RUNDATE Date(10) DATE Process Scheduler Run Date
160 WORK_CNT1 Number(10,0) DECIMAL(10) NOT NULL Work Count 1
161 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least
162 AVAIL_STATUS Character(1) VARCHAR2(1) NOT NULL Availability Status
1=Open
2=Restricted
3=Hold
4=Rejected
163 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes
164 IN_FL_TEMP_TBL_IND Character(1) VARCHAR2(1) NOT NULL Temp Table Indicator
165 TRANS_PROGRAM Character(3) VARCHAR2(3) NOT NULL Transaction Program
166 SOFT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Soft Reserve
167 IN_ZERO_PICKED_FLG Character(1) VARCHAR2(1) NOT NULL Zero Picked
168 UPDATE_DPI_FLAG Character(1) VARCHAR2(1) NOT NULL Update Demand Phys Inv
169 SUB_ITM_ID Character(18) VARCHAR2(18) NOT NULL 11/30/99 RML Added label "Substitute"
170 SUBSTITUTE_FLG Character(1) VARCHAR2(1) NOT NULL Substitute Flag
171 QTY_AVAILABLE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity Available
172 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate
173 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
174 SEQ_NBR2 Number(15,0) DECIMAL(15) NOT NULL Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV.
175 UOM_CONV_FLAG Character(1) VARCHAR2(1) NOT NULL UOM Conversion Flag
0=Use Entered UOM
1=Convert to Standard UOM
2=Convert to Default Stock UOM
176 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
177 UNIT_MEASURE_TXN Character(3) VARCHAR2(3) NOT NULL Transaction Unit of Measure
178 PHYS_INV_ERR_FLAG Character(1) VARCHAR2(1) NOT NULL Physical Inv Error Flag
179 UNIT_MEASURE_TEMP Character(3) VARCHAR2(3) NOT NULL Temperature UOM
180 ALLOCATE_SOURCE Character(2) VARCHAR2(2) NOT NULL Allocation Source - Why was the allocation created
LT=Lot Allocation
PR=Pre-allocation
SA=Standard Allocation
181 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups
182 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE