GC_LIMITS_AET(SQL Table) |
Index Back |
|---|---|
State Record for GC_LIMITSUsed for Government contracts |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 3 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 4 | BUS_UNIT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Business Unit Name |
| 5 | SOURCE_TABLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Source Table Name |
| 6 | CA_PRC_BILLING | Character(1) | VARCHAR2(1) NOT NULL | Process Billing - Checkbox Used in Contracts Limits Run Control page. |
| 7 | CA_PRC_REVENUE | Character(1) | VARCHAR2(1) NOT NULL | Process Revenue - Checkbox Used in Contracts Limits Run Control page. |
| 8 | CA_RECALC_TOT | Character(1) | VARCHAR2(1) NOT NULL | Recalculate Totals Only - Checkbox Used in Contracts Limits Run Control page. |
| 9 | CA_LMT_CALL | Character(1) | VARCHAR2(1) NOT NULL |
Limits Process Calling Program
O=Online P=PC Pricing R=Billing Interface - Retainage S=Standalone |
| 10 | CURR_TRANS_DATE | Character(3) | VARCHAR2(3) NOT NULL |
Date Type
ACT=Accounting Date TRN=Transaction Date |
| 11 | CA_TMP_TBL | Character(1) | VARCHAR2(1) NOT NULL |
Temporary Tables ?
Y/N Table Edit |
| 12 | GVC | Character(1) | VARCHAR2(1) NOT NULL | Government Contracts |
| 13 | SPLIT_LINE | Character(1) | VARCHAR2(1) NOT NULL | Split Line |
| 14 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 15 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 16 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 17 | RESOURCE_ID | Character(40) | VARCHAR2(40) NOT NULL | Transaction ID |
| 18 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 19 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 20 | TXN_LMT_TRANS_ID | Character(10) | VARCHAR2(10) NOT NULL | Transaction Limit Identifer |
| 21 | CONTRACT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 22 | LMT_PRCS1_WRK | Character(1) | VARCHAR2(1) NOT NULL |
Limit Process Work Field
It shows the status of a transaction inserted into an output table.
C=Changed N=New S=Same |
| 23 | RESOURCE_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Quantity |
| 24 | CA_USE_RUNCNTRL | Character(1) | VARCHAR2(1) NOT NULL | Used by the Limits Process To use Run Control or run process based on the State Table fields ? |
| 25 | PC_SWITCH_1 | Character(1) | VARCHAR2(1) NOT NULL | Reprice Rows? |
| 26 | CONTRACT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 27 | WHERE_CLAUSE_PC1 | Long Character(4000) | CLOB | Field to save a dynamic WHERE CLAUSE used in Projects batch processes. |
| 28 | LIMIT_SEQ_TXN | Number(3,0) | SMALLINT NOT NULL | Transaction Limit Sequence |
| 29 | ENABLE_SUMM_LIMITS | Character(1) | VARCHAR2(1) NOT NULL |
Field to Specify to enable Summary Limits for Government Contracts.
N=No Y=Yes |
| 30 | SEPARATE_BIL_REV | Character(1) | VARCHAR2(1) NOT NULL | Flag used by Governement Contracts to separate Billing and Revenue transactions |
| 31 | LIMIT_AMT_BIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Funded/Billing Limit Amount |
| 32 | LIMIT_AMT_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Revenue Limit Amount |
| 33 | ITD_EXCESS_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | ITD Excess Amount |
| 34 | LIMIT_AMT_TXN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Limit Amount |
| 35 | ITD_PRCSD_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | ITD Processed Amount |
| 36 | CURR_EXCESS_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Current Excess Amount |
| 37 | EXCESS_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excess Amount |
| 38 | AMOUNT_IN_EXCESS | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether the amount is in excess. |
| 39 | RECLAIMED_FROM_OL | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether the amount was reclaimed from over the limit. |
| 40 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 41 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 42 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 43 | LAST_RESOURCE_ID | Number(20,0) | DECIMAL(20) NOT NULL | Last Transaction ID |
| 44 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 45 | BI_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Billing Distribution Status
D=Distributed I=Ignore N=Not Distributed P=Priced U=Unbillable/Non-billable W=Billing Worksheet |
| 46 | GL_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal |
| 47 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 48 | REV_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Revenue Distribution Status
C=Created D=Distributed G=Generated I=Ignore N=Not Distributed |