AR
ARTranPostAlias
PX.Objects.AR41 of 41 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocType | char(3) | Doc. Type | - | |
Description:No description available | ||||
ID | int | - | ||
Description:No description available | ||||
RefNbr | nvarchar(15) | Ref. Nbr. | ARInvoice | |
Description:No description available | ||||
AccountID | int | Account | Account | |
Description:No description available | ||||
AdjNbr | int | - | ||
Description:No description available | ||||
Amt | decimal | - | ||
Description:No description available | ||||
BalanceSign | smallint | - | ||
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Nbr. | Batch | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CuryAmt | decimal(19, 4) | Amount | - | |
Description:No description available | ||||
CuryDiscAmt | decimal(19, 4) | Cash Discount Taken | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryItemDiscAmt | decimal | - | ||
Description:No description available | ||||
CuryPPDAmt | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
CuryRetainageAmt | decimal | - | ||
Description:No description available | ||||
CuryWOAmt | decimal(19, 4) | Write-Off Amount | - | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
DiscAmt | decimal | - | ||
Description:No description available | ||||
DocDate | datetime2 | Date | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Application Period | - | |
Description:No description available | ||||
GLSign | smallint | - | ||
Description:No description available | ||||
IsMigratedRecord | bit | - | ||
Description:No description available | ||||
IsVoidPrepaymentNonexistent in DB | bit | - | ||
Description:No description available | ||||
ItemDiscAmt | decimal | - | ||
Description:No description available | ||||
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
PPDAmt | decimal | - | ||
Description:No description available | ||||
ReferenceID | int | Customer | BAccount | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
RetainageAmt | decimal | - | ||
Description:No description available | ||||
RGOLAmt | decimal | - | ||
Description:No description available | ||||
SourceDocType | char(3) | Source Doc. Type | - | |
Description:No description available | ||||
SourceRefNbr | nvarchar(15) | Source Ref. Nbr. | - | |
Description:No description available | ||||
StatementDate | datetime2 | - | ||
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
TranClass | varchar(MAX) | - | ||
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
TranRefNbr | nvarchar(MAX) | Tran. Ref. Nbr. | - | |
Description:No description available | ||||
TranType | varchar(MAX) | Tran. Type | - | |
Description:No description available | ||||
Type | char(1) | Transaction type | - | |
Description:No description available | ||||
VoidAdjNbr | int | - | ||
Description:No description available | ||||
WOAmt | decimal | - | ||
Description:No description available | ||||