BNK_RCN_INP_LAY

(SQL Table)
 Index Back

Bank Recon Input File Layout

  • Related Language Record: BNK_RCNILAY_LNG

  • Parent Record Of BNK_RCNITRN_LNG BNK_RCN_INP_TRN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID

    Prompt Table: SP_SETID_NONVW

    2 RECON_LAYOUT_ID Character(8) VARCHAR2(8) NOT NULL Input File Layout ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: BNK_RCN_INP_LAY.DESCR

    5 TYPE_OF_GROUP Character(1) VARCHAR2(1) NOT NULL Type of Group
    E=Student Group
    X=External Org Group

    Default Value: E

    6 RECON_REC_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Record Type Flag
    N=Positional
    Y=Record Type Field

    Default Value: N

    7 RECON_REC_TYPE_OFF Number(3,0) SMALLINT NOT NULL Record Type
    8 RECON_REC_TYPE_LEN Number(3,0) SMALLINT NOT NULL Record Type Length
    9 RECON_REC_TYPE_DTL Character(20) VARCHAR2(20) NOT NULL Record Type Detail
    10 RECON_REC_TYPE_HDR Character(20) VARCHAR2(20) NOT NULL Record Type Header
    11 RECON_REC_TYPE_TRL Character(20) VARCHAR2(20) NOT NULL Record Type Trailer
    12 RECON_USE_HDR_FLG Character(1) VARCHAR2(1) NOT NULL Use Header Flag

    Y/N Table Edit

    Default Value: Y

    13 RECON_USE_TRL_FLG Character(1) VARCHAR2(1) NOT NULL Use Trailer Flag

    Y/N Table Edit

    Default Value: Y

    14 RECON_TRANS_CD_FLG Character(1) VARCHAR2(1) NOT NULL Transaction Code Flag

    Y/N Table Edit

    Default Value: N

    15 RECON_TRANS_CD_OFF Number(3,0) SMALLINT NOT NULL Transaction Code
    16 RECON_TRANS_CD_LEN Number(3,0) SMALLINT NOT NULL Transaction Code Length
    17 RECON_REF_FLG Character(1) VARCHAR2(1) NOT NULL Recon Reference Nbr Flag

    Y/N Table Edit

    Default Value: N

    18 RECON_REF_OFF Number(3,0) SMALLINT NOT NULL Reference Nbr
    19 RECON_REF_LEN Number(3,0) SMALLINT NOT NULL Transaction Reference Length
    20 RECON_AMT_FLG Character(1) VARCHAR2(1) NOT NULL Recon Amount Flag

    Default Value: Y

    21 RECON_AMT_OFF Number(3,0) SMALLINT NOT NULL Amount Offset
    22 RECON_AMT_LEN Number(3,0) SMALLINT NOT NULL Transaction Amount Length
    23 RECON_TRANS_DT_FLG Character(1) VARCHAR2(1) NOT NULL Transaction Date Flag

    Y/N Table Edit

    Default Value: N

    24 RECON_TRANS_DT_OFF Number(3,0) SMALLINT NOT NULL Accounting Date
    25 RECON_TRANS_DT_LEN Number(3,0) SMALLINT NOT NULL Transaction Date Length
    26 RECON_TRANS_DT_FMT Character(1) VARCHAR2(1) NOT NULL Date Format
    1=YYMMDD
    2=MMDDYY
    3=DDMMYY
    4=CCYYMMDD
    5=MMDDCCYY
    6=DDMMCCYY
    27 RECON_PAYEE_FLG Character(1) VARCHAR2(1) NOT NULL Match Payee Name

    Y/N Table Edit

    Default Value: Y

    28 RECON_PAYEE_OFF Number(3,0) SMALLINT NOT NULL Customer ID
    29 RECON_PAYEE_LEN Number(3,0) SMALLINT NOT NULL Payee ID Length
    30 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type

    Default Value: NO

    Prompt Table: NID_TYPE1_VW

    31 PREFIX_TWO Character(2) VARCHAR2(2) NOT NULL Prefix Two
    32 RECON_ACCT_TYP_FLG Character(1) VARCHAR2(1) NOT NULL Account Type Flag

    Y/N Table Edit

    Default Value: N

    33 RECON_ACCT_TYP_OFF Number(3,0) SMALLINT NOT NULL Account Type
    34 RECON_ACCT_TYP_LEN Number(3,0) SMALLINT NOT NULL Account Type Length
    35 RECON_ACCT_TYP_DFT Character(3) VARCHAR2(3) NOT NULL Account Type

    Prompt Table: ACCT_TYP_TBL_SF

    36 RECON_ITEM_TYP_FLG Character(1) VARCHAR2(1) NOT NULL Item Type Flag

    Y/N Table Edit

    Default Value: Y

    37 RECON_ITEM_TYP_OFF Number(3,0) SMALLINT NOT NULL Item Type
    38 RECON_ITEM_TYP_LEN Number(3,0) SMALLINT NOT NULL Item Type Length
    39 RECON_ITEM_TYP_DFT Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TYPE_TBL

    40 RECON_TERM_FLG Character(1) VARCHAR2(1) NOT NULL Term Flag

    Y/N Table Edit

    Default Value: N

    41 RECON_TERM_OFF Number(3,0) SMALLINT NOT NULL Term Offset
    42 RECON_TERM_LEN Number(3,0) SMALLINT NOT NULL Term Length
    43 RECON_TERM_DFT Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    44 RECON_CHCK_NUM_FLG Character(1) VARCHAR2(1) NOT NULL Check Nbr Flag

    Y/N Table Edit

    Default Value: N

    45 RECON_CHCK_NUM_OFF Number(3,0) SMALLINT NOT NULL Check Nbr
    46 RECON_CHCK_NUM_LEN Number(3,0) SMALLINT NOT NULL Check Nbr Length
    47 RECON_CTL_NUM_FLG Character(1) VARCHAR2(1) NOT NULL Control Nbr

    Y/N Table Edit

    Default Value: N

    48 RECON_CTL_NUM_OFF Number(3,0) SMALLINT NOT NULL Bank Tracer Nbr
    49 RECON_CTL_NUM_LEN Number(3,0) SMALLINT NOT NULL Control Nbr Length
    50 RECON_CTL_CNT_FLG Character(1) VARCHAR2(1) NOT NULL Control Count Flag

    Y/N Table Edit

    Default Value: N

    51 RECON_CTL_REC Character(1) VARCHAR2(1) NOT NULL Control Record
    H=Header
    N=None
    T=Trailer

    Default Value: H

    52 RECON_CTL_CNT_OFF Number(3,0) SMALLINT NOT NULL Control Count
    53 RECON_CTL_CNT_LEN Number(3,0) SMALLINT NOT NULL Control Count Length
    54 RECON_CTL_AMT_FLG Character(1) VARCHAR2(1) NOT NULL Control Amount Flag

    Y/N Table Edit

    Default Value: N

    55 RECON_CTL_AMT_OFF Number(3,0) SMALLINT NOT NULL Control Amount
    56 RECON_CTL_AMT_LEN Number(3,0) SMALLINT NOT NULL Control Amount Length
    57 RECON_ORIGIN_OFF Number(3,0) SMALLINT NOT NULL Recon Origin Offset
    58 RECON_ORIGIN_LEN Number(3,0) SMALLINT NOT NULL Recon Origin Length
    59 RECON_ORIGIN_DFT Character(5) VARCHAR2(5) NOT NULL Recon Origin

    Prompt Table: ORIGIN_TBL

    60 RECON_UNK_ERR_FLG Character(1) VARCHAR2(1) NOT NULL Abort Load on Unknown Rec Type

    Y/N Table Edit

    Default Value: N

    61 RECON_ORIGCURR_OFF Number(3,0) SMALLINT NOT NULL Recon Original Currency Cd Off
    62 RECON_ORIGCURR_LEN Number(3,0) SMALLINT NOT NULL Recon Original Currency Length
    63 RECON_ORIGCURR_DFT Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    64 RECON_CHRG_PTY_FLG Character(1) VARCHAR2(1) NOT NULL Charge Priority Flag

    Y/N Table Edit

    Default Value: N

    65 RECON_CHRG_PTY_OFF Number(3,0) SMALLINT NOT NULL Charge Priority
    66 RECON_CHRG_PTY_LEN Number(3,0) SMALLINT NOT NULL Charge Priority Length
    67 CHARGE_PRIORITY Character(8) VARCHAR2(8) NOT NULL Charge Priority List

    Prompt Table: PMT_CHRG_TBL

    68 RECON_DESCR_FLG Character(1) VARCHAR2(1) NOT NULL Description Flag

    Y/N Table Edit

    Default Value: N

    69 RECON_DESCR_OFF Number(3,0) SMALLINT NOT NULL Description
    70 RECON_DESCR_LEN Number(3,0) SMALLINT NOT NULL Description Length
    71 RECON_DESCR_DFT Character(30) VARCHAR2(30) NOT NULL Description
    72 RECON_DUE_DT_FLG Character(1) VARCHAR2(1) NOT NULL Due Date Flag

    Y/N Table Edit

    Default Value: N

    73 RECON_DUE_DT_OFF Number(3,0) SMALLINT NOT NULL Due Date
    74 RECON_DUE_DT_LEN Number(3,0) SMALLINT NOT NULL Due Date Length
    75 RECON_DUE_DT_FMT Character(1) VARCHAR2(1) NOT NULL Date Format
    1=YYMMDD
    2=MMDDYY
    3=DDMMYY
    4=CCYYMMDD
    5=MMDDCCYY
    6=DDMMCCYY
    76 RECON_DUE_DT_OPTN Character(1) VARCHAR2(1) NOT NULL Due Date Option
    E=Item Effective Date
    N=Null Due Date
    R=Program Run Date
    S=Specific Date
    77 DUE_DT Date(10) DATE Expected Birth Date
    78 RECON_ADM_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Application Number Flag

    Y/N Table Edit

    Default Value: N

    79 RECON_ADM_APPL_OFF Number(3,0) SMALLINT NOT NULL Application Nbr
    80 RECON_ADM_APPL_LEN Number(3,0) SMALLINT NOT NULL Application Nbr Length
    81 RECON_CONT_NUM_FLG Character(1) VARCHAR2(1) NOT NULL Contract Number Flag

    Y/N Table Edit

    Default Value: N

    82 RECON_CONT_NUM_OFF Number(3,0) SMALLINT NOT NULL Contract Nbr
    83 RECON_CONT_NUM_LEN Number(3,0) SMALLINT NOT NULL Contract Nbr Length
    84 RECON_CONT_ID_FLG Character(1) VARCHAR2(1) NOT NULL Contract Number Flag

    Y/N Table Edit

    Default Value: N

    85 RECON_CONT_ID_OFF Number(3,0) SMALLINT NOT NULL Contract Emplid
    86 RECON_CONT_ID_LEN Number(3,0) SMALLINT NOT NULL Contract Emplid Length
    87 RECON_RFND_ID_FLG Character(1) VARCHAR2(1) NOT NULL Refund Emplid Flag

    Y/N Table Edit

    Default Value: N

    88 RECON_RFND_ID_OFF Number(3,0) SMALLINT NOT NULL Refund Emplid
    89 RECON_RFND_ID_LEN Number(3,0) SMALLINT NOT NULL Refund Emplid Length
    90 RECON_BILL_DT_FLG Character(1) VARCHAR2(1) NOT NULL Billing Date Flag

    Y/N Table Edit

    Default Value: N

    91 RECON_BILL_DT_OFF Number(3,0) SMALLINT NOT NULL Billing Date Offset
    92 RECON_BILL_DT_LEN Number(3,0) SMALLINT NOT NULL Billing Date Length
    93 RECON_BILL_DT_FMT Character(1) VARCHAR2(1) NOT NULL Date Format
    1=YYMMDD
    2=MMDDYY
    3=DDMMYY
    4=CCYYMMDD
    5=MMDDCCYY
    6=DDMMCCYY
    94 BILLING_DT Date(10) DATE Billing Date
    95 RECON_PMTIDNBR_FLG Character(1) VARCHAR2(1) NOT NULL Payment ID Nbr Flag

    Y/N Table Edit

    Default Value: N

    96 RECON_PMTIDNBR_OFF Number(3,0) SMALLINT NOT NULL Payment ID Nbr
    97 RECON_PMTIDNBR_LEN Number(3,0) SMALLINT NOT NULL Payment ID Nbr Length
    98 RECON_REV_IND_FLG Character(1) VARCHAR2(1) NOT NULL Reversal Indicator Flag

    Y/N Table Edit

    Default Value: N

    99 RECON_REV_IND_OFF Number(3,0) SMALLINT NOT NULL Reversal Indicator
    100 RECON_REV_IND_LEN Number(3,0) SMALLINT NOT NULL Reversal Indicator Length
    101 SSF_RECON_INV_FLG Character(1) VARCHAR2(1) NOT NULL Invoice ID Flag

    Y/N Table Edit

    Default Value: N

    102 SSF_RECON_INV_OFF Number(3,0) SMALLINT NOT NULL Invoice ID offset
    103 SSF_RECON_INV_LEN Number(3,0) SMALLINT NOT NULL Invoice ID Length