Accounts Payable Tables

Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.

Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
PostRun pPostRun 14 0    
VendorID pVendorID 10      
InvoiceNum pInvoiceNum 15      
PmtType tinyint 1 0 Payment Type 0 = Payment, 3 = Prepayment, 4 = Manual, 9 = Void
GrossAmtDue pDecimal 13 0    
BaseGrossAmtDue pDecimal 13 0    
DiscAmt pDecimal 13 0    
InvoiceDate datetime 8      
CheckDate datetime 8      
VoidDate datetime 8      
CheckNum pCheckNum 10      
GLCashAcct pGlAcct 40      
GLDiscAcct pGlAcct 40      
GrossAmtDueFgn pDecimal 13 0    
DiscAmtFgn pDecimal 13 0    
CurrencyID pCurrency 6      
Ten99InvoiceYN bit 1 0    
DistCode pDistCode 6      
VoidYn bit 1 0    
SelectedYn bit 1 0    
DiscDueDate datetime 8      
NetDueDate datetime 8      
ExchRate pDecimal 13 -1    
BankId pBankID 10      
VoidBankId pBankID 10      
CheckRun datetime 8      
DiscLost pDecimal 13 0    
DiscTaken pDecimal 13 0    
DiscLostFgn pDecimal 13 0    
DiscTakenFgn pDecimal 13 0    
GlPeriod smallint 2 0    
FiscalYear smallint 2 0    
Ten99FormCode nvarchar 1      
TermsCode pTermsCode 6      
SumHistPeriod smallint 2 0    
PayToName nvarchar 30      
PayToAttn nvarchar 30      
PayToAddr1 nvarchar 30      
PayToAddr2 nvarchar 60      
PayToCity nvarchar 30      
PayToRegion nvarchar 10      
PayToCountry pCountry 6      
PayToPostalCode nvarchar 10      
PmtCurrencyID pCurrency 6      
PmtExchRate pDecimal 13 -1    
NetPaidCalc pDecimal 13 0    
DiscAmtCalc pDecimal 13 0    
DeliveryType tinyint 1 0   0 = Paper, 1 = Electronic
BankAcctNum nnvarchar 510      
RoutingCode nvarchar 9      
GLAcctAP pGlAcct 40      
GLAcctGainLoss pGlAcct 40      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
DistCode pDistCode 6      
Desc nvarchar

