Purchase Order 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
ForecastType nvarchar 10      
Descr nvarchar 35      
AdjFactor pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ForecastType nvarchar 10      
Period smallint 2 0    
WeightFactor pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransID pTransID 8      
QtyOrd pDecimal 13      
UnitCost pDecimal 13      
UnitCostFgn pDecimal 13      
ExtCost pDecimal 13      
ExtCostFgn pDecimal 13      
ItemId pItemID 24      
ItemType tinyint 1   Item Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item
LocId pLocID 10      
Descr nvarchar 35      
UnitsBase pUom 5      
Units pUom 5      
LineStatus tinyint 1   Line Status 0 = Open, 1 = Completed
GLDesc pGLDesc 30      
AddnlDescr text 16      
TaxClass tinyint 1      
BinNum nvarchar 10      
ConversionFactor pDecimal 13      
LottedYN bit 1      
InItemYN bit 1      
ReqShipDate datetime 8      
GLAcct pGlAcct 40      
GLAcctSales pGlAcct 40      
GLAcctWIP pGlAcct 40      
TransHistID nvarchar 10      
CustID pCustID 10      
ProjID 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      
QtySeqNum int 4      
SourceType smallint 2      
LineNum int 4      
LinkTransId pTransID 8      
Seq int 4      
ReleaseNum nvarchar 3      
ReqId nvarchar 4      
LandedCostID nvarchar 10      
LineSeq int 4      
TransHistIDLandedCost nvarchar 10      
LinkSeqNum int 4      
CF xml -1      
Type tinyint 1   Type 1 = Material, 2 = Expense, 3 = Other
ProjectDetailId int 4      
ActivityId int 4      
GLAcctAccrual pGlAcct 40      
EntryNum int 4      
ExpReceiptDate datetime 8      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
LCTransSeqNum int 4      
TransID pTransID 8      
EntryNum int 4      
Description nvarchar 35      
CostType tinyint 1   Cost Type 0 = Percent of Cost, 1 = Fixed Amount, 2 = Weight, 3 = Quantity
Amount pDecimal 13      
Level tinyint 1      
CalcAmount pDecimal 13      
LCDtlSeqNum int 4      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransId pTransID 8      
BatchId pBatchID 6      
TransType smallint 2   Transaction Type 1 = Goods Received, 2 = Invoice Received, 9 = New Order, -1 = New Return, -2 = Debit Memo
LocId pLocID 10      
VendorId pVendorID 10      
Notes text 16      
DistCode pDistCode 6      
TermsCode pTermsCode 6      
TransDate datetime 8      
TaxGrpID pTaxLoc 10      
TaxableYn bit 1      
PrintStatus tinyint 1   Purchase Order Print Status 0 = Unprinted, 1 = Online, 2 = Batch
PrintDate datetime 8      
ReqShipDate datetime 8      
OrderedBy pUserID 20      
ReceivedBy pUserID 20      
FOB nvarchar 35      
CurrencyID pCurrency 6      
ExchRate pDecimal 13      
ShipToID pCustID 10      
ShipToAttn nvarchar 30      
ShipToName nvarchar 30      
ShipToAddr1 nvarchar 30      
ShipToAddr2 nvarchar 60      
ShipToCity nvarchar 30      
ShipToRegion nvarchar 10      
ShipToCountry pCountry 6      
ShipToPostalCode nvarchar 10      
ShipVia nvarchar 20      
MemoTaxable pDecimal 13      
MemoNonTaxable pDecimal 13      
MemoSalesTax pDecimal 13      
MemoFreight pDecimal 13      
MemoMisc pDecimal 13      
MemoDisc pDecimal 13      
MemoPrepaid pDecimal 13      
CheckDate datetime 8      
MemoTaxableFgn pDecimal 13      
MemoNonTaxableFgn pDecimal 13      
MemoSalesTaxFgn pDecimal 13      
MemoFreightFgn pDecimal 13      
MemoMiscFgn pDecimal 13      
MemoDiscFgn pDecimal 13      
MemoPrepaidFgn pDecimal 13      
MemoCheckNo pCheckNum 10      
MemoDueDate1 datetime 8      
MemoDueDate2 datetime 8      
MemoDueDate3 datetime 8      
MemoPmtAmt1 pDecimal 13      
MemoPmtAmt2 pDecimal 13      
MemoPmtAmt3 pDecimal 13      
MemoPmtAmt1Fgn pDecimal 13      
MemoPmtAmt2Fgn pDecimal 13      
MemoPmtAmt3Fgn pDecimal 13      
MemoTaxClassFreight tinyint 1      
MemoTaxClassMisc tinyint 1      
MemoTaxLocID1 pTaxLoc 10      
MemoTaxAmt1 pDecimal 13      
MemoTaxAmt1Fgn pDecimal 13      
MemoTaxLocID2 pTaxLoc 10      
MemoTaxAmt2 pDecimal 13      
MemoTaxAmt2Fgn pDecimal 13      
MemoTaxLocID3 pTaxLoc 10      
MemoTaxAmt3 pDecimal 13      
MemoTaxAmt3Fgn pDecimal 13      
MemoTaxLocID4 pTaxLoc 10      
MemoTaxAmt4 pDecimal 13      
MemoTaxAmt4Fgn pDecimal 13      
MemoTaxLocID5 pTaxLoc 10      
MemoTaxAmt5 pDecimal 13      
MemoTaxAmt5Fgn pDecimal 13      
HdrRef int 4      
DropShipYn bit 1 0    
CF xml -1      
GroupId pTransID 8      
RequestedDate datetime 8      
RequestedBy pUserID 20      
ApprovedDate datetime 8      
ApprovedBy pUserID 20      
RequestStatus tinyint 1     0 = Approved, 1 = Declined
ExpReceiptDate datetime 8      
*TaxGrpId2 pTaxLoc        
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
ReceiptID uniqueidentifier 16 newid()    
InvoiceID uniqueidentifier 16 newid()    
Qty pDecimal 13      
QtySeqNum int 4      
HistSeqNum int 4      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
EntryNum int 4      
PostRun pPostRun 14      
TransID pTransID 8      
InvoiceNum pInvoiceNum 15      
Status tinyint 1   Status 0 = Current, 1 = Posted
Qty pDecimal 13      
UnitCost pDecimal 13      
UnitCostFgn pDecimal 13      
ExtCost pDecimal 13      
ExtCostFgn pDecimal 13      
HistSeqNum int 4      
AvgRcptCost pDecimal 13      
TransHistID nvarchar 10      
QtySeqNum int 4      
InvoiceID uniqueidentifier 16 newid()    
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransId pTransID 8      
InvcNum pInvoiceNum 15      
TaxLocID pTaxLoc 10      
TaxClass tinyint 1      
ExpAcct pGlAcct 40      
CurrTaxAmt pDecimal 13      
CurrRefundable pDecimal 13      
CurrTaxable pDecimal 13      
CurrNonTaxable pDecimal 13      
RefundAcct pGlAcct 40      
CurrTaxAmtFgn pDecimal 13      
CurrRefundableFgn pDecimal 13      
CurrTaxableFgn pDecimal 13      
CurrNonTaxableFgn pDecimal 13      
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
PostRun pPostRun 14      
TransId pTransID 8      
InvcNum pInvoiceNum 15      
Status tinyint 1   Invoice Status 0 = Current, 1 = Posted
InvcDate datetime 8      
GLPeriod smallint 2      
FiscalYear smallint 2      
Ten99InvoiceYN bit 1      
CurrTaxable pDecimal 13      
CurrNonTaxable pDecimal 13      
CurrSalesTax pDecimal 13      
CurrFreight pDecimal 13      
CurrMisc pDecimal 13      
CurrDisc pDecimal 13      
CurrPrepaid pDecimal 13      
CurrTaxableFgn pDecimal 13      
CurrNonTaxableFgn pDecimal 13      
CurrSalesTaxFgn pDecimal 13      
CurrFreightFgn pDecimal 13      
CurrMiscFgn pDecimal 13      
CurrDiscFgn pDecimal 13      
CurrPrepaidFgn pDecimal 13      
PostTaxable pDecimal 13      
PostNonTaxable pDecimal 13      
PostSalesTax pDecimal 13      
PostFreight pDecimal 13      
PostMisc pDecimal 13      
PostDisc pDecimal 13      
PostPrepaid pDecimal 13      
PostTaxableFgn pDecimal 13      
PostNonTaxableFgn pDecimal 13      
PostSalesTaxFgn pDecimal 13      
PostFreightFgn pDecimal 13      
PostMiscFgn pDecimal 13      
PostDiscFgn pDecimal 13      
PostPrepaidFgn pDecimal 13      
CurrCheckNo pCheckNum 10      
CurrCheckDate datetime 8      
CurrBankID pBankID 10      
CurrChkGlPeriod smallint 2      
CurrChkFiscalYear smallint 2      
CurrDueDate1 datetime 8      
CurrDueDate2 datetime 8      
CurrDueDate3 datetime 8      
CurrPmtAmt1 pDecimal 13      
CurrPmtAmt2 pDecimal 13      
CurrPmtAmt3 pDecimal 13      
CurrPmtAmt1Fgn pDecimal 13      
CurrPmtAmt2Fgn pDecimal 13      
CurrPmtAmt3Fgn pDecimal 13      
CurrTaxClassFreight tinyint 1      
CurrTaxClassMisc tinyint 1      
CurrTaxAdjClass tinyint 1      
CurrTaxAdjLocID pTaxLoc 10      
CurrTaxAdjAmt pDecimal 13      
CurrTaxAdjAmtFgn pDecimal 13      
InvoiceExchRate pDecimal 13      
PmtCurrencyId pCurrency 6      
PmtExchRate pDecimal 13      
-*GainLoss pDecimal 13      
DiscDueDate datetime 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransId pTransID 8      
RcptNum pInvoiceNum 15      
LotNum pLotNum 16      
QtyOrder pDecimal 13      
QtyFilled pDecimal 13      
UnitCost pDecimal 13      
UnitCostFgn pDecimal 13      
ExtCost pDecimal 13      
ExtCostFgn pDecimal 13      
HistSeqNum int 4      
LotCmnt nvarchar 35      
Status tinyint 1   Receipt Status 0 = Current, 1 = Posted
QtySeqNum int 4      
CF xml -1      
AccAdjCost pDecimal 13      
AccAdjCostFgn pDecimal 13      
ActivityId int 4      
EntryNum int 4      
ExtLocAID varchar 10      
ExtLocBID varchar 10      
QtyAccRev pDecimal 13      
QtySeqNum_Ext int 4      
ReceiptID uniqueidentifier 16 newid()    
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransID pTransID 8      
ReceiptNum pInvoiceNum 15      
ReceiptDate datetime 8      
GlPeriod smallint 2      
FiscalYear smallint 2      
ExchRate pDecimal 13 -1    
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
ReceiptID uniqueidentifier 16 newid()    
LCTransSeqNum int 4      
Amount pDecimal 13      
PostedAmount pDecimal 13      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransId pTransID 8      
EntryNum int 4      
RcptNum pInvoiceNum 15      
LotNum pLotNum 16      
SerNum pSerNum 35      
InvcNum pInvoiceNum 15      
SerCmnt nvarchar 35      
RcptUnitCost pDecimal 13      
*RcptCostUnitACV pDecimal 13      
RcptUnitCostFgn pDecimal 13      
RcptStatus tinyint 1   Receipt Status 0 = Current, 1 = Posted
InvcUnitCost pDecimal 13      
*InvcCostUnitACV pDecimal 13      
InvcUnitCostFgn pDecimal 13      
InvcStatus tinyint 1   Invoice Status 0 = Current, 1 = Posted
SerHistSeqNum int 4      
ExchRateSRec pDecimal 13      
ExchRateSInv pDecimal 13      
CF xml -1      
ExtLocAID nvarchar 10      
ExtLocBID nvarchar 10      
Column Name Column Type Length Default Value Description Enumeration
ItemId pItemID 24      
LocId pLocID 10      
UomDflt pUom 5      
QtyOnHand pDecimal 13 0    
QtyOnOrder pDecimal 13 0    
SafetyStock pDecimal 13 0    
UsageForecast pDecimal 13 0    
UsageAnnual pDecimal 13 0    
OrderPointEoq pDecimal 13 0    
OrderPointFrcst pDecimal 13 0    
OrderPointMinMax pDecimal 13 0    
OrderQtyEoq pDecimal 13 0    
OrderQtyFrcst pDecimal 13 0    
OrderQtyMinMax pDecimal 13 0    
NotesEoq nvarchar 2      
NotesFrcst nvarchar 2      
NotesMinMax nvarchar 2      
FrozenEoq bit 1 0    
FrozenFrcst bit 1 0    
FrozenQtyYN bit 1 0    
AutoReorderYN bit 1 0    
GlInvAcct pGlAcct 40      
AboveEoqOrdPt bit 1 0    
AboveFrcstOrdPt bit 1 0    
AboveMinMaxOrdPt bit 1 0    
AboveAllOrdPt bit 1 0    
MinOrderQty pDecimal 13 0    
MaxOrderQty pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
LandedCostID nvarchar 10      
LCDtlSeqNum int 4      
Description nvarchar 35      
CostType tinyint 1   Cost Type 0 = Percent of Cost, 1 = Fixed Amount, 2 = Weight, 3 = Quantity
Amount pDecimal 13 0    
Level tinyint 1      
GlAcctExpense pGlAcct 40      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
LandedCostID nvarchar 10      
Description nvarchar 35      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ReqId int 4      
VendorId pVendorID 10      
ItemId pItemID 24      
ItemType tinyint 1 0 Item Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item
LocId pLocID 10      
Descr nvarchar 35      
Qty pDecimal 13 0    
UnitCost pDecimal 13 0    
ExtCost pDecimal 13 0    
Uom pUom 5      
InitDate datetime 8      
EnteredBy pUserID 20      
SourceApp nvarchar 2      
RefId nvarchar 15      
GenerateYn bit 1 0    
GlAcct pGlAcct 40      
ReqShipDate datetime 8      
AddnlDescr text 16      
DropShipYn bit 1 0    
SourceType smallint 2   Source Type 0 = NA, 1 = PO Requisition, 2 = PO Transaction, 70 = JC, 71 = SO, 72 = SD, 73 = MP Material, 74 = MP Subcontract
LineNum int 4      
LinkTransId pTransID 8      
Seq int 4      
ReleaseNum nvarchar 3      
OrderReqId nvarchar 4      
LinkSeqNum int 4      
CustId pCustID 10      
ProjId nvarchar 10      
PhaseId nvarchar 10      
TaskId nvarchar 10      
CF xml -1      
ts timestamp 8      
*CurrencyID pCurrency 6      
ExpReceiptDate datetime 8      
Column Name Column Type Length Default Value Description Enumeration
ShiptoId pCustID 10      
ShiptoName 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      
Attn nvarchar 30      
ShipVia nvarchar 20      
TaxLocID pTaxLoc 10      
DistCode pDistCode 6      
Email pEmail 255      
Internet pWeb 255      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransID pTransID 8      
EntryNum int 4      
QtyOrd pDecimal 13 0    
UnitCost pDecimal 13 0    
UnitCostFgn pDecimal 13 0    
ExtCost pDecimal 13 0    
ExtCostFgn pDecimal 13 0    
ItemId pItemID 24      
ItemType tinyint 1 0 Item Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item
LocId pLocID 10      
Descr nvarchar 35      
UnitsBase pUom 5      
Units pUom 5      
LineStatus tinyint 1 0 Line Status 0 = Open, 1 = Completed
GLDesc pGLDesc 30      
AddnlDescr text 16      
TaxClass tinyint 1 0    
BinNum nvarchar 10      
ConversionFactor pDecimal 13 -1    
LottedYN bit 1 0    
InItemYN bit 1 -1    
ReqShipDate datetime 8 getdate()    
GLAcct pGlAcct 40      
GLAcctSales pGlAcct 40      
GLAcctWIP pGlAcct 40      
TransHistID nvarchar 10      
CustID pCustID 10      
ProjID nvarchar 10      
ProjName nvarchar 30      
PhaseId nvarchar 10      
PhaseName nvarchar 30      
TaskID nvarchar 10      
TaskName nvarchar 30      
UnitInc pDecimal 13 0    
ExtInc pDecimal 13 0    
ProjItemYn bit 1 0    
QtySeqNum int 4 0    
SourceType smallint 2   Source Type 0 = NA, 1 = PO Requisition, 2 = PO Transaction, 70 = JC, 71 = SO, 72 = SD, 73 = MP Material, 74 = MP Subcontract
LineNum int 4      
LinkTransId pTransID 8      
Seq int 4      
ReleaseNum nvarchar 3      
ReqId nvarchar 4      
LinkSeqNum int 4      
LandedCostID nvarchar 10      
LineSeq int 4      
TransHistIDLandedCost nvarchar 10      
CF xml -1      
ts timestamp 8      
Type tinyint 1   Type 1 = Material, 2 = Expense, 3 = Other
ProjectDetailId int 4      
ActivityId int 4      
GLAcctAccrual pGlAcct 40      
EntryNum int 4      
*QtySeqNum_Ext int 4 0    
*ExtLocA int        
Column Name Column Type Length Default Value Description Enumeration
LCTransSeqNum int 4      
TransID pTransID 8      
EntryNum int 4      
Description nvarchar 35      
CostType tinyint 1   Cost Type 0 = Percent of Cost, 1 = Fixed Amount, 2 = Weight, 3 = Quantity
Amount pDecimal 13 0    
Level tinyint 1      
CalcAmount pDecimal 13 0    
LCDtlSeqNum int 4      
CF xml -1      
ExpReceiptDate datetime 8      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8 z    
BatchId pBatchID 6 '######'    
TransType smallint 2 9 Transaction Type 0 = Request,1 = Goods Received, 2 = Invoice Received, 9 = New Order, -1 = New Return, -2 = Debit Memo
LocId pLocID 10      
VendorId pVendorID 10      
Notes text 16      
DistCode pDistCode 6      
TermsCode pTermsCode 6      
TransDate datetime 8 getdate()    
TaxGrpID pTaxLoc 10      
TaxableYn bit 1 -1    
PrintStatus tinyint 1 0 Purchase Order Print Status 0 = Unprinted, 1 = Online, 2 = Batch
PrintDate datetime 8      
ReqShipDate datetime 8 getdate()    
OrderedBy pUserID 20      
ReceivedBy pUserID 20      
FOB nvarchar 35      
CurrencyID pCurrency 6      
ExchRate pDecimal 13 -1    
ShipToID pCustID 10      
ShipToAttn nvarchar 30      
ShipToName nvarchar 30      
ShipToAddr1 nvarchar 30      
ShipToAddr2 nvarchar 60      
ShipToCity nvarchar 30      
ShipToRegion nvarchar 10      
ShipToCountry pCountry 6      
ShipToPostalCode nvarchar 10      
ShipVia nvarchar 20      
MemoTaxable pDecimal 13 0    
MemoNonTaxable pDecimal 13 0    
MemoSalesTax pDecimal 13 0    
MemoFreight pDecimal 13 0    
MemoMisc pDecimal 13 0    
MemoDisc pDecimal 13 0    
MemoPrepaid pDecimal 13 0    
CheckDate datetime 8      
MemoTaxableFgn pDecimal 13 0    
MemoNonTaxableFgn pDecimal 13 0    
MemoSalesTaxFgn pDecimal 13 0    
MemoFreightFgn pDecimal 13 0    
MemoMiscFgn pDecimal 13 0    
MemoDiscFgn pDecimal 13 0    
MemoPrepaidFgn pDecimal 13 0    
MemoCheckNo pCheckNum 10      
MemoDueDate1 datetime 8      
MemoDueDate2 datetime 8      
MemoDueDate3 datetime 8      
MemoPmtAmt1 pDecimal 13 0    
MemoPmtAmt2 pDecimal 13 0    
MemoPmtAmt3 pDecimal 13 0    
MemoPmtAmt1Fgn pDecimal 13 0    
MemoPmtAmt2Fgn pDecimal 13 0    
MemoPmtAmt3Fgn pDecimal 13 0    
MemoTaxClassFreight tinyint 1 0    
MemoTaxClassMisc tinyint 1 0    
MemoTaxLocID1 pTaxLoc 10      
MemoTaxAmt1 pDecimal 13 0    
MemoTaxAmt1Fgn pDecimal 13 0    
MemoTaxLocID2 pTaxLoc 10      
MemoTaxAmt2 pDecimal 13 0    
MemoTaxAmt2Fgn pDecimal 13 0    
MemoTaxLocID3 pTaxLoc 10      
MemoTaxAmt3 pDecimal 13 0    
MemoTaxAmt3Fgn pDecimal 13 0    
MemoTaxLocID4 pTaxLoc 10      
MemoTaxAmt4 pDecimal 13 0    
MemoTaxAmt4Fgn pDecimal 13 0    
MemoTaxLocID5 pTaxLoc 10      
MemoTaxAmt5 pDecimal 13 0    
MemoTaxAmt5Fgn pDecimal 13 0    
DropShipYn bit 1 0    
HdrRef int 4      
CF xml -1      
*TaxGrpId2 pTaxLoc        
Column Name Column Type Length Default Value Description Enumeration
Qty pDecimal 13 0    
QtySeqNum int 4 0    
HistSeqNum int 4 0    
ReceiptID uniqueidentifier 16 newid()    
InvoiceID uniqueidentifier 16 newid()    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransID pTransID 8      
EntryNum int 4 0    
InvoiceNum pInvoiceNum 15      
Status tinyint 1 0 Invoice Status 0 = Current, 1 = Posted
Qty pDecimal 13 0    
UnitCost pDecimal 13 0    
UnitCostFgn pDecimal 13 0    
ExtCost pDecimal 13 0    
ExtCostFgn pDecimal 13 0    
HistSeqNum int 4 0    
AvgRcptCost pDecimal 13 0    
TransHistID nvarchar 10      
QtySeqNum int 4 0    
InvoiceID uniqueidentifier 16 newid()    
CF xml -1      
ts timestamp 8      
*InvcHeaderID bigint 8      
ExpReceiptDate datetime 8      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
InvcNum pInvoiceNum 15      
TaxLocID pTaxLoc 10      
TaxClass tinyint 1 0    
ExpAcct pGlAcct 40      
CurrTaxAmt pDecimal 13 0    
CurrRefundable pDecimal 13 0    
CurrTaxable pDecimal 13 0    
CurrNonTaxable pDecimal 13 0    
RefundAcct pGlAcct 40      
CurrTaxAmtFgn pDecimal 13 0    
CurrRefundableFgn pDecimal 13 0    
CurrTaxableFgn pDecimal 13 0    
CurrNonTaxableFgn pDecimal 13 0    
CF xml -1      
ts timestamp 8      
TaxGroupType tinyint 1 0   0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2
LiabilityAccount pGlAcct        
Column Name Column Type Length Default Value Description Enumeration
*ID bigint 8      
TransId pTransID 8      
InvcNum pInvoiceNum 15      
Status tinyint 1 0 Invoice Status 0 = Current, 1 = Posted
InvcDate datetime 8 getdate()    
GLPeriod smallint 2 0    
FiscalYear smallint 2 0    
Ten99InvoiceYN bit 1 0    
CurrTaxable pDecimal 13 0    
CurrNonTaxable pDecimal 13 0    
CurrSalesTax pDecimal 13 0    
CurrFreight pDecimal 13 0    
CurrMisc pDecimal 13 0    
CurrDisc pDecimal 13 0    
CurrPrepaid pDecimal 13 0    
CurrTaxableFgn pDecimal 13 0    
CurrNonTaxableFgn pDecimal 13 0    
CurrSalesTaxFgn pDecimal 13 0    
CurrFreightFgn pDecimal 13 0    
CurrMiscFgn pDecimal 13 0    
CurrDiscFgn pDecimal 13 0    
CurrPrepaidFgn pDecimal 13 0    
PostTaxable pDecimal 13 0    
PostNonTaxable pDecimal 13 0    
PostSalesTax pDecimal 13 0    
PostFreight pDecimal 13 0    
PostMisc pDecimal 13 0    
PostDisc pDecimal 13 0    
PostPrepaid pDecimal 13 0    
PostTaxableFgn pDecimal 13 0    
PostNonTaxableFgn pDecimal 13 0    
PostSalesTaxFgn pDecimal 13 0    
PostFreightFgn pDecimal 13 0    
PostMiscFgn pDecimal 13 0    
PostDiscFgn pDecimal 13 0    
PostPrepaidFgn pDecimal 13 0    
CurrCheckNo pCheckNum 10      
CurrCheckDate datetime 8      
CurrBankID pBankID 10      
CurrChkGlPeriod smallint 2      
CurrChkFiscalYear smallint 2      
CurrDueDate1 datetime 8      
CurrDueDate2 datetime 8      
CurrDueDate3 datetime 8      
CurrPmtAmt1 pDecimal 13 0    
CurrPmtAmt2 pDecimal 13 0    
CurrPmtAmt3 pDecimal 13 0    
CurrPmtAmt1Fgn pDecimal 13 0    
CurrPmtAmt2Fgn pDecimal 13 0    
CurrPmtAmt3Fgn pDecimal 13 0    
CurrTaxClassFreight tinyint 1 0    
CurrTaxClassMisc tinyint 1 0    
CurrTaxAdjClass tinyint 1 0    
CurrTaxAdjLocID pTaxLoc 10      
CurrTaxAdjAmt pDecimal 13 0    
CurrTaxAdjAmtFgn pDecimal 13 0    
InvoiceExchRate pDecimal 13 -1    
PmtCurrencyId pCurrency 6      
PmtExchRate pDecimal 13 -1    
-*GainLoss pDecimal 13 0    
DiscDueDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ActivityId int 4      
*ID bigint 8      
*RcptHeaderId bigint 8      
TransId pTransID 8      
EntryNum int 4 0    
RcptNum pInvoiceNum 15      
LotNum pLotNum 16      
QtyOrder pDecimal 13 0    
QtyFilled pDecimal 13 0    
UnitCost pDecimal 13 0    
UnitCostFgn pDecimal 13 0    
ExtCost pDecimal 13 0    
ExtCostFgn pDecimal 13 0    
HistSeqNum int 4 0    
LotCmnt nvarchar 35      
Status tinyint 1 0 Receipt Status 0 = Current, 1 = Posted
QtySeqNum int 4 0    
ReceiptID uniqueidentifier 16 newid()    
QtyAccRev pDecimal 13 0    
AccAdjCostFgn pDecimal 13 0    
AccAdjCost pDecimal 13 0    
CF xml -1      
ts timestamp 8      
ExtLocA int 4      
ExtLocB int 4      
QtySeqNum_Ext int 4 0    
Column Name Column Type Length Default Value Description Enumeration
TransID pTransID 8      
ReceiptNum pInvoiceNum 15      
ReceiptDate datetime 8 getdate()    
GlPeriod smallint 2 0    
FiscalYear smallint 2 0    
ExchRate pDecimal 13 -1    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ReceiptID uniqueidentifier 16 newid()    
LCTransSeqNum int 4      
Amount pDecimal 13 0    
PostedAmount pDecimal 13 0    
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
GroupId pTransID 8      
RequestedDate datetime 8      
RequestedBy pUserID 8      
ApprovedDate datetime 8      
ApprovedBy pUserID 8      
Status tinyint 1   Status 0 = New, 1 = Pending, 2 = Approved, 3 = Declined
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
EntryNum int 4 0    
RcptNum pInvoiceNum 15      
LotNum pLotNum 16      
SerNum pSerNum 35      
InvcNum pInvoiceNum 15      
SerCmnt nvarchar 35      
RcptUnitCost pDecimal 13 0    
RcptUnitCostFgn pDecimal 13 0    
RcptStatus tinyint 1 0 Receipt Status 0 = Current, 1 = Posted
InvcUnitCost pDecimal 13 0    
InvcUnitCostFgn pDecimal 13 0    
InvcStatus tinyint 1 0 Invoice Status 0 = Current, 1 = Posted
SerHistSeqNum int 4 0    
ExchRateSRec pDecimal 13 -1    
ExchRateSInv pDecimal 13 -1    
CF xml -1      
ts timestamp 8 z    
ExtLocA int 4 z    
ExtLocB int 4      
*RcptCostUnitACV pDecimal 13      
*InvcCostUnitACV pDecimal 13