VAT_DST_TYPE(SQL Table) |
Index Back |
|---|---|
Account Types for VAT |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | VAT_PRCHS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Used for Purchases
Y/N Table Edit Default Value: N |
| 5 | VAT_SALES_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Used for Sales
Y/N Table Edit Default Value: N |
| 6 | VAT_EXPENSES_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Used for Expenses
Y/N Table Edit Default Value: N |
| 7 | VAT_GL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Used for GL
Y/N Table Edit Default Value: N |
| 8 | VAT_ACCT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Used for Accounting
Y/N Table Edit Default Value: Y |
| 9 | VAT_TXN_TBL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Used in VAT Transaction Table
Y/N Table Edit Default Value: N |
| 10 | VAT_GL_ACCT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
General Ledger VAT Account
Y/N Table Edit Default Value: N |
| 11 | VAT_ENTRY_TYPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
VAT Entry Type
I=Input O=Output |
| 12 | VAT_DST_TYPE_AUTH | Character(4) | VARCHAR2(4) NOT NULL |
VAT Distrib Type Group
Prompt Table: VAT_DST_TYPE |
| 13 | VAT_AM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Used for Assets
Y/N Table Edit Default Value: N |
| 14 | VAT_ACCTG_ENT_GRP | Character(1) | VARCHAR2(1) NOT NULL |
VAT Accounting Entry Group
I=Other Input VAT N=Non-Recoverable Input VAT O=Output VAT |
| 15 | VAT_TR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Used for Treasury
Y/N Table Edit Default Value: N |