| Name | Description | Type | Additional Information |
|---|---|---|---|
| Vendor |
The Vendor ID the AP Bill is for. The combination of Vendor, Invoice, and Bill Date are what uniquely identify an AP Bill. |
string |
Required Max length: 10 |
| InvoiceNumber |
The number of the Invoice the AP Bill paid. One of the values returned by the GetApBill method of the API. |
string |
Required Max length: 25 |
| Description |
User entered descript or short note about the AP Bill. |
string |
Max length: 40 |
| EntryDate |
The date the bill was entered. |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| BillDate |
The date of the bill. |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| DueDate |
The date the bill is due. |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| Source |
the specific transaction in Agvance that created bill. |
string |
Max length: 10 |
| UserName |
The name of the user that entered the bill. |
string |
Max length: 20 |
| PONumber |
The Purchase Order Number for the bill. |
string |
Max length: 10 |
| OnHoldYN |
'True' or 'False' value indicating whether the bill is on hold or not. |
boolean |
Must be 0, 1, True, or False |
| PaidByDate1 |
The date to pay the bill by in order to receive discount1. |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| PaidByDate2 |
The date to pay the bill by in order to receive discount2. |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| PaidByDate3 |
The date to pay the bill by in order to receive discount3. |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| PaidByDate4 |
The date to pay the bill by in order to receive discount4. |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| PaidByDate5 |
The date to pay the bill by in order to receive discount5. |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| DeductionPercent1 |
The Discount percentage given if the bill is paid by PaidBy1 date. |
decimal number |
Max of 2 decimal places Must be numeric |
| DeductionPercent2 |
The Discount percentage given if the bill is paid by PaidBy2 date. |
decimal number |
Max of 2 decimal places Must be numeric |
| DeductionPercent3 |
The Discount percentage given if the bill is paid by PaidBy3 date. |
decimal number |
Max of 2 decimal places Must be numeric |
| DeductionPercent4 |
The Discount percentage given if the bill is paid by PaidBy4 date. |
decimal number |
Max of 2 decimal places Must be numeric |
| DeductionPercent5 |
The Discount percentage given if the bill is paid by PaidBy5 date. |
decimal number |
Max of 2 decimal places Must be numeric |
| DiscountAmount1 |
The Discount amount for the bill if paid by PaidBy1. |
decimal number |
Max of 2 decimal places Must be numeric |
| DiscountAmount2 |
The Discount amount for the bill if paid by PaidBy2. |
decimal number |
Max of 2 decimal places Must be numeric |
| DiscountAmount3 |
The Discount amount for the bill if paid by PaidBy3. |
decimal number |
Max of 2 decimal places Must be numeric |
| DiscountAmount4 |
The Discount amount for the bill if paid by PaidBy4. |
decimal number |
Max of 2 decimal places Must be numeric |
| DiscountAmount5 |
The Discount amount for the bill if paid by PaidBy5. |
decimal number |
Max of 2 decimal places Must be numeric |
| DiscountGL |
The General Ledger account to post the bill discount to. |
string |
Max length: 10 |
| Gross |
The amount due before the discount is applied. |
decimal number | |
| Discount |
The Amount of the discount. |
decimal number | |
| Net |
The Amount due after the discount is applied. |
decimal number | |
| DatePaid |
The date the bill was paid. |
string |
Data type: DateTime Format must be MM/dd/yyyy |
| AmountPaid |
The amount actually paid. |
decimal number | |
| PaidYN |
'True' or 'False' indicating if the bill has been paid or not. |
boolean |
Must be 0, 1, True, or False |
| VoidedYN |
'True' or 'False' indicating if the bill has been voided or not. |
boolean |
Must be 0, 1, True, or False |
| ReversedYN |
'True' or 'False' indicating if the bill has been reversed or not. |
boolean |
Must be 0, 1, True, or False |
| Amount1099 |
The bill amount that needs reported on the 1099 tax form. |
decimal number |
Max of 2 decimal places Must be numeric Range: inclusive between -1000000000000.00 and 1000000000000.00 |
| CheckNumber |
The check number used to pay the bill. |
string |
Max length: 15 |
| FiscalMonth |
The fiscal month the bill is in. |
integer | |
| UsePrepayYN |
'True' or 'False' indicating if the bill was for prepay or not. |
boolean |
Must be 0, 1, True, or False |
| Transferred |
'True' or 'False' indicating if the bill was transferred or not. |
boolean |
Must be 0, 1, True, or False |
| LocationID |
The ID of the location the bill was entered in. |
string |
Max length: 6 |
| SpecialHandling |
User entered special handling instructions for the AP Bill. |
string |
Max length: 60 |
| PayByEFTYN |
'True' or 'False' value indicating if bill was paid by Electronic Fund Transfer. |
boolean |
Must be 0, 1, True, or False |
| Notes |
User entered notes or comments on the bill. |
string |
Max length: 255 |
| POInvoice |
The PO Invoice number on the bill. |
string |
Max length: 25 |
| APPurchaseOrder |
Whether this is an AP Bill or AP Purchase Order. |
boolean |
Must be 0, 1, True, or False |
| UserID |
The user who entered the bill. |
string |
Max length: 3 |
| ApBillGuid |
Globally unique identifier of the AP Bill |
globally unique identifier | |
| BillDetail |
A list that displays the amounts paid and discounts applied on the bill. |
Collection of clsAPBillDt |
List cannot be empty |