sage

 

 
ap_vendor  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

APDivisionNo

varchar(2)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

VendorNo

varchar(7)

latin1_swedish_ci

NO

 

(NULL)

 

select,insert,update,references

 

VendorName

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AddressLine1

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AddressLine2

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AddressLine3

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

City

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

State

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ZipCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CountryCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PrimaryContact

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TelephoneNo

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TelephoneExt

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FaxNo

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EmailAddress

varchar(250)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

URLAddress

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TermsCode

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Reference

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TemporaryVendor

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

VendorStatus

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

InactiveReasonCode

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CreditCardVendor

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

HoldPayment

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ElectronicPayment

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

StandardEntryClass

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ExemptionNoOnFile

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxSchedule

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxClass

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AccountKey

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SeparateCheck

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Comment

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Sort

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BatchFax

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UsePOReceiptOfInvForVendor

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PrimaryPurchaseAddressCode

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

VendorType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Form1099

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxpayerIDSocialSecurityNo

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Box1099

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

MiscBox9

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ElectronicConsentSigned1099

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FATCA

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

LastPurchaseDate

datetime

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

LastPaymentDate

datetime

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

LastCheckNo

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

LastCheckAmt

decimal(14,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

RetentionRate

decimal(6,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AverageDaysToPay

decimal(3,0)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AverageDaysOverDue

decimal(3,0)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

BalanceDue

decimal(15,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

NumberOfInvToUseInCalc

decimal(7,0)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

ap_vendor

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

ap_vendor

1

status

1

dbsync_status

A

0

(NULL)

(NULL)

YES

BTREE

 

 

ap_vendor

1

external_id

1

APDivisionNo

A

0

(NULL)

(NULL)

 

BTREE

 

 

ap_vendor

1

external_id

2

VendorNo

A

0

(NULL)

(NULL)

 

BTREE

 

 

Back

 
ar_customer  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ARDivisionNo

varchar(2)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

CustomerNo

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CustomerName

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AddressLine1

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AddressLine2

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AddressLine3

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

City

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

State

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ZipCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CountryCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TelephoneNo

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TelephoneExt

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FaxNo

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EmailAddress

varchar(250)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

URLAddress

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EBMEnabled

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EBMConsumerUserID

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BatchFax

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ContactCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipMethod

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxSchedule

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxExemptNo

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TermsCode

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo2

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo2

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo3

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo3

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo4

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo4

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo5

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo5

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Comment

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SortField

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TemporaryCustomer

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CustomerStatus

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

InactiveReasonCode

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

OpenItemCustomer

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ResidentialAddress

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

StatementCycle

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PrintDunningMessage

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UseSageCloudForInvPrinting

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CustomerType

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PriceLevel

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DateLastActivity

datetime

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

DateLastPayment

datetime

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

DateLastStatement

datetime

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

DateLastFinanceChrg

datetime

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

DefaultItemCode

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DefaultCostCode

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DefaultCostType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CreditHold

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PrimaryShipToCode

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DateEstablished

datetime

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

CreditCardGUID

varchar(32)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DefaultPaymentType

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EmailStatements

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

NumberOfInvToUseInCalc

decimal(2,0)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AvgDaysPaymentInvoice

decimal(3,0)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AvgDaysOverDue

decimal(3,0)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CustomerDiscountRate

decimal(12,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ServiceChargeRate

decimal(12,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CreditLimit

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

LastPaymentAmt

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

HighestStmntBalance

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

UnpaidServiceChrg

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

BalanceForward

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CurrentBalance

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AgingCategory1

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AgingCategory2

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AgingCategory3

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AgingCategory4

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

OpenOrderAmt

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

RetentionCurrent

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

RetentionAging1

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

RetentionAging2

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

RetentionAging3

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

RetentionAging4

decimal(13,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommRate2

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommRate3

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommRate4

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommRate5

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

UDF_Territory

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

credit_hold

int(3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

ar_customer

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

ar_customer

1

externalid

1

ARDivisionNo

A

0

(NULL)

(NULL)

YES

BTREE

 

 

ar_customer

1

externalid

2

CustomerNo

A

0

(NULL)

(NULL)

YES

BTREE

 

 

ar_customer

1

status

1

dbsync_status

A

0

(NULL)

(NULL)

YES

BTREE

 

 

Back

 
ar_invoicehistorydetail  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

InvoiceNo

varchar(7)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

HeaderSeqNo

varchar(6)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DetailSeqNo

varchar(6)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ItemCode

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ItemType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ItemCodeDesc

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ExtendedDescriptionKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalesAcctKey

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CostOfGoodsSoldAcctKey

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

InventoryAcctKey

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UnitOfMeasure

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SubjectToExemption

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Commissionable

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxClass

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Discount

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

DropShip

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

WareHouseCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PriceLevel

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ProductLine

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Valuation

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PriceOverridden

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

OrderWarehouse

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Revision

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption1

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption2

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption3

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption4

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption5

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption6

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption7

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption8

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption9

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

KitItem

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ExplodedKitItem

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SkipPrintCompLine

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

StandardKitBill

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AliasItemNo

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CustomerAction

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ItemAction

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarrantyCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ExpirationDate

varchar(25)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ExpirationOverridden

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CostCode

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CostType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CommentText

varchar(2048)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PromiseDate

varchar(25)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

APDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

VendorNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PurchaseOrderNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PurchaseOrderRequiredDate

varchar(25)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

QuantityShipped

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

QuantityOrdered

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

QuantityBackOrdered

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

UnitPrice

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

UnitCose

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

UnitOfMeasureConvFactor

int(12)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CommissionAmt

int(13)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

LineDiscountPercent

int(9)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

QuantiyPerBill

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ExtensionAmt

decimal(11,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AlternateTaxIdentifier

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxTypeApplied

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

NetGrossIndicator

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

DebitCardIndicator

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxAmt

int(12)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TaxRate

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AltUomConvFactor_001

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AltUomQuantity_001

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AltUomUnitPrice_001

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AltUom_001

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

ar_invoicehistorydetail

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

ar_invoicehistorydetail

1

external

1

InvoiceNo

A

0

(NULL)

(NULL)

YES

BTREE

 

 

ar_invoicehistorydetail

1

status

1

dbsync_status

A

0

(NULL)

(NULL)

YES

BTREE

 

 

Back

 
ar_invoicehistoryheader  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

InvoiceNo

varchar(7)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

HeaderSeqNo

varchar(6)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ModuleCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

InvoiceType

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

InvoiceDate

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TransactionDate

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ARDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CustomerNo

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TermsCode

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxSchedule

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxExemptNo

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CustomerPONo

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ApplyToInvoiceNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Comment

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

RepetitiveInvoiceRefNo

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

JobNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

InvoiceDueDate

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

DiscountDueDate

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SourceJournal

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

JournalNoGLBatchNo

varchar(6)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BatchFax

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FaxNo

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShippingInvoice

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalesOrderNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

OrderType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

OrderDate

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

BillToDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToCustomerNo

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToName

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToAddress1

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToAddress2

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToAddress3

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToCity

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToState

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToZipCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToCountryCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToCode

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToName

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToAddress1

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToAddress2

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToAddress3

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToCity

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToState

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToZipCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToCountryCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipDate

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ShipVia

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipZone

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FOB

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ConfirmTo

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CheckNoForDeposit

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommissions

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo2

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo2

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo3

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo3

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo4

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo4

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo5

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo5

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PaymentType

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

OtherPaymentTypeRefNo

varchar(24)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PaymentTypeCategory

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

RMANo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EBMSubmissionType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EBMUserIDSubmittingThisOrder

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EBMUserType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipperID

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UserKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarehouseCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipWeight

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ResidentialAddress

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EmailAddress

varchar(250)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CRMUserID

varchar(11)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CRMCompanyID

varchar(11)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CRMPersonID

varchar(11)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CRMOpportunityID

varchar(11)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxableSalesAmt

decimal(12,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

NonTaxableSalesAmt

decimal(12,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

FreightAmt

decimal(11,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SalesTaxAmt

decimal(11,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CostOfSalesAmt

decimal(12,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AmountSubjectToDiscount

decimal(12,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

DiscountRate

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

DiscountAmt

decimal(11,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SalesSubjectToComm

decimal(12,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CostSubjectToComm

decimal(12,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CommissionRate

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CommissionAmt

decimal(12,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommRate2

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommRate3

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommRate4

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommRate5

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

DepositAmt

decimal(12,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Weight

decimal(11,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

RetentionAmt

decimal(12,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

NumberOfPackages

decimal(5,0)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

DateCreated

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TimeCreated

varchar(8)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UserCreatedKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DateUpdated

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TimeUpdated

varchar(8)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UserUpdatedKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

ar_invoicehistoryheader

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

ar_invoicehistoryheader

1

external

1

InvoiceNo

A

0

(NULL)

(NULL)

YES

BTREE

 

 

ar_invoicehistoryheader

1

status

1

dbsync_status

A

0

(NULL)

(NULL)

YES

BTREE

 

 

Back

 
ar_openinvoices  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ArDivisionNo

varchar(2)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

CustomerNo

varchar(20)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

InvoiceNo

varchar(7)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

InvoiceType

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

InvoiceDate

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

InvoiceDueDate

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

InvoiceDiscountDate

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

InvoiceHistoryHeaderSeqNo

varchar(6)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PostingDate

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TermsCode

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxSchedule

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

salespersonNo

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommissionFlag

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

comment

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CreditMemoInvoiceReference

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

JobNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Customerpono

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

postingReference

varchar(14)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

checkno

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

soldtodivisionno

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

soldtoCustomerno

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

comissionRate

int(9)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TaxableAmt

int(14)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

NonTaxableAmt

int(14)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

FreightAmt

int(13)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SalesTaxAmt

int(13)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CostofSalesAmt

int(14)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SalesSubjectTocomm

int(14)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CostSubjectToComm

int(14)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

commissionAmt

int(13)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

DiscountAmt

int(14)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

paymentToday

int(14)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Balance

int(14)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

RetentionAmt

int(14)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

dbsyncid

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

ar_openinvoices

0

PRIMARY

1

dbsyncid

A

0

(NULL)

(NULL)

 

BTREE

 

 

ar_openinvoices

1

external

1

ArDivisionNo

A

0

(NULL)

(NULL)

YES

BTREE

 

 

ar_openinvoices

1

external1

1

CustomerNo

A

0

(NULL)

(NULL)

YES

BTREE

 

 

ar_openinvoices

1

external2

1

InvoiceNo

A

0

(NULL)

(NULL)

YES

BTREE

 

 

ar_openinvoices

1

status

1

dbsync_status

A

0

(NULL)

(NULL)

YES

BTREE

 

 

Back

 
ar_salesperson  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

SalespersonDivisionNo

varchar(2)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

SalespersonNo

varchar(4)

latin1_swedish_ci

NO

 

(NULL)

 

select,insert,update,references

 

SalespersonName

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AddressLine1

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AddressLine2

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AddressLine3

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

City

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

State

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ZipCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CountryCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TelephoneNo

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TelephoneExt

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EmailAddress

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalesManagerDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalesManagerNo

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CRMUserID

varchar(11)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UserKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CommissionRate

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SalesManagerCommRate

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

ar_salesperson

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

ar_salesperson

1

status

1

dbsync_status

A

0

(NULL)

(NULL)

YES

BTREE

 

 

ar_salesperson

1

external_id

1

SalespersonDivisionNo

A

0

(NULL)

(NULL)

 

BTREE

 

 

ar_salesperson

1

external_id

2

SalespersonNo

A

0

(NULL)

(NULL)

 

BTREE

 

 

Back

 
ci_extendeddescription  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ExtendedDescriptionKey

varchar(10)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

ExtendedDescriptionText

varchar(4096)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CreationModuleCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UpdatedModuleCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DateCreated

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TimeCreated

varchar(8)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UserCreatedKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DateUpdated

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TimeUpdated

varchar(8)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UserUpdatedKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

ci_extendeddescription

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

ci_extendeddescription

1

extended_key

1

ExtendedDescriptionKey

A

0

(NULL)

(NULL)

YES

BTREE

 

 

Back

 
ci_item  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ItemCode

varchar(30)

latin1_swedish_ci

NO

 

(NULL)

 

select,insert,update,references

 

ItemType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ItemCodeDesc

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UseInAR

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UseInSO

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UseInPO

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UseInBM

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CalculateCommission

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DropShip

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EBMEnabled

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AllowBackOrders

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AllowReturns

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PriceCode

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AllowTradeDiscount

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PrintReceiptLabels

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AllocateLandedCost

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

InactiveItem

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ConfirmCostIncrInRcptOfGoods

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarrantyCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalesUnitOfMeasure

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PurchaseUnitOfMeasure

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

StandardUnitOfMeasure

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PostToGLByDivision

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalesAcctKey

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CostOfGoodsSoldAcctKey

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

InventoryAcctKey

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PurchaseAcctKey

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ManufacturingCostAcctKey

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxClass

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PurchasesTaxClass

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ProductLine

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ProductType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Valuation

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DefaultWarehouseCode

varchar(3)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

PrimaryAPDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PrimaryVendorNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ImageFile

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

LastSoldDate

datetime

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

LastReceiptDate

datetime

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

LastPhysicalCountDate

datetime

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Category1

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Category2

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Category3

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Category4

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalesPromotionCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SaleStartingDate

datetime

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

SaleEndingDate

datetime

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

SaleMethod

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ExplodeKitItems

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipWeight

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CommentText

varchar(2048)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

RestockingMethod

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

NextLotSerialNo

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

InventoryCycle

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

RoutingNo

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ProcurementType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PlannerCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BuyerCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

LowLevelCode

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PlannedByMRP

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

VendorItemCode

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SetupCharge

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AttachmentFileName

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ItemImageWidthInPixels

decimal(4,0)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ItemImageHeightInPixels

decimal(4,0)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

StandardUnitCost

decimal(15,6)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

StandardUnitPrice

decimal(15,6)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

LastTotalUnitCost

decimal(15,6)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SalesPromotionPrice

decimal(15,6)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SuggestedRetailPrice

decimal(15,6)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SalesPromotionDiscountPercent

decimal(11,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TotalQuantityOnHand

decimal(15,6)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AverageBackOrderFillDays

decimal(5,0)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

LastAllocatedUnitCost

decimal(15,6)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CommissionRate

decimal(8,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

BaseCommAmt

decimal(11,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

PurchaseUMConvFctr

decimal(11,4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SalesUMConvFctr

decimal(11,4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Volume

decimal(10,4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

RestockingCharge

decimal(10,3)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ExtendedDescriptionKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

ci_item

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

ci_item

1

default_warehouse

1

DefaultWarehouseCode

A

0

(NULL)

(NULL)

YES

BTREE

 

 

ci_item

1

dbsync_status

1

dbsync_status

A

0

(NULL)

(NULL)

YES

BTREE

 

 

Back

 
ci_unitofmeasure  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

UnitOfMeasure

varchar(4)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

ConversionUM1

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ConversionFactor1

decimal(11,4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ConversionUM2

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ConversionFactor2

decimal(11,4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ConversionUM3

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ConversionFactor3

decimal(11,4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ConversionUM4

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ConversionFactor4

decimal(11,4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ConversionUM5

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ConversionFactor5

decimal(11,4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

DateCreated

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TimeCreated

varchar(8)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UserCreatedKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DateUpdated

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TimeUpdated

varchar(8)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UserUpdatedKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

ci_unitofmeasure

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

ci_unitofmeasure

1

unitofmeasure

1

UnitOfMeasure

A

0

(NULL)

(NULL)

YES

BTREE

 

 

Back

 
im_itemwarehouse  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ItemCode

varchar(30)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

warehousecode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Binlocation

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ReorderMethod

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EconomicOrderQty

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ReorderPointQty

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

MinimumOrderQty

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

MaximumOnhandQty

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Quantityonhand

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

QuantityOnPurchaseorder

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

QuantityOnSalesOrder

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

QuantityonBackOrder

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

AverageCost

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

QuantityOnWorkOrder

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

QuantityRequiredForWO

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

QuantityInShipping

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TotalWarehouseValue

int(15)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

bigint(20)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(3)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

dbsync_version

int(10)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

costcalccostcommitted

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

costcalcqtycommitted

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Datecreated

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Timecreated

time

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

UserCreatedKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DateUpdated

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

UserUpdatedKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AltUomQuantity_001

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

LastPhysicalCountDate

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

D404_QuantityOTW

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

im_itemwarehouse

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

im_itemwarehouse

1

status

1

dbsync_status

A

0

(NULL)

(NULL)

YES

BTREE

 

 

im_itemwarehouse

1

external_id

1

ItemCode

A

0

(NULL)

(NULL)

YES

BTREE

 

 

im_itemwarehouse

1

external_id

2

warehousecode

A

0

(NULL)

(NULL)

YES

BTREE

 

 

Back

 
im_warehouse  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

WarehouseCode

varchar(3)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

WarehouseDesc

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarehouseName

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarehouseAddress1

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarehouseAddress2

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarehouseAddress

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarehouseCity

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarehouseState

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarehouseZipCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarehouseCountryCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TelephoneNo

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TelephoneExt

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FaxNo

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EmailAddress

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ContactName

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PostToGLSubAcct

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DateCreated

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TimeCreated

varchar(8)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UserCreatedKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DateUpdated

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TimeUpdated

varchar(8)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UserUpdatedKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

im_warehouse

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

im_warehouse

1

warehouse_code

1

WarehouseCode

A

0

(NULL)

(NULL)

YES

BTREE

 

 

Back

 
so_salesorderdetail  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

SalesOrderNo

int(7)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

LineKey

int(6)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ItemCode

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ItemType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ItemCodeDesc

varchar(45)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Discount

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Commissionable

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SubjectToExemption

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarehouseCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Valuation

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PriceLevel

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

MasterOrderLineKey

varchar(6)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UnitOfMeasure

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DropShip

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

LotSerialFullyDistributed

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PrintDropShipment

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalesKitLineKey

varchar(6)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CostOfGoodsSoldAcctKey

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalesAcctKey

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PriceOverridden

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ExplodedKitItem

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

StandardKitBill

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Revision

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption1

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption2

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption3

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption4

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption5

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption6

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption7

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption8

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillOption9

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BackorderKitCompLine

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SkipPrintCompLine

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PromiseDate

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AliasItemNo

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SOHistoryDetlSeqNo

varchar(14)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxClass

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CustomerAction

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ItemAction

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarrantyCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ExpirationDate

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ExpirationOverridden

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CostOverridden

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CostCode

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CostType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CommentText

varchar(2048)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

APDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

VendorNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PurchaseOrderNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PurchaseOrderRequiredDate

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CommodityCode

varchar(12)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

AlternateTaxIdentifier

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxTypeApplied

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

NetGrossIndicator

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DebitCreditIndicator

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

QuantityOrdered

decimal(16,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

QuantityShipped

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

QuantityBackordered

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

MasterOriginalQty

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

MasterQtyBalance

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

MasterQtyOrderedToDate

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

RepeatingQtyShippedToDate

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

UnitPrice

decimal(14,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

UnitCost

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ExtensionAmt

decimal(14,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

UnitOfMeasureConvFactor

int(12)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

QuantityPerBill

int(16)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

LineDiscountPercent

int(9)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TaxAmt

int(12)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TaxRate

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

so_salesorderdetail

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

so_salesorderdetail

1

status

1

dbsync_status

A

0

(NULL)

(NULL)

YES

BTREE

 

 

so_salesorderdetail

1

external_id

1

SalesOrderNo

A

0

(NULL)

(NULL)

YES

BTREE

 

 

so_salesorderdetail

1

external_id

2

LineKey

A

0

(NULL)

(NULL)

YES

BTREE

 

 

Back

 
so_salesorderheader  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

SalesOrderNo

int(7)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

OrderDate

varchar(25)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

OrderType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

OrderStatus

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

MasterRepeatingOrderNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipExpireDate

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ARDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CustomerNo

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToCustomerNo

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToName

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToAddress1

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToAddress2

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToAddress3

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToCity

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToState

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToZipCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BillToCountryCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToCode

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToName

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToAddress1

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToAddress2

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToAddress3

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToCity

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToState

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToZipCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToCountryCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipVia

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipZone

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipZoneActual

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipWeight

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CustomerPONo

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FOB

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarehouseCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ConfirmTo

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Comment

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TermsCode

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxSchedule

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxExemptNo

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

InvalidTaxCalc

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PrintSalesOrders

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalesOrderPrinted

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PrintPickingSheets

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PickingSheetPrinted

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

LastInvoiceOrderDate

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

LastInvoiceOrderNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CurrentInvoiceNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CheckNoForDeposit

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CycleCode

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FaxNo

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BatchFax

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BatchEmail

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EmailAddress

varchar(250)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FreightCalculationMethod

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

LotSerialLinesExist

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommissions

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo2

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo2

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo3

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo3

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo4

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo4

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo5

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo5

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EBMUserType

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PaymentType

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

OtherPaymentTypeRefNo

varchar(24)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PaymentTypeCategory

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CancelReasonCode

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

RMANo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

JobNo

varchar(7)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ResidentialAddress

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CRMUserID

varchar(11)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CRMPersonID

varchar(11)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CRMOpportunityID

varchar(11)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CRMCompanyID

varchar(11)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CRMProspectID

varchar(11)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PromotedDate

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

DiscountRate

int(8)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

DiscountAmt

int(12)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Weight

int(12)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

FreightAmt

int(12)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

DepositAmt

int(13)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CommissionRate

int(9)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommRate2

int(9)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommRate3

int(9)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommRate4

int(9)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

SplitCommRate5

int(9)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

NumberOfShippingLabels

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

LastNoOfShippingLabels

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

so_salesorderheader

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

Back

 
so_shiptoaddress  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ARDivisionNo

varchar(2)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

CustomerNo

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToCode

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToName

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToAddress1

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToAddress2

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToAddress3

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToCity

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToState

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToZipCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipToCountryCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TelephoneNo

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TelephoneExt

varchar(5)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FaxNo

varchar(17)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BatchFax

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BatchEmail

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EmailAddress

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ContactCode

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonDivisionNo

varchar(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SalespersonNo

varchar(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ShipVia

varchar(15)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

WarehouseCode

varchar(3)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TaxSchedule

varchar(9)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ResidentialAddress

varchar(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DateCreated

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TimeCreated

varchar(8)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UserCreatedKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

DateUpdated

datetime

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TimeUpdated

varchar(8)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

UserUpdatedKey

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

dbsync_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbsync_status

int(2)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

dbsync_version

int(4)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

so_shiptoaddress

0

PRIMARY

1

dbsync_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

so_shiptoaddress

1

status

1

dbsync_status

A

0

(NULL)

(NULL)

YES

BTREE

 

 

so_shiptoaddress

1

external_id

1

ARDivisionNo

A

0

(NULL)

(NULL)

YES

BTREE

 

 

so_shiptoaddress

1

external_id

2

CustomerNo

A

0

(NULL)

(NULL)

YES

BTREE

 

 

so_shiptoaddress

1

external_id

3

ShipToCode

A

0

(NULL)

(NULL)

YES

BTREE

 

 

Back