FS_CCWIPE_AET(SQL Table) |
Index Back |
---|---|
CC Wipe AET |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
4 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
5 | FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL | Fieldname 2 |
6 | FIELDNAME3 | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
7 | CCWIPE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Wipe Status
C=Complete E=Error N=Available for Processing P=Processing S=All Records Wiped |
8 | CCWIPE_QTY | Number(3,0) | SMALLINT NOT NULL | Number of Overwrites |
9 | DUMMY_FIELD | Character(1) | VARCHAR2(1) NOT NULL | Dummy Field for Hiding Groups |
10 | WORK_CNT | Number(10,0) | DECIMAL(10) NOT NULL | Count of Anything |
11 | AE_INT_3 | Number(3,0) | SMALLINT NOT NULL | Number Work Field |
12 | AE_INT_4 | Number(4,0) | SMALLINT NOT NULL | Number Work Field |
13 | CCWIPE_INTERF | Character(1) | VARCHAR2(1) NOT NULL | Called from Interface |
14 | SQL_STMT_254 | Character(254) | VARCHAR2(254) NOT NULL | An internal work field that contains SQL text that is to be utilized in treasury application p |
15 | CCWIPE_ROWBYROW | Character(1) | VARCHAR2(1) NOT NULL | Process Record Row by Row |
16 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
17 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
18 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
19 | CUSTOMER_SETID | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
20 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
21 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
22 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
23 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
24 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |
25 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
26 | SEQ_NBR2 | Number(15,0) | DECIMAL(15) NOT NULL | Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV. |