...
| Record Type | RelatedRecordID format | Table Validated Against | |
|---|---|---|---|
| Action | ActionID | Actions | |
| APCredit | APInvoiceID | APInvoices | |
| APInvoice | APInvoiceID | APInvoices | |
| APVoucher | VoucherID | APVoucher | |
| ARCredit | InvoiceNumber | JobInvoices | |
| ARInvoice | InvoiceNumber | JobInvoices | |
| Asset | AssetID | Assets | |
| Batch | BatchNo | BatchHeaders | |
| CashFlow | JobCode.YearNo.PeriodNo | Forecasts | |
| Company | CompanyID | Companies | |
| Contract | ContractCode | Contracts | |
| Drawing | DocID | Documents | |
| Estimate | EstimateID | Estimates | |
| Forecast | JobCode.YearNo.PeriodNo | Forecasts | |
| ForecastGainAndLoss | WIPAdjustmentID | WIPAdjustments | |
| ForecastRiskAdjustment | ForecastRiskID | ForecastRisk | |
| ForecastSubcontractRisk | ForecastRiskID | ForecastRisk | |
| ForecastUncommittedAdjustment | ForecastRiskID | ForecastRisk | |
| ForecastWIPAdjustment | WIPAdjustmentID | WIPAdjustments | |
| Item | ItemID | Items | |
| Job | |||
| JobTransaction | |||
| Meeting | |||
| MeetingItem | |||
| Person | |||
| Plant | |||
| PlantPolicy | |||
| PlantServiceOrder | |||
| PriceRequest | |||
| Prospect | |||
| PurchaseOrder | PONumber | PurchaseOrders | |
| Quote | |||
| ReturnVoucher | |||
| ServiceAgreement | |||
| ServiceDesk | |||
| SubContract | |||
| SubContractorCetrtificationDetail | |||
| Timesheet | PersonID.TimesheetDate | Timesheets | |
| WorksOrder |
...
| PONumber | PurchaseOrders |
Timesheet's RelatedRecordID has a Timesheet component, these need to be treated in the following way:
Format: yyyym(m)d(d)
As file names cannot contain slashes these have been removed. The year component is always 4 digits. The Month and Day component are variable length (One or two characters) as leading zeros are removed.
So a file being attached to PersonID 1234 for Week Ending 13/07/2012 would have a RelatedRecordID portion of the file name as:
1234.2012713
Rejected Files
Rejected files are files that could not be automatically attached for some reason.
...
The Config.ini is a TAB delimited file. However Commas cannot be used in this file, substituted for a pipe ( | ) character if required.
A resonable level reasonable knowledge of SQL is required to configure the Config.ini file correctly.
...