GeneralLedgerPostingControlHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GeneralLedgerPostingControlHistorySeq int identity 4 √ null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
PostingNumber int 4 √ 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
ProgramName varchar 30 √ null
AdjustmentFlag bit 1 √ null
IgnoreTaxCodeFlag bit 1 √ null
BusinessUnitCode varchar 15 √ null
DebtorSubLedgerCode varchar 15 √ null
PostingModifiedFlag bit 1 √ null
DetailControlJournalFlag bit 1 √ null
PayThisAccountOnlyFlag bit 1 √ null
ForeignCurrencyCode varchar 15 √ null
ForeignCurrencyExchangeRate decimal 18,8 √ null
ForeignCurrencyPostingAmount money 21,4 √ null
DebtorReceiptDetailChequeFlag bit 1 √ null
DebtorReceiptDetailEFTFlag bit 1 √ null
PostingCompleteDate datetime 16,3 √ null
PostingCompleteID int 4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_GeneralLedgerPostingControlHistory_GeneralLedgerPostingControlHistorySeq Primary key Asc GeneralLedgerPostingControlHistorySeq