AP
APAdjust2
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AdjAmt | decimal | Amount | - | |
Description:The amount to be paid for the adjusted document. (See APRegister.OrigDocAmt) (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
AdjBatchNbr | nvarchar(15) | Batch Number | - | |
Description:The number of the Batch generated from the adjustment. Corresponds to the Batch.BatchNbr field. | ||||
AdjDiscAmt | decimal | Cash Discount Amount | - | |
Description:The amount of the cash discount for the adjusted document. Presented in the base currency of the company, see Company.BaseCuryID. | ||||
AdjNbr | int | Adjustment Nbr. | - | |
Description:The number of the adjustment. Defaults to the current number of lines in the related payment document. | ||||
AdjPPDAmt | decimal | - | ||
Description:No description available | ||||
AdjTypeNonexistent in DB | string | - | ||
Description:No description available | ||||
AdjWhTaxAmt | decimal | Withholding Tax Amount | - | |
Description:The amount of tax withheld from the payments to the adjusted document. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
AdjdAPAcct | int | Account | Account | |
Description:Identifier of the AP account, to which the adjusted document belongs. Corresponds to the Account.AccountID field. | ||||
AdjdAPSub | int | Subaccount | Sub | |
Description:Identifier of the AP subaccount, to which the adjusted document belongs. Corresponds to the Sub.SubID field. | ||||
AdjdBalSignNonexistent in DB | decimal? | - | ||
Description:A read-only field showing the sign of the impact of the adjusted document on the balance. Depends only on the values of the AdjgDocType and AdjdDocType fields. | ||||
AdjdBranchID | int | Branch | Branch | |
Description:Identifier of the Branch, to which the adjusted document belongs. | ||||
AdjdCuryIDNonexistent in DB | string | Currency | Currency | |
Description:No description available | ||||
AdjdCuryInfoID | bigint | CurrencyInfo | ||
Description:Identifier of the Currency Info record associated with the adjusted document. | ||||
AdjdCuryRateNonexistent in DB | decimal? | Cross Rate | - | |
Description:An optional cross rate that can be specified between the currency of the payment and currency of the original document. | ||||
AdjdDocDate | datetime | Date | - | |
Description:Either the date when the adjusted document was created or the date of the original vendor’s document. | ||||
AdjdDocType | char(3) | Document Type | - | |
Description:The type of the adjusted document. | ||||
AdjdFinPeriodID | string | Post Period | - | |
Description:Financial period of the adjusted document. Corresponds to the APRegister.FinPeriodID field. The value of this field is determined from the APAdjust.AdjdDocDate field. | ||||
AdjdHasPPDTaxes | bit | - | ||
Description:No description available | ||||
AdjdLineNbr | int | Line Nbr. | APTran | |
Description:No description available | ||||
AdjdOrigCuryInfoID | bigint | - | ||
Description:Identifier of the original Currency Info record associated with the adjusted document. | ||||
AdjdRefNbr | nvarchar(15) | Reference Nbr. | APRegister | |
Description:Reference number of the adjusted document. | ||||
AdjdTBSignNonexistent in DB | decimal? | - | ||
Description:A read-only field showing the sign of impact of the adjusted document on the trial balance. Depends only on the values of the AdjgDocType and AdjdDocType fields. | ||||
AdjdTranPeriodID | string | - | ||
Description:Financial period of the adjusted document. Corresponds to the APRegister.TranPeriodID field. | ||||
AdjdWhTaxAcctID | int | Account | Account | |
Description:Identifier of the account associated with withholding tax for the adjusted document. Corresponds to the Account.AccountID field. | ||||
AdjdWhTaxSubID | int | Subaccount | Sub | |
Description:Identifier of the subaccount associated with withholding tax for the adjusted document. Corresponds to the Sub.SubID field. | ||||
AdjgBalSignNonexistent in DB | decimal? | - | ||
Description:A read-only field showing the sign of the impact of the adjusting document on the balance. Depends only on the values of the AdjgDocType and AdjdDocType fields. | ||||
AdjgBranchID | int | Branch | Branch | |
Description:Identifier of the Branch, to which the adjusting document belongs. | ||||
AdjgCuryInfoID | bigint | CurrencyInfo | ||
Description:Identifier of the Currency Info record associated with the adjusting document. | ||||
AdjgDocDate | datetime | Transaction Date | - | |
Description:The date when the payment is applied. Defaults to the application date specified on the adjusting document. | ||||
AdjgDocType | char(3) | AdjgDocType | APRegister | |
Description:The type of the adjusting document. | ||||
AdjgFinPeriodID | string | Application Period | - | |
Description:Financial period of payment application. Defaults to the application period specified on the adjusting document. | ||||
AdjgGLSignNonexistent in DB | decimal? | - | ||
Description:!REV! A read-only field showing the sign of impact of the adjusting document on the General Ledger. Depends only on the values of the AdjgDocType and AdjdDocType fields. | ||||
AdjgRefNbr | nvarchar(15) | Reference Nbr. | APRegister | |
Description:Reference number of the adjusting document. | ||||
AdjgTBSignNonexistent in DB | decimal? | - | ||
Description:A read-only field showing the sign of impact of the adjusting document on the trial balance. Depends only on the values of the AdjgDocType and AdjdDocType fields. | ||||
AdjgTranPeriodID | string | Post Period | - | |
Description:Financial period of the adjusting document. This field corresponds to the APPayment.AdjTranPeriodID (not user-overridable) field of the adjusting document. | ||||
CashAccountID | int | CashAccount | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryAdjdAmt | decimal | - | ||
Description:The amount to be paid for the adjusted document. (See APRegister.CuryOrigDocAmt) (Presented in the currency of the document, see APRegister.CuryID) | ||||
CuryAdjdDiscAmt | decimal | - | ||
Description:The amount of the cash discount for the adjusted document. Presented in the currency of the document, see CuryID. | ||||
CuryAdjdPPDAmt | decimal | Cash Discount Taken | - | |
Description:The cash discount amount displayed for the document. Given in the currency of the adjusted document. | ||||
CuryAdjdWhTaxAmt | decimal | - | ||
Description:The amount of tax withheld from the payments to the adjusted document. (Presented in the currency of the document, see APRegister.CuryID) | ||||
CuryAdjgAmt | decimal | Amount Paid | - | |
Description:The actual amount paid on the document. Presented in the currency of the document, see APRegister.CuryID. | ||||
CuryAdjgDiscAmt | decimal | Cash Discount Taken | - | |
Description:The amount of the cash discount taken for the adjusting document. Presented in the currency of the document, see APRegister.CuryID. | ||||
CuryAdjgPPDAmt | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
CuryAdjgWhTaxAmt | decimal | With. Tax | - | |
Description:The amount of withholding tax calculated for the adjusting document, if applicable. Presented in the currency of the document, see APRegister.CuryID. | ||||
CuryDiscBalNonexistent in DB | decimal? | Cash Discount Balance | - | |
Description:The difference between the cash discount that was available and the actual amount of cash discount taken. (Presented in the currency of the document, see APRegister.CuryID) | ||||
CuryDocBalNonexistent in DB | decimal? | Balance | - | |
Description:The amount of the adjustment before the discount is taken. (Presented in the currency of the document, see APRegister.CuryID) | ||||
CuryJointAmountOwedNonexistent in DB | decimal? | Joint Amount Owed | - | |
Description:No description available | ||||
CuryJointBalanceNonexistent in DB | decimal? | Joint Balance | - | |
Description:No description available | ||||
CuryOrigDocAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
CuryWhTaxBalNonexistent in DB | decimal? | With. Tax Balance | - | |
Description:The difference between the amount of the tax to be withheld and the actual withheld amount (if any withholding taxes are applicable). (Presented in the currency of the document, see APRegister.CuryID) | ||||
DiscBalNonexistent in DB | decimal? | - | ||
Description:The difference between the cash discount that was available and the actual amount of cash discount taken. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
DisplayCuryAmtNonexistent in DB | decimal? | Amount Paid | - | |
Description:No description available | ||||
DisplayCuryDiscAmtNonexistent in DB | decimal? | Cash Discount Taken | - | |
Description:No description available | ||||
DisplayCuryIDNonexistent in DB | string | Currency | Currency | |
Description:No description available | ||||
DisplayCuryInfoIDNonexistent in DB | long? | - | ||
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 | string | Description | - | |
Description:No description available | ||||
DisplayDocTypeNonexistent in DB | string | Doc. Type | - | |
Description:No description available | ||||
DisplayFinPeriodIDNonexistent in DB | string | Post Period | MasterFinPeriod | |
Description:No description available | ||||
DisplayRefNbrNonexistent in DB | string | Reference Nbr. | APRegister | |
Description:No description available | ||||
DisplayStatusNonexistent in DB | string | Status | - | |
Description:No description available | ||||
DocBalNonexistent in DB | decimal? | - | ||
Description:The amount of the adjustment before the discount is taken. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
HasExpiredComplianceDocumentsNonexistent in DB | bool? | Expired Compliance | - | |
Description:No description available | ||||
Hold | bit | - | ||
Description:When set to "true" indicates that the adjustment is on hold. | ||||
InvoiceID | uniqueidentifier | - | ||
Description:Identifier of the Invoice. Corresponds to the APRegister.NoteID field. | ||||
IsAmountPaidCalculatedNonexistent in DB | bool? | - | ||
Description:An indicator of whether the APAdjust.CuryAdjgAmt value has been calculated previously by using the joint amount calculation method. Once the value has been set, it should not be recalculated. | ||||
IsInitialApplication | bit | - | ||
Description:Specifies (if set to "true") that this is the initial application created for a migrated document to affect all needed balances. | ||||
IsMigratedRecord | bit | - | ||
Description:Specifies (if set to "true") that the record has been created in migration mode without affecting GL module. | ||||
JointAmountOwedNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
JointBalanceNonexistent in DB | decimal? | Joint Balance | - | |
Description:No description available | ||||
JointPayeeExternalNameNonexistent in DB | string | Joint Payee Name | - | |
Description:No description available | ||||
JointPayeeID | int | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
MemoID | uniqueidentifier | - | ||
Description:Identifier of the Debit Adjustment. Corresponds to the APRegister.NoteID field. | ||||
NoteID | uniqueidentifier | - | ||
Description:Identifier of the Note object, associated with the adjustment. Corresponds to the Note.NoteID field. | ||||
OrigDocAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
PPDVATAdjDescriptionNonexistent in DB | string | Tax Adjustment | - | |
Description:The description of the adjustment, which is generated on the Generate AP Tax Adjustments (AP504500) form. This field is needed for showing on the Checks and Payments (AP302000) screen like a hyperlink. For example - "Debit Adj., 000084". Value is APAdjust.PPDVATAdjDocType + APAdjust.PPDVATAdjRefNbr field. | ||||
PPDVATAdjDocType | char(3) | - | ||
Description:The doc type of the adjustment, which is generated on the Generate AP Tax Adjustments (AP504500) form. Corresponds to the APInvoice.docType field. | ||||
PPDVATAdjRefNbr | nvarchar(15) | APAdjust.APInvoice | ||
Description:The reference number of the adjustment, which is generated on the Generate AP Tax Adjustments (AP504500) form. Corresponds to the APInvoice.RefNbr field. | ||||
PaymentID | uniqueidentifier | - | ||
Description:Identifier of the Payment. Corresponds to the APRegister.NoteID field. | ||||
PaymentMethodID | nvarchar(10) | PaymentMethod | ||
Description:No description available | ||||
PaymentProjectIDNonexistent in DB | int? | Project | PMProject | |
Description:A project that is displayed in a line of the table on the Documents to Apply tab of the Checks and Payments (AP302000) form. | ||||
PendingPPD | bit | Subject to Tax Adjustment | - | |
Description:No description available | ||||
PrintAdjdDocTypeNonexistent in DB | string | Type | - | |
Description:The type of the adjusted document for printing. Internal representation is the same as for AdjgDocType, but the user-friendly values of these two fields differ. | ||||
PrintAdjgDocTypeNonexistent in DB | string | Type | - | |
Description:The type of the adjusting document for printing. Internal representation is the same as for AdjgDocType, but the user-friendly values of these two fields differ. | ||||
RGOLAmt | decimal | Realized Gain/Loss Amount | - | |
Description:Realized Gain and Loss amount associated with the adjustment. | ||||
Released | bit | Released | APAdjust | |
Description:When set to "true" indicates that the adjustment was released. | ||||
ReverseGainLossNonexistent in DB | bool? | - | ||
Description:A read-only field, which when equal to "true", indicates that the sign of the gain and loss is reversed for the adjustment. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:Indicates whether the record is selected for mass processing or not. | ||||
SeparateCheckNonexistent in DB | bool? | Pay Separately | - | |
Description:When set to "true" indicates that the adjusted document should be paid for by a separate check. (See APInvoice.SeparateCheck) | ||||
StubNbr | nvarchar(40) | Check Number | - | |
Description:The number of the payment stub. | ||||
TPAR | bit | Track For TPAR | - | |
Description:No description available | ||||
TaxInvoiceNbr | nvarchar(15) | Tax Doc. Nbr | - | |
Description:The "Tax Doc. Nbr" of the tax transaction, generated on the "Recognize Output/Input VAT" (TX503000/TX503500) form. Corresponds to the TaxTran.TaxInvoiceNbr field. | ||||
VendorID | int | Vendor | Vendor | |
Description:Identifier of the Vendor, whom the related documents belongs. | ||||
VoidAdjNbr | int | - | ||
Description:The reference number of the voiding adjustment. | ||||
VoidApplNonexistent in DB | bool? | Void Application | - | |
Description:When equal to "true", indicates that the payment was voided or cancelled. Setting this field to "true" will change the type of the adjusting document to Voided Payment (""VCK"") and set Voided to "true". | ||||
Voided | bit | - | ||
Description:When set to "true" indicates that the adjustment was voided. | ||||
WhTaxBalNonexistent in DB | decimal? | - | ||
Description:The difference between the amount of the tax to be withheld and the actual withheld amount (if any withholding taxes are applicable). (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||