Awesome. Thank you!
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On Behalf Of czarnecki.laura@...
Sent: Tuesday, September 17, 2013 12:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: How to You link the TransGLC and Part Tran
I agree. Thank you very much!!
--- In vantage@yahoogroups.com, <tchristie@...> wrote:
Wow! Just wow. That is a fantastically helpful table.
Thanks,
Tom Christie | Information Technology Manager | AGM Container Controls, Inc.<http://www.agmcontainer.com/> |
tchristie@...<mailto:tchristie@...> | t: 520.881.2130 ext 2176
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Miguel Santillan
Sent: Tuesday, September 17, 2013 8:20 AM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] RE: How to You link the TransGLC and Part Tran
RelatedToFile
Key1
Key2
Key3
Key4
Key5
Key6
APInvHed
VendorNum
InvoiceNum
Vendor
VendorNum
BankAcct
BankAcctID
Currency
CurrencyCode
Company
Company
APTran
HeadNum
APTranNo
InvoiceNum
Voided
SalesTRC
TaxCode
RateCode
APInvTax
VendorNum
InvoiceNum
TaxCode
RateCode
ECAcquisitionSeq
BankFee
BankFeeID
BankTran
BankAcctID
TranNum
Voided
CheckHed
HeadNum
ExtCompany
ExtSystemID
TransferMethod
ExtCompanyID
ApInvExp
VendorNum
invoiceNum
InvoiceLine
InvExpSeq
APInvMsc
VendorNum
invoiceNum
InvoiceLine
InvExpSeq
PurMisc
MiscCode
DMRActn
ActionType
DMRNum
ActionDate
ActionNum
Reason
ReasonType
ReasonCode
RebateHdr
RebateID
RebateDtl
RebateID
LineNum
ProdGrup
ProdCode
Part
PartNum
PartClass
ClassID
InvcDtl
InvoiceNum
InvoiceLine
ApInvDtl
VendorNum
InvoiceNum
InvoiceLine
RcvDtl
VendorNum
PurPoint
PackSlip
PackLine
PORel
PONUM
POLine
PORelNum
GLPurch
PurchCode
Warehse
WareHouseCode
Plant
Plant
Customer
CustNum
APInvJob
VendorNum
InvoiceNum
InvoiceLine
JobNum
AssemblySeq
MtlSeq
LogAPInv
VendorNum
InvoiceNum
LogApInvTax
VendorNum
InvoiceNum
TaxCode
RateCode
ECAcquisitionSeq
Void
APPNHead
GroupID
HeadNum
APPNDtl
GroupID
HeadNum
InvoiceNum
TaxDtl
SysRowID
InvcHead
InvoiceNum
CashDtl
GroupID
HeadNum
InvoiceNum
InvoiceRef
FinCharge
ChargeCode
OrderRel
OrderNum
OrderLine
OrderRelNum
OrderHed
OrderNum
ShipDtl
PackNum
PackLine
SalesCat
SalesCatID
FSContCd
ContractCode
FSCallCd
CallCode
InvcTax
InvoiceNum
InvoiceLine
TaxCode
RateCode
ECAcquisitionSeq
MiscChrg
MiscCode
InvcMisc
InvoiceNum
InvoiceLine
SeqNum
CashHead
GroupID
HeadNum
ARPNHead
GroupID
HeadNum
ARPNDtl
GroupID
HeadNum
InvoiceNum
Invoiceref = 0 then U else string Invoiceref
CashBHed
BankAcctID
FiscalYear
FiscalYearSuffix
Bankslip
FiscalCalendarID
PlntTranDef
FromPlant
ToPlant
JobHead
JobNum
FSCallDt
CallNum
CallLine
PartTran
SysDate
SysTime
TranNum
OrderDtl
OrderNum
OrderLine
RcvHead
VendorNum
PurPoint
.PackSlip
RMADisp
RMANum
RMALine
.RMAReceipt
RMADisp
PartLot
PartNum
LotNum
ContainerHeader
ContainerID
NonConf
TranID
LaborDtl
LaborHedSeq
LaborDtlSeq
JCDept
JCDept
FAGroup
GroupCode
FAsset
AssetNum
AssetSeq
FAClass
ClassCode
FAAddition
AssetNum
AdditionNum
FADisposal
AssetNum
DisposalNum
PREmpMas
EmpID
PRCheck
HeadNum
PRChkDed
HeadNum
DeductionID
DeductionNum
PRDeduct
DeductionID
PRClsDed
ClassID
DeductionID
PRChkTax
HeadNum
TaxTblID
PRTaxMas
TaxTblID
PRClsTax
ClassID
TaxTblID
PRChkDtl
HeadNum
LineNum
PayType
PayTypeID
PayTLbr
PayTypeID
ExpenseCode
PlantConfCtrl
Plant
JCShift
Shift
POHeader
PONum
PODetail
PONum
POLine
ResourceGroup
ResourceGrpID
GlJrnDtlMnl
GroupID
BookID
FiscalYear
JournalCode
JournalNum
JournalLine
GlJrnHed
GroupID
BookID
FiscalYear
JournalCode
JournalNum
DropShipDtl
VendorNum
PurPoint
PackSlip
PackLine
MFGVAR
SysDate
SysTime
TranNum
DebNote
DebitNoteID
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
czarnecki.laura@...
Sent: Tuesday, September 17, 2013 7:40 AM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] RE: How to You link the TransGLC and Part Tran
Hi. Can someone point me to the place where the Keys are defined in each table?
Thank you,
Laura Czarnecki
--- In
vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:
I need to try with Key 1 and Key 2.
Thanks.
________________________________
From: vantage@yahoogroups.com [vantage@yahoogroups.com] on behalf of
paul.morgan@... [paul.morgan@...]
Sent: Monday, September 16, 2013 4:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: How to You link the TransGLC and Part Tran
As Cathy has replied but I would also add company in the mix
PartTran.Company = TranGLC.Company
PartTran.SysDate = TranGLC.Key1
PartTran.SysTime = TranGLC.Key2
PartTran.TranNum = TranGLC.Key3
--- In vantage@yahoogroups.com, <msantillan@...> wrote:
TranGLC.Company = PartTran.Company
TranGLC.Key3 = PartTran.TranNum
for each TranGLC no-lock where TranGLC.RelatedToFile = 'PartTran' And TranGLC.TranDate >= 9/2/2013 And TranGLC.TranDate <= 9/5/2013 , each PartTran no-lock where (TranGLC.Company = PartTran.Company and TranGLC.Key3 = PartTran.TranNum ).
Any Help would be appreciated.
I am trying to get the PartTran transaction date of the corresponding TranGLC Transaction date.
[Non-text portions of this message have been removed]