IN_RLS_DPI_TAO

(SQL Table)
Index Back

Demand Picking Locations

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PROCESSING_GROUP Number(10,0) DECIMAL(10) NOT NULL A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level.
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 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
5 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
6 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
7 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
8 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
10 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
11 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

Default Value: 0

12 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
13 RELEASE_INSTANCE Number(10,0) DECIMAL(10) NOT NULL 08/2004 rcw: Order Release Instance
14 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Prompt Table: %EDITTABLE

15 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Prompt Table: %EDITTABLE7

16 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: %EDITTABLE2

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

Prompt Table: %EDITTABLE3

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

Prompt Table: %EDITTABLE4

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

Prompt Table: %EDITTABLE5

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

Prompt Table: %EDITTABLE6

21 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

Prompt Table: %EDITTABLE8

22 STAGED_DATE Date(10) DATE Staged Date

Prompt Table: %EDITTABLE9

23 EXPIRATION_DATE Date(10) DATE Expiration Date
24 AVAIL_DATE Date(10) DATE Availability Date
25 RETEST_DATE Date(10) DATE Retest Date
26 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
27 QTY_PICKED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked in Phys Loc UOM
28 UNIT_MEASURE_PICK Character(3) VARCHAR2(3) NOT NULL Phys Location Unit of Measure

Prompt Table: %EDITTABLE10

29 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
30 QTY_DPI_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to determine how much Qty needs to be Allocated at the Physical Inventory level - Base
31 REPRINT_SORTER Number(10,0) DECIMAL(10) NOT NULL Reprint Sort Order
32 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
33 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

34 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

Y/N Table Edit

Default Value: N

35 AVAIL_STATUS Character(1) VARCHAR2(1) NOT NULL Availability Status
1=Open
2=Restricted
3=Hold
4=Rejected

Default Value: 1

36 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield
37 PICK_DATE Date(10) DATE Picked Date

Default Value: %date

38 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
39 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
40 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
41 LAST_QTY_SHIP Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Last Shipped
42 LAST_QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Used to save the last value of quantity shipped from the Shipping Issues Panel in Standard UOM at the DEMAND_PHYS_INV and SHIP_INF_INV level. Default to the quantity picked from the Express Issues Panel or for cases where auto ship equals 'Y'.
43 ZERO_SHIPPED_FLAG Character(1) VARCHAR2(1) NOT NULL Zero Shipped

Y/N Table Edit

Default Value: N

44 ASRS_ID Number(15,0) DECIMAL(15) NOT NULL ASRS Identifier
45 ZONE_CD Character(6) VARCHAR2(6) NOT NULL Zone code
46 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

Default Value: %datetime

47 MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
48 MSGNUM Number(5,0) INTEGER NOT NULL Message Number
49 IN_ALLOC_ERROR Character(3) VARCHAR2(3) NOT NULL Allocation Error Message
000=No Errors Found
001=Quantity Shortage - BU Level
002=Quantity Shortage - Loc Level
010=No Fixed Picking Bin
011=Fixed Picking - Not enough
012=Fixed Picking - none available
100=UOM Error encountered
101=UOM Error - Reservations
105=Pick Location UOM Error
106=Substitute UOM Error
999=Skip Row

Default Value: 000

50 IN_UOM_ERROR Character(1) VARCHAR2(1) NOT NULL UOM Error
1=OrdQty: Round Down to 0
2=OrdQty: Input Mod-Auto<>1
3=OrdQty:Truncate to 0
4=OrdQty: Input Modified - Error
5=Pick Location UOM Error
6=Substitute UOM Error
N=No UOM Errors

Default Value: N

51 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
52 CONVERSION_RATE1 Signed Number(17,8) DECIMAL(15,8) NOT NULL Req UOM conversion rate
53 CONVERSION_RATE2 Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
54 QTY_PREC_ORDR Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number
55 QTY_PREC_STCK Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number
56 QTY_PREC_STD Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number
57 ROUND_RULE_ORDR Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up
58 ROUND_RULE_STCK Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up
59 ROUND_RULE_STD Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up
60 SUB_ITM_ID Character(18) VARCHAR2(18) NOT NULL 11/30/99 RML Added label "Substitute"
61 IN_PICK_RULE Character(3) VARCHAR2(3) NOT NULL Picking Rule Used

Default Value: 00

62 IN_PICK_RULE_DTL Character(2) VARCHAR2(2) NOT NULL Pick Rule Detail
00=Not Applicable
01=By UOM, In Location
02=By UOM, In Zone, out of Loc
03=By UOM, Remaining Locations
04=Diff UOM, In Location
05=Diff UOM, In Zone
06=Diff UOM, Remaining Locations
07=Any UOM, In Location
08=Any UOM, In Zone
09=Any UOM, Remaining Locations
10=In Zone
11=Out of Zone

Default Value: 00

63 ALLOCATE_SOURCE Character(2) VARCHAR2(2) NOT NULL Allocation Source - Why was the allocation created
LT=Lot Allocation
PR=Pre-allocation
SA=Standard Allocation

Default Value: SA

64 NETTABLE_FLG Character(1) VARCHAR2(1) NOT NULL Nettable