PROCESS_INSTANCEPrompt Table: BANK_CD_VW
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
Y/N Table Edit
N=Next Business Day
P=Prior Business Day
B=Business Day
H=Holiday
W=Weekend Day
D=Draft Issue Date
I=Invoice Date
AP_SCHD_CLC_AET(SQL Table) |
Index Back |
|---|---|
AP Sched Pay Calc 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 | SELECT_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | SQL Select Count |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 5 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 6 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 7 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_VW |
| 8 | 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. |
| 9 | EFT_HOL_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL | EFT Bank Holiday List ID |
| 10 | SETTLEMENT_DAYS | Number(1,0) | SMALLINT NOT NULL | Settlement Days |
| 11 | SCHEDULED_PAY_DT | Date(10) | DATE | Scheduled to Pay |
| 12 | HOL_PROC_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday B=Due Before Holiday N=Not Applicable |
| 13 | HOL_PROC_DAYS | Number(3,0) | SMALLINT NOT NULL | Days before/after Holiday |
| 14 | HOL_PROC_OVERFL | Character(1) | VARCHAR2(1) NOT NULL |
Allow due date in next month
Y/N Table Edit |
| 15 | CALC_DT | Date(10) | DATE | The calculation date for a given data set within the Position tools. |
| 16 | MIN_CALC_DT | Date(10) | DATE | Minimum Calculation Date |
| 17 | MAX_CALC_DT | Date(10) | DATE | Maximum Calculation Date |
| 18 | HOLIDAY_DT | Date(10) | DATE | The date associated with a defined business holiday. |
| 19 | USE_BUS_DAY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Use Business Day |
| 20 | GO_NXT_PRV_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Go Next or Prior Business Day
N=Next Business Day P=Prior Business Day |
| 21 | MON | Character(1) | VARCHAR2(1) NOT NULL | Monday |
| 22 | TUES | Character(1) | VARCHAR2(1) NOT NULL | Tuesday |
| 23 | WED | Character(1) | VARCHAR2(1) NOT NULL | Wednesday |
| 24 | THURS | Character(1) | VARCHAR2(1) NOT NULL | Thursday |
| 25 | FRI | Character(1) | VARCHAR2(1) NOT NULL | Friday |
| 26 | SAT | Character(1) | VARCHAR2(1) NOT NULL | Saturday |
| 27 | SUN | Character(1) | VARCHAR2(1) NOT NULL | Sunday |
| 28 | BUS_DAY_STRING | Character(7) | VARCHAR2(7) NOT NULL | Business Day String |
| 29 | HOL_PROC_DAY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Holiday Processing Day Type
B=Business Day H=Holiday W=Weekend Day |
| 30 | BASIS_DATE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Basis Date Code
D=Draft Issue Date I=Invoice Date |
| 31 | NMBR_DAY | Number(3,0) | SMALLINT NOT NULL | Number of Days |
| 32 | NMBR_MTH | Number(2,0) | SMALLINT NOT NULL | Number of Months |
| 33 | DRAFT_BASIS_DT | Date(10) | DATE | Draft Terms Basis Date |
| 34 | DFT_MAT_DT | Date(10) | DATE | Draft Maturity Date |
| 35 | DFT_SCHED_MAT_DT | Date(10) | DATE | Draft Scheduled Maturity Date |