SETIDCNTRCT_IDSUBNODEPrompt Table: CS_NODES_VW
P=Parent
R=Remote
Default Value: R
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
CS_CNTRCT_HD_SN(SQL Table) |
Index Back |
|---|---|
Contract Syndication Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 3 | SUBNODE |
Character(30) | VARCHAR2(30) NOT NULL |
Subscribing Node
Prompt Table: CS_NODES_VW |
| 4 | CS_SN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Syndicate Type
P=Parent R=Remote Default Value: R |
| 5 | CS_PUBLISHED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Contract Published
Y/N Table Edit Default Value: N |
| 6 | PUBID | Signed Number(11,0) | DECIMAL(10) NOT NULL | Publication Identifier |
| 7 | CS_LOCAL_EMAIL | Character(70) | VARCHAR2(70) NOT NULL | Local Email Address |
| 8 | CS_CNTRCT_ID_SN | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 9 | CS_ORIG_SN_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 10 | CS_LAST_SN_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 11 | CS_SYNDICATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Contract Syndication
Y/N Table Edit Default Value: Y |
| 12 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | In process flag |
| 13 | CS_SNDCT_DEFAULTS | Character(1) | VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_DEFAULTS table will be syndicated.
Y/N Table Edit |
| 14 | CS_SNDCT_MISC_CHG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_HDR_MISC table will be syndicated.
Y/N Table Edit |
| 15 | CS_SNDCT_MILESTN | Character(1) | VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_MILESTN table will be syndicated.
Y/N Table Edit |
| 16 | CS_SNDCT_SHP_SCHED | Character(1) | VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_LN_SHIP table will be syndicated.
Y/N Table Edit |
| 17 | CS_SNDCT_DISTRIB | Character(1) | VARCHAR2(1) NOT NULL |
Flag to identifiy if the CNTRCT_BU_DSTRB and CNTRCT_DSTRB tables will be syndicated.
Y/N Table Edit |