PC_SUM_TPL_HDR(SQL Table) |
Index Back |
---|---|
Summarization Template HeaderSummarization template identifies the fields that will be used in the "group by" for summing project transactions. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PRODUCT_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Feeder integration product code
3RD=Third Party Loader APPO=Payables / Purchasing EX=Expenses GL=General Ledger GRFA=Grants Retroactive F&A PRC=Pricing Engine RPT1=Project Reporting Tables TL=Time and Labor USR1=User 1 USR2=User 2 USR3=User 3 USR4=User 4 USR5=User 5 VP=Variance Pricing |
2 | PROCESSING_SEQ | Number(5,0) | INTEGER NOT NULL | Processing Sequence |
3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
5 | DEFAULT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default Flag
Y/N Table Edit Default Value: N |
6 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
7 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
8 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
9 | FMS_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
10 | WHERE_CLAUSE_LONG | Long Character(4000) | CLOB | Where Clause |