AP_VCHR_EZ_TBL

(SQL Table)
Index Back

EZ Voucher

EZ Voucher

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
5 GNV_EZ_NUM Character(20) VARCHAR2(20) NOT NULL EZ Invoice EZ Number

Prompt Table: AP_VCHR_EZ_VW

6 GNV_REJ_EZ_NUM Character(20) VARCHAR2(20) NOT NULL EZ Invoice Rejection Number
7 GNV_REV_EZ_NUM Character(20) VARCHAR2(20) NOT NULL Reversed EZ Invoice

Prompt Table: AP_EZ_REV_VW
Set Control Field: GNV_EZ_NUM

8 GNV_GTC_NUM Character(20) VARCHAR2(20) NOT NULL The unique agreement number that must be established between the Requesting Agency and Servicing Agency which will track each General Terms and Conditions (GT&C) agreement from the origination through the completion or termination. G-Invoicing MANINSRI 05/06/2021
9 GNV_PERFM_DTTM Date(10) DATE The date and time the performance transaction was received by a system, e.g G-Invoicing. MANINSRI 16/06/2021
10 GNV_TRANS_DTTM Date(10) DATE The date and time the performance transaction was received by a system, e.g G-Invoicing. MANINSRI 16/06/2021
11 GNV_REJECT_BY_DT Date(10) DATE EZ Invoice Reject by Date
12 GNV_PERFORM_AMT Signed Number(33,2) DECIMAL(31,2) NOT NULL EZ Invoice Performance Amount
13 GNV_AUTHORZ_NAME Character(100) VARCHAR2(100) NOT NULL EZ Invoice Authorized Name
14 GNV_AUTHORZ_EMAIL Character(100) VARCHAR2(100) NOT NULL EZ Invoice Authorized Email
15 GNV_AUTHORZ_PHONE Character(20) VARCHAR2(20) NOT NULL EZ Invoice Authorized Phone
16 GNV_PREPARER_NAME Character(100) VARCHAR2(100) NOT NULL EZ Invoice Preparer Name
17 GNV_PREPARER_EMAIL Character(100) VARCHAR2(100) NOT NULL EZ Invoice Preparer Email
18 GNV_PREPARER_PHONE Character(20) VARCHAR2(20) NOT NULL EZ Invoice Preparer Phone
19 GNV_REQUEST_GRP_ID Character(36) VARCHAR2(36) NOT NULL Unique identifier for the Buyer organizational group. G-Invoicing MANINSRI 06/06/2021
20 GNV_SERVICE_GRP_ID Character(36) VARCHAR2(36) NOT NULL Unique identifier for the Seller organizational group. G-invoicing MANINSRI 06/06/2021
21 GNV_ACCOUNT_PERIOD Number(6,0) INTEGER NOT NULL The fiscal period that the transaction is reflected in the General Ledger, if applicable. G-INVOICING MANINSRI 16/06/2021
22 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process
23 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments