TXN_GRP_IDLS_TXN_IDPrompt Table: %EDITTABLE
Prompt Table: RE_SHIPTO_VW
Prompt Table: RE_VNDR_LOC
Prompt Table: RE_CUST_ADDR_BI
RE_MFT_TXN(SQL Table) |
Index Back |
|---|---|
Manual Fee TransactionManual Fee Transaction record links manual fees with a real estate transaction |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TXN_GRP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Row Key for Transaction Group |
| 2 | LS_TXN_ID |
Number(25,0) | DECIMAL(25) NOT NULL | Lease Transaction ID |
| 3 | ALLOC_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Field to store signed percentages in 3.2 format |
| 4 | PRINCIPAL_ID | Character(15) | VARCHAR2(15) NOT NULL |
Landlord/Tenant
Prompt Table: %EDITTABLE |
| 5 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table: RE_SHIPTO_VW |
| 6 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: RE_VNDR_LOC |
| 7 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Address Sequence Number
Prompt Table: RE_CUST_ADDR_BI |