| Customer_Invoice_Id |
No |
Key Id Field |
"123" |
|
| Customer_Id |
Yes |
Identifier |
"123" |
Must match an existing Customer id in the system |
| Customer_Name |
No, unless Customer_Id is not specified |
Lookup |
"Smith Family" |
Must match an existing Customer name in the system |
| Person_Id |
No, unless "Finance Require Student" is checked |
Identifier |
"123" |
Must match an existing person Id in the system. See Application Setup for more details on "Finance Require Student" checkbox |
| Person_First_Name |
No |
Lookup |
"John" |
Must match an existing person first name in the system |
| Person_Last_Name |
No |
Lookup |
"Doe" |
Must match an existing person last name in the system |
| Person_Birthdate |
No |
Lookup |
"2007/05/27" |
Must match an existing person birthdate in the system |
| Person_Type |
No |
Datasource Data |
"Student" |
Must match an existing person type in the system (e.g., Student, Inquiry) |
| Issued_Date |
Yes |
Date |
"2024/01/01" |
|
| Entered_Date |
Yes |
Date |
"2024/01/02" |
|
| Sent_Date |
No |
Date |
"2024/01/03" |
|
| Accounts_Receivable_Account_Id |
Yes |
Identifier |
"123" |
Must match an existing GL Account id in the system with type "accounts receivable" |
| Accounts_Receivable_Account_Number |
No, unless Accounts_Receivable_Account_Id is not specified |
Lookup |
"1-00-00-4165-127" |
Must match an existing GL Account number in the system with type "accounts receivable" |
| Customer_Memo |
No |
Text |
"Thank you for your business." |
|
| Internal_Memo |
No |
Text |
"Follow up on overdue payment." |
|
| Payment_Term_Id |
Yes |
Identifier |
"123" |
Must match an existing payment term id in the system |
| Payment_Term_Name |
No, unless Payment_Term_Id is not specified |
Lookup |
"10-pay" |
Must match an existing payment term name in the system |
| Invoice_Alternate_Id |
No |
Identifier |
"ALT123" |
|
| Posted_Date |
No |
Date |
"2024/01/05" |
|
| Voided_Date |
No |
Date |
"2024/01/06" |
|
| Void_Comment |
No |
Text |
"Duplicate entry" |
|
| Invoice_Classification_Id |
No, unless your school uses classifications |
Identifier |
"123" |
Must match an existing classification id in the system |
| Invoice_Classification_Name |
No, unless your school uses classifications and Invoice_Classification_Id is not specified |
Lookup |
"General Admin" |
Must match an existing classification name in the system |
| Attribute1_Id to Attribute10_Id |
No |
Identifier |
"123" |
Must match an existing Attribute id in the system |
| Attribute1_Name to Attribute10_Name |
No |
Lookup |
"Tuition Invoice" |
Must match an existing Attribute name in the system |
| Attribute1_Category to Attribute10_Category |
No |
Lookup |
"Finance" |
Must match an existing Attribute Category in the system |
| Attribute1_Comment to Attribute10_Comment |
No |
Text |
"Tuition for 25/26" |
|
| Item1_Product_Id to Item50_Product_Id |
No |
Identifier |
"123" |
Must match an existing Product id in the system |
| Item1_Product_Name to Item50_Product_Name |
No |
Lookup |
"Upper School Field Trip" |
Must match an existing Product name in the system |
| Iem1_Account_Id to Item50_Account_Id |
No |
Identifier |
"123" |
Must match an existing GL Account id in the system |
| Item1_Account_Number to Item50_Account_Number |
No |
Lookup |
"11-00-00-4257-127" |
Must match an existing GL Account number in the system |
| Item1_Overridden_Price to Item50_Overridden_Price |
No |
Decimal |
"950.00" |
|
| Item1_Quantity to Item50_Quantity |
No |
Integer |
"2" |
|
| Item1_Classification_Id to Item50_Classification_Id |
No, unless your school uses classifications |
Identifier |
"123" |
Must match an existing classification id in the system |
| Item1_Classification_Name to Item50_Classification_Name |
No, unless your school uses classifications and Item_Classification_Id is not specified |
Lookup |
"General Admin" |
Must match an existing classification name in the system |
| Item1_Note to Item50_Note |
No |
Text |
"Special order" |
|