Sage_SanAntonio_SAW_Prod |
ap_vendor
ap_vendor_master
ar_customer
ar_customer_master
ar_invoicedetail
ar_invoiceheader
ar_invoicehistorydetail
ar_invoicehistorydetail_master
ar_invoicehistoryheader
ar_invoicehistoryheader_master
ar_openinvoices
ar_openinvoices_master
ar_salesperson
ar_salesperson_master
ci_extendeddescription
ci_extendeddescription_master
ci_item
ci_item_master
ci_udt_uom
ci_udt_uom_master
ci_unitofmeasure
ci_unitofmeasure_master
Im_Itemwarehouse
Im_Itemwarehouse_master
im_warehouse
im_warehouse_master
so_salesorderdetail
so_salesorderdetail_master
so_salesorderheader
so_salesorderheader_master
so_shiptoaddress
so_shiptoaddress_master
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) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LastPaymentDate |
datetime |
(NULL) |
YES |
|
(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 |
103004 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ap_vendor |
1 |
status |
1 |
dbsync_status |
A |
4 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ap_vendor |
1 |
external_id |
1 |
APDivisionNo |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ap_vendor |
1 |
external_id |
2 |
VendorNo |
A |
4120 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
ap_vendor_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
APDivisionNo |
varchar(2) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
VendorNo |
varchar(7) |
latin1_swedish_ci |
NO |
PRI |
(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) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LastPaymentDate |
datetime |
(NULL) |
YES |
|
(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) |
YES |
|
(NULL) |
|
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_master |
0 |
PRIMARY |
1 |
APDivisionNo |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ap_vendor_master |
0 |
PRIMARY |
2 |
VendorNo |
A |
2110 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ap_vendor_master |
1 |
status |
1 |
dbsync_status |
A |
2 |
(NULL) |
(NULL) |
YES |
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) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DateLastPayment |
datetime |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DateLastStatement |
datetime |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DateLastFinanceChrg |
datetime |
(NULL) |
YES |
|
(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) |
YES |
|
(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 |
|
UDF_Market |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_Sales_Territory |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_Licenses |
varchar(14) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
credit_hold |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_Customer_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 |
|
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 |
577992 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_customer |
1 |
externalid |
1 |
ARDivisionNo |
A |
2 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ar_customer |
1 |
externalid |
2 |
CustomerNo |
A |
15210 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ar_customer |
1 |
status |
1 |
dbsync_status |
A |
4 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
ar_customer_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ARDivisionNo |
varchar(2) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
CustomerNo |
varchar(20) |
latin1_swedish_ci |
NO |
PRI |
(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) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DateLastPayment |
datetime |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DateLastStatement |
datetime |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DateLastFinanceChrg |
datetime |
(NULL) |
YES |
|
(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) |
YES |
|
(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 |
|
UDF_Market |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_Sales_Territory |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_Licenses |
varchar(14) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
credit_hold |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_Customer_Territory |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dbsync_id |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
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_customer_master |
0 |
PRIMARY |
1 |
ARDivisionNo |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_customer_master |
0 |
PRIMARY |
2 |
CustomerNo |
A |
7321 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_customer_master |
1 |
status |
1 |
dbsync_status |
A |
2 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
ar_invoicedetail |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
InvoiceNo |
varchar(7) |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
InvoiceType |
varchar(2) |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
LineKey |
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 |
|
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 |
|
CommentText |
varchar(2048) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Quantity |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Price |
decimal(11,3) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Cost |
decimal(11,3) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ExtensionAmt |
decimal(11,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 |
ar_invoicedetail |
0 |
PRIMARY |
1 |
dbsync_id |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
ar_invoiceheader |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
InvoiceNo |
varchar(7) |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
InvoiceType |
varchar(2) |
latin1_swedish_ci |
NO |
|
(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 |
|
SoldTo |
varchar(30) |
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 |
|
InvoiceDate |
datetime |
(NULL) |
NO |
|
(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 |
|
PrintInvoice |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ShipMethod |
varchar(15) |
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 |
|
Adjustment |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
RepetitiveInvoiceRefNo |
varchar(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ActuallyPrinted |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
JobNo |
varchar(7) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
InvoiceDueDate |
datetime |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
|
DiscountDueDate |
datetime |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
|
BatchNo |
varchar(5) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
InvalidTaxCalc |
varchar(1) |
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 |
|
EmailAddress |
varchar(250) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
PaymentType |
varchar(5) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CreditCardID |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CreditCardGUID |
varchar(32) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CardType |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Last4UnencryptedCreditCardNos |
varchar(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ExpirationDateYear |
varchar(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ExpirationDateMonth |
varchar(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CorporateCustIDPurchOrder |
varchar(17) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CorporateTaxOverrd |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CardholderName |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CreditCardTrackingID |
varchar(36) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CreditCardTransactionID |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CreditCardAuthorizationNo |
varchar(16) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
AuthorizationDate |
datetime |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
|
AuthorizationTime |
varchar(8) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
AVSAddressLine1 |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
AVSAddressLine2 |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
AVSCity |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
AVSState |
varchar(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
AVSZipCode |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
AVSCountryCode |
varchar(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CreditCardEmailAddress |
varchar(250) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CreditCardComment |
varchar(250) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
SaveCreditCard |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CommissionRate |
decimal(8,3) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FreightAmt |
decimal(11,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CommissionAmt |
decimal(13,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
RetentionAmt |
decimal(13,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CorporateSalesTax |
decimal(11,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 |
ar_invoiceheader |
0 |
PRIMARY |
1 |
dbsync_id |
A |
0 |
(NULL) |
(NULL) |
|
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 |
|
UDF_CRV_AMT |
int(16) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_CHARGEBACK |
int(10) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_SUPPLIER_ALLOWANCE |
int(10) |
(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_invoicehistorydetail |
0 |
PRIMARY |
1 |
dbsync_id |
A |
651099 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_invoicehistorydetail |
1 |
external |
1 |
InvoiceNo |
A |
29595 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ar_invoicehistorydetail |
1 |
status |
1 |
dbsync_status |
A |
4 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
ar_invoicehistorydetail_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
InvoiceNo |
varchar(7) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
HeaderSeqNo |
varchar(6) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
DetailSeqNo |
varchar(6) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
ItemCode |
varchar(30) |
latin1_swedish_ci |
NO |
PRI |
(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 |
|
UDF_CRV_AMT |
int(16) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_CHARGEBACK |
int(10) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_SUPPLIER_ALLOWANCE |
int(10) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dbsync_id |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
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_master |
0 |
PRIMARY |
1 |
InvoiceNo |
A |
10735 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_invoicehistorydetail_master |
0 |
PRIMARY |
2 |
DetailSeqNo |
A |
21470 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_invoicehistorydetail_master |
0 |
PRIMARY |
3 |
ItemCode |
A |
21470 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_invoicehistorydetail_master |
1 |
status |
1 |
dbsync_status |
A |
2 |
(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 |
162090 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_invoicehistoryheader |
1 |
external |
1 |
InvoiceNo |
A |
32418 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ar_invoicehistoryheader |
1 |
status |
1 |
dbsync_status |
A |
4 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
ar_invoicehistoryheader_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
InvoiceNo |
varchar(7) |
latin1_swedish_ci |
NO |
PRI |
(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 |
NO |
PRI |
(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) |
YES |
|
(NULL) |
|
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_master |
0 |
PRIMARY |
1 |
InvoiceNo |
A |
4946 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_invoicehistoryheader_master |
0 |
PRIMARY |
2 |
InvoiceType |
A |
4946 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_invoicehistoryheader_master |
1 |
status |
1 |
dbsync_status |
A |
2 |
(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 |
|
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_openinvoices |
0 |
PRIMARY |
1 |
dbsync_id |
A |
217650 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_openinvoices |
1 |
external |
1 |
ArDivisionNo |
A |
2 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ar_openinvoices |
1 |
external1 |
1 |
CustomerNo |
A |
7255 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ar_openinvoices |
1 |
external2 |
1 |
InvoiceNo |
A |
27206 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ar_openinvoices |
1 |
status |
1 |
dbsync_status |
A |
4 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
ar_openinvoices_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ArDivisionNo |
varchar(2) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
CustomerNo |
varchar(20) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
InvoiceNo |
varchar(7) |
latin1_swedish_ci |
NO |
PRI |
(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 |
|
dbsync_id |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
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_master |
0 |
PRIMARY |
1 |
ArDivisionNo |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_openinvoices_master |
0 |
PRIMARY |
2 |
CustomerNo |
A |
5193 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_openinvoices_master |
0 |
PRIMARY |
3 |
InvoiceNo |
A |
5193 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_openinvoices_master |
1 |
external |
1 |
ArDivisionNo |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_openinvoices_master |
1 |
external1 |
1 |
CustomerNo |
A |
5193 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_openinvoices_master |
1 |
external2 |
1 |
InvoiceNo |
A |
5193 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_openinvoices_master |
1 |
status |
1 |
dbsync_status |
A |
2 |
(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 |
5853 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_salesperson |
1 |
status |
1 |
dbsync_status |
A |
6 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ar_salesperson |
1 |
external_id |
1 |
SalespersonDivisionNo |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_salesperson |
1 |
external_id |
2 |
SalespersonNo |
A |
234 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
ar_salesperson_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
SalespersonDivisionNo |
varchar(2) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
SalespersonNo |
varchar(4) |
latin1_swedish_ci |
NO |
PRI |
(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) |
YES |
|
(NULL) |
|
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_master |
0 |
PRIMARY |
1 |
SalespersonDivisionNo |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_salesperson_master |
0 |
PRIMARY |
2 |
SalespersonNo |
A |
113 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ar_salesperson_master |
1 |
status |
1 |
dbsync_status |
A |
2 |
(NULL) |
(NULL) |
YES |
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 |
89058 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ci_extendeddescription |
1 |
extended_key |
1 |
ExtendedDescriptionKey |
A |
3562 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
ci_extendeddescription_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ExtendedDescriptionKey |
varchar(10) |
latin1_swedish_ci |
NO |
PRI |
(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) |
YES |
|
(NULL) |
|
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_master |
0 |
PRIMARY |
1 |
ExtendedDescriptionKey |
A |
1880 |
(NULL) |
(NULL) |
|
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 |
|
ItemCodeDesc |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ItemType |
varchar(1) |
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) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LastReceiptDate |
datetime |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LastPhysicalCountDate |
datetime |
(NULL) |
YES |
|
(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) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
SaleEndingDate |
datetime |
(NULL) |
YES |
|
(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 |
|
UDF_Class |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_Brand_Code |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_Item_Type |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_PA_ITEM |
varchar(1) |
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 |
86452 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ci_item |
1 |
default_warehouse |
1 |
DefaultWarehouseCode |
A |
8 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ci_item |
1 |
dbsync_status |
1 |
dbsync_status |
A |
4 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
ci_item_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ItemCode |
varchar(30) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
ItemCodeDesc |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ItemType |
varchar(1) |
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 |
|
(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) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LastReceiptDate |
datetime |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
LastPhysicalCountDate |
datetime |
(NULL) |
YES |
|
(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) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
SaleEndingDate |
datetime |
(NULL) |
YES |
|
(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 |
|
UDF_Class |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_Brand_Code |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_Item_Type |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_PA_ITEM |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dbsync_id |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
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_master |
0 |
PRIMARY |
1 |
ItemCode |
A |
2195 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ci_item_master |
1 |
dbsync_status |
1 |
dbsync_status |
A |
2 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
ci_udt_uom |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
UDF_UOM_CODE |
varchar(4) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
UDF_UOM_DESCRIPTION |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_BOTTLE_QTY |
varchar(5) |
latin1_swedish_ci |
YES |
|
1 |
|
select,insert,update,references |
|
Udf_PA_Size |
varchar(20) |
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_udt_uom |
0 |
PRIMARY |
1 |
dbsync_id |
A |
3163 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ci_udt_uom |
1 |
status |
1 |
dbsync_status |
A |
6 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
ci_udt_uom |
1 |
external_id |
1 |
UDF_UOM_CODE |
A |
225 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
ci_udt_uom_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
UDF_UOM_CODE |
varchar(4) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
UDF_UOM_DESCRIPTION |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_BOTTLE_QTY |
varchar(5) |
latin1_swedish_ci |
YES |
|
1 |
|
select,insert,update,references |
|
Udf_PA_Size |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dbsync_id |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
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_udt_uom_master |
0 |
PRIMARY |
1 |
UDF_UOM_CODE |
A |
108 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ci_udt_uom_master |
1 |
status |
1 |
dbsync_status |
A |
2 |
(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 |
8423 |
(NULL) |
(NULL) |
|
BTREE |
|
|
ci_unitofmeasure |
1 |
unitofmeasure |
1 |
UnitOfMeasure |
A |
210 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
ci_unitofmeasure_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
UnitOfMeasure |
varchar(4) |
latin1_swedish_ci |
NO |
PRI |
(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) |
YES |
|
(NULL) |
|
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_master |
0 |
PRIMARY |
1 |
UnitOfMeasure |
A |
105 |
(NULL) |
(NULL) |
|
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 |
|
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 |
|
UDF_Class |
varchar(20) |
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 |
|
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 |
|
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 |
107800 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Im_Itemwarehouse |
1 |
status |
1 |
dbsync_status |
A |
4 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Im_Itemwarehouse |
1 |
external_id |
1 |
ItemCode |
A |
3850 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Im_Itemwarehouse |
1 |
external_id |
2 |
warehousecode |
A |
7186 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
Im_Itemwarehouse_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ItemCode |
varchar(30) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
warehousecode |
varchar(3) |
latin1_swedish_ci |
NO |
PRI |
(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 |
|
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 |
|
UDF_Class |
varchar(20) |
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 |
|
dbsync_id |
bigint(20) |
(NULL) |
YES |
|
(NULL) |
|
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 |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
Im_Itemwarehouse_master |
0 |
PRIMARY |
1 |
ItemCode |
A |
3128 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Im_Itemwarehouse_master |
0 |
PRIMARY |
2 |
warehousecode |
A |
3128 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Im_Itemwarehouse_master |
1 |
status |
1 |
dbsync_status |
A |
2 |
(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 |
627 |
(NULL) |
(NULL) |
|
BTREE |
|
|
im_warehouse |
1 |
warehouse_code |
1 |
WarehouseCode |
A |
41 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
im_warehouse_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
WarehouseCode |
varchar(3) |
latin1_swedish_ci |
NO |
PRI |
(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) |
YES |
|
(NULL) |
|
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_master |
0 |
PRIMARY |
1 |
WarehouseCode |
A |
17 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
so_salesorderdetail |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
SalesOrderNo |
varchar(7) |
latin1_swedish_ci |
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 |
datetime |
(NULL) |
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 |
|
UDF_CHARGEBACK |
decimal(10,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TaxRate |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_SUPPLIER_ALLOWANCE |
int(10) |
(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 |
82404 |
(NULL) |
(NULL) |
|
BTREE |
|
|
so_salesorderdetail |
1 |
status |
1 |
dbsync_status |
A |
6 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
so_salesorderdetail |
1 |
external_id |
1 |
SalesOrderNo |
A |
74 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
so_salesorderdetail |
1 |
external_id |
2 |
LineKey |
A |
209 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
so_salesorderdetail_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
SalesOrderNo |
varchar(7) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
LineKey |
int(6) |
(NULL) |
NO |
PRI |
(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 |
datetime |
(NULL) |
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 |
|
UDF_CHARGEBACK |
decimal(10,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TaxRate |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_SUPPLIER_ALLOWANCE |
int(10) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dbsync_id |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
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_master |
0 |
PRIMARY |
1 |
SalesOrderNo |
A |
258 |
(NULL) |
(NULL) |
|
BTREE |
|
|
so_salesorderdetail_master |
0 |
PRIMARY |
2 |
LineKey |
A |
517 |
(NULL) |
(NULL) |
|
BTREE |
|
|
so_salesorderdetail_master |
1 |
status |
1 |
dbsync_status |
A |
6 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
so_salesorderheader |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
SalesOrderNo |
varchar(7) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
OrderDate |
datetime |
(NULL) |
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 |
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 |
|
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(255) |
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 |
|
UDF_PA_Order_Type |
varchar(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_TERRITORY |
varchar(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_PA_ORDNUM |
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 |
so_salesorderheader |
0 |
PRIMARY |
1 |
dbsync_id |
A |
26420 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
so_salesorderheader_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
SalesOrderNo |
varchar(7) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
OrderDate |
datetime |
(NULL) |
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 |
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 |
|
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(255) |
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 |
|
UDF_PA_Order_Type |
varchar(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_TERRITORY |
varchar(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_PA_ORDNUM |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dbsync_id |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
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_master |
0 |
PRIMARY |
1 |
SalesOrderNo |
A |
126 |
(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 |
|
Udf_Pa_Pricing |
varchar(93) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_ACTIVE |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_PREMISE |
varchar(5) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_REGION |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_SALES_RECAP |
varchar(30) |
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 |
366349 |
(NULL) |
(NULL) |
|
BTREE |
|
|
so_shiptoaddress |
1 |
status |
1 |
dbsync_status |
A |
4 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
so_shiptoaddress |
1 |
external_id |
1 |
ARDivisionNo |
A |
2 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
so_shiptoaddress |
1 |
external_id |
2 |
CustomerNo |
A |
15264 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
so_shiptoaddress |
1 |
external_id |
3 |
ShipToCode |
A |
17445 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back
so_shiptoaddress_master |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ARDivisionNo |
varchar(2) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
CustomerNo |
varchar(20) |
latin1_swedish_ci |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
|
ShipToCode |
varchar(4) |
latin1_swedish_ci |
NO |
PRI |
(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 |
|
Udf_Pa_Pricing |
varchar(93) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_ACTIVE |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_PREMISE |
varchar(5) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_REGION |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
UDF_SALES_RECAP |
varchar(30) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
dbsync_id |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
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_master |
0 |
PRIMARY |
1 |
ARDivisionNo |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
so_shiptoaddress_master |
0 |
PRIMARY |
2 |
CustomerNo |
A |
8368 |
(NULL) |
(NULL) |
|
BTREE |
|
|
so_shiptoaddress_master |
0 |
PRIMARY |
3 |
ShipToCode |
A |
8368 |
(NULL) |
(NULL) |
|
BTREE |
|
|
so_shiptoaddress_master |
1 |
status |
1 |
dbsync_status |
A |
2 |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
Back