VED_DUP_INV_LOG(SQL Table) |
Index Back |
|---|---|
Vchr Edit Dupl Invoice Log |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 4 | DUPLICATE_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Duplicate Business Unit |
| 5 | DUPLICATE_VCHR_ID |
Character(8) | VARCHAR2(8) NOT NULL | Duplicate Voucher ID |
| 6 | DUP_INV_BUS_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit
N=No Y=Yes Y/N Table Edit Default Value: N |
| 7 | DUP_INV_VENDOR_NUM | Character(1) | VARCHAR2(1) NOT NULL |
Vendor ID
N=No Y=Yes Y/N Table Edit Default Value: N |
| 8 | DUP_INV_NUM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Number
N=No Y=Yes Y/N Table Edit Default Value: N |
| 9 | DUP_INV_DT | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Date
N=No Y=Yes Y/N Table Edit Default Value: N |
| 10 | DUP_INV_GROSS_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Gross Amount
N=No Y=Yes Y/N Table Edit Default Value: N |