| Name | Description | Type | Additional information |
|---|---|---|---|
| CustomerAgingId |
Sedona internal autonumber for Customer Aging |
integer |
None. |
| CustomerId |
Foreign key from AR_Customer table |
integer |
Required |
| Bucket1 |
1-30 days past due |
decimal number |
None. |
| Bucket2 |
31-60 days past due |
decimal number |
None. |
| Bucket3 |
61-90 days past due |
decimal number |
None. |
| Bucket4 |
91-120 days past due |
decimal number |
None. |
| Bucket5 |
120+ days past due |
decimal number |
None. |
| BalCurrent |
current balance due |
decimal number |
None. |
| BalUnapCredit | decimal number |
None. |
|
| BalUnapCash | decimal number |
None. |
|
| BalAdvanceDep | decimal number |
None. |
|
| LastLatePenalty | decimal number |
None. |
|
| LateChargeDate | string |
None. |
|
| DateLastAged | string |
None. |
|
| NFSChecks | integer |
None. |
|
| AverageDaysToPay | integer |
None. |