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 TypeSQL DB LengthKeyable Length
1SERIES SearchSeriesDDL_SeriesInteger20
2CustomerVendor_ID SearchCustomer/Vendor IDSTR15String1615
3ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
4VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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_NumberString1615
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 IDGBInteger20
7EFTBankType SearchEFT Bank TypeDDL_EFTBankTypeInteger20
8FRGNBANK SearchForeign BankCB_Foreign_BankBoolean20
9INACTIVE SearchInactiveCB_InactiveBoolean20
10BANKNAME SearchBank NameSTR30String3230
11EFTBankAcct SearchEFT Bank AccountSTR34String3634
12EFTBankBranch SearchEFT Bank BranchSTR15String1615
13GIROPostType SearchGIRO Post TypeDDL_GIROPostTypeInteger20
14EFTBankCode SearchEFT Bank CodeSTR15String1615
15EFTBankBranchCode SearchEFT Bank Branch CodeSTR5_GPAString65
16EFTBankCheckDigit SearchEFT Bank Check DigitSTR2_LBAString42
17BSROLLNO SearchBuilding Society Roll NoSTR30String3230
18IntlBankAcctNum SearchInternational Bank Account NumberSTR34String3634
19SWIFTADDR SearchSwift AddressSTR11String1211
20CustVendCountryCode SearchCustomer/Vendor Country CodeCountry CodeString43
21DeliveryCountryCode SearchDelivery Country CodeCountry CodeString43
22BNKCTRCD SearchBank Country CodeCountry CodeString43
23CBANKCD SearchCentral Bank CodeCentral Bank CodeString108
24ADDRESS1 SearchAddress 1STR60String6260
25ADDRESS2 SearchAddress 2STR60String6260
26ADDRESS3 SearchAddress 3STR60String6260
27ADDRESS4 SearchAddress 4STR60String6260
28RegCode1 SearchRegulatory Code 1STR30String3230
29RegCode2 SearchRegulatory Code 2STR30String3230
30BankInfo7 SearchBank Info 7DDLInteger20
31EFTTransitRoutingNo SearchEFT Transit Routing NumberSTR10_LBNString1210
32CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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_TransferMethodInteger20
34EFTAccountType SearchEFT Account TypeEFT_Account_Type_DDLInteger20
35EFTPrenoteDate SearchEFT Prenote DateDATEDate46
36EFTTerminationDate SearchEFT Termination DateDATEDate46
37DEX_ROW_ID Searchintint1010

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 *