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 StorageRelevant Tracking records for supply and billing |
Archive StorageTracking records that were fully delivered and charged. |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Client Number | Integer | 0 | Edit | Hidden Read Only Key Field |
ClientNumber | |
| SubRecord ID | Real | 0 | Edit | Hidden Read Only Key Field |
SubrecordId | |
| Sale Source | Values List: 0 = None1 = Order 2 = Delivery Note 3 = Transaction Invoice 4 = Tax Invoice |
Status | 0 | Select | Read Only | SaleSource |
| Client P.O. | String | 20 | Edit | Read Only | ClientPO | |
| Order Number | Real | 0 | Edit | Read Only | OrderNumber | |
| Item ID | Real | 0 | Edit | Hidden Read Only |
ItemId | |
| Catalogic Number | String | 30 | Edit | Read Only | CatalogicNumber | |
| Description | String | 120 | Edit | Read Only | Description | |
| Quantity | Real | 0 | Edit | Read Only | Quantity | |
| Unit of measure | Status | 0 | Select | Read Only | UnitOfMeasure | |
| Deadline | FixDT | 0 | SelectEdit | Deadline | ||
| Quantity Ready to Supply | Real | 0 | Edit | Read Only | QuantityReadyToSupply | |
| Quantity on Delivery Note | Real | 0 | Edit | Read Only | QuantityOnDeliveryNote | |
| Quantity on Tax Invoice | Real | 0 | Edit | Read Only | QuantityOnTaxInvoice | |
| Production Order On | FixDT | 0 | SelectEdit | Read Only | ProductionOrderOn | |
| Production Order By | String | 40 | Edit | Read Only | ProductionOrderBy | |
| Commitment ID | Integer | 0 | Edit | Read Only | CommitmentId | |
| Prepaid | Bool | 0 | Select | Read Only | Prepaid | |
| Integer Unit Quantity | Bool | 0 | Select | Hidden Read Only |
IntegerUnitQuantity | |
| PP&C Handling | Bool | 0 | Select | Hidden Read Only |
PpCHandling | |
| Delivery Notes Reference | String | 80 | Edit | Read Only | DeliveryNotesReference |