RM Customer Intrastat MSTR (VAT10101)

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

Display Name: RM Customer Intrastat MSTR
Physical Name: VAT10101
Technical Name: RM_Customer_Intrastat_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['RM Customer Intrastat MSTR'].CUSTNMBR AS 'RM Customer Intrastat MSTR-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM VAT10101 AS ['RM Customer Intrastat MSTR'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['RM Customer Intrastat MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	ADRSCODE	Address Code	String	STR15_Address_Code	15
3	TXRGNNUM	Tax Registration Number	String	STR25	25
4	CCode	Country Code	String	STR6_VAT	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['RM Customer Intrastat MSTR'].CCode AS 'RM Customer Intrastat MSTR-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM VAT10101 AS ['RM Customer Intrastat MSTR'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['RM Customer Intrastat MSTR'].CCode = ['VAT Country Code MSTR'].CCode
5	TMCODE	Transport Mode Code	String	STR6_VAT	6
6	TRANSNATURE	Transaction Nature	String	STR6_VAT	6
7	TCC	Tax Commodity Code	String	STR30_VAT	30
8	PRT	Port	String	STR6_VAT	6
9	RGN	Region	String	STR6_VAT	6
10	PRCDRRGM	Procedure/Regime	String	STR6_VAT	6
11	INCTRMS	Incoterms	String	STR6_VAT	6