aurora_standard.styrevsd

Field Type Null Default Key Extra Comment
post_no int(11) YES
doc_no int(11) YES
doc_date date YES
pay_date date YES
empl_code varchar(6) YES
check_no varchar(10) YES
cash_amount decimal(12,2) YES
cash_acct_no int(11) YES
department varchar(3) YES
eop_date date YES
total_hours decimal(12,2) YES
liab_acct int(11) YES
cash_fac_no varchar(3) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
doc_no
TableColumn
aurora_standard.audpadjdpy_doc_no
aurora_standard.chmgltrcar_doc_no
aurora_standard.chmgltrcrm_doc_no
aurora_standard.chmgltrcip_doc_no
aurora_standard.chmgltrcop_doc_no
aurora_standard.chmgltrcr3_doc_no
aurora_standard.chmgltrcr4_doc_no
aurora_standard.chmgltrccr_doc_no
aurora_standard.chmgltrcaj_doc_no
aurora_standard.chmgltrcnr_doc_no
aurora_standard.chmgltrcnc_doc_no
aurora_standard.chmgltrcfc_doc_no
aurora_standard.chmpadjdpy_doc_no
aurora_standard.chmrefndcheck_doc_no
aurora_standard.discountsinv_doc_no
aurora_standard.odhpayddpy_doc_no
aurora_standard.odhpayidpy_doc_no
aurora_standard.odhpayodpy_doc_no
aurora_standard.odhpayrepy_doc_no
aurora_standard.stfcntrcfa_doc_no
aurora_standard.stgcntrcgenjrn_doc_no
aurora_standard.stgcntrcstdent_doc_no
aurora_standard.sticstvrrec_doc_no
aurora_standard.stoinvceinv_doc_no
aurora_standard.stoordreorig_doc_no
aurora_standard.stoordreinv_doc_no
aurora_standard.stoshipdinv_doc_no
aurora_standard.stoshipdpo_doc_no
aurora_standard.stpactvdinv_doc_no
aurora_standard.stpactvvinv_doc_no
aurora_standard.stpcashdinv_doc_no
aurora_standard.stpcntrcap_doc_no
aurora_standard.stpcntrccd_doc_no
aurora_standard.stpvoidrchk_doc_no
aurora_standard.stractvdinv_doc_no
aurora_standard.stractvvinv_doc_no
aurora_standard.strcashdinv_doc_no
aurora_standard.strcntrcar_doc_no
aurora_standard.strcntrccr_doc_no
aurora_standard.stucntrcreq_doc_no
aurora_standard.stucntrcpo_doc_no
aurora_standard.stucntrcrec_doc_no
aurora_standard.stucntrcinv_doc_no
aurora_standard.stucntrcret_doc_no
aurora_standard.stuinvcdinv_doc_no
aurora_standard.stuinvcdpo_doc_no
aurora_standard.stuinvceinv_doc_no
aurora_standard.stuinvcepo_doc_no
aurora_standard.stuordrdorder_doc_no
aurora_standard.stuordreorig_doc_no
aurora_standard.stuordreorder_doc_no
aurora_standard.stuprcheinv_doc_no
aurora_standard.sturectdrec_doc_no
aurora_standard.sturectdpo_doc_no
aurora_standard.sturecterec_doc_no
aurora_standard.sturectepo_doc_no
aurora_standard.sturqstdpo_doc_no
aurora_standard.sturqstdref_doc_no
aurora_standard.sturtrndret_doc_no
aurora_standard.sturtrndpo_doc_no
aurora_standard.sturtrndrec_doc_no
aurora_standard.sturtrndinv_doc_no
aurora_standard.sturtrneret_doc_no
aurora_standard.stxmtaxdinv_doc_no
aurora_standard.stxtaxldinv_doc_no
aurora_standard.stycdeddpy_doc_no
aurora_standard.stycincdpy_doc_no
aurora_standard.stycntrcpy_doc_no
aurora_standard.stypayarpy_doc_no
aurora_standard.stypddrdpy_doc_no
aurora_standard.styvoidepay_doc_no
pay_date
TableColumn
aurora_standard.chmadmqrself_pay_date
aurora_standard.chmagesdlast_pay_date
aurora_standard.chpcobrdfirst_pay_date
aurora_standard.stpinvceto_pay_date
aurora_standard.stpopendto_pay_date
aurora_standard.stpopendlast_pay_date
aurora_standard.stpvendrlast_pay_date
aurora_standard.strcustrlast_pay_date
aurora_standard.stropendlast_pay_date
post_no
TableColumn
aurora_standard.chmgltrcar_post_no
aurora_standard.stfcntrcfa_post_no
aurora_standard.stgcntrcgenjrn_post_no
aurora_standard.stgcntrcgenled_post_no
aurora_standard.stpcntrcap_post_no
aurora_standard.stpcntrccd_post_no
aurora_standard.strcntrcar_post_no
aurora_standard.strcntrccr_post_no
aurora_standard.stucntrcreq_post_no
aurora_standard.stucntrcrec_post_no
aurora_standard.stucntrcinv_post_no
aurora_standard.stucntrcret_post_no
aurora_standard.stuinvceinv_post_no
aurora_standard.sturqstdreq_post_no
aurora_standard.stycntrcpy_post_no
eop_date
TableColumn
aurora_standard.chtesigdta_eop_date
aurora_standard.chtwkhrdcarry_eop_date
empl_code
TableColumn
aurora_standard.chtsupvcsupv_empl_code
aurora_standard.stypddrdadj_empl_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
cash_acct_no
TableColumn
aurora_standard.stpcntrccd_cash_acct_no
aurora_standard.strcntrccr_cash_acct_no