CA_LMT_WRK_AET(SQL Table) |
Index Back |
|---|---|
State Record for CA_LMT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Contract Type |
| 4 | CA_RQST_SRC | Character(3) | VARCHAR2(3) NOT NULL |
Contract Classification
FED=Federal Reimbursable Agreement GEN=Generic Application GOV=Government INT=Internal OND=CRM Field Services On Demand STD=Standard |
| 5 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table: CUST_SLD_VW |
| 6 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CONTR_HDR |
| 7 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL |
Contract Line Num
Prompt Table: CA_DETAIL |
| 8 | CONTRACT_ADMIN | Character(40) | VARCHAR2(40) NOT NULL |
Contract Administrator defined on CABU.
Prompt Table: MEMBER_VW |
| 9 | CA_GVC_CNT | Number(9,0) | DECIMAL(9) NOT NULL | Count Government Contracting Rows |
| 10 | CA_COMM_CNT | Number(9,0) | DECIMAL(9) NOT NULL | Count Commercial Rows |
| 11 | CA_POP_CNT | Number(9,0) | DECIMAL(9) NOT NULL | Rows outside the POP |
| 12 | WHERE_CLAUSE_AE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause AE |
| 13 | WHERE_CLAUSE1 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 14 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 15 | AE_ALIAS_1 | Character(15) | VARCHAR2(15) NOT NULL | AE Alias 1 |
| 16 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 17 | CA_AUX1_WRK | Character(3) | VARCHAR2(3) NOT NULL | Auxiliar Field 1 |
| 18 | CA_AUX2_WRK | Character(1) | VARCHAR2(1) NOT NULL | Auxiliar Field 2 |
| 19 | CA_AUX3_WRK | Character(3) | VARCHAR2(3) NOT NULL | Auxiliar Field 3 |
| 20 | CA_AUX4_WRK | Character(20) | VARCHAR2(20) NOT NULL | To Set The Paid Status |
| 21 | 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 |
| 22 | CONTRACT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 23 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 24 | CA_CONTINUE | Character(1) | VARCHAR2(1) NOT NULL | Continue Control Field |
| 25 | CA_CONTINUE1 | Character(1) | VARCHAR2(1) NOT NULL | Continue Control Field |
| 26 | CONTRACT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 27 | RESOURCE_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Quantity |
| 28 | PC_TOTAL_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Total Quantity |
| 29 | RESOURCE_ID | Character(40) | VARCHAR2(40) NOT NULL | Transaction ID |
| 30 | LAST_RESOURCE_ID | Number(20,0) | DECIMAL(20) NOT NULL | Last Transaction ID |
| 31 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 32 | LIMIT_AMT_TXN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Limit Amount |
| 33 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 34 | CA_WRK1_CNT | Number(9,0) | DECIMAL(9) NOT NULL | Work Field for Counting 1 |
| 35 | CA_WRK2_CNT | Number(9,0) | DECIMAL(9) NOT NULL | Work Field for Counting 2 |
| 36 | RESOURCE_ID_FROM | Character(40) | VARCHAR2(40) NOT NULL | Original Transaction ID |
| 37 | RETAINAGE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Retainage Amount |
| 38 | DISCOUNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the discount amount deducted from the par price of a given deal transaction such as a bond. |
| 39 | RETAINAGE_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used by CA_LIMITS |
| 40 | DISCOUNT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used by CA_LIMITS |
| 41 | RETAINAGE_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Retainage Percentage |
| 42 | DISCOUNT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Discount Percentage |