GPGB_EDI_REFDefault Value: 9
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Y/N Table Edit
GPGB_EDI_TRANS(SQL Table) |
Index Back |
|---|---|
EDI Transactions CounterGPUK record counts number of final edi transactions initiated. Used to set a unique reference field in the edi output. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPGB_EDI_REF |
Number(14,0) | DECIMAL(14) NOT NULL | GPUK EDI stores EDI transaction number |
| 2 | GPGB_EDI_NI_MATCH | Number(3,0) | SMALLINT NOT NULL |
GPUK EDI
Field stores length of NI number to match
Default Value: 9 |
| 3 | GPGB_EDI_AUDIT | Character(1) | VARCHAR2(1) NOT NULL |
Use EDI Audit Flag
Y/N Table Edit Default Value: Y |
| 4 | GPGB_EDI_PATHIN | Character(64) | VARCHAR2(64) NOT NULL | GPUK EDI stores EDI incoming file path |
| 5 | GPGB_EDI_IN_ABS | Character(1) | VARCHAR2(1) NOT NULL |
GPUK EDI stores EDI absolute file path indicator
Y/N Table Edit |
| 6 | GPGB_EDI_PATHOUT | Character(64) | VARCHAR2(64) NOT NULL | GPUK EDI stores EDI outgoing file path |
| 7 | GPGB_EDI_OUT_ABS | Character(1) | VARCHAR2(1) NOT NULL |
GPUK EDI stores EDI absolute file path indicator
Y/N Table Edit |