CA_AE_BAM_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COMMAND | Character(10) | VARCHAR2(10) NOT NULL | |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
| 4 | ACCT_FROM_DT | Date(10) | DATE | Accounting Date From |
| 5 | ACCT_TO_DT | Date(10) | DATE | Acctg To Date |
| 6 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 7 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CNTR_SRCH_VW |
| 8 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Product Group
Prompt Table:
PRODGP_NGCA_VW
|
| 9 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
CA_PROD_ITEM_VW
|
| 10 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 11 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL |
Contract Type
Prompt Table:
CA_TYPE_TBL
|
| 12 | FROM_DATE | Date(10) | DATE | From Date |
| 13 | THRU_DATE | Date(10) | DATE | Through Date |
| 14 | CA_STATUS | Character(24) | VARCHAR2(24) NOT NULL |
Contract Status
Prompt Table: CA_STATUS_VW |
| 15 | CA_PROC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available.
A=Active C=Closed P=Pending |
| 16 | CA_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Obligation status
A=Active C=Cancelled P=Pending R=Renewed |
| 17 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 18 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 19 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 20 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 21 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 22 | BASE_LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |