General ledger database columns

The table in this appendix lists the GL account columns found in user applications. It shows the application, table, and column name for each column. The table also indicates whether you must fully specify the GL account.

The GL account specification required (fully or partially) column indicates whether the general ledger database column, and its corresponding field on a tab, require a fully specified account, or whether a partially specified account is acceptable.

A fully specified account has an account code in each required component, for example, 6100-350-SAF. A partially specified account has placeholder characters for one or more account components, for example, 6100-???-SAF.

Table 1. General ledger database column definitions
Application Table Column name GL account specification required (fully or partially)
CHRTACCT TAX EXCLUSIVEGL Fully
CHRTACCT TAX INCLUSIVEGL Fully
CHRTACCT TAXTYPE EXCLUSIVEGL Fully
CHRTACCT TAXTYPE INCLUSIVEGL Fully
COMPANY COMPANIES APCONTROLACC Fully
COMPANY COMPANIES APSUSPENSEACC Fully
COMPANY COMPANIES RBNIACC Fully
COMPANY COMPANIES APCONTROLACC Fully
ASSET ASSETTRANS GLDEBITACCT Partially
ASSET ASSETTRANS GLCREDITACCT Partially
ASSET ASSET GLACCOUNT Partially
ASSET ASSET ROTSUSPACCT Fully
INVENTOR INVCOST CONTROLACC Fully
INVENTOR INVCOST GLACCOUNT Partially
INVENTOR INVCOST INVCOSTADJACC Fully
INVENTOR INVCOST SHRINKAGEACC Fully
INVENTOR INVRESERVE GLACCOUNT Fully
INVENTOR INVTRANS GLCREDITACCT Fully
INVENTOR INVTRANS GLDEBITACCT Fully
INVENTOR REORDER CONTROLACC Fully
INVENTOR REORDER GLACCOUNT Fully
INVOICE APTRANS GLCREDITACCT Fully
INVOICE APTRANS GLDEBITACCT Fully
INVOICE INVOICE APCONTROLACCT Fully
INVOICE INVOICE APSUSPENSEACCT Fully
INVOICE INVOICE TAX1GL Fully
INVOICE INVOICE TAX2GL Fully
INVOICE INVOICE TAX3GL Fully
INVOICE INVOICE TAX4GL Fully
INVOICE INVOICE TAX5GL Fully
INVOICE INVOICECOST GLCREDITACCT Fully
INVOICE INVOICECOST GLDEBITACCT Fully
INVOICE INVOICETRANS GLCREDITACCT Fully
INVOICE INVOICETRANS GLDEBITACCT Fully
INVOICE SCHARGES GLDEBITACCT Fully
LABOR LABORCRAFTRATE CONTROLACC Fully
LABOR LABORCRAFTRATE GLACCOUNT Partially
LABOR LABTRANS GLCREDITACCT Fully
LABOR LABTRANS GLDEBITACCT Fully
LOCATION LOCATIONS CONTROLACC Fully
LOCATION LOCATIONS CURVARACC Fully
LOCATION LOCATIONS GLACCOUNT Partially
LOCATION LOCATIONS INVCOSTADJACC Fully
LOCATION LOCATIONS INVOICEVARACC Fully
LOCATION LOCATIONS PURCHVARACC Fully
LOCATION LOCATIONS INVOICEVARACC Fully
LOCATION LOCATIONS PURCHVARACC Fully
LOCATION LOCATIONS RECEIPTVARACC Fully
LOCATION LOCATIONS SHRINKAGEACC Fully
PM PM GLACCOUNT Partially
PO POLINE GLCREDITACCT Fully
PO POLINE GLDEBITACCT

Before approval: partially

On approval: fully

PR PRLINE GLCREDITACCT Fully
PR PRLINE GLDEBITACCT

Before approval: partially

On approval: fully

RECEIVING MATRECTRANS GLCREDITACCT Fully
RECEIVING MATRECTRANS GLDEBITACCT Fully
RECEIVING MATRECTRANS GLCREDITACCT Fully
RECEIVING MATRECTRANS GLDEBITACCT Fully
RFQ RFQLINE GLDEBITACCT Fully
RFQ RFQLINE GLCREDITACCT Fully
RFQ RFQLINE GLCREDITACCT Fully
SERV SERVRECTRANS GLCREDITACCT Fully
SERV SERVRECTRANS GLDEBITACCT Fully
TOOL TOOL CONTROLACC Fully
TOOL TOOL GLACCOUNT Partially
TOOL TOOLTRANS GLCREDITACCT Fully
TOOL TOOLTRANS GLDEBITACCT Fully
WOTRACK WORKORDER GLACCOUNT Partially
WOTRACK WOSTATUS GLACCOUNT Partially