EOEC_CCI_ORDR_NUMPrompt Table: EOEC_CCI_ITEMS
EOEC_CCI_ITEM_NBRPrompt Table: EOEC_CCI_ITEMS
Default Value: 0
EOEC_CCI_O_LINE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEC_CCI_ORDR_NUM |
Number(10,0) | DECIMAL(10) NOT NULL |
Order Number
Prompt Table: EOEC_CCI_ITEMS |
| 2 | EOEC_CCI_ITEM_NBR |
Character(10) | VARCHAR2(10) NOT NULL |
Item Number
Prompt Table: EOEC_CCI_ITEMS |
| 3 | EOEC_CCI_QUANTITY | Number(4,0) | SMALLINT NOT NULL |
Quantity
Default Value: 0 |
| 4 | EOEC_CCI_ITEM_COST | Number(8,2) | DECIMAL(7,2) NOT NULL | Item Cost |
| 5 | EOEC_CCI_ITEM_TOT | Number(8,2) | DECIMAL(7,2) NOT NULL | Item Total Cost |