| Field Name | Description | Data Type / Format | Data Input Guidance |
| AR_CODE | Customer ID (Debtor) | Alphanumeric | Unique ID of the customer (must exist in system). |
| AR_RECON_ACT | AR Reconciliation Account | Numeric | The Recon Account used for AR control (e.g., AR-Local). |
| INV_NUM | Invoice Number | Alphanumeric | The unique invoice number from the legacy system. This is critical for future cash application. |
| INV_DATE | Invoice Date | Date (e.g., DD/MM/YYYY) | The original date the invoice was issued. Used for AR aging. |
| POSTING_DATE | Posting Date | Date (e.g., DD/MM/YYYY) | The date the transaction is recorded in the new system |
| INV_CUR | Invoice Currency | CURRENCY CODE | The currency of the original invoice (e.g., USD, EUR). |
| INV_AMT | Invoice Amount | Numeric (2 decimals) | The outstanding balance in the INV_CUR. Must be a positive value for debit and negative for credit |
| EX_RATE | Exchange Rate | Numeric (4 decimals) | The rate used for conversion (e.g., 1.0500). If INV_CUR = Local Currency, enter 1.0000. |
| LOC_AMT | Local Currency Amount | Numeric (2 decimals) | The calculated balance in the company's local currency. |
| NOTES | Reference / Memo | Alphanumeric | Recommended: Use a standardized description (e.g., "OB AR Load 20251231"). |
| SUSPENSE_GL | Suspense G/L Account | Numeric | The temporary balancing account for the upload. Must be the same account for all AR items. |
| Field Name | Description | Data Type / Format | Data Input Guidance |
| AP_CODE | Vendor ID (Creditor) | Alphanumeric | Unique ID of the vendor (must exist in system). |
| AP_RECON_ACT | AP Reconciliation Account | Numeric | The Recon Account used for AP control (e.g., AP-LOCAL). |
| INV_NUM | Invoice/Bill Number | Alphanumeric | The unique invoice number from the legacy system. This is critical for future payment processing. |
| INV_DATE | Invoice Date | Date (e.g., DD/MM/YYYY) | The original date the invoice was issued by the vendor. Used for AP aging. |
| POSTING_DATE | Posting Date | Date (e.g.,DD/MM/YYYY) | The date the transaction is recorded in the new system (e.g., the day before go-live, such as 20251231). |
| INV_CUR | Invoice Currency | CURRENCY CODE | The currency of the original vendor bill (e.g., USD, JPY). |
| INV_AMT | Invoice Amount | Numeric (2 decimals) | The outstanding balance in the INV_CUR. Must be a positive value for Debit and negative for Credit |
| EX_RATE | Exchange Rate | Numeric (4 decimals) | The rate used for conversion (e.g., 1.0800). If INV_CUR = Local Currency, enter 1.0000. |
| LOC_AMT | Local Currency Amount | Numeric (2 decimals) | The calculated balance in the company's local currency. |
| NOTES | Reference / Memo | Alphanumeric | Recommended: Use a standardized description (e.g., "OB AP Load 20251231"). |
| SUSPENSE_GL | Suspense G/L Account | Numeric | The temporary balancing account for the upload. Must be the same account for all AP items. |
| Field Name | Description | Data Type / Format | Data Input Guidance |
| GL_CODE | G/L Account Number | Numeric | Unique G/L account number. Must adhere to system-required cost object rules (e.g., must have a Cost Center). |
| INV_DATE | Reference Date | Date (e.g., DD/MM/YYYY) | The date used for general reference (often the same as the POSTING_DATE). |
| POSTING_DATE | Posting Date | Date (e.g., DD/MM/YYYY) | The date the balance is recorded (e.g., 20251231). |
| DOC_CUR | Document Currency | CURRENCY CODE | The currency of the balance. For GLT, this is often the Local Currency. |
| DOC_AMT | Document Amount | Signed Numeric | The balance in the DOC_CUR. Crucial: Debit amounts must be POSITIVE. Credit amounts must be NEGATIVE. |
| EX_RATE | Exchange Rate | Numeric (4 decimals) | The rate used for conversion. If DOC_CUR = Local Currency, enter 1.0000. |
| LOC_AMT | Local Currency Amount | Signed Numeric | The balance in the company's local currency. Crucial: Debit amounts must be POSITIVE. Credit amounts must be NEGATIVE. |
| NOTES | Reference / Memo | Alphanumeric | Recommended: Use a standardized description (e.g., "OB GLT Load 20251231"). |