AR
ARBalances
A balance record of an accounts receivable customer. Customer balances are accumulated into records across the following dimensions: branch, customer, and customer location. The balance records are created and updated by the ARDocumentRelease graph during the document release process.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AverageDaysToPay | int | - | ||
Description:No description available | ||||
BranchID | int | Branch | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CurrentBal | decimal | - | ||
Description:No description available | ||||
CuryID | nvarchar(5) | - | ||
Description:No description available | ||||
CustomerID | int | Customer | ||
Description:No description available | ||||
CustomerLocationID | int | Location | ||
Description:No description available | ||||
DatesUpdatedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
LastDocDate | datetime | - | ||
Description:No description available | ||||
LastInvoiceDate | datetime | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
NumberInvoicePaid | int | - | ||
Description:No description available | ||||
OldInvoiceDate | datetime | - | ||
Description:No description available | ||||
PaidInvoiceDays | int | - | ||
Description:No description available | ||||
StatementRequired | bit | - | ||
Description:No description available | ||||
TotalOpenOrders | decimal | - | ||
Description:No description available | ||||
TotalPrepayments | decimal | - | ||
Description:No description available | ||||
TotalQuotations | decimal | - | ||
Description:No description available | ||||
TotalShipped | decimal | - | ||
Description:No description available | ||||
UnreleasedBal | decimal | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||