SETIDDefault Value: TAX_HEADER_TBL.SETID
TAX_CDDefault Value: TAX_HEADER_TBL.TAX_CD
VAT_DST_ACCT_TYPEVAT_DST_WS1(SQL Table) |
Index Back |
|---|---|
Workscroll |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: TAX_HEADER_TBL.SETID |
| 2 | TAX_CD |
Character(8) | VARCHAR2(8) NOT NULL |
Tax Code
Default Value: TAX_HEADER_TBL.TAX_CD |
| 3 | 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. |
| 4 | VAT_EXPENSES_FLG | Character(1) | VARCHAR2(1) NOT NULL | Used for Expenses |
| 5 | VAT_GL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Used for GL |
| 6 | VAT_PRCHS_FLG | Character(1) | VARCHAR2(1) NOT NULL | Used for Purchases |
| 7 | VAT_SALES_FLG | Character(1) | VARCHAR2(1) NOT NULL | Used for Sales |