vPayrollJournalListing


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 null
NameInternal varchar 100 √ null
NameExternal varchar 100 √ null
LegalFullName varchar 150 √ null
Surname varchar 30 √ null
Preferred varchar 20 √ null
PreferredFormal varchar 20 √ null
Given1 varchar 20 √ null
Given2 varchar 50 √ null
BirthDate datetime 16,3 √ null
MailNamePrimary varchar 100 √ null
AddressComma varchar 200 √ null
AddressFull varchar 200 √ null
EmploymentCategory varchar 5 √ null
EmploymentStatus varchar 1 √ null
EmploymentStatusDescription varchar 50 √ null
EmploymentStatusContractFlag smallint 2 √ null
EmploymentStatusSynergyMeaning varchar 10 √ null
StartDate datetime 16,3 √ null
TerminatedFlag smallint 2 √ null
TerminationDate datetime 16,3 √ null
PayrollYear smallint 2 null
PayGroup varchar 5 √ null
PayGroupDescription varchar 40 √ null
PayFrequencyCode varchar 5 √ null
PayFrequencyDescription varchar 20 √ null
TaxScaleCode varchar 3 √ null
TaxScaleDescription varchar 50 √ null
YTDTotalTaxation money 21,4 null
YTDNettPay money 21,4 null
YTDGrossPay money 21,4 null
YTDHECS money 21,4 null
YTDHELP money 21,4 null
YTDSuperContributionTax money 21,4 null
TaxFileNumber int 4 √ null
TaxDependantRebate money 21,4 √ null
TaxHECSFlag smallint 2 √ null
TaxHELPFlag smallint 2 √ null
FringeBenefitsTax money 21,4 √ null
ReferenceSuperBase money 21,4 √ null
AnnualAllowance money 21,4 √ null
AnnualSalary money 21,4 √ null
AnnualBudget money 21,4 √ null
Comment varchar 4000 √ null
PreviousNettPay money 21,4 null
PostingNumber int 4 null
FrequencyCode varchar 5 √ null
PayPeriods decimal 10,4 √ null
OverridePayMethodCode varchar 5 √ null
GrossPay money 21,4 √ null
HECS money 21,4 √ null
HELP money 21,4 √ null
TotalTaxation money 21,4 √ null
TaxationOverrideFlag bit 1 √ null
NettPay money 21,4 √ null
ChequeNumber int 4 √ null
EmployerSuperannuation money 21,4 √ null
SuperContributionTax money 21,4 √ null
Description varchar 255 √ null
NormalPay money 21,4 √ null
SalarySacrifice money 21,4 √ null
SalarySacrificeSuperannuation money 21,4 √ null
TaxableAllowances money 21,4 √ null
NonTaxableAllowances money 21,4 √ null
Deductions money 21,4 √ null
EmployeeSuperannuation money 21,4 √ null
TerminationPay money 21,4 √ null
OtherPaymentGross money 21,4 √ null
OtherPaymentWithholding money 21,4 √ null
ChequeDate datetime 16,3 √ null
PostingSource varchar 10 null
PostingCreatedDate datetime 16,3 √ null
PostingCreatedBy varchar 50 √ null
PostingDescription varchar 60 null
PostingDate datetime 16,3 √ null
PostingDeletedFlag bit 1 √ null
PrintVersion smallint 2 null
PostingCompleteFlag bit 1 null
PostingControlAmount money 21,4 null
PostingAmount money 21,4 null
DebtorControlGLJournalSeq int 4 null
BankControlGLJournalSeq int 4 null
CreditorControlGLJournalSeq int 4 null
BankCode varchar 15 null
DebtorInstControlGLJournalSeq int 4 null
TaxIncomeControlGLJournalSeq int 4 null
TaxExpenseControlGLJournalSeq int 4 null
GLDate datetime 16,3 √ null
PayStartDate datetime 16,3 √ null
PayEndDate datetime 16,3 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views