EODI_XFR_TRANS_IDDefault Value: 0
Prompt Table: EODI_XFR_REG
A=Assembling File
C=Processing Complete
P=Processing Application Logic
R=Receiving File
Default Value: P
Y/N Table Edit
Default Value: N
EODI_XFR_DETAIL(SQL Table) |
Index Back |
|---|---|
Desktop Integration FilesCheck In/Out Files |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EODI_XFR_TRANS_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Transfer ID
Default Value: 0 |
| 2 | EODI_XFR_PROC_ID | Character(15) | VARCHAR2(15) NOT NULL |
Transfer Process ID
Prompt Table: EODI_XFR_REG |
| 3 | EODI_XFR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Status
A=Assembling File C=Processing Complete P=Processing Application Logic R=Receiving File Default Value: P |
| 4 | EODI_DELETED | Character(1) | VARCHAR2(1) NOT NULL |
Deleted Flag
Y/N Table Edit Default Value: N |
| 5 | EODI_LAST_UP_DTTM | DateTime(26) | TIMESTAMP | Last Update Date Time |
| 6 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 7 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |