Location #14

General Ledger table in Microsoft Dynamics 365 Business Central. 63 fields, 8 records in Cronus demo.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Code.

All fields (63)

Location — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Code PK	Code	Normal
2	Name	Text	Normal
130	Default Bin Code	Code	Normal	→ Bin #7354
5700	Name 2	Text	Normal
5701	Address	Text	Normal
5702	Address 2	Text	Normal
5703	City	Text	Normal
5704	Phone No.	Text	Normal
5705	Phone No. 2	Text	Normal
5706	Telex No.	Text	Normal
5707	Fax No.	Text	Normal
5713	Contact	Text	Normal
5714	Post Code	Code	Normal
5715	County	Text	Normal
5718	Email	Text	Normal
5719	Home Page	Text	Normal
5720	Country/Region Code	Code	Normal	→ Country/Region #9
5724	Use As In-Transit	Boolean	Normal
5726	Require Put-away	Boolean	Normal
5727	Require Pick	Boolean	Normal
5728	Cross-Dock Due Date Calc.	DateFormula	Normal
5729	Use Cross-Docking	Boolean	Normal
5730	Require Receive	Boolean	Normal
5731	Require Shipment	Boolean	Normal
5732	Bin Mandatory	Boolean	Normal
5733	Directed Put-away and Pick	Boolean	Normal
5734	Default Bin Selection	Option	Normal
5790	Outbound Whse. Handling Time	DateFormula	Normal
5791	Inbound Whse. Handling Time	DateFormula	Normal
6100	Transfer Doc. Sending Profile	Code	Normal	→ Document Sending Profile #60
7305	Put-away Template Code	Code	Normal	→ Put-away Template Header #7307
7306	Use Put-away Worksheet	Boolean	Normal
7307	Pick According to FEFO	Boolean	Normal
7308	Allow Breakbulk	Boolean	Normal
7309	Bin Capacity Policy	Option	Normal
7310	Pick Bin Policy	Option	Normal
7311	Check Warehouse Class	Boolean	Normal
7312	Put-away Bin Policy	Option	Normal
7313	Open Shop Floor Bin Code	Code	Normal	→ Bin #7354
7314	To-Production Bin Code	Code	Normal	→ Bin #7354
7315	From-Production Bin Code	Code	Normal	→ Bin #7354
7316	Prod. Consump. Whse. Handling	Option	Normal
7317	Adjustment Bin Code	Code	Normal	→ Bin #7354
7318	Prod. Output Whse. Handling	Option	Normal
7319	Always Create Put-away Line	Boolean	Normal
7320	Always Create Pick Line	Boolean	Normal
7321	Special Equipment	Option	Normal
7323	Receipt Bin Code	Code	Normal	→ Bin #7354
7325	Shipment Bin Code	Code	Normal	→ Bin #7354
7326	Cross-Dock Bin Code	Code	Normal	→ Bin #7354
7330	To-Assembly Bin Code	Code	Normal	→ Bin #7354
7331	From-Assembly Bin Code	Code	Normal	→ Bin #7354
7332	Asm.-to-Order Shpt. Bin Code	Code	Normal	→ Bin #7354
7333	To-Project Bin Code	Code	Normal	→ Bin #7354
7334	Asm. Consump. Whse. Handling	Option	Normal
7335	Project Consump. Whse. Handling	Option	Normal
7600	Base Calendar Code	Code	Normal	→ Base Calendar #7600
7700	Use ADCS	Boolean	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (6)

Tables referenced by fields on the Location table through TableRelation properties.

Bin

#7354 · Warehouse · via Default Bin Code, Open Shop Floor Bin Code, To-Production Bin Code, From-Production Bin Code, Adjustment Bin Code, Receipt Bin Code, Shipment Bin Code, Cross-Dock Bin Code, To-Assembly Bin Code, From-Assembly Bin Code, Asm.-to-Order Shpt. Bin Code, To-Project Bin Code

Country/Region

#9 · General Ledger · via Country/Region Code

Document Sending Profile

#60 · Other · via Transfer Doc. Sending Profile

Put-away Template Header

#7307 · Warehouse · via Put-away Template Code

Base Calendar

#7600 · Other · via Base Calendar Code