Fields - GLHistory
| Field Name | Data Type | Description, Example |
|---|---|---|
| DealerId | string | Internal Dealer Identifier (intentionally left blank) |
| glhistoryid(key) | long | Id for history record |
| jounralentryid(key) | long | Id for journal entry record |
| accountdepartment(key) | string | GL Account number |
| description | string | Description of GL account |
| debit | money | Debit amount of transaction |
| credit | money | Credit amount of transaction |
| documentnumber(key) | string | Dealer specified document identifier |
| date | date | Date of GL History record |
| scheduleid | bigint | Foreign identifier to scheduled accounts |
| journal | string | Journal entry type – All Others, Manual Batch 1, Manual Batch 2, Recurring Batch, and ‘blank’ |
| schedxrefid | bigint | Foreign identifier to accounting transactions |
| scheddocid | bigint | Foreign identifier to accounting document |
| schedacctid | string | Foreign identifier – VendorId, MajorunitId, CustomerId, PartshipmentId |
| locationdocumenttype | string | Origination of accounting document – Parts Invoice, Special Order Deposit, Miscellaneous Receipt, Paid Out, Parts Inventory Update, Bar Code Inventory Update, Part Receiving Document, Part Return Document, Repair Order, Repair Order Deposit, Warranty Claim Credit, Reverse Repair Order, Sublet Closeout, Reverse Sublet Closeout, Sales Deal, Sales Deposit, Major Unit, Trade Purchase, RO Cancel Adjustment, Sales Deal Unfinalize, Trade Un-Purchase, Major Unit Receiving to AP, Major Unit Transfer Send, Major Unit Transfer Receive, Resolving Adjustment, Reservation Charge, Rental Payment, Rental Posting, Reservation Invoice, Rental Receivables Conversion, Bank Deposit, AR Credit Card Payment, ‘blank’ |
| customername | string | Full customer name |
| arcustomername | string | Full customer name on the AR record |
| apvendorname | string | Name of AP vendor |
| stocknumber | string | Major Unit stock number |
| lienholder | string | Name of lienholder on deal |
| creationdate | date | Date when GL record was posted |
| acctdeptid | long | Account department Id for journal entry record |
| AppliedDocId | long | Associated ID for applied documents, references to the schedxrefid. |