PRE_AR_TOOTH
Description:
This table contains tooth information for a single temporary accounts receivable (TAR) line. This data is coming from the Dental-Tooth Numbers (I TAR 508) item. Note: TAR records in Chronicles are purged periodically depending on your system setting. Be aware that old data in this table might be lost if you truncate the table.

Primary Key
Column Name Ordinal Position
TAR_ID 1
CHARGE_LINE 2
TOOTH_LINE 3

Column Information
Name Type Discontinued?
1 TAR_ID NUMERIC No
The unique identifier for the subject record.
2 CHARGE_LINE INTEGER No
The line number for the information associated with this record.
3 TOOTH_LINE INTEGER No
The line number of one of the multiple values associated with a specific group of data within this record.
4 TOOTH_NUM_C_NAME VARCHAR No
The tooth number category ID for the temporary transaction.
May contain organization-specific values: No
Category Entries:
Tooth 1
Tooth 2
Tooth 3
Tooth 4
Tooth 5
Tooth 6
Tooth 7
Tooth 8
Tooth 9
Tooth 10
Tooth 11
Tooth 12
Tooth 13
Tooth 14
Tooth 15
Tooth 16
Tooth 17
Tooth 18
Tooth 19
Tooth 20
Tooth 21
Tooth 22
Tooth 23
Tooth 24
Tooth 25
Tooth 26
Tooth 27
Tooth 28
Tooth 29
Tooth 30
Tooth 31
Tooth 32
Tooth A
Tooth B
Tooth C
Tooth D
Tooth E
Tooth F
Tooth G
Tooth H
Tooth I
Tooth J
Tooth K
Tooth L
Tooth M
Tooth N
Tooth O
Tooth P
Tooth Q
Tooth R
Tooth S
Tooth T
Tooth 18 (FDI)
Tooth 17 (FDI)
Tooth 16 (FDI)
Tooth 15 (FDI)
Tooth 14 (FDI)
Tooth 13 (FDI)
Tooth 12 (FDI)
Tooth 11 (FDI)
Tooth 21 (FDI)
Tooth 22 (FDI)
Tooth 23 (FDI)
Tooth 24 (FDI)
Tooth 25 (FDI)
Tooth 26 (FDI)
Tooth 27 (FDI)
Tooth 28 (FDI)
Tooth 38 (FDI)
Tooth 37 (FDI)
Tooth 36 (FDI)
Tooth 35 (FDI)
Tooth 34 (FDI)
Tooth 33 (FDI)
Tooth 32 (FDI)
Tooth 31 (FDI)
Tooth 41 (FDI)
Tooth 42 (FDI)
Tooth 43 (FDI)
Tooth 44 (FDI)
Tooth 45 (FDI)
Tooth 46 (FDI)
Tooth 47 (FDI)
Tooth 48 (FDI)
Tooth 55 (FDI)
Tooth 54 (FDI)
Tooth 53 (FDI)
Tooth 52 (FDI)
Tooth 51 (FDI)
Tooth 61 (FDI)
Tooth 62 (FDI)
Tooth 63 (FDI)
Tooth 64 (FDI)
Tooth 65 (FDI)
Tooth 75 (FDI)
Tooth 74 (FDI)
Tooth 73 (FDI)
Tooth 72 (FDI)
Tooth 71 (FDI)
Tooth 81 (FDI)
Tooth 82 (FDI)
Tooth 83 (FDI)
Tooth 84 (FDI)
Tooth 85 (FDI)
Tooth UR8 (Palmer)
Tooth UR7 (Palmer)
Tooth UR6 (Palmer)
Tooth UR5 (Palmer)
Tooth UR4 (Palmer)
Tooth UR3 (Palmer)
Tooth UR2 (Palmer)
Tooth UR1 (Palmer)
Tooth UL1 (Palmer)
Tooth UL2 (Palmer)
Tooth UL3 (Palmer)
Tooth UL4 (Palmer)
Tooth UL5 (Palmer)
Tooth UL6 (Palmer)
Tooth UL7 (Palmer)
Tooth UL8 (Palmer)
Tooth LL8 (Palmer)
Tooth LL7 (Palmer)
Tooth LL6 (Palmer)
Tooth LL5 (Palmer)
Tooth LL4 (Palmer)
Tooth LL3 (Palmer)
Tooth LL2 (Palmer)
Tooth LL1 (Palmer)
Tooth LR1 (Palmer)
Tooth LR2 (Palmer)
Tooth LR3 (Palmer)
Tooth LR4 (Palmer)
Tooth LR5 (Palmer)
Tooth LR6 (Palmer)
Tooth LR7 (Palmer)
Tooth LR8 (Palmer)
Tooth URE (Palmer)
Tooth URD (Palmer)
Tooth URC (Palmer)
Tooth URB (Palmer)
Tooth URA (Palmer)
Tooth ULA (Palmer)
Tooth ULB (Palmer)
Tooth ULC (Palmer)
Tooth ULD (Palmer)
Tooth ULE (Palmer)
Tooth LLE (Palmer)
Tooth LLD (Palmer)
Tooth LLC (Palmer)
Tooth LLB (Palmer)
Tooth LLA (Palmer)
Tooth LRA (Palmer)
Tooth LRB (Palmer)
Tooth LRC (Palmer)
Tooth LRD (Palmer)
Tooth LRE (Palmer)