Skip to main content
FA

Transact

PX.Objects.FA
Field NameTypeDisplay NameForeign Key
LineNbr
int-
Description:No description available
RefNbrDefault Navigation
nvarchar(15)Reference Number-
Description:No description available
AccountIDDefault NavigationNonexistent in DB
intAccountAccount
Description:No description available
AssetCDNonexistent in DB
nvarchar(15)Asset ID-
Description:No description available
AssetIDDefault Navigation
intAsset-
Description:No description available
BatchNbrDefault Navigation
nvarchar(15)Batch Nbr.-
Description:No description available
BookIDDefault Navigation
intBook-
Description:No description available
BranchIDDefault Navigation
intBranch-
Description:No description available
ClassIDNonexistent in DB
int-
Description:No description available
ComponentNonexistent in DB
bitComponent-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated By-
Description:No description available
CreatedByScreenID
varchar(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
CreditAccountIDDefault Navigation
intCredit Account-
Description:No description available
CreditAmtNonexistent in DB
decimalCredit-
Description:No description available
CreditSubIDDefault Navigation
intCredit Subaccount-
Description:No description available
DebitAccountIDDefault Navigation
intDebit Account-
Description:No description available
DebitAmtNonexistent in DB
decimalDebit-
Description:No description available
DebitSubIDDefault Navigation
intDebit Subaccount-
Description:No description available
DepartmentNonexistent in DB
nvarchar(10)-
Description:No description available
DepreciableNonexistent in DB
bit-
Description:No description available
DeprFromDateNonexistent in DB
datetimePlaced-in-Service Date-
Description:No description available
EmployeeIDNonexistent in DB
int-
Description:No description available
FinPeriodIDDefault Navigation
char(6)Tran. Period-
Description:No description available
GLTranID
int-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified By-
Description:No description available
LastModifiedByScreenID
varchar(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
MethodDesc
nvarchar(10)Method-
Description:No description available
NewAssetNonexistent in DB
bitCreate Asset-
Description:No description available
NoteID
uniqueidentifier-
Description:No description available
Origin
char(1)Origin-
Description:No description available
Posted
bit-
Description:No description available
Qty
decimalQuantity-
Description:No description available
ReceiptDateNonexistent in DB
datetimeReceipt Date-
Description:No description available
ReclassificationOnCreditProhibited
bitReclassification on credit prohibited-
Description:No description available
ReclassificationOnDebitProhibited
bitReclassification on Debit Is Prohibited-
Description:No description available
Released
bitReleased-
Description:No description available
RGOLAmt
decimalRGOL Amount-
Description:No description available
SelectedNonexistent in DB
bitSelected-
Description:No description available
SrcBranchIDDefault Navigation
intFrom Branch-
Description:No description available
SubIDDefault NavigationNonexistent in DB
intSubaccountSub
Description:No description available
TargetAssetIDNonexistent in DB
int-
Description:No description available
TranAmt
decimalTransaction Amount-
Description:No description available
TranDate
datetime2Tran. Date-
Description:No description available
TranDesc
nvarchar(256)Transaction Description-
Description:No description available
TranID
int-
Description:No description available
TranPeriodID
char(6)-
Description:No description available
TranType
char(2)Transaction Type-
Description:No description available
tstamp
timestamp-
Description:No description available