AP
APTran2
PX.Objects.AP136 of 136 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | APInvoice | |
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
AccountID | int | Account | Account | |
Description:No description available | ||||
AccrueCost | bit | Accrue Cost | - | |
Description:No description available | ||||
AllowControlAccountForModuleNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
AutomaticDiscountsDisabled | bit | - | ||
Description:No description available | ||||
BaseQty | decimal | Base Qty. | - | |
Description:No description available | ||||
BaseUnreceivedQty | decimal | - | ||
Description:No description available | ||||
Box1099 | smallint | 1099 Box | AP1099Box | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CalculateDiscountsOnImportNonexistent in DB | bit | Calculate automatic discounts on import | - | |
Description:No description available | ||||
CanViewDeferralSchedule | bit | - | ||
Description:No description available | ||||
CashDiscBal | decimal | - | ||
Description:No description available | ||||
ClassIDNonexistent in DB | int | Asset Class | FixedAsset | |
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 | ||||
CuryCashDiscBal | decimal | Cash Discount Balance | - | |
Description:No description available | ||||
CuryDiscAmt | decimal | Discount Amount | - | |
Description:No description available | ||||
CuryDiscCost | decimal | Disc. Unit Cost | - | |
Description:No description available | ||||
CuryExpenseAmt | decimal | - | ||
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryLineAmt | decimal | Ext. Cost | - | |
Description:No description available | ||||
CuryOrigRetainageAmt | decimal | Original Retainage | - | |
Description:No description available | ||||
CuryOrigTaxableAmt | decimal | Taxable Amount | - | |
Description:No description available | ||||
CuryOrigTaxAmt | decimal | Tax Amount | - | |
Description:No description available | ||||
CuryOrigTranAmt | decimal | Original Amount | - | |
Description:No description available | ||||
CuryPrepaymentAmt | decimal | Prepayment Amount | - | |
Description:No description available | ||||
CuryRetainageAmt | decimal | CuryRetainageAmt | - | |
Description:No description available | ||||
CuryRetainageBal | decimal | Unreleased Retainage | - | |
Description:No description available | ||||
CuryRetainedTaxableAmt | decimal | Retained Taxable Amount | - | |
Description:No description available | ||||
CuryRetainedTaxAmt | decimal | Retained Tax | - | |
Description:No description available | ||||
CuryTaxableAmt | decimal | Net Amount | - | |
Description:No description available | ||||
CuryTaxAmt | decimal | VAT | - | |
Description:No description available | ||||
CuryTranAmt | decimal | Amount | - | |
Description:No description available | ||||
CuryTranBal | decimal | Balance | - | |
Description:No description available | ||||
CuryUnitCost | decimal | Unit Cost | - | |
Description:No description available | ||||
CustodianNonexistent in DB | uniqueidentifier | Custodian | EPEmployee | |
Description:No description available | ||||
Date | datetime2 | Expense Date | - | |
Description:No description available | ||||
DeferredCode | nvarchar(10) | Deferral Code | DRDeferredCode | |
Description:No description available | ||||
DefScheduleID | int | Original Deferral Schedule | DRSchedule | |
Description:No description available | ||||
DiscAmt | decimal | - | ||
Description:No description available | ||||
DiscCost | decimal | - | ||
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | APDiscount | |
Description:No description available | ||||
DiscountsAppliedToLine | varbinary | - | ||
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | - | |
Description:No description available | ||||
DiscPct | decimal | Discount Percent | - | |
Description:No description available | ||||
DocumentDiscountRate | decimal | - | ||
Description:No description available | ||||
DrCr | char(1) | - | ||
Description:No description available | ||||
DropshipExpenseRecording | varchar(1) | - | ||
Description:No description available | ||||
DRTermEndDate | datetime2 | Term End Date | - | |
Description:No description available | ||||
DRTermStartDate | datetime2 | Term Start Date | - | |
Description:No description available | ||||
EmployeeID | int | - | ||
Description:No description available | ||||
ExpectedPPVAmount | decimal | Estimated PPV Amount | - | |
Description:No description available | ||||
ExpenseAmt | decimal | - | ||
Description:No description available | ||||
FinPeriodID | char(6) | - | ||
Description:No description available | ||||
FreezeManualDiscNonexistent in DB | bit | - | ||
Description:No description available | ||||
GroupDiscountRate | decimal | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsDirectTaxLine | bit | - | ||
Description:No description available | ||||
IsStockItem | bit | - | ||
Description:No description available | ||||
LandedCostCodeID | nvarchar(15) | Landed Cost Code | LandedCostCode | |
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 | ||||
LCDocType | char(1) | LC Type | - | |
Description:No description available | ||||
LCLineNbr | int | LC Line | POLandedCostDetail | |
Description:No description available | ||||
LCRefNbr | nvarchar(15) | LC Number | POLandedCostDoc | |
Description:No description available | ||||
LineAmt | decimal | - | ||
Description:No description available | ||||
LineType | char(2) | - | ||
Description:No description available | ||||
ManualDisc | bit | Manual Discount | - | |
Description:No description available | ||||
ManualPrice | bit | Manual Cost | - | |
Description:No description available | ||||
NonBillable | bit | Non Billable | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigDocumentDiscountRate | decimal | - | ||
Description:No description available | ||||
OrigGroupDiscountRate | decimal | - | ||
Description:No description available | ||||
OrigLineNbr | int | - | ||
Description:No description available | ||||
OrigRetainageAmt | decimal | - | ||
Description:No description available | ||||
OrigTaxableAmt | decimal | - | ||
Description:No description available | ||||
OrigTaxAmt | decimal | - | ||
Description:No description available | ||||
OrigTranAmt | decimal | - | ||
Description:No description available | ||||
POAccrualLineNbr | int | - | ||
Description:No description available | ||||
POAccrualRefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
POAccrualType | char(1) | Billing Based On | - | |
Description:No description available | ||||
POLineNbr | int | PO Line | POLine | |
Description:No description available | ||||
PONbr | nvarchar(15) | PO Number | POOrder | |
Description:No description available | ||||
POOrderType | char(2) | PO Type | - | |
Description:No description available | ||||
POPPVAmt | decimal | PO PPV Amount | - | |
Description:No description available | ||||
PPVDocType | char(3) | PPV Doc. Type | - | |
Description:No description available | ||||
PPVRefNbr | nvarchar(15) | PPV Ref. Nbr. | INRegister | |
Description:No description available | ||||
PrepaymentAmt | decimal | - | ||
Description:No description available | ||||
PrepaymentPct | decimal | Prepayment Percent | - | |
Description:No description available | ||||
PrevPOLineNbr | int | - | ||
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
ProjectReclassifiedNonexistent in DB | bit | - | ||
Description:No description available | ||||
Qty | decimal | Quantity | - | |
Description:No description available | ||||
ReceiptLineNbr | int | PO Receipt Line | POReceiptLine | |
Description:No description available | ||||
ReceiptNbr | nvarchar(15) | PO Receipt Nbr. | POReceipt | |
Description:No description available | ||||
ReceiptType | char(2) | PO Receipt Type | - | |
Description:No description available | ||||
Reclassified | bit | - | ||
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
RequiresTermsNonexistent in DB | bit | - | ||
Description:No description available | ||||
RetainageAmt | decimal | - | ||
Description:No description available | ||||
RetainageBal | decimal | - | ||
Description:No description available | ||||
RetainagePct | decimal | RetainagePct | - | |
Description:No description available | ||||
RetainedTaxableAmt | decimal | - | ||
Description:No description available | ||||
RetainedTaxAmt | decimal | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SignedCuryTranAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||
SignedQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
SignedTranAmtNonexistent in DB | decimal | - | ||
Description:No description available | ||||
SiteID | int | INSite | ||
Description:No description available | ||||
SkipDiscNonexistent in DB | bit | - | ||
Description:No description available | ||||
SortOrder | int | Line Order | - | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
SuppliedByVendorIDNonexistent in DB | int | Vendor | ||
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TaxableAmt | decimal | - | ||
Description:No description available | ||||
TaxAmt | decimal | - | ||
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TaxID | nvarchar(60) | Tax ID | Tax | |
Description:No description available | ||||
TranAmt | decimal(19, 4) | Amount | - | |
Description:No description available | ||||
TranBal | decimal(19, 4) | Balance | - | |
Description:No description available | ||||
TranClass | char(1) | - | ||
Description:No description available | ||||
TranDate | datetime2 | Document Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Transaction Descr. | - | |
Description:No description available | ||||
TranIDObsolete | int | - | ||
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitCost | decimal | - | ||
Description:No description available | ||||
UnreceivedQty | decimal | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||