EOEC_CCI_INV_NUMEOEC_CCI_INV(SQL Table) |
Index Back |
|---|---|
CCI InvoiceCredit Card Interface Invoice |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEC_CCI_INV_NUM |
Character(20) | VARCHAR2(20) NOT NULL | Invoice Number |
| 2 | EOEC_DATE | Date(10) | DATE | Date |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | EOEC_CCI_DISC_AMT | Number(21,3) | DECIMAL(20,3) NOT NULL | Discount Amount |
| 5 | EOEC_CCI_SHIP_AMT | Number(21,3) | DECIMAL(20,3) NOT NULL | Shipping Amount |
| 6 | EOEC_CCI_DUTY_AMT | Number(21,3) | DECIMAL(20,3) NOT NULL | Duty Amount |
| 7 | EOEC_CCI_TAX_AMT | Number(21,3) | DECIMAL(20,3) NOT NULL | Tax Amount |
| 8 | EOEC_CCI_TAX_INCL | Character(1) | VARCHAR2(1) NOT NULL | National Tax Incl |
| 9 | EOEC_CCI_TOTAL_AMT | Number(21,3) | DECIMAL(20,3) NOT NULL | Total Amount |
| 10 | EOEC_CCI_COMMENT | Character(254) | VARCHAR2(254) NOT NULL | Comments |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |