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 |