VAT_DST_ACCT_TYPEPrompt Table: VAT_DST_TYPE_VW
VAT_DST_GL_O_VW(SQL View) |
Index Back |
|---|---|
GL Output VAT Account TypeGL Output VAT Account Type |
| SELECT VAT_DST_ACCT_TYPE , DESCR , DESCRSHORT FROM PS_VAT_DST_TYPE WHERE VAT_GL_ACCT_FLG = 'Y' AND VAT_ENTRY_TYPE_FLG = 'O' |
| # | 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.
Prompt Table: VAT_DST_TYPE_VW |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |