Address Electronic Funds Transfer Master (SY06000)

azurecurveProductsMicrosoft Dynamics GP (0)CompanyAddress Electronic Funds Transfer Master (SY06000)

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

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: Address Electronic Funds Transfer Master
Physical Name: SY06000
Technical Name: AddressEFT

Group Display Name: Electronic Funds Transfer
Group Technical Name: Electronic Funds Transfer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SERIES SearchSeriesIntegerDDL_Series0
2CustomerVendor_ID SearchCustomer/Vendor IDStringSTR1515
3ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
4VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

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

Click to show/hide

SELECT
       ['Address Electronic Funds Transfer Master'].CUSTNMBR AS 'Address Electronic Funds Transfer Master-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SY06000 AS ['Address Electronic Funds Transfer Master']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Address Electronic Funds Transfer Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
6EFTUseMasterID SearchEFT Use Master IDIntegerGB0
7EFTBankType SearchEFT Bank TypeIntegerDDL_EFTBankType0
8FRGNBANK SearchForeign BankBooleanCB_Foreign_Bank0
9INACTIVE SearchInactiveBooleanCB_Inactive0
10BANKNAME SearchBank NameStringSTR3030
11EFTBankAcct SearchEFT Bank AccountStringSTR3434
12EFTBankBranch SearchEFT Bank BranchStringSTR1515
13GIROPostType SearchGIRO Post TypeIntegerDDL_GIROPostType0
14EFTBankCode SearchEFT Bank CodeStringSTR1515
15EFTBankBranchCode SearchEFT Bank Branch CodeStringSTR5_GPA5
16EFTBankCheckDigit SearchEFT Bank Check DigitStringSTR2_LBA2
17BSROLLNO SearchBuilding Society Roll NoStringSTR3030
18IntlBankAcctNum SearchInternational Bank Account NumberStringSTR3434
19SWIFTADDR SearchSwift AddressStringSTR1111
20CustVendCountryCode SearchCustomer/Vendor Country CodeStringCountry Code3
21DeliveryCountryCode SearchDelivery Country CodeStringCountry Code3
22BNKCTRCD SearchBank Country CodeStringCountry Code3
23CBANKCD SearchCentral Bank CodeStringCentral Bank Code8
24ADDRESS1 SearchAddress 1StringSTR6060
25ADDRESS2 SearchAddress 2StringSTR6060
26ADDRESS3 SearchAddress 3StringSTR6060
27ADDRESS4 SearchAddress 4StringSTR6060
28RegCode1 SearchRegulatory Code 1StringSTR3030
29RegCode2 SearchRegulatory Code 2StringSTR3030
30BankInfo7 SearchBank Info 7IntegerDDL0
31EFTTransitRoutingNo SearchEFT Transit Routing NumberStringSTR10_LBN10
32CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Address Electronic Funds Transfer Master'].CURNCYID AS 'Address Electronic Funds Transfer Master-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       SY06000 AS ['Address Electronic Funds Transfer Master']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Address Electronic Funds Transfer Master'].CURNCYID = ['Currency Setup'].CURNCYID
33EFTTransferMethod SearchEFT Transfer MethodIntegerEFT_DDL_TransferMethod0
34EFTAccountType SearchEFT Account TypeIntegerEFT_Account_Type_DDL0
35EFTPrenoteDate SearchEFT Prenote DateDateDATE6
36EFTTerminationDate SearchEFT Termination DateDateDATE6
azurecurveProductsMicrosoft Dynamics GP (0)CompanyAddress Electronic Funds Transfer Master (SY06000)

Leave a Reply

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