Skip to main content
AR

ARInvoice

PX.Objects.AR.Standalone
Field NameTypeDisplay NameForeign Key
DocType
char(3)-
Description:No description available
RefNbr
nvarchar(15)ARRegister
Description:No description available
ApplyOverdueCharge
bit-
Description:No description available
ApprovedCredit
bit-
Description:No description available
ApprovedCreditAmt
decimal(19, 4)-
Description:No description available
AvalaraCustomerUsageType
char(1)-
Description:No description available
BalanceWOTotal
decimal(19, 4)-
Description:No description available
BillAddressID
intARAddress
Description:No description available
BillContactID
intARContact
Description:No description available
CommnAmt
decimal(19, 4)-
Description:No description available
CommnblAmt
decimal(19, 4)-
Description:No description available
CommnPct
decimal(9, 6)-
Description:No description available
CreditHold
bitCredit Hold-
Description:No description available
CuryBalanceWOTotal
decimal(19, 4)-
Description:No description available
CuryCommnAmt
decimal(19, 4)-
Description:No description available
CuryCommnblAmt
decimal(19, 4)-
Description:No description available
CuryDiscAppliedAmt
decimal(19, 4)-
Description:No description available
CuryGoodsExtPriceTotal
decimal(19, 4)Goods-
Description:No description available
CuryLineDiscTotal
decimal(19, 4)Line Discounts-
Description:No description available
CuryLineTotal
decimal(19, 4)-
Description:No description available
CuryMiscExtPriceTotal
decimal(19, 4)Misc. Charges-
Description:No description available
CuryPaymentTotal
decimal(19, 4)-
Description:No description available
CuryTaxTotal
decimal(19, 4)-
Description:No description available
CuryUnpaidBalance
decimal(19, 4)-
Description:No description available
CuryVatExemptTotal
decimal(19, 4)-
Description:No description available
CuryVatTaxableTotal
decimal(19, 4)-
Description:No description available
DiscAppliedAmt
decimal(19, 4)-
Description:No description available
DiscDate
datetime2-
Description:No description available
ExternalTaxExemptionNumber
nvarchar(30)-
Description:No description available
GoodsExtPriceTotal
decimal(19, 4)-
Description:No description available
InstallmentNbr
smallint-
Description:No description available
InvoiceDate
datetime2-
Description:No description available
InvoiceNbr
nvarchar(40)-
Description:No description available
IsPaymentsTransferred
bit-
Description:No description available
LineDiscTotal
decimal(19, 4)Line Discounts-
Description:No description available
LineTotal
decimal(19, 4)-
Description:No description available
MasterRefNbr
nvarchar(15)-
Description:No description available
MiscExtPriceTotal
decimal(19, 4)-
Description:No description available
OwnerID
intContact
Description:No description available
PaymentTotal
decimal(19, 4)-
Description:No description available
ProjectID
intPMProject
Description:No description available
RefNoteID
uniqueidentifier-
Description:No description available
Revoked
bitRevoked-
Description:No description available
ShipAddressID
intARAddress
Description:No description available
ShipContactID
intARContact
Description:No description available
TaxTotal
decimal(19, 4)-
Description:No description available
TaxZoneID
nvarchar(10)TaxZone
Description:No description available
TermsID
nvarchar(10)Terms
Description:No description available
UnpaidBalance
decimal(19, 4)-
Description:No description available
VatExemptTotal
decimal(19, 4)-
Description:No description available
VatTaxableTotal
decimal(19, 4)-
Description:No description available
WorkgroupID
intEPCompanyTree
Description:No description available