VAT_DST_ACCT_TYPELANGUAGE_CDVAT_DST_LANG(SQL View) |
Index Back |
|---|---|
Prompt - Account Types for VAT |
| SELECT FIELDVALUE ,LANGUAGE_CD , XLATLONGNAME , XLATSHORTNAME FROM PSXLATITEMLANG 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 4 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |