AR
ARAdjust
The fact of application of one accounts receivable document to another, which results in an adjustment of the balances of both documents. It can be either an application of a payment document to an invoice document (such as when a payment closes an invoice), or an application of one payment document to another, such as an application of a customer refund to a payment. The entities of this type are mainly edited on the Payments and Applications (AR302000) form, which corresponds to the ARPaymentEntry graph. They can also be edited on the Applications tab of the Invoices and Memos (AR301000) form, which corresponds to the ARInvoiceEntry graph.
View API Entity: PaymentDetail
/entity/Default/25.200.001/PaymentDetail| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AdjAmt | decimal | - | ||
Description:No description available | ||||
AdjBatchNbr | nvarchar(15) | Batch Number | - | |
Description:No description available | ||||
AdjDiscAmt | decimal | - | ||
Description:No description available | ||||
AdjNbr | int | Adjustment Nbr. | - | |
Description:No description available | ||||
AdjPPDAmt | decimal | - | ||
Description:The cash discount amount displayed for the document. Given in the base currency of the company. | ||||
AdjSignedAmtNonexistent in DB | decimal? | - | ||
Description:The signed base currency value of AdjAmt depending on AdjdDocType | ||||
AdjTypeNonexistent in DB | string | - | ||
Description:Adjustment type - an incoming or outgoing adjustment. Controlled by specific BLCs, e.g. filled out in application delegate in ARInvoiceEntry. | ||||
AdjWOAmt | decimal | - | ||
Description:No description available | ||||
AdjdARAcct | int | Account | Account | |
Description:No description available | ||||
AdjdARSub | int | Subaccount | Sub | |
Description:No description available | ||||
AdjdBalSignNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
AdjdBranchID | int | Branch | Branch | |
Description:No description available | ||||
AdjdCuryIDNonexistent in DB | string | Currency | Currency | |
Description:No description available | ||||
AdjdCuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
AdjdCuryRateNonexistent in DB | decimal? | Cross Rate | - | |
Description:No description available | ||||
AdjdCustomerID | int | Customer | Customer | |
Description:No description available | ||||
AdjdDocDate | datetime | Date | - | |
Description:No description available | ||||
AdjdDocType API | char(3) | Doc. Type | - | |
Description:No description available | ||||
AdjdFinPeriodID | string | Post Period | - | |
Description:No description available | ||||
AdjdHasPPDTaxes | bit | - | ||
Description:When "true", indicates that the linked adjusted document has taxes, that are reduces cash discount taxable amount on early payment. | ||||
AdjdLineNbr API | int | Line Nbr. | ARTran | |
Description:No description available | ||||
AdjdOrderNbr | nvarchar(15) | Order Nbr. | SOOrder | |
Description:No description available | ||||
AdjdOrderType | char(2) | Order Type | SOOrderType | |
Description:No description available | ||||
AdjdOrigCuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
AdjdRefNbr API | nvarchar(15) | Reference Nbr. | ARRegister | |
Description:No description available | ||||
AdjdTBSignNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
AdjdTranPeriodID | string | - | ||
Description:No description available | ||||
AdjgBalSignNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
AdjgBranchID | int | Branch | Branch | |
Description:No description available | ||||
AdjgCuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
AdjgDocDate | datetime | - | ||
Description:No description available | ||||
AdjgDocType | char(3) | AdjgDocType | SOAdjust | |
Description:No description available | ||||
AdjgFinPeriodID | string | Application Period | - | |
Description:No description available | ||||
AdjgGLSignNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
AdjgRefNbr | nvarchar(15) | AdjgRefNbr | ARRegister | |
Description:No description available | ||||
AdjgTBSignNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
AdjgTranPeriodID | string | - | ||
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 | ||||
CuryAdjdAmt | decimal | - | ||
Description:No description available | ||||
CuryAdjdDiscAmt | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
CuryAdjdOrigAmt | decimal | - | ||
Description:No description available | ||||
CuryAdjdPPDAmt | decimal | Cash Discount Taken | - | |
Description:The cash discount amount displayed for the document. Given in the currency of the adjusted document. | ||||
CuryAdjdWOAmt | decimal | - | ||
Description:No description available | ||||
CuryAdjgAmt API | decimal | Amount Paid | - | |
Description:No description available | ||||
CuryAdjgDiscAmt | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
CuryAdjgPPDAmt API | decimal | Cash Discount Taken | - | |
Description:The cash discount amount displayed for the document. Given in the currency of the adjusting document. | ||||
CuryAdjgSignedAmtNonexistent in DB | decimal? | - | ||
Description:The signed foreign currency value of CuryAdjgAmt depending on AdjdDocType | ||||
CuryAdjgWOAmt API | decimal | Write-Off Amount | - | |
Description:No description available | ||||
CuryDiscBalNonexistent in DB | decimal? | Cash Discount Balance | - | |
Description:No description available | ||||
CuryDocBalNonexistent in DB | decimal? | Balance | - | |
Description:No description available | ||||
CuryOrigDocAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
CuryWOBalNonexistent in DB | decimal? | Write-Off Limit | - | |
Description:No description available | ||||
CustomerID | int | CustomerID | Customer | |
Description:No description available | ||||
DiscBalNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
DisplayAdjAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
DisplayBranchIDNonexistent in DB | int? | BranchID | Branch | |
Description:No description available | ||||
DisplayCuryAmtNonexistent in DB | decimal? | Amount Paid | - | |
Description:No description available | ||||
DisplayCuryIDNonexistent in DB | string | Currency | Currency | |
Description:No description available | ||||
DisplayCuryInfoIDNonexistent in DB | long? | - | ||
Description:No description available | ||||
DisplayCuryPPDAmtNonexistent in DB | decimal? | Cash Discount Taken | - | |
Description:No description available | ||||
DisplayCuryWOAmtNonexistent in DB | decimal? | Write-Off Amount | - | |
Description:No description available | ||||
DisplayCustomerIDNonexistent in DB | int? | Customer | Customer | |
Description:No description available | ||||
DisplayDocDateNonexistent in DB | DateTime? | Date | - | |
Description:No description available | ||||
DisplayDocDescNonexistent in DB | string | Description | - | |
Description:No description available | ||||
DisplayDocTypeNonexistent in DB | string | Doc. Type | - | |
Description:No description available | ||||
DisplayFinPeriodIDNonexistent in DB | string | Post Period | MasterFinPeriod | |
Description:No description available | ||||
DisplayProcStatusNonexistent in DB | string | Proc. Status | - | |
Description:No description available | ||||
DisplayRefNbrNonexistent in DB | string | Reference Nbr. | ARRegister | |
Description:No description available | ||||
DisplayStatusNonexistent in DB | string | Status | - | |
Description:No description available | ||||
DocBalNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
HasExpiredComplianceDocumentsNonexistent in DB | bool? | Expired Compliance | - | |
Description:No description available | ||||
HistoryAdjdDocTypeNonexistent in DB | string | Type | - | |
Description:No description available | ||||
Hold | bit | - | ||
Description:No description available | ||||
InvoiceID | uniqueidentifier | - | ||
Description:No description available | ||||
IsCCAuthorized | bit | - | ||
Description:No description available | ||||
IsCCCaptured | bit | - | ||
Description:No description available | ||||
IsCCPayment | bit | - | ||
Description:No description available | ||||
IsInitialApplication | bit | - | ||
Description:Specifies (if set to "true") that the application has been created for the migrated document to affect all needed balances. | ||||
IsMigratedRecord | bit | - | ||
Description:Specifies (if set to "true") that the record has been created in migration mode without affecting GL module. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
MemoID | uniqueidentifier | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigDocAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
PPDVATAdjDescriptionNonexistent in DB | string | Tax Adjustment | - | |
Description:The description of the adjustment, which is generated on the Generate AR Tax Adjustments (AR504500) form. This field is needed for showing on the Payments and Applications (AR302000) screen like a hyperlink. For example - "Credit Memo. AR012053". Value is ARAdjust.PPDVATAdjDocType + ARAdjust.PPDVATAdjRefNbr field. | ||||
PPDVATAdjDocType | char(3) | - | ||
Description:The doc type of the adjustment, which is generated on the Generate AR Tax Adjustments (AR504500) form. Corresponds to the ARInvoice.docType field. | ||||
PPDVATAdjRefNbr | nvarchar(15) | Tax Adjustment | ARInvoice | |
Description:The reference number of the vat adjustment document, which is generated on the Generate AR Tax Adjustments (AR504500) form. Corresponds to the ARInvoice.RefNbr field. | ||||
PaymentCaptureFailed | bit | - | ||
Description:No description available | ||||
PaymentID | uniqueidentifier | - | ||
Description:No description available | ||||
PaymentPendingProcessing | bit | - | ||
Description:No description available | ||||
PaymentReleased | bit | - | ||
Description:No description available | ||||
PendingPPD | bit | Subject to Tax Adjustment | - | |
Description:A Boolean value that indicates (if it is true) that the linked adjusted document has been paid in full and to close the document, you need to apply the cash discount by generating a credit memo on the Generate AR Tax Adjustments (AR504500) form. | ||||
PrintAdjdDocTypeNonexistent in DB | string | Type | - | |
Description:No description available | ||||
PrintAdjgDocTypeNonexistent in DB | string | Type | - | |
Description:No description available | ||||
RGOLAmt | decimal | - | ||
Description:No description available | ||||
Recalculatable | bit | - | ||
Description:Specifies (if set to true) that the invoice has external taxes and have to recalculate the amount paid If the user manually adjust the amount, this flag's value is set to false | ||||
Released | bit | ARAdjust | ||
Description:No description available | ||||
RemoveNonexistent in DB | string? | Remove | - | |
Description:Remove Action | ||||
ReverseGainLossNonexistent in DB | bool? | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:Indicates whether the record is selected for processing. | ||||
StatementDate | datetime | - | ||
Description:No description available | ||||
TaxInvoiceNbr | nvarchar(15) | Tax Doc. Nbr | - | |
Description:The "Tax Doc. Nbr" of the tax transaction, generated on the "Recognize Output/Input VAT" (TX503000/TX503500) form. Corresponds to the TaxTran.TaxInvoiceNbr field. | ||||
VoidAdjNbr | int | - | ||
Description:No description available | ||||
VoidApplNonexistent in DB | bool? | Void Application | - | |
Description:No description available | ||||
Voided | bit | - | ||
Description:No description available | ||||
WOBalNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
WriteOffReasonCode API | nvarchar(20) | Write-Off Reason Code | ReasonCode | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||