CR
LocationAlias
PX.Objects.CR.Standalone131 of 131 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BAccountID | int | Account ID | BAccount | |
Description:No description available | ||||
LocationCD | nvarchar(30) | Location ID | - | |
Description:No description available | ||||
APAccountID | int | AP Account | - | |
Description:No description available | ||||
APRetainageAcctID | int | Retainage Payable Account | - | |
Description:No description available | ||||
APRetainageSubID | int | Retainage Payable Sub. | - | |
Description:No description available | ||||
APSubID | int | AP Sub. | - | |
Description:No description available | ||||
ARAccountID | int | AR Account | - | |
Description:No description available | ||||
ARRetainageAcctID | int | Retainage Receivable Account | - | |
Description:No description available | ||||
ARRetainageSubID | int | Retainage Receivable Sub. | - | |
Description:No description available | ||||
ARSubID | int | AR Sub. | - | |
Description:No description available | ||||
BAccountBAccountID | int | - | ||
Description:No description available | ||||
CAdditionalHandling | bit | Additional Handling | - | |
Description:No description available | ||||
CARAccountID | int | AR Account | Account | |
Description:No description available | ||||
CARAccountLocationID | int | - | ||
Description:No description available | ||||
CARSubID | int | AR Sub. | Sub | |
Description:No description available | ||||
CashAccountID | int | Cash Account | - | |
Description:No description available | ||||
CAvalaraCustomerUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
CAvalaraExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:No description available | ||||
CBranchID | int | Shipping Branch | Branch | |
Description:No description available | ||||
CCalendarID | nvarchar(10) | Calendar | CSCalendar | |
Description:No description available | ||||
CCarrierID | nvarchar(15) | Ship Via | Carrier | |
Description:No description available | ||||
CDefProjectID | int | Default Project | PMProject | |
Description:No description available | ||||
CDiscountAcctID | int | Discount Account | Account | |
Description:No description available | ||||
CDiscountSubID | int | Discount Sub. | Sub | |
Description:No description available | ||||
CFOBPointID | nvarchar(15) | FOB Point | FOBPoint | |
Description:No description available | ||||
CFreightAcctID | int | Freight Account | Account | |
Description:No description available | ||||
CFreightSubID | int | Freight Sub. | Sub | |
Description:No description available | ||||
CGroundCollect | bit | Ground Collect | - | |
Description:No description available | ||||
CInsideDelivery | bit | Inside Delivery | - | |
Description:No description available | ||||
CInsurance | bit | Insurance | - | |
Description:No description available | ||||
CLeadTime | smallint | Lead Time (Days) | - | |
Description:No description available | ||||
CLiftGate | bit | Lift Gate | - | |
Description:No description available | ||||
CLimitedAccess | bit | Limited Access | - | |
Description:No description available | ||||
CMPDiscountSubID | int | Discount Sub. | Sub | |
Description:No description available | ||||
CMPExpenseSubID | int | Expense Sub. | Sub | |
Description:No description available | ||||
CMPFreightSubID | int | Freight Sub. | Sub | |
Description:No description available | ||||
CMPGainLossSubID | int | Currency Gain/Loss Sub. | Sub | |
Description:No description available | ||||
CMPSalesSubID | int | Sales Sub. | Sub | |
Description:No description available | ||||
CMPSiteID | int | Warehouse | INSite | |
Description:No description available | ||||
COrderPriority | smallint | Order Priority | - | |
Description:No description available | ||||
CPriceClassID | nvarchar(10) | Price Class | ARPriceClass | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CResedential | bit | Residential Delivery | - | |
Description:No description available | ||||
CRetainageAcctID | int | Retainage Receivable Account | Account | |
Description:No description available | ||||
CRetainageSubID | int | Retainage Receivable Sub. | Sub | |
Description:No description available | ||||
CSalesAcctID | int | Sales Account | Account | |
Description:No description available | ||||
CSalesSubID | int | Sales Sub. | Sub | |
Description:No description available | ||||
CSaturdayDelivery | bit | Saturday Delivery | - | |
Description:No description available | ||||
CShipComplete | char(1) | Shipping Rule | - | |
Description:No description available | ||||
CShipTermsID | nvarchar(10) | Shipping Terms | ShipTerms | |
Description:No description available | ||||
CShipZoneID | nvarchar(15) | Shipping Zone | ShippingZone | |
Description:No description available | ||||
CSiteID | int | Warehouse | INSite | |
Description:No description available | ||||
CTaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
CTaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:No description available | ||||
DefAddressID | int | Default Address | Address | |
Description:No description available | ||||
DefContactID | int | Default Contact | Contact | |
Description:No description available | ||||
Descr | nvarchar(60) | Location Name | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(64) | External ID | - | |
Description:No description available | ||||
IsActive | bit | Active | - | |
Description:No description available | ||||
IsAddressSameAsMainNonexistent in DBObsolete | bit | Same as Main | - | |
Description:No description available | ||||
IsAPAccountSameAsMainNonexistent in DB | bit | Same As Default Location's | - | |
Description:No description available | ||||
IsAPPaymentInfoSameAsMainNonexistent in DB | bit | Same As Default Location's | - | |
Description:No description available | ||||
IsARAccountSameAsMainNonexistent in DB | bit | Same As Default Location's | - | |
Description:No description available | ||||
IsContactSameAsMainNonexistent in DBObsolete | bit | Same as Main | - | |
Description:No description available | ||||
IsDefault | bit | Default | - | |
Description:No description available | ||||
IsRemitAddressSameAsMainNonexistent in DBObsolete | bit | Same as Main | - | |
Description:No description available | ||||
IsRemitContactSameAsMainNonexistent in DBObsolete | bit | Same as Main | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LocationAPAccountSubBAccountID | int | - | ||
Description:No description available | ||||
LocationAPPaymentInfoBAccountID | int | - | ||
Description:No description available | ||||
LocationARAccountSubBAccountID | int | - | ||
Description:No description available | ||||
LocationID | int | LocationID | - | |
Description:No description available | ||||
LocType | char(2) | Location Type | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideAddressNonexistent in DB | bit | Override | - | |
Description:No description available | ||||
OverrideContactNonexistent in DB | bit | Override | - | |
Description:No description available | ||||
OverrideRemitAddressNonexistent in DB | bit | Override | - | |
Description:No description available | ||||
OverrideRemitContactNonexistent in DB | bit | Override | - | |
Description:No description available | ||||
PaymentByType | int | Payment By | - | |
Description:No description available | ||||
PaymentLeadTime | smallint | Payment Lead Time (Days) | - | |
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | Payment Method | - | |
Description:No description available | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
Description:No description available | ||||
RemitAddressIDNonexistent in DBObsolete | int | - | ||
Description:No description available | ||||
RemitContactIDNonexistent in DBObsolete | int | - | ||
Description:No description available | ||||
SeparateCheck | bit | Pay Separately | - | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VAllowAPBillBeforeReceipt | bit | Allow AP Bill Before Receipt | - | |
Description:No description available | ||||
VAPAccountID | int | AP Account | Account | |
Description:No description available | ||||
VAPAccountLocationID | int | - | ||
Description:No description available | ||||
VAPSubID | int | AP Sub. | Sub | |
Description:No description available | ||||
VBranchID | int | Receiving Branch | Branch | |
Description:No description available | ||||
VCarrierID | nvarchar(15) | Ship Via | Carrier | |
Description:No description available | ||||
VCashAccountID | int | Cash Account | CashAccount | |
Description:No description available | ||||
VDefAddressID | int | - | ||
Description:No description available | ||||
VDefContactID | int | - | ||
Description:No description available | ||||
VDefProjectIDObsolete | int | Default Project | PMProject | |
Description:No description available | ||||
VDiscountAcctID | int | Discount Account | Account | |
Description:No description available | ||||
VDiscountSubID | int | Discount Sub. | Sub | |
Description:No description available | ||||
VEmailOrder | bit | Email Order | - | |
Description:No description available | ||||
VExpenseAcctID | int | Expense Account | Account | |
Description:No description available | ||||
VExpenseSubID | int | Expense Sub. | Sub | |
Description:No description available | ||||
VFOBPointID | nvarchar(15) | FOB Point | FOBPoint | |
Description:No description available | ||||
VFreightAcctID | int | Freight Account | Account | |
Description:No description available | ||||
VFreightSubID | int | Freight Sub. | Sub | |
Description:No description available | ||||
VLeadTime | smallint | Lead Time (Days) | - | |
Description:No description available | ||||
VPaymentByType | int | Payment By | - | |
Description:No description available | ||||
VPaymentInfoLocationID | int | - | ||
Description:No description available | ||||
VPaymentLeadTime | smallint | Payment Lead Time (Days) | - | |
Description:No description available | ||||
VPaymentMethodID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
VPrepaymentPct | decimal(9, 6) | Prepayment Percent | - | |
Description:No description available | ||||
VPrintOrder | bit | Print Order | - | |
Description:No description available | ||||
VRcptQtyAction | char(1) | Receipt Action | - | |
Description:No description available | ||||
VRcptQtyMax | decimal(9, 6) | Max. Receipt (%) | - | |
Description:No description available | ||||
VRcptQtyMin | decimal(9, 6) | Min. Receipt (%) | - | |
Description:No description available | ||||
VRcptQtyThreshold | decimal(9, 6) | Threshold Receipt (%) | - | |
Description:No description available | ||||
VRemitAddressID | int | Address | ||
Description:No description available | ||||
VRemitContactID | int | Contact | ||
Description:No description available | ||||
VRetainageAcctID | int | Retainage Payable Account | Account | |
Description:No description available | ||||
VRetainageSubID | int | Retainage Payable Sub. | Sub | |
Description:No description available | ||||
VSeparateCheck | bit | Pay Separately | - | |
Description:No description available | ||||
VShipTermsID | nvarchar(10) | Shipping Terms | ShipTerms | |
Description:No description available | ||||
VSiteID | int | Warehouse | INSite | |
Description:No description available | ||||
VSiteIDIsNull | smallint | - | ||
Description:No description available | ||||
VTaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
VTaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:No description available | ||||