Euro Address Electronic Funds Transfer Master (CBEU1188)

azurecurveProductsCashbook (1058)CompanyEuro Address Electronic Funds Transfer Master (CBEU1188)

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

Product: Cashbook (1058)
Series: Company

Display Name: Euro Address Electronic Funds Transfer Master
Physical Name: CBEU1188
Technical Name: CB_Euro_AddressEFT

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SERIES SearchSeriesDDL_SeriesInteger0
2CustomerVendor_ID SearchCustomer/Vendor IDSTR15String15
3ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
4VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Euro Address Electronic Funds Transfer Master'].VENDORID AS 'Euro Address Electronic Funds Transfer Master-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       CBEU1188 AS ['Euro Address Electronic Funds Transfer Master']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Euro Address Electronic Funds Transfer Master'].VENDORID = ['PM Vendor Master File'].VENDORID
5CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Euro Address Electronic Funds Transfer Master'].CUSTNMBR AS 'Euro Address Electronic Funds Transfer Master-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       CBEU1188 AS ['Euro Address Electronic Funds Transfer Master']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Euro Address Electronic Funds Transfer Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
6EFTBankType SearchEFT Bank TypeDDL_EFTBankTypeInteger0
7FRGNBANK SearchForeign BankCB_Foreign_BankBoolean0
8INACTIVE SearchInactiveCB_InactiveBoolean0
9BANKNAME SearchBank NameSTR30String30
10EFTBankAcct SearchEFT Bank AccountSTR34String34
11EFTBankBranch SearchEFT Bank BranchSTR15String15
12GIROPostType SearchGIRO Post TypeDDL_GIROPostTypeInteger0
13EFTBankCode SearchEFT Bank CodeSTR15String15
14EFTBankBranchCode SearchEFT Bank Branch CodeSTR5_GPAString5
15EFTBankCheckDigit SearchEFT Bank Check DigitSTR2_LBAString2
16IntlBankAcctNum SearchInternational Bank Account NumberSTR34String34
17SWIFTADDR SearchSwift AddressSTR11String11
18CustVendCountryCode SearchCustomer/Vendor Country CodeCountry CodeString3
19DeliveryCountryCode SearchDelivery Country CodeCountry CodeString3
20BNKCTRCD SearchBank Country CodeCountry CodeString3
21CBANKCD SearchCentral Bank CodeCentral Bank CodeString8
22ADDRESS1 SearchAddress 1STR60String60
23ADDRESS2 SearchAddress 2STR60String60
24ADDRESS3 SearchAddress 3STR60String60
25ADDRESS4 SearchAddress 4STR60String60
26RegCode1 SearchRegulatory Code 1STR30String30
27RegCode2 SearchRegulatory Code 2STR30String30
28BankInfo7 SearchBank Info 7DDLInteger0
azurecurveProductsCashbook (1058)CompanyEuro Address Electronic Funds Transfer Master (CBEU1188)

Leave a Reply

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