SETIDVENDOR_IDINVOICE_IDINVOICE_DTBUSINESS_UNITPO_IDPO_LINE_NBRPV_SS_INVC_DTL(SQL Table) |
Index Back |
|---|---|
Invoice DetailInvoice Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | INVOICE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 4 | INVOICE_DT |
Date(10) | DATE NOT NULL | Invoice Date |
| 5 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 7 | PO_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Purchase Order Line Number |
| 8 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 9 | ITEM_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Item Description |
| 10 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 11 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
| 12 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 13 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 14 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
| 15 | VNDR_CATALOG_ID | Character(20) | VARCHAR2(20) NOT NULL | Vendor's Catalog Number |