Site Setup (IV40700)

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

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Site Setup
Physical Name: IV40700
Technical Name: IV_Location_SETP

Group Display Name: Inventory Site Setup
Group Technical Name: Inventory Site Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
2LOCNDSCR SearchLocation DescriptionStringSTR3030
3NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Site Setup'].NOTEINDX AS 'Site Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       IV40700 AS ['Site Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Site Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
4ADDRESS1 SearchAddress 1StringSTR6060
5ADDRESS2 SearchAddress 2StringSTR6060
6ADDRESS3 SearchAddress 3StringSTR6060
7CITY SearchCityStringSTR3535
8STATE SearchStateStringSTR30_State29
9ZIPCODE SearchZip CodeStringSTR1010
10COUNTRY SearchCountryStringSTR6060
11PHONE1 SearchPhone 1StringPhone_Number14
12PHONE2 SearchPhone 2StringPhone_Number14
13PHONE3 SearchPhone 3StringPhone_Number314
14FAXNUMBR SearchFax NumberStringSTR14_FAX14
15Location_Segment SearchLocation SegmentStringSTR66_Site_SEG66
16STAXSCHD SearchSales Tax ScheduleStringSTR15_LBAU15
17PCTAXSCH SearchPurchases Tax ScheduleStringSTR15_LBAU15
18INCLDDINPLNNNG SearchIncluded in PlanningBooleanCB0
19PORECEIPTBIN SearchPurchase Receipt BinStringSTR15_Bin15
20PORETRNBIN SearchPurchase Returns BinStringSTR15_Bin15
21SOFULFILLMENTBIN SearchSO Fulfillment BinStringSTR15_Bin15
22SORETURNBIN SearchSO Return BinStringSTR15_Bin15
23BOMRCPTBIN SearchBOM Receipt BinStringSTR15_Bin15
24MATERIALISSUEBIN SearchMaterial Issues BinStringSTR15_Bin15
25MORECEIPTBIN SearchMO Receipt BinStringSTR15_Bin15
26REPAIRISSUESBIN SearchRepair Issues BinStringSTR15_Bin15
27WMSINT SearchWMS IntegrationBooleanCB0
28PICKTICKETSITEOPT SearchPicking Ticket Site OptionIntegerDDL_PickingTicketSiteOption0
29BINBREAK SearchBin BreakIntegerDDL_Bin_Break0
30CCode SearchCountry CodeStringSTR6_VAT6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Site Setup'].CCode AS 'Site Setup-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       IV40700 AS ['Site Setup']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Site Setup'].CCode = ['VAT Country Code MSTR'].CCode
31DECLID SearchDeclarant IDStringSTR15_Address_Code15
32INACTIVE SearchInactiveBooleanCB_Inactive0

Leave a Reply

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