AP
APInvoiceEntry.APAdjust
PX.Objects.AP97 of 97 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) | Doc. Type | - | |
Description:No description available | ||||
AdjgRefNbr | nvarchar(15) | Reference Nbr. | APRegister | |
Description:No description available | ||||
AdjNbr | int | Adjustment Nbr. | - | |
Description:No description available | ||||
AdjAmt | decimal(19, 4) | 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(19, 4) | 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) | - | ||
Description:No description available | ||||
AdjPPDAmt | decimal | - | ||
Description:No description available | ||||
AdjTypeNonexistent in DB | nchar(1) | - | ||
Description:No description available | ||||
AdjWhTaxAmt | decimal(19, 4) | 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(19, 4) | Amount Paid | - | |
Description:No description available | ||||
CuryAdjdDiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryAdjdPPDAmt | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
CuryAdjdWhTaxAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryAdjgAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryAdjgDiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryAdjgPPDAmt | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
CuryAdjgWhTaxAmt | 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 | ||||
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 | ||||
Hold | bit | - | ||
Description:No description available | ||||
InvoiceID | uniqueidentifier | - | ||
Description:No description available | ||||
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(19, 4) | 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) | - | ||
Description:No description available | ||||
TaxInvoiceNbr | nvarchar(15) | Tax Doc. Nbr | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VendorID | int | Vendor ID | 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 | ||||