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 | SQL DB Length | Keyable Length |
|---|---|---|---|---|---|---|
| 1 | SERIES  | Series | DDL_Series | Integer | 2 | 0 |
| 2 | CustomerVendor_ID | Customer/Vendor ID | STR15 | String | 16 | 15 |
| 3 | ADRSCODE | Address Code | STR15_Address_Code | String | 16 | 15 |
| 4 | VENDORID | Vendor ID | STR_15_Vendor_ID | String | 16 | 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 | 16 | 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 | 2 | 0 |
| 7 | EFTBankType | EFT Bank Type | DDL_EFTBankType | Integer | 2 | 0 |
| 8 | FRGNBANK | Foreign Bank | CB_Foreign_Bank | Boolean | 2 | 0 |
| 9 | INACTIVE | Inactive | CB_Inactive | Boolean | 2 | 0 |
| 10 | BANKNAME | Bank Name | STR30 | String | 32 | 30 |
| 11 | EFTBankAcct | EFT Bank Account | STR34 | String | 36 | 34 |
| 12 | EFTBankBranch | EFT Bank Branch | STR15 | String | 16 | 15 |
| 13 | GIROPostType | GIRO Post Type | DDL_GIROPostType | Integer | 2 | 0 |
| 14 | EFTBankCode | EFT Bank Code | STR15 | String | 16 | 15 |
| 15 | EFTBankBranchCode | EFT Bank Branch Code | STR5_GPA | String | 6 | 5 |
| 16 | EFTBankCheckDigit | EFT Bank Check Digit | STR2_LBA | String | 4 | 2 |
| 17 | BSROLLNO | Building Society Roll No | STR30 | String | 32 | 30 |
| 18 | IntlBankAcctNum | International Bank Account Number | STR34 | String | 36 | 34 |
| 19 | SWIFTADDR | Swift Address | STR11 | String | 12 | 11 |
| 20 | CustVendCountryCode | Customer/Vendor Country Code | Country Code | String | 4 | 3 |
| 21 | DeliveryCountryCode | Delivery Country Code | Country Code | String | 4 | 3 |
| 22 | BNKCTRCD | Bank Country Code | Country Code | String | 4 | 3 |
| 23 | CBANKCD | Central Bank Code | Central Bank Code | String | 10 | 8 |
| 24 | ADDRESS1 | Address 1 | STR60 | String | 62 | 60 |
| 25 | ADDRESS2 | Address 2 | STR60 | String | 62 | 60 |
| 26 | ADDRESS3 | Address 3 | STR60 | String | 62 | 60 |
| 27 | ADDRESS4 | Address 4 | STR60 | String | 62 | 60 |
| 28 | RegCode1 | Regulatory Code 1 | STR30 | String | 32 | 30 |
| 29 | RegCode2 | Regulatory Code 2 | STR30 | String | 32 | 30 |
| 30 | BankInfo7 | Bank Info 7 | DDL | Integer | 2 | 0 |
| 31 | EFTTransitRoutingNo | EFT Transit Routing Number | STR10_LBN | String | 12 | 10 |
| 32 | CURNCYID | Currency ID | STR15_Currency_ID | String | 16 | 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 | 2 | 0 |
| 34 | EFTAccountType | EFT Account Type | EFT_Account_Type_DDL | Integer | 2 | 0 |
| 35 | EFTPrenoteDate | EFT Prenote Date | DATE | Date | 4 | 6 |
| 36 | EFTTerminationDate | EFT Termination Date | DATE | Date | 4 | 6 |
| 37 | DEX_ROW_ID | int | int | 10 | 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. | ||||||