Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CreditorID | int | 4 | null |
|
|
|||
| CreditorIDType | varchar | 1 | √ | null |
|
|
||
| CreditorPayeeName | varchar | 50 | null |
|
|
|||
| CreditorAccountReference | varchar | 30 | null |
|
|
|||
| CreditorPaymentMethod | varchar | 5 | null |
|
|
|||
| CreditorNotifyMethod | varchar | 3 | null |
|
|
|||
| CreditorEFTDetailsFlag | bit | 1 | null |
|
|
|||
| CreditorBankBSB | varchar | 8 | √ | null |
|
|
||
| CreditorBankAccount | varchar | 15 | null |
|
|
|||
| CreditorOverrideInvDesc | varchar | 50 | √ | null |
|
|
||
| CreditorPaymentTermsDays | smallint | 2 | null |
|
|
|||
| CreditorImmediatePaymentFlag | bit | 1 | null |
|
|
|||
| CreditorSupplierCategory | varchar | 10 | null |
|
|
|||
| CreditorSupplierCategoryDescription | varchar | 50 | √ | null |
|
|
||
| CreditorSupplierApprovedFlag | bit | 1 | null |
|
|
|||
| CreditorAlertMessage | varchar | 255 | null |
|
|
|||
| CreditorAlertMessageTransFlag | bit | 1 | null |
|
|
|||
| CreditorHoldPaymentFlag | bit | 1 | null |
|
|
|||
| CreditorLastPaymentDate | datetime | 16,3 | √ | null |
|
|
||
| CreditorLastPaymentAmount | money | 21,4 | null |
|
|
|||
| CreditorLastPaymentChequeNumber | int | 4 | null |
|
|
|||
| CreditorCurrentBalance | money | 21,4 | null |
|
|
|||
| CreditorPricesIncludeTaxFlag | bit | 1 | null |
|
|
|||
| CreditorABNFlag | bit | 1 | null |
|
|
|||
| CreditorABN | varchar | 11 | null |
|
|
|||
| CreditorABNDivision | smallint | 2 | null |
|
|
|||
| CreditorGSTRegisteredFlag | bit | 1 | null |
|
|
|||
| CreditorConsignmentFlag | bit | 1 | null |
|
|
|||
| CreditorConsignmentStockPaymentFlag | bit | 1 | null |
|
|
|||
| CreditorMailName | varchar | 100 | √ | null |
|
|
||
| CreditorMailSalutation | varchar | 100 | √ | null |
|
|
||
| CreditorNameInternal | varchar | 100 | √ | null |
|
|
||
| CreditorNameExternal | varchar | 100 | √ | null |
|
|
||
| CreditorLegalFullName | varchar | 150 | √ | null |
|
|
||
| CreditorPreferredFormal | varchar | 20 | √ | null |
|
|
||
| CreditorSurname | varchar | 30 | √ | null |
|
|
||
| CreditorPhone | varchar | 15 | √ | null |
|
|
||
| CreditorOccupPhone | varchar | 15 | √ | null |
|
|
||
| CreditorOccupFax | varchar | 15 | √ | null |
|
|
||
| CreditorMobilePhone | varchar | 15 | √ | null |
|
|
||
| CreditorEmail | varchar | 100 | √ | null |
|
|
||
| CreditorCompanyName | varchar | 50 | √ | null |
|
|
||
| CreditorMailNamePrimary | varchar | 100 | √ | null |
|
|
||
| CreditorSuburb | varchar | 40 | √ | null |
|
|
||
| CreditorState | varchar | 40 | √ | null |
|
|
||
| CreditorPostCode | varchar | 5 | √ | null |
|
|
||
| CreditorCountryCode | varchar | 5 | √ | null |
|
|
||
| CreditorCountryDescription | varchar | 40 | √ | null |
|
|
||
| CreditorAddress1 | varchar | 40 | √ | null |
|
|
||
| CreditorAddress2 | varchar | 40 | √ | null |
|
|
||
| CreditorAddress3 | varchar | 40 | √ | null |
|
|
||
| CreditorAddressComma | varchar | 200 | √ | null |
|
|
||
| CreditorAddressFull | varchar | 200 | √ | null |
|
|
||
| CreditorAddressDPID | varchar | 8 | √ | null |
|
|
||
| CreditorAddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| CreditorAddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| CreditorAddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| PurchasesLastYear | money | 21,4 | √ | null |
|
|
||
| PurchasesYTD | money | 21,4 | √ | null |
|
|
||
| ActiveFlag | bit | 1 | null |
|
|
Table contained 0 rows