BUSINESS_UNITASSET_IDTRANSACTIONIDPrompt Table: SP_BU_AP_NONVW
Prompt Table: VCHR_VW_AM
A=Active
I=Inactive
Prompt Table: CATEGORY_TBL
AM_VAT_ATTR_H(SQL Table) |
Index Back |
|---|---|
AM Vat Attributes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | TRANSACTIONID |
Number(10,0) | DECIMAL(10) NOT NULL | Transaction Identifier |
| 4 | CREATION_DT | Date(10) | DATE | Creation Date |
| 5 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL | Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen. |
| 6 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table: SP_BU_AP_NONVW |
| 7 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table: VCHR_VW_AM |
| 8 | TRAN_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Describes the transaction. |
| 9 | YEAR_OF_INIT | Number(4,0) | SMALLINT NOT NULL | Initial VAT Recoverable Year |
| 10 | VAT_NBR_OF_YEARS | Number(2,0) | SMALLINT NOT NULL | VAT Recoverable Years |
| 11 | ACTIVE_INACT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Record?
A=Active I=Inactive |
| 12 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Asset Category
Prompt Table: CATEGORY_TBL |