DL_HEADR_IN_EC

(SQL Table)
 Index Back

DL Header In Stgn Tbl

Direct Loan Header Inbound Stgn Tbl - 1997 Aid Year

  • Parent Record Of DL_CHG_ACK_EC DL_CRDT_ACK_EC DL_ORGACK_00_EC DL_ORGACK_01_EC DL_ORGACK_01_VW DL_ORIG_ACK_EC DL_PNOTE_ACK_EC DL_TRLR_IN_EC DL_TRL_00_EC DL_TRL_01_EC DL_TRL_01_VW DL_TRL_02_EC DL_TRL_02_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
    2 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
    3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
    I=Inbound
    O=Outbound

    Default Value: I

    4 LN_HEADER_NBR Number(3,0) SMALLINT NOT NULL Loan Header Nbr
    5 DL_HEADER_ID Character(10) VARCHAR2(10) NOT NULL DL Header ID

    Default Value: DL HEADER

    6 DL_REC_LNGTH_O Number(4,0) SMALLINT NOT NULL Record Length
    7 DL_MSG_CLASS Character(8) VARCHAR2(8) NOT NULL DL Message Class
    8 DL_HDR_BATCH_ID Character(23) VARCHAR2(23) NOT NULL DL Header Batch ID
    9 DL_HDR_CREATE_DT_O Date(10) DATE DL Create Date
    10 DL_CREATE_TIME Character(6) VARCHAR2(6) NOT NULL DL Create Time
    11 LOAN_TRANS_DTTM DateTime(26) TIMESTAMP Loan Trans Date/Time
    12 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).