PROCESS_INSTANCEPrompt Table: CA_PREPAID_SRCH
BUSINESS_UNIT_PCPrompt Table: SP_BU_PC_NONVW
ACT=Accounting Date
TRN=Transaction Date
CA_PGP_CC_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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Contract Type |
| 4 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 5 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_PREPAID_SRCH |
| 6 | CA_PGP_SEQ | Number(3,0) | SMALLINT NOT NULL | Progress Payment Sequence |
| 7 | BUSINESS_UNIT_PC |
Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 8 | ASOF_DT | Date(10) | DATE | As of Date |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 10 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 11 | WHERE_CLAUSE_AE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause AE |
| 12 | FIELDNAME_CUREFFDT | Character(18) | VARCHAR2(18) NOT NULL | Currency Effective Date |
| 13 | CURR_TRANS_DATE | Character(3) | VARCHAR2(3) NOT NULL |
Date Type
ACT=Accounting Date TRN=Transaction Date |
| 14 | DUMMY_NUM | Number(6,0) | INTEGER NOT NULL | DUMMY NUM |
| 15 | INITIATED_FROM | Character(1) | VARCHAR2(1) NOT NULL | Initiated From |