APSetup

PX.Objects.AP

53 of 53 fields

	Field Name	Type	Display Name	Foreign Key
	`ApplyQuantityDiscountBy`	`char(1)`	Apply Quantity Discounts To	-
Description:No description available
	`AutoPost`	`bit`	Automatically Post on Release	-
Description:If set to "true", indicates that transactions will be automatically posted to the General Ledger once they are released in the Accounts Payable module.
	`BatchNumberingID`Default Navigation	`nvarchar(10)`	Batch Numbering Sequence	Numbering
Description:The numbering sequence used for batches generated by the Accounts Payable module. This field is a link to a Numbering record.
	`CheckNumberingID`Default Navigation	`nvarchar(10)`	Payment Numbering Sequence	Numbering
Description:The numbering sequence used for Accounts Payable payments. This field is a link to a Numbering record.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CreditAdjNumberingID`Default Navigation	`nvarchar(10)`	Credit Adjustment Numbering Sequence	Numbering
Description:The numbering sequence used for credit adjustments. This field is a link to a Numbering record.
	`DataInconsistencyHandlingMode`	`char(1)`	Extra Data Validation	-
Description:No description available
	`DebitAdjNumberingID`Default Navigation	`nvarchar(10)`	Debit Adjustment Numbering Sequence	Numbering
Description:The numbering sequence used for debit adjustments. This field is a link to a Numbering record.
	`DefaultTranDesc`	`char(1)`	Default Transaction Description	-
Description:Default way to populate description for new transactions. "C" - Combination of Vendor ID and Name, "I" - Vendor ID, "N" - Vendor Name, "U" - description entered by user.
	`DfltVendorClassID`Default Navigation	`nvarchar(10)`	Default Vendor Class ID	VendorClass
Description:No description available
	`EarlyChecks`	`bit`	Enable Early Payments	-
Description:If set to "true", allows to enter and print checks for bills, belonging to future periods. Defaults to "true".
	`ExpenseSubMask`	`varchar(30)`	Combine Expense Sub. From	-
Description:The subaccount mask that defines the rule of choosing segment values for the expense subaccount to be used for non-stock items on data entry forms in the Accounts Payable module. To set up the rule, select a segment, press F3, and choose a source of the segment value, which is one of the following options: The mask may include the following characters: C: Expense subaccount associated with branch E: Subaccount associated with employee I: Subaccount associated with non-stock item L: Subaccount associated with vendor location For a segment, the characters designating each option are repeated as many times as there are characters in the segment.
	`HoldEntry`	`bit`	Hold Documents on Entry	-
Description:If set to "true", new documents will have the On Hold status by default, which prevents them from being released.
	`IntercompanyExpenseAccountDefault`	`char(1)`	Use Intercompany Expense Account From	-
Description:No description available
	`InvoiceNumberingID`Default Navigation	`nvarchar(10)`	Bill Numbering Sequence	Numbering
Description:The numbering sequence used for Accounts Payable bills. This field is a link to a Numbering record.
	`InvoicePrecision`	`decimal(19, 4)`	Rounding Precision	-
Description:Determines the smallest value to round bills amount to. Doesn't have any effect unless Invoice Rounding feature is enabled. If Rounding Rule (APSetup.InvoiceRounding) is set to Use Currency Precision (""N"") the value of this field similarly does not affect rounding. Allowed values are: ""0.05"", ""0.1"", ""0.5"", ""1.0"", ""10"", ""100"". Defaults to ""0.1""
	`InvoiceRounding`	`char(1)`	Rounding Rule for Bills	-
Description:Determines the rule to be used to round bills total amounts. Doesn't have any effect unless Invoice Rounding feature is enabled. Smallest unit to round to is determined by the precision of the Currency if Use Currency Precision is selected, or by the value of the APSetup.InvoicePrecision field otherwise. Allowed values are: ""N"" - Use Currency Precision: To round the totals to the decimal precision supported by the currency of the document. (See Currency.DecimalPlaces field.) ""R"" - Nearest: To round each bill total to the nearest multiple of the smallest unit (specified in the Rounding Precision box). (Mathematical rounding) ""C"" - Up: To round up each bill total to the next multiple of the smallest unit. ""F"" - Down: To round down each bill total to the previous multiple of the smallest unit.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`LoadVendorsPricesUsingAlternateID`	`bit`	Load Vendor Prices by Alternate ID	-
Description:When set to "true", makes it possible to load Vendor Prices by alternate ID
	`MigrationMode`	`bit`	Activate Migration Mode	-
Description:Specifies (if set to "true") that migration mode is activated for the AP 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`	`int`	Number of Months	-
Description:The number of months the history of price changes should be kept. This field is relevant if the Fixed Number of Months ("F") option is selected in the RetentionType.
	`PastDue00`	`smallint`	Aging Period 1	-
Description:The maximum number of days outstanding or past due for the document to be included in the first category.
	`PastDue01`	`smallint`	Aging Period 2	-
