PARTY_KEY1=Supplier
2=Customer
RE_LS_PRNC_PTY(SQL Table) |
Index Back |
|---|---|
Principal Parties on a LeasePrincipal Parties on a Lease |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PARTY_KEY |
Number(10,0) | DECIMAL(10) NOT NULL | Party Key |
| 2 | PRNCPL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Principal Type
1=Supplier 2=Customer |
| 3 | PRINCIPAL_ID | Character(15) | VARCHAR2(15) NOT NULL | Landlord/Tenant |
| 4 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 5 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
| 6 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
| 7 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 8 | FMS_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |