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 |