VAT: AccountView VAT codes
read only per partition
- Catalog:
AccountView - Label: VAT codes
Can only retrieve data.
Table Columns
The columns of the table VAT are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCT_ |
varchar2 |
Reverse-charge VAT account number | |||
CALC_ |
char |
Calculate VAT on VAT | |||
CALC_ |
decimal |
VAT calculation method | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
COGS_ |
char |
Add VAT to cost price | |||
FRM_ |
varchar2 |
Category code | |||
FRM_ |
varchar2 |
Linked reverse-charge VAT section | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
IS_ABC |
char |
ABC transaction | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
VAT_ |
varchar2 |
Account number | |||
VAT_ |
varchar2 |
VAT Code | |||
VAT_ |
varchar2 |
Linked code | |||
VAT_ |
varchar2 |
VAT code description | |||
VAT_ |
decimal |
VAT percentage | |||
VAT_ |
decimal |
VAT type (numeric) |