AR
ARAdjust2
PX.Objects.AR109 of 109 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AdjdDocType | char(3) | Document Type | - | |
Description:No description available | ||||
AdjdLineNbr | int | Line Nbr. | ARTran | |
Description:No description available | ||||
AdjdRefNbr | nvarchar(15) | Reference Nbr. | ARInvoice | |
Description:No description available | ||||
AdjgDocType | char(3) | Doc. Type | - | |
Description:No description available | ||||
AdjgRefNbr | nvarchar(15) | Reference Nbr. | ARPayment | |
Description:No description available | ||||
AdjNbr | int | Adjustment Nbr. | - | |
Description:No description available | ||||
AdjAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
AdjBatchNbr | nvarchar(15) | Batch Number | - | |
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 | nvarchar(5) | 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 | datetime2 | Date | - | |
Description:No description available | ||||
AdjdFinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
AdjdHasPPDTaxes | bit | - | ||
Description:No description available | ||||
AdjDiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
AdjdOrderNbr | nvarchar(15) | Order Nbr. | SOAdjust | |
Description:No description available | ||||
AdjdOrderType | char(2) | Order Type | SOOrderType | |
Description:No description available | ||||
AdjdOrigCuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
AdjdTBSignNonexistent in DB | decimal | - | ||
Description:No description available | ||||
AdjdTranPeriodID | char(6) | - | ||
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 | datetime2 | - | ||
Description:No description available | ||||
AdjgFinPeriodID | char(6) | - | ||
Description:No description available | ||||
AdjgGLSignNonexistent in DB | decimal | - | ||
Description:No description available | ||||
AdjgTBSignNonexistent in DB | decimal | - | ||
Description:No description available | ||||
AdjgTranPeriodID | char(6) | - | ||
Description:No description available | ||||
AdjPPDAmt | decimal | - | ||
Description:No description available | ||||
AdjSignedAmt | decimal | - | ||
Description:No description available | ||||
AdjTypeNonexistent in DB | nchar(1) | - | ||
Description:No description available | ||||
AdjWOAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryAdjdAmt | decimal(19, 4) | Amount Paid | - | |
Description:No description available | ||||
CuryAdjdDiscAmt | decimal(19, 4) | Cash Discount Taken | - | |
Description:No description available | ||||
CuryAdjdOrigAmt | decimal(19, 4) | Original Amount Paid | - | |
Description:No description available | ||||
CuryAdjdPPDAmt | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
CuryAdjdWOAmt | decimal(19, 4) | Write-Off Amount | - | |
Description:No description available | ||||
CuryAdjgAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryAdjgDiscAmt | decimal(19, 4) | Cash Discount Taken | - | |
Description:No description available | ||||
CuryAdjgPPDAmt | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
CuryAdjgSignedAmt | decimal | - | ||
Description:No description available | ||||
CuryAdjgWOAmt | decimal(19, 4) | - | ||
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 | Customer | 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 | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
DisplayCuryInfoIDNonexistent in DB | bigint | - | ||
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 | nvarchar(150) | Description | - | |
Description:No description available | ||||
DisplayDocTypeNonexistent in DB | nchar(3) | Doc. Type | - | |
Description:No description available | ||||
DisplayFinPeriodIDNonexistent in DB | nchar(6) | Post Period | MasterFinPeriod | |
Description:No description available | ||||
DisplayProcStatusNonexistent in DB | nchar(3) | Proc. Status | - | |
Description:No description available | ||||
DisplayRefNbrNonexistent in DB | nvarchar(15) | Reference Nbr. | ARRegister | |
Description:No description available | ||||
DisplayStatusNonexistent in DB | nchar(1) | Status | - | |
Description:No description available | ||||
DocBalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
HistoryAdjdDocTypeNonexistent in DB | nchar(3) | 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:No description available | ||||
IsMigratedRecord | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(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 | ||||
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:No description available | ||||
PPDVATAdjDescriptionNonexistent in DB | nvarchar(40) | Tax Adjustment | - | |
Description:No description available | ||||
PPDVATAdjDocType | char(3) | - | ||
Description:No description available | ||||
PPDVATAdjRefNbr | nvarchar(15) | Tax Adjustment | ARInvoice | |
Description:No description available | ||||
PrintAdjdDocTypeNonexistent in DB | nchar(3) | Type | - | |
Description:No description available | ||||
PrintAdjgDocTypeNonexistent in DB | nchar(3) | Type | - | |
Description:No description available | ||||
Recalculatable | bit | - | ||
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
ReverseGainLossNonexistent in DB | bit | - | ||
Description:No description available | ||||
RGOLAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
StatementDate | datetime2 | - | ||
Description:No description available | ||||
TaxInvoiceNbr | nvarchar(15) | Tax Doc. Nbr | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VoidAdjNbr | int | - | ||
Description:No description available | ||||
VoidApplNonexistent in DB | bit | Void Application | - | |
Description:No description available | ||||
Voided | bit | - | ||
Description:No description available | ||||
WOBalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
WriteOffReasonCode | nvarchar(20) | Write-Off Reason Code | ReasonCode | |
Description:No description available | ||||