VRBT_EVT_PO(SQL Table) |
Index Back |
|---|---|
Supplier Rebate PO Events (XReSupplier Rebate PO Event Cross-Ref table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
| 2 | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order | |
| 3 | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] | |
| 4 | Character(5) | VARCHAR2(5) NOT NULL | SetID | |
| 5 | Character(25) | VARCHAR2(25) NOT NULL | Vendor Rebate ID | |
| 6 | EVENT_STATUS_VRBT | Character(1) | VARCHAR2(1) NOT NULL |
Rebate Event Status
A=Active D=Disassociated P=Pending Dissociation |
| 7 | EVENT_DT | Date(10) | DATE | The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting |