BUSINESS_UNITEIP_CTL_ID0=No Synchronization Required
1=Synchronize a Business Unit
2=Synchronize an Item
3=Synchronize a Storage Location
4=Synchronize a Lot ID
5=Synchronize Item at a Stor Loc
BCT_PHY_TMP_INV(SQL Table) |
Index Back |
|---|---|
Physical Inventory Synch.This temporatory table is used when sychronization flag > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 3 | COUNTING_EVENT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Counting Event ID |
| 4 | SYNCH_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Synchronization Flag used to indicate the level of synchronization during a physical inventory snapshot.
0=No Synchronization Required 1=Synchronize a Business Unit 2=Synchronize an Item 3=Synchronize a Storage Location 4=Synchronize a Lot ID 5=Synchronize Item at a Stor Loc |