ENTRY_VAT_TBL(SQL Table) |
Index Back |
---|---|
Child table of Entry Use Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ENTRY_USE_ID | Character(5) | VARCHAR2(5) NOT NULL | Specifies the System Function or type of processing associated with an entry type. |
2 | VAT_DCLRTN_POINT | Character(1) | VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date D=At Delivery Time I=At Invoice Time P=At Payment Time |
3 | VAT_AFFECT | Character(1) | VARCHAR2(1) NOT NULL |
Effect on VAT Processing
A=Adjust Intermediate VAT Liab I=Include in Item Entry Totals N=None P=Move Intermediate VAT to Final |
4 | 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 |