| field name | data type | mnd. | description |
|---|
| gl_ar_acct | character(80) | no | Receivables |
| gl_ar_cc | character(30) | no | AR Cost Ctr |
| gl_disc_acct | character(80) | no | Sales Discount |
| gl__qadc01 | character(80) | no | |
| gl__qadc03 | character(80) | no | |
| gl__qadc05 | character(80) | no | |
| gl_term_acct | character(80) | no | Sales Terms |
| gl_fin_acct | character(80) | no | Sales Finance |
| gl_rtns_acct | character(80) | no | Sales Returns |
| gl_cs_acct | character(80) | no | Sales Cash |
| gl_disc_cc | character(30) | no | Disc Cost Ctr |
| gl__qadc02 | character(80) | no | |
| gl__qadc04 | character(80) | no | |
| gl__qadc06 | character(80) | no | |
| gl_tax1_cc | character(30) | no | Tax Cost Ctr |
| gl_tax2_cc | character(30) | no | Tax Cost Ctr |
| gl_tax3_cc | character(30) | no | Tax Cost Ctr |
| gl_term_cc | character(30) | no | Terms Cost Ctr |
| gl_fin_cc | character(30) | no | Finance Cost Ctr |
| gl_rtns_cc | character(30) | no | Returns Cost Ctr |
| gl_cs_cc | character(30) | no | Cash Cost Ctr |
| gl_tax1_acct | character(80) | no | Sales Tax 1 |
| gl_tax2_acct | character(80) | no | Sales Tax 2 |
| gl_tax3_acct | character(80) | no | Sales Tax 3 |
| gl_sls_acct | character(80) | no | Sales |
| gl_sls_cc | character(30) | no | Sales Cost Ctr |
| gl_ap_acct | character(80) | no | Payables |
| gl_ap_cc | character(30) | no | AP Cost Ctr |
| gl_pur_acct | character(80) | no | Purchases |
| gl_pur_cc | character(30) | no | Purchases Cost Ctr |
| gl_inv_acct | character(80) | no | Inventory Acct |
| gl_inv_cc | character(30) | no | Inventory Cost Ctr |
| gl_dscr_acct | character(80) | no | Inv Discrep Acct |
| gl_dscr_cc | character(30) | no | Inv Discrep Cost Ctr |
| gl_wip_acct | character(80) | no | Work in Process |
| gl_wip_cc | character(30) | no | Work in Process Cost Ctr |
| gl_cog_acct | character(80) | no | Cost of Goods |
| gl_cog_cc | character(30) | no | Cost of Goods Cost Ctr |
| gl_scrp_acct | character(80) | no | Scrap |
| gl_scrp_cc | character(30) | no | Scrap Cost Ctr |
| gl_apds_acct | character(80) | no | AP Discount |
| gl_apds_cc | character(30) | no | AP Disc Cost Ctr |
| gl_verify | logical | no | Verify GL Accounts |
| gl_ppv_acct | character(80) | no | PO Price Variance |
| gl_ppv_cc | character(30) | no | PO Price Var Cost Ctr |
| gl_rcpt_acct | character(80) | no | PO Receipts Acct |
| gl_rcpt_cc | character(30) | no | PO Receipts Cost Ctr |
| gl_bdn_acct | character(80) | no | Burden |
| gl_bdn_cc | character(30) | no | Burden Cost Ctr |
| gl_lbr_acct | character(80) | no | Labor |
| gl_lbr_cc | character(30) | no | Labor Cost Ctr |
| gl_lvar_acct | character(80) | no | Labor Usage Var |
| gl_lvar_cc | character(30) | no | Labor Usage Variance CC |
| gl_ot_acct | character(80) | no | Overtime |
| gl_ot_cc | character(30) | no | Overtime Cost Ctr |
| gl_cop_acct | character(80) | no | Cost Of Production |
| gl_cop_cc | character(30) | no | Cost of Production Cost Ctr |
| gl_wvar_acct | character(80) | no | Method Variance |
| gl_wvar_cc | character(30) | no | Method Variance CC |
| gl_base_curr | character(30) | no | Base Currency |
| gl_symbol | character(30) | no | Symbol |
| gl_user_acct | character(80) | no | Exempt Sales Acct |
| gl_user_cc | character(30) | no | Exempt Sales Cost Ctr |
| gl_entity | character(30) | no | Entity |
| gl__qad01 | integer | no | |
| gl_user1 | character(80) | no | Ufld1 |
| gl_user2 | character(80) | no | Ufld2 |
| gl_index1 | integer | no | Index |
| gl_vat | logical | no | Value Added Tax |
| gl_ex_round | integer | no | Round Factor |
| gl_can | logical | no | Canadian Tax |
| gl_cchg_acct | character(80) | no | Cost Revalue Acct |
| gl_cchg_cc | character(30) | no | Cost Revalue Cost Ctr |
| gl_xfer_acct | character(80) | no | Transfer Variance |
| gl_xfer_cc | character(30) | no | Transfer Variance Cost Ctr |
| gl_cmtl_acct | character(80) | no | COGS Material Acct |
| gl_cmtl_cc | character(30) | no | COGS Material CC |
| gl_clbr_acct | character(80) | no | COGS Labor Acct |
| gl_clbr_cc | character(30) | no | COGS Labor CC |
| gl_cbdn_acct | character(80) | no | COGS Burden Acct |
| gl_cbdn_cc | character(30) | no | COGS Burden CC |
| gl_covh_acct | character(80) | no | COGS Overhead Acct |
| gl_covh_cc | character(30) | no | COGS Overhead CC |
| gl_csub_acct | character(80) | no | COGS Subcontract Acct |
| gl_csub_cc | character(30) | no | COGS Subcontract CC |
| gl_apvr_acct | character(80) | no | AP Rate Variance |
| gl_apvr_cc | character(30) | no | AP Rate Var Cost Ctr |
| gl_apvu_acct | character(80) | no | AP Usage Variance |
| gl_apvu_cc | character(30) | no | AP Usage Var Cost Ctr |
| gl_bvar_acct | character(80) | no | Burden Usage Var |
| gl_bvar_cc | character(30) | no | Burden Usage Variance CC |
| gl_lvrr_acct | character(80) | no | Labor Rate Var |
| gl_lvrr_cc | character(30) | no | Labor Rate Variance CC |
| gl_bvrr_acct | character(80) | no | Burden Rate Var |
| gl_bvrr_cc | character(30) | no | Burden Rate Variance CC |
| gl_ovh_acct | character(80) | no | Overhead Appl Acct |
| gl_ovh_cc | character(30) | no | Overhead Appl CC |
| gl__qadl01 | logical | no | |
| gl_sub_len | integer | no | Sub-Module Sub-Account Length |
| gl_mvar_acct | character(80) | no | Material Usage Var |
| gl_mvar_cc | character(30) | no | Material Usage Variance CC |
| gl_mvrr_acct | character(80) | no | Material Rate Var |
| gl_mvrr_cc | character(30) | no | Material Rate Variance CC |
| gl_svar_acct | character(80) | no | Subcontract Usage Var |
| gl_svar_cc | character(30) | no | Subcontract Usage Variance CC |
| gl_svrr_acct | character(80) | no | Subcontract Rate Var |
| gl_svrr_cc | character(30) | no | Subcontract Rate Variance CC |
| gl__qadc07 | character(80) | no | |
| gl__qadc08 | character(80) | no | |
| gl_flr_acct | character(80) | no | Floor Stock Account |
| gl_flr_cc | character(30) | no | Floor Stock CC |
| gl_esls_acct | character(80) | no | Exempt Sales Acct |
| gl_esls_cc | character(30) | no | Exempt Sales Cost Ctr |
| gl_tax_type | character(30) | no | Tax Type |
| gl_frtapp_acct | character(80) | no | Sales Freight Applied Account |
| gl_frtapp_cc | character(30) | no | Cost Center |
| gl_frtacc_acct | character(80) | no | Sales Freight Accrued Account |
| gl_frtacc_cc | character(30) | no | Cost Center |
| gl__qadc09 | character(30) | no | Bank Acct Validation |
| gl_apvrx_acct | character(80) | no | Expensed Item Rate Var |
| gl_apvrx_cc | character(30) | no | Expensed Items Rate Var CC |
| gl_apvux_acct | character(80) | no | Expensed Item Usage Var |
| gl_apvux_cc | character(30) | no | Expense Items Use Var CC |
| gl_rcptx_acct | character(80) | no | Expensed Item Receipts |
| gl_rcptx_cc | character(30) | no | Expensed Receipts Cost Ctr |
| gl_crterms_acct | character(80) | no | Credit Terms Interest Account |
| gl_crterms_cc | character(30) | no | Credit Terms Interest CC |
| gl_late_acct | character(80) | no | Credit Terms Late Interest Acct |
| gl_late_cc | character(30) | no | Credit Terms Late Interest CC |
| gl_xvar_acct | character(80) | no | Mix Var |
| gl_xvar_cc | character(30) | no | Mix Var CC |
| gl_rnd_mthd | character(30) | no | Rounding Method |
| gl_lang | character(30) | no | Default System Language |
| gl_fslbr_acct | character(80) | no | Service Labor |
| gl_fslbr_cc | character(30) | no | Service Labor CC |
| gl_fsbdn_acct | character(80) | no | Service Burden |
| gl_fsbdn_cc | character(30) | no | Service Burden CC |
| gl_fsexp_acct | character(80) | no | Service Expense |
| gl_fsexp_cc | character(30) | no | Service Expense CC |
| gl_fsexd_acct | character(80) | no | Expense Due Employee |
| gl_fsexd_cc | character(30) | no | Expense Due CC |
| gl_fsrc_inv_acct | character(80) | no | Repair Center Inventory |
| gl_fsrc_inv_cc | character(30) | no | Repair Center Inv CC |
| gl_fscm_inv_acct | character(80) | no | Customer Inventory |
| gl_fscm_inv_cc | character(30) | no | Customer Inventory CC |
| gl_rmar_acct | character(80) | no | Service Returns |
| gl_rmar_cc | character(30) | no | Service Returns CC |
| gl_ex_rnd_acct | character(80) | no | Exchange Rounding Acct |
| gl_ex_rnd_cc | character(30) | no | Exchange Rounding CC |
| gl_ex_ratetype | character(80) | no | Exchange Rate Type |
| gl_ugain_acct | character(80) | no | Unrealized Exchange Gain Acct |
| gl_ugain_cc | character(30) | no | Unrealized Exchange Gain CC |
| gl_uloss_acct | character(80) | no | Unrealized Exchange Loss Acct |
| gl_uloss_cc | character(30) | no | Unrealized Exchange Loss CC |
| gl_rgain_acct | character(80) | no | Realized Exchange Gain Acct |
| gl_rgain_cc | character(30) | no | Realized Exchange Gain CC |
| gl_rloss_acct | character(80) | no | Realized Exchange Loss Acct |
| gl_rloss_cc | character(30) | no | Realized Exchange Loss CC |
| gl_apds_sub | character(80) | no | AP Discount Sub |
| gl_apvrx_sub | character(80) | no | Exp Item Rate Var Sub |
| gl_apvr_sub | character(80) | no | AP Rate Variance Sub |
| gl_apvux_sub | character(80) | no | Exp Item Usage Sub |
| gl_apvu_sub | character(80) | no | AP Usage Variance Sub |
| gl_ap_sub | character(80) | no | Payables Sub-Acct |
| gl_ar_sub | character(80) | no | Receivables Sub-Acct |
| gl_bdn_sub | character(80) | no | Burden Sub-Acct |
| gl_bvar_sub | character(80) | no | Burden Usage Var Sub |
| gl_bvrr_sub | character(80) | no | Burden Rate Var Sub |
| gl_cbdn_sub | character(80) | no | COGS Burden Sub-Acct |
| gl_cchg_sub | character(80) | no | Cost Revalue Sub-Acct |
| gl_clbr_sub | character(80) | no | COGS Labor Sub-Acct |
| gl_cmtl_sub | character(80) | no | COGS Material Sub-Acct |
| gl_cog_sub | character(80) | no | Cost of Goods Sub_Acct |
| gl_cop_sub | character(80) | no | Cost Of Production Sub |
| gl_covh_sub | character(80) | no | COGS Overhead Sub-Acct |
| gl_crterms_sub | character(80) | no | Credit Terms Int Sub |
| gl_csub_sub | character(80) | no | COGS Subcontract Sub-Acct |
| gl_cs_sub | character(80) | no | Sales Cash Sub-Acct |
| gl_disc_sub | character(80) | no | Sales Disc Sub-Acct |
| gl_dscr_sub | character(80) | no | Inv Discrep Sub-Acct |
| gl_ex_rnd_sub | character(80) | no | Exchange Rounding Sub |
| gl_fin_sub | character(80) | no | Sales Finance Sub |
| gl_flr_sub | character(80) | no | Floor Stock Sub-Acct |
| gl_frtacc_sub | character(80) | no | Sales Frt Accrued Sub |
| gl_frtapp_sub | character(80) | no | Sales Frt Applied Sub |
| gl_fsbdn_sub | character(80) | no | Service Burden Sub |
| gl_fscm_inv_sub | character(80) | no | Customer Inv Sub |
| gl_fsexd_sub | character(80) | no | Expense Due Emp Sub |
| gl_fsexp_sub | character(80) | no | Service Expense Sub |
| gl_fslbr_sub | character(80) | no | Service Labor Sub |
| gl_fsrc_inv_sub | character(80) | no | Repair Center Inv Sub |
| gl_inv_sub | character(80) | no | Inventory Sub-Acct |
| gl_late_sub | character(80) | no | Cr Terms Late Inte Sub |
| gl_lbr_sub | character(80) | no | Labor Sub-Acct |
| gl_lvar_sub | character(80) | no | Labor Usage Var Sub |
| gl_lvrr_sub | character(80) | no | Labor Rate Var Sub |
| gl_mvar_sub | character(80) | no | Material Usage Var Sub |
| gl_mvrr_sub | character(80) | no | Material Rate Var Sub |
| gl_ot_sub | character(80) | no | Overtime Sub-Acct |
| gl_ovh_sub | character(80) | no | Overhead Appl Sub-Acct |
| gl_ppv_sub | character(80) | no | PO Price Variance Sub |
| gl_pur_sub | character(80) | no | Purchases Sub |
| gl_rcptx_sub | character(80) | no | Exp Item Receipts Sub |
| gl_rcpt_sub | character(80) | no | PO Receipts Sub-Acct |
| gl_rgain_sub | character(80) | no | Realized Exch Gain Sub |
| gl_rloss_sub | character(80) | no | Realized Exch Loss Sub |
| gl_rmar_sub | character(80) | no | Service Returns Sub |
| gl_rtns_sub | character(80) | no | Sales Returns Sub |
| gl_scrp_sub | character(80) | no | Scrap Sub-Acct |
| gl_sls_sub | character(80) | no | Sales Sub-Account |
| gl_svar_sub | character(80) | no | Sub Usage Var Sub |
| gl_svrr_sub | character(80) | no | Sub Rate Var Sub |
| gl_term_sub | character(80) | no | Sales Terms Sub |
| gl_txap_acct | character(80) | no | AP Tax Account |
| gl_txap_sub | character(80) | no | AP Tax Sub-Account |
| gl_txap_cc | character(30) | no | AP Tax Cost Center |
| gl_txapr_acct | character(80) | no | AP Retained Tax Acct |
| gl_txapr_sub | character(80) | no | AP Retained Tax Sub-Account |
| gl_txapr_cc | character(30) | no | AP Retained Tax CC |
| gl_txar_acct | character(80) | no | AR Sales Tax Account |
| gl_txar_sub | character(80) | no | AR Sales Tax Sub-Account |
| gl_txar_cc | character(30) | no | AR Sales Tax CC |
| gl_txara_acct | character(80) | no | AR Absorbed Tax Acct |
| gl_txara_sub | character(80) | no | AR Absorbed Tax Sub-Account |
| gl_txara_cc | character(30) | no | AR Absorbed Tax CC |
| gl_ugain_sub | character(80) | no | Unrealized Exchange Gain Sub |
| gl_uloss_sub | character(80) | no | Unrealized Exchange Loss Sub |
| gl_user_sub | character(80) | no | Exempt Sales Sub-Acct |
| gl_wip_sub | character(80) | no | Work in Process Sub |
| gl_wvar_sub | character(80) | no | Method Variance Sub |
| gl_xfer_sub | character(80) | no | Transfer Variance Sub |
| gl_xvar_sub | character(80) | no | Mix Var Sub-Acct |
| gl_fsdef_acct | character(80) | no | Deferred Revenue |
| gl_fsdef_sub | character(80) | no | Deferred Revenue Sub-Acct |
| gl_fsdef_cc | character(30) | no | Deferred Revenue CC |
| gl_fsaccr_acct | character(80) | no | Accrued Revenue |
| gl_fsaccr_sub | character(80) | no | Accrued Revenue Sub-Acct |
| gl_fsaccr_cc | character(30) | no | Accrued Revenue CC |
| gl_timezone | character(80) | no | Server Time Zone |
| gl_domain | character(8) | yes | Domain |
| oid_gl_ctrl | decimal(10) | no | |
| gl_txar_cn_acct | character(80) | no | Sales Tax CN Acct |
| gl_txar_cn_sub | character(80) | no | Sales Tax CN Sub-Account |
| gl_txap_cn_acct | character(80) | no | AP Tax CN Account |
| gl_txap_cn_sub | character(80) | no | AP Tax CN Sub-Account |
| gl_txara_cn_acct | character(80) | no | Sales Tax Abs CN Acct |
| gl_txara_cn_sub | character(80) | no | Sales Tax Abs CN Sub-Acct |
| gl_txapr_cn_acct | character(80) | no | AP Tax Ret CN Account |
| gl_txapr_cn_sub | character(80) | no | AP Tax Ret CN Sub-Account |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |