VAT_ADDR_MSTR (VAT00300)

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

Display Name: VAT_ADDR_MSTR
Physical Name: VAT00300
Technical Name: VAT_ADDR_MSTR

Group Display Name: Intrastat
Group Technical Name: Intrastat

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ECRECTYPE	EC Record Type	Integer	INT4	4
2	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['VAT_ADDR_MSTR'].CUSTNMBR AS 'VAT_ADDR_MSTR-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM VAT00300 AS ['VAT_ADDR_MSTR'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['VAT_ADDR_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3	ADRSCODE	Address Code	String	STR15_Address_Code	15
4	TCC	Tax Commodity Code	String	STR30_VAT	30
5	CCode	Country Code	String	STR6_VAT	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['VAT_ADDR_MSTR'].CCode AS 'VAT_ADDR_MSTR-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM VAT00300 AS ['VAT_ADDR_MSTR'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['VAT_ADDR_MSTR'].CCode = ['VAT Country Code MSTR'].CCode
6	ECFLAG	EC Member Flag	Boolean	CB_EC_MEMBER	0
7	TXRGNNUM	Tax Registration Number	String	STR25	25
8	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['VAT_ADDR_MSTR'].NOTEINDX AS 'VAT_ADDR_MSTR-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM VAT00300 AS ['VAT_ADDR_MSTR'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['VAT_ADDR_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX