Other table in Microsoft Dynamics 365 Business Central. 15 fields, 0 records in Cronus demo.
The MigrationQB CustomerTrans table (ID 1913) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 15 fields, with a primary key of Customer Number, Transaction Type. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Customer Number, Transaction Type.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Customer Number PK | Text | Normal | |
| 2 | Document Number | Text | Normal | |
| 3 | Internal Quickbooks customer reference number. | Text | Normal | |
| 4 | Transaction Date | Date | Normal | |
| 5 | Ship Date | Date | Normal | |
| 6 | Due Date | Date | Normal | |
| 7 | Amount | Decimal | Normal | |
| 8 | Transaction Type PK | Option | Normal | |
| 9 | Internal Quickbooks transaction reference number | Text | Normal | |
| 10 | General Legder Document Number | Text | Normal | |
| 2000000000 | System ID | GUID | Normal | |
| 2000000001 | Created At | DateTime | Normal | |
| 2000000002 | Created By | GUID | Normal | |
| 2000000003 | Modified At | DateTime | Normal | |
| 2000000004 | Modified By | GUID | Normal |