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.
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 |