GNV_EZ_NUMGNV_REV_EZ_NUMAP_EZ_REV_VW(SQL View) |
Index Back |
|---|---|
EZ Reversed NumberEZ Reversed Number |
| SELECT DISTINCT GNV_REF_EZ_NUM , GNV_EZ_NUM FROM PS_AP_GINV_EZ_VW WHERE GNV_EZ_TRANS_TYPE='324' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GNV_EZ_NUM |
Character(20) | VARCHAR2(20) NOT NULL | EZ Invoice EZ Number |
| 2 | GNV_REV_EZ_NUM |
Character(20) | VARCHAR2(20) NOT NULL | Reversed EZ Invoice |