aurora_standard.stiselld

Field Type Null Default Key Extra Comment
doc_no int(11) YES MUL
line_no smallint(6) YES
item_code varchar(20) YES
warehouse_code varchar(10) YES
sell_qty decimal(10,2) YES
price decimal(12,2) YES
sell_factor decimal(6,2) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
price
TableColumn
_1.clients_fee_schedules_mapcfsm_price
_1.cpt_analysis_codescac_price
_1.hl7_ordersord_lo_list_price
_1.labs_orderslo_cost_price
_1.labs_orderslo_list_price
_1.labs_orders_clients_pricinglocp_client_price
_1188.clients_fee_schedules_mapcfsm_price
_1188.cpt_analysis_codescac_price
_1188.hl7_ordersord_lo_list_price
_1188.labs_orderslo_cost_price
_1188.labs_orderslo_list_price
_1188.labs_orders_clients_pricinglocp_client_price
_1218.clients_fee_schedules_mapcfsm_price
_1218.cpt_analysis_codescac_price
_1218.hl7_ordersord_lo_list_price
_1218.labs_orderslo_cost_price
_1218.labs_orderslo_list_price
_1218.labs_orders_clients_pricinglocp_client_price
_1548.clients_fee_schedules_mapcfsm_price
_1548.cpt_analysis_codescac_price
_1548.hl7_ordersord_lo_list_price
_1548.labs_orderslo_cost_price
_1548.labs_orderslo_list_price
_1548.labs_orders_clients_pricinglocp_client_price
_435.clients_fee_schedules_mapcfsm_price
_435.cpt_analysis_codescac_price
_435.hl7_ordersord_lo_list_price
_435.labs_orderslo_cost_price
_435.labs_orderslo_list_price
_435.labs_orders_clients_pricinglocp_client_price
_436.clients_fee_schedules_mapcfsm_price
_436.cpt_analysis_codescac_price
_436.hl7_ordersord_lo_list_price
_436.labs_orderslo_cost_price
_436.labs_orderslo_list_price
_436.labs_orders_clients_pricinglocp_client_price
_436_archive_testing.clients_fee_schedules_mapcfsm_price
_436_archive_testing.cpt_analysis_codescac_price
_436_archive_testing.hl7_ordersord_lo_list_price
_436_archive_testing.labs_orderslo_cost_price
_436_archive_testing.labs_orderslo_list_price
_436_archive_testing.labs_orders_clients_pricinglocp_client_price
_437.clients_fee_schedules_mapcfsm_price
_437.cpt_analysis_codescac_price
_437.hl7_ordersord_lo_list_price
_437.labs_orderslo_cost_price
_437.labs_orderslo_list_price
_437.labs_orders_clients_pricinglocp_client_price
_8.clients_fee_schedules_mapcfsm_price
_8.cpt_analysis_codescac_price
_8.hl7_ordersord_lo_list_price
_8.labs_orderslo_cost_price
_8.labs_orderslo_list_price
_8.labs_orders_clients_pricinglocp_client_price
_81.clients_fee_schedules_mapcfsm_price
_81.cpt_analysis_codescac_price
_81.hl7_ordersord_lo_list_price
_81.labs_orderslo_cost_price
_81.labs_orderslo_list_price
_81.labs_orders_clients_pricinglocp_client_price
_999.clients_fee_schedules_mapcfsm_price
_999.cpt_analysis_codescac_price
_999.hl7_ordersord_lo_list_price
_999.labs_orderslo_cost_price
_999.labs_orderslo_list_price
_999.labs_orders_clients_pricinglocp_client_price
aurora_standard.chrdrugcawp_unit_price
aurora_standard.chrdrugcdp_unit_price
aurora_standard.chrraterminimum_price
aurora_standard.chrraterround_price
aurora_standard.gary13sum_price
aurora_standard.gary2sum_net_price
aurora_standard.itemstotal_price
aurora_standard.lngdrgwac_cur_price
aurora_standard.lngdrgwac_cur_unit_price
aurora_standard.lngdrgawp_cur_price
aurora_standard.lngdrgawp_cur_unit_price
aurora_standard.lngdrgdp_cur_price
aurora_standard.lngdrgdp_cur_unit_price
aurora_standard.lngdrgful_cur_price
aurora_standard.lngdrgful_cur_unit_price
aurora_standard.lngdrgsrp_cur_price
aurora_standard.lngdrgsrp_cur_unit_price
aurora_standard.stiinvtrmarket_price
aurora_standard.stockunit_price
aurora_standard.stoshipdorig_price
aurora_standard.stoshipdretail_price
aurora_standard.stuabcdorig_price
aurora_standard.stuabcdprintback_price
aurora_standard.stuinvcdnet_price
aurora_standard.stultyprupdate_price
aurora_standard.stuordrdnet_price
aurora_standard.stuprcheold_price
aurora_standard.stuprchenew_price
aurora_standard.ttiinvtrmarket_price
common.test_codestco_x_price
common.users_permissionsupr_fee_schedule_override_price
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
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