Share via

Location Table

  • Article

Specifies information about your locations, such as example, warehouses, and distribution centers.

You can keep track of items in different locations using the Location table. Each location has a name as well as a code representing the name. You use the table to assign a code to a location name. You can then enter the code in location code fields elsewhere in the program, for example, on purchase or sales document lines. This will then record the transactions for the location when you post.

You must set up a Location card and Location code for each warehouse location or distribution center location. When you record increases or decreases in inventory, you enter the code for the relevant location. Then you can always see where specific items are in stock.

List of Fields in the Table

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
Composition Types Field, Location Table Sales Tax
T.C.A.N. No. Field, Location Table Income Tax
C.S.T No Field, Location Table Sales Tax
Phone No. 2 Field, Location Table Inventory
Testing Location Field, Location Table Excise
Composition Field, Location Table Sales Tax
Export or Deemed Export Field, Location Table Sales Tax
State Field, Location Table Income Tax
T.I.N. No. Field, Location Table Sales Tax
Inbound Whse. Handling Time Field, Location Table Inventory
Address Field, Location Table Inventory
Service Tax Registration No. Field, Location Table Service Tax
E-Mail Field, Location Table Inventory
L.S.T. No. Field, Location Table Sales Tax
Fax No. Field, Location Table Inventory
C.E. Commissionerate Field, Location Table Excise
Input Service Distributor Field, Location Table Service Tax
Phone No. Field, Location Table Inventory
Telex No. Field, Location Table Inventory
To-Assembly Bin Code Field, Location Table Inventory
Default Bin Code Field, Location Table Inventory
Base Calendar Code Field, Location Table Inventory
T.A.N. No. Field, Location Table Income Tax
Trading Location Field, Location Table Excise
E.C.C. No. Field, Location Table Excise
City Field, Location Table Inventory
Address 2 Field, Location Table Inventory
Use Cross-Docking Field, Location Table Inventory
Require Shipment Field, Location Table Inventory
Excise Bus. Posting Group Field, Location Table Excise
Name Field, Location Table Inventory
Require Put-away Field, Location Table Inventory
Post Code Field, Location Table Inventory
Provincial Tax Area Code Field, Location Table United States Local Functionality
County Field, Location Table Inventory
Tax Area Code Field, Location Table United States Local Functionality
Name 2 Field, Location Table Inventory
Cross-Dock Due Date Calc. Field, Location Table Inventory
Home Page Field, Location Table Inventory
C.E. Range Field, Location Table Excise
Outbound Whse. Handling Time Field, Location Table Inventory
Country/Region Code Field, Location Table Inventory
Tax Exemption No. Field, Location Table United States Local Functionality
Do Not Use For Tax Calculation Field, Location Table United States Local Functionality
Asm.-to-Order Shpt. Bin Code Field, Location Table Inventory
C.E. Division Field, Location Table Excise
Transfer Receipt Nos. Field, Location Table India Local Functionality
Purch. Rcpt. Nos. (Trading) Field, Location Table India Local Functionality
Code Field, Location Table Inventory
Sales Shpt. Nos. (Trading) Field, Location Table India Local Functionality
Pick According to FEFO Field, Location Table Inventory
Sale Cr. Memo Nos. (Trading) Field, Location Table India Local Functionality
Sales Invoice Nos. (Trading) Field, Location Table India Local Functionality
Require Receive Field, Location Table Inventory
Require Pick Field, Location Table Inventory
Sales Invoice Nos. Field, Location Table India Local Functionality
Contact Field, Location Table Inventory
From-Assembly Bin Code Field, Location Table Inventory
Use As In-Transit Field, Location Table Inventory
Purch Cr. Memo Nos. (Trading) Field, Location Table India Local Functionality
Posted Serv. Shipment Nos. Field, Location Table India Local Functionality
Posted Serv. Cr. Memo Nos. Field, Location Table India Local Functionality
Subcontractor No. Field, Location Table India Local Functionality
Sales Credit Memo Nos. Field, Location Table India Local Functionality
Subcontracting Location Field, Location Table India Local Functionality
Serv. Invoice Nos. (Trading) Field, Location Table India Local Functionality
Purh. Invoice Nos. (Trading) Field, Location Table India Local Functionality
Posted Serv. Invoice Nos. Field, Location Table India Local Functionality
Serv. Cr. Memo Nos. (Trading) Field, Location Table India Local Functionality
Purch. Receipt Nos. Field, Location Table India Local Functionality
Transfer Shipment Nos. Field, Location Table India Local Functionality
Purch. Invoice Nos. Field, Location Table India Local Functionality
Purch. Credit Memo Nos. Field, Location Table India Local Functionality
Sales Ret Rcpt Nos. (Trading) Field, Location Table India Local Functionality
Purch. Ret. Shipment Nos. Field, Location Table India Local Functionality
Sales Shipment Nos. (Captive) Field, Location Table India Local Functionality
Sales Shipment Nos. Field, Location Table India Local Functionality
Purch. Ret Shpt Nos. (Trading) Field, Location Table India Local Functionality
Sales Return Receipt Nos. Field, Location Table India Local Functionality
Serv. Shipment Nos. (Trading) Field, Location Table India Local Functionality

See Also

Reference

Location List