NC_POP_Line (NCVAT121)

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

Product: Advanced VAT (2474)
Series: Purchasing

Display Name: NC_POP_Line_BETA
Physical Name: NCVAT121
Technical Name: NC_POP_Line_BETA

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1NC_POP_Doc_Type SearchNC POP Doc TypeINTInteger0
2POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString17
3RCPTLNNM SearchReceipt Line NumberLI_Sequence_NumberLong Integer10
4TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['NC_POP_Line_BETA'].TAXDTLID AS 'NC_POP_Line_BETA-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       NCVAT121 AS ['NC_POP_Line_BETA']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['NC_POP_Line_BETA'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
5TRXAMNT SearchTRX AmountDLR19_$S2Currency19
6Originating_TRX_Amount SearchOriginating TRX AmountDLR17_RBSO_UTR$Currency17
7TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
8ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
9NC_Change_Code SearchNC Change CodeSTR20String20
10NC_VAT_Treatment SearchNC VAT TreatmentNC_VAT_TreatmentInteger0
11NC_Transaction_Status SearchNC Transaction StatusINTInteger0
12NC_Recoverable_Rate SearchNC Recoverable RateNC RecoverableCurrency8
13NC_Tax_Base_Amount SearchNC Tax Base AmountDLR19_RBSO_UTR$Currency19
14NC_Originating_Tax_Base_ SearchNC Originating Tax Base AmountDLR19_RBSO_UTR$Currency19
15NC_Rec_Tax_Amount SearchNC Rec Tax AmountDLR19_RBSO_UTR$Currency19
16NC_Originating_Rec_Tax_A SearchNC Originating Rec Tax AmountDLR19_RBSO_UTR$Currency19
17NC_Unit_TRX_Amount SearchNC Unit TRX AmountDLR19_RBSO_UTR$Currency19
18NC_Originating_Unit_TRX_ SearchNC Originating Unit TRX AmountDLR19_RBSO_UTR$Currency19
19NC_Capital_Item_Message_ SearchNC Capital Item Message GivenbooleanBoolean0
20DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency17
21ODISAMTAV SearchOriginating Discount Amount AvailableDLR17_RBS0_UTR$Currency17

Leave a Reply

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