BUYER_IDREPORT_ENTITYPrompt Table: PO_SPEND_EN_SCH
PO_SPEND_BUYER(SQL Table) |
Index Back |
|---|---|
Buyer's Spend analysis setting |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUYER_ID |
Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 2 | REPORT_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL |
Reporting Entity ID
Prompt Table: PO_SPEND_EN_SCH |
| 3 | REL_START_PER | Signed Number(4,0) | DECIMAL(3) NOT NULL | Start - Cur Period Minus |
| 4 | REL_END_PER | Signed Number(4,0) | DECIMAL(3) NOT NULL | End - Cur Period Minus |