PM Address MSTR Extra (DE00200)

azurecurveProductsCashbook (1058)PurchasingPM Address MSTR Extra (DE00200)

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

Product: Cashbook (1058)
Series: Purchasing

Display Name: PM Address MSTR Extra
Physical Name: DE00200
Technical Name: 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
       ['PM Address MSTR Extra'].VENDORID AS 'PM Address MSTR Extra-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       DE00200 AS ['PM Address MSTR Extra']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['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

Click to show/hide Payment Entry Type


0	Check
1	Cash
2	Credit Card
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)PurchasingPM Address MSTR Extra (DE00200)

Leave a Reply

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