G/L Entry Table

  • Article

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