| X | PK | 1 | PromissoryNoteNum | Promissory note number | BankPromissoryNoteNum | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | BankPromissoryNoteNum | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | PromissoryNoteNum | | SaveContents | Yes | | StringSize | 30 | | Table | BankPromissoryNoteTable | | Type | String | | Visible | Yes |
|
| X | | 2 | DocumentStatus | Status | BankPromissoryNoteStatus | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | BankPromissoryNoteStatus | | ExtendedDataType | | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DocumentStatus | | SaveContents | Yes | | Table | BankPromissoryNoteTable | | Type | Enum | | Visible | Yes |
|
| X | TR FK | 3 | BankAccountID | Bank account | CompanyBankAccountId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | CompanyBankAccountId | | GroupPrompt | | | HelpText | @SYS22506 (Name of account in financial institution) | | Label | | | Mandatory | Yes | | Name | BankAccountID | | SaveContents | Yes | | StringSize | 10 | | Table | BankPromissoryNoteTable | | Type | String | | Visible | Yes |
|
| | 4 | AmountCur | Amount | AmountCur | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AmountCur | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | @SYS73959 (Amount the promissory note was drawn for.) | | Label | @SYS6928 (Amount) | | Mandatory | No | | Name | AmountCur | | SaveContents | Yes | | Table | BankPromissoryNoteTable | | Type | Real | | Visible | Yes |
|
| FK | 5 | CurrencyCode | Currency | CurrencyCode | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | CurrencyCode | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | CurrencyCode | | SaveContents | Yes | | StringSize | 3 | | Table | BankPromissoryNoteTable | | Type | String | | Visible | Yes |
|
| FK | 6 | BeneficiaryAccountNum | Recipient | VendAccount | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | VendAccount | | GroupPrompt | | | HelpText | @SYS73960 (Account of beneficiary of the promissory note.) | | Label | @SYS4466 (Recipient) | | Mandatory | No | | Name | BeneficiaryAccountNum | | SaveContents | Yes | | StringSize | 10 | | Table | BankPromissoryNoteTable | | Type | String | | Visible | Yes |
|
| TR | 7 | TransDate | Date | TransDate | Date | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | TransDate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | TransDate | | SaveContents | Yes | | Table | BankPromissoryNoteTable | | Type | Date | | Visible | Yes |
|
| TR | 8 | Voucher | Voucher | Voucher | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Voucher | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Voucher | | SaveContents | Yes | | StringSize | 20 | | Table | BankPromissoryNoteTable | | Type | String | | Visible | Yes |
|
| TR FK | 9 | VendPromissoryNoteID | Note ID | VendPromissoryNoteID | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | VendPromissoryNoteID | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | VendPromissoryNoteID | | SaveContents | Yes | | StringSize | 20 | | Table | BankPromissoryNoteTable | | Type | String | | Visible | Yes |
|