AP
APDocumentEnq.APRegister
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
APAccountID | int | AP Account | Account | |
Description:Identifier of the AP account, to which the document belongs. Corresponds to the Account.AccountID field. | ||||
APSubID | int | AP Subaccount | Sub | |
Description:Identifier of the AP subaccount, to which the document belongs. Corresponds to the Sub.SubID field. | ||||
Approved | bit | - | ||
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Nbr. | Batch | |
Description:Number of the Batch, generated for the document on release. Corresponds to the Batch.BatchNbr field. | ||||
BranchID | int | Branch | - | |
Description:Identifier of the Branch, to which the document belongs. Corresponds to the Branch.BranchID field. | ||||
ClosedDate | datetime | Closed Date | - | |
Description:The date of the last application. | ||||
ClosedFinPeriodID | string | Closed Period | - | |
Description:The financial period in which the document was closed. Corresponds to the FinPeriodID field. | ||||
ClosedTranPeriodID | string | Closed Master Period | - | |
Description:The financial period in which the document was closed. Corresponds to the TranPeriodID field. | ||||
CuryDiscBal | 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 CuryID) | ||||
CuryDiscTaken | decimal | - | ||
Description:!REV! The amount of the cash discount taken. (Presented in the currency of the document, see CuryID) | ||||
CuryDiscTot | decimal | Discount Total | - | |
Description:Total discount associated with the document in the currency of the document. (See CuryID) | ||||
CuryDocBal | decimal | Balance | - | |
Description:The balance of the Accounts Payable document after tax (if inclusive) and the discount in the currency of the document. (See CuryID) | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:Code of the Currency of the document. Defaults to the company's base currency. | ||||
CuryInfoID | bigint | - | ||
Description:Identifier of the CurrencyInfo object associated with the document. Generated automatically. Corresponds to the CurrencyInfo.CurrencyInfoID field. | ||||
CuryOrigDiscAmt | decimal | Cash Discount | - | |
Description:!REV! The amount of the cash discount taken for the original document. (Presented in the currency of the document, see CuryID) | ||||
CuryOrigDocAmt | decimal | Amount | - | |
Description:The amount to be paid for the document in the currency of the document. (See CuryID) | ||||
CuryOrigWhTaxAmt | decimal | With. Tax | - | |
Description:The amount of withholding tax calculated for the document, if applicable, in the currency of the document. (See CuryID) | ||||
CuryRetainageTotal | decimal | Original Retainage | - | |
Description:No description available | ||||
CuryRetainageUnreleasedAmt | decimal | Unreleased Retainage | - | |
Description:No description available | ||||
CuryTaxWheld | decimal | - | ||
Description:!REV! The amount of tax withheld from the payments to the document. (Presented in the currency of the document, see CuryID) | ||||
CuryWhTaxBal | decimal | - | ||
Description:!REV! The difference between the original amount of withholding tax to be payed and the amount that was actually paid. (Presented in the currency of the document, see CuryID) | ||||
DiscBal | 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) | ||||
DiscTaken | decimal | - | ||
Description:The amount of the cash discount taken. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
DiscTot | decimal | - | ||
Description:Total discount associated with the document in the base currency of the company. (See Company.BaseCuryID) | ||||
DocBal | decimal | - | ||
Description:The balance of the Accounts Payable document after tax (if inclusive) and the discount in the base currency of the company. (See Company.BaseCuryID) | ||||
DocDate | datetime | Date | - | |
Description:Date of the document. | ||||
DocDesc | nvarchar(512) | Description | - | |
Description:Description of the document. | ||||
DocType | char(3) | Type | - | |
Description:No description available | ||||
FinPeriodID | string | Post Period | FinPeriod | |
Description:The financial period of the document. The value defaults to the period to which the APRegister.DocDate belongs, but can be overridden by a user. | ||||
Hold | bit | Hold | - | |
Description:When set to "true" indicates that the document is on hold and thus cannot be released. | ||||
IsMigratedRecord | bit | - | ||
Description:Specifies (if set to "true") that the record has been created in migration mode without affecting GL module. | ||||
IsRetainageDocument | bit | Retainage Bill | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:Identifier of the Note object, associated with the document. Corresponds to the Note.NoteID field. | ||||
OpenDoc | bit | Open | - | |
Description:When set to "true" indicates that the document is open. | ||||
OrigDiscAmt | decimal | - | ||
Description:The amount of the cash discount taken for the original document. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
OrigDocAmt | decimal | Amount | - | |
Description:The amount to be paid for the document in the base currency of the company. (See Company.BaseCuryID) | ||||
OrigDocType | char(3) | Orig. Doc. Type | - | |
Description:Type of the original (source) document. | ||||
OrigRefNbr | nvarchar(15) | Orig. Ref. Nbr. | - | |
Description:Reference number of the original (source) document. | ||||
OrigWhTaxAmt | decimal | - | ||
Description:The amount of withholding tax calculated for the document, if applicable, in the base currency of the company. (See Company.BaseCuryID) | ||||
Prebooked | bit | Prebooked | - | |
Description:When set to "true" indicates that the document was prebooked. | ||||
Printed | bit | - | ||
Description:When set to "true" indicates that the document was printed. | ||||
RGOLAmt | decimal | - | ||
Description:Realized Gain and Loss amount associated with the document. | ||||
RefNbr | nvarchar(15) | Reference Nbr. | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:!REV! | ||||
Rejected | bit | - | ||
Description:No description available | ||||
Released | bit | Released | - | |
Description:When set to "true" indicates that the document was released. | ||||
ReleasedToVerifyNonexistent in DB | bool? | - | ||
Description:When set, on persist checks, that the document has the corresponded Released original value. When not set, on persist checks, that Released value is not changed. Throws an error otherwise. | ||||
RetainageTotal | decimal | Original Retainage | - | |
Description:No description available | ||||
RetainageUnreleasedAmt | decimal | Unreleased Retainage | - | |
Description:No description available | ||||
Scheduled | bit | - | ||
Description:When set to "true" indicates that the document is part of a "Schedule" and serves as a template for generating other documents according to it. | ||||
SignBalanceNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
TaxWheld | decimal | - | ||
Description:The amount of tax withheld from the payments to the document. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||
TranPeriodID | string | Master Period | - | |
Description:The financial period of the document. Determined by the date of the document. Unlike APRegister.FinPeriodID the value of this field can't be overridden by user. | ||||
VendorID | int | Vendor | - | |
Description:Identifier of the Vendor, whom the document belongs to. | ||||
Voided | bit | Void | - | |
Description:When set to "true" indicates that the document was voided. In this case VoidBatchNbr field will hold the number of the voiding Batch. | ||||
WhTaxBal | decimal | - | ||
Description:The difference between the original amount of withholding tax to be payed and the amount that was actually paid. (Presented in the base currency of the company, see Company.BaseCuryID) | ||||