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 |