aurora_standard.reqbuild

Field Type Null Default Key Extra Comment
department varchar(3) YES
vend_code varchar(6) YES
item_code varchar(20) YES
doc_no 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
item_code
TableColumn
aurora_standard.chmbitmdvend_item_code
aurora_standard.chmschgdvend_item_code
aurora_standard.glstrackp_item_code
aurora_standard.glstrackm_item_code
aurora_standard.icactvvvend_item_code
aurora_standard.stiixrefvend_item_code
aurora_standard.stmaintdmaint_po_item_code
aurora_standard.stuctlgdvend_item_code
aurora_standard.sturqstdvend_item_code
aurora_standard.tmpctlgdvend_item_code
aurora_standard.tmplvl2vend_item_code
aurora_standard.tmplvl3vend_item_code
aurora_standard.tmpparlvlvend_item_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
vend_code
TableColumn
aurora_standard.vndxrefold_vend_code
aurora_standard.vndxrefnew_vend_code