GL
JournalWithSubEntry.GLTranDocAP
PX.Objects.GL91 of 91 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BatchNbr | nvarchar(15) | Batch Number | GLDocBatch | |
Description:No description available | ||||
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
Module | char(2) | Batch Module | - | |
Description:No description available | ||||
ApplAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
ApplCount | int | - | ||
Description:No description available | ||||
BAccountID | int | Vendor | BAccount | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CADrCr | nchar(1) | - | ||
Description:No description available | ||||
CashAccountIDNonexistent in DB | int | - | ||
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 | ||||
CreditAccountID | int | Credit Account | Account | |
Description:No description available | ||||
CreditCashAccountID | int | CashAccount | ||
Description:No description available | ||||
CreditSubID | int | Credit Subaccount | Sub | |
Description:No description available | ||||
CuryApplAmt | decimal(19, 4) | Application Amount | - | |
Description:No description available | ||||
CuryDiscAmt | decimal | Cash Discount | - | |
Description:No description available | ||||
CuryDiscBalNonexistent in DB | decimal | Disc. Balance | - | |
Description:No description available | ||||
CuryDiscTaken | decimal | - | ||
Description:No description available | ||||
CuryDocTotalNonexistent in DB | decimal | Doc Total | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInclTaxAmt | decimal | Included Tax Amount | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryOrigWhTaxAmt | decimal | With. Tax | - | |
Description:No description available | ||||
CuryTaxableAmt | decimal | Taxable Amount | - | |
Description:No description available | ||||
CuryTaxAmt | decimal | Tax Amount | - | |
Description:No description available | ||||
CuryTaxTotalNonexistent in DB | decimal | Tax Total | - | |
Description:No description available | ||||
CuryTaxWheld | decimal | - | ||
Description:No description available | ||||
CuryTranAmt | decimal | Subtotal Amount | - | |
Description:No description available | ||||
CuryTranTotal | decimal | Total Amount | - | |
Description:No description available | ||||
CuryUnappliedBalNonexistent in DB | decimal | Unapplied Balance | - | |
Description:No description available | ||||
CuryWhTaxBalNonexistent in DB | decimal | Wh. Tax Balance | - | |
Description:No description available | ||||
DebitAccountID | int | Debit Account | Account | |
Description:No description available | ||||
DebitCashAccountID | int | CashAccount | ||
Description:No description available | ||||
DebitSubID | int | Debit Subaccount | Sub | |
Description:No description available | ||||
DiscAmt | decimal | - | ||
Description:No description available | ||||
DiscBalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
DiscDate | datetime2 | Cash Discount Date | - | |
Description:No description available | ||||
DiscTaken | decimal | - | ||
Description:No description available | ||||
DocCreated | bit | Doc. Created | - | |
Description:No description available | ||||
DocTotalNonexistent in DB | unspecified | - | ||
Description:No description available | ||||
DueDate | datetime2 | Due Date | - | |
Description:No description available | ||||
EntryTypeID | nvarchar(10) | Entry Type ID | CAEntryType | |
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Ext. Ref.Number | - | |
Description:No description available | ||||
FinPeriodID | char(6) | - | ||
Description:No description available | ||||
GroupTranIDNonexistent in DB | int | GroupTranID | - | |
Description:No description available | ||||
ImportRefNbrNonexistent in DB | nvarchar(15) | - | ||
Description:No description available | ||||
InclTaxAmt | decimal | Included Tax Amount | - | |
Description:No description available | ||||
IsARCustomerCashAccountNonexistent in DB | 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 | ||||
LocationID | int | Location | Location | |
Description:No description available | ||||
NeedsCreditCashAccountNonexistent in DB | bit | - | ||
Description:No description available | ||||
NeedsDebitCashAccountNonexistent in DB | bit | - | ||
Description:No description available | ||||
NeedTaskValidationNonexistent in DB | bit | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigWhTaxAmt | decimal | - | ||
Description:No description available | ||||
ParentLineNbr | int | Parent Line Nbr. | GLTranDoc | |
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
PMInstanceID | int | Card/Account Nbr. | CustomerPaymentMethod | |
Description:No description available | ||||
PMTranID | bigint | PMTran | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Ref. Number | APInvoice | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
Split | bit | Split | - | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TaxableAmt | decimal | Taxable Amount | - | |
Description:No description available | ||||
TaxAmt | decimal | Tax Amount | - | |
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TaxID | nvarchar(60) | Tax ID | Tax | |
Description:No description available | ||||
TaxRate | decimal | Tax Rate | - | |
Description:No description available | ||||
TaxWheld | decimal | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | Terms | |
Description:No description available | ||||
TranAmt | decimal | - | ||
Description:No description available | ||||
TranClass | char(1) | - | ||
Description:No description available | ||||
TranCode | nvarchar(5) | Tran. Code | GLTranCode | |
Description:No description available | ||||
TranDate | datetime2 | Transaction Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Transaction Description | - | |
Description:No description available | ||||
TranLineNbr | int | - | ||
Description:No description available | ||||
TranModule | char(2) | Tran. Module | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
TranTotal | decimal | - | ||
Description:No description available | ||||
TranType | char(3) | Type | GLTranCode | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnappliedBalNonexistent in DB | decimal | - | ||
Description:No description available | ||||
WhTaxBalNonexistent in DB | decimal | - | ||
Description:No description available | ||||