Table GSTDTL
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| GSTDTL | GDL | GST detail | Financials | KAU |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| GDL0 | RPTNUM | Yes | |
| GDL1 | NUM+BPR+VAT+SNS | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCDAT | Accounting date | D | ||||||
| AMTATI | Amount + tax | MD1 | ||||||
| AMTVAT | Declared amount | MD1 | ||||||
| AUS1AGSTSAL | 1A GST on sales | A | 5 | |||||
| AUS1BGSTPUR | 1B GST on purchases | A | 5 | |||||
| AUSBAS | A | 5 | ||||||
| AUSG10CAPPUR | G10 capital purchase | A | 5 | |||||
| AUSG11NCAPPU | G11 non capital pur | A | 5 | |||||
| AUSG1TOTSA | G1 total sales | A | 5 | |||||
| AUSG2EXPSAL | G2 export sales | A | 5 | |||||
| AUSG3GSTFRES | G3 GST free sales | A | 5 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BPR | BP | BPR | [BPR]BPR0=[GDL]BPR | Other | ||||
| CPY | Company | CPY | [CPY]CPY0=[GDL]CPY | Other | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[GDL]CREUSR | Other | ||||
| FCY | Site | FCY | [FCY]FCY0=[GDL]FCY | Other | ||||
| INVTYP | Invoice category | M | 15 | 645 | ||||
| LIN | Invoice line | L | 8 | |||||
| NETPRINOT | Net price - tax | MD8 | ||||||
| NUM | Invoice no. | VCR | ||||||
| RPTNUM | Report | A | 20 | |||||
| SNS | Sign | C | 2 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[GDL]UPDUSR | Other | ||||
| VAT | Tax | VAT | [TVT]TVT0=VAT(indice);[V]GSUPCLE | Other |