AR_LINE_ITEM_DETAILS · Accumedic EHI Export Format

01Relates to the patient

INVOICE + LINE_NO matches AR_LINE_ITEMS.INVOICE + AR_LINE_ITEMS.LINE_NO on a row of AR_LINE_ITEMS that relates to the patient

Single-patient export: the patient's rows.

02References

ADJUSTMENT_TYPE → V_ADJUSTMENT_TYPES.ADJUSTMENT_TYPE
APPT_ID, APPT_LINE_NO, APPT_TRANSACTION_NO → APPT_PAYMENTS.APPT_ID, APPT_LINE_NO, APPT_TRANSACTION_NO
INVOICE, LINE_NO → AR_LINE_ITEMS.INVOICE, LINE_NO
COMPANY_CODE → PAYORS.COMPANY_CODE
PAYMENT_SOURCE → V_PAYMENT_SOURCE.PAYMENT_SOURCE
INSURANCE_ID, COMPANY_CODE → INSURANCE_POLICIES.INSURANCE_ID, COMPANY_CODE
PAYMENT_TYPE → V_PAYMENT_TYPES.PAYMENT_TYPE

03Columns

#	Column	Type	Source type	Null	Notes
1	INVOICE PK	integer	int	no
2	LINE_NO PK	integer	int	no
3	TRANSACTION_NO PK	integer	int	no
4	INSURANCE_ID	string	varchar(25)	yes
5	COMPANY_CODE	string	varchar(20)	no
6	TRANSACTION_TYPE	integer	int	no	Kind of ledger transaction. Codes: `AR_TRANSACTION_KIND`
7	TRANSACTION_DATE	datetime	datetime	no
8	AMOUNT	decimal	decimal(19,4)	no	Transaction amount in US dollars.
9	APPROVED_AMOUNT	decimal	decimal(19,4)	yes
10	CHECK_NO	string	varchar(30)	yes
11	REFERENCE_NO	string	varchar(30)	yes
12	REASON_CODE	string	varchar(6)	yes
13	BILL_DATE	datetime	datetime	no
14	PAYMENT_SOURCE	string	varchar(6)	yes
15	PAYMENT_TYPE	integer	int	yes
16	APPLY_DEDUCTIBLE	string	char(1)	yes
17	USER_ID	string	varchar(20)	yes
18	REMIT_FILENAME	string	varchar(100)	yes
19	REMIT_CODE	string	varchar(5)	yes
20	DEDUCTIBLE_AMOUNT	decimal	decimal(19,4)	yes
21	COINSURANCE_AMOUNT	decimal	decimal(19,4)	yes
22	REMIT_STATUS	string	varchar(4)	yes
23	ADJUSTMENT_TYPE	integer	int	yes
24	CLAIM_BATCH_NUMBER	integer	int	yes
25	ENTRY_DATE	datetime	datetime	no
26	ENTRY_USER_ID	string	varchar(20)	no
27	REBILL_INVOICE	integer	int	yes
28	RECEIPT_NUMBER	integer	int	yes
29	DIRECT_DEPOSIT_NO	string	varchar(30)	yes
30	REMARK_CODE	string	varchar(5)	yes
31	REMARK_CODE_2	string	varchar(5)	yes
32	REMARK_CODE_3	string	varchar(5)	yes
33	REMARK_CODE_4	string	varchar(5)	yes
34	REMARK_CODE_5	string	varchar(5)	yes
35	CAS_CODE	string	varchar(3)	yes
36	EXPECTED_AMT	decimal	decimal(19,4)	yes
37	SOURCE	integer	int	yes	Where the transaction was entered. Codes: `AR_TRANSACTION_SOURCE`
38	APPT_ID	integer	int	yes
39	APPT_LINE_NO	integer	int	yes
40	APPT_TRANSACTION_NO	integer	int	yes
41	COMMENT_TEXT	string	varchar(240)	yes
42	SOURCE_INVOICE	integer	int	yes
43	DEST_INVOICE	integer	int	yes
44	COPAY_DUE	decimal	decimal(19,4)	yes
45	ADJ_GROUP_CODE	string	varchar(2)	yes
46	POS_CODE	string	varchar(2)	yes
47	ACCEPT_ASSIGNMENT	string	char(1)	yes