CS_CNT_SN_AET(SQL Table) |
Index Back |
|---|---|
POD param select tableStaging table to hold the selected values for Purchase Order Dispatch |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | REQUEST_ID |
Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 7 | ALL_CNTRCT | Character(1) | VARCHAR2(1) NOT NULL |
All Contracts
N=Specific Contract Y=All Contracts Default Value: Y |
| 8 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 9 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table: CS_CNT_AVAIL_VW |
| 10 | ALL_VNDR | Character(1) | VARCHAR2(1) NOT NULL |
All Suppliers
N=Specific Supplier Y=All Suppliers |
| 11 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 12 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 13 | CS_MSG_CONTENT | Character(1) | VARCHAR2(1) NOT NULL |
Determines if contract should be published (or re-published) in it's entirety, or changes only. If contract has not been published the default is to 'publish all', if it has, then the default is 'changes only'.
A=Entire Contract C=Changes Only |
| 14 | CHUNK_SIZE | Number(3,0) | SMALLINT NOT NULL | Chunk Size |
| 15 | CS_PUBLISH_CHNGS | Character(1) | VARCHAR2(1) NOT NULL |
Re-publish syndicated contract. All contract information is published the first time it is syndicated. By default, once a contract has been syndicated, only the changes to the contract will be published. If the re-publish flag is selected ('Y'), all contracts meeting the search criteria will be fully published. On the remote system, the existing contract information will be replaced with the 're-published' contract. If the re-publish flag is not selected ('N'), then the default behavior will be used.
Y/N Table Edit |
| 16 | CS_PUBLISH_SINCE | Date(10) | DATE | Publish Since |
| 17 | SUBNODE | Character(30) | VARCHAR2(30) NOT NULL | Subscribing Node |