vItemSales


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SaleSeq int 4 √ null
SaleBusinessUnitCode varchar 15 √ null
SaleDate datetime 16,3 √ null
SaleCreatedDate datetime 16,3 √ null
SaleCreatedTimeAMPM varchar 7 √ null
SaleCreatedTime24 varchar 5 √ null
SaleHoldFlag bit 1 √ null
SaleStudentID int 4 √ null
SaleGLCode varchar 15 null
SaleGLDescription varchar 50 null
SaleGLCostCentreCode varchar 15 null
SaleGLCostCentreDescription varchar 100 null
SaleGLFlag int 4 null
SaleGLSuballocationCode varchar 15 null
SaleStaffID int 4 √ null
SchoolStaffCode varchar 30 null
SaleID int 4 √ null
SaleName varchar 60 √ null
SaleName2 varchar 60 √ null
SaleComment varchar 80 √ null
SalePostingNumber int 4 √ null
SaleInvoiceNumber int 4 √ null
SaleInvoiceDate datetime 16,3 √ null
ItemCategory varchar 15 √ null
ItemCategoryDescription varchar 40 √ null
ItemStockFlag bit 1 √ null
ItemUnitofMeasureSold varchar 10 √ null
ItemDescription varchar 60 √ null
ItemLookup varchar 30 √ null
ItemBarCode varchar 30 √ null
UnitOfMeasureSold varchar 10 √ null
UnitOfMeasureSupplied varchar 10 √ null
UnitsSuppliedToStock decimal 16,4 √ null
EnforceSaleDescriptionFlag bit 1 √ null
ABN varchar 11 null
ItemSaleSeq int 4 null
SaleDetailLineNumber int 4 null
SaleItemCode varchar 15 null
SaleQuantitySold decimal 16,4 √ null
SaleQuantitySoldString varchar 30 √ null
SaleUnitPrice decimal 14,4 null
SaleTaxCode varchar 5 null
SaleTaxAmount money 21,4 null
SaleExtendedPrice money 21,4 null
SaleExtendedCost money 21,4 null
SaleOverrideDescription varchar 255 null
SaleDescription varchar 255 √ null
DiscountLinePercent numeric 8,4 null
DiscountLineAmount money 21,4 null
DiscountSalePercent numeric 8,4 null
DiscountSaleAmount money 21,4 null
DebtorID int 4 √ null
DebtorStudentID int 4 √ null
DebtorSubLedgerCode varchar 15 √ null
DebtorSubLedgerCodeDisplay varchar 15 √ null
DebtorStatementGroup varchar 10 √ null
DebtorStatus varchar 3 √ null
BPAYReference varchar 21 √ null
DebtorNameInternal varchar 100 √ null
DebtorNameExternal varchar 100 √ null
DebtorLegalFullName varchar 150 √ null
DebtorSurname varchar 30 √ null
DebtorTitle varchar 30 √ null
DebtorInitials varchar 15 √ null
DebtorSuffix varchar 20 √ null
DebtorPreferred varchar 20 √ null
DebtorPreferredFormal varchar 20 √ null
DebtorGiven1 varchar 20 √ null
DebtorGiven2 varchar 50 √ null
DebtorGender varchar 15 √ null
DebtorCreatedDate datetime 16,3 √ null
DebtorCreatedBy varchar 50 √ null
DebtorModifiedDate datetime 16,3 √ null
DebtorModifiedBy varchar 50 √ null
DebtorAllowReceiptPrintFlag bit 1 √ null
DebtorAllowReminderFlag bit 1 √ null
DebtorAllowInterestFlag bit 1 √ null
DebtorAllowDeleteFlag bit 1 √ null
DebtorReferenceType varchar 3 √ null
DebtorReference varchar 60 √ null
DebtorPrepaid money 21,4 √ null
DebtorCurrentBalance money 21,4 √ null
DebtorNotifiedBalance money 21,4 √ null
DebtorLastPaymentDate datetime 16,3 √ null
DebtorLastPaymentAmount money 21,4 √ null
DebtorArrangementActiveFlag bit 1 √ null
DebtorLastOverdueLetterCode varchar 5 √ null
DebtorLastOverdueLetterDate datetime 16,3 √ null
DebtorLastOverdueLetterAmount money 21,4 √ null
DebtorLastOverdueLetterRefDate datetime 16,3 √ null
DebtorLastOverdueLetterDaysBetween smallint 2 √ null
DebtorMailName varchar 100 √ null
DebtorPrimaryOnlyFlag bit 1 √ null
DebtorMailSalutation varchar 100 √ null
DebtorAddressComma varchar 8000 √ null
DebtorAddressFull varchar 602 √ null
DebtorAddressDPID varchar 8 √ null
DebtorAddressDPIDBarcode varchar 60 √ null
DebtorAddressSortPlanNumber varchar 10 √ null
DebtorAddressPAFVersion varchar 10 √ null
DebtorSuburb varchar 40 √ null
DebtorPostcode varchar 5 √ null
DebtorCountryCode varchar 5 √ null
DebtorMailAddressCode varchar 1 √ null
DebtorOccupCode varchar 15 √ null
DebtorOccupDesc varchar 50 √ null
DebtorOccupCompany varchar 50 √ null
DebtorOccupIndustryCode varchar 8 √ null
DebtorOccupPositionCode varchar 8 √ null
DebtorOccupPhone varchar 15 √ null
DebtorOccupFax varchar 15 √ null
DebtorOccupMobilePhone varchar 15 √ null
DebtorOccupEmail varchar 100 √ null
DebtorHomePhone varchar 15 √ null
DebtorHomeFax varchar 15 √ null
DebtorMobilePhone varchar 15 √ null
DebtorHomeEmail varchar 100 √ null
DebtorSpouseNameInternal varchar 100 √ null
DebtorSpouseNameExternal varchar 100 √ null
DebtorSpouseLegalFullName varchar 150 √ null
DebtorSpouseGiven1 varchar 20 √ null
DebtorSpouseGiven2 varchar 50 √ null
DebtorSpousePreferred varchar 20 √ null
DebtorSpousePreferredFormal varchar 20 √ null
DebtorSpouseSurname varchar 30 √ null
DebtorSpouseMobilePhone varchar 15 √ null
DebtorSpouseOccupPhone varchar 15 √ null
DebtorSpouseOccupMobilePhone varchar 15 √ null
DebtorCommentWarningFlag bit 1 √ null
DebtorComment varchar 2147483647 √ null
DebtorCommentWarningChargesFlag bit 1 √ null
DebtorCommentWarningReceiptsFlag bit 1 √ null
DebtorPaymentAutoDeductAmount money 21,4 √ null
DebtorPaymentAutoDeductFrequency varchar 5 √ null
DebtorPaymentAutoDeductNextDate datetime 16,3 √ null
DebtorPaymentAutoDeductHoldFlag bit 1 √ null
DebtorPaymentAutoDeductMethod varchar 5 √ null
DebtorPaymentAutoDeductStopDate datetime 16,3 √ null
DebtorEziDebitCreatedDate datetime 16,3 √ null
DebtorEziDebitCreatedFlag bit 1 √ null
DebtorEziDebitCustomerRef int 4 √ null
DebtorAutoDebitAuthorisedDate datetime 16,3 √ null
DebtorAddress1Silent varchar 8000 √ null
DebtorAddress2Silent varchar 8000 √ null
DebtorSuburbSilent varchar 8000 √ null
DebtorPostCodeSilent varchar 8000 √ null
DebtorStateSilent varchar 8000 √ null
DebtorMobilePhoneSilent varchar 8000 √ null
DebtorIDFull varchar 15 √ null
DebtorAllowSales varchar 1 √ null
DebtorAllowSalesFlag bit 1 √ null
DebtorNotifyMethod varchar 2 √ null
SaleAccountCode varchar 31 √ null
ItemDescriptionFull varchar 319 √ null
SaleMailName varchar 100 √ null
SaleAddressFull varchar 200 √ null
OperatorLoginName varchar 50 √ null
SaleGroupNumber int 4 √ null
SaleGroupDescription varchar 8000 √ null
StudentGiven1 varchar 20 √ null
StudentGiven2 varchar 50 √ null
StudentCampus varchar 3 √ null
StudentYearLevel smallint 2 √ null
StudentForm varchar 15 √ null
StudentDebtorMailName varchar 100 √ null
StudentDebtorAddressFull varchar 200 √ null
SaleOrderNumber int 4 √ null
StudentPreferred varchar 20 √ null
DocketName varchar 100 √ null
DocketAddressFull varchar 602 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views