PROCESS_INSTANCE1=Category Based
2=Weekly Sales
3=Each Period
4=Cumulative
5=Cumulative Pro Rata
6=Modified Cumulative
7=Lease Pro Rata
8=Cumulative BreakPoint Prorata
1=Payables
2=Receivables
N=Disabled
Y=Enabled
RE_PCT_TXNS_AET(SQL Table) |
Index Back |
|---|---|
Process Sales Reports AE TableApplication Engine Table used for Process Sales Reports Process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BI_SCHED_ID | Number(30,0) | DECIMAL(30) NOT NULL | Bill Schedule ID |
| 3 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 4 | SCHED_NUM | Number(5,0) | INTEGER NOT NULL | Team sequence number |
| 5 | REVISION_NBR | Number(3,0) | SMALLINT NOT NULL | Sales Report Revision Number - Number (3) |
| 6 | LS_KEY | Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 7 | PRINCIPAL_ID | Character(15) | VARCHAR2(15) NOT NULL | Landlord/Tenant |
| 8 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 11 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 12 | BI_CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Billing Calendar ID |
| 13 | SLS_CALC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Sales Compuation Methods for computing percent rent
1=Category Based 2=Weekly Sales 3=Each Period 4=Cumulative 5=Cumulative Pro Rata 6=Modified Cumulative 7=Lease Pro Rata 8=Cumulative BreakPoint Prorata |
| 14 | SLSRPT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Sales Report ID - Number (15) |
| 15 | LEASE_OBLG | Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables |
| 16 | START_DT | Date(10) | DATE | Start Date |
| 17 | END_DT | Date(10) | DATE | End Date |
| 18 | FS_CHK_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Check box for Enable/Disable
N=Disabled Y=Enabled |