LS_KEY1=Payables
2=Receivables
RE_TXN_HDR_VW(SQL View) |
Index Back |
|---|---|
Transaction Header ViewTransaction Header View |
| SELECT LS_KEY ,LS_NBR ,BUSINESS_UNIT ,LEASE_NAME ,LEASE_OBLG ,PRINCIPAL_ID ,REGION_CD ,CURRENCY_CD FROM PS_RE_LS |
| # | 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_NBR | Character(10) | VARCHAR2(10) NOT NULL | Lease Number, User Enterable or Generated Sequence Number |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | LEASE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Name |
| 5 | LEASE_OBLG | Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables |
| 6 | PRINCIPAL_ID | Character(15) | VARCHAR2(15) NOT NULL | Landlord/Tenant |
| 7 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL | Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |