Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/POT10302
Product: WennSoft Products (131)
Series: Company
Display Name: PO_VAT_INTRA_WORK
Physical Name: POT10302
Technical Name: PO_VAT_INTRA_WORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 SERIES 
Series DDL_Series Integer 0 2 DOCTYPE Document Type DDL_Document_Type Integer 0 3 DOCNUMBR Document Number STR20_Document_Number String 20 4 SQNCLINE Sequence Line DLR19_$S2 Currency 19 5 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['PO_VAT_INTRA_WORK'].CUSTNMBR AS 'PO_VAT_INTRA_WORK-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
POT10302 AS ['PO_VAT_INTRA_WORK']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PO_VAT_INTRA_WORK'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR6 CCode Country Code STR6_VAT String 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['PO_VAT_INTRA_WORK'].CCode AS 'PO_VAT_INTRA_WORK-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
POT10302 AS ['PO_VAT_INTRA_WORK']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['PO_VAT_INTRA_WORK'].CCode = ['VAT Country Code MSTR'].CCode7 TXRGNNUM Tax Registration Number STR25 String 25 8 TCC Tax Commodity Code STR30_VAT String 30 9 NUMASS Net Unit Mass DLR17_QTY_RBS0_UTR Currency 17 10 QUANTITY QTY DLR17_QTY_RBS0_STR Currency 17 11 LMASS Line Mass DLR17_QTY_RBS0_UTR Currency 17 12 TMCODE Transport Mode Code STR6_VAT String 6 13 TRANSNATURE Transaction Nature STR6_VAT String 6 14 VALBASISCODE Value Basis Code STR6_VAT String 6 15 PROTYPECODE Process Type Code STR6_VAT String 6 16 SUPPUNITS Supplementary Units DLR17_QTY_RBS0_UTR Currency 17 17 TRADREF Traders Reference STR20 String 20 18 GOODSVALUE Goods Value DLR19_RBS0_UTR$ Currency 19 19 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 20 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['PO_VAT_INTRA_WORK'].NOTEINDX AS 'PO_VAT_INTRA_WORK-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
POT10302 AS ['PO_VAT_INTRA_WORK']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PO_VAT_INTRA_WORK'].NOTEINDX = ['Record Notes Master'].NOTEINDX21 DOCDATE Document Date DT Date 8 22 POSTED Posted True/False Boolean 0 23 VOIDSTTS Void Status INT Integer 0 24 RECNUM Receivings_Number_STR STR17_LBAU String 17 25 ORGDSVAL Originating Goods Value DLR19_RBSO_UTR$ Currency 19 26 ORTAXAMT Originating Tax Amount DLR17_RBS0_UTR$ Currency 17 27 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PO_VAT_INTRA_WORK'].CURRNIDX AS 'PO_VAT_INTRA_WORK-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
POT10302 AS ['PO_VAT_INTRA_WORK']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PO_VAT_INTRA_WORK'].CURRNIDX = ['Currency Setup'].CURRNIDX