NC_VATImport_LINE_REJT (NCVIM301)

azurecurveProductsAdvanced VAT (2474)FinancialNC_VATImport_LINE_REJT (NCVIM301)

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

Product: Advanced VAT (2474)
Series: Financial

Display Name: NC_VATImport_LINE_REJT
Physical Name: NCVIM301
Technical Name: NC_VATImport_LINE_REJT

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1NC_Reference_ID SearchNC Reference IDSTR50String50
2NC_Reference_Line SearchNC Reference LineDLR19_$S2Currency19
3JRNENTRY SearchJournal EntryLI8_U0Long Integer8
4ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String6
5ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String6
6ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String6
7ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String6
8ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String6
9ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String6
10ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String6
11ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String6
12ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String6
13ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String6
14ACTNUMST SearchAccount Number StringSTR128_LBUString128
15DSCRIPTN SearchDescriptionSTR30String30
16DEBITAMT SearchDebit AmountDLR19_$S2Currency19
17CRDTAMNT SearchCredit AmountDLR19_$S2Currency19
18TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['NC_VATImport_LINE_REJT'].TAXDTLID AS 'NC_VATImport_LINE_REJT-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       NCVIM301 AS ['NC_VATImport_LINE_REJT']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['NC_VATImport_LINE_REJT'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
19TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
20NC_Default_Taxes SearchNC Default TaxesBooleanBoolean0
azurecurveProductsAdvanced VAT (2474)FinancialNC_VATImport_LINE_REJT (NCVIM301)

Leave a Reply

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