ECQUEUEINSTANCE1=Update
2=Deletion
3=Correction
4=Test Only
1=Interim previous-day data
2=Final previous-day data
3=Interim same-day data
4=Final same-day data
BS_GROUPHDR_EC(SQL Table) |
Index Back |
|---|---|
Bank Statement Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | RECEIVER | Character(20) | VARCHAR2(20) NOT NULL | Receiver is used in bank reconciliation |
| 3 | ORIGINATOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Originator |
| 4 | GROUP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Specifies exactly how data in a group of accounts are to be processed.
1=Update 2=Deletion 3=Correction 4=Test Only |
| 5 | ASOFDATE | Date(10) | DATE | As of Date |
| 6 | ASOFTIME | Time(15) | TIMESTAMP | As of Time |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | ASOFDATE_MODIFIER | Character(1) | VARCHAR2(1) NOT NULL |
As-of-Date Mofifier
1=Interim previous-day data 2=Final previous-day data 3=Interim same-day data 4=Final same-day data |