CA_BU_XS_DEF(SQL Table) |
Index Back |
|---|---|
CA BU Lvl Excess/Reclm defsContracts Business Unit level Excess / Reclaim definitions for Government Contracts. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_CA_NONVW |
| 2 | EXCESS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Type of excess to specify stamping of Res. Type / Res. Cat / Res Sub Cat values on the new rows created by Summary Limits Process.
BLR=Bil Line Level Reclaimed BLX=Bil Line Level Excess BTR=Bil Txn Level Reclaimed BTX=Bil Txn Level Excess RLR=Rev Line Level Reclaimed RLX=Rev Line Level Excess RTR=Rev Txn Level Reclaimed RTX=Rev Txn Level Excess |
| 3 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table: PROJ_RES_TYPE |
| 4 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table: PROJ_CATG_TBL |
| 5 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table: PROJ_SUBCAT_TBL |