IN_FL_PFB_AET(SQL Table) |
Index Back |
---|---|
Picking Feedback State RecordUsed 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 |