UPG_CONV_TBL(SQL Table) |
Index Back |
|---|---|
Upgrade Setup Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: CUR_RT_TYPE_TBL |
| 2 | UPG_RELEASE | Character(4) | VARCHAR2(4) NOT NULL |
Upgrade Application Release
751=7.51 Release 752=7.52 Release 753=7.53 Release 801=8 SP1 Release 803=8 SP3 Release 840=8.40 Release 841=8.40 SP1 880=8.80 Release |
| 3 | UPGRADE_DT | Date(10) | DATE | UPGRADE DATE |
| 4 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Billing Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 5 | TAX_COMPANY | Character(5) | VARCHAR2(5) NOT NULL | Company for Tax Suppliers |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 7 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 8 | START_DT | Date(10) | DATE | Start Date |
| 9 | DOC_TYPE_IU | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table: DOC_TYPE_A_VW |
| 10 | PUBLIC_SECTOR | Character(1) | VARCHAR2(1) NOT NULL | Public Sector |
| 11 | WTHD_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 12 | DAYS_UOM | Character(3) | VARCHAR2(3) NOT NULL |
the unit of measure for days
Prompt Table: SPF_UOM_VW |
| 13 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 14 | UPG_PLAN_DATA | Character(1) | VARCHAR2(1) NOT NULL |
Planning Data
E=Enterprise Planning P=Production Planning |