EDCVAT26 - vatDaybookITCCalculationTemp
Dynamics GP table EDCVAT26 (vatDaybookITCCalculationTemp) contains 12 columns including vatDbkModule_ID, DOCTYPE, DOCNUMBR....
SQL Query Builder
12 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 | ||
| CustomerVendor_ID | Customer/Vendor ID | String | 16 | ||
| Tax_Date | Tax Date | Date | 4 | ||
| DOCDATE | Document Date | Date | 4 | ||
| PSTGDATE | Posting Date | Date | 4 | ||
| 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 EDCVAT26. Click "Join" to add to your query.
vatDbkModule_ID
vatDbkCurr_ITC_Amt