Date Determination Logic CSV Format
Each Date Determination Logic CSV file contains one or more logic expressions.
For information about using CSV format files, see Best Practices for Importing Data with CSV Files.
Date Determination Logic File Format
|
SDITYPE=DateDeterminationLogic |
|||
|---|---|---|---|
|
Column Name |
Format |
Req? |
Description |
|
Name |
varchar2(100) |
Y |
A name for the logic expression. |
|
Description |
varchar2(2000) |
Y |
A description of the logic expression. |
|
DateExpression |
varchar2(2000) |
Y |
The actual date expression. |
Date Determination Logic File Example
This file includes a single date determination logic record.
-
sdiType=DateDeterminationLogic
-
Name,Description,DateExpression
-
Earlier of Invoice or Movement,Use Whichever is earlier: InvoiceD
ate or Movement Date,isNull(movementDate) ? invoiceDate : invoice
Date.before(movementDate) ? invoiceDate : movementDate
For more information about formatting a CSV file, see Creating CSV Import Files.
Updating an Existing Date Determination Logic Expression
You can update an existing date determination logic expression by including matching data in the Name column, then entering a new Description and/or Date Expression.
Date Determination Logic File Import Prerequisites
You must create the desired company into which you want to import the Date Determination Logic records before running the Import/Export Wizard.
Date Determination Logic File Import Options
When importing a Date Determination Logic file, the Import/Export Wizard prompts for Company Selection. Select the desired company.