PAY_CYCLEPAY_CYCLE_SEQ_NUMBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
BANK_SETIDDefault Value: OPR_BANK_VW_AP.BANK_SETID
BANK_CDBANK_ACCT_KEYPYCYCL_SUM(SQL Table) |
Index Back |
|---|---|
Summary Requirements scroll |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_CYCLE |
Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle |
| 2 | PAY_CYCLE_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Pay Cycle Sequence Number |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 4 | BANK_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Default Value: OPR_BANK_VW_AP.BANK_SETID |
| 5 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 6 | BANK_ACCT_KEY |
Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 8 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 9 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 10 | NUM_OF_VOUCHERS | Number(8,0) | INTEGER NOT NULL | Sched Pymnts |