VAT_DST_ACCT_TYPEVAT_DST_TYPE_VW(SQL View) |
Index Back |
|---|---|
Prompt - Account Types for VAT |
| SELECT FIELDVALUE , XLATLONGNAME , XLATSHORTNAME FROM PSXLATITEM WHERE FIELDNAME = 'DST_ACCT_TYPE' AND (FIELDVALUE LIKE 'VO%' OR FIELDVALUE LIKE 'VI%') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VAT_DST_ACCT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger. |
| 2 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 3 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |