AP
PendingPPDVATAdjApp
PX.Objects.AP116 of 116 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AdjdDocType | char(3) | Document Type | - | |
Description:No description available | ||||
AdjdLineNbr | int | Line Nbr. | APTran | |
Description:No description available | ||||
AdjdRefNbr | nvarchar(15) | Reference Nbr. | APInvoice | |
Description:No description available | ||||
AdjgDocType | char(3) | AdjgDocType | - | |
Description:No description available | ||||
AdjgRefNbr | nvarchar(15) | Reference Nbr. | APRegister | |
Description:No description available | ||||
AdjNbr | int | Adjustment Nbr. | - | |
Description:No description available | ||||
InvDocType | char(3) | - | ||
Description:Adjusted Doc Type, it can be a docType listed in the APInvoiceType.TaxInvoiceListAttribute | ||||
InvRefNbr | nvarchar(15) | - | ||
Description:Adjusted Ref. number | ||||
PayDocType | char(3) | - | ||
Description:Payment (adjusting) Document type | ||||
PayRefNbr | nvarchar(15) | - | ||
Description:Payment (adjusting) Ref. number | ||||
PPDAdjNbr | int | - | ||
Description:Prompt Payment Discount Adjust Number. Should be filled from the number of lines in the related payment document. | ||||
AdjAmt | decimal | Amount | - | |
Description:No description available | ||||
AdjBatchNbr | nvarchar(15) | Batch Number | - | |
Description:No description available | ||||
AdjdAPAcct | int | Account | Account | |
Description:No description available | ||||
AdjdAPSub | 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 | ||||
AdjdDocDate | datetime2 | Date | - | |
Description:No description available | ||||
AdjdFinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
AdjdHasPPDTaxes | bit | - | ||
Description:No description available | ||||
AdjDiscAmt | decimal | Cash Discount Amount | - | |
Description:No description available | ||||
AdjdOrigCuryInfoID | bigint | - | ||
Description:No description available | ||||
AdjdTBSignNonexistent in DB | decimal | - | ||
Description:No description available | ||||
AdjdTranPeriodID | char(6) | - | ||
Description:No description available | ||||
AdjdWhTaxAcctID | int | Account | Account | |
Description:No description available | ||||
AdjdWhTaxSubID | int | Subaccount | Sub | |
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 | Transaction Date | - | |
Description:No description available | ||||
AdjgFinPeriodID | char(6) | Application Period | - | |
Description:No description available | ||||
AdjgGLSignNonexistent in DB | decimal | - | ||
Description:No description available | ||||
AdjgTBSignNonexistent in DB | decimal | - | ||
Description:No description available | ||||
AdjgTranPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
AdjPPDAmt | decimal | - | ||
Description:No description available | ||||
AdjTypeNonexistent in DB | nchar(1) | - | ||
Description:No description available | ||||
AdjWhTaxAmt | decimal | Withholding Tax Amount | - | |
Description:No description available | ||||
CashAccountID | int | CashAccount | ||
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 | - | ||
Description:No description available | ||||
CuryAdjdDiscAmt | decimal | - | ||
Description:No description available | ||||
CuryAdjdPPDAmt | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
CuryAdjdWhTaxAmt | decimal | - | ||
Description:No description available | ||||
CuryAdjgAmt | decimal | Amount Paid | - | |
Description:No description available | ||||
CuryAdjgDiscAmt | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
CuryAdjgPPDAmt | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
CuryAdjgWhTaxAmt | decimal | With. Tax | - | |
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 | ||||
CuryWhTaxBalNonexistent in DB | decimal | With. Tax Balance | - | |
Description:No description available | ||||
DiscBalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DisplayCuryAmtNonexistent in DB | decimal | Amount Paid | - | |
Description:No description available | ||||
DisplayCuryDiscAmtNonexistent in DB | decimal | Cash Discount Taken | - | |
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 | ||||
DisplayCuryWhTaxAmtNonexistent in DB | decimal | With. Tax | - | |
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 | ||||
DisplayRefNbrNonexistent in DB | nvarchar(15) | Reference Nbr. | - | |
Description:No description available | ||||
DisplayStatusNonexistent in DB | nchar(1) | Status | - | |
Description:No description available | ||||
DocBalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DocDesc | nvarchar(512) | Description | - | |
Description:Description of the document. | ||||
Hold | bit | - | ||
Description:No description available | ||||
IndexNonexistent in DB | int | - | ||
Description:Index of the record | ||||
InvCuryDocBal | decimal | - | ||
Description:Adjusted document cury Document Balance | ||||
InvCuryID | nvarchar(5) | Currency | - | |
Description:Adjusted document CuryID | ||||
InvCuryInfoID | bigint | - | ||
Description:Adjusted document CuryID | ||||
InvCuryOrigDiscAmt | decimal | Cash Discount | - | |
Description:Adjusted document Cury original discount amount | ||||
InvCuryOrigDocAmt | decimal | Amount | - | |
Description:Adjusted document original cury amount | ||||
InvCuryTaxTotal | decimal | Tax Total | - | |
Description:Adjusted document cury Tax Total amount | ||||
InvCuryVatTaxableTotal | decimal | VAT Taxable Total | - | |
Description:Adjusted document VAT Taxable total amount | ||||
InvoiceID | uniqueidentifier | - | ||
Description:No description available | ||||
InvoiceNbr | nvarchar(40) | Vendor Ref. | - | |
Description:Vendor Ref. of the Invoice. | ||||
InvTaxCalcMode | nvarchar(10) | - | ||
Description:Adjusted document TaxCalcMode | ||||
InvTaxZoneID | nvarchar(10) | - | ||
Description:Adjusted document TaxZoneID | ||||
InvTermsID | nvarchar(10) | Credit Terms | - | |
Description:Adjusted document Credit TermsID | ||||
InvVendorLocationID | int | - | ||
Description:Adjusted document VendorLocationID | ||||
IsInitialApplication | bit | - | ||
Description:No description available | ||||
IsMigratedRecord | bit | - | ||
Description:No description available | ||||
JointPayeeID | int | - | ||
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 | ||||
PaymentID | uniqueidentifier | - | ||
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | PaymentMethod | ||
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) | APRegister | ||
Description:No description available | ||||
PrintAdjdDocTypeNonexistent in DB | nchar(3) | Type | - | |
Description:No description available | ||||
PrintAdjgDocTypeNonexistent in DB | nchar(3) | Type | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
ReverseGainLossNonexistent in DB | bit | - | ||
Description:No description available | ||||
RGOLAmt | decimal | Realized Gain/Loss Amount | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SeparateCheckNonexistent in DB | bit | Pay Separately | - | |
Description:No description available | ||||
StubNbr | nvarchar(40) | Check Number | - | |
Description:No description available | ||||
TaxInvoiceNbr | nvarchar(15) | Tax Doc. Nbr | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
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 | ||||
WhTaxBalNonexistent in DB | decimal | - | ||
Description:No description available | ||||