| # |
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
|
| 4 |
TRANS_CNTRL_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Transaction Set Control Number
|
| 5 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 6 |
EDI_REF_NBR_QUAL |
Character(2) |
VARCHAR2(2) NOT NULL |
EDI Reference Number Qualifier
30=United States Govern Visa Nbr
48=Agency's Student Number
49=Family Unit Number
4A=Personal Identification Number
50=State Student ID Number
56=Corrected SSN
57=Prior Incorrect SSN
A6=Employee Identification Number
C0=Canadian Social Insurance Nbr
E4=Charge Card
LR=Local Student Id Nbr
MV=Migrant Number
SY=Social Security Number
V2=Visa Type
V4=State Department I-20 Form Nbr
V5=State Depart IAP-66 Form Nbr
ZZ=Mutually Defined
|
| 7 |
EDI_REF_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
EDI Reference Number
|
| 8 |
TRANS_ROW_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Row ID
|