UPG_APE01_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	BUSINESS_UNIT_1	Character(5)	VARCHAR2(5) NOT NULL	Non-Joint Venture BU
4	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
5	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
6	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
7	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
8	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
9	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
10	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
11	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
12	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
13	CF_BAL_LINE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Chart Field Balancing Line Num
14	SALETX_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Applicable
15	SUT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	Sales/Use Tax Applicability D=Direct Pay E=Item is Exempt S=Sales Tax Applicable U=Use Tax Applicable X=Purchaser Is Exonerated
16	TAX_CD_SUT	Character(8)	VARCHAR2(8) NOT NULL	Tax Code - Sales and Use Tax
17	SALETX_CD	Character(8)	VARCHAR2(8) NOT NULL	Sales Tax Code
18	USETAX_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use Tax Applicable
19	USETAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Use Tax Code
20	BASE_CURRENCY_BNK	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the subject bank general ledger business unit.
21	CUR_RT_TYPE_BNK	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
22	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
23	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. "
24	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
25	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
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	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
28	SETID1	Character(5)	VARCHAR2(5) NOT NULL	SetID Value
29	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
30	UA_VENDOR_ID1	Character(10)	VARCHAR2(10) NOT NULL	Supplier ID
31	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
32	UA_VNDR_LOC1	Character(10)	VARCHAR2(10) NOT NULL	Supplier Location
33	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
34	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
35	PYMNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Document Type E=Express Payment M=Manual Payment R=Regular payment W=Withholding Payment Z=Zero Payment Check
36	SCHEDULED_PAY_DT	Date(10)	DATE	Scheduled to Pay
37	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
38	PRCNT_WTHHLD	Number(6,2)	DECIMAL(5,2) NOT NULL	Percent Withheld
39	UA_PRCNT_WTHD_BU	Number(6,2)	DECIMAL(5,2) NOT NULL	Percent Withheld
40	UA_PRCNT_PRORATE	Number(9,7)	DECIMAL(8,7) NOT NULL	Percent Withheld
41	UA_PRCNT_WTHD_VNDR	Number(6,2)	DECIMAL(5,2) NOT NULL	Percent Withheld
42	EXCHNG_RT_BNK	Number(16,7)	DECIMAL(15,7) NOT NULL	Exchange Rate
43	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
44	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
45	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
46	UA_CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Exchange Rate Type
47	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
48	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
49	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
50	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
51	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
52	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
53	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
54	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
55	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
56	EFFDT	Date(10)	DATE	Effective Date
57	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
58	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
59	WTHD_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Basis Amount
60	END_DATE	Date(10)	DATE	End Date
61	BEGIN_DT	Date(10)	DATE	Begin Date
62	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
63	PREV_VENDOR	Character(15)	VARCHAR2(15) NOT NULL	Previous vendor processed in 1099 Reporting AE.
64	PREV_SETID	Character(5)	VARCHAR2(5) NOT NULL	Previous Setid