The format of imported factor order approval data is based on the approval import program entered for the payment terms of the factor in Payment Terms Maintenance.
The following factors are supported for importing order approval information in Factor Order Approval Import:
CIT
TCF Inventory Finance
Wells Fargo
The following tables display the file format for importing CIT order approval information:
Field Number |
Field Name |
Start Position |
End Position |
Length |
DataType |
Notes |
1 |
Format Type |
1 |
2 |
2 |
A/N |
This is the following value: CF |
2 |
Group Client Number |
3 |
6 |
4 |
N |
This is the master client number. |
3 |
Client Number |
7 |
10 |
4 |
N |
This is the client number of the confirmation. |
4 |
Julian Date |
11 |
13 |
3 |
N |
|
5 |
Hour of Extraction |
14 |
15 |
2 |
N |
|
6 |
Record Type |
16 |
17 |
2 |
N |
This is the following value: 10 |
7 |
CIT Customer Number |
18 |
24 |
7 |
N |
|
8 |
Client Customer Number |
25 |
39 |
15 |
A/N |
|
9 |
Customer Name |
40 |
69 |
30 |
A/N |
|
10 |
Client Order Number |
70 |
91 |
22 |
A/N |
This is the truncated Apprise order number (for example, nj.123). This is validated against the order in Apprise. |
11 |
CIT Reference Number |
92 |
101 |
10 |
A/N |
This left-justified reference number is reported in the import log file and stored on the order (cc-approval-code). |
12 |
Order Amount |
102 |
109 |
8 |
N |
This is the original order amount. |
13 |
Approved Amount |
110 |
117 |
8 |
N |
This is the amount actually approved. This data is stored in credit task user-defined field 7. |
14 |
Action Code |
118 |
119 |
2 |
A/N |
If this is AA or AC, the order is released from finance hold and listed on the log file as approved. If the action code is anything else, the order is left on finance hold and the import log summary values are updated as follows:
This data is stored in credit task user-defined field 1. |
15 |
Reason Code 1 |
120 |
121 |
2 |
A/N |
This is reported in the import log file. This data is stored in credit task user-defined field 2. |
16 |
Reason Code 2 |
122 |
123 |
2 |
A/N |
This is reported in the import log file (if present). This data is stored in credit task user-defined field 3. |
17 |
Reason Code 3 |
124 |
125 |
2 |
A/N |
This is reported in the import log file (if present). This data is stored in credit task user-defined field 4. |
18 |
Reason Code 4 |
126 |
127 |
2 |
A/N |
This is reported in the import log file (if present). This data is stored in credit task user-defined field 5. |
19 |
Reason Code 5 |
128 |
129 |
2 |
A/N |
This is reported in the import log file (if present). This data is stored in credit task user-defined field 6. |
20 |
Order Receipt Date |
130 |
135 |
6 |
N |
This is the order receipt date in MMDDYY format. |
21 |
Start Ship Date |
136 |
141 |
6 |
N |
This is the start ship date in MMDDYY format. |
22 |
Completion Ship Date |
142 |
147 |
6 |
N |
This is the completion ship date in MMDDYY format. |
23 |
Terms Days |
148 |
150 |
3 |
N |
This is the number of days from the invoice date to the due date. |
24 |
Credit Line Amount |
151 |
159 |
9 |
N |
|
25 |
Credit Line Type |
160 |
160 |
1 |
N |
|
26 |
Credit Approver Number |
161 |
163 |
3 |
N |
This is the credit officer making the decision. |
27 |
Future Use |
164 |
225 |
62 |
|
This is blank spaces. |
Note This record must be present for validation.
Field Number |
Field Name |
Start Position |
End Position |
Length |
DataType |
Notes |
1 |
Format Type |
1 |
2 |
2 |
A/N |
This is the following value: CF |
2 |
Group Client Number |
3 |
6 |
4 |
N |
This is the master client number. |
3 |
Client Number |
7 |
10 |
4 |
N |
This is the client number for the group of confirmations. |
4 |
Julian Date |
11 |
13 |
3 |
N |
|
5 |
Hour of Extraction |
14 |
15 |
2 |
N |
|
6 |
Record Type |
16 |
17 |
2 |
N |
This is the following value: 80 |
7 |
Filler |
18 |
24 |
7 |
N |
This is the following value: 9999999 |
8 |
Record Count |
25 |
29 |
5 |
N |
This is the number of credit confirmations. |
9 |
Total Amount |
30 |
38 |
9 |
N |
This is the total monetary amount of confirmations. |
10 |
Future Use |
39 |
225 |
187 |
|
|
The following table displays the file format for exporting TCF Inventory Finance order approval information:
Field Number |
Field Name |
Exported Values |
1 |
ChangeType |
"I" to indicate a new approval request response |
2 |
ManufactureCode |
Factor client code entered for the payment terms in Payment Terms Maintenance. |
3 |
ManufactureCustomerNumber |
Customer code for the order |
4 |
SalesOrderNumber |
This is an optional segment that is not required. |
5 |
PoNumber |
Customer purchase order number for the order |
6 |
CommitmentAmount |
Amount of the order approved |
7 |
OriginalCommitmentAmount |
Total amount of the order from the customer |
8 |
PendingCommitmentAmount |
Pending approval amount |
9 |
CommitmentDescription |
Description of the approval |
10 |
ExternalCommitmentNumber |
Order number - This is a tracking number for the approval request. |
11 |
CommitmentApprovalNumber |
Approval code stored with the order and displayed in Order Entry |
12 |
ExpirationDate |
Expiration date for the approval |
13 |
CommitmentStatus |
Status of the approval |
The following table displays the file format for importing Wells Fargo order approval information:
Field Number |
Field Name |
Exported Values |
1 |
Factor Client Code |
Factor client code entered for the payment terms in Payment Terms Maintenance. |
2 |
Customer's Account Number |
custname.cust-code |
3 |
Order Reference Number |
oe-header.order-num |
4 |
Session Number |
Not applicable |
5 |
Approval Number |
Approval code stored with the order and displayed in Order Entry |
6 |
Order Amount |
Not applicable |
7 |
Status |
One of the following:
This data is stored in credit task user-defined field 7. |
8 |
Delivery Date |
Not applicable |
9 |
Filler |
blank spaces |
10 |
Reason Code |
This is a two-digit reason code assigned by Wells Fargo. The software assigns the appropriate Apprise credit status code (or creates one if it is not already in Apprise to prevent validation errors and delays). |
11 |
Remarks |
Additional information provided by Wells Fargo. This information is stored as a note for the associated credit task. This data is stored in credit task user-defined field 8. |
12 |
Filler |
blank spaces |