INTFC_AP_AM_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PRE_INTFC_ID	Number(8,0)	INTEGER NOT NULL	Pre-Interface ID
3	PRE_INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Pre-Interface Line Number
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
6	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".
7	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
8	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
10	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
11	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
12	PROCESS_APAM_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Process Option A=Process All Business Units B=Process Business Unit C=Process Contract G=Process Control Group I=Process Voucher O=Process Origin V=Process Supplier
13	GRP_AP_ID	Character(10)	VARCHAR2(10) NOT NULL	Control Group ID
14	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
15	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
16	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
17	ORIGIN_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
18	QUANTITY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Interface
19	SEL_CNT	Number(4,0)	SMALLINT NOT NULL	Selected Count
20	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
21	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
22	PO_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Purchase Order Line Number
23	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
24	PO_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	PO Distribution Line Number
25	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
26	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
27	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
28	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
29	RECV_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Receiver Distrib Line
30	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
31	FIX_ROUNDING_ERROR	Character(1)	VARCHAR2(1) NOT NULL	Fix Rounding Error
32	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
33	COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Cost
34	DISTRIB_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Sequence
35	TAG_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Tag Number
36	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
37	CHARTFIELD_PR1	Character(18)	VARCHAR2(18) NOT NULL	Chartfield Priority 1
38	CHARTFIELD_PR2	Character(18)	VARCHAR2(18) NOT NULL	Chartfield Priority 2
39	VAT_SETID	Character(5)	VARCHAR2(5) NOT NULL	VAT SetID
40	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
41	BUSINESS_UNIT_VAT	Character(5)	VARCHAR2(5) NOT NULL	Vat Apportionment Business Uni
42	CHARTFIELD_PR1_VAL	Character(20)	VARCHAR2(20) NOT NULL	Chartfield Priority 1 Value
43	CHARTFIELD_PR2_VAL	Character(20)	VARCHAR2(20) NOT NULL	Chartfield Priority 2 Value
44	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Recovery Percent
45	VAT_CONSTRAINT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Coefficient of Constraint
46	VAT_TAXATION_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Coefficient of Taxation
47	VAT_ADMISSION_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Coefficient of Admission
48	TAX_CD_VAT	Character(8)	VARCHAR2(8) NOT NULL	Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
49	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
50	ACCOUNTING_DT_AP	Date(10)	DATE	Accounting Date AP
51	PRIMARY_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.
52	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
53	POSTING_PROCESS	Character(4)	VARCHAR2(4) NOT NULL	Posting Process ACAV=Period End Accruals ACCR=AP Accrual CANC=Payment Cancelations CASH=Cash Clearing CLOS=Voucher Closure DFTA=Draft Accrual PCAD=Card PPAY=Prepaid Reversals PREP=Prepaids PYMN=Payments RACC=Receipt Accrual RCVL=Revaluation REVL=Revaluations VOID=Void WTHA=Withholding Accrual
54	CF_BAL_LINE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Chart Field Balancing Line Num
55	TAX_AUTHORITY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Authority
56	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
57	FILENAME_OUT	Character(80)	VARCHAR2(80) NOT NULL	Output file name
58	FILEREFPATH	Character(128)	VARCHAR2(128) NOT NULL	File Reference Path
59	PO_GROUP_ID	Character(18)	VARCHAR2(18) NOT NULL	GroupID
60	PO_GRP_SEQ_NUM	Number(8,0)	INTEGER NOT NULL	Procurement Group Sequence
61	END_PO_GRP_SEQ	Number(8,0)	INTEGER NOT NULL	Procurement Group Sequence
62	MAX_PO_GRP_SEQ	Number(8,0)	INTEGER NOT NULL	Procurement Group Sequence
63	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
64	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
65	QTY_RECV_APPLIED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Receiver line ship quantity applied to voucher line in PO unit of measure