aurora_standard.stpactvv

Field Type Null Default Key Extra Comment
orig_journal varchar(2) YES
doc_no int(11) YES
post_no int(11) YES
post_date date YES
doc_date date YES
ref_code varchar(6) YES
doc_desc varchar(30) YES
inv_chk_no varchar(15) YES
doc_type varchar(2) YES
act_type varchar(1) YES
inv_doc_no int(11) YES
amount decimal(12,2) YES

References

Local Column References
amount
TableColumn
HSPI_CURES2015_B1.invoice_generation_rule_setsminimum_amount
HSPI_Central_Hospital.invoice_generation_rule_setsminimum_amount
HSPI_Dewitt.invoice_generation_rule_setsminimum_amount
HSPI_Fulton.invoice_generation_rule_setsminimum_amount
HSPI_Inferno.invoice_generation_rule_setsminimum_amount
HSPI_MU2015_E1.invoice_generation_rule_setsminimum_amount
HSPI_MU2015_G2.invoice_generation_rule_setsminimum_amount
HSPI_MU2015_G9.invoice_generation_rule_setsminimum_amount
HSPI_Sandbox.invoice_generation_rule_setsminimum_amount
HSPI_Summit_General.invoice_generation_rule_setsminimum_amount
HSPI_United_Physicians.invoice_generation_rule_setsminimum_amount
MPI.invoice_generation_rule_setsminimum_amount
_1.billing_codesbil_negative_amount
_1.billing_codesbil_positive_amount
_1.encounters_paymentsepay_amount
_1.encounters_ub04enc_ub04_39_a_amount
_1.encounters_ub04enc_ub04_39_b_amount
_1.encounters_ub04enc_ub04_39_c_amount
_1.encounters_ub04enc_ub04_39_d_amount
_1.encounters_ub04enc_ub04_40_a_amount
_1.encounters_ub04enc_ub04_40_b_amount
_1.encounters_ub04enc_ub04_40_c_amount
_1.encounters_ub04enc_ub04_40_d_amount
_1.encounters_ub04enc_ub04_41_a_amount
_1.encounters_ub04enc_ub04_41_b_amount
_1.encounters_ub04enc_ub04_41_c_amount
_1.encounters_ub04enc_ub04_41_d_amount
_1.insurances_allowables_cpt_mapiacm_amount
_1.insurances_contracted_pricingicp_amount
_1.ledgerled_amount
_1.ledgerled_orig_amount
_1.ledgerled_unit_amount
_1.patient_finance_recordspfr_min_due_amount
_1.patientspat_min_due_amount
_1.patients_immunizationspim_administered_amount
_1.patients_immunizations_templatespimt_administered_amount
_1.patients_inventorypinv_administered_amount
_1.patients_payments_schedulespps_amount
_1.patients_responsibility_estimatesprest_allowed_amount
_1.patients_responsibility_estimates_servicesprests_allowed_amount
_1.pre_services_line_adjustmentsprestsla_amount
_1.voided_paymentsvp_amount
_1.voided_paymentsvp_orig_amount
_1188.billing_codesbil_negative_amount
_1188.billing_codesbil_positive_amount
_1188.encounters_paymentsepay_amount
_1188.encounters_ub04enc_ub04_39_a_amount
_1188.encounters_ub04enc_ub04_39_b_amount
_1188.encounters_ub04enc_ub04_39_c_amount
_1188.encounters_ub04enc_ub04_39_d_amount
_1188.encounters_ub04enc_ub04_40_a_amount
_1188.encounters_ub04enc_ub04_40_b_amount
_1188.encounters_ub04enc_ub04_40_c_amount
_1188.encounters_ub04enc_ub04_40_d_amount
_1188.encounters_ub04enc_ub04_41_a_amount
_1188.encounters_ub04enc_ub04_41_b_amount
_1188.encounters_ub04enc_ub04_41_c_amount
_1188.encounters_ub04enc_ub04_41_d_amount
_1188.insurances_allowables_cpt_mapiacm_amount
_1188.insurances_contracted_pricingicp_amount
_1188.ledgerled_amount
_1188.ledgerled_orig_amount
_1188.ledgerled_unit_amount
_1188.patient_finance_recordspfr_min_due_amount
_1188.patientspat_min_due_amount
_1188.patients_immunizationspim_administered_amount
_1188.patients_immunizations_templatespimt_administered_amount
_1188.patients_inventorypinv_administered_amount
_1188.patients_payments_schedulespps_amount
_1188.patients_responsibility_estimatesprest_allowed_amount
_1188.patients_responsibility_estimates_servicesprests_allowed_amount
_1188.pre_services_line_adjustmentsprestsla_amount
_1188.voided_paymentsvp_amount
_1188.voided_paymentsvp_orig_amount
_1218.billing_codesbil_negative_amount
_1218.billing_codesbil_positive_amount
_1218.encounters_paymentsepay_amount
_1218.encounters_ub04enc_ub04_39_a_amount
_1218.encounters_ub04enc_ub04_39_b_amount
_1218.encounters_ub04enc_ub04_39_c_amount
_1218.encounters_ub04enc_ub04_39_d_amount
_1218.encounters_ub04enc_ub04_40_a_amount
_1218.encounters_ub04enc_ub04_40_b_amount
_1218.encounters_ub04enc_ub04_40_c_amount
_1218.encounters_ub04enc_ub04_40_d_amount
_1218.encounters_ub04enc_ub04_41_a_amount
_1218.encounters_ub04enc_ub04_41_b_amount
_1218.encounters_ub04enc_ub04_41_c_amount
_1218.encounters_ub04enc_ub04_41_d_amount
_1218.insurances_allowables_cpt_mapiacm_amount
_1218.insurances_contracted_pricingicp_amount
_1218.led_temporary_ledger_table_ANMled_amount
_1218.led_temporary_ledger_table_ANMled_orig_amount
_1218.ledgerled_amount
_1218.ledgerled_orig_amount
_1218.ledgerled_unit_amount
_1218.patient_finance_recordspfr_min_due_amount
_1218.patientspat_min_due_amount
_1218.patients_immunizationspim_administered_amount
_1218.patients_immunizations_templatespimt_administered_amount
_1218.patients_inventorypinv_administered_amount
_1218.patients_payments_schedulespps_amount
_1218.patients_responsibility_estimatesprest_allowed_amount
_1218.patients_responsibility_estimates_servicesprests_allowed_amount
_1218.pre_services_line_adjustmentsprestsla_amount
_1218.voided_paymentsvp_amount
_1218.voided_paymentsvp_orig_amount
_1548.billing_codesbil_negative_amount
_1548.billing_codesbil_positive_amount
_1548.encounters_paymentsepay_amount
_1548.encounters_ub04enc_ub04_39_a_amount
_1548.encounters_ub04enc_ub04_39_b_amount
_1548.encounters_ub04enc_ub04_39_c_amount
_1548.encounters_ub04enc_ub04_39_d_amount
_1548.encounters_ub04enc_ub04_40_a_amount
_1548.encounters_ub04enc_ub04_40_b_amount
_1548.encounters_ub04enc_ub04_40_c_amount
_1548.encounters_ub04enc_ub04_40_d_amount
_1548.encounters_ub04enc_ub04_41_a_amount
_1548.encounters_ub04enc_ub04_41_b_amount
_1548.encounters_ub04enc_ub04_41_c_amount
_1548.encounters_ub04enc_ub04_41_d_amount
_1548.insurances_allowables_cpt_mapiacm_amount
_1548.insurances_contracted_pricingicp_amount
_1548.ledgerled_amount
_1548.ledgerled_orig_amount
_1548.ledgerled_unit_amount
_1548.patient_finance_recordspfr_min_due_amount
_1548.patientspat_min_due_amount
_1548.patients_immunizationspim_administered_amount
_1548.patients_immunizations_templatespimt_administered_amount
_1548.patients_inventorypinv_administered_amount
_1548.patients_payments_schedulespps_amount
_1548.patients_responsibility_estimatesprest_allowed_amount
_1548.patients_responsibility_estimates_servicesprests_allowed_amount
_1548.pre_services_line_adjustmentsprestsla_amount
_1548.voided_paymentsvp_amount
_1548.voided_paymentsvp_orig_amount
_435.billing_codesbil_negative_amount
_435.billing_codesbil_positive_amount
_435.encounters_paymentsepay_amount
_435.encounters_ub04enc_ub04_39_a_amount
_435.encounters_ub04enc_ub04_39_b_amount
_435.encounters_ub04enc_ub04_39_c_amount
_435.encounters_ub04enc_ub04_39_d_amount
_435.encounters_ub04enc_ub04_40_a_amount
_435.encounters_ub04enc_ub04_40_b_amount
_435.encounters_ub04enc_ub04_40_c_amount
_435.encounters_ub04enc_ub04_40_d_amount
_435.encounters_ub04enc_ub04_41_a_amount
_435.encounters_ub04enc_ub04_41_b_amount
_435.encounters_ub04enc_ub04_41_c_amount
_435.encounters_ub04enc_ub04_41_d_amount
_435.insurances_allowables_cpt_mapiacm_amount
_435.insurances_contracted_pricingicp_amount
_435.ledgerled_amount
_435.ledgerled_orig_amount
_435.ledgerled_unit_amount
_435.patient_finance_recordspfr_min_due_amount
_435.patientspat_min_due_amount
_435.patients_immunizationspim_administered_amount
_435.patients_immunizations_templatespimt_administered_amount
_435.patients_inventorypinv_administered_amount
_435.patients_payments_schedulespps_amount
_435.patients_responsibility_estimatesprest_allowed_amount
_435.patients_responsibility_estimates_servicesprests_allowed_amount
_435.pre_services_line_adjustmentsprestsla_amount
_435.voided_paymentsvp_amount
_435.voided_paymentsvp_orig_amount
_436.billing_codesbil_negative_amount
_436.billing_codesbil_positive_amount
_436.encounters_paymentsepay_amount
_436.encounters_ub04enc_ub04_39_a_amount
_436.encounters_ub04enc_ub04_39_b_amount
_436.encounters_ub04enc_ub04_39_c_amount
_436.encounters_ub04enc_ub04_39_d_amount
_436.encounters_ub04enc_ub04_40_a_amount
_436.encounters_ub04enc_ub04_40_b_amount
_436.encounters_ub04enc_ub04_40_c_amount
_436.encounters_ub04enc_ub04_40_d_amount
_436.encounters_ub04enc_ub04_41_a_amount
_436.encounters_ub04enc_ub04_41_b_amount
_436.encounters_ub04enc_ub04_41_c_amount
_436.encounters_ub04enc_ub04_41_d_amount
_436.insurances_allowables_cpt_mapiacm_amount
_436.insurances_contracted_pricingicp_amount
_436.ledgerled_amount
_436.ledgerled_orig_amount
_436.ledgerled_unit_amount
_436.patient_finance_recordspfr_min_due_amount
_436.patientspat_min_due_amount
_436.patients_immunizationspim_administered_amount
_436.patients_immunizations_templatespimt_administered_amount
_436.patients_inventorypinv_administered_amount
_436.patients_payments_schedulespps_amount
_436.patients_responsibility_estimatesprest_allowed_amount
_436.patients_responsibility_estimates_servicesprests_allowed_amount
_436.pre_services_line_adjustmentsprestsla_amount
_436.voided_paymentsvp_amount
_436.voided_paymentsvp_orig_amount
_436_archive_testing.billing_codesbil_negative_amount
_436_archive_testing.billing_codesbil_positive_amount
_436_archive_testing.encounters_paymentsepay_amount
_436_archive_testing.encounters_ub04enc_ub04_39_a_amount
_436_archive_testing.encounters_ub04enc_ub04_39_b_amount
_436_archive_testing.encounters_ub04enc_ub04_39_c_amount
_436_archive_testing.encounters_ub04enc_ub04_39_d_amount
_436_archive_testing.encounters_ub04enc_ub04_40_a_amount
_436_archive_testing.encounters_ub04enc_ub04_40_b_amount
_436_archive_testing.encounters_ub04enc_ub04_40_c_amount
_436_archive_testing.encounters_ub04enc_ub04_40_d_amount
_436_archive_testing.encounters_ub04enc_ub04_41_a_amount
_436_archive_testing.encounters_ub04enc_ub04_41_b_amount
_436_archive_testing.encounters_ub04enc_ub04_41_c_amount
_436_archive_testing.encounters_ub04enc_ub04_41_d_amount
_436_archive_testing.insurances_allowables_cpt_mapiacm_amount
_436_archive_testing.insurances_contracted_pricingicp_amount
_436_archive_testing.ledgerled_amount
_436_archive_testing.ledgerled_orig_amount
_436_archive_testing.ledgerled_unit_amount
_436_archive_testing.patient_finance_recordspfr_min_due_amount
_436_archive_testing.patientspat_min_due_amount
_436_archive_testing.patients_immunizationspim_administered_amount
_436_archive_testing.patients_immunizations_templatespimt_administered_amount
_436_archive_testing.patients_inventorypinv_administered_amount
_436_archive_testing.patients_payments_schedulespps_amount
_436_archive_testing.patients_responsibility_estimatesprest_allowed_amount
_436_archive_testing.patients_responsibility_estimates_servicesprests_allowed_amount
_436_archive_testing.pre_services_line_adjustmentsprestsla_amount
_436_archive_testing.voided_paymentsvp_amount
_436_archive_testing.voided_paymentsvp_orig_amount
_437.billing_codesbil_negative_amount
_437.billing_codesbil_positive_amount
_437.encounters_paymentsepay_amount
_437.encounters_ub04enc_ub04_39_a_amount
_437.encounters_ub04enc_ub04_39_b_amount
_437.encounters_ub04enc_ub04_39_c_amount
_437.encounters_ub04enc_ub04_39_d_amount
_437.encounters_ub04enc_ub04_40_a_amount
_437.encounters_ub04enc_ub04_40_b_amount
_437.encounters_ub04enc_ub04_40_c_amount
_437.encounters_ub04enc_ub04_40_d_amount
_437.encounters_ub04enc_ub04_41_a_amount
_437.encounters_ub04enc_ub04_41_b_amount
_437.encounters_ub04enc_ub04_41_c_amount
_437.encounters_ub04enc_ub04_41_d_amount
_437.insurances_allowables_cpt_mapiacm_amount
_437.insurances_contracted_pricingicp_amount
_437.ledgerled_amount
_437.ledgerled_orig_amount
_437.ledgerled_unit_amount
_437.patient_finance_recordspfr_min_due_amount
_437.patientspat_min_due_amount
_437.patients_immunizationspim_administered_amount
_437.patients_immunizations_templatespimt_administered_amount
_437.patients_inventorypinv_administered_amount
_437.patients_payments_schedulespps_amount
_437.patients_responsibility_estimatesprest_allowed_amount
_437.patients_responsibility_estimates_servicesprests_allowed_amount
_437.pre_services_line_adjustmentsprestsla_amount
_437.voided_paymentsvp_amount
_437.voided_paymentsvp_orig_amount
_8.billing_codesbil_negative_amount
_8.billing_codesbil_positive_amount
_8.daily_close_calculationsdcc_last_payment_amount
_8.daily_close_calculationsdcc_bil_negative_amount
_8.daily_close_calculationsdcc_bil_positive_amount
_8.daily_close_calculationsdcc_led_amount
_8.daily_close_calculationsdcc_led_orig_amount
_8.encounters_paymentsepay_amount
_8.encounters_ub04enc_ub04_39_a_amount
_8.encounters_ub04enc_ub04_39_b_amount
_8.encounters_ub04enc_ub04_39_c_amount
_8.encounters_ub04enc_ub04_39_d_amount
_8.encounters_ub04enc_ub04_40_a_amount
_8.encounters_ub04enc_ub04_40_b_amount
_8.encounters_ub04enc_ub04_40_c_amount
_8.encounters_ub04enc_ub04_40_d_amount
_8.encounters_ub04enc_ub04_41_a_amount
_8.encounters_ub04enc_ub04_41_b_amount
_8.encounters_ub04enc_ub04_41_c_amount
_8.encounters_ub04enc_ub04_41_d_amount
_8.insurances_allowables_cpt_mapiacm_amount
_8.insurances_contracted_pricingicp_amount
_8.ledgerled_amount
_8.ledgerled_orig_amount
_8.ledgerled_unit_amount
_8.patient_finance_recordspfr_min_due_amount
_8.patientspat_min_due_amount
_8.patients_immunizationspim_administered_amount
_8.patients_immunizations_templatespimt_administered_amount
_8.patients_inventorypinv_administered_amount
_8.patients_payments_schedulespps_amount
_8.patients_responsibility_estimatesprest_allowed_amount
_8.patients_responsibility_estimates_servicesprests_allowed_amount
_8.pre_services_line_adjustmentsprestsla_amount
_8.voided_paymentsvp_amount
_8.voided_paymentsvp_orig_amount
_81.billing_codesbil_negative_amount
_81.billing_codesbil_positive_amount
_81.encounters_paymentsepay_amount
_81.encounters_ub04enc_ub04_39_a_amount
_81.encounters_ub04enc_ub04_39_b_amount
_81.encounters_ub04enc_ub04_39_c_amount
_81.encounters_ub04enc_ub04_39_d_amount
_81.encounters_ub04enc_ub04_40_a_amount
_81.encounters_ub04enc_ub04_40_b_amount
_81.encounters_ub04enc_ub04_40_c_amount
_81.encounters_ub04enc_ub04_40_d_amount
_81.encounters_ub04enc_ub04_41_a_amount
_81.encounters_ub04enc_ub04_41_b_amount
_81.encounters_ub04enc_ub04_41_c_amount
_81.encounters_ub04enc_ub04_41_d_amount
_81.insurances_allowables_cpt_mapiacm_amount
_81.insurances_contracted_pricingicp_amount
_81.ledgerled_amount
_81.ledgerled_orig_amount
_81.ledgerled_unit_amount
_81.patient_finance_recordspfr_min_due_amount
_81.patientspat_min_due_amount
_81.patients_immunizationspim_administered_amount
_81.patients_immunizations_templatespimt_administered_amount
_81.patients_inventorypinv_administered_amount
_81.patients_payments_schedulespps_amount
_81.patients_responsibility_estimatesprest_allowed_amount
_81.patients_responsibility_estimates_servicesprests_allowed_amount
_81.pre_services_line_adjustmentsprestsla_amount
_81.voided_paymentsvp_amount
_81.voided_paymentsvp_orig_amount
_999.billing_codesbil_negative_amount
_999.billing_codesbil_positive_amount
_999.encounters_paymentsepay_amount
_999.encounters_ub04enc_ub04_39_a_amount
_999.encounters_ub04enc_ub04_39_b_amount
_999.encounters_ub04enc_ub04_39_c_amount
_999.encounters_ub04enc_ub04_39_d_amount
_999.encounters_ub04enc_ub04_40_a_amount
_999.encounters_ub04enc_ub04_40_b_amount
_999.encounters_ub04enc_ub04_40_c_amount
_999.encounters_ub04enc_ub04_40_d_amount
_999.encounters_ub04enc_ub04_41_a_amount
_999.encounters_ub04enc_ub04_41_b_amount
_999.encounters_ub04enc_ub04_41_c_amount
_999.encounters_ub04enc_ub04_41_d_amount
_999.insurances_allowables_cpt_mapiacm_amount
_999.insurances_contracted_pricingicp_amount
_999.ledgerled_amount
_999.ledgerled_orig_amount
_999.ledgerled_unit_amount
_999.patient_finance_recordspfr_min_due_amount
_999.patientspat_min_due_amount
_999.patients_immunizationspim_administered_amount
_999.patients_immunizations_templatespimt_administered_amount
_999.patients_inventorypinv_administered_amount
_999.patients_payments_schedulespps_amount
_999.patients_responsibility_estimatesprest_allowed_amount
_999.patients_responsibility_estimates_servicesprests_allowed_amount
_999.pre_services_line_adjustmentsprestsla_amount
_999.voided_paymentsvp_amount
_999.voided_paymentsvp_orig_amount
aurora_standard.amcbdwo_amount
aurora_standard.chmnbcgrtot_amount
aurora_standard.chmnbpyrtot_amount
aurora_standard.chmtbtrrtot_amount
aurora_standard.chpempirlife_amount
aurora_standard.chrdrugcpurch_amount
aurora_standard.chtwkhrdcarry_amount
aurora_standard.mktcusproposal_amount
aurora_standard.oddpayrecash_amount
aurora_standard.odhpayrecash_amount
aurora_standard.stfactvddepr_amount
aurora_standard.stfactvvdepr_amount
aurora_standard.stoinvceitem_amount
aurora_standard.stoinvcetrd_ds_amount
aurora_standard.stoinvcest_tx_amount
aurora_standard.stoinvceco_tx_amount
aurora_standard.stoinvceci_tx_amount
aurora_standard.stoinvcefrght_amount
aurora_standard.stoinvcetotal_amount
aurora_standard.stoinvcetax_amount
aurora_standard.stoordrdtax_amount
aurora_standard.stoordrdnet_amount
aurora_standard.stoordreitem_amount
aurora_standard.stoordretrd_ds_amount
aurora_standard.stoordretax_amount
aurora_standard.stoordrefrght_amount
aurora_standard.stoordretotal_amount
aurora_standard.stoshipdtax_amount
aurora_standard.stoshipdnet_amount
aurora_standard.stpactvdhome_curr_amount
aurora_standard.stpinvcedisc_amount
aurora_standard.stpinvceap_amount
aurora_standard.stpinvcehome_curr_amount
aurora_standard.stpopendorig_amount
aurora_standard.stpopendhome_curr_amount
aurora_standard.stractvdhome_curr_amount
aurora_standard.strcustrstmt_amount
aurora_standard.strinvcedisc_amount
aurora_standard.strinvcetax_amount
aurora_standard.strinvcefrght_amount
aurora_standard.strinvcemisc_amount
aurora_standard.strinvcear_amount
aurora_standard.strinvcehome_curr_amount
aurora_standard.strnotedorig_amount
aurora_standard.stropendorig_amount
aurora_standard.stropendhome_curr_amount
aurora_standard.stuinvcemisc_amount
aurora_standard.stuinvcefrght_amount
aurora_standard.stuordreitem_amount
aurora_standard.stuordretrd_ds_amount
aurora_standard.stuordretax_amount
aurora_standard.stuordrefrght_amount
aurora_standard.stuordremisc_amount
aurora_standard.stuordregoods_amount
aurora_standard.stuordretotal_amount
aurora_standard.stuordreprepay_amount
aurora_standard.styinccrot_shift_amount
aurora_standard.stypayrecash_amount
aurora_standard.styrevsdcash_amount
aurora_standard.tmp04dchg_amount
aurora_standard.tmp15chdchg_amount
common.billing_codesbil_negative_amount
common.billing_codesbil_positive_amount
common.rcm_stats_agingrcmsa_0_30_amount
common.rcm_stats_agingrcmsa_31_60_amount
common.rcm_stats_agingrcmsa_61_90_amount
common.rcm_stats_agingrcmsa_91_120_amount
common.rcm_stats_agingrcmsa_121_amount
common.rcm_stats_agingrcmsa_total_amount
template_library.patients_immunizations_templatespimt_administered_amount
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.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
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
post_date
TableColumn
aurora_standard.hl7ft1trans_post_date
aurora_standard.stuinvceinv_post_date