25

      
AccrualGLAcct pGlAcct 40      
PayablesGLAcct pGlAcct 40      
SalesTaxGLAcct pGlAcct 40      
FreightGLAcct pGlAcct 40      
MiscGLAcct pGlAcct 40      
CF xml -1      
ts timestamp 8      
DivisionID nvarchar 6      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransID pTransID 8      
InvoiceNum pInvoiceNum 15      
EntryNum int 4 0   -1 = Sales Tax, -2 = Freight, -3 = Misc
LineSeq int 4      
PartId pItemID 24      
PartType tinyint 1 0 Part Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item
WhseId pLocID 10      
Desc nvarchar 35      
Qty pDecimal 13 0    
QtyBase pDecimal 13 0    
Units pUom 5      
UnitsBase pUom 5      
UnitCost pDecimal 13 0    
UnitCostFgn pDecimal 13 0    
ExtCost pDecimal 13 0    
ExtCostFgn pDecimal 13 0    
GLDesc pGLDesc 30      
AddnlDesc text 16      
HistSeqNum int 4 0    
TaxClass tinyint 1 0    
BinNum nvarchar 10      
ConversionFactor pDecimal 13 -1    
LottedYN bit 1 0    
InItemYN bit 1 0    
GLAcct pGlAcct 40      
GLAcctWIP pGlAcct 40      
GLAcctSales pGlAcct 40      
TransHistId nvarchar 10      
CustomerID pCustID 10      
JobId nvarchar 10      
ProjName nvarchar 30      
PhaseId nvarchar 10      
PhaseName nvarchar 30      
TaskId nvarchar 10      
TaskName nvarchar 30      
UnitInc pDecimal 13      
ExtInc pDecimal 13      
ProjItemYn bit 1 0    
CostType nvarchar 6      
CF xml -1      
*ExtLocAID nvarchar 10      
*ExtLocBID nvarchar 10      
*QtySeqNum_Ext int 4      
*QtyStatus int 4      
Column Name Column Type Length Default Value Description Enumeration
BankID pBankID 10      
ChkGlPeriod smallint 2      
ChkFiscalYr smallint 2      
DiscDueDate datetime 8      
GLAcctAP pGlAcct 40      
GLAcctFreight pGlAcct 40      
GLAcctMisc pGlAcct 40      
GLAcctTaxAdj pGlAcct 40      
PostRun pPostRun 14 0    
TransId pTransID 8 0    
InvoiceNum pInvoiceNum 15 0    
BatchId pBatchID 6 '######'    
WhseId pLocID 10 0    
VendorId pVendorID 10 0    
InvoiceDate datetime 8 getdate()    
TransType smallint 2 -1 Transaction Type 1 = Invoice, -1 = Debit Memo
PONum nvarchar 25 0    
DistCode pDistCode 6      
TermsCode pTermsCode 6      
DueDate1 datetime 8      
DueDate2 datetime 8      
DueDate3 datetime 8      
PmtAmt1 pDecimal 13      
PmtAmt2 pDecimal 13      
PmtAmt3 pDecimal 13      
Subtotal pDecimal 13      
SalesTax pDecimal 13      
Freight pDecimal 13      
Misc pDecimal 13      
CashDisc pDecimal 13      
PrepaidAmt pDecimal 13      
CurrencyId pCurrency 6 0    
ExchRate pDecimal 13 -1    
PmtCurrencyId pCurrency 6 0    
PmtExchRate pDecimal 13 -1    
PmtAmt1Fgn pDecimal 13      
PmtAmt2Fgn pDecimal 13      
PmtAmt3Fgn pDecimal 13      
SubtotalFgn pDecimal 13      
SalesTaxFgn pDecimal 13      
FreightFgn pDecimal 13      
MiscFgn pDecimal 13      
CashDiscFgn pDecimal 13      
PrepaidAmtFgn pDecimal 13      
CheckNum nvarchar 50      
CheckDate datetime 8      
PostDate datetime 8      
GLPeriod smallint 2      
FiscalYear smallint 2      
Ten99InvoiceYN bit 1      
Status tinyint 1   Transaction Status 0 = Released, 1 = Hold, 2 = Temp Hold
Notes text 16      
TaxGrpID pTaxLoc 10      
TaxableYn bit 1 -1    
Taxable pDecimal 13      
NonTaxable pDecimal 13      
TaxableFgn pDecimal 13      
NonTaxableFgn pDecimal 13      
TaxClassFreight tinyint 1      
TaxClassMisc tinyint 1      
TaxLocID1 pTaxLoc 10      
TaxAmt1 pDecimal 13      
TaxAmt1Fgn pDecimal 13      
TaxLocID2 pTaxLoc 10      
TaxAmt2 pDecimal 13      
TaxAmt2Fgn pDecimal 13      
TaxLocID3 pTaxLoc 10      
TaxAmt3 pDecimal 13      
TaxAmt3Fgn pDecimal 13      
TaxLocID4 pTaxLoc 10      
TaxAmt4 pDecimal 13      
TaxAmt4Fgn pDecimal 13      
TaxLocID5 pTaxLoc 10      
TaxAmt5 pDecimal 13      
TaxAmt5Fgn pDecimal 13      
TaxAdjClass tinyint 1      
TaxAdjLocID pTaxLoc 10      
TaxAdjAmt pDecimal 13      
TaxAdjAmtFgn pDecimal 13      
Source tinyint 1   Source Application 0 = AP, 1 = PO
SumHistPeriod smallint 2      
CF xml -1      
*TaxGrpID2 pTaxLoc        
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransId pTransID 8      
InvoiceNum pInvoiceNum 15      
EntryNum int 4      
Counter int 4      
TransAllocId nvarchar 10      
AcctId pGlAcct 40      
Amount pDecimal 13 0    
AmountFgn pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransId pTransID 8      
InvoiceNum pInvoiceNum 15      
EntryNum int 4      
SeqNum nvarchar 15      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
QtyOrder pDecimal 13 0    
QtyFilled pDecimal 13 0    
QtyBkord pDecimal 13 0    
CostUnit pDecimal 13 0    
CostUnitFgn pDecimal 13 0    
HistSeqNum int 4      
Cmnt nvarchar 35      
CF xml -1      
*ExtLocAID nvarchar 10      
*ExtLocBID nvarchar 10      
*QtySeqNum_Ext int 4      
*QtyStatus int 4      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransId pTransID 8      
InvoiceNum pInvoiceNum 15      
EntryNum int 4      
SeqNum nvarchar 15      
LotNum pLotNum 16      
SerNum pSerNum 35      
ItemId pItemID 24      
LocId pLocID 10      
CostUnit pDecimal 13 0    
PriceUnit pDecimal 13 0    
CostUnitFgn pDecimal 13 0    
PriceUnitFgn pDecimal 13 0    
HistSeqNum int 4      
Cmnt nvarchar 35      
CF xml -1      
EntryNum int        
ExtLocAID varchar 10      
ExtLocBID varchar 10      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14 0    
TransId pTransID 8      
InvcNum pInvoiceNum 15      
TaxLocID pTaxLoc 10      
TaxClass tinyint 1 0    
ExpAcct pGlAcct 40      
TaxAmt pDecimal 13 0    
Refundable pDecimal 13 0    
Taxable pDecimal 13 0    
NonTaxable pDecimal 13 0    
RefundAcct pGlAcct 40      
TaxAmtFgn pDecimal 13 0    
TaxableFgn pDecimal 13 0    
NonTaxableFgn pDecimal 13 0    
RefundableFgn pDecimal 13 0    
CF xml -1      
TaxGroupType tinyint 1 0   0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2
LiabilityAccount pGlAcct        
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
RecurID nvarchar 10      
CopyDate datetime 8      
BillDate datetime 8      
Amount pDecimal 13 0    
AmountFgn pDecimal 13 0    
PostRun pPostRun 14      
TransID pTransID 8      
Source tinyint 1 0 Source Application 0 = AP, 1 = PO
UserID pUserID 20      
CF xml -1      
EntryNum int        
LineSeq int 4      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
VendorID pVendorID 10      
InvoiceNum pInvoiceNum 15      
Status tinyint 1 0 Invoice Status 0 = Released, 1 = Hold, 2 = Temp Hold, 3 = Paid, 4 = Paid Invoices
Ten99InvoiceYN bit 1 0    
DistCode pDistCode 6      
InvoiceDate datetime 8 getdate()    
DiscDueDate datetime 8      
NetDueDate datetime 8      
GrossAmtDue pDecimal 13 0    
BaseGrossAmtDue pDecimal 13 0    
DiscAmt pDecimal 13 0    
GrossAmtDueFgn pDecimal 13 0    
DiscAmtFgn pDecimal 13 0    
CheckNum pCheckNum 10      
CheckDate datetime 8      
CurrencyId pCurrency 6      
ExchRate pDecimal 13 -1    
GlPeriod smallint 2 0    
FiscalYear smallint 2 0    
CheckPeriod smallint 2 0    
CheckYear smallint 2 0    
TermsCode pTermsCode 6      
VoidCreatedDate datetime 8      
BankID pBankID 10      
PmtCurrencyId pCurrency 6      
PmtExchRate pDecimal 13 -1    
-*CalcGainLoss pDecimal 13      
-*GLAcctGainLoss pGlAcct 40      
*GLAcctAP pGlAcct 40      
*APGrossAmtDue pGlAcct 40      
Notes text 16      
PostRun pPostRun 14      
TransID pTransID 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int 4      
ControlID int 4      
PmtType tinyint 1 0   0 = Payment, 3 = Prepaid
PaymentNum pCheckNum 10 0    
PaymentDate datetime 8 0    
FiscalPeriod smallint 2      
FiscalYear smallint 2      
DeliveryType tinyint 1     0 = Paper, 1 = Electronic, 2 = Credit Card
BankAcctNum nvarchar 255      
RoutingCode nvarchar 9      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID int 4      
BatchID int 6      
Filter nvarchar max      
DisplayFilter nvarchar max      
InvoicesDue datetime 8      
DiscountsDue datetime 8      
PaymentDate datetime 8      
FiscalPeriod smallint 2      
FiscalYear smallint 2      
BankID pBankID 10      
CurrencyID pCurrency 6      
GLCashAcct pGlAcct 40      
GLDiscAcct pGlAcct 40      
TransmitDate datetime 8      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID int 4      
PaymentID int 4      
InvoiceCounter int 4      
ControlID int 4      
GrossAmtDue pDecimal 13      
GrossAmtDueBase pDecimal 13      
DiscLost pDecimal 13      
DiscLostBase pDecimal 13      
DiscTaken pDecimal 13      
DiscTakenBase pDecimal 13      
PaymentAmt pDecimal 13      
PaymentAmtBase pDecimal 13      
GLAccGainLoss pGlAcct 40      
GLGainLossAmt pDecimal 13      
GLGainLossAmtBase pDecimal 13      
DropFlagYN bit 1      
ts timestamp 8      
CF xml -1      
AdjAmt pDecimal 13      
AdjAmtFgn pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
PaymentID int 4      
PaymentDetailID int 4      
TaxLocID pTaxLoc        
TaxClass tinyint 1      
Level tinyint 1      
TaxAmt pDecimal 13      
TaxAmtFgn pDecimal 13      
Taxable pDecimal 13      
TaxableFgn pDecimal 13      
NonTaxable pDecimal 13      
NonTaxableFgn pDecimal 13      
Refundable pDecimal 13      
RefundableFgn pDecimal 13      
LiabilityAcct pGlAcct 40      
ExpenseAcct pGlAcct 40      
RefundAcct pGlAcct 40      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
HeaderID bigint 8      
Invoicecounter int 4      
InvoiceDate datetime 8      
InvoiceNum pInvoiceNum 15      
DistCode pDistCode 6      
TermsCode pTermsCode 6      
CurrencyID pCurrency 6      
NetDueDate datetime 8      
DiscDueDate datetime 8      
GrossAmtDue pDecimal 13      
GrossAmtDueBase pDecimal 13      
DiscLost pDecimal 13      
DiscLostBase pDecimal 13      
DiscTaken pDecimal 13      
DiscTakenBase pDecimal 13      
PaymentAmt pDecimal 13      
PaymentAmtBase pDecimal 13      
GLAcctAP pGlAcct 40      
GLPayableAmt pDecimal 13      
GLPayableAmtBase pDecimal 13      
GLDiscAmt pDecimal 13      
GLDiscAmtBase pDecimal 13      
GLAccGainLoss pGlAcct 40      
GLGainLossAmt pDecimal 13 0    
GLGainLossAmtBase pDecimal 13 0    
Ten99InvoiceYN bit 1 0    
BaseGrossAmtDue pDecimal 13 0    
APGrossAmtDue pDecimal 13 0    
CF xml -1      
AdjAmt pDecimal 13 0    
AdjAmtFgn pDecimal 13 0    
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
HeaderID int 4      
DetailID int 4      
TaxLocID pTaxLoc        
TaxClass tinyint 1      
Level tinyint 1      
TaxAmt pDecimal 13      
TaxAmtFgn pDecimal 13      
Taxable pDecimal 13      
TaxableFgn pDecimal 13      
NonTaxable pDecimal 13      
NonTaxableFgn pDecimal 13      
Refundable pDecimal 13      
RefundableFgn pDecimal 13      
LiabilityAcct pGlAcct 40      
ExpenseAcct pGlAcct 40      
RefundAcct pGlAcct 40      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
Ten99Amt pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
PostRun pPostRun 14      
PaymentID int 4      
BatchID pBatchID 6      
VendorID pVendorID 10      
PmtType tinyint 1     0 = Payment, 3 = Prepaid
PaymentDate datetime 8      
PaymentRun datetime 8      
PaymentAmt pDecimal 13      
PaymentAmtBase pDecimal 13      
CurrencyId pCurrency 6      
BankID pBankID 10      
BankAcctNum nvarchar 255      
RoutingCode nvarchar 9      
FiscalPeriod smallint 2      
FiscalYear smallint 2      
PayToName nvarchar 30      
PayToAttn nvarchar 30      
PayToAddr1 nvarchar 30      
PayToAddr2 nvarchar 60      
PayToCity nvarchar 30      
PayToRegion nvarchar 10      
PayToCountry pCountry 6      
PayToPostalCode nvarchar 10      
DeliveryType tinyint 1     0 = Paper, 1 = Electronic
GLCashAcct pGlAcct 40      
GLDiscAcct pGlAcct 40      
VoidDate datetime 8      
VoidFiscalPeriod smallint 2      
VoidFiscalYear smallint 2      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
VendorID pVendorID 10      
CheckNum pCheckNum 10      
CheckAmt pDecimal 13 0    
DiscTaken pDecimal 13 0    
DiscLost pDecimal 13 0    
Ten99Pmt pDecimal 13 0    
CheckAmtFgn pDecimal 13 0    
DiscTakenFgn pDecimal 13 0    
DiscLostFgn pDecimal 13 0    
Ten99PmtFgn pDecimal 13 0    
CheckDate datetime 8      
GLCashAcct pGlAcct 40      
CurrencyId pCurrency 6      
CalcGainLoss pDecimal 13 0    
GLAccGainLoss pGlAcct 40      
GrpID int 4 0    
BatchID pBatchID 6 '######'    
DeliveryType tinyint 1 0    
BankAcctNum nvarchar 510      
RoutingCode nvarchar 9      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
VendorIDFrom pVendorID 10      
VendorIDThru pVendorID 10      
Currency pCurrency 6      
InvoicesDue datetime 8      
DiscountsDue datetime 8      
CheckDate datetime 8      
GLPeriod smallint 2 0    
FiscalYear smallint 2 0    
PrepaidCheckTotal pDecimal 13 0    
DiscountTakenTotal pDecimal 13 0    
CheckAmountTotal pDecimal 13 0    
PrepaidCheckTotalFgn pDecimal 13 0    
DiscountTakenTotalFgn pDecimal 13 0    
CheckAmountTotalFgn pDecimal 13 0    
User pUserID 20      
BankID pBankID 10      
PmtCurrencyId pCurrency 6      
PmtExchRate pDecimal 13 -1    
BatchID pBatchID 6 '######'    
TransmitDate datetime 8      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
VendorID pVendorID 10      
InvoiceNum pInvoiceNum 15      
Counter int 4 0    
Status tinyint 1 0 Prepare Check Status 0 = Released, 3 = Paid
Ten99InvoiceYN bit 1 0    
DistCode pDistCode 6      
InvoiceDate datetime 8      
DiscDueDate datetime 8      
NetDueDate datetime 8      
GrossAmtDueChk pDecimal 13 0    
GrossAmtDue pDecimal 13 0    
BaseGrossAmtDue pDecimal 13 0    
DiscAmt pDecimal 13 0    
GrossAmtDueFgn pDecimal 13 0    
DiscAmtFgn pDecimal 13 0    
CheckNum pCheckNum 10      
CheckDate datetime 8      
CurrencyId pCurrency 6      
ExchRate pDecimal 13 -1    
VendorHoldYN bit 1 0    
DiscLost pDecimal 13 0    
DiscTaken pDecimal 13 0    
DiscLostFgn pDecimal 13 0    
DiscTakenFgn pDecimal 13 0    
Ten99FormCode nvarchar 1      
DropFlagYN bit 1 0    
CheckAmt pDecimal 13 0    
CheckAmtFgn pDecimal 13 0    
BankID pBankID 10      
GLCashAcct pGlAcct 40      
GLDiscAcct pGlAcct 40      
GlPeriod smallint 2 0    
FiscalYear smallint 2 0    
TermsCode pTermsCode 6      
PmtCurrencyId pCurrency 6      
PmtExchRate pDecimal 13 -1    
CalcGainLoss pDecimal 13 0    
GLAccGainLoss pGlAcct 40      
Notes text 16      
GrpID int 4 0    
BatchID pBatchID 6 '######'    
PageFlag tinyint 1 0 Check Saver Flag 0 = On Stub, 1 = Separate Page
PrintCounter int 4 0    
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
ErrorLogMsg nvarchar 150      
CheckDate datetime 8      
BatchID pBatchID 6 '######'    
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PriorityCode nvarchar 1      
Desc nvarchar 25      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
RecurID nvarchar 10      
EntryNum int 4      
LineSeq int 4      
PartId pItemID 24      
PartType tinyint 1 0 Part Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item
Desc nvarchar 35      
JobId nvarchar 10      
PhaseId nvarchar 10      
CostType nvarchar 6      
GLAcct pGlAcct 40      
Qty pDecimal 13 0    
QtyBase pDecimal 13 0    
Units pUom 5      
UnitsBase pUom 5      
UnitCost pDecimal 13 0    
ExtCost pDecimal 13 0    
GLDesc pGLDesc 30      
AddnlDesc text 16      
TaxClass tinyint 1 0    
*LocId pLocID 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
RecurID nvarchar 10      
VendorID pVendorID 10      
InvoiceNum pInvoiceNum 15      
PONum nvarchar 25      
DistCode pDistCode 6      
TermsCode pTermsCode 6      
Subtotal pDecimal 13 0    
SalesTax pDecimal 13 0    
Freight pDecimal 13 0    
Misc pDecimal 13 0    
CurrencyId pCurrency 6      
-*ExchRate pDecimal 13 -1    
-*ExchRateDate datetime 8 getdate()    
-*UseCurrExchRate bit 1 0    
-*SubtotalFgn pDecimal 13 0    
-*SalesTaxFgn pDecimal 13 0    
-*FreightFgn pDecimal 13 0    
-*MiscFgn pDecimal 13 0    
RunCode nvarchar 6      
Ten99InvoiceYN bit 1 0    
StartingDate datetime 8 getdate()    
EndingDate datetime 8      
StartingBal pDecimal 13 0    
RemainingBal pDecimal 13 0    
NumOfPmt smallint 2 0    
RemainingPmt smallint 2 0    
Notes text 16      
TaxGrpID pTaxLoc 10      
TaxClassFreight tinyint 1 0    
TaxClassMisc tinyint 1 0    
TaxableYn bit 1 -1    
BillType tinyint 1 0 Billing Type 0 = As Needed, 1 = Days, 2 = Monthly, 3 = Quarterly, 4 = Yearly
BillInterval int 4 0 Billing Interval 0 = Not Set, Non-Zero = Number of Intervals (Days)
NextBillDate datetime 8      
LastBillDate datetime 8      
*RecurType tinyint 1     0 = Order, 1 = Return
*TaxAmtAdj pDecimal 13      
*TaxLocAdj pTaxLoc 10      
*TaxClassAdj tinyint 1      
CF xml -1      
ts timestamp 8      
*TaxGrpID2 pTaxLoc        
Column Name Column Type Length Default Value Description Enumeration
RecNo smallint 2      
RecType nvarchar 1      
RecPosition smallint 2      
RecLength smallint 2 0    
RecTitle nvarchar 50      
RecValue nvarchar 1000      
PayToName nvarchar 30      
Column Name Column Type Length Default Value Description Enumeration
AcctNo varchar 10      
Addr1 varchar 30      
Addr2 varchar 60      
Amount pDecimal 13      
City varchar 30      
Name varchar 30      
NameControl varchar 4      
PayToName varchar 30      
PostalCode varchar 10      
Region varchar 10      
SecondTINNotYN bit 1      
Ten99FieldIndicator varchar 1      
Ten99ForeignAddrYN bit 1      
Ten99FormCode varchar 1      
Ten99RecipientID varchar 16      
VendorID pVendorID 10      
Column Name Column Type Length Default Value Description Enumeration
IndicatorId nvarchar 1      
Desc nvarchar 30      
Limit pDecimal 13 0    
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
FormCode nvarchar 1      
Desc nvarchar 15      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CAddr1 varchar 40      
CAddr2 varchar 40      
CCity varchar 30      
CControlCode varchar 5      
CName varchar 40      
ContactEmail pEmail 255      
ContactExt varchar 5      
ContactName varchar 40      
ContactPhone varchar 15      
ControlCode varchar 5      
Counter int 4      
CPostalCode varchar 9      
CRegion varchar 2      
CTIN varchar 15      
FgnCorpYN bit 1      
NameControl varchar 4      
NumRecordsInput int 4      
NumRecordsOutput int 4      
OutputFile varchar 255      
PayerFgnCorpYN bit 1      
PaymentYear smallint 2      
PriorYear bit 1      
RAC varchar 2      
RunType smallint 2      
TAAddr1 varchar 40      
TAAddr2 varchar 40      
TACity varchar 30      
TAExt varchar 5      
TAName varchar 40      
TAPhone varchar 15      
TAPostalCode varchar 9      
TARegion varchar 2      
TinFed varchar 15      
TMAddr1 varchar 40      
TMAddr2 varchar 40      
TMCity varchar 30      
TMExt varchar 5      
TMName varchar 40      
TMPhone varchar 15      
TMPostalCode varchar 9      
TMRegion varchar 2      
TName varchar 40      
ts timestamp 8      
VAddress varchar 40      
VCity varchar 30      
VContactEmail pEmail 255      
VContactExt varchar 5      
VContactName varchar 40      
VContactPhone varchar 15      
VFgnCorpYN bit 1      
VIndicator char 1      
VName varchar 40      
VPostalCode varchar 9      
VState varchar 2      
EntryNum int        
LineSeq int 4      
Column Name Column Type Length Default Value Description Enumeration
TermsCode pTermsCode 6      
Desc nvarchar 15      
DiscPct pDecimal 13 0    
DiscDayOfMonth bit 1 0    
DiscDays smallint 2 0    
DiscMinDays smallint 2 0    
NetDueDays smallint 2 0    
NetDueDayOfMonth bit 1 0    
NetDueMinDays smallint 2 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
EntryNum int 4      
TransAllocId nvarchar 10      
Segments pGlAcct 40      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
EntryNum int 4      
Counter int 4      
AcctId pGlAcct 40      
Amount pDecimal 13 0    
AmountFgn pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransID pTransID 8      
EntryNum int 4      
LineSeq int 4      
PartId pItemID 24      
PartType tinyint 1 0 Part Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item
WhseId pLocID 10      
Desc nvarchar 35      
CostType nvarchar 6      
GLAcct pGlAcct 40      
Qty pDecimal 13 0    
QtyBase pDecimal 13 0    
Units pUom 5      
UnitsBase pUom 5      
UnitCost pDecimal 13 0    
UnitCostFgn pDecimal 13 0    
ExtCost pDecimal 13 0    
ExtCostFgn pDecimal 13 0    
GLDesc pGLDesc 30      
AddnlDesc text 16      
HistSeqNum int 4 0    
TaxClass tinyint 1 0    
BinNum nvarchar 10      
ConversionFactor pDecimal 13 -1    
LottedYN bit 1 0    
InItemYN bit 1 0    
GLAcctSales pGlAcct 40      
TransHistId nvarchar 10      
ExtInc pDecimal 13      
GLAcctWIP pGlAcct 40      
CustomerID pCustID 10      
JobId nvarchar 10      
ProjName nvarchar 30      
PhaseId nvarchar 10      
PhaseName nvarchar 30      
TaskId nvarchar 10      
TaskName nvarchar 30      
UnitInc pDecimal 13      
QtySeqNum int 4 0    
CF xml -1      
ts timestamp 8      
*ExtLocA int 4      
*ExtLocB int 4      
*QtySeqNum_Ext int 4      
*QtyStatus int 4      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
BatchId pBatchID 6 '######'    
WhseId pLocID 10      
VendorId pVendorID 10      
InvoiceNum pInvoiceNum 15      
InvoiceDate datetime 8 getdate()    
TransType smallint 2 -1 Transaction Type 1 = Invoice, -1 = Debit Memo
PONum nvarchar 25      
DistCode pDistCode 6      
TermsCode pTermsCode 6      
DueDate1 datetime 8      
DueDate2 datetime 8      
DueDate3 datetime 8      
PmtAmt1 pDecimal 13 0    
PmtAmt2 pDecimal 13 0    
PmtAmt3 pDecimal 13 0    
Subtotal pDecimal 13 0    
SalesTax pDecimal 13 0    
Freight pDecimal 13 0    
Misc pDecimal 13 0    
CashDisc pDecimal 13 0    
PrepaidAmt pDecimal 13 0    
CurrencyId pCurrency 6      
ExchRate pDecimal 13 -1    
PmtCurrencyId pCurrency 6      
PmtExchRate pDecimal 13 -1    
PmtAmt1Fgn pDecimal 13 0    
PmtAmt2Fgn pDecimal 13 0    
PmtAmt3Fgn pDecimal 13 0    
SubtotalFgn pDecimal 13 0    
SalesTaxFgn pDecimal 13 0    
FreightFgn pDecimal 13 0    
MiscFgn pDecimal 13 0    
CashDiscFgn pDecimal 13 0    
PrepaidAmtFgn pDecimal 13 0    
CheckNum pCheckNum 10      
CheckDate datetime 8      
PostDate datetime 8      
GLPeriod smallint 2 0    
FiscalYear smallint 2 0    
Ten99InvoiceYN bit 1      
Status tinyint 1 0 Transaction Status 0 = Released, 1 = Hold, 2 = Temporary Hold
Notes text 16      
TaxGrpID pTaxLoc 10      
TaxableYn bit 1 -1    
Taxable pDecimal 13 0    
NonTaxable pDecimal 13 0    
TaxableFgn pDecimal 13 0    
NonTaxableFgn pDecimal 13 0    
TaxClassFreight tinyint 1 0    
TaxClassMisc tinyint 1 0    
TaxLocID1 pTaxLoc 10      
TaxAmt1 pDecimal 13 0    
TaxAmt1Fgn pDecimal 13 0    
TaxLocID2 pTaxLoc 10      
TaxAmt2 pDecimal 13 0    
TaxAmt2Fgn pDecimal 13 0    
TaxLocID3 pTaxLoc 10      
TaxAmt3 pDecimal 13 0    
TaxAmt3Fgn pDecimal 13 0    
TaxLocID4 pTaxLoc 10      
TaxAmt4 pDecimal 13 0    
TaxAmt4Fgn pDecimal 13 0    
TaxLocID5 pTaxLoc 10      
TaxAmt5 pDecimal 13 0    
TaxAmt5Fgn pDecimal 13 0    
TaxAdjClass tinyint 1 0    
TaxAdjLocID pTaxLoc 10      
TaxAdjAmt pDecimal 13 0    
TaxAdjAmtFgn pDecimal 13 0    
BankID pBankID 10      
ChkGlPeriod smallint 2      
ChkFiscalYear smallint 2      
DiscDueDate datetime 8      
CF xml -1      
ts timestamp 8      
*TaxGrpID2 pTaxLoc        
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
TaxLocID pTaxLoc 10      
TaxClass tinyint 1 0    
Level tinyint 1 -1    
ExpAcct pGlAcct 40      
TaxAmt pDecimal 13 0    
Refundable pDecimal 13 0    
Taxable pDecimal 13 0    
NonTaxable pDecimal 13 0    
RefundAcct pGlAcct 40      
InvcNum pInvoiceNum 15      
TaxAmtFgn pDecimal 13 0    
TaxableFgn pDecimal 13 0    
NonTaxableFgn pDecimal 13 0    
RefundableFgn pDecimal 13 0    
CF xml -1      
ts timestamp 8      
TaxGroupType tinyint 1 0   0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2
LiabiltyAccount pGlAcct        
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
EntryNum int 4      
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
QtyOrder pDecimal 13 0    
QtyFilled pDecimal 13 0    
QtyBkord pDecimal 13 0    
CostUnit pDecimal 13 0    
CostUnitFgn pDecimal 13 0    
HistSeqNum int 4      
Cmnt nvarchar 35      
QtySeqNum int 4 0    
CF xml -1      
ts timestamp 8      
*ExtLocA int 4      
*ExtLocB int 4      
*QtySeqNum_Ext int 4      
*QtyStatus int 4      
Column Name Column Type Length Default Value Description Enumeration
ActivityId int 4      
EntryNum int 4      
Id int 4      
ProjectDetailId int 4      
TransId pTransID 8      
ts timestamp 8      
CF xml -1      
Type tinyint 1     1 = Material, 2 = Expense, 3 = Other
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
EntryNum int 4      
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
CostUnit pDecimal 13 0    
PriceUnit pDecimal 13 0    
CostUnitFgn pDecimal 13 0    
PriceUnitFgn pDecimal 13 0    
HistSeqNum int 4      
Cmnt nvarchar 35      
QtySeqNum int 4 0    
CF xml -1      
ts timestamp 8      
ExtLocA int 4      
ExtLocB int 4      
*CostUnitACV pDecimal 13 0    
Column Name Column Type Length Default Value Description Enumeration
VendorID pVendorID 10      
Name nvarchar 30      
Contact nvarchar 30      
Addr1 nvarchar 30      
Addr2 nvarchar 60      
City nvarchar 30      
Region nvarchar 10      
Country pCountry 6      
PostalCode nvarchar 10      
IntlPrefix nvarchar 6      
Phone nvarchar 15      
FAX nvarchar 15      
OurAcctNum nvarchar 25      
PayToName nvarchar 30      
PayToAttention nvarchar 30      
PayToAddr1 nvarchar 30      
PayToAddr2 nvarchar 60      
PayToCity nvarchar 30      
PayToRegion nvarchar 10      
PayToCountry pCountry 6      
PayToPostalCode nvarchar 10      
PayToIntlPrefix nvarchar 6      
PayToPhone nvarchar 15      
Ten99FormCode nvarchar 1      
Ten99RecipientID nvarchar 16      
Ten99FieldIndicator nvarchar 1      
Ten99ForeignAddrYN bit 1      
SecondTINNotYN bit 1      
GLAcct pGlAcct 40      
PriorityCode nvarchar 1      
VendorHoldYN bit 1 0    
TempYN bit 1 0    
VendorClass nvarchar 6      
TermsCode pTermsCode 6      
DivisionCode nvarchar 6      
DistCode pDistCode 6      
TaxableYN bit 1 -1    
Memo text 16      
CurrencyId pCurrency 6      
TaxGrpID pTaxLoc 10      
Email pEmail 255      
Internet pWeb 255      
LastPurchDate datetime 8      
LastPurchNum nvarchar 15      
LastPmtDate datetime 8      
LastCheckNum pCheckNum 10      
LastPurchAmt pDecimal 13 0    
LastPmtAmt pDecimal 13 0    
GrossDue pDecimal 13 0    
Prepaid pDecimal 13 0    
-*LastPurchAmtFgn pDecimal 13 0    
-*LastPmtAmtFgn pDecimal 13 0    
-*GrossDueFgn pDecimal 13 0    
-*PrepaidFgn pDecimal 13 0    
DfltTransAllocId nvarchar 10      
Status tinyint 1 0 Vendor Status 0 = Active, 1 = Inactive
DeliveryType tinyint 1 0 Check Delivery 0 = Paper, 1 = Electronic
BankAcctNum nnvarchar 510      
MaskValue nvarchar 4      
RoutingCode nvarchar 9      
DefaultPayBankId pBankID 10      
ChkOpt tinyint 1 0 Check Option 0 = Consolidated, 1 = Individual
CF xml -1      
ts timestamp 8      
*TaxPayerType1 bigint 8      
*TaxPayerType2 bigint 8      
*TaxID1 nvarchar 255      
*TaxID2 nvarchar 255      
*TaxGrpId2 pTaxLoc        
Column Name Column Type Length Default Value Description Enumeration
ClassID nvarchar 6      
Desc nvarchar 25      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
VendorID pVendorID 10      
FiscalYear smallint 2 0    
GLPeriod smallint 2 0    
Purch pDecimal 13 0    
Pmt pDecimal 13 0    
DiscTaken pDecimal 13 0    
DiscLost pDecimal 13 0    
Ten99Pmt pDecimal 13 0    
PurchFgn pDecimal 13 0    
PmtFgn pDecimal 13 0    
DiscTakenFgn pDecimal 13 0    
DiscLostFgn pDecimal 13 0    
Ten99PmtFgn pDecimal 13 0    
CF xml -1      
ts timestamp 8