| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 2 |
COUNTING_EVENT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Counting Event ID
|
| 3 |
COUNT_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Count Header Status
1=Open
2=Finished
3=Canceled
Default Value: 1
|
| 4 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
|
| 5 |
UTILIZ_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Group
CYCL=Cycle Count
|
| 6 |
UTILIZ_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Type
|
| 7 |
MAX_ITEMS |
Number(6,0) |
INTEGER NOT NULL |
Maximum Items to Select
|
| 8 |
GEN_ACCTG_LINES |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Qty Transaction History
Y/N Table Edit
|
| 9 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
|
| 10 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 11 |
PERCENT_TOLERANCE |
Signed Number(12,4) |
DECIMAL(10,4) NOT NULL |
Percent Tolerance
|
| 12 |
AND_OR |
Character(1) |
VARCHAR2(1) NOT NULL |
Reconciliation Reporting
1=AND
2=OR
|
| 13 |
DOLLAR_TOLERANCE |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Dollar Tolerance
|
| 14 |
COUNT_GRADE |
Character(20) |
VARCHAR2(20) NOT NULL |
Count Grade
|
| 15 |
COUNT_START_DT |
Date(10) |
DATE |
Count Start Date
|
| 16 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 17 |
COUNT_POST_DT |
Date(10) |
DATE |
Last Stock Qty Update
|
| 18 |
NO_RECORDS |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Number of Records
|
| 19 |
NO_RECS_POSTED |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Number Updated Stock Qty
|
| 20 |
QTY_TOTAL |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Quantity Total
|
| 21 |
QTY_ERROR |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Error
|
| 22 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 23 |
PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All
S=Only purge items with at least
Y/N Table Edit
Default Value: N
|
| 24 |
BLIND_COUNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Blind Count
Y/N Table Edit
Default Value: Y
|
| 25 |
CANCEL_UNPROCESSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Unprocessed Items
Y/N Table Edit
|
| 26 |
COUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Count Options
C=Cycle Count
M=Manual Count
P=Physical Inventory
|
| 27 |
DUE_TO_COUNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Due to Count
Y/N Table Edit
|
| 28 |
CYCLE_COUNT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cycle Count Option
1=Manual Count
2=Due To Count
3=Item ID
4=Family
5=Storage Location
6=Negative Balance
7=Due To Count by Storage Loc
|
| 29 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
|
| 30 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
|
| 31 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
|
| 32 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
|
| 33 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
|
| 34 |
STOR_LOC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Storage Location Options
1=Single Storage Location
2=Range of Locations
|
| 35 |
FROM_STOR_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
From storage area
|
| 36 |
FROM_STOR_LEV1 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 1
|
| 37 |
FROM_STOR_LEV2 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 2
|
| 38 |
FROM_STOR_LEV3 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 3
|
| 39 |
FROM_STOR_LEV4 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 4
|
| 40 |
TO_STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
|
| 41 |
TO_STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
|
| 42 |
TO_STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
|
| 43 |
TO_STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
|
| 44 |
TO_STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
|
| 45 |
ZERO_QTY_CNT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Quantity Option
1=Include All
2=Exclude Zero Quantity
3=Include Zero Quantity
|
| 46 |
AS_OF_TRANS_DATE |
Date(10) |
DATE |
As of Transaction Date
|
| 47 |
COUNT_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort By
I=Item ID
L=Location
T=Tag ID
|
| 48 |
MIN_GROUP_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Grouping Options
G=Number of groups
R=Max rows per group
|
| 49 |
MIN_GROUP_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Group Count
|
| 50 |
MIN_GROUP_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep sort values together
|
| 51 |
INV_ITEM_ACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Item status
0=Dummy value
1=Active
Default Value: 0
|
| 52 |
INV_ITEM_INACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
item status
0=Dummy value
4=Inactive
Default Value: 0
|
| 53 |
INV_ITEM_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
item status
0=Dummy value
2=Hold
Default Value: 0
|
| 54 |
INV_ITEM_DISCONTIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Item status
0=Dummy value
3=Discontinue
Default Value: 0
|
| 55 |
INV_ITEM_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Item staus
0=Dummy value
A=All
Default Value: 0
|