PYCYCL_CNV_TMP(SQL Table) |
Index Back |
|---|---|
Conversion Error temp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PAY_CYCLE |
Character(6) | VARCHAR2(6) NOT NULL |
Pay Cycle
Prompt Table: SP_PYCYCL_NONVW |
| 2 | BANK_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table: SP_SETBNK_NONVW |
| 3 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_TBL |
| 4 | 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
Prompt Table: BANK_ACCT_TBL |
| 5 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table: SP_SETVND_NONVW |
| 6 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR |
| 7 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | PAY_DOC_ID |
Character(20) | VARCHAR2(20) NOT NULL | Advice ID |
| 9 | PAY_DOC_SEQ |
Number(5,0) | INTEGER NOT NULL | Advice Sequence |
| 10 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table: CURRENCY_CD_TBL |
| 11 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: RT_TYPE_TBL |
| 12 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table: CURRENCY_CD_TBL |
| 13 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL |
Payment Currency
Prompt Table: CURRENCY_CD_TBL |
| 14 | CUR_RT_TYPE_PYMNT | Character(5) | VARCHAR2(5) NOT NULL |
Payment Currency Rate Type
Prompt Table: RT_TYPE_TBL |
| 15 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 16 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 17 | PYMNT_RATE_MULT | Number(16,8) | DECIMAL(15,8) NOT NULL | An internal convention utilized for determining whether a currency exchange rate is stored |
| 18 | PYMNT_RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | An internal convention utilized for determining whether a currency exchange rate is store |
| 19 | PAY_CYCLE_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Pay Cycle Sequence Number |
| 20 | PYMNT_DT | Date(10) | DATE | Payment Date |