Description:The maximum number of days outstanding or past due for the document to be included in the second category. If the value here is greater than the PastDue00 value, documents from the first category are not included in the second category.
	`PastDue02`	`smallint`	Aging Period 3	-
Description:The maximum number of days outstanding or past due for the document to be included in the third category. If the value here is greater than the PastDue01 value, documents from the second category are not included in the third category.
	`PaymentLeadTime`	`smallint`	Payment Lead Time	-
Description:The number of days on average required for a payment to reach a vendor location. This value is used as a default value for multiple boxes on the Approve Bills for Payment (AP502000) and Prepare Payments (AP503000) forms.
	`PerRetainHist`	`smallint`	Periods to Retain History	-
Description:Defines the number of periods, during which the Accounts Payable module history will be stored in the database. Increasing this value later, after some period of use, is not recommended, because the history deleted from the database cannot be restored and some reports will be incomplete.
	`PerRetainTran`	`smallint`	Keep Transactions for	-
Description:Defines the number of periods, during which the batches generated by the Accounts Payable module will be stored in the database. Increasing this value later, after some period of use, is not recommended, because the history deleted from the database cannot be restored and some reports will be incomplete.
	`PPDDebitAdjustmentDescr`	`nvarchar(50)`	Tax Adjustment Description	-
Description:No description available
	`PrepaymentInvoiceNumberingID`Default Navigation	`nvarchar(10)`	Prepayment Invoice Numbering Sequence	Numbering
Description:No description available
	`PriceWSNumberingID`Default Navigation	`nvarchar(10)`	Price Worksheet Numbering Sequence	Numbering
Description:No description available
	`PrintDirectSalesOn`	`char(2)`	Report Direct Sales On	-
Description:No description available
	`RaiseErrorOnDoubleInvoiceNbr`	`bit`	Raise an Error on Duplicate Vendor Reference Number	-
Description:When set to "true", makes the system generate errors when a new document is created with a value in the Vendor Ref. box that has already been used in the system.
	`ReclassifyInvoices`	`bit`	Allow Bill Reclassification	-
Description:No description available
	`RequireApprovePayments`	`bit`	Require Approval of Bills Prior to Payment	-
Description:If set to "true", indicates that approval of bills is required before bills may be paid. Bills can be approved using the Approve Bills for Payment (AP502000) form.
	`RequireControlTaxTotal`	`bit`	Validate Tax Totals on Entry	-
Description:No description available
	`RequireControlTotal`	`bit`	Validate Document Totals on Entry	-
Description:If set to "true", adds the Amount box to the Summary area of the Bills and Adjustments (AP301000) form. To save a document in the Balanced status, the user must enter the document total in this box after reviewing the document.
	`RequireSingleProjectPerDocument`Obsolete	`bit`		-
Description:No description available
	`RequireVendorRef`	`bit`	Require Vendor Reference	-
Description:When set to "true", indicates that users must fill in Vendor Ref. (APInvoice.InvoiceNbr) on data entry forms in the Accounts Payable, Taxes and Purchase Orders modules. Also this check box controls the Ext. Ref. Number box (GLTranDoc.ExtRefNbr) on the Journal Vouchers (GL304000) form of the General Ledger module.
	`RetainageBillsAutoRelease`	`bit`	Automatically Release Retainage Documents	-
Description:No description available
	`RetainTaxes`	`bit`	Retain Taxes	-
Description:No description available
	`RetentionType`	`char(1)`	Retention Type	-
Description:The way the history of prices will be retained. Allowed values are: "L" - Last Price Only: the last defined price is kept; "F" - Fixed Number of Months: the history of price changes is kept for the number of months specified in the NumberOfMonths field. The period is calculated back from the current system date.
	`SuggestPaymentAmount`	`bit`	Set Zero Payment Amount to Application Amount	-
Description:No description available
	`SummaryPost`Nonexistent in DB	`bit`	Post Summary on Updating GL	-
Description:Indicates whether to post transactions to GL as summary or in detailed mode. This field depends on and changes TransactionPosting field when set. "true" indicates that summary should be posted (corresponds to ""S"" value of the TransactionPosting field.)
	`TermsInDebitAdjustments`	`bit`	Use Credit Terms in Debit Adjustments	-
Description:Activates possibility to use Credit Terms, Due date and Discount date in debit adjustments
	`TransactionPosting`	`char(1)`	Transaction Posting	-
Description:Indicates whether to post transactions to GL as summary or in detailed mode. Is set by the SummaryPost field. ""S"" - Summary, ""D"" - Detail. Defaults to Detail.
	`tstamp`	`timestamp`		-
Description:No description available
	`ValidateDataConsistencyOnRelease`Obsolete	`bit`		-
Description:No description available
	`VendorPriceUpdate`	`char(1)`	Vendor Price Update	-
Description:No description available