RBF_ATM_CARD_T

(SQL Table)
 Index Back

ATM Card

ATM Card header transaction information.............................................................

  • Parent Record Of RBF_ATM_USAGETW RBF_ATM_USAGE_T

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRANSACTION_NO Character(15) VARCHAR2(15) NOT NULL Transaction table's primary key.
    2 ATM_CARD_NO Number(16,0) DECIMAL(16) NOT NULL ATM Card Number
    3 IBANK_TRAN_TYPE Character(4) VARCHAR2(4) NOT NULL For the Internet Banking transaction table his field represents the type column.
    AACT=Reactivate Card
    ACNC=Cancel Card
    ACNN=Account Nickname
    ADDR=Change Account Address
    AFT=Automatic Fund Transfer
    AFTR=Enable or Disable Features
    AISS=Issue ATM Card
    ALIM=Change Limits
    ALNK=Link ATM Card to Account(s)
    ARPL=Replace Card
    ASSP=Suspend Card
    ATYP=Change Card Type
    FEER=Fee Reversal
    ORCC=Order Cashier's Check
    ORDC=Order Check Copy
    ORDD=Order Document
    ORFC=Order Foreign Currency
    ORTC=Order Traveler's Checks
    PROF=Profile Change
    PYBL=Pay Bill
    RECH=Reorder Checks
    STP=Stop Payment
    TRMN=Transfer Money
    4 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    6 ATM_CARD_TYPE Character(4) VARCHAR2(4) NOT NULL ATM card types such as Standard and Debit
    PRDB=Premium Debit
    PRND=Premium
    STDB=Standard Debit
    STND=Standard
    7 DEBIT_CARD_TYPE Character(4) VARCHAR2(4) NOT NULL Debit Card Type
    MAST=MasterCard
    VISA=VISA
    8 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID

    Prompt Table: SP_SETID_NONVW

    9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: RBF_ATM_PROD_VW

    10 ATM_CARD_STATUS Character(3) VARCHAR2(3) NOT NULL Status of an ATM Card, stored as a translate value
    ACT=Active
    CNC=Cancelled
    ERR=Error
    INA=Inactive
    PRC=Processing
    SSP=Suspended
    11 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

    Prompt Table: BO

    12 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    13 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

    Prompt Table: BO_CNCT_PRSN_VW

    14 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    15 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID

    Prompt Table: CM

    16 SHIPPING_OPTION Character(4) VARCHAR2(4) NOT NULL Shipping Option
    PICK=Picked up by Customer
    SHIP=Shipped to Customer
    17 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    18 SITE_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.
    19 SHIPPING_METHOD Character(4) VARCHAR2(4) NOT NULL Shipping Method
    FED=FedEx
    FEDE=FedEx Express
    UPS=UPS Ground
    UPS2=UPS 2nd Day Air
    UPSN=UPS Next Day Air
    USPP=USPS Priority Mail
    USPS=USPS First Class Mail
    20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    21 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    22 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    23 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    24 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    25 CITY Character(30) VARCHAR2(30) NOT NULL City
    26 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    27 NUM2 Character(4) VARCHAR2(4) NOT NULL Number 2
    28 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    29 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    30 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    31 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    32 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    33 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    34 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    35 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    36 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    Default Value: Y

    37 CASH_WD_FLG Character(1) VARCHAR2(1) NOT NULL Cash withdrawal flag

    Y/N Table Edit

    Default Value: Y

    38 POS_FLG Character(1) VARCHAR2(1) NOT NULL position flag

    Y/N Table Edit

    Default Value: Y

    39 BILL_PAY_FLG Character(1) VARCHAR2(1) NOT NULL Bill Pay Flag

    Y/N Table Edit

    Default Value: Y

    40 LIMIT_CURR_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    41 CASH_WD_LIMIT Number(29,4) DECIMAL(28,4) NOT NULL Cash Withdrawal Limit
    42 ATM_REPLACE_REASON Character(4) VARCHAR2(4) NOT NULL reason for atm replacement
    DAMG=Damaged Card
    LOST=Lost
    MAGN=Bad Magnetic Strip
    STOL=Stolen
    43 ATM_SUSPEND_REASON Character(4) VARCHAR2(4) NOT NULL Reason for ATM Card Suspension
    ACSU=Account Suspended
    STOL=Stolen
    44 ATM_CANCEL_REASON Character(4) VARCHAR2(4) NOT NULL Atm Cancel reason
    ACCL=Account(s) Closed
    LOST=Lost
    NEED=Don't Need Card
    STOL=Stolen
    45 ATM_REACT_REASON Character(4) VARCHAR2(4) NOT NULL Atm reason
    BERR=Bank Error
    CREQ=Customer Request
    OCLR=Overdraft Cleared
    46 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    47 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    48 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    49 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    50 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    51 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time