CM_ACCT_TMP1(SQL Table) |
Index Back |
|---|---|
Inventory acctg temp1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
| 3 | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. | |
| 4 | Character(18) | VARCHAR2(18) NOT NULL | Item ID | |
| 5 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
| 6 | ITEM_RULE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Inventory item rules flag |
| 7 | GRP_RULE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Item group rules flag |
| 8 | BU_RULE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Inventory BU rules flag |
| 9 | ALL_COST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | All cost element flag |
| 10 | ALL_DISTRIB_FLAG | Character(1) | VARCHAR2(1) NOT NULL | All distribution types blank |