| # |
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 |
GEN_ACCTG_LINES |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Qty Transaction History
Y/N Table Edit
Default Value: Y
|
| 3 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table:
CM_DISTR_TYPE
|
| 4 |
PERCENT_TOLERANCE |
Signed Number(12,4) |
DECIMAL(10,4) NOT NULL |
Percent Tolerance
|
| 5 |
AND_OR |
Character(1) |
VARCHAR2(1) NOT NULL |
Reconciliation Reporting
1=AND
2=OR
Default Value: 1
|
| 6 |
DOLLAR_TOLERANCE |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Dollar Tolerance
|
| 7 |
BLIND_COUNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Blind Count
Y/N Table Edit
Default Value: Y
|
| 8 |
CANCEL_UNPROCESSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Unprocessed Items
Y/N Table Edit
Default Value: N
|
| 9 |
COUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Count Options
C=Cycle Count
M=Manual Count
P=Physical Inventory
Default Value: C
|
| 10 |
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
|
| 11 |
ZERO_QTY_CNT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Quantity Option
1=Include All
2=Exclude Zero Quantity
3=Include Zero Quantity
Default Value: 1
|
| 12 |
AS_OF_TRANS_DATE |
Date(10) |
DATE |
As of Transaction Date
|