AR
ARDocumentEnq.GLTran
PX.Objects.AR78 of 78 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BatchNbr | nvarchar(15) | Batch Number | Batch | |
Description:No description available | ||||
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
Module | char(2) | Module | - | |
Description:No description available | ||||
AccountID | int | Account | Account | |
Description:No description available | ||||
AccountRequireUnitsNonexistent in DB | bit | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CATranID | bigint | CATran | ||
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CreditAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryCreditAmt | decimal | Credit Amount | - | |
Description:No description available | ||||
CuryDebitAmt | decimal | Debit Amount | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryReclassRemainingAmt | decimal | Remaining Reclass. Amount | - | |
Description:No description available | ||||
DebitAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
FinPeriodID | char(6) | Period ID | - | |
Description:No description available | ||||
GLTurnover | decimal | - | ||
Description:No description available | ||||
IncludedInReclassHistoryNonexistent in DB | bit | Included in Reclass. History | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsInterCompany | bit | - | ||
Description:No description available | ||||
IsNonPM | bit | - | ||
Description:No description available | ||||
IsReclassReverse | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LedgerBalanceTypeNonexistent in DB | nchar(1) | - | ||
Description:No description available | ||||
LedgerID | int | Ledger | ||
Description:No description available | ||||
NextPostYearNonexistent in DB | nchar(6) | - | ||
Description:No description available | ||||
NextTranYearNonexistent in DB | nchar(6) | - | ||
Description:No description available | ||||
NonBillable | bit | Non Billable | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigAccountID | int | Original Account | Account | |
Description:No description available | ||||
OrigBatchNbr | nvarchar(15) | Orig. Batch Nbr. | - | |
Description:No description available | ||||
OrigLineNbr | int | Orig. Line Nbr. | GLTran | |
Description:No description available | ||||
OrigModule | char(2) | Orig. Module | - | |
Description:No description available | ||||
OrigPMTranID | bigint | - | ||
Description:No description available | ||||
OrigSubID | int | Original Subaccount | Sub | |
Description:No description available | ||||
PMTranID | bigint | PM Tran. | - | |
Description:No description available | ||||
Posted | bit | - | ||
Description:No description available | ||||
PostYearNonexistent in DB | nchar(4) | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
Qty | decimal | Quantity | - | |
Description:No description available | ||||
ReclassBatchModule | char(2) | Reclass. Batch Module | - | |
Description:No description available | ||||
ReclassBatchNbr | nvarchar(15) | Reclass. Batch Number | - | |
Description:No description available | ||||
ReclassificationProhibited | bit | - | ||
Description:No description available | ||||
Reclassified | bit | - | ||
Description:No description available | ||||
ReclassOrigTranDate | datetime2 | - | ||
Description:No description available | ||||
ReclassReleasedCount | int | - | ||
Description:No description available | ||||
ReclassRemainingAmt | decimal | - | ||
Description:No description available | ||||
ReclassSeqNbr | int | Reclass. Sequence Nbr. | - | |
Description:No description available | ||||
ReclassSourceTranBatchNbr | nvarchar(15) | - | ||
Description:No description available | ||||
ReclassSourceTranLineNbr | int | - | ||
Description:No description available | ||||
ReclassSourceTranModule | char(2) | - | ||
Description:No description available | ||||
ReclassTotalCount | int | - | ||
Description:No description available | ||||
ReclassType | varchar(1) | Reclassification Type | - | |
Description:No description available | ||||
ReferenceID | int | Customer/Vendor | BAccount | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Ref. Number | - | |
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SkipNormalizeAmountsNonexistent in DB | bit | - | ||
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
SummPost | bit | - | ||
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TaxID | nvarchar(60) | Tax ID | - | |
Description:No description available | ||||
TranClass | char(1) | - | ||
Description:No description available | ||||
TranDate | datetime2 | Transaction Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(512) | Transaction Description | - | |
Description:No description available | ||||
TranID | int | - | ||
Description:No description available | ||||
TranLineNbr | int | - | ||
Description:No description available | ||||
TranPeriodID | char(6) | Master Period ID | - | |
Description:No description available | ||||
TranType | char(3) | - | ||
Description:No description available | ||||
TranYearNonexistent in DB | nchar(4) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
ZeroPostNonexistent in DB | bit | - | ||
Description:No description available | ||||