G/L Entry Table

Specifies a general ledger entry, which you can see from the chart of accounts, if you post to a general ledger account.

G/L entries can be created in the following ways: by posting a general journal; by posting a sales order, invoice, or credit memo; by posting a purchase order, invoice or credit memo; by posting cash receipts and payments to vendors; by posting finance charge memos and reminders and by running batch jobs.

You cannot change the contents of the fields in the G/L Entry table because the entries have been posted.

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
Tax Amount Field, G/L Entry Table	Sales Tax
Positive Field, G/L Entry Table	Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Transaction No. Field, G/L Entry Table	Spain Local Functionality
Official Date Field, G/L Entry Table	Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Old G/L Account No. Field, G/L Entry Table	Spain Local Functionality
Entry Type Field, G/L Entry Table	France Local Functionality
New G/L Account No. Field, G/L Entry Table	Spain Local Functionality
Letter Date Field, G/L Entry Table	France Local Functionality
Updated Field, G/L Entry Table	Spain Local Functionality
Letter Field, G/L Entry Table	France Local Functionality
Entry Type Field, G/L Entry Table	France Local Functionality
Applies-to ID Field, G/L Entry Table	France Local Functionality
Bill No. Field, G/L Entry Table	Spain Local Functionality
Location Code Field, G/L Entry Table	India Local Functionality
Closed at Date Field, G/L Entry Table	Belgium Local Functionality
Journal Template Name Field, G/L Entry Table	Belgium Local Functionality
Closed by Entry No. Field, G/L Entry Table	Belgium Local Functionality
Closed by Amount Field, G/L Entry Table	Belgium Local Functionality
Open Field, G/L Entry Table	Belgium Local Functionality
Remaining Amount Field, G/L Entry Table	Belgium Local Functionality
Applies-to ID Field, G/L Entry Table	Belgium Local Functionality
Applies-to ID Field, G/L Entry Table	Netherlands Local Functionality
Open Field, G/L Entry Table	Netherlands Local Functionality
Closed at Date Field, G/L Entry Table	Netherlands Local Functionality
Closed by Entry No. Field, G/L Entry Table	Netherlands Local Functionality
Remaining Amount Field, G/L Entry Table	Netherlands Local Functionality
Closed by Amount Field, G/L Entry Table	Netherlands Local Functionality
Tax Amount Field, G/L Entry Table	India Sales Tax
Quantity Field, G/L Entry Table	General Ledger
Reversed Entry No. Field, G/L Entry Table	General Ledger
User ID Field, G/L Entry Table	General Ledger
Entry Type Field, G/L Entry Table	France Local Functionality
IC Partner Code Field, G/L Entry Table	General Ledger
Global Dimension 2 Code Field, G/L Entry Table	General Ledger
Applies-to ID Field, G/L Entry Table	Netherlands Local Functionality
FA Entry No. Field, G/L Entry Table	General Ledger
Prod. Order No. Field, G/L Entry Table	General Ledger
Open Field, G/L Entry Table	Netherlands Local Functionality
System-Created Entry Field, G/L Entry Table	General Ledger
Prior-Year Entry Field, G/L Entry Table	General Ledger
Location Code Field, G/L Entry Table	India Local Functionality
Description Field, G/L Entry Table	General Ledger
Debit Amount Field, G/L Entry Table	General Ledger
Closed at Date Field, G/L Entry Table	Netherlands Local Functionality
Closed by Entry No. Field, G/L Entry Table	Netherlands Local Functionality
Journal Batch Name Field, G/L Entry Table	General Ledger
Reversed by Entry No. Field, G/L Entry Table	General Ledger
Bal. Account No. Field, G/L Entry Table	General Ledger
Remaining Amount Field, G/L Entry Table	Netherlands Local Functionality
Closed by Amount Field, G/L Entry Table	Netherlands Local Functionality
Bal. Account Type Field, G/L Entry Table	General Ledger
Reason Code Field, G/L Entry Table	General Ledger
Global Dimension 1 Code Field, G/L Entry Table	General Ledger
Credit Amount Field, G/L Entry Table	General Ledger
Source No. Field, G/L Entry Table	General Ledger
G/L Account No. Field, G/L Entry Table	General Ledger
G/L Account Name Field, G/L Entry Table	General Ledger
Business Unit Code Field, G/L Entry Table	General Ledger
Document Date Field, G/L Entry Table	General Ledger
Source Type Field, G/L Entry Table	General Ledger
FA Entry Type Field, G/L Entry Table	General Ledger
Additional-Currency Amount Field, G/L Entry Table	General Ledger
BAS Adjustment Field, G/L Entry Table	New Zealand Local Functionality
STE Transaction ID Field, G/L Entry Table	United States Local Functionality
Adjustment Field, G/L Entry Table	New Zealand Local Functionality
BAS Doc. No. Field, G/L Entry Table	New Zealand Local Functionality
GST/HST Field, G/L Entry Table	United States Local Functionality
BAS Version Field, G/L Entry Table	New Zealand Local Functionality
Consol. Version No. Field, G/L Entry Table	New Zealand Local Functionality
Consol. BAS Doc. No. Field, G/L Entry Table	New Zealand Local Functionality
Entry Type Field, G/L Entry Table	New Zealand Local Functionality
Tax Area Code Field, G/L Entry Table	General Ledger
External Document No. Field, G/L Entry Table	General Ledger
Quantity Field, G/L Entry Table	General Ledger
Source Code Field, G/L Entry Table	General Ledger
Entry No. Field, G/L Entry Table	General Ledger
Reversed Entry No. Field, G/L Entry Table	General Ledger
VAT Prod. Posting Group Field, G/L Entry Table	General Ledger
Document No. Field, G/L Entry Table	General Ledger
User ID Field, G/L Entry Table	General Ledger
Posting Date Field, G/L Entry Table	General Ledger
Add.-Currency Debit Amount Field, G/L Entry Table	General Ledger
IC Partner Code Field, G/L Entry Table	General Ledger
Gen. Bus. Posting Group Field, G/L Entry Table	General Ledger
Global Dimension 2 Code Field, G/L Entry Table	General Ledger
Close Income Statement Dim. ID Field, G/L Entry Table	General Ledger
No. Series Field, G/L Entry Table	General Ledger
FA Entry No. Field, G/L Entry Table	General Ledger
Prod. Order No. Field, G/L Entry Table	General Ledger
Document Type Field, G/L Entry Table	General Ledger
Tax Liable Field, G/L Entry Table	General Ledger
System-Created Entry Field, G/L Entry Table	General Ledger
Prior-Year Entry Field, G/L Entry Table	General Ledger
Description Field, G/L Entry Table	General Ledger
Debit Amount Field, G/L Entry Table	General Ledger
Journal Batch Name Field, G/L Entry Table	General Ledger
Reversed by Entry No. Field, G/L Entry Table	General Ledger
Bal. Account No. Field, G/L Entry Table	General Ledger
Bal. Account Type Field, G/L Entry Table	General Ledger
Reason Code Field, G/L Entry Table	General Ledger
VAT Bus. Posting Group Field, G/L Entry Table	General Ledger
Global Dimension 1 Code Field, G/L Entry Table	General Ledger
Credit Amount Field, G/L Entry Table	General Ledger
Source No. Field, G/L Entry Table	General Ledger
Add.-Currency Credit Amount Field, G/L Entry Table	General Ledger
Job No. Field, G/L Entry Table	General Ledger
Gen. Posting Type Field, G/L Entry Table	General Ledger
Amount Field, G/L Entry Table	General Ledger
G/L Account No. Field, G/L Entry Table	General Ledger
G/L Account Name Field, G/L Entry Table	General Ledger
Business Unit Code Field, G/L Entry Table	General Ledger
VAT Amount Field, G/L Entry Table	General Ledger
Reversed Field, G/L Entry Table	General Ledger
Gen. Prod. Posting Group Field, G/L Entry Table	General Ledger
Tax Group Code Field, G/L Entry Table	General Ledger
Use Tax Field, G/L Entry Table	General Ledger
Document Date Field, G/L Entry Table	General Ledger
Source Type Field, G/L Entry Table	General Ledger
FA Entry Type Field, G/L Entry Table	General Ledger
Dimension Set ID Field, G/L Entry Table	General Ledger
Transaction No. Field, G/L Entry Table	General Ledger
Additional-Currency Amount Field, G/L Entry Table	General Ledger
Amount (FCY) Field, G/L Entry Table	Switzerland Local Functionality
Tax Amount Field, G/L Entry Table	Sales Tax
Location Code Field, G/L Entry Table	India Local Functionality
Entry Type Field, G/L Entry Table	France Local Functionality
Tax Area Code Field, G/L Entry Table	General Ledger
External Document No. Field, G/L Entry Table	General Ledger
Quantity Field, G/L Entry Table	General Ledger
Source Code Field, G/L Entry Table	General Ledger
Entry No. Field, G/L Entry Table	General Ledger
Reversed Entry No. Field, G/L Entry Table	General Ledger
VAT Prod. Posting Group Field, G/L Entry Table	General Ledger
Closed by Amount Field, G/L Entry Table	Netherlands Local Functionality
Document No. Field, G/L Entry Table	General Ledger
User ID Field, G/L Entry Table	General Ledger
Posting Date Field, G/L Entry Table	General Ledger
Add.-Currency Debit Amount Field, G/L Entry Table	General Ledger
IC Partner Code Field, G/L Entry Table	General Ledger
Gen. Bus. Posting Group Field, G/L Entry Table	General Ledger
Global Dimension 2 Code Field, G/L Entry Table	General Ledger
Close Income Statement Dim. ID Field, G/L Entry Table	General Ledger
No. Series Field, G/L Entry Table	General Ledger
FA Entry No. Field, G/L Entry Table	General Ledger
Prod. Order No. Field, G/L Entry Table	General Ledger
Document Type Field, G/L Entry Table	General Ledger
Tax Liable Field, G/L Entry Table	General Ledger
System-Created Entry Field, G/L Entry Table	General Ledger
Prior-Year Entry Field, G/L Entry Table	General Ledger
Description Field, G/L Entry Table	General Ledger
Debit Amount Field, G/L Entry Table	General Ledger
Journal Batch Name Field, G/L Entry Table	General Ledger
Reversed by Entry No. Field, G/L Entry Table	General Ledger
Bal. Account No. Field, G/L Entry Table	General Ledger
Bal. Account Type Field, G/L Entry Table	General Ledger
Reason Code Field, G/L Entry Table	General Ledger
VAT Bus. Posting Group Field, G/L Entry Table	General Ledger
Global Dimension 1 Code Field, G/L Entry Table	General Ledger
Credit Amount Field, G/L Entry Table	General Ledger
Source No. Field, G/L Entry Table	General Ledger
Add.-Currency Credit Amount Field, G/L Entry Table	General Ledger
Job No. Field, G/L Entry Table	General Ledger
Gen. Posting Type Field, G/L Entry Table	General Ledger
Amount Field, G/L Entry Table	General Ledger
G/L Account No. Field, G/L Entry Table	General Ledger
G/L Account Name Field, G/L Entry Table	General Ledger
Business Unit Code Field, G/L Entry Table	General Ledger
VAT Amount Field, G/L Entry Table	General Ledger
Reversed Field, G/L Entry Table	General Ledger
Gen. Prod. Posting Group Field, G/L Entry Table	General Ledger
Tax Group Code Field, G/L Entry Table	General Ledger
Use Tax Field, G/L Entry Table	General Ledger
Document Date Field, G/L Entry Table	General Ledger
Source Type Field, G/L Entry Table	General Ledger
FA Entry Type Field, G/L Entry Table	General Ledger
Dimension Set ID Field, G/L Entry Table	General Ledger
Transaction No. Field, G/L Entry Table	General Ledger
Additional-Currency Amount Field, G/L Entry Table	General Ledger
Applies-to ID Field, G/L Entry Table	Netherlands Local Functionality
Open Field, G/L Entry Table	Netherlands Local Functionality
Closed at Date Field, G/L Entry Table	Netherlands Local Functionality
Closed by Entry No. Field, G/L Entry Table	Netherlands Local Functionality
Remaining Amount Field, G/L Entry Table	Netherlands Local Functionality
Tax Area Code Field, G/L Entry Table	General Ledger
External Document No. Field, G/L Entry Table	General Ledger
Source Code Field, G/L Entry Table	General Ledger
Entry No. Field, G/L Entry Table	General Ledger
VAT Prod. Posting Group Field, G/L Entry Table	General Ledger
Document No. Field, G/L Entry Table	General Ledger
Posting Date Field, G/L Entry Table	General Ledger
Add.-Currency Debit Amount Field, G/L Entry Table	General Ledger
Gen. Bus. Posting Group Field, G/L Entry Table	General Ledger
Close Income Statement Dim. ID Field, G/L Entry Table	General Ledger
No. Series Field, G/L Entry Table	General Ledger
Document Type Field, G/L Entry Table	General Ledger
Tax Liable Field, G/L Entry Table	General Ledger
VAT Bus. Posting Group Field, G/L Entry Table	General Ledger
Add.-Currency Credit Amount Field, G/L Entry Table	General Ledger
Job No. Field, G/L Entry Table	General Ledger
Gen. Posting Type Field, G/L Entry Table	General Ledger
Amount Field, G/L Entry Table	General Ledger
VAT Amount Field, G/L Entry Table	General Ledger
Reversed Field, G/L Entry Table	General Ledger
Gen. Prod. Posting Group Field, G/L Entry Table	General Ledger
Tax Group Code Field, G/L Entry Table	General Ledger
Use Tax Field, G/L Entry Table	General Ledger
Dimension Set ID Field, G/L Entry Table	General Ledger
Transaction No. Field, G/L Entry Table	General Ledger
Tax Area Code Field, G/L Entry Table	General Ledger
External Document No. Field, G/L Entry Table	General Ledger
Quantity Field, G/L Entry Table	General Ledger
Source Code Field, G/L Entry Table	General Ledger
Entry No. Field, G/L Entry Table	General Ledger
Reversed Entry No. Field, G/L Entry Table	General Ledger
VAT Prod. Posting Group Field, G/L Entry Table	General Ledger
Document No. Field, G/L Entry Table	General Ledger
User ID Field, G/L Entry Table	General Ledger
Posting Date Field, G/L Entry Table	General Ledger
Add.-Currency Debit Amount Field, G/L Entry Table	General Ledger
IC Partner Code Field, G/L Entry Table	General Ledger
Gen. Bus. Posting Group Field, G/L Entry Table	General Ledger
Global Dimension 2 Code Field, G/L Entry Table	General Ledger
Close Income Statement Dim. ID Field, G/L Entry Table	General Ledger
No. Series Field, G/L Entry Table	General Ledger
FA Entry No. Field, G/L Entry Table	General Ledger
Prod. Order No. Field, G/L Entry Table	General Ledger
Document Type Field, G/L Entry Table	General Ledger
Tax Liable Field, G/L Entry Table	General Ledger
System-Created Entry Field, G/L Entry Table	General Ledger
Prior-Year Entry Field, G/L Entry Table	General Ledger
Description Field, G/L Entry Table	General Ledger
Debit Amount Field, G/L Entry Table	General Ledger
Journal Batch Name Field, G/L Entry Table	General Ledger
Reversed by Entry No. Field, G/L Entry Table	General Ledger
Bal. Account No. Field, G/L Entry Table	General Ledger
Bal. Account Type Field, G/L Entry Table	General Ledger
Reason Code Field, G/L Entry Table	General Ledger
VAT Bus. Posting Group Field, G/L Entry Table	General Ledger
Global Dimension 1 Code Field, G/L Entry Table	General Ledger
Credit Amount Field, G/L Entry Table	General Ledger
Source No. Field, G/L Entry Table	General Ledger
Add.-Currency Credit Amount Field, G/L Entry Table	General Ledger
Job No. Field, G/L Entry Table	General Ledger
Gen. Posting Type Field, G/L Entry Table	General Ledger
Amount Field, G/L Entry Table	General Ledger
G/L Account No. Field, G/L Entry Table	General Ledger
G/L Account Name Field, G/L Entry Table	General Ledger
Business Unit Code Field, G/L Entry Table	General Ledger
VAT Amount Field, G/L Entry Table	General Ledger
Reversed Field, G/L Entry Table	General Ledger
Gen. Prod. Posting Group Field, G/L Entry Table	General Ledger
Tax Group Code Field, G/L Entry Table	General Ledger
Use Tax Field, G/L Entry Table	General Ledger
Document Date Field, G/L Entry Table	General Ledger
Source Type Field, G/L Entry Table	General Ledger
FA Entry Type Field, G/L Entry Table	General Ledger
Dimension Set ID Field, G/L Entry Table	General Ledger
Transaction No. Field, G/L Entry Table	General Ledger
Additional-Currency Amount Field, G/L Entry Table	General Ledger
Entry Type Field, G/L Entry Table	France Local Functionality
Applies-to ID Field, G/L Entry Table	Netherlands Local Functionality
Open Field, G/L Entry Table	Netherlands Local Functionality
Closed at Date Field, G/L Entry Table	Netherlands Local Functionality
Closed by Entry No. Field, G/L Entry Table	Netherlands Local Functionality
Remaining Amount Field, G/L Entry Table	Netherlands Local Functionality
Closed by Amount Field, G/L Entry Table	Netherlands Local Functionality

See Also

Reference

General Ledger Entries