Skip to content · Zum Inhalt

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