LS_KEYLS_OPTION_SEQPARTY_TYPE_CDPrompt Table: RE_PTY_TYPE
OPT_RECIP_SEQY/N Table Edit
Default Value: N
Prompt Table: %EDITTABLE
RE_OPT_RECIP(SQL Table) |
Index Back |
|---|---|
Option RecipientRecipients that are to be notified for an Option |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 2 | LS_OPTION_SEQ |
Number(10,0) | DECIMAL(10) NOT NULL | Lease Option Sequence Key |
| 3 | PARTY_TYPE_CD |
Character(20) | VARCHAR2(20) NOT NULL |
Party type code (Internal or External)
Prompt Table: RE_PTY_TYPE |
| 4 | OPT_RECIP_SEQ |
Number(10,0) | DECIMAL(10) NOT NULL | Option Recipient Key |
| 5 | COMPLETED | Character(1) | VARCHAR2(1) NOT NULL |
Completed
Y/N Table Edit Default Value: N |
| 6 | DT_COMPLETED | Date(10) | DATE | Date Completed |
| 7 | PARTY_KEY | Number(10,0) | DECIMAL(10) NOT NULL |
Party Key
Prompt Table: %EDITTABLE |