Database Table "hyp_Client Open Billing or Supply"

Table Description

Tracking production, supply and customer billing according to orders. Delivered and charged records, will be archived.

Normal Storage

Relevant Tracking records for supply and billing

Archive Storage

Tracking records that were fully delivered and charged.

Deleted Storage(Recycle)

Field Name Description and Notes Data Type Text Length
Client Number Integer 0
SubRecord ID Unique record key for programming (GUTS) Real 0
Order Number Order document number Real 0
Item ID Unique record key of the items line in table (hyp_Order Items) Real 0
Catalogic Number String 30
Description The field "Description" is copied from the order doc. String 120
Quantity Real 0
Unit of measure
Status 0
Commitment ID Record key of Contractual Obligation to the customer (hyp_Client Contract) Integer 0
CFP Tax-Free Selling Price Tax-Free Selling Price, according to obligation. Real 0
CFP Taxable Selling Price Taxable Selling Price, according to obligation. Real 0
CFP Selling Currency Selling Currency, according to obligation String 4
Deadline The required Delivery Date FixDT 0
Quantity Ready to Supply The quantity of products, ready to be supplied. This quantity can be partial. Real 0
Quantity on Delivery Note This quantity is updated automatically after producing the delivery note. Real 0
Quantity on Tax Invoice This quantity is automatically updated after producing the tax invoice. Real 0
Delivery Notes Reference If any Delivery note was produced, its reference number will be displayed in this field. String 80
Integer Unit Quantity This field defines whether the available sold quantity was defined as Integer. Bool 0
PP&C Handling Boolean Flag. Production and/or Delivery required (physical product).
False value represent Services or Charges.
Bool 0
Prepaid Boolean Flag. Defines whether the product was prepaid. Bool 0
Production Order On An automatic field that will be updated according to the actual date of sending the order to production. FixDT 0
Production Order By The user name that have updated the status of the order as "Sent to Production". String 40
Jump to tables index

Database Table "hyp_Order Confirmation Chain"

Table Description

The confirmation chain proccess of an order.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name Description and Notes Data Type Text Length
Order Number Real 0
Step Name The name of the step in the confirmation chain, as defined in the Orders tab of the System Fundamentals. String 30
Signed On The exact time of of signing this step. FixDT 0
Signed By The user name that has approved this step. String 40
Jump to tables index