Pages

Friday, January 31, 2014

GL_import_refference table links

For Invoices transactions: 
--------------------------
REFERENCE_1 = Vendor Name 
REFERENCE_2 = Invoice id 
REFERENCE_3 = Distribution Line Number 
REFERENCE_4 = blank 
REFERENCE_5 = Invoice Number 
REFERENCE_6 = AP Invoices 
REFERENCE_7 = set of books id 
REFERENCE_8 = blank 
REFERENCE_9 = blank 
REFERENCE_10 = For Expense lines, this is blank (For
Liabilities, "Liability") 


For Payments transactions: 
-------------------------- 
REFERENCE_1 = Vendor Name 
REFERENCE_2 = Invoice id 
REFERENCE_3 = Check id 
REFERENCE_4 = Check number 
REFERENCE_5 = Invoice Number 
REFERENCE_6 = AP Payments
REFERENCE_7 = Set of books id 
REFERENCE_8 = Invoice Distribution Line Number 
REFERENCE_9 = Invoice payment id 
REFERENCE_10 = Liability 

No comments:

Post a Comment