
Tracelogic Database Table
Records internal state when logic decisions were made during processing. Primarily used for support and diagnostic purposes
Fields
- physkey
- #100, Datatype: String 44 bytes
- physkeys
- #101, Datatype: String 44 bytes
Reference to related sale, where applicable. This contains the sale.physkey value. - localsid
- #102, Datatype: Integer
- dt
- #103, Datatype: DateTime
Local datetime this decision was made - srcuid
- #104, Datatype: Integer
- logicflow
- #105, Datatype: Integer
Where in the code base this logic test was made - plevel
- #106, Datatype: Integer
Current version of code - qlevel
- #107, Datatype: Integer
Current dynamic patch level of code. 0 means no dynamic patch is currently active for this function - rve
- #108, Datatype: Double
- amt0
- #110, Datatype: Money/Currency
- amt1
- #111, Datatype: Money/Currency
- amt2
- #112, Datatype: Money/Currency
- lv0
- #120, Datatype: Integer
- lv1
- #121, Datatype: Integer
- lv2
- #122, Datatype: Integer
- str0
- #130, Datatype: String 128 bytes
- str1
- #131, Datatype: String 128 bytes
- str2
- #132, Datatype: String 128 bytes
- flow0
- #200, Datatype: Integer
- flow1
- #201, Datatype: Integer
- flow2
- #202, Datatype: Integer
- flow3
- #203, Datatype: Integer
- flow4
- #204, Datatype: Integer
- flow5
- #205, Datatype: Integer
Remarks
LogicFlow 323200815. Account Credit/Floor Limit checked
This logic flow is recorded when a payment is applied and requested to be charged to an account. The related sale is linked in the physkeys field
Field | Contents |
Amt0 | The current credit_limit of the account |
Amt1 | The current balance of the account |
Amt2 | The amount of this payment. This amount will be added to the current balance if payment is accepted |
Flow0 | Contains 324200815 if the payment pushes the account over the credit_limit Contains 325200815 if the payment is still within the credit limit |