SO
SOInvoice
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ARPaymentCATranID | bigint | - | ||
Description:No description available | ||||
ARPaymentCashAccountID | int | - | ||
Description:No description available | ||||
ARPaymentClearDate | datetime | - | ||
Description:No description available | ||||
ARPaymentCleared | bit | - | ||
Description:No description available | ||||
ARPaymentDepositAsBatch | bit | - | ||
Description:No description available | ||||
ARPaymentDocType | char(3) | ARPayment | ||
Description:No description available | ||||
ARPaymentExtRefNbr | nvarchar(15) | - | ||
Description:No description available | ||||
ARPaymentPMInstanceID | int | - | ||
Description:No description available | ||||
ARPaymentPaymentMethodID | nvarchar(10) | - | ||
Description:No description available | ||||
ARPaymentRefNbr | nvarchar(15) | ARPayment | ||
Description:No description available | ||||
ARRegisterDocType | char(3) | ARRegister | ||
Description:No description available | ||||
ARRegisterRefNbr | nvarchar(15) | ARRegister | ||
Description:No description available | ||||
AdjDate | datetime | - | ||
Description:No description available | ||||
AdjFinPeriodID | nvarchar | - | ||
Description:No description available | ||||
AdjTranPeriodID | nvarchar | - | ||
Description:No description available | ||||
BillAddressID | int | SOBillingAddress | ||
Description:No description available | ||||
BillContactID | int | SOBillingContact | ||
Description:No description available | ||||
CATranID | bigint | - | ||
Description:No description available | ||||
CashAccountID | int | Cash Account | Account | |
Description:No description available | ||||
ChargeCntr | int | - | ||
Description:No description available | ||||
ClearDate | datetime | Clear Date | - | |
Description:No description available | ||||
Cleared | bit | Cleared | - | |
Description:No description available | ||||
ConsolidateChargeTotal | decimal | - | ||
Description:No description available | ||||
CreateINDoc | bit | - | ||
Description:The flag indicates that the Invoice contains at least one line with a Stock Item, therefore an Inventory Document should be created. | ||||
CuryConsolidateChargeTotal | decimal | Consolidate Charges | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | ||
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryManDisc | decimal | Manual Total | - | |
Description:No description available | ||||
CuryOrigDocAmt | decimal | - | ||
Description:No description available | ||||
CuryPaymentAmt | decimal | Payment Amount | - | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
DepositAfter | datetime | - | ||
Description:No description available | ||||
DepositNbr | nvarchar(15) | - | ||
Description:No description available | ||||
DepositType | char(3) | - | ||
Description:No description available | ||||
Deposited | bit | - | ||
Description:No description available | ||||
DisableAutomaticTaxCalculation | bit | - | ||
Description:No description available | ||||
DocDate | datetime | Date | - | |
Description:No description available | ||||
DocDesc | nvarchar(150) | Description | - | |
Description:No description available | ||||
DocType | char(3) | Type | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Payment Ref. | - | |
Description:No description available | ||||
Hold | bit | - | ||
Description:No description available | ||||
InitialSOBehavior | char(2) | - | ||
Description:No description available | ||||
IsTaxSaved | bit | Tax has been saved in the external tax provider | - | |
Description:No description available | ||||
IsTaxValid | bit | - | ||
Description:No description available | ||||
ManDisc | decimal | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigDocAmt | decimal | - | ||
Description:No description available | ||||
PMInstanceID | int | Card/Account Nbr. | CustomerPaymentMethod | |
Description:No description available | ||||
PaymentAmt | decimal | - | ||
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
PaymentProjectID | int | Project | PMProject | |
Description:No description available | ||||
PaymentTaskID | int | Project Task | PMTask | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | ARInvoice | |
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
SOOrderNbr | nvarchar(15) | Order Nbr. | SOOrder | |
Description:No description available | ||||
SOOrderType | char(2) | Order Type | SOOrderType | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ShipAddressID | int | SOShippingAddress | ||
Description:No description available | ||||
ShipContactID | int | SOShippingContact | ||
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
SuggestRelatedItemsNonexistent in DB | bool? | - | ||
Description:No description available | ||||
TranCntr | int | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||