EOEC_CCI_ITEM_NUMEOEC_CCI_ITEM(SQL Table) |
Index Back |
|---|---|
CCI ItemCredit Card Interface Item |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEC_CCI_ITEM_NUM |
Character(20) | VARCHAR2(20) NOT NULL | Item Number |
| 2 | EOEC_CCI_SKU | Character(18) | VARCHAR2(18) NOT NULL | SKU |
| 3 | EOEC_CCI_UPC | Character(18) | VARCHAR2(18) NOT NULL | Uniform Product Code ID |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | EOEC_CCI_QTY | Number(10,0) | DECIMAL(10) NOT NULL | Quantity |
| 6 | EOEC_CCI_UOM | Character(12) | VARCHAR2(12) NOT NULL | Unit of Measurement |
| 7 | EOEC_CCI_UNITPRICE | Number(21,3) | DECIMAL(20,3) NOT NULL | Unit Price |
| 8 | EOEC_CCI_EXTAMT | Number(21,3) | DECIMAL(20,3) NOT NULL | Extended Amount |
| 9 | EOEC_CCI_DISC_AMT | Number(21,3) | DECIMAL(20,3) NOT NULL | Discount Amount |
| 10 | EOEC_CCI_TAX_AMT | Number(21,3) | DECIMAL(20,3) NOT NULL | Tax Amount |
| 11 | EOEC_CCI_TOTAL_AMT | Number(21,3) | DECIMAL(20,3) NOT NULL | Total Amount |