GFAP_PYCERT_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
2	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
3	SCHEDULE_ID	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
6	PAY_DOC_SEQ	Number(5,0)	INTEGER NOT NULL	Advice Sequence
7	PAY_DOC_DT	Date(10)	DATE	Advice Date
8	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
9	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
10	SCHEDULED_PAY_DT	Date(10)	DATE	Scheduled to Pay
11	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
12	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
13	DSCNT_PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Discount Amount
14	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
15	PYMNT_MESSAGE	Character(70)	VARCHAR2(70) NOT NULL	Payment Message
16	PYMNT_SEPARATE	Character(1)	VARCHAR2(1) NOT NULL	Separate Payment Y/N Table Edit
17	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
18	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
19	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
20	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
21	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
22	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
23	PYMNT_SELCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Selection Status C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid
24	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
25	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
26	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
27	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
28	PYMNT_GROUP_CD	Character(2)	VARCHAR2(2) NOT NULL	Pay Group Code
29	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
30	PAID_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Paid Amount
31	PAID_AMT_GROSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Paid Amount
32	PAID_AMT_DSCNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount on Paid Amount
33	PAID_AMT_GROSS_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Payment Amount
34	PAID_AMT_DSCNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Discount Paid Amount
35	PAID_AMT_BNK_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount - Base Bank Unit
36	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
37	CUR_RT_TYPE_PYMNT	Character(5)	VARCHAR2(5) NOT NULL	Payment Currency Rate Type
38	PYMNT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is stored
39	PYMNT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is store
40	BASE_CURRENCY_BNK	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the subject bank general ledger business unit.
41	CUR_RT_TYPE_BNK	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
42	BNK_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange spot rate is stored either as
43	BNK_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange spot rate is store
44	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
45	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
46	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
47	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
48	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
49	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
50	PYMNT_DT	Date(10)	DATE	Payment Date
51	PREFERRED_LANGUAGE	Character(3)	VARCHAR2(3) NOT NULL	Preferred Language ARA=Arabic CFR=Canadian French CZE=Czech DAN=Danish DUT=Dutch E=English ENG=English ESP=Spanish F=French FIN=Finnish FRA=French GER=German HUN=Hungarian INE=International English ITA=Italian JPN=Japanese KOR=Korean NOR=Norwegian POL=Polish POR=Portuguese RUS=Russian SVE=Swedish THA=Thai UKE=UK English ZHS=Simplified Chinese ZHT=Traditional Chinese
52	REMIT_BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit Bank Setid
53	REMIT_BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Remit Bank Code
54	REMIT_BNK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	Remit Bank Account
55	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
56	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
57	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
58	DOC_SEQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting. 1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status
59	PYMNT_REASON_CD	Character(4)	VARCHAR2(4) NOT NULL	Payment Reason Code
60	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
61	PYMNT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Hold Payment N=No Y=Yes
62	PYMNT_HOLD_REASON	Character(3)	VARCHAR2(3) NOT NULL	Hold Reason ACC=Accounting in Dispute ACV=Federal Supplier Inactive ALC=Agency Location Code Required AMT=Amount in Dispute CCR=CCR Expired CRT=Contract Retention EFT=EFT incomplete or not Prenoted FNS=Financial Sanctions GDS=Goods in Dispute GNV=G-Invoicing Hold IPC=Inbound IPAC Required OTH=Other QTY=Quantity in Dispute SAM=SAM Expired WTH=Withholding Hold
63	PAY_SCHEDULE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Pay Schedule Type MAN=Manual OTH=Other Non Transportation TRN=Transportation