DL_HDR_SASA6_VW

(SQL View)
Index Back

DLSAS 2005-06 Search Record

DLSAS Search Record for 2005-06 inbound files

SELECT A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.DL_BATCH_ID_00 , A.LN_HEADER_NBR , A.DL_HEADER_ID , A.DL_REC_LNGTH_O , A.DL_MSG_CLASS , A.DL_HDR_CREATE_DT_O , A.DL_CREATE_TIME , A.DL_BATCH_RJCT , A.DL_REBUILD_TYPE , A.DL_PROVIDER_ID , A.DL_PROVIDER_VER , A.LOAN_TRANS_DTTM , A.PROCESS_INSTANCE , A.OPRID FROM PS_DL_HDR_06_EC A , PS_DL_CSHSUM_06_EC B WHERE A.ECTRANSID = B.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW

# 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 DL_BATCH_ID_00 Character(23) VARCHAR2(23) NOT NULL DL Batch ID
5 LN_HEADER_NBR Number(3,0) SMALLINT NOT NULL Loan Header Nbr
6 DL_HEADER_ID Character(10) VARCHAR2(10) NOT NULL DL Header ID
7 DL_REC_LNGTH_O Number(4,0) SMALLINT NOT NULL Record Length
8 DL_MSG_CLASS Character(8) VARCHAR2(8) NOT NULL DL Message Class
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 DL_BATCH_RJCT Character(2) VARCHAR2(2) NOT NULL Direct Loan Batch Reject Code
12 DL_REBUILD_TYPE Character(2) VARCHAR2(2) NOT NULL DL Rebuild File Type
13 DL_PROVIDER_ID Character(3) VARCHAR2(3) NOT NULL DL Software Provider ID
14 DL_PROVIDER_VER Character(6) VARCHAR2(6) NOT NULL DL Software Provider Version
15 LOAN_TRANS_DTTM DateTime(26) TIMESTAMP Loan Trans Date/Time
16 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
17 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).