AP
APTranPostGLwithLines
AP Document Post GL with Lines.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
APRegisterDocDate | datetime | Date | - | |
Description:Date of the document. | ||||
APRegisterTranPeriodID | string | - | ||
Description:Financial Period of the document. | ||||
AccountID | int | Account | Account | |
Description:AccountID of corresponding APTranPostGL table record. | ||||
BalanceAmtNonexistent in DB | decimal? | - | ||
Description:Balance amtount. | ||||
BalanceSign | smallint | - | ||
Description:Sign of the Balance. | ||||
BranchID | int | Branch | - | |
Description:Identifier of the Branch, to which the document belongs. | ||||
ClosedDate | datetime | - | ||
Description:The date of the last application. | ||||
ClosedFinPeriodID | string | - | ||
Description:The Financial Period, in which the document was closed. Corresponds to the FinPeriodID field. | ||||
ClosedTranPeriodID | string | - | ||
Description:The Financial Period, in which the document was closed. Corresponds to the TranPeriodID field. | ||||
CreditAPAmtNonexistent in DB | decimal? | - | ||
Description:Credit AP amount in the base currency of the company. | ||||
CuryCreditAPAmtNonexistent in DB | decimal? | Credit AP Amt. | - | |
Description:Credit AP amount. | ||||
CuryDebitAPAmtNonexistent in DB | decimal? | Debit AP Amt. | - | |
Description:Debit AP amount. | ||||
CuryID | nvarchar | - | ||
Description:Identifier of the Currency of this Currency Info object. | ||||
CuryInfoID | bigint | - | ||
Description:Identifier of the CurrencyInfo object associated with the document. | ||||
CuryTurnDiscAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
CuryTurnWHTaxAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
DebitAPAmtNonexistent in DB | decimal? | - | ||
Description:Debit AP amount in the base currency of the company. | ||||
DocDateNonexistent in DB | DateTime? | Date | - | |
Description:Date of the document. | ||||
DocType | nvarchar | Doc. Type | - | |
Description:The type of the document. The field can have one of the following values: - INV: Invoice - ACR: Credit Adjustment - ADR: Debit Adjustment - CHK: Payment - VCK: Voided Payment - PPM: Prepayment - REF: Refund - VRF: Voided Refund - QCK: Cash Purchase - VQC: Voided Cash Purchase | ||||
FinPeriodIDNonexistent in DB | string | Application Period | - | |
Description:Financial Period of the document. | ||||
IDNonexistent in DB | int? | - | ||
Description:Id of corresponding APTranPost table record. | ||||
IsMigratedRecord | bit | - | ||
Description:Specifies (if set to "true") that the record has been created in migration mode without affecting GL module. | ||||
LineNbrNonexistent in DB | int? | Line Nbr. | - | |
Description:The number of the transaction line in the document. | ||||
OpenDoc | bit | - | ||
Description:When set to "true" indicates that the document is open. | ||||
Ord | smallint | - | ||
Description:The field is used in reports for joining and filtering purposes. | ||||
OrigBalanceAmtNonexistent in DB | decimal? | - | ||
Description:The signed 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. | ||||
OrigRetainageAmtNonexistent in DB | decimal? | Original Retainage | - | |
Description:Original retainage amount. | ||||
PaymentsByLinesAllowed | bit | - | ||
Description:Specifies (if set to "true") that the record has been created with activated FeaturesSet.PaymentsByLines feature and such document allow payments by lines. | ||||
Prebooked | bit | - | ||
Description:When set to "true" indicates that the document was prebooked. | ||||
PrintDocTypeNonexistent in DB | string | Type | - | |
Description:Type of the document for displaying in reports. This field has the same set of possible internal values as the DocType field, but exposes different user-friendly values. | ||||
ProjectIDNonexistent in DB | int? | - | ||
Description:The project with which the item is associated or the non-project code if the item is not intended for any project. The field is relevant only if the Project Accounting feature is enabled. | ||||
RGOLAmt | decimal | - | ||
Description:Realized gains or losses amount. | ||||
RefNbr | nvarchar | Ref. Nbr. | - | |
Description:Reference number of the document. | ||||
RefNoteID | uniqueidentifier | - | ||
Description:AP document transaction note id. | ||||
ReferenceID | int | - | ||
Description:Transaction Reference ID. | ||||
Released | bit | - | ||
Description:When set to "true" indicates that the document was released. | ||||
ReleasedRetainageAmtNonexistent in DB | decimal? | - | ||
Description:Released retainage amount. | ||||
SourceDocType | nvarchar | Source Doc. Type | - | |
Description:Source document doc type. | ||||
SourceRefNbr | nvarchar | Source Ref. Nbr. | - | |
Description:Source document ref number. | ||||
SubID | int | Subaccount | Sub | |
Description:SubID Account ID of corresponding APTranPostGL table record. | ||||
TranClass | nvarchar | - | ||
Description:Transaction class. | ||||
TranPeriodIDNonexistent in DB | string | - | ||
Description:Financial Period of the document. | ||||
TranRefNbr | nvarchar | - | ||
Description:Transaction ref number. | ||||
TranTypeNonexistent in DB | string | - | ||
Description:The type of the transaction. | ||||
TurnDiscAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
TurnRGOLAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
TurnWHTaxAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
Type | nvarchar | - | ||
Description:Transaction type. | ||||
VendorID | int | Vendor | - | |
Description:Identifier of the Vendor, whom the document belongs to. | ||||
Voided | bit | - | ||
Description:When set to "true" indicates that the document was voided. In this case VoidBatchNbr field will hold the number of the voiding Batch. | ||||