FS_CCHOST_AET

(SQL Table)
 Index Back

Cache for OM intfc_crcard load

Cache record for the Om Credit Card interface load process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
5 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
6 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
    • 7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    8 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    9 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    10 CC_PROF_OPT Character(1) VARCHAR2(1) NOT NULL Credit Card Profile Option
    0=No Tokenization
    1=Create Profiles Before
    2=Create Profiles After
    11 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    12 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
    13 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    14 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
    15 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.
    16 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    17 RETURN_STATUS Character(10) VARCHAR2(10) NOT NULL statetax
    18 SCM_CCI_GROUP Character(15) VARCHAR2(15) NOT NULL Credit Card Group
    19 EOEC_CCI_MERCH_REF Character(50) VARCHAR2(50) NOT NULL Merchant Reference
    20 CC_RQST_TOKEN Long Character(256) VARCHAR2(256) Request Token
    21 TBLNAME Character(18) VARCHAR2(18) NOT NULL Represents a PeopleSoft database table name.
    22 CONV_INACTIVE Character(1) VARCHAR2(1) NOT NULL Convert Inactive Customers
    23 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
    601=Consumer Sync
    701=BOM Sync
    801=Item Revision
    901=Item Bus Unit Sync
    902=Item Sync
    24 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    25 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
    26 REF_PAY_GROUP_ID Number(3,0) SMALLINT NOT NULL Refund payment group
    27 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    28 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    29 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
    30 INACTIVE_TEXT Character(15) VARCHAR2(15) NOT NULL Inactive MsgText
    31 CC_OPT_DESCR Character(30) VARCHAR2(30) NOT NULL 02/14/12 EGS: Created
    32 MIN_KEY_SEPARATOR Character(2) VARCHAR2(2) NOT NULL Key Field Seperator
    33 KEYLIST Character(254) VARCHAR2(254) NOT NULL KeyList
    34 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    35 CONV_STATUS Character(1) VARCHAR2(1) NOT NULL 02/22/12 EGS: Created
    1=Not Converted
    2=In Process
    3=Complete
    4=Incomplete
    36 PUBLIC_VOUCHER_NBR Number(6,0) INTEGER NOT NULL Public Voucher Number
    37 GRP_INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    38 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
    39 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
    40 TOKEN_FLG Character(1) VARCHAR2(1) NOT NULL 03/13/12 EGS: Created
    41 MAIN_FLG Character(1) VARCHAR2(1) NOT NULL 03/15/12 EGS: Created
    42 CC_HOST_CUTOFF_DT Date(10) DATE Transaction Cut Off Date
    43 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
    44 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
    45 OK_TO_CONVERT Character(1) VARCHAR2(1) NOT NULL Ok to Convert
    46 EXISTS_TOKEN Character(1) VARCHAR2(1) NOT NULL 03/13/12 EGS: Created