VED_SCHED_AET

(SQL Table)
Index Back

Vchr Edit Sched AE State Tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
3 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
4 SELECT_COUNT Number(10,0) DECIMAL(10) NOT NULL SQL Select Count
5 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
8 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
9 INVOICE_DT Date(10) DATE Invoice Date
10 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
11 PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount
12 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions
13 PVX_UNALLOC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unallocated Payment Amount
14 PVX_UNALLOC_CNT Number(10,0) DECIMAL(10) NOT NULL Unallocated Payment Count
15 PVX_UNALLOC_FIRST Number(5,0) INTEGER NOT NULL First Unallocated Payment Nbr
16 PVX_UNALLOC_LAST Number(5,0) INTEGER NOT NULL Last Unallocated Payment Nbr
17 PVX_ALLOC_SHR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Allocated Payment Share Amount
18 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.
19 DSCNT_DUE_DT Date(10) DATE Discount Due Date
20 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount
21 DUE_DT_FLG Character(1) VARCHAR2(1) NOT NULL Due Date Control
T=Controlled by Terms
U=User Specified
22 DSCNT_AMT_FLG Character(1) VARCHAR2(1) NOT NULL Discount Amount Control
T=Controlled by Payment Terms
U=User Specified
23 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
24 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
25 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
26 HOLIDAY_LIST_ID Character(10) VARCHAR2(10) NOT NULL This is used to identify what holiday calendar to use. This is the access field for all financials groups.
27 HOL_PROC_LVL Character(1) VARCHAR2(1) NOT NULL Holiday Processing level
B=Specify Calendar at Bank level
U=Specify Calendar
28 USE_BUS_DAY_FLG Character(1) VARCHAR2(1) NOT NULL Use Business Day
29 GO_NXT_PRV_FLG Character(1) VARCHAR2(1) NOT NULL Go Next or Prior Business Day
N=Next Business Day
P=Prior Business Day
30 DFT_MAT_DT Date(10) DATE Draft Maturity Date
31 DFT_SCHED_MAT_DT Date(10) DATE Draft Scheduled Maturity Date
32 PYMNT_CNT_TOTAL Number(5,0) INTEGER NOT NULL Total Payment Count
33 PYMNT_CNT_MAX Number(5,0) INTEGER NOT NULL Max payment count
34 GROSS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Amount
35 DSCNT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Amount
36 DIFFERENCE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Difference Amount