AP
APQuickCheck
PX.Objects.AP.Standalone190 of 190 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocType | char(3) | Type | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | - | |
Description:No description available | ||||
AdjCntr | int | - | ||
Description:No description available | ||||
AdjDate | datetime2 | Date | - | |
Description:No description available | ||||
AdjFinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
AdjTranPeriodID | char(6) | - | ||
Description:No description available | ||||
APAccountID | int | AP Account | Account | |
Description:No description available | ||||
APInvoiceDocType | char(3) | - | ||
Description:No description available | ||||
APInvoiceRefNbr | nvarchar(15) | - | ||
Description:No description available | ||||
APPaymentDocType | char(3) | - | ||
Description:No description available | ||||
APPaymentRefNbr | nvarchar(15) | - | ||
Description:No description available | ||||
Approved | bit | - | ||
Description:No description available | ||||
APSubID | int | AP Subaccount | Sub | |
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Nbr. | Batch | |
Description:No description available | ||||
BillCntr | int | - | ||
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
CashAccountID | int | Cash Account | - | |
Description:No description available | ||||
CATranID | bigint | - | ||
Description:No description available | ||||
ChargeAmt | decimal | - | ||
Description:No description available | ||||
ChargeCntr | int | - | ||
Description:No description available | ||||
ClearDate | datetime2 | Clear Date | - | |
Description:No description available | ||||
Cleared | bit | Cleared | - | |
Description:No description available | ||||
ClosedDate | datetime2 | Closed Date | - | |
Description:No description available | ||||
ClosedFinPeriodID | char(6) | Closed Period | - | |
Description:No description available | ||||
ClosedTranPeriodID | char(6) | Closed Period | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryChargeAmt | decimal | Finance Charges | - | |
Description:No description available | ||||
CuryDiscBal | decimal(19, 4) | Cash Discount Balance | - | |
Description:No description available | ||||
CuryDiscountedDocTotalNonexistent in DB | decimal | Discounted Doc. Total | - | |
Description:No description available | ||||
CuryDiscountedPriceNonexistent in DB | decimal | Tax on Discounted Price | - | |
Description:No description available | ||||
CuryDiscountedTaxableTotalNonexistent in DB | decimal | Discounted Taxable Total | - | |
Description:No description available | ||||
CuryDiscTaken | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryDiscTot | decimal | Discount Total | - | |
Description:No description available | ||||
CuryDocBal | decimal(19, 4) | Balance | - | |
Description:No description available | ||||
CuryDocDiscNonexistent in DBObsolete | decimal | Document Discount | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryInitDocBal | decimal | Balance | - | |
Description:No description available | ||||
CuryLineRetainageTotal | decimal | - | ||
Description:No description available | ||||
CuryLineTotal | decimal | Detail Total | - | |
Description:No description available | ||||
CuryOrigDiscAmt | decimal(19, 4) | Cash Discount Taken | - | |
Description:No description available | ||||
CuryOrigDocAmt | decimal(19, 4) | Payment Amount | - | |
Description:No description available | ||||
CuryOrigDocAmtWithRetainageTotalNonexistent in DB | decimal | Total Amount | - | |
Description:No description available | ||||
CuryOrigTaxDiscAmt | decimal | Discounted Tax Amount | - | |
Description:No description available | ||||
CuryOrigWhTaxAmt | decimal(19, 4) | With. Tax | - | |
Description:No description available | ||||
CuryRetainagePaidTotalNonexistent in DB | decimal | Paid Retainage | - | |
Description:No description available | ||||
CuryRetainageReleased | decimal | Released Retainage | - | |
Description:No description available | ||||
CuryRetainageTotal | decimal | Original Retainage | - | |
Description:No description available | ||||
CuryRetainageUnpaidTotalNonexistent in DB | decimal | Unpaid Retainage | - | |
Description:No description available | ||||
CuryRetainageUnreleasedAmt | decimal | Unreleased Retainage | - | |
Description:No description available | ||||
CuryRetainedDiscTotal | decimal | Discount on Retainage | - | |
Description:No description available | ||||
CuryRetainedTaxTotal | decimal | Tax on Retainage | - | |
Description:No description available | ||||
CuryRoundDiff | decimal | Rounding Diff. | - | |
Description:No description available | ||||
CuryTaxAmt | decimal | Tax Amount | - | |
Description:No description available | ||||
CuryTaxRoundDiff | decimal | Rounding Diff. | - | |
Description:No description available | ||||
CuryTaxTotal | decimal | Tax Total | - | |
Description:No description available | ||||
CuryTaxWheld | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryVatExemptTotal | decimal | Tax Exempt Total | - | |
Description:No description available | ||||
CuryVatTaxableTotal | decimal | Taxable Total | - | |
Description:No description available | ||||
CuryWhTaxBal | decimal(19, 4) | - | ||
Description:No description available | ||||
DefRetainagePct | decimal | Default Retainage Percent | - | |
Description:No description available | ||||
DepositAfter | datetime2 | Deposit After | - | |
Description:No description available | ||||
DepositAsBatch | bit | Batch Deposit | - | |
Description:No description available | ||||
DepositDateNonexistent in DB | datetime | Batch Deposit Date | - | |
Description:No description available | ||||
Deposited | bit | Deposited | - | |
Description:No description available | ||||
DepositNbr | nvarchar(15) | Batch Deposit Nbr. | - | |
Description:No description available | ||||
DepositType | char(3) | DepositType | - | |
Description:No description available | ||||
DiscBal | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscountedDocTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DiscountedPriceNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DiscountedTaxableTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DiscTaken | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscTot | decimal | - | ||
Description:No description available | ||||
DisplayCuryInitDocBal | decimal | Migrated Balance | - | |
Description:No description available | ||||
DocBal | decimal(19, 4) | - | ||
Description:No description available | ||||
DocClassNonexistent in DB | nchar(1) | - | ||
Description:No description available | ||||
DocDate | datetime2 | Date | - | |
Description:No description available | ||||
DocDesc | nvarchar(512) | Description | - | |
Description:No description available | ||||
DocDiscNonexistent in DBObsolete | decimal | - | ||
Description:No description available | ||||
DontApprove | bit | - | ||
Description:No description available | ||||
EmployeeID | int | Owner | Contact | |
Description:No description available | ||||
EmployeeWorkgroupID | int | Workgroup ID | EPCompanyTree | |
Description:No description available | ||||
EntityUsageType | char(1) | - | ||
Description:No description available | ||||
ExternalPaymentID | nvarchar(50) | External Payment ID | - | |
Description:No description available | ||||
ExternalPaymentIsVoidable | bit | - | ||
Description:No description available | ||||
ExternalPaymentStatus | nvarchar(50) | External Payment Status | - | |
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | - | ||
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Payment Ref. | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
HasMultipleProjects | bit | - | ||
Description:No description available | ||||
HasPPDTaxes | bit | - | ||
Description:No description available | ||||
HasUseTaxNonexistent in DB | bit | - | ||
Description:No description available | ||||
HasWithHoldTaxNonexistent in DB | bit | - | ||
Description:No description available | ||||
HiddenKeyNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:No description available | ||||
ImpRefNbr | nvarchar(15) | - | ||
Description:No description available | ||||
InitDocBal | decimal | - | ||
Description:No description available | ||||
InvoiceDate | datetime2 | Vendor Ref. Date | - | |
Description:No description available | ||||
InvoiceNbr | nvarchar(40) | Vendor Ref. | - | |
Description:No description available | ||||
IsExpectedPPVValid | bit | - | ||
Description:No description available | ||||
IsMigratedRecord | bit | - | ||
Description:No description available | ||||
IsPrintingProcessNonexistent in DB | bit | - | ||
Description:Indicates that this check under printing processing to prevent update CashAccountCheck table by AP.PaymentRefAttribute /> | ||||
IsRetainageDocument | bit | Retainage Document | - | |
Description:No description available | ||||
IsRetainageReversing | bit | Retainage Reversing | - | |
Description:No description available | ||||
IsTaxPosted | bit | Tax has been posted to the external tax provider | - | |
Description:No description available | ||||
IsTaxSaved | bit | Tax has been saved in the external tax provider | - | |
Description:No description available | ||||
IsTaxValid | bit | Tax Is Up to Date | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineRetainageTotal | decimal | - | ||
Description:No description available | ||||
LineTotal | decimal | - | ||
Description:No description available | ||||
NonTaxable | bit | Non-Taxable | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenDoc | bit | - | ||
Description:No description available | ||||
OrigDiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
OrigDocAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
OrigDocAmtWithRetainageTotalNonexistent in DB | decimal | Total Amount | - | |
Description:No description available | ||||
OrigDocDate | datetime2 | - | ||
Description:No description available | ||||
OrigDocType | char(3) | Orig. Doc. Type | - | |
Description:No description available | ||||
OrigModule | char(2) | Source | - | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Orig. Ref. Nbr. | - | |
Description:No description available | ||||
OrigTaxDiscAmt | decimal | - | ||
Description:No description available | ||||
OrigWhTaxAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
OwnerIDNonexistent in DB | int | Approver | Contact | |
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
PaymentsByLinesAllowed | bit | Pay by Line | - | |
Description:No description available | ||||
PaySel | bit | - | ||
Description:No description available | ||||
PendingPayment | bit | - | ||
Description:No description available | ||||
PendingPPD | bit | - | ||
Description:No description available | ||||
PendingProcessing | bit | - | ||
Description:No description available | ||||
PrebookAcctID | int | Reclassification Account | - | |
Description:No description available | ||||
PrebookBatchNbr | nvarchar(15) | Pre-releasing Batch Nbr. | Batch | |
Description:No description available | ||||
Prebooked | bit | Pre-Released | - | |
Description:No description available | ||||
PrebookSubID | int | Reclassification Subaccount | - | |
Description:No description available | ||||
PrepaymentAccountID | int | Prepayment Account | Account | |
Description:No description available | ||||
PrepaymentSubID | int | Prepayment Subaccount | Sub | |
Description:No description available | ||||
PrintCheck | bit | Print Check | - | |
Description:No description available | ||||
PrintDocTypeNonexistent in DB | nchar(3) | Type | - | |
Description:No description available | ||||
Printed | bit | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
Rejected | bit | - | ||
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
ReleasedOrPrebookedNonexistent in DB | bit | - | ||
Description:No description available | ||||
ReleasedToVerifyNonexistent in DB | bit | - | ||
Description:No description available | ||||
RemitAddressID | int | Address | ||
Description:No description available | ||||
RemitContactID | int | Remittance Contact | Contact | |
Description:No description available | ||||
RetainageAcctID | int | Retainage Payable Account | Account | |
Description:No description available | ||||
RetainageApply | bit | Apply Retainage | - | |
Description:No description available | ||||
RetainagePaidTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
RetainageReleased | decimal | Released Retainage | - | |
Description:No description available | ||||
RetainageSubID | int | Retainage Payable Sub. | Sub | |
Description:No description available | ||||
RetainageTotal | decimal | Original Retainage | - | |
Description:No description available | ||||
RetainageUnpaidTotalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
RetainageUnreleasedAmt | decimal | Unreleased Retainage | - | |
Description:No description available | ||||
RetainedDiscTotal | decimal | - | ||
Description:No description available | ||||
RetainedTaxTotal | decimal | - | ||
Description:No description available | ||||
RGOLAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
RoundDiff | decimal | - | ||
Description:No description available | ||||
Scheduled | bit | - | ||
Description:No description available | ||||
ScheduleID | nvarchar(15) | Schedule | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SeparateCheck | bit | - | ||
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
StubCntr | int | - | ||
Description:No description available | ||||
SuppliedByVendorID | int | Vendor | ||
Description:A reference to the Vendor. An integer identifier of the vendor that supplied the goods. Always equals to VendorID in APQuickCheck. | ||||
SuppliedByVendorLocationID | int | Location | ||
Description:Identifier of the Location of the Supplied-by Vendor, associated with the document. Corresponds to the Location.LocationID field. Defaults to AP bill's vendor location. Always equals to VendorLocationID in APQuickCheck. | ||||
TaxAmt | decimal | - | ||
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
TaxCostINAdjRefNbr | nvarchar(15) | Adjustment Nbr. | INRegister | |
Description:No description available | ||||
TaxRoundDiff | decimal | - | ||
Description:No description available | ||||
TaxTotal | decimal | - | ||
Description:No description available | ||||
TaxWheld | decimal(19, 4) | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Vendor Tax Zone | TaxZone | |
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | Terms | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VatExemptTotal | decimal | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal | - | ||
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||
VendorLocationID | int | Location | Location | |
Description:No description available | ||||
VoidApplNonexistent in DB | bit | - | ||
Description:No description available | ||||
VoidBatchNbr | nvarchar(15) | Void Batch Nbr. | Batch | |
Description:No description available | ||||
Voided | bit | Void | - | |
Description:No description available | ||||
WhTaxBal | decimal(19, 4) | - | ||
Description:No description available | ||||
WorkgroupIDNonexistent in DB | int | Approval Workgroup ID | EPCompanyTree | |
Description:No description available | ||||