Skip to main content
AR

ARSetup

PX.Objects.AR
Field NameTypeDisplay NameForeign Key
AddOpenPaymentsAndCreditMemos
bitAdd Open Payments and Credit Memos-
Description:No description available
AddUnpaidPPI
bitAdd Unpaid Prepayment Invoices-
Description:Specifies default behavior of Prepayment Invoices on Prepare Unning Letters. Specific for feature VAT Recognition on Prepayments.
AgeCredits
bitAge Credits-
Description:No description available
AlwaysFromBaseCury
bitAlways Calculate Price from Base Currency Price-
Description:No description available
ApplyQuantityDiscountBy
char(1)Apply Quantity Discounts To-
Description:No description available
AutoLoadMaxDocs
smallintMax. Number of Documents by Auto Loading-
Description:No description available
AutoPost
bitAutomatically Post on Release-
Description:No description available
AutoReleaseDunningFee
bitAutomatically Release Dunning Fee Documents-
Description:No description available
AutoReleaseDunningLetter
bitAutomatically Release Dunning Letters-
Description:No description available
AutoReleasePPDCreditMemo
bitAutomatically Release Tax Adjustments-
Description:A Boolean value that indicates (if it is ) that the credit memo generated on the Generate AR Tax Adjustments (AR504500) form will be released automatically.
BalanceWriteOffDefault Navigation
nvarchar(20)Balance Write-Off Reason CodeReasonCode
Description:No description available
BatchNumberingIDDefault Navigation
nvarchar(10)GL Batch Numbering SequenceNumbering
Description:No description available
ConsolidatedStatement
bitConsolidate Statements for all Branches-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
CreditAdjNumberingIDDefault Navigation
nvarchar(10)Credit Memo Numbering SequenceNumbering
Description:No description available
CreditCheckError
bitHold Document on Failed Credit Check-
Description:No description available
CreditWriteOffDefault Navigation
nvarchar(20)Credit Write-Off Reason CodeReasonCode
Description:No description available
DataInconsistencyHandlingMode
char(1)Extra Data Validation-
Description:No description available
DebitAdjNumberingIDDefault Navigation
nvarchar(10)Debit Memo Numbering SequenceNumbering
Description:No description available
DefaultRateTypeIDDefault Navigation
nvarchar(6)Default Rate TypeCurrencyRateType
Description:No description available
DefaultTranDesc
char(1)Default Transaction Description-
Description:No description available
DefFinChargeFromCycle
bitSet Default Overdue Charges by Statement Cycle-
Description:No description available
DfltCustomerClassIDDefault Navigation
nvarchar(10)Default Customer Class IDCustomerClass
Description:No description available
DunningFeeInventoryIDDefault Navigation
intDunning Fee ItemInventoryItem
Description:No description available
DunningFeeNumberingIDDefault Navigation
nvarchar(10)Dunning Fee Numbering SequenceNumbering
Description:No description available
DunningFeeTermIDDefault Navigation
nvarchar(10)TermsTerms
Description:The identifier of the Dunning Fee Terms object that can be set for all dunning fees as default one. Optinal field that defaults the credit terms for dunning fee invoice.
DunningLetterBranchIDDefault Navigation
intDunning Letter from BranchBranch
Description:No description available
DunningLetterProcessType
intDunning Process-
Description:No description available
EmailBeforeRelease
bitRequire Invoice/Memo Emailing Before Release-
Description:No description available
FinChargeFirst
bitApply Payments to Overdue Charges First-
Description:No description available
FinChargeNumberingIDDefault Navigation
nvarchar(10)Overdue Charge Numbering SequenceNumbering
Description:No description available
FinChargeOnCharge
bitCalculate on Overdue Charge Documents-
Description:No description available
HoldEntry
bitHold Documents on Entry-
Description:No description available
IncludeNonOverdueDunning
bitAdd Coming-Due Documents-
Description:No description available
IntegratedCCProcessing
bitEnable Integrated CC Processing-
Description:No description available
IntercompanySalesAccountDefault
char(1)Use Intercompany Sales Account From-
Description:No description available
InvoiceNumberingIDDefault Navigation
nvarchar(10)Invoice Numbering SequenceNumbering
Description:No description available
InvoicePrecision
decimal(19, 4)Rounding Precision-
Description:No description available
InvoiceRounding
char(1)Rounding Rule for Invoices-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
LineDiscountTarget
char(1)Line Discount Basis-
Description:No description available
LoadSalesPricesUsingAlternateID
bitLoad Sales Prices by Alternate ID-
Description:When set to "true", makes it possible to load Sales Prices by alternate ID
MigrationMode
bitActivate Migration Mode-
Description:Specifies (if set to "true") that migration mode is activated for the AR module. In other words, this gives an ability to create the document with starting balance without any applications.
NoteID
uniqueidentifier-
Description:No description available
NumberOfMonths
intNumber of Months-
Description:No description available
PaymentNumberingIDDefault Navigation
nvarchar(10)Payment Numbering SequenceNumbering
Description:No description available
PerRetainHist
smallintPeriods to Retain History-
Description:No description available
PerRetainTran
smallintKeep Transactions for-
Description:No description available
PPDCreditMemoDescr
nvarchar(150)Tax Adjustment Description-
Description:The description of the credit memo generated on the Generate AR Tax Adjustments (AR504500) form.
PrepareDunningLetters
char(1)Prepare Dunning Letters-
Description:No description available
PrepareStatements
char(1)Prepare Statements-
Description:No description available
PrepaymentInvoiceNumberingIDDefault Navigation
nvarchar(10)Prepayment Invoice Numbering SequenceNumbering
Description:No description available
PriceWSNumberingIDDefault Navigation
nvarchar(10)Price Worksheet Numbering SequenceNumbering
Description:No description available
PrintBeforeRelease
bitRequire Invoice/Memo Printing Before Release-
Description:No description available
RequireControlTotal
bitValidate Document Totals on Entry-
Description:No description available
RequireExtRef
bitRequire Payment Reference on Entry-
Description:When set to "true", indicates that users must fill Ext. Ref. Number box (GLTranDoc.ExtRefNbr).
RetainageInvoicesAutoRelease
bitAutomatically Release Retainage Documents-
Description:No description available
RetainTaxes
bitRetain Taxes-
Description:No description available
RetentionType
char(1)Retention Type-
Description:No description available
SalesSubMask
varchar(30)Combine Sales Sub. From-
Description:No description available
SPCommnCalcType
char(1)Salesperson Commission By-
Description:No description available
SPCommnPeriodType
char(1)Commission Period Type-
Description:No description available
StatementBranchIDDefault Navigation
intStatement from BranchBranch
Description:No description available
SummaryPostNonexistent in DB
bitPost Summary on Updating GL-
Description:No description available
TermsInCreditMemos
bitUse Credit Terms in Credit Memos-
Description:Activates possibility to use Credit Terms in credit memos
TransactionPosting
char(1)Transaction Posting-
Description:No description available
tstamp
timestamp-
Description:No description available
UsageNumberingIDDefault Navigation
nvarchar(10)Usage Transaction Numbering SequenceNumbering
Description:No description available
ValidateDataConsistencyOnReleaseObsolete
bit-
Description:No description available
WriteOffNumberingIDDefault Navigation
nvarchar(10)Write-Off Numbering SequenceNumbering
Description:No description available