field name | data type | db field | description |
tcgl__qadc09 | character | gl_ctrl.gl__qadc09 | Bank Acct Validation |
tcgl_ap_acct | character | gl_ctrl.gl_ap_acct | Payables |
tcgl_ap_cc | character | gl_ctrl.gl_ap_cc | AP Cost Ctr |
tcgl_ap_sub | character | gl_ctrl.gl_ap_sub | Payables Sub-Acct |
tcgl_apds_acct | character | gl_ctrl.gl_apds_acct | AP Discount |
tcgl_apds_cc | character | gl_ctrl.gl_apds_cc | AP Disc Cost Ctr |
tcgl_apds_sub | character | gl_ctrl.gl_apds_sub | AP Discount Sub |
tcgl_apvr_acct | character | gl_ctrl.gl_apvr_acct | AP Rate Variance |
tcgl_apvr_cc | character | gl_ctrl.gl_apvr_cc | AP Rate Var Cost Ctr |
tcgl_apvr_sub | character | gl_ctrl.gl_apvr_sub | AP Rate Variance Sub |
tcgl_apvrx_acct | character | gl_ctrl.gl_apvrx_acct | Expensed Item Rate Var |
tcgl_apvrx_cc | character | gl_ctrl.gl_apvrx_cc | Expensed Items Rate Var CC |
tcgl_apvrx_sub | character | gl_ctrl.gl_apvrx_sub | Exp Item Rate Var Sub |
tcgl_apvu_acct | character | gl_ctrl.gl_apvu_acct | AP Usage Variance |
tcgl_apvu_cc | character | gl_ctrl.gl_apvu_cc | AP Usage Var Cost Ctr |
tcgl_apvu_sub | character | gl_ctrl.gl_apvu_sub | AP Usage Variance Sub |
tcgl_apvux_acct | character | gl_ctrl.gl_apvux_acct | Expensed Item Usage Var |
tcgl_apvux_cc | character | gl_ctrl.gl_apvux_cc | Expense Items Use Var CC |
tcgl_apvux_sub | character | gl_ctrl.gl_apvux_sub | Exp Item Usage Sub |
tcgl_ar_acct | character | gl_ctrl.gl_ar_acct | Receivables |
tcgl_ar_cc | character | gl_ctrl.gl_ar_cc | AR Cost Ctr |
tcgl_ar_sub | character | gl_ctrl.gl_ar_sub | Receivables Sub-Acct |
tcgl_base_curr | character | gl_ctrl.gl_base_curr | Base Currency |
tcgl_bdn_acct | character | gl_ctrl.gl_bdn_acct | Burden |
tcgl_bdn_cc | character | gl_ctrl.gl_bdn_cc | Burden Cost Ctr |
tcgl_bdn_sub | character | gl_ctrl.gl_bdn_sub | Burden Sub-Acct |
tcgl_bvar_acct | character | gl_ctrl.gl_bvar_acct | Burden Usage Var |
tcgl_bvar_cc | character | gl_ctrl.gl_bvar_cc | Burden Usage Variance CC |
tcgl_bvar_sub | character | gl_ctrl.gl_bvar_sub | Burden Usage Var Sub |
tcgl_bvrr_acct | character | gl_ctrl.gl_bvrr_acct | Burden Rate Var |
tcgl_bvrr_cc | character | gl_ctrl.gl_bvrr_cc | Burden Rate Variance CC |
tcgl_bvrr_sub | character | gl_ctrl.gl_bvrr_sub | Burden Rate Var Sub |
tlgl_can | logical | gl_ctrl.gl_can | Canadian Tax |
tcgl_cbdn_acct | character | gl_ctrl.gl_cbdn_acct | COGS Burden Acct |
tcgl_cbdn_cc | character | gl_ctrl.gl_cbdn_cc | COGS Burden CC |
tcgl_cbdn_sub | character | gl_ctrl.gl_cbdn_sub | COGS Burden Sub-Acct |
tcgl_cchg_acct | character | gl_ctrl.gl_cchg_acct | Cost Revalue Acct |
tcgl_cchg_cc | character | gl_ctrl.gl_cchg_cc | Cost Revalue Cost Ctr |
tcgl_cchg_sub | character | gl_ctrl.gl_cchg_sub | Cost Revalue Sub-Acct |
tcgl_clbr_acct | character | gl_ctrl.gl_clbr_acct | COGS Labor Acct |
tcgl_clbr_cc | character | gl_ctrl.gl_clbr_cc | COGS Labor CC |
tcgl_clbr_sub | character | gl_ctrl.gl_clbr_sub | COGS Labor Sub-Acct |
tcgl_cmtl_acct | character | gl_ctrl.gl_cmtl_acct | COGS Material Acct |
tcgl_cmtl_cc | character | gl_ctrl.gl_cmtl_cc | COGS Material CC |
tcgl_cmtl_sub | character | gl_ctrl.gl_cmtl_sub | COGS Material Sub-Acct |
tcgl_cog_acct | character | gl_ctrl.gl_cog_acct | Cost of Goods |
tcgl_cog_cc | character | gl_ctrl.gl_cog_cc | Cost of Goods Cost Ctr |
tcgl_cog_sub | character | gl_ctrl.gl_cog_sub | Cost of Goods Sub_Acct |
tcgl_cop_acct | character | gl_ctrl.gl_cop_acct | Cost Of Production |
tcgl_cop_cc | character | gl_ctrl.gl_cop_cc | Cost of Production Cost Ctr |
tcgl_cop_sub | character | gl_ctrl.gl_cop_sub | Cost Of Production Sub |
tcgl_covh_acct | character | gl_ctrl.gl_covh_acct | COGS Overhead Acct |
tcgl_covh_cc | character | gl_ctrl.gl_covh_cc | COGS Overhead CC |
tcgl_covh_sub | character | gl_ctrl.gl_covh_sub | COGS Overhead Sub-Acct |
tcgl_crterms_acct | character | gl_ctrl.gl_crterms_acct | Credit Terms Interest Account |
tcgl_crterms_cc | character | gl_ctrl.gl_crterms_cc | Credit Terms Interest CC |
tcgl_crterms_sub | character | gl_ctrl.gl_crterms_sub | Credit Terms Int Sub |
tcgl_cs_acct | character | gl_ctrl.gl_cs_acct | Sales Cash |
tcgl_cs_cc | character | gl_ctrl.gl_cs_cc | Cash Cost Ctr |
tcgl_cs_sub | character | gl_ctrl.gl_cs_sub | Sales Cash Sub-Acct |
tcgl_csub_acct | character | gl_ctrl.gl_csub_acct | COGS Subcontract Acct |
tcgl_csub_cc | character | gl_ctrl.gl_csub_cc | COGS Subcontract CC |
tcgl_csub_sub | character | gl_ctrl.gl_csub_sub | COGS Subcontract Sub-Acct |
tcgl_disc_acct | character | gl_ctrl.gl_disc_acct | Sales Discount |
tcgl_disc_cc | character | gl_ctrl.gl_disc_cc | Disc Cost Ctr |
tcgl_disc_sub | character | gl_ctrl.gl_disc_sub | Sales Disc Sub-Acct |
tcgl_domain | character | gl_ctrl.gl_domain | Domain |
tcgl_dscr_acct | character | gl_ctrl.gl_dscr_acct | Inv Discrep Acct |
tcgl_dscr_cc | character | gl_ctrl.gl_dscr_cc | Inv Discrep Cost Ctr |
tcgl_dscr_sub | character | gl_ctrl.gl_dscr_sub | Inv Discrep Sub-Acct |
tcgl_entity | character | gl_ctrl.gl_entity | Entity |
tcgl_esls_acct | character | gl_ctrl.gl_esls_acct | Exempt Sales Acct |
tcgl_esls_cc | character | gl_ctrl.gl_esls_cc | Exempt Sales Cost Ctr |
tcgl_ex_ratetype | character | gl_ctrl.gl_ex_ratetype | Exchange Rate Type |
tcgl_ex_rnd_acct | character | gl_ctrl.gl_ex_rnd_acct | Exchange Rounding Acct |
tcgl_ex_rnd_cc | character | gl_ctrl.gl_ex_rnd_cc | Exchange Rounding CC |
tcgl_ex_rnd_sub | character | gl_ctrl.gl_ex_rnd_sub | Exchange Rounding Sub |
tigl_ex_round | integer | gl_ctrl.gl_ex_round | Round Factor |
tcgl_fin_acct | character | gl_ctrl.gl_fin_acct | Sales Finance |
tcgl_fin_cc | character | gl_ctrl.gl_fin_cc | Finance Cost Ctr |
tcgl_fin_sub | character | gl_ctrl.gl_fin_sub | Sales Finance Sub |
tcgl_flr_acct | character | gl_ctrl.gl_flr_acct | Floor Stock Account |
tcgl_flr_cc | character | gl_ctrl.gl_flr_cc | Floor Stock CC |
tcgl_flr_sub | character | gl_ctrl.gl_flr_sub | Floor Stock Sub-Acct |
tcgl_frtacc_acct | character | gl_ctrl.gl_frtacc_acct | Sales Freight Accrued Account |
tcgl_frtacc_cc | character | gl_ctrl.gl_frtacc_cc | Cost Center |
tcgl_frtacc_sub | character | gl_ctrl.gl_frtacc_sub | Sales Frt Accrued Sub |
tcgl_frtapp_acct | character | gl_ctrl.gl_frtapp_acct | Sales Freight Applied Account |
tcgl_frtapp_cc | character | gl_ctrl.gl_frtapp_cc | Cost Center |
tcgl_frtapp_sub | character | gl_ctrl.gl_frtapp_sub | Sales Frt Applied Sub |
tcgl_fsaccr_acct | character | gl_ctrl.gl_fsaccr_acct | Accrued Revenue |
tcgl_fsaccr_cc | character | gl_ctrl.gl_fsaccr_cc | Accrued Revenue CC |
tcgl_fsaccr_sub | character | gl_ctrl.gl_fsaccr_sub | Accrued Revenue Sub-Acct |
tcgl_fsbdn_acct | character | gl_ctrl.gl_fsbdn_acct | Service Burden |
tcgl_fsbdn_cc | character | gl_ctrl.gl_fsbdn_cc | Service Burden CC |
tcgl_fsbdn_sub | character | gl_ctrl.gl_fsbdn_sub | Service Burden Sub |
tcgl_fscm_inv_acct | character | gl_ctrl.gl_fscm_inv_acct | Customer Inventory |
tcgl_fscm_inv_cc | character | gl_ctrl.gl_fscm_inv_cc | Customer Inventory CC |
tcgl_fscm_inv_sub | character | gl_ctrl.gl_fscm_inv_sub | Customer Inv Sub |
tcgl_fsdef_acct | character | gl_ctrl.gl_fsdef_acct | Deferred Revenue |
tcgl_fsdef_cc | character | gl_ctrl.gl_fsdef_cc | Deferred Revenue CC |
tcgl_fsdef_sub | character | gl_ctrl.gl_fsdef_sub | Deferred Revenue Sub-Acct |
tcgl_fsexd_acct | character | gl_ctrl.gl_fsexd_acct | Expense Due Employee |
tcgl_fsexd_cc | character | gl_ctrl.gl_fsexd_cc | Expense Due CC |
tcgl_fsexd_sub | character | gl_ctrl.gl_fsexd_sub | Expense Due Emp Sub |
tcgl_fsexp_acct | character | gl_ctrl.gl_fsexp_acct | Service Expense |
tcgl_fsexp_cc | character | gl_ctrl.gl_fsexp_cc | Service Expense CC |
tcgl_fsexp_sub | character | gl_ctrl.gl_fsexp_sub | Service Expense Sub |
tcgl_fslbr_acct | character | gl_ctrl.gl_fslbr_acct | Service Labor |
tcgl_fslbr_cc | character | gl_ctrl.gl_fslbr_cc | Service Labor CC |
tcgl_fslbr_sub | character | gl_ctrl.gl_fslbr_sub | Service Labor Sub |
tcgl_fsrc_inv_acct | character | gl_ctrl.gl_fsrc_inv_acct | Repair Center Inventory |
tcgl_fsrc_inv_cc | character | gl_ctrl.gl_fsrc_inv_cc | Repair Center Inv CC |
tcgl_fsrc_inv_sub | character | gl_ctrl.gl_fsrc_inv_sub | Repair Center Inv Sub |
tigl_index1 | integer | gl_ctrl.gl_index1 | Index |
tcgl_inv_acct | character | gl_ctrl.gl_inv_acct | Inventory Acct |
tcgl_inv_cc | character | gl_ctrl.gl_inv_cc | Inventory Cost Ctr |
tcgl_inv_sub | character | gl_ctrl.gl_inv_sub | Inventory Sub-Acct |
tcgl_lang | character | gl_ctrl.gl_lang | Default System Language |
tcgl_late_acct | character | gl_ctrl.gl_late_acct | Credit Terms Late Interest Acct |
tcgl_late_cc | character | gl_ctrl.gl_late_cc | Credit Terms Late Interest CC |
tcgl_late_sub | character | gl_ctrl.gl_late_sub | Cr Terms Late Inte Sub |
tcgl_lbr_acct | character | gl_ctrl.gl_lbr_acct | Labor |
tcgl_lbr_cc | character | gl_ctrl.gl_lbr_cc | Labor Cost Ctr |
tcgl_lbr_sub | character | gl_ctrl.gl_lbr_sub | Labor Sub-Acct |
tcgl_lvar_acct | character | gl_ctrl.gl_lvar_acct | Labor Usage Var |
tcgl_lvar_cc | character | gl_ctrl.gl_lvar_cc | Labor Usage Variance CC |
tcgl_lvar_sub | character | gl_ctrl.gl_lvar_sub | Labor Usage Var Sub |
tcgl_lvrr_acct | character | gl_ctrl.gl_lvrr_acct | Labor Rate Var |
tcgl_lvrr_cc | character | gl_ctrl.gl_lvrr_cc | Labor Rate Variance CC |
tcgl_lvrr_sub | character | gl_ctrl.gl_lvrr_sub | Labor Rate Var Sub |
tcgl_mvar_acct | character | gl_ctrl.gl_mvar_acct | Material Usage Var |
tcgl_mvar_cc | character | gl_ctrl.gl_mvar_cc | Material Usage Variance CC |
tcgl_mvar_sub | character | gl_ctrl.gl_mvar_sub | Material Usage Var Sub |
tcgl_mvrr_acct | character | gl_ctrl.gl_mvrr_acct | Material Rate Var |
tcgl_mvrr_cc | character | gl_ctrl.gl_mvrr_cc | Material Rate Variance CC |
tcgl_mvrr_sub | character | gl_ctrl.gl_mvrr_sub | Material Rate Var Sub |
tcgl_ot_acct | character | gl_ctrl.gl_ot_acct | Overtime |
tcgl_ot_cc | character | gl_ctrl.gl_ot_cc | Overtime Cost Ctr |
tcgl_ot_sub | character | gl_ctrl.gl_ot_sub | Overtime Sub-Acct |
tcgl_ovh_acct | character | gl_ctrl.gl_ovh_acct | Overhead Appl Acct |
tcgl_ovh_cc | character | gl_ctrl.gl_ovh_cc | Overhead Appl CC |
tcgl_ovh_sub | character | gl_ctrl.gl_ovh_sub | Overhead Appl Sub-Acct |
tcgl_ppv_acct | character | gl_ctrl.gl_ppv_acct | PO Price Variance |
tcgl_ppv_cc | character | gl_ctrl.gl_ppv_cc | PO Price Var Cost Ctr |
tcgl_ppv_sub | character | gl_ctrl.gl_ppv_sub | PO Price Variance Sub |
tcgl_pur_acct | character | gl_ctrl.gl_pur_acct | Purchases |
tcgl_pur_cc | character | gl_ctrl.gl_pur_cc | Purchases Cost Ctr |
tcgl_pur_sub | character | gl_ctrl.gl_pur_sub | Purchases Sub |
tcgl_rcpt_acct | character | gl_ctrl.gl_rcpt_acct | PO Receipts Acct |
tcgl_rcpt_cc | character | gl_ctrl.gl_rcpt_cc | PO Receipts Cost Ctr |
tcgl_rcpt_sub | character | gl_ctrl.gl_rcpt_sub | PO Receipts Sub-Acct |
tcgl_rcptx_acct | character | gl_ctrl.gl_rcptx_acct | Expensed Item Receipts |
tcgl_rcptx_cc | character | gl_ctrl.gl_rcptx_cc | Expensed Receipts Cost Ctr |
tcgl_rcptx_sub | character | gl_ctrl.gl_rcptx_sub | Exp Item Receipts Sub |
tcgl_rgain_acct | character | gl_ctrl.gl_rgain_acct | Realized Exchange Gain Acct |
tcgl_rgain_cc | character | gl_ctrl.gl_rgain_cc | Realized Exchange Gain CC |
tcgl_rgain_sub | character | gl_ctrl.gl_rgain_sub | Realized Exch Gain Sub |
tcgl_rloss_acct | character | gl_ctrl.gl_rloss_acct | Realized Exchange Loss Acct |
tcgl_rloss_cc | character | gl_ctrl.gl_rloss_cc | Realized Exchange Loss CC |
tcgl_rloss_sub | character | gl_ctrl.gl_rloss_sub | Realized Exch Loss Sub |
tcgl_rmar_acct | character | gl_ctrl.gl_rmar_acct | Service Returns |
tcgl_rmar_cc | character | gl_ctrl.gl_rmar_cc | Service Returns CC |
tcgl_rmar_sub | character | gl_ctrl.gl_rmar_sub | Service Returns Sub |
tcgl_rnd_mthd | character | gl_ctrl.gl_rnd_mthd | Rounding Method |
tcgl_rtns_acct | character | gl_ctrl.gl_rtns_acct | Sales Returns |
tcgl_rtns_cc | character | gl_ctrl.gl_rtns_cc | Returns Cost Ctr |
tcgl_rtns_sub | character | gl_ctrl.gl_rtns_sub | Sales Returns Sub |
tcgl_scrp_acct | character | gl_ctrl.gl_scrp_acct | Scrap |
tcgl_scrp_cc | character | gl_ctrl.gl_scrp_cc | Scrap Cost Ctr |
tcgl_scrp_sub | character | gl_ctrl.gl_scrp_sub | Scrap Sub-Acct |
tcgl_sls_acct | character | gl_ctrl.gl_sls_acct | Sales |
tcgl_sls_cc | character | gl_ctrl.gl_sls_cc | Sales Cost Ctr |
tcgl_sls_sub | character | gl_ctrl.gl_sls_sub | Sales Sub-Account |
tigl_sub_len | integer | gl_ctrl.gl_sub_len | Sub-Module Sub-Account Length |
tcgl_svar_acct | character | gl_ctrl.gl_svar_acct | Subcontract Usage Var |
tcgl_svar_cc | character | gl_ctrl.gl_svar_cc | Subcontract Usage Variance CC |
tcgl_svar_sub | character | gl_ctrl.gl_svar_sub | Sub Usage Var Sub |
tcgl_svrr_acct | character | gl_ctrl.gl_svrr_acct | Subcontract Rate Var |
tcgl_svrr_cc | character | gl_ctrl.gl_svrr_cc | Subcontract Rate Variance CC |
tcgl_svrr_sub | character | gl_ctrl.gl_svrr_sub | Sub Rate Var Sub |
tcgl_symbol | character | gl_ctrl.gl_symbol | Symbol |
tcgl_tax_type | character | gl_ctrl.gl_tax_type | Tax Type |
tcgl_tax1_acct | character | gl_ctrl.gl_tax1_acct | Sales Tax 1 |
tcgl_tax1_cc | character | gl_ctrl.gl_tax1_cc | Tax Cost Ctr |
tcgl_tax2_acct | character | gl_ctrl.gl_tax2_acct | Sales Tax 2 |
tcgl_tax2_cc | character | gl_ctrl.gl_tax2_cc | Tax Cost Ctr |
tcgl_tax3_acct | character | gl_ctrl.gl_tax3_acct | Sales Tax 3 |
tcgl_tax3_cc | character | gl_ctrl.gl_tax3_cc | Tax Cost Ctr |
tcgl_term_acct | character | gl_ctrl.gl_term_acct | Sales Terms |
tcgl_term_cc | character | gl_ctrl.gl_term_cc | Terms Cost Ctr |
tcgl_term_sub | character | gl_ctrl.gl_term_sub | Sales Terms Sub |
tcgl_timezone | character | gl_ctrl.gl_timezone | Server Time Zone |
tcgl_txap_acct | character | gl_ctrl.gl_txap_acct | AP Tax Account |
tcgl_txap_cc | character | gl_ctrl.gl_txap_cc | AP Tax Cost Center |
tcgl_txap_cn_acct | character | gl_ctrl.gl_txap_cn_acct | AP Tax CN Account |
tcgl_txap_cn_sub | character | gl_ctrl.gl_txap_cn_sub | AP Tax CN Sub-Account |
tcgl_txap_sub | character | gl_ctrl.gl_txap_sub | AP Tax Sub-Account |
tcgl_txapr_acct | character | gl_ctrl.gl_txapr_acct | AP Retained Tax Acct |
tcgl_txapr_cc | character | gl_ctrl.gl_txapr_cc | AP Retained Tax CC |
tcgl_txapr_sub | character | gl_ctrl.gl_txapr_sub | AP Retained Tax Sub-Account |
tcgl_txar_acct | character | gl_ctrl.gl_txar_acct | AR Sales Tax Account |
tcgl_txar_cc | character | gl_ctrl.gl_txar_cc | AR Sales Tax CC |
tcgl_txar_cn_acct | character | gl_ctrl.gl_txar_cn_acct | Sales Tax CN Acct |
tcgl_txar_cn_sub | character | gl_ctrl.gl_txar_cn_sub | Sales Tax CN Sub-Account |
tcgl_txar_sub | character | gl_ctrl.gl_txar_sub | AR Sales Tax Sub-Account |
tcgl_txara_acct | character | gl_ctrl.gl_txara_acct | AR Absorbed Tax Acct |
tcgl_txara_cc | character | gl_ctrl.gl_txara_cc | AR Absorbed Tax CC |
tcgl_txara_sub | character | gl_ctrl.gl_txara_sub | AR Absorbed Tax Sub-Account |
tcgl_ugain_acct | character | gl_ctrl.gl_ugain_acct | Unrealized Exchange Gain Acct |
tcgl_ugain_cc | character | gl_ctrl.gl_ugain_cc | Unrealized Exchange Gain CC |
tcgl_ugain_sub | character | gl_ctrl.gl_ugain_sub | Unrealized Exchange Gain Sub |
tcgl_uloss_acct | character | gl_ctrl.gl_uloss_acct | Unrealized Exchange Loss Acct |
tcgl_uloss_cc | character | gl_ctrl.gl_uloss_cc | Unrealized Exchange Loss CC |
tcgl_uloss_sub | character | gl_ctrl.gl_uloss_sub | Unrealized Exchange Loss Sub |
tcgl_user_acct | character | gl_ctrl.gl_user_acct | Exempt Sales Acct |
tcgl_user_cc | character | gl_ctrl.gl_user_cc | Exempt Sales Cost Ctr |
tcgl_user_sub | character | gl_ctrl.gl_user_sub | Exempt Sales Sub-Acct |
tcgl_user1 | character | gl_ctrl.gl_user1 | Ufld1 |
tcgl_user2 | character | gl_ctrl.gl_user2 | Ufld2 |
tlgl_vat | logical | gl_ctrl.gl_vat | Value Added Tax |
tlgl_verify | logical | gl_ctrl.gl_verify | Verify GL Accounts |
tcgl_wip_acct | character | gl_ctrl.gl_wip_acct | Work in Process |
tcgl_wip_cc | character | gl_ctrl.gl_wip_cc | Work in Process Cost Ctr |
tcgl_wip_sub | character | gl_ctrl.gl_wip_sub | Work in Process Sub |
tcgl_wvar_acct | character | gl_ctrl.gl_wvar_acct | Method Variance |
tcgl_wvar_cc | character | gl_ctrl.gl_wvar_cc | Method Variance CC |
tcgl_wvar_sub | character | gl_ctrl.gl_wvar_sub | Method Variance Sub |
tcgl_xfer_acct | character | gl_ctrl.gl_xfer_acct | Transfer Variance |
tcgl_xfer_cc | character | gl_ctrl.gl_xfer_cc | Transfer Variance Cost Ctr |
tcgl_xfer_sub | character | gl_ctrl.gl_xfer_sub | Transfer Variance Sub |
tcgl_xvar_acct | character | gl_ctrl.gl_xvar_acct | Mix Var |
tcgl_xvar_cc | character | gl_ctrl.gl_xvar_cc | Mix Var CC |
tcgl_xvar_sub | character | gl_ctrl.gl_xvar_sub | Mix Var Sub-Acct |
tdoid_gl_ctrl | decimal | gl_ctrl.oid_gl_ctrl | |