IN_TR_PHYS_AET

(SQL Table)
 Index Back

Transfers Phys Inv Temp table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Default Value: DEMAND_PICK_VW.INV_ITEM_ID

8 STAGED_DATE Date(10) DATE Staged Date
9 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
10 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
11 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
12 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
13 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
14 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
15 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
16 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
17 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
18 QTY_ALLOC_REMNG Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty to be Allocated
19 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
20 QTY_PRECISION Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal
W=Whole Nbr
21 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
22 QTY_PREC_STD Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number
23 XFER_SELECT Character(1) VARCHAR2(1) NOT NULL Transfer Select
24 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
25 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
26 TRANSFER_ALLOC_QTY Character(1) VARCHAR2(1) NOT NULL Transfer Allocated Quantity
27 TRANSFERSTATUS Character(1) VARCHAR2(1) NOT NULL Distribution Transfer Status