aurora_standard.styrtimd

Field Type Null Default Key Extra Comment
rec_card_no int(11) YES
line_no smallint(6) YES
inc_code varchar(6) YES
department varchar(3) YES
inc_rate decimal(18,8) YES
inc_number decimal(18,8) YES
inc_hours decimal(18,8) YES
fac_no varchar(3) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
line_no
TableColumn
aurora_standard.chmmbc41service_line_no
aurora_standard.sticstvrrec_line_no
aurora_standard.stmnotednote_line_no
aurora_standard.stmwarrdwarr_line_no
aurora_standard.stoordrdkit_line_no
aurora_standard.stuinvcdinv_line_no
aurora_standard.stuinvcdpo_line_no
aurora_standard.stuordrdorder_line_no
aurora_standard.stuprcheinv_line_no
aurora_standard.sturectdrec_line_no
aurora_standard.sturectdpo_line_no
aurora_standard.sturqstdpo_line_no
aurora_standard.sturqstdref_line_no
aurora_standard.sturtrndret_line_no
aurora_standard.sturtrndpo_line_no
aurora_standard.sturtrndrec_line_no
aurora_standard.sturtrndinv_line_no
fac_no
TableColumn
aurora_standard.chmpricaprev_fac_no
aurora_standard.chmpricacur_fac_no
aurora_standard.chpcashrcash_fac_no
aurora_standard.chpcobpdcash_fac_no
aurora_standard.chpcobpdbal_fac_no
aurora_standard.chscustddept_fac_no
aurora_standard.chshotlrdept_fac_no
aurora_standard.chtemplrdflt_fac_no
aurora_standard.curs_tempcash_fac_no
aurora_standard.curs_tempap_fac_no
aurora_standard.stgrowpdrod_beg_fac_no
aurora_standard.stgrowpdrod_end_fac_no
aurora_standard.stpcashddist_fac_no
aurora_standard.stpcashddisc_fac_no
aurora_standard.stpcashecash_fac_no
aurora_standard.stpcntrccash_fac_no
aurora_standard.stpcntrcdisc_fac_no
aurora_standard.stpinvcecash_fac_no
aurora_standard.stpopendap_fac_no
aurora_standard.stpopendcash_fac_no
aurora_standard.stucntrccash_fac_no
aurora_standard.stuinvcecash_fac_no
aurora_standard.stxfinsdfin_fac_no
aurora_standard.styaccrrliab_fac_no
aurora_standard.styaccrrexpense_fac_no
aurora_standard.styemplrcash_fac_no
aurora_standard.stypayfdcash_fac_no
aurora_standard.stypayodbal_fac_no
aurora_standard.stypayrecash_fac_no
aurora_standard.styrevsdcash_fac_no
aurora_standard.stytypercash_fac_no
inc_code
TableColumn
aurora_standard.chtclokdpaid_inc_code
aurora_standard.chteshtdshift_inc_code
aurora_standard.chteshtdother_inc_code
aurora_standard.chteshtdhol_inc_code
aurora_standard.chtshftcshift_inc_code
aurora_standard.chtshftcother_inc_code
aurora_standard.chtshftcholiday_inc_code
aurora_standard.hhtclokdpaid_inc_code
aurora_standard.jkyemppdaccr_inc_code
aurora_standard.stycincdpy_inc_code
aurora_standard.stycntrcbase_inc_code
aurora_standard.styemppdaccr_inc_code
aurora_standard.styinccrot_base_inc_code
aurora_standard.styptodvhrs_used_inc_code
aurora_standard.timetablpaid_inc_code
department
TableColumn
aurora_standard.curs_tempcash_department
aurora_standard.sticntrcuse_department
aurora_standard.stpcashddist_department
aurora_standard.stpcashddisc_department
aurora_standard.stpcashecash_department
aurora_standard.stpcasheoa_department
aurora_standard.stpinvcedisc_department
aurora_standard.stpinvceap_department
aurora_standard.stpinvcecash_department
aurora_standard.stpopendap_department
aurora_standard.stpopendcash_department
aurora_standard.stpvendrcash_department
aurora_standard.stpvendrexp_department
aurora_standard.strcashddist_department
aurora_standard.strcashddisc_department
aurora_standard.strcashecash_department
aurora_standard.strcasheoa_department
aurora_standard.strinvcedisc_department
aurora_standard.strinvcetax_department
aurora_standard.strinvcefrght_department
aurora_standard.strinvcemisc_department
aurora_standard.strinvcear_department
aurora_standard.stropendar_department
aurora_standard.stucntrcuse_department
aurora_standard.styapckddist_department
aurora_standard.stydeddvhome_department
aurora_standard.stydeddvgl_department
aurora_standard.styincdvhome_department
aurora_standard.styincdvgl_department
aurora_standard.styobldvhome_department
aurora_standard.styobldvgl_department
aurora_standard.styptodvhome_department
common.service_ticketsstc_department