ubdet

The ubdet table is part of the family of billing tables that include ubdeth, ubdethl, ubdeths and ubdeth_tax. They can be linked together by the history_sequence_id along with Hist_Sum.

Notes:

For information about interpreting EDIFICE Tables, see Understanding EDIFICE Tables.
To view other EDIFICE Tables, see the EDIFICE Database Overview.

ubdet
Field
History_Sequence_ID
Row_Index
Step_Charge1
Step_Charge2
Step_Charge3
Step_Charge4
Step_Charge5
Step_Charge6
Step_Charge7
Step_Charge8
Step_Charge9
Step_Charge10
Step_Charge11
Step_Charge12
Step_Charge13
Step_Charge14
Step_Charge15
Step_Charge16
Step_Charge17
Step_Charge18
Step_Charge19
Step_Charge20
Step_Charge21
Step_Charge22
Step_Charge23
Step_Charge24
Step_Charge25
Step_Charge26
Step_Charge27
Step_Charge28
Step_Charge29
Step_Charge30
Step_Usage1
Step_Usage2
Step_Usage3
Step_Usage4
Step_Usage5
Step_Usage6
Step_Usage7
Step_Usage8
Step_Usage9
Step_Usage10
Step_Usage11
Step_Usage12
Step_Usage13
Step_Usage14
Step_Usage15
Step_Usage16
Step_Usage17
Step_Usage18
Step_Usage19
Step_Usage20
Step_Usage21
Step_Usage22
Step_Usage23
Step_Usage24
Step_Usage25
Step_Usage26
Step_Usage27
Step_Usage28
Step_Usage29
Step_Usage30
Post_Sequence
System_Date
Transaction_Type
Debit_Credit
Due_Date
GL_Period
Original_Rate_Class
Original_Period
Post_Date
Status
Statement_Invoice_Number
Statement_Print_Sequence
Exception_Type
Customer_ID
GL_Credit_Acct
GL_Debit_Acct
System_Time
Post_User
User
Location_ID
Billing_Run_ID
Reference_1
Reference_2
Reference_3
Reference_4
Units
Cost_Of_Goods
Item_ID
Linked_Transaction_ID
Customer_Type