Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| InvoiceTransactionSeq | int | 4 | null |
|
|
|||
| CreditorID | int | 4 | null |
|
|
|||
| CreditorPayeeName | varchar | 50 | √ | null |
|
|
||
| CreditorName | varchar | 100 | null |
|
|
|||
| InvoicePostingNumber | int | 4 | null |
|
|
|||
| BankCode | varchar | 15 | √ | null |
|
|
||
| PostingForeignCurrencyCode | varchar | 15 | √ | null |
|
|
||
| InvoiceMode | char | 1 | null |
|
|
|||
| InvoiceModeDescription | varchar | 13 | √ | null |
|
|
||
| InvoiceNumber | varchar | 20 | null |
|
|
|||
| FullInvoiceDescription | varchar | 73 | null |
|
|
|||
| InvoiceDate | datetime | 16,3 | null |
|
|
|||
| InvoiceChequeNumber | int | 4 | null |
|
|
|||
| InvoiceDescription | varchar | 50 | null |
|
|
|||
| InvoiceAmount | money | 21,4 | √ | null |
|
|
||
| BankFeeAmount | money | 21,4 | null |
|
|
|||
| BankFeeAmountForeignCurrency | money | 21,4 | √ | null |
|
|
||
| BankFeeAmountActual | money | 21,4 | √ | null |
|
|
||
| BankFeeGLCode | varchar | 15 | null |
|
|
|||
| BankFeeDescription | varchar | 100 | null |
|
|
|||
| ForeignCurrencyCode | varchar | 15 | null |
|
|
|||
| LocalCurrencyAmount | money | 21,4 | null |
|
|
|||
| ForeignCurrencyAmount | money | 21,4 | √ | null |
|
|
||
| ForeignCurrencyExchangeRate | decimal | 18,8 | √ | null |
|
|
||
| InvoiceDiscount | money | 21,4 | null |
|
|
|||
| InvoiceDisputedFlag | bit | 1 | null |
|
|
|||
| InvoiceCurrencyBracketed | varchar | 17 | null |
|
|
|||
| InvoiceDueDate | datetime | 16,3 | √ | null |
|
|
||
| GLJournalSeq | int | 4 | √ | null |
|
|
||
| GLCode | varchar | 15 | √ | null |
|
|
||
| GLDescription | varchar | 50 | √ | null |
|
|
||
| GLActiveFlag | bit | 1 | √ | null |
|
|
||
| GLJournalDescription | varchar | 255 | √ | null |
|
|
||
| GLSubAllocationCode | varchar | 15 | √ | null |
|
|
||
| GLFullCode | varchar | 31 | √ | null |
|
|
||
| GLAmount | money | 21,4 | √ | null |
|
|
||
| TaxCode | varchar | 5 | √ | null |
|
|
||
| TaxCodeBracketed | varchar | 7 | √ | null |
|
|
||
| GLClassificationCode | varchar | 15 | √ | null |
|
|
||
| TaxAmount | money | 21,4 | √ | null |
|
|
||
| GrossAmount | money | 21,4 | √ | null |
|
|
||
| LocalCurrencyGLAmount | money | 21,4 | √ | null |
|
|
||
| LocalCurrencyTaxAmount | money | 21,4 | √ | null |
|
|
||
| LocalCurrencyGrossAmount | money | 21,4 | √ | null |
|
|
||
| ForeignCurrencyGLAmount | money | 21,4 | √ | null |
|
|
||
| ForeignCurrencyTaxAmount | money | 21,4 | √ | null |
|
|
||
| ReverseGLJournalSeq | int | 4 | √ | null |
|
|
||
| AutoGeneratedFlag | bit | 1 | null |
|
|
|||
| AutoGeneratedIndicator | varchar | 2 | null |
|
|
|||
| EnrolmentDepositSeq | int | 4 | null |
|
|
|||
| EnrolmentDepositCode | varchar | 10 | null |
|
|
|||
| EnrolmentDepositAmount | money | 21,4 | null |
|
|
|||
| EnrolmentDepositAmountOwing | money | 21,4 | √ | null |
|
|
||
| EnrolmentDepositName | varchar | 100 | √ | null |
|
|
||
| AssetNumber | int | 4 | null |
|
|
|||
| AssetTypeCode | varchar | 15 | null |
|
|
|||
| AssetDepreciationRate | decimal | 7,2 | null |
|
|
|||
| AssetDepreciationMethod | char | 1 | null |
|
|
|||
| AssetDescription | varchar | 130 | null |
|
|
|||
| AssetGLSubAllocationCode | varchar | 15 | null |
|
|
|||
| AssetQuantity | int | 4 | null |
|
|
|||
| AssetPurchasedDate | datetime | 16,3 | √ | null |
|
|
||
| AssetPurchasedCost | money | 21,4 | null |
|
|
|||
| CreditorNameInternal | varchar | 100 | null |
|
|
|||
| CreditorNameExternal | varchar | 100 | null |
|
|
|||
| CreditorLegalFullName | varchar | 150 | null |
|
|
|||
| CreditorPreferredFormal | varchar | 20 | null |
|
|
|||
| CreditorSurname | varchar | 30 | null |
|
|
|||
| InvoiceBankControlGLJournalSeq | int | 4 | √ | null |
|
|
||
| InvoiceCreditorControlGLJournalSeq | int | 4 | √ | null |
|
|
||
| InvoiceTaxExpenseControlGLJournalSeq | int | 4 | √ | null |
|
|
||
| ControlJournalFlag | bit | 1 | √ | null |
|
|
Table contained 0 rows