tcBusinessFieldName | tcDataType | tcOperator |
iiCompanyId | i | |
icDebtorCode | c | = |
icParentType | c | = |
tBankNumber1.BankNumber | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBankNumber2.BankNumber | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBankNumber1.BankNumberExtension | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBankNumber2.BankNumberIsActive | l | =,<> |
tBankNumber1.BankNumberIsActive | l | =,<> |
tBankNumber1.BankNumberIsDefault | l | =,<> |
tBankNumber1.BankNumberParentType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBankNumber1.BankNumberValidation | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBankPayFormat.BankPayFormatIsActive | l | =,<> |
tCompany.CompanyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGL.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPayFormatType.PayFormatTypeCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPayFormatType.PayFormatTypeIsActive | l | =,<> |
tPayFormatType.PayFormatTypeModule | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPayFormatType.PayFormatTypePayInstrument | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPayFormatType.PayFormatTypePayType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
field name | data type | db field | description |
tcBankNumber | character | BankNumber1.BankNumber | Bank Number |
tiBankNumber_ID | integer | BankNumber1.BankNumber_ID | Record ID |
tcBankNumberExtension | character | BankNumber1.BankNumberExtension | Bank Extension |
tlBankNumberIsActive | logical | BankNumber1.BankNumberIsActive | Active |
tlBankNumberIsDefault | logical | BankNumber1.BankNumberIsDefault | Default |
tcBankNumberParentType | character | BankNumber1.BankNumberParentType | Type |
tcBankNumberValidation | character | BankNumber1.BankNumberValidation | Validation |
tiBankPayFormat_ID | integer | BankPayFormat.BankPayFormat_ID | Record ID |
tlBankPayFormatIsActive | logical | BankPayFormat.BankPayFormatIsActive | Active |
tiCompany_ID | integer | Company.Company_ID | Record ID |
tcCompanyCode | character | Company.CompanyCode | Entity Code |
tiDebtor_ID | integer | Debtor.Debtor_ID | Record ID |
tcDebtorCode | character | Debtor.DebtorCode | A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation. |
| api annotation: | | If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create. |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tcOwnBankNumber | character | BankNumber2.BankNumber | Bank Number |
tiOwnBankNumber_ID | integer | BankNumber2.BankNumber_ID | Record ID |
tlOwnBankNumberIsActive | logical | BankNumber2.BankNumberIsActive | Active |
tcPayFormatTypeCode | character | PayFormatType.PayFormatTypeCode | Format Name |
tlPayFormatTypeIsActive | logical | PayFormatType.PayFormatTypeIsActive | Active |
tcPayFormatTypeModule | character | PayFormatType.PayFormatTypeModule | Module |
tcPayFormatTypePayInstrument | character | PayFormatType.PayFormatTypePayInstrument | Payment Instrument |
tcPayFormatTypePayType | character | PayFormatType.PayFormatTypePayType | Payment Type |
DebtorCustom | character | calculated | custom fields |
BankNumber1Custom | character | calculated | custom fields |
BankPayFormatCustom | character | calculated | custom fields |
BankNumber2Custom | character | calculated | custom fields |
CompanyCustom | character | calculated | custom fields |
GLCustom | character | calculated | custom fields |
PayFormatTypeCustom | character | calculated | custom fields |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(Debtor),rowid(BankNumber1),rowid(BankPayFormat),rowid(BankNumber2),rowid(CompanySharedSet),rowid(Company),rowid(GL),rowid(PayFormatType) |