| # |
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 |
COUNTING_EVENT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Counting Event ID
|
| 3 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
BU_ITM_INV_VW
|
| 4 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
STOR_AREA_VW2
|
| 5 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
STOR_LEV1_VW2
|
| 6 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
STOR_LEV2_VW2
|
| 7 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
STOR_LEV3_VW2
|
| 8 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
STOR_LEV4_VW2
|
| 9 |
CONTAINER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Container ID
Prompt Table:
CNTR_ID_INV
|
| 10 |
STAGED_DATE |
Date(10) |
DATE NOT NULL |
Staged Date
Prompt Table:
STAGED_DT2IN_VW
|
| 11 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 12 |
INV_LOT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Lot ID
Prompt Table:
%EDITTABLE
|
| 13 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
INV_STCK_UOM_VW
|
| 14 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 15 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
|
| 16 |
QTY_COUNT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Count Quantity
|
| 17 |
UNIT_MEASURE_COUNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit of Measure
Prompt Table:
INV_STCK_UOM_VW
|
| 18 |
COUNT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Count Item Status
1=New
2=Counting
3=Quantity Entered - Hold
4=Ready to Update Stock Quantity
5=Stock Quantity Updated
6=Canceled
Default Value: 4
|
| 19 |
POSTING_ERROR_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Posting Error Flag
1=No Average Cost
11=No Auto-Add of New Container
13=Standard Qty fail in a whole#
14=Whole # required for Count Qty
15=Storage Qty fail in a whole#
16=From/To UOM Rate must whole#
17=No Standard Cost
2=No Lot Control Record
3=Duplicate Serial Item found
4=Negative Quantity
5=Missing UOM Conversion Rate
6=Serial ID - multiple locations
7=Container - multiple locations
8=Wrong Item - Single Item Cntr
9=Incomplete Item Definition
D=Duplicate Fix Picking Location
E=Fix Picking Location UOM Error
X=In Process
|
| 20 |
COUNT_DTTM |
DateTime(26) |
TIMESTAMP |
Count Date/Time
|
| 21 |
QTY_PCT_ERROR |
Signed Number(12,4) |
DECIMAL(10,4) NOT NULL |
Quantity Percent Error
|
| 22 |
INV_COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Costing Method
1=Average Cost
4=Non Cost
5=Actual Cost
6=Standard Cost
|
| 23 |
NEED_TO_RECONCILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Needs Reconciliation
Y/N Table Edit
Default Value: Y
|
| 24 |
QTY_DELTA_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Delta Quantity
|
| 25 |
QTY_SYSTEM_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
System Quantity
|
| 26 |
INVENTORY_TAG_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Inventory Tag ID
|
| 27 |
QTY_RESERVED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Reserved
Default Value: 0
|