VED_SCHED_AET(SQL Table) |
Index Back |
|---|---|
Vchr Edit Sched AE State Tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |