aurora_standard.stoinvce

Field Type Null Default Key Extra Comment
doc_no int(11) YES MUL
order_no varchar(10) YES
bill_to_code varchar(6) YES
sell_to_code varchar(6) YES
ship_to_code varchar(6) YES
inv_doc_no int(11) YES
stage varchar(3) YES
inv_no varchar(10) YES
inv_date date YES
inv_printed varchar(1) YES
ok_to_post varchar(1) YES
terms_code varchar(6) YES
terms_approval varchar(6) YES
pay_method varchar(6) YES
payment varchar(1) YES
card_no varchar(20) YES
exp_date varchar(5) YES
check_no varchar(8) YES
fob_point varchar(15) YES
ship_via varchar(15) YES
ship_weight decimal(10,0) YES
freight_doc varchar(15) YES
st_tx_code varchar(6) YES
co_tx_code varchar(6) YES
ci_tx_code varchar(6) YES
st_tx_rate decimal(6,0) YES
co_tx_rate decimal(6,0) YES
ci_tx_rate decimal(6,0) YES
tax_rate decimal(6,0) YES
trd_ds_rate decimal(6,0) YES
item_amount decimal(12,0) YES
discountable decimal(12,0) YES
trd_ds_amount decimal(12,0) YES
taxable decimal(12,0) YES
st_tx_amount decimal(12,0) YES
co_tx_amount decimal(12,0) YES
ci_tx_amount decimal(12,0) YES
frght_amount decimal(12,0) YES
total_amount decimal(12,0) YES
td_ds_acct int(11) YES
st_tx_acct int(11) YES
co_tx_acct int(11) YES
ci_tx_acct int(11) YES
freight_acct int(11) YES
asset_acct int(11) YES
td_ds_dept varchar(3) YES
st_tx_dept varchar(3) YES
co_tx_dept varchar(3) YES
ci_tx_dept varchar(3) YES
freight_dept varchar(3) YES
asset_dept varchar(3) YES
mtaxg_code varchar(6) YES
tax_amount decimal(12,0) YES
currency_code varchar(3) YES
curr_rate_type varchar(6) YES
currency_rate decimal(16,0) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
payment
TableColumn
HSPI_CURES2015_B1.ipf_responsefederal_payment
HSPI_Central_Hospital.ipf_responsefederal_payment
HSPI_Dewitt.ipf_responsefederal_payment
HSPI_Fulton.ipf_responsefederal_payment
HSPI_Inferno.ipf_responsefederal_payment
HSPI_MU2015_E1.ipf_responsefederal_payment
HSPI_MU2015_G2.ipf_responsefederal_payment
HSPI_MU2015_G9.ipf_responsefederal_payment
HSPI_Sandbox.ipf_responsefederal_payment
HSPI_Summit_General.ipf_responsefederal_payment
HSPI_United_Physicians.ipf_responsefederal_payment
MPI.ipf_responsefederal_payment
_1.billing_codesbil_patient_payment
_1.encounters_paymentsepay_bil_id_payment
_1188.billing_codesbil_patient_payment
_1188.encounters_paymentsepay_bil_id_payment
_1218.billing_codesbil_patient_payment
_1218.encounters_paymentsepay_bil_id_payment
_1548.billing_codesbil_patient_payment
_1548.encounters_paymentsepay_bil_id_payment
_435.billing_codesbil_patient_payment
_435.encounters_paymentsepay_bil_id_payment
_436.billing_codesbil_patient_payment
_436.encounters_paymentsepay_bil_id_payment
_436_archive_testing.billing_codesbil_patient_payment
_436_archive_testing.encounters_paymentsepay_bil_id_payment
_437.billing_codesbil_patient_payment
_437.encounters_paymentsepay_bil_id_payment
_8.billing_codesbil_patient_payment
_8.daily_close_calculationsdcc_found_unapplied_payment
_8.daily_close_calculationsdcc_bil_patient_payment
_8.encounters_paymentsepay_bil_id_payment
_81.billing_codesbil_patient_payment
_81.encounters_paymentsepay_bil_id_payment
_999.billing_codesbil_patient_payment
_999.encounters_paymentsepay_bil_id_payment
aurora_standard.chmblogdlab_payment
aurora_standard.chmcontctimely_payment
aurora_standard.chmcontrdown_payment
aurora_standard.chmmbc50source_of_payment
aurora_standard.chmplogdlab_payment
aurora_standard.logdetldlab_payment
aurora_standard.stxratidprincipal_payment
common.billing_codesbil_patient_payment
exp_date
TableColumn
_1.patients_payment_methodspatpm_exp_date
_1188.patients_payment_methodspatpm_exp_date
_1218.patients_payment_methodspatpm_exp_date
_1548.patients_payment_methodspatpm_exp_date
_435.patients_payment_methodspatpm_exp_date
_436.patients_payment_methodspatpm_exp_date
_436_archive_testing.patients_payment_methodspatpm_exp_date
_437.patients_payment_methodspatpm_exp_date
_8.patients_payment_methodspatpm_exp_date
_81.patients_payment_methodspatpm_exp_date
_999.patients_payment_methodspatpm_exp_date
aurora_standard.bhphybakdea_exp_date
aurora_standard.c8phydea_exp_date
aurora_standard.chmphyncdea_exp_date
aurora_standard.chpempidlicense_exp_date
aurora_standard.chqcarddcardiac_exp_date
aurora_standard.chqliabdliab_pol_exp_date
aurora_standard.chqlicndlic_exp_date
aurora_standard.chqphyncbrd_cert_exp_date
aurora_standard.vault_providersdea_exp_date
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.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
order_no
TableColumn
aurora_standard.chmpintrrx_order_no
stage
TableColumn
aurora_standard.gary1line_stage
aurora_standard.stoordrdhi_stage
aurora_standard.stoordrdlo_stage
aurora_standard.stoordrehi_stage
aurora_standard.stoordrelo_stage
aurora_standard.stuordrdline_stage
aurora_standard.stuordrepo_stage
aurora_standard.sturqstdline_stage
aurora_standard.sturtrndpo_line_stage
taxable
TableColumn
aurora_standard.oddpayreinc_taxable
aurora_standard.odhpayreinc_taxable
aurora_standard.stpinvceinternet_taxable
aurora_standard.stpopendinternet_taxable
aurora_standard.stuinvceinternet_taxable
aurora_standard.stypayreinc_taxable
inv_no
TableColumn
aurora_standard.stpinchdold_inv_no
aurora_standard.stpinchdnew_inv_no
aurora_standard.strcntrclast_inv_no
card_no
TableColumn
aurora_standard.stpvendrcredit_card_no
aurora_standard.styrtimdrec_card_no
aurora_standard.styrtimerec_card_no
currency_code
TableColumn
aurora_standard.stxdcrtrfrom_currency_code
aurora_standard.stxdcrtrto_currency_code
aurora_standard.stxpcrtrfrom_currency_code
aurora_standard.stxpcrtrto_currency_code
tax_rate
TableColumn
aurora_standard.stystwhrfed_tax_rate
total_amount
TableColumn
common.rcm_stats_agingrcmsa_total_amount