NC_Detail_MSTR_Extra_OLD (NCVAT001)

azurecurveProductsAdvanced VAT (2474)FinancialNC_Detail_MSTR_Extra_OLD (NCVAT001)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVAT001

Product: Advanced VAT (2474)
Series: Financial

Display Name: NC_Detail_MSTR_Extra_8002a
Physical Name: NCVAT001
Technical Name: NC_Detail_MSTR_Extra_8002a

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['NC_Detail_MSTR_Extra_8002a'].TAXDTLID AS 'NC_Detail_MSTR_Extra_8002a-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       NCVAT001 AS ['NC_Detail_MSTR_Extra_8002a']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['NC_Detail_MSTR_Extra_8002a'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
2NC_VAT_Treatment SearchNC VAT TreatmentNC_VAT_TreatmentInteger0
3NC_Recoverable_Rate SearchNC Recoverable RateNC RecoverableCurrency8
4NC_Destination_Tax_Detai SearchNC Destination Tax Detail IDSTR15_Tax_Detail_IDString15
5NC_Memo_Account_Index SearchNC Memo Account IndexLI_14Long Integer14
6NC_VAT_Calc_Type SearchNC VAT Calc TypeNC VAT Calc TypeInteger0
7NC_VAT_100_Option SearchNC VAT 100 OptionGBInteger0
8NC_VAT_Allocation SearchNC VAT AllocationNC VAT Calc TypeInteger0
9NC_VAT_Accrual_Account_I SearchNC VAT Accrual Account IndexLI_14Long Integer14
10NC_Expense_Offset_Acc_St SearchNC Expense Offset Acc StringSTR130String130
11NC_Non_Rec_Acc_String SearchNC Non Rec Acc StringSTR130String130
12NC_Change_Reason_Require SearchNC Change Reason RequiredNC Change Reason RequiredBoolean0
13NC_Reverse_Charge_Tax_De SearchNC Reverse Charge Tax Detail IDSTR15_Tax_Detail_IDString15
azurecurveProductsAdvanced VAT (2474)FinancialNC_Detail_MSTR_Extra_OLD (NCVAT001)

Leave a Reply

Your email address will not be published. Required fields are marked *