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

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