COUNT_SETUP_INV

(SQL Table)
Index Back

Physical/Cycle Count Setup

# 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