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 Group Display Name: Electronic Funds Transfer
Physical Name: SY06000
Technical Name: AddressEFT
Group Technical Name: Electronic Funds Transfer
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | SERIES ![]() | Series | DDL_Series | Integer | 0 | |
2 | CustomerVendor_ID ![]() | Customer/Vendor ID | STR15 | String | 15 | |
3 | ADRSCODE ![]() | Address Code | STR15_Address_Code | String | 15 | |
4 | VENDORID ![]() | Vendor ID | STR_15_Vendor_ID | String | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['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 | ||||||
5 | CUSTNMBR ![]() | Customer Number | STR15_RM_Customer_Number | String | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['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 | ||||||
6 | EFTUseMasterID ![]() | EFT Use Master ID | GB | Integer | 0 | |
7 | EFTBankType ![]() | EFT Bank Type | DDL_EFTBankType | Integer | 0 | |
8 | FRGNBANK ![]() | Foreign Bank | CB_Foreign_Bank | Boolean | 0 | |
9 | INACTIVE ![]() | Inactive | CB_Inactive | Boolean | 0 | |
10 | BANKNAME ![]() | Bank Name | STR30 | String | 30 | |
11 | EFTBankAcct ![]() | EFT Bank Account | STR34 | String | 34 | |
12 | EFTBankBranch ![]() | EFT Bank Branch | STR15 | String | 15 | |
13 | GIROPostType ![]() | GIRO Post Type | DDL_GIROPostType | Integer | 0 | |
14 | EFTBankCode ![]() | EFT Bank Code | STR15 | String | 15 | |
15 | EFTBankBranchCode ![]() | EFT Bank Branch Code | STR5_GPA | String | 5 | |
16 | EFTBankCheckDigit ![]() | EFT Bank Check Digit | STR2_LBA | String | 2 | |
17 | BSROLLNO ![]() | Building Society Roll No | STR30 | String | 30 | |
18 | IntlBankAcctNum ![]() | International Bank Account Number | STR34 | String | 34 | |
19 | SWIFTADDR ![]() | Swift Address | STR11 | String | 11 | |
20 | CustVendCountryCode ![]() | Customer/Vendor Country Code | Country Code | String | 3 | |
21 | DeliveryCountryCode ![]() | Delivery Country Code | Country Code | String | 3 | |
22 | BNKCTRCD ![]() | Bank Country Code | Country Code | String | 3 | |
23 | CBANKCD ![]() | Central Bank Code | Central Bank Code | String | 8 | |
24 | ADDRESS1 ![]() | Address 1 | STR60 | String | 60 | |
25 | ADDRESS2 ![]() | Address 2 | STR60 | String | 60 | |
26 | ADDRESS3 ![]() | Address 3 | STR60 | String | 60 | |
27 | ADDRESS4 ![]() | Address 4 | STR60 | String | 60 | |
28 | RegCode1 ![]() | Regulatory Code 1 | STR30 | String | 30 | |
29 | RegCode2 ![]() | Regulatory Code 2 | STR30 | String | 30 | |
30 | BankInfo7 ![]() | Bank Info 7 | DDL | Integer | 0 | |
31 | EFTTransitRoutingNo ![]() | EFT Transit Routing Number | STR10_LBN | String | 10 | |
32 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
33 | EFTTransferMethod ![]() | EFT Transfer Method | EFT_DDL_TransferMethod | Integer | 0 | |
34 | EFTAccountType ![]() | EFT Account Type | EFT_Account_Type_DDL | Integer | 0 | |
35 | EFTPrenoteDate ![]() | EFT Prenote Date | DATE | Date | 6 | |
36 | EFTTerminationDate ![]() | EFT Termination Date | DATE | Date | 6 | |
37 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |