Factor Order Approval Import Format

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 Format

The following tables display the file format for importing CIT order approval information:

Credit Confirmations Detail Record (1 Per Order)

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:

  • r; is listed under Pending

  • AD is listed under Partially Approved

  • AX is listed under Others

  • DA or DR is listed under Declined

  • HC is listed under Hold

  • CI, CR, or CZ is listed under Cancelled

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.

Credit Confirmations Total Record (1 Per File)

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

 

 

TCF Inventory Finance

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

Wells Fargo Format

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:

  • A or B - credit approved; release the order from credit hold in Apprise

  • R, S or T - Referred; do not release the order from credit hold in Apprise

  • D - Declined;  Do not release the order from credit hold in Apprise (it must be manually processed to close or void the order as it was declined)

  • H - Held; Do not release the order from credit hold in Apprise (awaiting a further status update from Wells Fargo)

  • V - Void; Do not release the order from credit hold in Apprise (it must be manually processed to close or void the order)

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