CHUNK_RULE_IDPrompt Table: EO_CHUNKBU_VW
EFFDTDefault Value: %date
MSGNODENAMEPrompt Table: PSMSGNODEDEFN
IN_VENDORID_EOV(SQL View) |
Index Back |
|---|---|
Business Unit Chunking TableGeneric Business Unit / Message Node relation |
| SELECT CHUNK_RULE_ID , EFFDT , MSGNODENAME , VENDOR_SETID , VENDOR_ID , VNDR_LOC FROM PS_PO_VENDORID_EOC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHUNK_RULE_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Chunking Rule ID
Prompt Table: EO_CHUNKBU_VW |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | MSGNODENAME |
Character(30) | VARCHAR2(30) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
Prompt Table: PSMSGNODEDEFN |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |