Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| BusinessUnitCode | varchar | 15 | null |
|
|
|||
| BusinessUnitDescription | varchar | 50 | null |
|
|
|||
| Address1 | varchar | 40 | null |
|
|
|||
| Address2 | varchar | 40 | null |
|
|
|||
| Address3 | varchar | 40 | null |
|
|
|||
| Suburb | varchar | 40 | null |
|
|
|||
| State | varchar | 5 | null |
|
|
|||
| PostCode | varchar | 5 | null |
|
|
|||
| Phone | varchar | 15 | null |
|
|
|||
| ResponsiblePerson | varchar | 40 | null |
|
|
|||
| OrderNumberLast | int | 4 | null |
|
|
|||
| OrderNumberHigh | int | 4 | null |
|
|
|||
| OrderStationerySuffix | varchar | 10 | null |
|
|
|||
| SaleInvoiceNumberLast | int | 4 | null |
|
|
|||
| SaleInvoiceNumberHigh | int | 4 | null |
|
|
|||
| SaleInvoiceStationerySuffix | varchar | 10 | null |
|
|
|||
| PricesIncludeTaxFlag | bit | 1 | null |
|
|
|||
| FeeCode | varchar | 15 | null |
|
|
|||
| FeeCategoryCode | varchar | 15 | null |
|
|
|||
| GLSaleControl | varchar | 15 | null |
|
|
|||
| PurchaseOrderCount | tinyint | 1 | null |
|
|
|||
| PurchaseOrderDescription1 | varchar | 80 | null |
|
|
|||
| PurchaseOrderDescription2 | varchar | 80 | null |
|
|
|||
| PurchaseOrderDescription3 | varchar | 80 | null |
|
|
|||
| PurchaseOrderDescription4 | varchar | 80 | null |
|
|
|||
| PrintBusinessUnitAddressFlag | bit | 1 | null |
|
|
|||
| BusinessUnitMailName | varchar | 120 | null |
|
|
|||
| BusinessUnitMailAddress | varchar | 180 | null |
|
|
|||
| ProduceInvoiceOnChargeFlag | bit | 1 | null |
|
|
|||
| AllowNoStockSale | char | 1 | null |
|
|
|||
| DocketProduceOnSaleFlag | bit | 1 | null |
|
|
|||
| DocketStationerySuffix | varchar | 10 | null |
|
|
|||
| GLStockControl | varchar | 15 | null |
|
|
|||
| GLStockMovementControl | varchar | 15 | null |
|
|
|||
| GLPurchaseControl | varchar | 15 | null |
|
|
|||
| GLStockIntegratedFlag | bit | 1 | null |
|
|
|||
| DocketCopies | int | 4 | null |
|
|
|||
| PurchaseOrderGoItemCodeFlag | bit | 1 | null |
|
|
|||
| CredInvoiceItemReceiptsFlag | bit | 1 | null |
|
|
|||
| EnterCustomerBeforeSaleFlag | bit | 1 | null |
|
|
|||
| ConsignmentStockEnabledFlag | bit | 1 | null |
|
|
|||
| ConsignmentStockDefaultFlag | bit | 1 | null |
|
|
|||
| ConsignmentCommissionPercent | numeric | 9,4 | null |
|
|
|||
| ConsignmentMinPaymentAmount | money | 21,4 | null |
|
|
|||
| ConsignmentDefaultSaleTaxCode | varchar | 5 | null |
|
|
|||
| ConsignmentCommissionGLCode | varchar | 15 | null |
|
|
|||
| ConsignmentCommissionTaxCode | varchar | 5 | null |
|
|
|||
| ConsignmentPurchasesGLCode | varchar | 15 | null |
|
|
|||
| ScannerEnabledFlag | bit | 1 | null |
|
|
|||
| CustomerDisplayUnitCode | varchar | 15 | null |
|
|
|||
| CustomerDisplayUnitPort | varchar | 5 | null |
|
|
|||
| CustomerDisplayUnitMessage | varchar | 50 | null |
|
|
|||
| ReceiptPrinterFlag | bit | 1 | null |
|
|
|||
| ReceiptPrinterCode | varchar | 15 | null |
|
|
|||
| ReceiptPrinterPort | varchar | 50 | null |
|
|
|||
| GLSaleAuthoriseType | varchar | 1 | null |
|
|
|||
| SaleRoundItemCode | varchar | 15 | null |
|
|
|||
| SaleRoundDirection | varchar | 1 | null |
|
|
|||
| SaleRoundCents | tinyint | 1 | null |
|
|
|||
| CashDrawerCode | varchar | 15 | null |
|
|
|||
| CashDrawerPort | varchar | 50 | null |
|
|
|||
| RequireCustomer | varchar | 1 | null |
|
|
|||
| RequireDriversLicense | varchar | 1 | null |
|
|
|||
| RequireCreditCardNumber | varchar | 1 | null |
|
|
|||
| RequireCreditCardExpiry | varchar | 1 | null |
|
|
|||
| RequireEFTReference | varchar | 1 | null |
|
|
|||
| RequireCreditCardType | varchar | 1 | null |
|
|
|||
| CloseOffType1Description | varchar | 30 | null |
|
|
|||
| CloseOffType2Description | varchar | 30 | null |
|
|
|||
| CloseOffType3Description | varchar | 30 | null |
|
|
|||
| CloseOffType4Description | varchar | 30 | null |
|
|
|||
| AdvancedPOSFlag | bit | 1 | null |
|
|
|||
| ConsignmentDebtorFeeCode | varchar | 15 | null |
|
|
|||
| RequireOrderNumber | varchar | 1 | null |
|
|
|||
| PurchaseOrderThresholdAmount | money | 21,4 | null |
|
|
|||
| SaleCopyLastDateFlag | bit | 1 | null |
|
|
|||
| PurchaseOrderItemReceiptsFlag | bit | 1 | null |
|
|
|||
| NoSalePassword | varchar | 30 | null |
|
|
|||
| SaleSameItemAdjustQuantityFlag | bit | 1 | null |
|
|
|||
| IncludeConsignmentStockOnSearchScreenFlag | bit | 1 | null |
|
|
|||
| ReceiptPrinterName | varchar | 200 | null |
|
|
|||
| StocktakeIncludeConsignmentFlag | bit | 1 | null |
|
|
|||
| StocktakeAllowSalesFlag | bit | 1 | null |
|
|
|||
| PurchaseOrderTwoLevelAuthorisationFlag | bit | 1 | null |
|
|
|||
| PurchaseOrderEmailUserName | varchar | 100 | null |
|
|
|||
| PurchaseOrderEmailPassword | varchar | 50 | null |
|
|
|||
| PurchaseOrderEmailContentType | varchar | 15 | null |
|
|
|||
| PurchaseOrderEmailToOriginatorFlag | bit | 1 | null |
|
|
|||
| PurchaseOrderEmailToDepartmentAuthoriserFlag | bit | 1 | null |
|
|
|||
| PurchaseOrderEmailToAuthoriserFlag | bit | 1 | null |
|
|
|||
| PurchaseOrderEmailToAddresses | varchar | 200 | null |
|
|
|||
| PurchaseOrderEmailFlag | bit | 1 | null |
|
|
|||
| PurchaseOrderEmailSubject | varchar | 255 | null |
|
|
|||
| PurchaseOrderEmailMessage | varchar | 2147483647 | √ | null |
|
|
||
| PurchaseOrderEmailSenderEmail | varchar | 100 | null |
|
|
|||
| PurchaseOrderEmailSenderName | varchar | 100 | null |
|
|
|||
| PurchaseOrderEnforceGLCodeType | varchar | 1 | null |
|
|
|||
| AllowZeroDollarPurchaseOrderFlag | bit | 1 | null |
|
|
|||
| PromptGLSaleFlag | bit | 1 | null |
|
|
|||
| PromptZeroBudgetGLsFlag | bit | 1 | null |
|
|
|||
| ConsignmentStockAltColorFlag | bit | 1 | null |
|
|
|||
| ConsignmentStockDefaultPriceFlag | bit | 1 | null |
|
|
|||
| EnableRequisitionFlag | bit | 1 | null |
|
|
|||
| RequisitionEmailFlag | bit | 1 | null |
|
|
|||
| RequisitionEmailSubject | varchar | 255 | null |
|
|
|||
| RequisitionEmailMessage | varchar | 2147483647 | null |
|
|
|||
| DefaultBusinessUnitFlag | bit | 1 | null |
|
|
|||
| StocktakeActiveFlag | bit | 1 | √ | null |
|
|
Table contained 0 rows