Euro PM Address MSTR Extra (CBEU1029)

azurecurveProductsCashbook (1058)FinancialEuro PM Address MSTR Extra (CBEU1029)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Euro PM Address MSTR Extra
Physical Name: CBEU1029
Technical Name: CB_Euro_PM_Vendor_Address_Extra

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Euro PM Address MSTR Extra'].VENDORID AS 'Euro PM Address MSTR Extra-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       CBEU1029 AS ['Euro PM Address MSTR Extra']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Euro PM Address MSTR Extra'].VENDORID = ['PM Vendor Master File'].VENDORID
2ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
3Cell_Phone SearchCell PhonePhone_NumberString2214
4BNKACTNM SearchBank Account NumberSTR15String1615
5BANKNAME SearchBank NameSTR30String3230
6BANKID SearchBank IDSTR15_Bank_IDString1615
7SWIFTADDR1 SearchSwift Address1STR111String1211
8FRGNBANK SearchForeign BankCB_Foreign_BankBoolean20
9Electronic SearchElectronicCB_ElectronicBoolean20
10PYENTTYP SearchPayment Entry TypeGBInteger20
11ADDRESS1 SearchAddress 1STR60String6260
12ADDRESS2 SearchAddress 2STR60String6260
13ADDRESS3 SearchAddress 3STR60String6260
14ADDRESS4 SearchAddress 4STR60String6260
15VNDCTRCD SearchVendor Country CodeCountry CodeString43
16BNKCTRCD SearchBank Country CodeCountry CodeString43
17VNDDELCC SearchVendor Delivery Country CodeCountry CodeString43
azurecurveProductsCashbook (1058)FinancialEuro PM Address MSTR Extra (CBEU1029)

Leave a Reply

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