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.