AP_PYTR_CLC_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AE_NO_LIST_EDITS	Character(1)	VARCHAR2(1) NOT NULL	no edits
3	SELECT_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	SQL Select Count
4	PYTR_CALC_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Calc Option C=Calculate Only D=Determine Discount Earned S=Schedule Results
5	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
6	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
9	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
10	TERMS_BASIS_DT	Date(10)	DATE	Payment Terms Basis Date
11	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
12	TERMS_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Terms Basis Amount
13	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
14	BASIS_YEAR_CHAR	Character(4)	VARCHAR2(4) NOT NULL	Basis Year Characters
15	BASIS_MONTH_CHAR	Character(2)	VARCHAR2(2) NOT NULL	Basis Month Characters
16	BASIS_DAY_CHAR	Character(2)	VARCHAR2(2) NOT NULL	Basis Day Characters
17	NET_DUE_ADD_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Net Due Date Days Increment
18	DSC_DUE_ADD_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Dscnt Due Date Days Increment
19	DSCNT_TRMS_PERCENT	Signed Number(13,8)	DECIMAL(11,8) NOT NULL	Discount Terms Percent
20	DSCNT_TRMS_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Terms Amount
21	TERMS_ADJUST_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Terms Adjustment Days
22	PYMNT_DELAY_DAYS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Payment Delay Days
23	DSCNT_DELAY_DAYS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Discount Delay Days
24	NBR_OF_TERMS	Number(2,0)	SMALLINT NOT NULL	Number of Terms
25	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.
26	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
27	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
28	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions