EDCVAT25 - vatDaybookITCCalculation
Dynamics GP table EDCVAT25 (vatDaybookITCCalculation) contains 8 columns including vatDbkModule_ID, DOCTYPE, DOCNUMBR....
SQL Query Builder
8 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| vatDbkModule_ID | vatDbkModule_ID | String | 8 | ||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| DOCNUMBR | Document Number | String | 22 | ||
| vatDbkCurr_ITC_Amt | vatDbkCurr_ ITC_ Amt | Currency | 10 | ||
| vatDbkITCClaimRate | vatDbkITCClaimRate | Currency | 10 | ||
| vatDbkVaried_ITC_Amt | vatDbkVaried_ITC_Amt | Currency | 10 | ||
| TAXDTLID | Tax Detail ID | String | 16 | ||
| VOIDSTTS | Void Status0 = Document has not been voided.1 = Document has been voided.2 = Document has been marked NSF and voided. | Integer | 2 | ||
Void Status values (2) 0 = Normal1 = Voided | |||||
Related Tables
Tables that share columns with EDCVAT25. Click "Join" to add to your query.
vatDbkModule_ID
vatDbkCurr_ITC_Amt
vatDbkITCClaimRate
vatDbkVaried_ITC_Amt