AR
ARDocumentEnq.ARRegister
PX.Objects.AR54 of 54 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocType | char(3) | Type | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | - | |
Description:No description available | ||||
ARAccountID | int | AR Account | - | |
Description:No description available | ||||
ARSubID | int | AR Subaccount | - | |
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Nbr. | Batch | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
ClosedFinPeriodID | char(6) | Closed Period | - | |
Description:No description available | ||||
ClosedTranPeriodID | char(6) | Closed Period | - | |
Description:No description available | ||||
CuryDiscActTakenNonexistent in DB | decimal | Currency Cash Discount Taken | - | |
Description:No description available | ||||
CuryDiscBal | decimal(19, 4) | Cash Discount Balance | - | |
Description:No description available | ||||
CuryDiscTaken | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryDocBal | decimal(19, 4) | Currency Balance | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryOrigDiscAmt | decimal(19, 4) | Cash Discount | - | |
Description:No description available | ||||
CuryOrigDocAmt | decimal(19, 4) | Currency Origin. Amount | - | |
Description:No description available | ||||
CuryOrigDocAmtWithRetainageTotalNonexistent in DB | decimal | Total Amount | - | |
Description:No description available | ||||
CuryRetainageTotal | decimal(19, 4) | Original Retainage | - | |
Description:No description available | ||||
CuryRetainageUnreleasedAmt | decimal(19, 4) | Unreleased Retainage | - | |
Description:No description available | ||||
CuryRetainedDiscTotal | decimal(19, 4) | Discount on Retainage | - | |
Description:No description available | ||||
CuryRetainedTaxTotal | decimal(19, 4) | Tax on Retainage | - | |
Description:No description available | ||||
CustomerID | int | Customer | - | |
Description:No description available | ||||
DiscActTakenNonexistent in DB | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
DiscBal | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscTaken | decimal(19, 4) | - | ||
Description:No description available | ||||
DocBal | decimal(19, 4) | Balance | - | |
Description:No description available | ||||
DocDate | datetime2 | Date | - | |
Description:No description available | ||||
DocDesc | nvarchar(512) | Description | - | |
Description:No description available | ||||
DueDate | datetime2 | Due Date | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
IsMigratedRecord | bit | - | ||
Description:No description available | ||||
IsRetainageDocument | bit | Retainage Document | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenDoc | bit | - | ||
Description:No description available | ||||
OrigDiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
OrigDocAmt | decimal(19, 4) | Origin. Amount | - | |
Description:No description available | ||||
OrigDocAmtWithRetainageTotalNonexistent in DB | decimal | Total Amount | - | |
Description:No description available | ||||
OrigDocType | char(3) | Orig. Doc. Type | - | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Orig. Ref. Nbr. | - | |
Description:No description available | ||||
PaymentMethodIDNonexistent in DB | nvarchar(10) | Payment Method | - | |
Description:No description available | ||||
PendingPayment | bit | - | ||
Description:No description available | ||||
PrepaymentAccountID | int | Prepayment Account | - | |
Description:No description available | ||||
PrepaymentSubID | int | Prepayment Subaccount | - | |
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
RetainageTotal | decimal(19, 4) | Original Retainage | - | |
Description:No description available | ||||
RetainageUnreleasedAmt | decimal(19, 4) | Unreleased Retainage | - | |
Description:No description available | ||||
RetainedDiscTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
RetainedTaxTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
RGOLAmt | decimal(19, 4) | RGOL Amount | - | |
Description:No description available | ||||
Scheduled | bit | - | ||
Description:No description available | ||||
SignBalance | decimal | - | ||
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
Voided | bit | - | ||
Description:No description available | ||||