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 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
       ['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 NumberSTR15_RM_Customer_NumberString15
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 IDGBInteger0
7EFTBankType SearchEFT Bank TypeDDL_EFTBankTypeInteger0
8FRGNBANK SearchForeign BankCB_Foreign_BankBoolean0
9INACTIVE SearchInactiveCB_InactiveBoolean0
10BANKNAME SearchBank NameSTR30String30
11EFTBankAcct SearchEFT Bank AccountSTR34String34
12EFTBankBranch SearchEFT Bank BranchSTR15String15
13GIROPostType SearchGIRO Post TypeDDL_GIROPostTypeInteger0
14EFTBankCode SearchEFT Bank CodeSTR15String15
15EFTBankBranchCode SearchEFT Bank Branch CodeSTR5_GPAString5
16EFTBankCheckDigit SearchEFT Bank Check DigitSTR2_LBAString2
17BSROLLNO SearchBuilding Society Roll NoSTR30String30
18IntlBankAcctNum SearchInternational Bank Account NumberSTR34String34
19SWIFTADDR SearchSwift AddressSTR11String11
20CustVendCountryCode SearchCustomer/Vendor Country CodeCountry CodeString3
21DeliveryCountryCode SearchDelivery Country CodeCountry CodeString3
22BNKCTRCD SearchBank Country CodeCountry CodeString3
23CBANKCD SearchCentral Bank CodeCentral Bank CodeString8
24ADDRESS1 SearchAddress 1STR60String60
25ADDRESS2 SearchAddress 2STR60String60
26ADDRESS3 SearchAddress 3STR60String60
27ADDRESS4 SearchAddress 4STR60String60
28RegCode1 SearchRegulatory Code 1STR30String30
29RegCode2 SearchRegulatory Code 2STR30String30
30BankInfo7 SearchBank Info 7DDLInteger0
31EFTTransitRoutingNo SearchEFT Transit Routing NumberSTR10_LBNString10
32CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 MethodEFT_DDL_TransferMethodInteger0
34EFTAccountType SearchEFT Account TypeEFT_Account_Type_DDLInteger0
35EFTPrenoteDate SearchEFT Prenote DateDATEDate6
36EFTTerminationDate SearchEFT Termination DateDATEDate6
37DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

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

Leave a Reply

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