CHUNK_RULE_IDPrompt Table: IN_CHUNKPAR_VW
EFFDTDefault Value: %date
MSGNODENAMEPrompt Table: PSMSGNODEDEFN
BUSINESS_UNITPrompt Table: SP_BUIN_NONVW
LOCATIONPO_BU_PAR_EOV(SQL View) |
Index Back |
|---|---|
Par Location Chunking Table |
| SELECT CHUNK_RULE_ID , EFFDT , MSGNODENAME , BUSINESS_UNIT , %Substring(INV_CART_ID, 1, 10) FROM PS_IN_BU_PAR_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: IN_CHUNKPAR_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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
| 5 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL | Location Code |