Common Table & Field Reference

This section provides a quick reference for frequently used Business Central tables and fields in business rules. All table and field IDs have been verified against the system schema.

26.1 Sales Tables

Sales Header (Table 36):

• Field 2: Sell-to Customer No.

• Field 3: No. (Document No.)

• Field 20: Order Date

• Field 68: Ship-to Code

• Field 71: Requested Delivery Date

• Field 79: Sell-to Customer Name

• Field 120: Status (0=Open, 1=Released, 2=Pending Approval, 3=Pending Prepayment)

• Field 167: Payment Terms Code

Sales Line (Table 37):

• Field 3: Document No.

• Field 6: Type (0=Empty, 1=G/L Account, 2=Item, 3=Resource, 4=Fixed Asset, 5=Charge (Item))

• Field 11: Description

• Field 15: Quantity

• Field 22: Unit Price

• Field 23: Unit Cost (LCY)

• Field 27: Line Discount %

• Field 61: Amount (Line Amount)

26.2 Purchase Tables

Purchase Header (Table 38):

• Field 2: Buy-from Vendor No.

• Field 3: No. (Document No.)

• Field 5: Order Date

• Field 68: Ship-to Code

• Field 79: Buy-from Vendor Name

• Field 120: Status

Purchase Line (Table 39):

• Field 3: Document No.

• Field 6: Type

• Field 11: Description

• Field 15: Quantity

• Field 22: Direct Unit Cost

• Field 27: Line Discount %

• Field 61: Amount

26.3 Customer Table

Customer (Table 18):

• Field 2: Name

• Field 5: Address

• Field 7: City

• Field 9: Phone No.

• Field 20: Credit Limit (LCY)

• Field 39: Blocked (Empty=Not Blocked, All=All Transactions Blocked)

• Field 59: Balance (LCY)

• Field 102: E-Mail

• Field 118: Salesperson Code

26.4 Vendor Table

Vendor (Table 23):

• Field 2: Name

• Field 5: Address

• Field 7: City

• Field 9: Phone No.

• Field 23: Vendor Posting Group

• Field 45: Purchaser Code

• Field 59: Balance (LCY)

• Field 102: E-Mail

26.5 Item Table

Item (Table 27):

• Field 3: Description

• Field 8: Base Unit of Measure

• Field 10: Inventory Posting Group

• Field 11: Shelf No.

• Field 18: Unit Cost

• Field 22: Unit Price

• Field 31: Vendor No.

• Field 50: Last Date Modified

26.6 General Ledger Account Table

G/L Account (Table 15):

• Field 2: Name

• Field 4: Account Type (0=Posting, 1=Heading, 2=Total, 3=Begin-Total, 4=End-Total)

• Field 9: Income/Balance (0=Income Statement, 1=Balance Sheet)

• Field 34: Blocked (Yes/No)

26.7 Other Common Tables

Location (Table 14):

• Field 2: Name

• Field 5: Address

• Field 7: City

• Field 9: Phone No.

Salesperson/Purchaser (Table 13):

• Field 2: Name

• Field 5: E-Mail

• Field 7: Phone No.

Payment Terms (Table 3):

• Field 2: Description

• Field 4: Due Date Calculation

• Field 5: Discount Date Calculation